How to hide zero data labels in chart in Excel?
Sometimes, you may add data labels in chart for making the data value more clearly and directly in Excel. But in some cases, there are zero data labels in the chart, and you may want to hide these zero data labels. Here I will tell you a quick way to hide the zero data labels in Excel at once.
If you want to hide zero data labels in chart, please do as follow:
1. Right click at one of the data labels, and select Format Data Labels from the context menu. See screenshot:
2. In the Format Data Labels dialog, Click Number in left pane, then select Custom from the Category list box, and type #"" into the Format Code text box, and click Add button to add it to Type list box. See screenshot:
3. Click Close button to close the dialog. Then you can see all zero data labels are hidden.
Tip: If you want to show the zero data labels, please go back to Format Data Labels dialog, and click Number > Custom, and select #,##0;-#,##0 in the Type list box.
Note: In Excel 2013, you can right click the any data label and select Format Data Labels to open the Format Data Labels pane; then click Number to expand its option; next click the Category box and select the Custom from the drop down list, and type #"" into the Format Code text box, and click the Add button.
Best Office Productivity Tools
Supports Office/Excel 2007-2021 and 365 | Available in 44 Languages | Easy to Uninstall Completely
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need Is Just A Click Away...
Supercharge Your Excel Skills: Experience Efficiency Like Never Before with Kutools for Excel (Full-Featured 30-Day Free Trial)
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! (Full-Featured 30-Day Free Trial)