Protecting Pivot Chart format when refreshing PT Data

[sigmeister]

Hi

Can anyone please advise how I can protect my Pivot Chart formatting and Chart Type when refreshing data on a Pivot Table?
I have set up a line/column on 2 axis as a default, but it keeps going back to 2 bar graph and all my scaling etc has been lost.

 

[lenze]

Try recording a macro with the PT refresh and formatting it. run the macro to refresh

lenze

 

[sigmeister]

Thanks Lenze, that's probably the best way. I thought there may have been some settings I missed, but a macro seems the most sensible.

Cheers