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.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
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.