Axis Formatting

[SWZ]

I want the top of this burndown line (and the 0 data point) to intersect with the y-axis.

I can't seem to find the Format Axis setting that allows me to achieve that.

Thanks in advance for the help!

 

[Kaper]

This line is now drawn as Line Graph. If you change type to Scatterplot (XY) but drawn with line and no markers, you can get crossing vertical axis at 0. This line (both lines) shall be drwan on secondary axis, and you will have to play a bit with axes visibility. First making secondary X visible. The making sure data series for lines include X values. "synchronizing" primary and secondary axes (probably you don't need secondary vertical, which will be swithed on by excel by default).

 

[Peter_SSs]

Welcome to the MrExcel board!

Before

Don't you just need to right-click on the horizontal axis values and choose 'Format Axis ..' then choose this option?

After

 

[Kaper]

Well it will also move the columns on the column part ... as required (if I understand well the arrow on the screenshor, I've not noticed before).