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 ?|
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 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:
|Qualcomm Snapdragon processors - list of mobile phones brands|
|Remove or hide bottom navigation bar with buttons on Android|
|How to restore permanently disabled Instagram account ?|
|Free email accounts with large or unlimited storage capacity|
|List of the best Free web hosting sites with subdomain|
|HTML list <ul> not showing items <li> on a new line|
|How to count blank cells with no values in Excel ?|