• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 103
  • Last Modified:

Show the 0 on the Vertical Axis

Experts, how do I show the 0 in 2016?

Graph
0
pdvsa
Asked:
pdvsa
  • 5
  • 3
  • 3
  • +1
1 Solution
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
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.
0
 
JohnBusiness Consultant (Owner)Commented:
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
0
 
pdvsaProject financeAuthor Commented:
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
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
I was talking about to change -200.0 to 0.
0
 
JohnBusiness Consultant (Owner)Commented:
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.
0
 
pdvsaProject financeAuthor Commented:
<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?
0
 
JohnBusiness Consultant (Owner)Commented:
Negative numbers should work if Auto is disabled everywhere. Did you try a different worksheet?
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
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.
0
 
pdvsaProject financeAuthor Commented:
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.
0
 
Rob HensonFinance AnalystCommented:
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.
0
 
pdvsaProject financeAuthor Commented:
Hi Rob, what would be the formatting to show 0?
0
 
Rob HensonFinance AnalystCommented:
Standard currency format will show the 0, Accounting format shows 0 as "£ - ".

Thanks
Rob
0
 
pdvsaProject financeAuthor Commented:
thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
  • 3
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now