Zero value not showing on Excel chart vertical axis - how to display ?

I have created an Excel column chart with positive and negative values on axes, but the zero value is not showing on vertical axis. Other numbers on axis are displayed correctly. How can I make also the zero value appear ?

Hi,

You can modify the showing of number values on axes by changing of number format. For example, when values on vertical axis look like this:




Click on vertical axis with right mouse button to display the menu and choose Format Axis:



Then in Number section, change Category, Type and enter Format Code according to your needs:



To display the zero value on vertical axis, the format code has to be changed in this case from # ### to # ##0. Save the changes by clicking on Add.



After the change of number format, the chart should look like: