Chart & Visualization Issues

How to Hide Zero-Value Series Name Labels in Excel Charts

Rana GarciaRana Garcia Nov 11, 2026 869 views

Question details

The user wants to prevent chart data labels that contain series names from displaying when the corresponding data value is zero.

How to Hide Zero-Value Series Name Labels in Excel Charts
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.
Before you start

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.

Solution 1Recommended

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.

1
Create the helper column formula

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.

2
Apply the formula to all rows

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.

3
Add data labels to your chart

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'.

4
Format labels using the helper column

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.

Use a Helper Column to Hide Zero-Value Labels
Dynamic Updates: Your chart will now only display series names for data points with non-zero values. If your source data changes and a zero becomes a positive number, the label will automatically appear.
Manage Charts Easily in WPS Office

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. 1. Open your data: Launch WPS Spreadsheet and open your existing workbook containing the chart data.
  2. 2. Insert a chart: Highlight your data, navigate to the Insert tab, and select your preferred Chart type.
  3. 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.
100% compatible with Microsoft Excel (.xlsx) formatsIntuitive chart elements and data label formattingLightweight application with fast processing for large datasetsFree to use with a familiar tabbed interface
microsoft office alternative - wps office

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.