| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
PivotChart disassociation 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make pivotchart formatting stick after pivottable refresh. | Charts and Charting in Excel | |||
| 2 y-axes PivotChart | Charts and Charting in Excel | |||
| PivotChart | Excel Discussion (Misc queries) | |||
| Sort PivotChart | Excel Discussion (Misc queries) | |||
| pivotchart | Charts and Charting in Excel | |||
Hybrid Mode
