how to align two Y-axis

[wbbane]

Excel graph with two y-axis has zeros misaligned; how do you align zeros on two y-axis, desirably placing zeros at the intersection with the x-axis ?

 

[dgmcdo]

Left click on the 1st y axis to highlight in the chart. Then right click on that axis, click on the Format Axis option, then click on the scale tab, then set you Minimum value to 0. Repeat steps for the second y axis.

 

[wbbane]

Thank you,

however, this way all the negative data disappears, i.e. I can see only the upper part of my graphs!

Is there a way to allign zeros without eliminating negative part?

 

[dgmcdo]

Just follow the same steps as above and make the minimum point for each of the y axis the same and the x axis will align.