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:
- Select the axis and press CTRL+1 (or right click and select “Format axis”)
- Go to “Number” tab. Select “Custom”
- Specify the custom formatting code as
- Press “Add” if you are using Excel 2007, otherwise press just OK.
- 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]
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.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« 2010 Calendar – Excel Template [Downloads]||How to Print Excel Comments »|