Auto Adjust Scale

[jk9533]

Anybody know how to auto adjust secondary axis scale to be the same as the
primary?

 

[Del Cotter]

Anybody know how to auto adjust secondary axis scale to be the same as the
primary?

For each series on the primary axis, create a series on the secondary
axis which duplicates the data, and format it so it's invisible. And
vice versa for each series on the secondary axis.

Now whatever data prompts the primary axis to change will also make the
secondary axis change in exactly the same way.

 

[Jon Peltier]

It's probably easier to have a single series that has the min and max from
among all the data, and plot this as a hidden series on both axes.

- Jon