Create separate pivot chart for each filter?

[oo0tommyk0oo]

Hi, I have just started using Pivot tables and charts and have found them to be very useful. I have a pivot chart (simple pie chart) created from a data table with filters on it. This is great for flicking between each filter. However i was wondering if there was a way to create a pie chart for each filter next to each other for easy comparison?

The only way i can do it is to copy and paste as picture, but then these charts no longer update or to create a seperate pivot table for each.. . If i simply copy and paste, when i change the filter on the table both charts change

Thanks for any help

Tommy

[DonkeyOte]

You will (I think) require separate Pivots for each Chart, however, it sounds as though the Pivots can all share the same cache.

[oo0tommyk0oo]

Thanks for the reply

I think that is what i have now. They all feed off table1, but each chart has its own mini pivot table on the side. So if i want to change something i have to do it on all. This works, i was just wondering if there was a built in function to run off one pivot.

[DonkeyOte]

There are ways to update multiple pivots simultaneously : VBA pre XL2007; Slicers XL2010

To demo we'd need more info. in terms of what is being altered & where ... regards changes that should be reflected in all Pivots.

[oo0tommyk0oo]

It's not worth a VBA code, VBA scares the other staff here. I only need to change one filter on 6 charts. Will just create a seperate sheet for each filter change.

Thanks for the help