Chart Axis to display 0.50 m

[mikehk]

I have used custom axis to display unit in "m",
how do I change to range/display axis to show

0.5 m
1 m
1.5 m
2 m
2.5 m
3 m
3.5 m

Thank you

[MrShorty]

Easiest, though not exactly what you ask for, would be to use a number format like "0.# \m". This will display
0.5 m
1. m
1.5 m
2. m
etc. with the extra decimal point character on the whole number divisions. If you can tolerate those decimal points, this will be easiest.

If you cannot tolerate them, then you will probably want to create a "dummy" series and use text from cells as data labels on the dummy series to make your own axis. The technique is basically the same one described here (https://peltiertech.com/reciprocal-chart-axis-scale/ ) for a reciprocal (temperature) axis.

[mikehk]

I don't mind the decimal points, unfortunately
"0.# \m" doesn't work or may be I am doing something wrong

[mikehk]

#,, "m"

I am using the above code now

[MrShorty]

Can you post an example of it not working? It worked just fine for me.