View Single Post
  #2  
Old February 15th, 2008, 03:33 AM posted to microsoft.public.excel.charting
Christopher Scott [MSFT]
external usenet poster
 
Posts: 27
Default Create separate pivot chart for each filter

There's not a way to do this from what I know. You would need to create a
separate pivot table and pivot chart for each filter/view.

If you don't need to keep your pivot chart updating with the pivot table and
just want a few "snapshots", you could filter the pivot table the way you
want, then copy and paste the chart to a new workbook to "unlink" the chart
from the pivot table.
--
Thanks,
Christopher

This posting is provided "AS IS" with no warranties, and confers no rights.


"RTMI" wrote:

In Excel, Pivot Charts - When filtering in a pivot table, how do you create a
separate chart for each filtered set of data? As it is now, the chart updates
when you change the filter criteria.