PivotChart disassociation from PivotTable

S

Sean McPoland

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
 

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

Top