- Click on the y-axis or data labels
- Right-click and select Format Axis... or Format Data Labels...
- In the right-hand pane, click on the "Label options". It looks like a bar graph
Click >Number to expose more detail
- In the format Code textbox
- Remove all contents inside of that textbox
- For less detail, enter: 0,, "m";-0,, "m";"-"
- For moderate detail, enter: 0.0,, "m";-0.0,, "m";"-"
- For a lot of detail, enter: 0.00,, "m";-0.00,, "m";"-"
Here's how it looks