Excel Pivot Chart Slicers: How to Add and Use Them

An Excel PivotChart slicer is a set of clickable filter buttons for a PivotTable and its connected PivotChart. In Excel for Microsoft 365 on Windows, select the PivotTable, choose PivotTable Analyze > Insert Slicer, select the field to filter, and click OK; the chart updates as you choose slicer buttons.

What a PivotChart slicer does

A slicer gives a visible, clickable way to filter PivotTable data. Instead of opening a field’s drop-down menu and checking items, a reader can click a labeled button such as “East” or “Online.” The connected PivotTable changes to show the selected items, and its PivotChart reflects the filtered results. Slicers are useful in reports and dashboards because the available choices stay visible.

A slicer is not a separate chart filter or a chart annotation. It filters a field in the PivotTable’s underlying data, and the PivotChart displays the result of that change. For example, a PivotTable summarizing sales by month and region can have a slicer for sales channel. Clicking “Retail” filters the table and chart to retail records while retaining the month and region layout.

Slicers work with PivotTables and PivotCharts, not ordinary charts built directly from a cell range. To use one with a regular chart, you would need to change the report design—for example, use a PivotTable and PivotChart, or build a separate filtering mechanism that changes the chart’s source data.

How slicers and PivotCharts are connected

A PivotChart is linked to a PivotTable, even when the table is on another worksheet or is hidden from view. The PivotTable organizes and summarizes the source records; the PivotChart visualizes that summary. A slicer filters a field in the PivotTable, so the change flows through to the chart. This relationship explains why adding a slicer to the associated PivotTable is a dependable way to control its chart.

Each slicer is tied to a field, such as Region, Product, or Salesperson. It filters the field’s items rather than performing a calculation. The PivotTable’s value field—such as Sum of Sales—continues to use its existing summary calculation. A slicer for Year, for example, limits which records contribute to the displayed total; it does not change the total from a sum to an average.

Behind the interface, PivotTables use a data source and a PivotTable cache or, in some workbooks, the Excel Data Model. A slicer can control more than one PivotTable when those tables use a compatible shared connection. It cannot automatically control every PivotTable that happens to use a similarly named field. Connection compatibility matters, especially when a workbook contains PivotTables created separately.

Add a slicer to a PivotChart

Click a cell in the PivotTable associated with the chart. If the table is on another sheet, go to that sheet first. The PivotChart itself may expose slicer commands in some ribbon layouts, but selecting the PivotTable makes the relationship explicit.
On the ribbon, choose PivotTable Analyze > Insert Slicer. The PivotTable Analyze tab appears when a PivotTable is selected.
In the Insert Slicers dialog box, select one or more fields you want users to filter by, such as Region or Product, and choose OK. Each selected field creates a separate slicer.
Move and resize the slicer so it does not cover the chart or the table. Select its border and drag it; use the sizing handles to change its dimensions.
Click a slicer button and confirm that both the PivotTable and its PivotChart show the filtered result. Save the workbook after arranging the report.

If a slicer is inserted while the PivotTable is selected, Excel associates it with that PivotTable. You can confirm or change which compatible PivotTables it controls by selecting the slicer and using the slicer ribbon’s Report Connections command. Depending on the ribbon layout, the contextual tab may be labeled Slicer or Slicer Tools. If the expected tab is missing, click the slicer itself.

Use slicer buttons and clear filters

Click one button to filter to one item. To select multiple items, use the slicer’s multi-select control, usually shown as a small icon near the top-right of the slicer, and then click the desired buttons. In many layouts, holding Ctrl while clicking also adds or removes selections. The exact appearance can vary with the slicer style and available space.

When a slicer is filtering its field, a clear-filter icon appears in its header, commonly shown as a funnel with an X. Click it to remove that slicer’s filter and restore all items for that field. Clearing one slicer does not clear filters applied by other slicers, report filters, or the PivotTable’s own field filters. Check all of those controls if the chart still appears restricted.

Button colors and appearance indicate the selection state. Items included in the current filter are highlighted; excluded items are not. Items that cannot produce a result under the current combination of filters may appear dimmed or unavailable, depending on the report and settings. This is a useful clue when a selection seems to have no effect.

Format and arrange slicers for a report

Select a slicer to access its contextual ribbon options. You can choose a built-in slicer style, set the number of columns of buttons, adjust button height and width, and change the slicer’s overall size. A one-column slicer is easy to scan for a short list of regions; a multi-column layout can save space when there are many categories. Avoid making buttons so small that labels become difficult to read.

Use the slicer’s settings to control details such as its caption and how items with no data are displayed. A caption such as “Choose a region” can make a dashboard clearer than a field name that is ambiguous to its audience. If the slicer list includes old or irrelevant categories, first check the source data and PivotTable refresh behavior rather than assuming a formatting option will remove them.

For a clean dashboard, place slicers near the chart they control and use consistent sizes and styles. Leave enough room for long item names and for the chart to resize or redraw. Consider testing several combinations of filters before sharing the workbook: an arrangement that works for one region may crowd the chart when a longer category name is selected or when multiple slicers are used together.

Control multiple PivotTables and charts

