multiple charts from a single pivot table
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
On 22/02/2010 13:00, Yossi evenzur wrote:
Hi
can i create several pivot charts from a single pivot table?
|