macro to keep chart dual axis format

  • Thread starter Thread starter kay
  • Start date Start date
K

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!
 
Back
Top