Greetings,
I have four pie charts created with four pivot tables. Is there a way to so that when I filter data in one pivot table all of the pie charts become updated base on that criteria rather than just updating the one pie chart affiliated with the pivot table? Im guessing VBA is the only way to go with this since its for excel 2007. Is anyone able to provide a code that could execute this function? I have posted this in another forum as well but I have yet to get a reply. Heres the link:
http://www.excelguru.ca/forums/showt...charts-at-once
Thank you in advance
I have also attached a sample workbook for those looking for a visual idea of what I am talking about.
DummyWorkbook.xlsx
Bookmarks