One slicer can control multiple PivotTables when Excel recognizes them as compatible. Select the slicer, open Slicer > Report Connections (or the similarly named Report Connections command on the contextual ribbon), and select the PivotTables to connect. The connected PivotCharts update because they reflect those PivotTables. This is useful for a dashboard with separate charts for sales, order counts, and returns that should all respond to the same Region selection.

If a PivotTable is missing from the Report Connections list, the tables may not share a PivotTable cache or compatible Data Model connection. Having the same source columns or the same field name does not, by itself, guarantee that Excel can connect them. A practical approach is to create additional PivotTables by copying a compatible existing PivotTable, then adjust their fields and layout. For data-model reports, make sure the PivotTables use the same model connection.

Connections can also create confusing results if reports have different purposes. A slicer connected to several tables filters all of them, which may be unwanted if one chart is meant to show an unfiltered benchmark. Review the Report Connections selections deliberately, and use separate slicers when different charts need independent filters.

Slicers compared with filters and timelines

PivotTable field filters are compact and familiar, but their options are hidden in a drop-down until opened. Slicers display choices as buttons, making the active selection easier to see and use. A slicer takes more worksheet space, so a field filter may be a better fit for a dense analysis sheet or a field that users rarely change.

For date fields, a timeline can provide a visual time-range control, such as selecting months or quarters. A timeline is a separate PivotTable filtering control, not simply a date slicer with a different style. It requires a suitable date field in the PivotTable and is available through the PivotTable Analyze ribbon’s Insert Timeline command in supported desktop Excel versions. Use a regular slicer for discrete categories such as department, and consider a timeline when users need to select date ranges.

Neither control changes the source records. They filter which records contribute to the PivotTable’s displayed summary. If the underlying data has been edited, refresh the PivotTable so it reflects those edits; filtering alone is not a substitute for refreshing.

Common problems and fixes

The chart does not change. Confirm that it is a PivotChart linked to the PivotTable controlled by the slicer. A standard chart based on a cell range will not respond to a PivotTable slicer automatically.
A PivotTable is missing from Report Connections. Check whether it shares a compatible cache or Data Model connection with the slicer’s PivotTable. Similar source data is not enough to ensure a shared connection.
New source records do not appear. Refresh the PivotTable using PivotTable Analyze > Refresh, or use Data > Refresh All to refresh workbook connections and PivotTables. If the source range does not include the new rows, update the source or use a well-structured Excel table as the source.
Old categories remain in the slicer. Refresh the PivotTable and inspect its source data. PivotTable retention settings can preserve items that no longer appear in the current source; check PivotTable Options and its Data settings if stale items remain.
The desired item is unavailable. Another slicer or filter may exclude records that would make that item relevant. Clear other filters to check, then review the source records and the slicer’s display settings.
The slicer is hard to use. Enlarge it, add columns, choose a clearer style, or shorten source labels where appropriate. Keep readable button text rather than squeezing a long list into a narrow area.

Excel on Mac and Excel for the web

The steps and ribbon names above are for Excel for Microsoft 365 on Windows. Excel for Mac also supports PivotTable slicers in current versions, but the ribbon arrangement and contextual tab names can differ. Select the PivotTable and look for the PivotTable Analyze or PivotTable tab and its Insert Slicer command; select the slicer to find its formatting and connection options. If an option is not visible, check that Excel is updated and that the selected object is a PivotTable or slicer.

Excel for the web can display and interact with many existing slicers, but authoring and management capabilities may differ from desktop Excel and can depend on the workbook and feature support. For creating or troubleshooting slicer connections, use the desktop app when the relevant command is unavailable in the browser. A workbook’s data source or organizational settings can also limit refresh behavior.

Frequently Asked Questions

Can I add a slicer directly to a regular Excel chart?
A regular chart does not connect to PivotTable slicers. Create a PivotTable and PivotChart from the data, then insert a slicer for a field in that PivotTable, or build another mechanism that filters the chart’s source range.

Why is my PivotChart slicer not filtering the chart?
Check that the chart is a PivotChart linked to the PivotTable controlled by the slicer. If the chart is connected but still shows unexpected results, check the slicer’s selection, other filters, and whether the PivotTable has been refreshed after source-data changes.

Can one slicer control two PivotCharts?
Yes, if their PivotTables can share the slicer’s compatible PivotTable cache or Data Model connection. Select the slicer, open Report Connections, and select the relevant PivotTables. The charts follow their respective PivotTables.

How do I select more than one slicer item?
Use the slicer’s multi-select control and click each item you want included. In many Excel layouts, Ctrl-click also adds or removes selections. To return that field to all items, click the slicer’s clear-filter icon.

Can I use a slicer to filter dates?
Yes. A slicer can filter a date field by its available items. For selecting a continuous period, a PivotTable timeline is often easier to use; insert one from PivotTable Analyze > Insert Timeline when the field and Excel version support it.

Do slicers update when I change the source data?
They reflect the PivotTable’s current data, so refresh the PivotTable after editing or adding records. Also verify that the PivotTable source range includes new rows; a refresh cannot include records outside its source.

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.