How to Hide Zero-Value Series Name Labels in Excel Charts
Question details
The user wants to prevent chart data labels that contain series names from displaying when the corresponding data value is zero.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Formatting chart data labels to improve the presentation of a graph by hiding empty or zero data points.
- Observed behavior
- By default, Excel displays the series name for all data points on a chart, even if the value is zero, which can clutter the visualization.
Ensure your chart data is organized into clear columns for series names and values, and prepare to insert a blank column next to your data to act as a helper column.
Use a Helper Column to Hide Zero-Value Labels
Create a dynamic helper column that outputs the series name only when the value is greater than zero, and link this column to your chart labels.
Excel does not have a built-in toggle to hide series names for zero values automatically. However, you can easily bypass this limitation using an IF formula in a helper column combined with the 'Value From Cells' data label feature.
Assuming column A contains your series names and column B contains your values, click on cell C2. Enter the formula =IF(B2=0,"",A2). This tells the spreadsheet to leave the cell blank if the value is zero, or display the series name if it is not.
Click on cell C2 again, grab the fill handle (the small square at the bottom right of the cell), and drag it down to apply the formula to the rest of your data rows.
Click on your existing chart to select it. Click the Chart Elements button (the '+' icon next to the chart) and check the box for 'Data Labels'.
Right-click the newly added data labels on your chart and select 'Format Data Labels'. In the Format Data Labels pane, check the box for 'Value From Cells'. A prompt will appear; highlight the range of your new helper column (e.g., C2:C10) and click OK. Finally, uncheck the default 'Series Name' or 'Value' options so only your helper column labels appear.

Create and Format Professional Charts in WPS Spreadsheet
WPS Spreadsheet offers powerful, intuitive charting tools that are fully compatible with Excel formats. Easily manage data labels, customize visualizations, and handle complex datasets seamlessly.
- 1. Open your data: Launch WPS Spreadsheet and open your existing workbook containing the chart data.
- 2. Insert a chart: Highlight your data, navigate to the Insert tab, and select your preferred Chart type.
- 3. Customize labels: Use the Chart Elements menu to add data labels, then right-click them to choose 'Select Range' and link them to your helper column.

Frequently Asked Questions
Can I hide zero values without using a helper column?
You can hide the actual '0' numeric value using custom number formatting (such as 0;-0;;@), but this standard trick does not hide the associated Series Name or Category Name labels. To hide the names tied to zero values, the helper column method is required.
What versions of Excel support 'Value From Cells' for data labels?
The 'Value From Cells' option for chart data labels was introduced in Excel 2013. It is available in all newer versions, including Microsoft 365, as well as in WPS Spreadsheet.
Why does my chart still show a comma or separator when the label is hidden?
If you leave the default 'Series Name', 'Category Name', or 'Value' boxes checked alongside 'Value From Cells', the separator (like a comma or newline) might still render even if the text is blank. Ensure you uncheck the default label options and only keep 'Value From Cells' checked in the Label Options menu.




