Keeping Charts from Changing
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)? |
Keeping Charts from Changing
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)? |
Keeping Charts from Changing
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)? |
All times are GMT +1. The time now is 09:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com