Keeping Charts from Changing

  • Thread starter Thread starter Redhawkphi
  • Start date Start date
R

Redhawkphi

Is there anyway to keep Charts created from Pivot tables from Changing once
you're done compiling the needed data from the table (other than cut & copy
over to a PP or Word doc)?
 
I'm sure there is more to this than meets the eye - If you don't want the
pivot chart to change don't change the source data.

Another solution would be to copy the pivot table, build the pivot chart,
then select the pivot table and choose Copy, then Edit, Paste Special,
Values. You will no longer have a pivot chart.
 
I guess what I'm asking for is how to keep the original graph, and then
change the variables in the table to make another graph without loosing the
original graph.
 
Back
Top