Auto Adjust Scale

  • Thread starter Thread starter jk9533
  • Start date Start date
Anybody know how to auto adjust secondary axis scale to be the same as the
primary?
Click to expand...

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