Preventing Pivot Chart autoformatting?

[SimonPerry]

Hi all, is it possible to prevent a pivotchart autoformatting when you refresh the data or change the selection?

I have formatted the chart to my requirements however when I refresh the data it defaults to a different format meaning I have to update it each time...

Any advice/help much appreciated.

Thanks

 

[Richard Schollar]

Hi Simon

Have you unchecked the autoformat option for the underlying pivot table (in the Pivot Table Options dialog)?

Richard

 

[SimonPerry]

That simple! Thanks so much.

Cheers
Simon