View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default multiple pivotcharts from 1 pivot table?

Each chart will change when the pivot table on which it's based changes.
Make a copy of the pivot table for each chart that you need, and base
each chart on a copy.

JJeter wrote:
I have a pivot table that I need to generate several charts from and I need
for each chart not to change when I change the data in the table. Is there a
way to do this? All of these charts will be in the same workbook.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html