• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Removing Negative Symbol from Y Axis

Hi all,
Trying to sort a chart where 2 sets of data are displayed with one set above zero and the other below. So a bar with above and below the line. The problem is that I would like both sets to display positive. Easy to remove the '-' prefix from the labels, but not from the axis.

So in effect I want £2,000,000 at the top and the same on the axis at the bottom without the zero. I have had to ensure the numbers were negative to get them below the line, but then dealt with that issue with a a custom format code.


Any thoughts on this much appreciated.


Thanks,


-CL
 
Select the Chart
Right click the Y-Axis and select Format Axis
Select the Number
Set the format code to #;#;0
Untick Linked to Source

This is Excel 2016
upload_2017-1-16_17-53-13.png

Older versions will look different
 
Back
Top