Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

pivot chart

ResolvedVersion 2016

Donna has attended:
Excel Pivot Tables course

Pivot Chart

Once I've created a Pivot Chart, changed formatting, labels etc. I would like to copy and reuse as a template and change the source data. But I'm not able to change source data. Any advice?

Thank you

RE: Pivot Chart

Hi Donna,

Thank you for the forum question.

When you create a PivotTable Excel create something called Pivot Cache and you will need to replace the Pivot Cache with the new data.

A much better solution is to right click on the chart and save it as a template. Next time you want to have a Pivot Chart just click Pivot Chart and to the left of the dialog box you can find a folder named Templates. Select the template you want to use and you will get a chart based on the template.



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.17 secs.