Secondary y-axis and x-axis intersect

[idozone]

Sometimes when I am trying to graph data that requires two series to be graphed on separate y-axes I have a problem with the second y-axis refusing to be intersect by the x-axis at the y-axis "0" value. That is, sometimes the second y-axis will default to being intersected by the x-axis at some point greater than "0" on the y-axis and I can't make it change. I've been into the "format axis" interface and under the "Value axis scale" setting designated "Category (x) axis crosses at . . "0"" but it still doesn't change.

 

[Jon Peltier]

But the secondary Y axis is looking for the secondary X axis, and you probably don't have one of those. You need to equalize the ratios of min to max on both axes. Try this:

http://peltiertech.com/Excel/Charts/AlignXon2Ys.html

 

[idozone]

Thanks

This solves my problem.

You have a great site; lots of other useful information.

Thanks

idozone