Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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)? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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)? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping date from changing | Excel Discussion (Misc queries) | |||
How do I drag a formula keeping cells the same but changing sheets | Excel Worksheet Functions | |||
Changing many charts in one worksheet | Charts and Charting in Excel | |||
How do I fill down keeping one cell calculation from changing in . | Excel Discussion (Misc queries) | |||
Keeping a transfered value the same after changing the original va | Excel Worksheet Functions |