View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
AdamV[_2_] AdamV[_2_] is offline
external usenet poster
 
Posts: 38
Default 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?