align zero markers on combination chart?

[Jana J]

I am using a bar-line combination chart and wondering if I can align the zero
markers on both the left and right y axes. This would result in negative
values on my secondary axis to appear below the zero line (of both axes)
which is what I want.

 

[Andy Pope]

Hi,

Have a look at Jon's info on this
http://peltiertech.com/Excel/Charts/AlignXon2Ys.html

Cheers
Andy

 

[Luke M]

Check out Jon Peltier's article about this very thing:

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