Connect Slicers to PivotCharts from the Data Model in WPS Spreadsheets
Question details
The user wants an existing slicer based on one related table to filter a PivotChart that uses fields from two tables in the same Data Model.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A PivotChart is built from two related tables connected by respondent ID, and an existing slicer is based on fields from the first table.
- Observed behavior
- The slicer does not list the PivotChart in its report connections, so the chart is not filtered by the slicer.
Open the workbook in WPS Spreadsheets and confirm that the PivotChart, its underlying PivotTable, and both respondent tables belong to the same Data Model. In the Relationships window, verify that the respondent ID relationship is active before adjusting slicer connections.
Connect the Slicer to the PivotTable That Feeds the PivotChart
Use this when the slicer is already created but the PivotChart does not appear under report connections.
In WPS Spreadsheets, slicers connect to PivotTables rather than directly to PivotCharts. A PivotChart inherits slicer filtering from its underlying PivotTable, so the connection must be enabled on that PivotTable.
Click the slicer that is based on the field from the first respondent table so that the Slicer contextual tab appears.
On the Slicer tab, click Report Connections or PivotTable Connections to open the connection dialog.
Check the box for the PivotTable that supplies the data to the PivotChart, then click OK.
Click the PivotChart or its underlying PivotTable, go to the Data tab, and choose Refresh All to apply the slicer connection.
Verify the Data Model Relationship and Slicer Field Table
Use this if the slicer still does not filter the PivotChart after enabling the underlying PivotTable connection.
Link Slicers to PivotCharts Through the Underlying PivotTable in WPS Spreadsheets
In WPS Spreadsheets, use Report Connections on the slicer to enable the underlying PivotTable, then verify the Data Model relationship so the PivotChart filters correctly.
- 1. Select the slicer: Open the workbook in WPS Spreadsheets and click the slicer that is based on the first respondent table.
- 2. Open Report Connections: On the Slicer tab, click Report Connections to see the available PivotTables.
- 3. Enable the chart's PivotTable: Check the underlying PivotTable that feeds the PivotChart and click OK.
- 4. Refresh the data: Select the PivotChart or its PivotTable and use Refresh All from the Data tab.
- 5. Test the slicer: Click a slicer item and confirm that the PivotChart updates to show only the related respondent records.
Frequently Asked Questions
Why doesn't my PivotChart appear in the slicer's report connections?
A slicer connects to PivotTables, not directly to PivotCharts. Select the slicer, open Report Connections, and enable the underlying PivotTable that the chart is based on.
How do I find the underlying PivotTable for a PivotChart in WPS Spreadsheets?
Select the PivotChart, open the PivotChart or PivotTable tool options, and check which PivotTable is referenced as its data source. Then connect the slicer to that PivotTable.
Why is the slicer still not filtering the chart after I enable the PivotTable connection?
Verify that the PivotTable and both respondent tables are in the same Data Model, that the respondent ID relationship is active, and that the slicer field comes from the correctly related table.
Can I connect one slicer to multiple PivotCharts?
Yes, as long as the PivotCharts share the same underlying PivotTable or their underlying PivotTables are all connected to that slicer through Report Connections.
Does WPS Spreadsheets support slicers and PivotCharts in .xlsx workbooks?
Yes, WPS Spreadsheets supports slicers, PivotTables, and PivotCharts and can open and edit .xlsx workbooks created in Microsoft Excel.
