• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 45
  • Last Modified:

MS Excel chart

have an Excel Spreadsheet, to which I used a Pivot Table to come up with the Data I have attached in the screenshot below.
As you can see I have one column for Items and have other columns representing the Month , I displayed just 6 months for the sake of brievity (from January to June or 1 to 6 as displayed on the column headers)

on each month, an item has a different cost.
sd
I would like to filter on Items. for instance when I filter just on ItemA , it will display the row for ItemA and on the right it will display a graph with the Fluctuation of the Cost from January to June.

How can this be accomplished without inserting the graph manually for each  Row that I filter on ?

Thank you


sp2.JPG
0
jskfan
Asked:
jskfan
  • 3
  • 2
1 Solution
 
Ryan ChongCommented:
you probably need to calculate the Fluctuation of the Cost first before you can show it in the graph
0
 
jskfanAuthor Commented:
you probably need to calculate the Fluctuation of the Cost first before you can show it in the graph
how can this be done ?

Thank you
0
 
Ryan ChongCommented:
check out this article on how to add the second chart into an existing chart.

How to create combination charts and add secondary axis for it in Excel?
https://www.extendoffice.com/documents/excel/1267-excel-create-combination-chart.html

to come out something like this:

SnapShot.png29075577.xlsx
0
 
Ryan ChongCommented:
do you need further assistance here?
0
 
jskfanAuthor Commented:
Will take a look at it later.
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now