align two y-axis

[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...

 

[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.

 

[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