Link a Pivot Chart to a Slicer in Excel

To link a slicer to an Excel PivotChart, select the PivotTable or PivotChart, choose PivotTable Analyze > Insert Slicer, and select the field to filter. The slicer filters the PivotTable and its associated PivotChart; to control additional compatible PivotTables and charts, select the slicer and use Slicer > Report Connections.

How to add a slicer to a PivotChart

In Excel for Microsoft 365 on Windows, a PivotChart is linked to its underlying PivotTable. In most cases, you do not connect the slicer directly to the chart: you connect it to the PivotTable, and the chart updates when that table is filtered. Start with a PivotTable and PivotChart built from the data you want to explore. If you have not made them yet, select a cell in your source data and use Insert > PivotTable; after arranging the fields, select a cell in the PivotTable and choose PivotTable Analyze > PivotChart.

To add the slicer, select a cell in the PivotTable or select the PivotChart, then choose PivotTable Analyze > Insert Slicer. In the dialog, tick the field you want to filter, such as Region, Product, or Salesperson, and select OK. Excel places a slicer on the sheet. Click a button in it to filter the PivotTable and chart to that value. For example, a Region slicer can switch a chart of monthly sales between North, South, East, and West.

Click the PivotTable or its PivotChart.
Choose PivotTable Analyze > Insert Slicer and select one or more fields.
Move and resize the slicer so it is easy to use alongside the chart.
Click a slicer item and confirm that the PivotTable and chart show the expected filtered results.

If the chart does not respond, select the slicer and check its report connections, as described below. Also confirm that the chart is actually a PivotChart and not a standard chart built from copied or linked cells.

What the slicer connection does

A slicer is a visual filter for a PivotTable field. Selecting a slicer item applies a filter to the report, and the PivotChart reflects the changed PivotTable results. The slicer is therefore not a separate chart control; its connection is to one or more PivotTables. A PivotChart responds because it displays data from its associated PivotTable.

This distinction matters when a workbook contains several reports. One PivotTable may summarize revenue by month while another summarizes units by product. Even if both were made from the same source data, a slicer does not necessarily control both automatically. You must check whether each PivotTable is included in the slicer’s Report Connections list. If it is not listed, the reports may not share a compatible PivotTable cache or data connection.

Slicers show the available values as buttons, and the selected state makes the active filter visible. That is often clearer than opening a small filter menu on a PivotTable field. A slicer can also make a dashboard easier for someone else to use, since they can choose a region or category without rearranging the report fields.

Connect one slicer to multiple PivotCharts

To have one slicer filter several PivotCharts, connect it to each chart’s underlying PivotTable. Click the slicer, open the Slicer tab, and choose Report Connections. In the dialog, select the compatible PivotTables that the slicer should control, then choose OK. Depending on the workbook and Excel build, the command or dialog may be labelled PivotTable Connections instead. If a report is absent from the list, Excel cannot connect that slicer to it in its current form.

For example, imagine a dashboard with one PivotChart showing sales by month and another showing sales by product. If both PivotTables use the same source and compatible cache, a single Region slicer can filter both. Selecting West then updates both views to show West-region results. This makes comparisons useful: the charts retain different layouts while sharing the same filter selection.

When building a dashboard that needs shared controls, it is easiest to create the PivotTables from the same source and in a way that lets them share a cache. If you already have separate reports, check Report Connections before rebuilding anything. If a PivotTable is missing, compare how its source and connection were created with those of a report that does appear. A PivotTable built from a separate range, external connection, or distinct cache may require a compatible shared setup before the slicer can control it.

Choose useful fields and arrange the slicer

Choose a field whose values make sense as direct filter choices. Region, department, product category, and salesperson are common choices. A field with hundreds or thousands of distinct entries can make a slicer cumbersome; in that case, consider filtering on a broader category, adding a second level of navigation, or using the PivotTable’s field filter instead. Date fields may be easier to explore with a Timeline, which is designed for filtering dates in PivotTables.

Click the slicer to reveal its formatting and layout options. The Slicer tab lets you change the number of button columns, adjust the displayed button height and width, choose a slicer style, and set the slicer’s caption. A wider slicer can show long labels more clearly; multiple columns can reduce the height of a list. Keep enough space for the full set of choices, and avoid styling that makes selected and unselected buttons hard to distinguish.

