If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|