macro to keep chart dual axis format

[kay]

Hi!

I have created pivot table and pivot chart.
in pivot chart i have three series - Actual, Target and Variance.
i have put Variance series as dual axis - (format - selected data series -
secondary axis).

but when i have new data and when i refresh pivot table, this format for
variance gets change and i have to set up again this as secondary axis format.
so i need help to create macro to keep this settings.

Thanks!

 

[galimi]

Kay,

Feel free to contact me via my website & I will assist you.