Useful controls include the clear-filter icon in the slicer header, which removes the selection and returns the report to an unfiltered state, and the Multi-Select control, which lets users select more than one item. The exact icons can vary with the Excel build and slicer size. For a dashboard, label the slicer clearly and test the layout with both a single selection and multiple selections.

Common connection problems and fixes

If clicking a slicer does not change a chart, first determine whether the chart is a PivotChart. A standard chart can look similar, but it does not automatically listen to PivotTable slicers. Next, select the slicer and open Report Connections. Make sure the PivotTable that feeds the chart is checked. A slicer may filter one PivotChart while leaving another untouched simply because the second chart’s PivotTable is not connected.

If the relevant PivotTable does not appear in the connection list, check whether the PivotTables use compatible sources and caches. Two reports that happen to display the same data are not necessarily connected internally. Differences in source ranges, data connections, or the way the PivotTables were created can prevent a shared slicer connection. If the source range has grown, update the PivotTable’s source as appropriate and refresh it; a slicer cannot filter records that are not included in the PivotTable’s source.

Also try refreshing the PivotTable using PivotTable Analyze > Refresh, or refresh all workbook data with Data > Refresh All when appropriate. Refreshing updates report results from the source; it does not by itself repair an incompatible connection. If filters appear inconsistent, clear the slicer selection and inspect the PivotTable’s own filters as well. A report can have additional filters applied independently of the slicer.

PivotChart slicers versus regular chart filters

A PivotChart and a regular chart are different tools, even though both display chart elements such as axes, legends, and data series. A PivotChart is tied to a PivotTable and can respond to its field filters and slicers. A regular chart is usually based on a cell range or table; it will not appear as a PivotTable in the slicer’s Report Connections dialog and cannot be directly connected to a PivotTable slicer.

If your chart is a regular chart, you have a few options. You can create a PivotTable and PivotChart from the same source and use the slicer with that PivotChart. Or keep the regular chart and filter its source table using Excel table filters, formulas, or other dashboard design methods. Those approaches are not the same as connecting a regular chart to a slicer, and their setup depends on how the chart’s data is prepared.

PivotCharts are convenient for interactive summaries, but they inherit some PivotTable behavior and layout constraints. If you need exact control over a chart’s data range or formatting, a regular chart may be preferable. Choose based on whether the report needs PivotTable-style grouping and filtering or a more fixed chart presentation.

Excel on Mac and Excel for the web

On Excel for Mac, PivotTables and slicers are available in current Microsoft 365 versions, but ribbon labels and the placement of controls can differ from Windows. Select the PivotTable, look for the PivotTable or Slicer tab, and use the slicer insertion and connection controls available in that build. If you cannot find Report Connections, check that Excel is updated and that the selected object is a slicer associated with a PivotTable. Avoid relying on Windows-only keyboard shortcuts for these steps; the ribbon commands are the clearest route across platforms.

Excel for the web can support interaction with some PivotTable slicers, but the controls for creating, editing, or connecting slicers may differ or be more limited than in the desktop application. For initial setup or troubleshooting shared connections, open the workbook in Excel for Microsoft 365 on Windows or Mac. After setup, test the workbook in the environment where its intended users will open it, because available features can depend on the platform and workbook content.

Frequently Asked Questions

Can a slicer connect directly to a PivotChart?
No. A PivotChart responds through its associated PivotTable. Add the slicer to the PivotTable and, if needed, connect it to additional compatible PivotTables through Report Connections.

Why is my PivotTable missing from Report Connections?
It may use a different source, PivotTable cache, or data connection. The reports must be compatible for the slicer to control them. Compare how the PivotTables were created and whether they use the same underlying data setup.

Can one slicer control several charts?
Yes, when the charts are PivotCharts and their underlying PivotTables are compatible with the slicer. Select the slicer, open Report Connections, and check the PivotTables you want it to filter.

Can a slicer filter a normal Excel chart?
Not directly. A regular chart is not connected to a PivotTable in the same way as a PivotChart. Use a PivotChart, or choose another method to filter the data feeding the regular chart.

Does refreshing the PivotTable fix a slicer connection?
Refresh updates report data from its source, but it does not make incompatible PivotTables share a slicer. Refresh when source records have changed; use Report Connections to check which reports the slicer controls.

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.