multiple charts from a single pivot table

  • Thread starter Thread starter Yossi evenzur
  • Start date Start date
No, but you can copy the pivot table to create another which uses the
same pivot cache, so they will refresh in synch with each other, and
share any grouping and calculated fields.
Filtering won't be synchronised though, so you may want to either
automate that with macros or use formaulas to check for basic
consistency eg grand grand totals are the same.

Adam
 
Back
Top