Excel PivotChart: How to Hide Series and Keep Data

To hide a series in an Excel PivotChart, filter out its item in the field used for Legend (Series): open that field’s dropdown on the chart, clear the checkbox beside the item, and select OK. This hides it from the PivotChart without deleting its source data, but it also filters the connected PivotTable.

What “hide a series” means in a PivotChart

A PivotChart is controlled by the fields and filters in its associated PivotTable. A series is one of the plotted groups shown in the chart legend. For example, if a chart shows sales by month, with Region in Legend (Series), North and South may appear as two separate lines. Filtering out North removes that series from the chart display.

Filtering is different from deleting. The records remain in the source data, and you can show the series again by restoring its checkbox. However, a PivotChart does not treat its plotted series like a regular chart’s editable data range. Its field layout and filters determine what is plotted, so a chart-only hide command is generally not available for an individual PivotChart series.

Also distinguish a series from a category. In a monthly sales chart, months may be categories on the horizontal axis, while regions are the series. Filtering a month removes a category or time period; filtering a region removes a series. Which action you need depends on where the relevant field is placed in the PivotChart.

Hide a series with the legend field filter

In Excel for Microsoft 365 on Windows, the direct approach is to filter the field that supplies the chart’s series. If the field buttons are visible, the dropdown on the legend field is usually the quickest route. If they are not visible, use the Field List to confirm the field placement and show the appropriate button.

Select the PivotChart. The contextual PivotChart Analyze tab appears on the ribbon.
Choose PivotChart Analyze > Field List if the PivotChart Fields pane is not already open.
In the pane, find the field in the Legend (Series) area. This is the field whose items create separate plotted series.
Open the dropdown for that field, either from its chart field button or from the field controls in the pane.
Clear the checkbox beside the item you want to hide, then select OK. If the list is long, use its search box to find the item first.

If the field button is missing from the chart, select the chart and choose PivotChart Analyze > Field Buttons > Show Legend Field Buttons. Ribbon wording or placement can vary slightly with window size and Excel updates. You can also filter the field from the PivotChart Fields pane; the essential step is changing the filter for the field in Legend (Series), not removing the field from the chart layout.

To restore the series, open the same dropdown and check the item again. If you cleared several items or applied other filters, choose the option to clear the filter for that field, if available, then apply the selection you want. Avoid dragging the field out of Legend (Series) unless you intend to change the chart’s structure rather than temporarily hide one item.

Choose the correct field to filter

The field’s location determines what its filter does. A field in Legend (Series) creates the separate chart groups. A field in Axis (Categories) controls the labels or categories along the chart axis. A field in Filters applies a report-level filter, and a field in Values supplies the numbers being plotted. To hide one named legend entry, start with the field in Legend (Series).

For instance, imagine a PivotChart of quarterly revenue by product, with Quarter in Axis (Categories), Product in Legend (Series), and Sum of Revenue in Values. Clear the checkbox for Product C to hide its line or set of columns. Clear Q2 in the Quarter filter instead, and the chart omits that quarter for every product; that does not hide Product C alone.

Chart type matters, too. A line or clustered-column chart commonly displays multiple series clearly. A pie chart represents one data series at a time, so its legend entries are typically categories or slices rather than several independent series. If you do not see the expected field or the chart changes in an unexpected way, check the field layout and chart type before changing the source data.

Understand the effect on the PivotTable

The filter is part of the PivotTable report behind the PivotChart. As a result, filtering a series through the PivotChart generally filters the associated PivotTable as well. If the table and chart sit beside one another, you may see a product or region disappear from both. This is normal: the chart is not merely concealing a visual object; it is displaying a filtered view of the pivot report.

That behavior can be useful when the table and chart are meant to tell the same story. It can be surprising when the PivotTable is intended to remain a complete reference while the chart shows a selected subset. In that case, decide whether a second pivot report or a regular chart based on a separate helper range would better fit the workbook. A separate PivotTable can have its own filters, though reports connected to the same slicer may change together when that slicer is used.

Filtering does not remove rows from the underlying source table. Refreshing the PivotTable may update its available items based on the current source and cache, but a refresh is not the same as deleting source records. Keep the distinction clear: source data is the record set; the PivotTable filter controls which items the report currently displays.

