Excel Pivot Chart: How to Remove a Series

To remove a series from an Excel PivotChart, select the chart, open PivotChart Analyze > Field List, and remove the relevant field from Legend (Series) or Values. To remove just one category from a series, filter that category out using its field-button dropdown instead.

Why PivotCharts handle series differently

A PivotChart is connected to a PivotTable, so its series are generated from the fields and items in the underlying pivot layout. This is different from a standard chart, where you can usually open Select Data and edit or delete individual series references independently. With a PivotChart, changing its field layout or filtering an item changes the pivot-based report that supplies the chart.

That connection is useful: when you refresh or rearrange the PivotTable, the chart can update with it. It also explains why deleting a series directly from the chart may not work as expected. Excel may prevent that edit, or the series may return when the PivotTable refreshes or its layout changes. To make a lasting change, adjust the fields or filters that produce the series.

Before editing, decide what you mean by “remove a series.” You might want to remove an entire data field, hide one category such as a region, or simply make the chart less cluttered without changing the data shown in the PivotTable. Each goal calls for a different action.

Identify what creates the series

Select the PivotChart and choose PivotChart Analyze > Field List if the PivotChart Fields pane is not already visible. The pane shows areas such as Filters, Legend (Series), Axis (Categories), and Values. The fields in those areas determine the chart’s structure.

For example, suppose a sales PivotTable contains Month, Region, and Revenue. If Month is in Axis (Categories), Region is in Legend (Series), and Revenue is in Values, the chart will generally show a separate revenue series for each region. Removing Region from Legend (Series) removes that split; filtering out the West item removes only West while leaving the other regions available.

Some PivotCharts use more than one measure. If both Revenue and Units are in Values, Excel can plot both measures as series. In that case, the series you want to remove may be a value field rather than a category such as Region. Check the field layout before changing anything.

Remove a whole field from the chart

Use this method when a field is responsible for a complete set of series and you no longer want the chart divided by that field. In the PivotChart Fields pane, drag the field out of Legend (Series). You can also move it to another area if you still need it as a filter or category. For instance, moving Region from Legend (Series) to Filters replaces several regional lines with a chart for the selected region.

Select the PivotChart so its chart-specific ribbon tab appears.
Choose PivotChart Analyze > Field List.
Find the field in Legend (Series) and drag it out of the layout, or move it to another area.
Check the chart and the associated PivotTable to confirm the report now shows the intended breakdown.

Removing a field from the chart layout does not delete the field or its source data from the workbook. It changes how the PivotTable-based report is arranged. However, because the chart is linked to the PivotTable, the table’s layout or displayed results may change too. If you need the PivotTable to retain a particular presentation, consider whether moving the field to Filters is preferable to removing it altogether.

Remove one category but keep the field

If you want to exclude one series, such as one product or region, while retaining the other series, filter the field’s items. Use the dropdown on the chart’s field button for the field in Legend (Series), clear the checkbox for the item to exclude, and confirm with OK if Excel presents an OK button. The chart will omit that item, while the field remains part of the PivotChart layout.

If you cannot see a suitable dropdown on the chart, the field buttons may be hidden. Select the chart and use PivotChart Analyze > Field Buttons > Show All to display them. The exact set of buttons visible depends on the chart’s fields and Excel’s layout. You can also filter the corresponding field in the associated PivotTable; the chart will reflect that filter.

For example, if the chart has a series for each sales region and you want to omit West for a presentation, clear West in the Region field’s item list. This is a filter, not deletion: West remains in the source data and can be included again by reopening the dropdown and selecting it. Other filters, slicers, or report settings can also affect which items appear, so check those if the desired category is not listed.

When the series represents a value field

In some charts, each measure in the Values area creates a series. A chart might compare Revenue and Units across months, for example. To remove Units from the chart, select the chart, open the PivotChart Fields pane, and drag Units out of Values. This removes that measure from the pivot layout; it does not erase the Units column from the source table.

Be cautious if the associated PivotTable is also being used for other work. Removing a value field from the shared pivot layout can change what the PivotTable displays as well as what the chart plots. If the goal is only to show a simpler chart while keeping a detailed table, you may need a separate PivotTable and PivotChart for the chart, or a regular chart built from a separate range of summarized data.

