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.
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 ?