I am trying to filter pivot chart by strategy and it does not update the combined Sum of Cumulative chart when I uncheck / filter strategy.
I have attached the example.
Any help would be greatly appreciated.
thanks
I am trying to filter pivot chart by strategy and it does not update the combined Sum of Cumulative chart when I uncheck / filter strategy.
I have attached the example.
Any help would be greatly appreciated.
thanks
Hi,
The Pivot Table and the Chart refreshed when I converted the file into Excel 2010.
Please check the attached file and see if it works now. I have converted the file back to Excel 97-2003 in case you do not have Excel 2010 in your system.
Regards,
Chandra
Please click on ‘ * Add Reputation’ button on the left side bottom of my post if I was helpful in resolving the issue.
Hi,
Thanks for that. I have now copied my source data into your saved version and all is working correctly. Not sure why it does not in my original Excel 2013 saved version.
cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks