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

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.

"ShaneDevenshire" wrote:

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