Add units/currency on top of the y-axis in line chart

[meomeoxinh]

Hello,
Does anyone know how to add the unit (such as $ or pounds) on top of the y-axis in the line chart? I could only find the way to add the currency to all numbers on the y-axis but I want it to show $m on top of the y-axis only.
Thanks in advance.

 

[awoohaw]

I tried link axis numbers to source and that picked up the first format and perpetuated it.
The only thing I can think of is to put the format of the number in your axis label:

 

[meomeoxinh]

I tried link axis numbers to source and that picked up the first format and perpetuated it.
The only thing I can think of is to put the format of the number in your axis label:
View attachment 90951

Is there anyway I can move the labels $m to above 25?

 

[awoohaw]

Is there anyway I can move the labels $m to above 25?

what label are you referring to? The axis label is movable, but it is oriented in the wrong direction.
You could put a text box (transparent interior) on the chart but that would probably not 'move and resize' with the chart.

 

[meomeoxinh]

what label are you referring to? The axis label is movable, but it is oriented in the wrong direction.
You could put a text box (transparent interior) on the chart but that would probably not 'move and resize' with the chart.

Thank you very much.

 

[awoohaw]

Thank you very much.

My pleasure. Although, I'm not sure you got the answer you wanted.

and welcome to the Mr. Excel Forum.

Best Wishes!