align zero markers on combination chart?
 

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.

align zero markers on combination chart?
 

Hi,

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

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jana J" <Jana wrote in message
...
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.

align zero markers on combination chart?
 

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

http://peltiertech.com/Excel/Charts/AlignXon2Ys.html
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jana J" wrote:

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.