align two y-axis


R

rickree

I have a scatter line graph with two lines. The two lines are
associated to different y-axis (primary and secondary). Is there a
way to align the scale of the primary and secondary y-axis so that the
point y=0 is the same major axis for both the primary and secondary y-
axis?

Other than this macro http://peltiertech.com/Excel/Charts/AlignXon2Ys.html
Which I can't seem to get running becuase I am an extreme dumdum when
it comes to macros...
 
Ad

Advertisements

S

Shane Devenshire

Hi,

Double-click the primary Y axis and choose the Scale tab and set the
Minimumn, Maximum and anything else you want. Repeat the process for the
seconday Y axis.
 
Ad

Advertisements

M

Michael.Tarnowski

I have a scatter line graph with two lines. The two lines are
associated to different y-axis (primary and secondary). Is there a
way to align the scale of the primary and secondary y-axis so that the
point y=0 is the same major axis for both the primary and secondary y-
axis?

Other than this macrohttp://peltiertech.com/Excel/Charts/AlignXon2Ys.html
Which I can't seem to get running becuase I am an extreme dumdum when
it comes to macros...

Hi rickree,

here is an elaborated approach to set automatically Min and Max Scale
for Y-Axis
http://www.cellmatrix.net/index.php/comments/automatically_set_min_and_max_scale_for_y_axis/

More on additional y-axis you will find at
http://www.google.com/cse?cx=partne...:3rfphr06tf2&ie=ISO-8859-1&q=Y-Axis&sa=Search

Hope that helps, have fun
Cheers Michael
 

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

Top