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 ?
give a positive ratinggive a negative rating
12 Apr 2021 at 05:31 PM

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 be 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

give a positive ratinggive a negative rating
18 Apr 2021 at 03:52 PM
Share on FacebookShare on TwitterShare on LinkedInSend email
2024 AnswerTabsTermsContact us