Pivot Tables that updates mutliple pie charts at once

Koopa Troopa

New member
Joined
Jul 26, 2013
Messages
4
Reaction score
0
Points
0
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?

Thank you in advance

I have posted this in another forum as well but I have yet to get a reply. Its not letting me provide a link but its in the Mr. Excel forum under Excel Questions if anybody is interested.​
 
Back
Top