How to hide “0” in chart axis [quick tip]

Have you ever wondered how you can hide that 0 (zero) at axis bottom? Like this…,

Here is a handy little trick to do just that:

1. Select the axis and press CTRL+1 (or right click and select “Format axis”)
2. Go to “Number” tab. Select “Custom”
3. Specify the custom formatting code as #,##0;-#,##0;;
4. Press “Add” if you are using Excel 2007, otherwise press just OK.
5. That is all.

The trick uses custom number formatting codes in excel to show blanks whenever axis value is Zero, thus hiding the zeros at the bottom of axis. [even more juicy awesome kickass stuff on custom cell formatting]

Learn more quick excel tips and charting tricks.

PS: I am in Stockholm this week, to meet some customers. Internet access is limited plus I am too busy exploring this beautiful city. So we will have only quick tips this week.