Pivot Tables

Hi Julia,

Thank you for your question and welcome to the forum.

Unfortunately there is no way of achieving that in the front end of Excel.

However you can write VBA code in the Visual Basic Editor Window to create the Pivot Table and Chart and all the formatting.

So each time you run the macro it creates the Pivot table and chart again based on the code so the formatting is all the same.

Our Excel VBA 2 day Intro/Intermdiate course has Pivot Tables written into it.

I hope this answers your question.

Regards

Simon