Pivot Chart Filters in Excel: How to Add and Use Them

Yes. In Excel for Microsoft 365 on Windows, select the PivotChart and use its field-button drop-downs to filter, or choose PivotChart Analyze > Insert Slicer for clickable filter buttons; for date fields, you can add a timeline. These controls filter the chart through its linked PivotTable, so the PivotTable’s displayed results change too.

What a PivotChart filter does

A PivotChart visualizes the results of a PivotTable. Its filters let you limit which source items contribute to those results—for example, show sales for one region, a chosen product group, or a particular period. When you change a filter, Excel recalculates the PivotTable and updates the chart to match. This is different from merely hiding a chart element: the filter changes the set of data summarized by the PivotTable.

The available controls depend on how the PivotTable fields are arranged. A field in the Axis (Categories) area supplies category labels, a field in Legend (Series) splits data into series, and a field in Filters acts as a report filter. Those fields can have drop-down buttons on the chart. A field does not have to be visible as an axis or series to be useful as a filter; a slicer can filter a field that is not displayed in the chart.

For example, imagine a PivotTable with monthly revenue by product, and a PivotChart that plots the totals. Filtering the Region field to West limits the chart to West-region revenue, even if Region is not one of the chart’s visible axes. It does not create a separate, chart-only view of the same PivotTable.

Add a filter with PivotChart field buttons

Field buttons are the quickest option when you want a compact drop-down directly on the chart. In Excel for Microsoft 365 on Windows:

Select the PivotChart. The contextual PivotChart Analyze tab appears on the ribbon.
If the chart does not show field buttons, choose PivotChart Analyze > Field Buttons, then select Show All.
On the chart, open the drop-down for the field you want to filter. Depending on the field’s position, its button may represent an axis, legend, value, or report-filter field.
Clear Select All, select the items to keep, and choose OK. The chart and linked PivotTable update together.

Field-button labels and positions vary with the chart layout. To filter product categories, for instance, open the button for the category field, leave only the products you want selected, and apply the selection. To restore the full view, reopen that field’s menu and select all items, or use its clear-filter command if shown.

When the chart is crowded, you can hide some or all of the buttons without removing the filter settings. Select PivotChart Analyze > Field Buttons and choose the relevant hide option, such as Hide All. The filter remains in effect, but readers may need to use the linked PivotTable or a slicer to change it. Showing the buttons again makes those chart controls available.

Use a slicer for visible, clickable filters

A slicer is a panel of buttons, with one button for each available item in a field. It is often easier to understand than a small chart drop-down, especially in a dashboard intended for other people. To add one, select the PivotChart and choose PivotChart Analyze > Insert Slicer. Select one or more fields in the dialog box and choose OK. Excel places a slicer on the worksheet; move and resize it near the chart, then click an item to filter.

Suppose a report has a Region slicer with East, Central, and West buttons. Clicking West filters the connected PivotTable and chart to that region. To select more than one item, use the slicer’s multi-select control if it is displayed, then select the desired buttons. The clear-filter icon in the slicer header removes the slicer’s selection and restores all items for that field.

Slicers can make the current selection obvious, but they take up worksheet space. A slicer for a field with hundreds of distinct values may also be unwieldy. Choose fields with a manageable number of useful choices—such as Region, Department, or Product Category—and use a drop-down filter for long lists when that is more practical. You can format a slicer and set its number of columns from the contextual slicer tab after selecting it.

Filter dates with a timeline

For a PivotTable field containing actual dates, a timeline provides a graphical way to select a period. Select the PivotChart and choose PivotChart Analyze > Insert Timeline. Select the date field and choose OK. Use the timeline’s level selector to view or choose years, quarters, months, or days, then drag or click across the period you want included.

A timeline is useful for questions such as how sales changed during the last few months or how one quarter compares with another. It requires a date field that Excel recognizes as dates; text that merely looks like a date may not work as expected. If the timeline is unavailable or shows unexpected gaps, check the source values for text entries, blanks, or invalid dates, then refresh the PivotTable.

Timelines and slicers are controls over PivotTable fields, not independent chart decorations. Clearing a timeline selection returns that date field to its unfiltered state. If you need to filter by a date range that is not convenient on a timeline, the date field’s PivotTable drop-down may offer date-filter options such as a range, depending on the field and data.

Choose the right filter for the job

Excel offers several ways to narrow a PivotChart’s data. The best choice depends on how many options the field has and how the report will be used:

