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 ?
12 Apr 2021 at 05:31 PM
0pnshow more
NicoleNicole
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:


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

18 Apr 2021 at 03:52 PM
0pnshow more
TimTim
Share on FacebookShare on TwitterShare on LinkedInSend email
Follow us on Facebook & Twitter
2021 AnswerTabsTermsContact us