Use a slicer for a reusable series selector

A slicer is a set of clickable buttons that filters a PivotTable or PivotChart field. It can make series selection easier for readers who should not have to open a small dropdown each time. For example, add a slicer for Product and click Product A or Product B to control which products appear in the chart.

To add one, select the PivotTable or PivotChart, then use the contextual PivotTable or PivotChart Analyze tab and choose Insert Slicer. Select the field that supplies the series and confirm. The slicer buttons then act as filters for that field; selecting multiple buttons can show multiple items, subject to the slicer’s selection settings.

Slicers are especially useful on dashboards because their current selection is visible. They are not inherently chart-only, however: they filter the connected PivotTable report too. If a slicer should control several reports, use its report connections to choose the PivotTables it affects. Only reports with compatible PivotTable connections can be connected, and connecting reports intentionally means one slicer selection can change more than one chart or table.

When you need chart-only hiding

If the PivotTable must stay unfiltered while the chart independently hides a series, the built-in PivotChart field filter is not the right mechanism. One option is to create a regular chart from a separate summary range, such as a carefully designed helper table that references the PivotTable results. A regular chart can use its own chart filters and data range without filtering the pivot report itself.

Another option is to create a second PivotTable and build a separate PivotChart from it. Give that report its own field filters and avoid connecting it to slicers that also control the original report. This is often easier to maintain when the chart still needs PivotTable features such as field-based grouping or refreshable summaries. Check the workbook after creating it: if both reports respond to the same slicer or report filter, adjust the slicer’s report connections or use a different setup.

For a small, fixed chart, a normal chart linked to a helper range may be simpler. For a chart that must update as source records change, a second PivotTable can be more convenient. The trade-off is that helper ranges may need careful formulas or layout management, while extra PivotTables add another report to refresh and maintain.

Common problems and fixes

The dropdown is missing: Select the chart and open the Field List. Confirm which field is in Legend (Series), then show its legend field button from PivotChart Analyze > Field Buttons, if that control is available in your ribbon layout.
The wrong thing disappears: You may have filtered the Axis (Categories) field instead of the Legend (Series) field. Check the four areas in the PivotChart Fields pane before changing another filter.
The PivotTable changed too: That is expected for a filter on the connected pivot report. Use a separate PivotTable or a regular chart with a separate data range when you need the chart to vary independently.
The chart does not show a separate series for each item: Verify that the intended field is in Legend (Series), and consider whether the selected chart type supports multiple series in the way you expect.
A hidden item returns after refresh: Review the field’s filter after refreshing and check whether the source data now contains new or changed items. A refresh can update the PivotTable’s available items and displayed results.

In Excel for Mac, the same field-filter principle applies, although contextual tab names and ribbon placement can differ by release. Excel for the web also has a different interface and may not expose every desktop control in the same place. If you cannot find a field-button command, open the PivotTable or PivotChart field pane and filter the relevant field there, or use the Windows desktop version for the steps above.

Frequently Asked Questions

Can I hide a PivotChart series without filtering the PivotTable?
No, not with the usual PivotChart field filter: it filters the associated pivot report. For an independent chart-only view, use a regular chart based on a separate range or create a second PivotTable and PivotChart with separate filter connections.

Can I click a legend entry and press Delete?
That is not the recommended way to hide an item in a PivotChart. PivotCharts are controlled by their pivot fields, and direct series editing is restricted compared with a regular chart. Filter the corresponding Legend (Series) field instead so the change is managed by the PivotTable report.

How do I show a hidden series again?
Open the dropdown for the same Legend (Series) field and check the item again. If you are unsure which items are filtered, clear that field’s filter and then select the desired items.

Why does hiding a series remove it from my PivotTable too?
The chart and PivotTable share the pivot report’s field filter. Filtering a legend item changes the report view, not just the chart’s appearance. Use a separate report or a normal chart if the table must remain unchanged.

Can a slicer hide PivotChart series?
Yes. Add a slicer for the field that supplies the series and use its buttons to select the items to display. The slicer filters connected PivotTable reports as well, so review its report connections if the workbook contains multiple charts or tables.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.