Field-button drop-down: Good for occasional filtering and compact worksheets. It keeps controls attached to the chart but can be less obvious to a casual reader.
Slicer: Good for interactive reports where people should see the available choices and the current selection. It works for categories as well as other fields.
Timeline: Good for exploring a date field across a continuous period, with year-to-day levels.
Report filter: Put a field in the PivotTable Fields Filters area to create a filter above the PivotTable. It is useful for a simple single-field selection, but is less visual than a slicer.

You can combine controls. A report might use a Region slicer, a Product Category slicer, and a timeline for Order Date. Each control filters the same PivotTable, so the results reflect all the selections together. If a selection produces no matching records—for example, a category has no sales in the selected region and period—the chart may show no data. That is not necessarily a chart error; it may simply be the result of the combined filters.

Connect filters to more than one PivotChart

A slicer can sometimes control multiple PivotTables and PivotCharts, which helps keep a dashboard consistent. Select the slicer, open its contextual Slicer tab, and choose Report Connections (the command may be labeled PivotTable Connections in some Excel versions). Select the PivotTables it should control and confirm. The charts connected to those PivotTables then respond to that slicer.

Not every PivotTable will appear in the connections list. In general, the PivotTables need to share a compatible source or PivotTable connection. If one table was built from a different source or cache, Excel may not let the slicer control it. A practical fix is to create the PivotTables from the same source in a compatible way, or use separate slicers for the separate groups of PivotTables. Check each chart after connecting controls so you can confirm the selections produce the intended view.

Refresh data and troubleshoot filters

Filters only work with items known to the PivotTable. If a newly added product or date is missing from a slicer, refresh the PivotTable using PivotTable Analyze > Refresh, or choose Data > Refresh All to refresh workbook connections. If new source rows still do not appear, check the PivotTable’s source range. A source formatted as an Excel table generally expands as rows are added; a fixed cell range may need to be adjusted through PivotTable Analyze > Change Data Source.

Other common problems have straightforward checks:

No field buttons are visible: Select the chart and use PivotChart Analyze > Field Buttons > Show All, or add a slicer.
A slicer does not affect a chart: Open its Report Connections or PivotTable Connections list and confirm the chart’s PivotTable is selected.
The filter list contains old items: Refresh the PivotTable and inspect its source data. Cached items can sometimes remain available even after records are removed; PivotTable options include settings for retaining items in the source field.
The chart goes blank after filtering: Clear other filters and check whether the chosen combination has any matching source rows.
A date timeline cannot be inserted: Confirm that the source field contains valid date values and is included in the PivotTable.

On Excel for Mac, the same general approach applies, but the contextual tab names and ribbon layout can differ by release. Select the PivotChart and look for the PivotChart or PivotTable analysis controls, then use the corresponding Insert Slicer or date-timeline command if it is available in that version. Excel for the web may also present a different editing interface, so Windows ribbon paths in this guide are specifically for Microsoft 365 desktop Excel on Windows.

PivotChart filters compared with regular chart filters

A regular chart built from a worksheet range is filtered through its source data or the chart’s available chart-filter controls. A PivotChart is different: it is tied to a PivotTable and uses PivotTable fields, field buttons, slicers, or timelines. Therefore, filtering a PivotChart also changes the linked PivotTable’s results. If the requirement is to hide a point in one chart without changing a shared PivotTable, consider making a separate PivotTable for that view or using a regular chart based on a separate data range. Simply hiding field buttons does not disconnect a PivotChart from its PivotTable.

Frequently Asked Questions

Can I add a filter to a PivotChart without a slicer?
Yes. Use the field-button drop-downs on the PivotChart or put a field in the linked PivotTable’s Filters area. A slicer is optional; it is a more visible alternative.

Can I filter a PivotChart without changing its PivotTable?
Not when both use the same PivotTable. A PivotChart reflects that PivotTable’s filtered results. For an independent chart view, create a separate PivotTable or use a separate source range.

Why is Insert Slicer greyed out?
Check that you selected a PivotChart or its linked PivotTable and that the workbook is in a state that allows editing. Some PivotTables, sources, or Excel versions may not support the control in the way expected. Try inserting the slicer from the linked PivotTable and check that the field is available.

Can one slicer filter two PivotCharts?
Yes, if their PivotTables can be connected to the same slicer. Select the slicer and use Report Connections or PivotTable Connections to choose the compatible PivotTables that should respond.

How do I remove a PivotChart filter?
Clear the selection in the chart field-button menu, click the slicer’s clear-filter icon, or clear the timeline selection. Removing a slicer object is different: it deletes the control, but it may not clear other filters already applied to the PivotTable.

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.