Linking Multiple pivotcharts
 

help please........

my issue is:multiple charts in one worksheet aren't linked together.
can they even be???

Like if i wish to see chart1 and chart2 for car_id 1 it can be done .But
i'll have to munually set the filter to car_id 1 for both charts.
One click wont be usefull.
Both the manual filter (for the two charts )will have to be changed.
is there any possible way that all the 4 charts in one worksheet change on
"one click" for each car id........??

--
Regards,
Mahwish Anwar Syed