Pivot Chart - Disassocoation from PivotTable

G

Guest

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
 
G

Guest

Sorry - wrong section Please delete - have posted to the right one...
Charting...

regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivottable refresh problem 1
Auto Refresh Pivot Table after Source Data is Refreshed 0
Macro to refresh pivot chart - URGENT PLEASE !!!! T_T 3
PivotTable and PivotChart clear failure 1
PivotTable Field Selection 1
Creating a PivotTable Report from an Another PivotTable Report 1
PivotTable and PivotCharts Problem - Manipulating in VBA 1
Chart from PivTbl, WITHOUT PivChart? 1

Top