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.
--
Cheers,
Shane Devenshire


"Redhawkphi" wrote:

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)?