Excel Pie Chart: Remove Zero-Value Labels

To remove a zero-value label from an Excel pie chart, click the chart, click the label once to select the labels, click the zero label again to select only that label, and press Delete. If the chart data changes regularly, use a helper column that returns a blank label for zero values, then set the chart to use that column for its labels.

Why a zero-value label can appear

A pie chart represents each category as a share of a whole. A category whose value is zero has no slice with a visible area, but Excel can still include that category in the chart’s data labels. The result may be a label such as “Travel 0” floating beside the pie, even though there is no travel slice to point to. This is a label-display issue, not evidence that Excel has drawn a slice with a nonzero size.

Data labels are separate from the values and categories in the worksheet. A chart can use the source values to calculate its slices while displaying category names, values, percentages, or text from a different cell range. That separation is useful here: you can remove one label without changing the data, or arrange for the chart to show a blank label whenever its corresponding value is zero.

First check what the underlying cell contains. A cell may display as 0 because of its number format or because a formula rounds a small result for display, while its actual stored value is not exactly zero. That distinction matters if you choose a formula-based solution. If the value is genuinely zero and the label is simply unwanted, the individual-label method is usually fastest.

Remove one label from the chart

In Excel for Microsoft 365 on Windows, select the chart and locate the zero-value label. Click a label once to select the data labels for that series. Then click the specific zero label again; this second click selects that data label on its own. Press Delete. The other labels and the worksheet data should remain unchanged.

Click the pie chart, then click the label you want to remove.
Click that same label a second time so only that label, rather than the whole set, is selected.
Check the selection before deleting. A single label should be selected, not the entire series of labels.
Press Delete. If you removed the wrong label, use Ctrl+Z on Windows to undo the change immediately.

This is a good choice for a one-off chart, a report whose data will not change, or a label that should stay hidden regardless of future values. It does not change the underlying category or its value, and it does not recalculate the other slices. It only removes that label from the chart. In Excel for Mac, the same general selection approach works, although the contextual chart controls and keyboard behavior can vary slightly by version; use the chart’s Format Data Labels pane if selecting the individual label is difficult.

Hide zero labels automatically with a helper column

If the chart is refreshed or edited often, deleting a label by hand is less dependable: a value that changes from zero to a positive number may still have its label manually removed. A helper column gives the chart label text that responds to the data instead. When the value is zero, the helper cell is blank; when the value is positive, the helper cell returns the category name.

For example, assume category names are in A2:A6, pie values are in B2:B6, and you can use C2:C6 for helper labels. Enter this in C2 and fill it down through C6:

=IF(B2=0,"",A2)

With Food in A2 and 12 in B2, C2 returns Food. With Travel in A3 and 0 in B3, C3 returns a blank. This formula tests for an exact zero, so it works as intended when the source value is truly 0. If the values are calculated and merely displayed as zero after rounding, decide whether the chart should treat those small underlying values as zero too; adjust the test to match the workbook’s calculation rules rather than relying only on how the cell looks.

To use the helper cells as labels, select the chart and open the Format Data Labels pane, usually by right-clicking a data label and choosing Format Data Labels. Under Label Options, select Value From Cells and select the helper range, C2:C6 in this example. Clear the Value option if you do not want Excel to append the numeric value to the category text. Also clear other label components, such as Percentage, if the goal is to show only the helper text. The exact pane layout can vary slightly, but the key is to use the helper range for label text instead of relying on the chart’s default category or value label.

Keep the helper range aligned with the chart’s categories: it should have one corresponding cell for each plotted category, in the same order. If you add rows to the chart’s source data, extend the helper formulas and the chart’s label range as well. Otherwise, labels can become mismatched or new categories may not receive the intended custom text.

Choose the method that fits the chart

The manual deletion method and the helper-column method solve slightly different problems. The first hides a particular label; the second controls what text the chart receives based on each row’s value. Consider how the chart will be maintained before choosing:

