Excel PivotTable Slicer Does Not Filter All Charts: Fix

You connect a slicer to a PivotTable, but some charts on the same worksheet do not update when you click the slicer buttons. This happens because each chart must be explicitly connected to the same PivotCache or PivotTable that the slicer controls. Excel does not automatically link charts created from the same source data to an existing slicer. This article explains why the slicer skips certain charts and provides the exact steps to connect them so all charts respond to slicer selections.

Why a Slicer Does Not Control All Charts

A slicer is a visual filter that connects to one or more PivotTables and PivotCharts that share the same PivotCache. When you create a PivotTable and then insert a PivotChart from that same PivotTable, both objects reference the same cache. The slicer you add to the PivotTable does not automatically connect to any existing PivotCharts. You must manually add the chart to the slicer’s connection list.

The PivotCache Requirement

Every PivotTable and PivotChart in Excel is built on a PivotCache, which is a memory object that stores the source data. If you create a second PivotTable from the same source range using the same worksheet, Excel often reuses the same cache. However, if you create a PivotChart by selecting a different range or by copying a PivotTable, the cache may differ. A slicer can only filter objects that share the identical cache.

Chart Types That Work With Slicers

Only PivotCharts — charts created from a PivotTable — can be connected to a slicer. Standard charts that you create from raw data using Insert > Chart do not have a PivotCache and will never appear in the slicer’s Report Connections dialog. If you need a standard chart to respond to slicer selections, you must convert it to a PivotChart or use a different filtering method such as worksheet filters or formulas.

Steps to Connect a Slicer to All PivotCharts

Follow these steps to link an existing slicer to every PivotChart that should respond to filter selections.

1. Select the slicer that is not filtering all charts
   Click the slicer once to activate the Slicer tab on the Ribbon. If you have multiple slicers, repeat these steps for each one.
2. Open the Report Connections dialog
   On the Slicer tab, click Report Connections. Alternatively, right-click the slicer and choose Report Connections from the context menu.
3. Check the boxes for all PivotCharts and PivotTables
   In the Report Connections dialog, you will see a list of all PivotTables and PivotCharts in the workbook that share the same PivotCache as the slicer. Place a check mark next to each item you want the slicer to control. Click OK.
4. Test the slicer on all charts
   Click any slicer button. Every PivotChart and PivotTable you checked should update immediately. If a chart does not change, it does not share the same cache or is not a PivotChart.

If the Chart Does Not Appear in Report Connections

When a chart does not show up in the Report Connections list, the cause is almost always one of two things: the chart is a standard chart, not a PivotChart, or the PivotChart uses a different PivotCache. To verify, right-click the chart and select Change Chart Type. If the Chart Type dialog shows “PivotChart” in the title bar, it is a PivotChart. If not, you need to create a new PivotChart from the PivotTable.

How to Create a PivotChart That Shares the Same Cache

1. Select any cell inside the existing PivotTable
   This ensures the new chart uses the same PivotCache.
2. Go to Insert > PivotChart
   On the Insert tab, click PivotChart. Choose a chart type and click OK. The new chart will automatically appear in the slicer’s Report Connections list.
3. Repeat the Report Connections step
   Open the slicer’s Report Connections dialog and check the box for the new PivotChart.

If the Slicer Still Does Not Filter All Charts

Chart and PivotTable Are on Different Worksheets

A slicer can control PivotCharts and PivotTables on any worksheet in the same workbook. If the chart is on a different worksheet, it still appears in Report Connections as long as it shares the same cache. Verify that the chart is a PivotChart and that both the PivotTable and chart were created from the same source data.

Multiple Slicers for the Same Field

If you have two slicers that both filter the same field, they will stay in sync automatically. However, if you want one slicer to control all charts and the other to control a subset, you must configure each slicer’s Report Connections individually. A chart can be connected to more than one slicer, but each slicer must have its own connection list set.

PivotTable and Chart Use Different Source Ranges

If you created a PivotTable from range A1:D100 and then created a second PivotTable from range A1:D200, each has its own cache. A slicer connected to the first PivotTable cannot filter the second chart. To fix this, delete the second PivotTable and create it from the same source range as the first, or use the same PivotTable as the basis for the chart.

PivotChart Slicer vs Standard Chart Filtering: Key Differences

Item	PivotChart with Slicer	Standard Chart with Filter
Data source	PivotCache from a PivotTable	Raw worksheet range or table
Filtering mechanism	Slicer connected via Report Connections	Worksheet filter, table filter, or formula
Cache sharing	Requires identical PivotCache	Not applicable — each chart reads source data independently
Multiple chart update	One slicer can update many charts sharing the same cache	Each chart must be filtered individually or via a common table
Ease of setup	Must manually connect slicer to each chart	Filter the source table, and all charts based on that table update

Now you can connect a slicer to every PivotChart in your workbook by opening the Report Connections dialog and checking the appropriate boxes. Next time you build a dashboard, create all PivotCharts from the same PivotTable to keep them on the same cache. For advanced control, use the Slicer Connections button on the PivotTable Analyze tab to manage multiple slicers at once.