How to get vertical axis to show a tick mark

I have a lot of posts today How can I get the vertical axis to show a "0" instead of just a "-" mark?

Thanks,

Alex

Hi Alex,

I would imagine that you have a number format that shows a zero as a "-"

Check your number format on your axis.

You can change to a custom format like this:

#,##0;-#,##0;0;

instead of this:

#,##0;-#,##0;-;

Here is a blog post that I did that shows you how to remove the zero, so you can see it in action and use it to see how to add it back

Remove The Zero Point or Make a Hole in an Excel Radar Chart

Let me know if this helps.

Steve=True

Thanks. You were right.

Awesome,

Glad I could help.

Steve=True