Also check whether Excel has arranged the measures as series or categories. A PivotChart with multiple value fields can show them in different orientations depending on the layout and chart type. If removing a field changes the chart in an unexpected way, inspect the field areas and the chart’s labels rather than assuming that every visible legend entry corresponds to a source-data column.

Hide buttons without removing data

Field buttons are controls displayed on a PivotChart; they are not data series. Hiding them can make a finished chart look cleaner, but it does not remove or filter any series. To hide them, select the chart and choose PivotChart Analyze > Field Buttons > Hide All. If you only want to hide a particular type of button, use the corresponding option in the Field Buttons menu when available.

This is a good choice when the chart already contains the right data and you simply do not want viewers to see filter controls. It is not a substitute for filtering: the series remain in the chart, and hiding the buttons can make it less obvious how to change the displayed items later. You can show the buttons again from the same menu.

Keep the PivotTable unchanged where possible

Filtering a PivotChart’s field often affects the associated PivotTable because the two are connected. A chart filter is therefore not always a chart-only edit. If a PivotTable feeds other reports, inspect those reports after changing a filter or field arrangement. A slicer can provide a clearer way to control items, but it also filters the PivotTable or PivotTables connected to it.

To add a slicer, select the associated PivotTable and choose PivotTable Analyze > Insert Slicer, then select the field to control. A slicer is useful when viewers need to switch between categories without opening a small dropdown. If multiple PivotTables use compatible source data, you can manage which ones a slicer controls through its report connections; do not assume it controls every PivotTable automatically.

If the chart must have a series arrangement independent of the PivotTable, consider making a regular chart from a separate range of summarized values. That approach gives you the standard chart’s more direct series controls, but it also means the chart may not behave like a PivotChart or update automatically with the same pivot layout. Decide whether independent formatting or pivot-driven refresh is more important for the report.

Common problems and checks

The series returns: Check whether you deleted or edited a chart element instead of changing its PivotChart field or filter. Adjust the layout or filter, then refresh if the PivotTable uses refreshed source data.
The dropdown is missing: Show the PivotChart field buttons, or apply the filter from the associated PivotTable’s field dropdown.
Several series disappear: You may have removed a field from Legend (Series) rather than unchecking one item. Undo the layout change if needed, then filter the specific item instead.
The PivotTable changes too: That is often expected because the chart and table share a pivot layout or filter. Use a separate PivotTable for a separate report view when necessary.
An item is absent from the filter list: Review other active filters and slicers, and consider whether the source data or PivotTable has been refreshed. An item with no data in the current context may not appear, depending on the field settings.

When the chart is used in a dashboard, make a small change first and inspect the result before hiding controls or distributing the workbook. This helps catch changes to linked PivotTables and slicers that may not be obvious from the chart alone.

Excel for Mac and Excel for the web

The field-based approach applies in Excel for Microsoft 365 on Windows and is also available in current desktop Excel for Mac, though ribbon labels, pane placement, and available chart controls can differ by build. On Mac, select the PivotChart and look for its PivotChart Analyze tab and Field List or PivotChart Fields pane; use the field areas there rather than trying to edit a series as if the chart were a standard chart.

Excel for the web can handle many PivotTable and chart tasks, but its available PivotChart editing controls may not match the Windows desktop ribbon. If you cannot find the field list or the relevant filter control in the browser, open the workbook in the desktop app and make the layout change there. Avoid relying on a hidden-button setting as a workaround: hiding controls does not remove the series.

Frequently Asked Questions

Can I delete a series from a PivotChart with the Delete key?
That is not the reliable way to remove a PivotChart series. Change the field layout or filter the relevant item instead; the chart’s series are generated from its PivotTable connection.

How do I remove only one legend entry?
If the entry is one item of a field in Legend (Series), open that field’s dropdown and clear the item’s checkbox. If it is a measure such as Revenue, remove that value field from Values instead.

Will removing a PivotChart series delete my source data?
No. Removing a field from the pivot layout or filtering out an item changes the report, not the underlying source records. The item can generally be shown again by restoring the field or filter selection.

Why does filtering the chart also change my PivotTable?
The PivotChart is linked to a PivotTable, and its fields and filters can be shared with that table. For a separate chart view, use a separate PivotTable or build a regular chart from a separate summarized range.

Can I remove a series without changing the PivotTable?
Not always when both use the same pivot layout. Hiding field buttons leaves the data untouched but does not remove a series. For genuinely independent chart data, use a separate pivot report or a regular chart based on its own range.

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.