Use individual deletion for a fixed presentation chart where only one or two labels need to disappear and future data changes are unlikely.
Use a helper column for a recurring report, a chart linked to changing data, or a chart that should show a category name only when its value is nonzero.
Change the source data only if zero-valued categories should not be part of the chart at all. Removing or filtering data can affect other formulas, tables, and reports, so it is more consequential than hiding a label.

For a chart that should continue to show every positive category, the helper approach is generally easier to maintain. For a single published snapshot, manual deletion avoids adding worksheet support columns. Neither method changes the fact that a zero-value category contributes no slice area; they only change how the chart labels are displayed.

Label settings and chart updates

Excel’s data-label settings apply to different parts of a label. For example, a label may include a category name, a value, a percentage, or a combination. If a zero appears because the chart is displaying the value, clearing the Value option for the whole series will remove values from every label, not just the zero. That may be appropriate if you want category names only, but it is not a selective fix.

Similarly, changing a number format can alter how values look without changing the chart’s source data. It is not the clearest approach when the requirement is to remove only zero labels: it can affect all labels using that format, and the result may depend on which label components are enabled. A helper range makes the rule visible in the worksheet and lets you control the label text directly.

After changing a chart, inspect it again when the data updates. A manually deleted label may not return automatically when its value becomes positive. A helper formula, by contrast, recalculates its text as the underlying value changes, provided the chart still points to the right helper cells. If a chart is copied or its data range is expanded, verify the Value From Cells range as well as the pie’s source range.

Common problems and checks

If clicking a label seems to select every label, that is normal on the first click. Click the intended label again, carefully, to select just that point’s label. If the whole chart or the full label set remains selected, do not press Delete yet: deleting at that selection level could remove more than intended. Clicking outside the chart and starting again can make the selection easier to see.

If the label still shows a zero after using a helper column, check that Value From Cells is selected and that the range points to the helper cells, not the original category or value cells. Then check whether Value or Percentage is still selected as an additional label component. If the blank label appears to leave unwanted spacing, remember that Excel positions labels around the chart; moving or changing the remaining labels may help, but a blank text value is not the same as removing a slice from the source data.

If a cell looks like zero but the formula does not return a blank, inspect the cell’s formula bar or increase its displayed decimal places to see whether it contains a small fraction. The exact-zero test in the example does not treat a small positive value as zero. Choose a deliberate rounding or tolerance rule only if that matches how the data should be interpreted; changing the chart label rule should not silently redefine the underlying measurements.

Excel for the web may offer a different set of chart-formatting controls from desktop Excel. If you cannot find Value From Cells or cannot select just one label, open the workbook in the desktop application and use the Format Data Labels pane. On Windows, Ctrl+Z undoes a recent change; on Mac, use Command+Z. Undo is useful immediately after an accidental deletion, but it is not a substitute for keeping a copy before making substantial chart or data changes.

Frequently Asked Questions

Can I remove only the zero from a label and keep the category name?
Yes. Use a helper column that returns the category name for positive values and a blank for zero, then select that column through Value From Cells. Simply clearing the Value option removes values from all labels, not only the zero.

Does deleting a zero label delete the worksheet value?
No. Selecting and deleting an individual data label changes the chart display only. The source cell and the pie chart’s calculation remain unchanged.

Will a deleted label come back if the zero becomes a positive value?
Do not rely on it to return. A manually removed label can remain hidden for that point. Use a helper column if the label should appear or disappear automatically as values change.

Can I remove all zero-value categories from the pie chart?
You can filter or otherwise exclude those categories from the chart’s source data, but that changes what the chart includes rather than only hiding text. Check whether the same data range feeds other charts or calculations before changing it.

Why does Excel show a zero label when there is no visible slice?
A zero contributes no visible slice area, but Excel can still display a label for the category. The label and the slice are separate chart elements, so hiding the label does not change the value.

Can I hide zero labels in Excel for the web?
Some chart editing options differ in the browser. If the individual-label selection or Value From Cells control is unavailable, open the workbook in Excel for Microsoft 365 desktop and make the change there.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.