| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Chart - Disassocoation from PivotTable
Hi all,
I have a PivotTable - wonderful - took a long time to figure this out but wow... Anyway I also have a PivotChart that works wonderfully thank you MS...but I want to take a copy of the chart after Pivoting the data and save it to a second WorkSheet and Dis-associate it from the chart so it does not update when I go and refresh the Pivot table... required workflow is as follows: Pivottable refresh - Select chart - save to sheet2-A1 Change citeria Pivottable refresh - Select chart - save to sheet2-A20 Change citeria Pivottable refresh - Select chart - save to sheet2-A30 Print Sheet2 therefore getting more than one chart on a sheet of paper and reducing my carbon emissions... I hope this makes sense... This ability to "snapshot" a pivottable graph would be so wonderful an make life so easy. Many thanks in advance regards Sean |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot Chart - Disassocoation from PivotTable
Sorry - wrong section Please delete - have posted to the right one...
Charting... regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where are the pivottable chart buttons? | Charts and Charting in Excel | |||
| PivotTable and Chart | Excel Discussion (Misc queries) | |||
| XY-chart with pivottable? | Excel Discussion (Misc queries) | |||
| pivottable + chart | Excel Programming | |||
| Update Chart in Pivottable | Excel Programming | |||
Linear Mode
