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