pivot table charts

[Zrx]

Hello,

DO you need a pivot table for every pivot chart?

Can you extract many charts from one pivot table report in otherwords?

Thanks,
Ralph

[Andy Pope]

A pivot chart will reflect the contents of the pivot table. So whilst you can have multiple charts they will all show the same information. Changing a chart or the table will affect all other charts/tables linked to it.

As long as the pivot tables all use the same pivot cache the impact should not be too create on the workbook.