Link to home
Start Free TrialLog in
Avatar of pdvsa
pdvsaFlag for United States of America

asked on

Show the 0 on the Vertical Axis

Experts, how do I show the 0 in 2016?

User generated image
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Double click the Vertical Axis or Right click it and choose Format Axis and in there under the Axis Options, change the Minimum Bounds to 0.
Make sure you are using the XLXS format and not Compatibility Mode.  Then review this Microsoft Article and the screenshot below.

https://support.office.com/en-us/article/Change-the-scale-of-the-vertical-value-axis-in-a-chart-05973661-e56a-4486-a9f3-f9ce41df0021

User generated image
Avatar of pdvsa

ASKER

Not sure why it is not displaying a 0.  I double clicked the vertical and I see the options and I change the minimum to 0 but it doesnt save it and keeps changing it back to 10.  

any advice?

User generated image
I was talking about to change -200.0 to 0.
Also change Auto to Fixed in all the settings in your screen above.  And try a new worksheet to see if it is a worksheet issue.
Avatar of pdvsa

ASKER

<I was talking about to change -200.0 to 0.
OK but I do have negative numbers in another graph (different from the one posted).
I did make the change and it does say 0 but if I do have negatives then it no longer is correct.  

Knowing I have negatives, does this change something?
Negative numbers should work if Auto is disabled everywhere. Did you try a different worksheet?
If you have negative values, why would you like to show 0 on the vertical axis. If is it set to auto, it will adjust the vertical axis as per the values.
Avatar of pdvsa

ASKER

I want to see the 0 for visual purposes.  I havent tried a new sheet but will in the am.  Not at computer now.  I am on euro time.  Have a good day... Thanks for the help.
Is it just the number formatting? Maybe the formatting that you have chosen does not show zero value and the chart axis has the "Linked to Source" option ticked.
Avatar of pdvsa

ASKER

Hi Rob, what would be the formatting to show 0?
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pdvsa

ASKER

thank you!