macro to keep chart dual axis format

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Gantt chart duration not showing 0
Excel does not accept text format! 0
Scatter Chart 0
Create a chart from a table in word thats dynamic 0
simple chart 0
Setting column width in a table with a macro is not working 0
create chart with column axis 10

Top