Pivot Table Issues

How to Add Radio Buttons and Slicers to an Excel Pivot Chart

Nimra MalikNimra Malik Nov 4, 2026 869 views

Question details

The user wants to add interactive filtering controls, such as radio buttons or slicers, to an Excel Pivot Chart in older versions without relying on unsupported dynamic functions like FILTER or SWITCH.

How to Add Interactive Radio Buttons and Slicers to an Excel Pivot Chart
Product
Microsoft Excel 2016
Device & OS
not provided
Scenario
Creating an interactive Pivot Chart dashboard in Excel 2016 where newer filtering functions are unavailable.
Observed behavior
Seeking a practical method to filter Pivot Chart data interactively using option controls or slicers.
Before you start

Ensure your Excel Pivot Table and Chart are fully set up before adding interactive controls. Verify that your data source contains clean, clearly labeled columns to serve as filter categories.

Solution 1Recommended

Use Pivot Table Slicers as an Alternative to Radio Buttons

Slicers provide a modern, built-in, and highly interactive way to filter Pivot Charts without requiring complex formulas or VBA, making them ideal for Excel 2016 users.

Since Excel 2016 lacks the newer FILTER and SWITCH worksheet functions, using Slicers is the most efficient and visually appealing alternative to traditional form controls. Slicers function directly like buttons and seamlessly control the chart output.

1
Select the Pivot Chart

Click anywhere on your existing Pivot Chart or the linked Pivot Table.

2
Insert a Slicer

Navigate to the 'PivotChart Analyze' (or 'Analyze') tab on the Excel ribbon, and click on 'Insert Slicer' in the Filter group.

3
Choose Filter Fields

A dialog box will appear. Check the boxes corresponding to the data fields you want to use as filters, then click 'OK'.

4
Position and Format Slicer

Drag the Slicer box next to your Pivot Chart. You can adjust the number of columns in the Slicer ribbon tab to make the options display horizontally, mimicking traditional radio buttons.

Use Pivot Table Slicers as an Alternative to Radio Buttons
Slicer Behavior: Clicking an item in the Slicer visually acts like an interactive radio button, instantly updating both the Pivot Table and the linked Pivot Chart.
Seamless Data Analysis

Create Interactive Pivot Charts with WPS Spreadsheet

WPS Spreadsheet provides intuitive tools for building Pivot Tables and inserting Slicers. You can easily create highly interactive dashboards and filter your charts with visually appealing controls without needing advanced formulas.

  1. 1. Open Data: Open your data set in WPS Spreadsheet.
  2. 2. Create PivotTable: Select your data, go to the 'Insert' tab, and click 'PivotTable'.
  3. 3. Insert PivotChart: Generate a PivotChart from your summarized data using the Insert tab.
  4. 4. Add Slicers: Click on the PivotTable, go to the 'Analyze' tab, and select 'Insert Slicer'.
  5. 5. Filter Interactively: Choose your desired filter fields and use the Slicer blocks to control the PivotChart interactively.
Fully compatible with Microsoft Excel (.xlsx) formats and Pivot Table structures.Built-in Slicer support for interactive chart filtering without complex formulas.Lightweight software that runs smoothly on older devices.Free and user-friendly interface for immediate productivity.
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I use the FILTER or SWITCH functions in Excel 2016?

The FILTER and SWITCH functions are dynamic array functions introduced in newer versions like Excel 2019, Excel 2021, and Microsoft 365. Excel 2016 does not support them natively, which is why Slicers or Form Controls are recommended instead.

Can a single Slicer control multiple Pivot Charts?

Yes. You can link one Slicer to multiple Pivot Tables (and their associated Pivot Charts) by right-clicking the Slicer, selecting 'Report Connections', and checking the boxes for all applicable Pivot Tables sharing the same data cache.

How do I format Slicers to look like custom buttons?

Select the Slicer, go to the 'Slicer' tab on the ribbon, and choose from the Slicer Styles gallery. You can customize colors, hide the header via Slicer Settings, and adjust the column count to make the Slicer items appear as a horizontal row of buttons.