Pivot Chart Slicers: How to Add and Use Them

Yes. In Excel for Microsoft 365 on Windows, select the PivotChart, choose PivotChart Analyze > Insert Slicer, select one or more fields, and click OK. The slicer then filters the chart through its underlying PivotTable, giving readers clickable buttons instead of requiring them to open a filter menu.

What a PivotChart slicer does

A slicer is a visual filter for a PivotTable or PivotChart. It appears as a box of labeled buttons—such as product names, regions, or sales representatives. Clicking a button filters the connected PivotTable, and a PivotChart based on that table redraws to show the filtered results. A reader can often understand the current selection at a glance, which makes slicers useful on interactive reports and dashboards.

A slicer does not change or delete the source data. It changes which records the PivotTable includes in its calculation. For example, imagine a PivotTable summarizing sales by month and product category. Add a slicer for Region, then click West: the chart updates to show the West region while the underlying records remain in the source table. Clear the selection to return to all regions.

The distinction between a PivotChart and a regular chart matters. A slicer can filter a PivotChart because it is connected to a PivotTable. It does not automatically filter an ordinary chart that happens to display similar-looking data. If you need an ordinary chart to respond to a slicer, it may be possible to build it from a PivotTable’s changing output, but the slicer’s direct connection is to the PivotTable, not to the chart itself.

How to add a slicer to a PivotChart

First make sure the chart is actually a PivotChart. Select it and look for the contextual PivotChart Analyze tab on the ribbon. If that tab does not appear, select the PivotTable instead and use PivotTable Analyze > Insert Slicer; the slicer will still filter a PivotChart based on that table.

Click the PivotChart, or click its associated PivotTable.
On the ribbon, choose PivotChart Analyze > Insert Slicer. When the PivotTable is selected, the equivalent path is PivotTable Analyze > Insert Slicer.
In the Insert Slicers dialog box, tick the field or fields you want readers to filter by, such as Region, Year, or Category.
Click OK. Excel adds a slicer for each selected field.
Drag each slicer to a useful position and resize it so the buttons and labels are readable.

The available fields come from the PivotTable’s source data or data model. A field such as Region must be present in that source before it can be offered as a slicer. If a new column has been added to a worksheet source, refresh the PivotTable and, if necessary, update its source range before looking for that field in the Insert Slicers dialog.

Filtering, clearing, and selecting multiple values

Click a slicer button to filter to that item. For instance, clicking North in a Region slicer limits the PivotTable and chart to North. Buttons that are unavailable under the current filters may appear dimmed; their status can help explain why a particular combination produces no records.

To remove a slicer’s filter, click the clear-filter icon in the slicer header. It usually looks like a small filter symbol with a red cross. Clearing one slicer removes that slicer’s selection only; other slicers can remain active. This is important when a report combines filters such as Year = 2025 and Region = North. Clear the Year slicer alone and the Region filter remains in effect.

To choose more than one item, use the slicer’s Multi-Select button if it is displayed, then click the desired buttons. Depending on the layout and Excel version, you can also use the applicable modifier key while selecting. The slicer header indicates when multiple values are selected. For an easy-to-read report, consider making the multi-selection state obvious and explaining that more than one button can be active.

Filters from different slicers combine. If a user selects North in one slicer and Furniture in another, the PivotTable shows records that meet both conditions, not records that meet either one. That behavior is usually what a dashboard needs, but it can result in an empty chart when the selected combination has no matching records.

Connect one slicer to other PivotTables and charts

A slicer initially controls the PivotTable from which it was created. It can also control other PivotTables—and their PivotCharts—when Excel allows those reports to share the relevant PivotTable cache or data-model connection. This is useful when a dashboard contains several views, such as sales by month, sales by product, and sales by salesperson, that should all respond to the same Region selection.

To check or change the connection, select the slicer and choose Slicer > Report Connections (the command may be labeled PivotTable Connections in some Excel builds). Tick the PivotTables the slicer should control, then click OK. If a desired PivotTable is missing from the list, the reports may not share a compatible source or connection. Creating the PivotTables from the same source and cache, or building them from the same Data Model, can make them eligible to share a slicer.

Take care when connecting a slicer to multiple reports: each report should use the same meaning for the selected field. A Region field with consistent values is a good fit. Two columns that happen to have the same heading but represent different concepts should not be treated as interchangeable. After connecting the slicer, click a few options and confirm every chart responds as intended.

Format and arrange slicers for a dashboard

