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
 

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

Horizontal axis to the bottom 1
vertical scale on both ends of bar chart 1
v.2003 - Scale problem in 2 X-Axis Chart 1
scales of 1st and 2nd series 1
Positioning of y-axis scale 3
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1
Vertical line on column chart with monthly data 3
Time Scales on Horizontal Axis - Excel Charts 1

Back
Top