How to hide zero in chart axis in Excel?
Generally, when creating a chart, the axis is beginning with zero as shown as below. But sometimes, you want to hide the zero in the chart axis for good look. Here this tutorial will tell you the method on hiding zero in chart axis in Excel.
Hide zero in chart axis
Hiding zero in chart axis is not complex in Excel, please just do as follow:
1. Right click at the axis you want to hide zero, and select Format Axis from the context menu.
2. In Format Axis dialog, click Number in left pane, and select Custom from Category list box, then type #"" in to Format Code text box, then click Add to add this code into Type list box. See screenshot:
3. Click Close to exist the dialog. Now the zero in chart axis is hidden.
Tip: For showing zero in chart axis, go back to Format Axis dialog, and click Number > Custom. Select #,##0;-#,##0 in the Type list box.
Note: In Excel 2013, you need to click Number tab to expand its option, and select Custom from the Category drop down list, then type #"" in the Format Code box, and click the Add button.
Relative Articles:
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
