Avatar of pdvsa
pdvsa
Flag for United States of America asked on

Show the 0 on the Vertical Axis

Experts, how do I show the 0 in 2016?

Graph
Microsoft Excel

Avatar of undefined
Last Comment
pdvsa

8/22/2022 - Mon
Subodh Tiwari (Neeraj)

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.
John

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

Excel-2016-Axis-Options
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?

graphoptionsX
Your help has saved me hundreds of hours of internet surfing.
fblack61
Subodh Tiwari (Neeraj)

I was talking about to change -200.0 to 0.
John

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.
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?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
John

Negative numbers should work if Auto is disabled everywhere. Did you try a different worksheet?
Subodh Tiwari (Neeraj)

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.
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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Rob Henson

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.
pdvsa

ASKER
Hi Rob, what would be the formatting to show 0?
ASKER CERTIFIED SOLUTION
Rob Henson

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
pdvsa

ASKER
thank you!
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.