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 ?
posted on 12.04.2021 at 17:31
0pnshow more

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:

excel zero value not showing on vertical axis

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

excel chart format vertical axis values

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

excel chart format axis number type

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

excel chart vertical axis change number format

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

excel zero value display on vertical axis

posted on 18.04.2021 at 15:52
0pnshow more
share on facebookshare on twitter
2021 AnswerTabsTermsContact us