Removing Negative Symbol from Y Axis

[Cantonalives]

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

 

[Hui]

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


Older versions will look different

 

[Cantonalives]

So simple but so useful!! Thank you so much!!!!!!