Select a slicer to reveal its contextual Slicer tab. From there, you can choose a slicer style, adjust the number of button columns, set button height and width, and manage connections. A slicer with many items may need more than one column; a short list often works best in a single column or row. Resize it to show useful labels without excessive blank space.

Use clear field names and consistent styling. For example, label a slicer Sales Region rather than leaving an unclear abbreviation such as Reg. Align related slicers above or beside the chart, and leave enough space for longer button labels. If the report will be printed, check that the slicers do not cover chart labels or extend beyond the print area.

For a date field, a Timeline may be more convenient than a regular slicer because it offers a time-based control for years, quarters, months, or days. Select the PivotTable or PivotChart and look for PivotTable Analyze > Insert Timeline. Timelines require a supported date field; text that merely looks like a date may not work as a true date field. You can use a Timeline alongside slicers for categorical fields such as Region or Product.

Common problems and practical fixes

Insert Slicer is unavailable: Select a PivotTable or PivotChart first. The command is contextual and may not appear when an ordinary chart or a blank worksheet cell is selected.
The field is missing: Check that the field is in the PivotTable’s source data or Data Model. Refresh the PivotTable after changes, and confirm that its source range includes newly added rows or columns.
The slicer does not affect another chart: That chart may be a regular chart, or its PivotTable may not be connected. Use Report Connections to inspect eligible PivotTables; a normal chart is not directly controlled like a PivotChart.
A connected PivotTable is not listed: The reports may use different PivotTable caches or data connections. Similar column headings alone do not guarantee that two reports can share a slicer.
The chart goes blank: Check for filters that conflict across slicers, or a selected combination with no matching source records. Clear the filters and reapply them one at a time to identify the cause.
New source rows are not included: Refreshing updates the PivotTable’s cached results, but it does not always expand a fixed source range. Use an Excel Table as the source where practical, or adjust the PivotTable data source to include the added records.

When troubleshooting, also check the PivotTable’s own filters and field layout. A slicer can be working correctly while another filter or a missing chart category makes the result look unexpected. Refreshing is especially relevant after changing source values, but it will not fix a slicer connection problem by itself.

PivotChart slicers versus filters and other options

PivotTable report filters and field dropdowns can filter the same report without adding a separate visual control. They may be simpler when a workbook has limited space or only one person uses it. Slicers are more visible and easier to operate in a presentation, but each one occupies worksheet space and can add visual clutter if every field gets its own control.

Use a slicer when readers need to explore a small set of meaningful categories, such as Region, Channel, or Product Line. Use a Timeline when date-range navigation is the main task. Use ordinary PivotTable filters for less frequently changed criteria or when compactness matters. If the source data needs more complex filtering than the PivotTable provides, consider whether a separate report design or a different analysis tool is more appropriate rather than adding many overlapping slicers.

On Excel for Mac, slicers are available in current Microsoft 365 versions, although ribbon organization can differ from Windows. Select the PivotTable or PivotChart and look for the contextual PivotTable Analyze or PivotChart Analyze tab and its Insert Slicer command. Excel for the web may support interacting with existing workbook features differently from the desktop app, so use the Windows desktop steps above when creating or managing a report and a command is not available in the browser.

Frequently Asked Questions

Can I add a slicer directly to a PivotChart?
Yes. Select the PivotChart and choose PivotChart Analyze > Insert Slicer. The slicer filters the PivotChart through its underlying PivotTable.

Can one slicer control multiple PivotCharts?
Yes, if the PivotCharts’ underlying PivotTables can share the slicer connection. Select the slicer, open Slicer > Report Connections or PivotTable Connections, and select the eligible PivotTables.

Why can’t I see a field in the Insert Slicers box?
The field must be available in the PivotTable’s source or Data Model. Check the source range, refresh the PivotTable, and confirm the field is included in the data used by that report.

Can a slicer filter a regular Excel chart?
Not directly in the same way it filters a PivotChart. A slicer controls a PivotTable; a PivotChart based on that table updates with it. A standard chart needs a separate setup that responds to the changing PivotTable output.

How do I show all the data again?
Click the clear-filter icon in the slicer header. If other slicers or PivotTable filters are active, clear those separately too; one slicer’s clear button does not reset every filter in the report.

Can I use a date slicer?
Yes. You can add a regular slicer for a supported date field, or use PivotTable Analyze > Insert Timeline for a time-oriented control. The source field must contain real date values for a Timeline to work correctly.

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.