Hi,
I'm not a frequent user of Pivot table & charts, Appreciate if someone can please help with the Pivot charts.
I'm trying to plot multiple graph with Single pivot table using filters but when the filter is removed all the charts get updated with the filter I select. Is there a way to freeze the filter for one chart and when I plot another Graph it should update the select the second filter.
Say for example In the attached sheet, I have "Name" in one column and "instance" in another column and "Values" to plot the graph. I'm looking to plot separate charts for each filter on pivot table of "Name" but when I change the filter its changes the charts, Is there a way to create separate charts for each filter I select.
Also whenever the raw data is changed or any addition to it, the graphs should get updated with pivot refresh.
Please help! In this case a VB code may be fine.
Thanks
Raj !
Bookmarks