Chart & Visualization Issues

How to Connect an Existing Slicer to a New Data Model PivotChart

Huma Ashraf Ch Oct 10, 2026 869 views

Question details

The user is trying to connect an existing slicer to a newly created PivotChart, but the new chart does not appear in the Report Connections list.

How to Connect an Existing Slicer to a New Data Model PivotChart

Product: Spreadsheet
Device & OS: not provided
Scenario: Attempting to link an existing slicer to a new PivotChart to filter data across multiple charts simultaneously.
Observed behavior: The new PivotChart is missing from the slicer's Report Connections list because it was built on a regular table instead of the Data Model.

Before you start

Ensure that the data source you are working with is added to the Data Model. Slicers can only connect to multiple PivotCharts if they all share the exact same Data Model or data cache.

Solution 1Recommended

Create a PivotChart using the Data Model

Replace your existing normal chart or table-based PivotChart with one explicitly connected to the Data Model so the slicer can recognize it.

Slicers cannot control standard charts or PivotCharts built directly from simple tables without utilizing the Data Model. To fix this, you must recreate the chart using the correct data source.

Delete the incompatible chart

Select the normal chart or standard PivotChart that isn't appearing in the Report Connections list, and press the Delete key on your keyboard.

Create a new PivotChart

Go to the 'Insert' tab on the ribbon and select 'PivotChart'. When prompted for the data source, ensure you check the option to use the workbook's Data Model.

Connect the slicer

Right-click the existing slicer and select 'Report Connections'. Your new Data Model PivotChart should now appear in the list. Check the box next to it and click 'OK'.

Field Compatibility: If the chart still doesn't appear in the connections list, verify that both the PivotChart and the slicer are using compatible fields from the exact same Data Model.

Manage Data with WPS Spreadsheet

Create and Filter PivotCharts Effortlessly in WPS Office

WPS Spreadsheet provides powerful data analysis tools, allowing you to easily create PivotTables, PivotCharts, and connect Slicers to filter your data dynamically without complex data model configurations.

1. Open your data file in WPS: Launch WPS Spreadsheet and open your existing workbook containing the dataset.
2. Insert a PivotChart: Select your data range, navigate to the 'Insert' tab, and choose 'PivotChart' to summarize and visualize your data.
3. Insert and link a Slicer: Click on your PivotChart, go to the 'Analyze' tab, and select 'Insert Slicer'. You can easily connect it to multiple PivotCharts through the Report Connections setting.

Seamless compatibility with Microsoft Excel (.xlsx) files and advanced charting features.Intuitive interface for creating PivotCharts and managing Slicer connections.Lightweight application that handles large datasets smoothly.Free alternative for comprehensive spreadsheet data analysis.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my PivotChart not showing up in Report Connections?

This usually happens if the PivotChart was created from a regular table or range instead of the same Data Model or data cache as the slicer. Both the slicer and the PivotChart must share the exact same data source to be connected.

Can a single slicer control multiple PivotCharts?

Yes, a single slicer can control multiple PivotCharts as long as all the charts are built from the same data source. You can link them by right-clicking the slicer, selecting 'Report Connections', and checking the boxes for all applicable charts.

Are standard charts compatible with slicers?

No, standard charts (like a basic bar or pie chart inserted directly from a table) cannot be controlled by slicers. Slicers are specifically designed to filter PivotTables and PivotCharts.

Excel & Data Problems