Automatic pivot chart formatting

[JoeyGirl]

Hi all,

I've been dealing with the common problem of pivot graphs losing their formatting whenever the parameters in the pivot are changed. To combat this I created a button in the worksheet linked to a macro that will format the graph, but I was wondering if I could take this a step further and have the macro triggered whenever the pivot table changes?

I've been searching the internet and I think maybe 'OnChange' is what I need to use but I can't find anything that shows how to use it in this context - all the information is on using it when a value in a specific cell changes.

Thanks in advance!

[Andy Pope]

If the chart is on the worksheet then maybe you can use

Please Login or Register  to view this content.

If it's a chart sheet then

Please Login or Register  to view this content.

[JoeyGirl]

Thanks for your response - your solution works a treat! :D