Sorry, I thought you wanted each chart's layout to remain the same, if
the pivot table's layout changed.
If you want a static chart, copy the chart, and paste it into a new
workbook. Then, cut it from the new workbook, and paste it back into the
original workbook.
JJeter wrote:
Debra,
I could have sworn that I saw somewhere that a PivotChart could be copied
and made static so that it wouldn't change when the original Pivot Table
changed.
Thank you for your response.
Jim Jeter
"Debra Dalgleish" wrote:
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
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html