Excel Chart Slicers: How They Work and How to Add Them

An Excel chart slicer is a clickable control that filters chart data, so a reader can focus on selected categories without changing the chart’s layout or editing its source data. In Microsoft 365 for Windows, add one to a PivotChart through PivotTable Analyze > Insert Slicer, or add one to an Excel table through Table Design > Insert Slicer and build a chart from that table.

What a chart slicer does

A slicer is a set of labeled buttons for filtering data. For example, a sales report might have buttons for North, South, East, and West. Clicking North filters the connected data to that region, and a connected chart updates to show the remaining records. The slicer also makes the current selection visible, unlike a filter dropdown that can be less apparent to someone viewing the worksheet.

A slicer does not independently edit a chart or create a new analysis. It filters a supported data source, and the chart reflects that source’s filtered state. The two common setups are a PivotTable with a PivotChart, and an Excel table with a regular chart based on the table’s data. This distinction matters: a slicer cannot simply be attached to any chart made from an arbitrary cell range. If the chart is based on a plain range, first organize the range as a table or build a PivotTable-based report.

Slicers are useful for interactive dashboards, recurring reports, and workbook handoffs. A manager can select a product or time period without knowing how the chart was built. They are less useful when the report has only one obvious view, or when many filter buttons would take up more room than the chart itself.

Choose between a table and a PivotChart

Use a table slicer when the source is a straightforward list of records and you want to filter those records directly. For instance, a table with Date, Region, Product, and Revenue columns can have a Region slicer. A regular chart whose source is that table can respond as the table rows are filtered. This approach is simple and often suits a compact report.

Use a PivotTable and PivotChart when you need summarized results, such as total revenue by month and product, rather than a chart of every transaction. A PivotChart is tied to its PivotTable, so a slicer connected to that PivotTable can filter the summary and chart together. PivotTables also allow fields to be rearranged and summarized without building separate summary formulas.

Table slicer: best for filtering individual records and a regular chart based on the table.
PivotChart slicer: best for filtering an aggregated report, such as sales totals by region and month.
Timeline: a date-oriented filter for PivotTables, useful when selecting date periods is more convenient than clicking individual date labels.

For example, a sales table can feed a PivotTable with Month in Rows, Product in Columns, and Revenue in Values. A PivotChart based on that summary can show monthly totals. A Region slicer then lets a viewer compare the same chart for one region or several regions. The source data remains intact; the filter changes what the report displays.

Add a slicer to a PivotChart

In Excel for Microsoft 365 on Windows, create the PivotTable and PivotChart first. Select a cell in the PivotTable so Excel displays the PivotTable tools, then follow these steps:

Select PivotTable Analyze > Insert Slicer.
In the Insert Slicers window, check the field or fields you want to filter by, such as Region or Product, and select OK.
Move and resize the slicer beside the chart. Click a button to filter the connected PivotTable and PivotChart.
To remove the filter, use the clear-filter icon in the slicer header, usually shown as a funnel with a red mark.

If you select the PivotChart rather than the PivotTable, Excel may show PivotChart Analyze tools; the available slicer command can depend on the selected object and ribbon layout. Selecting a cell in the associated PivotTable is a reliable way to find the PivotTable Analyze command. A slicer can filter fields present in the PivotTable’s source, even if that field is not currently displayed as a row or column, provided it is available to that PivotTable.

Add a slicer to an Excel table chart

For a regular chart, first make sure its source records are an Excel table. Select a cell in the dataset and choose Insert > Table, or press Ctrl+T on Windows and confirm whether the table has headers. Then select a table cell and choose Table Design > Insert Slicer. Check a field, such as Region, and select OK. Create or retain a chart whose data comes from the table; filtering the table then filters the records represented in the chart.

Arrange the slicer and chart so the buttons do not cover the data. To change the slicer’s appearance, select it and use the Slicer tab’s styles and settings. The exact ribbon arrangement can vary with window size and Excel updates. A slicer can be resized, moved, and given a different number of button columns, which can make a long list of categories easier to scan.

On Mac, current desktop editions of Excel also support slicers, though ribbon labels and placement can differ from Windows. Excel for the web can display and use many existing workbook slicers, but some creation or design options may not be available in every web experience. If you cannot find the insert command, open the workbook in the desktop app and select the table or PivotTable itself before looking for the relevant Design or Analyze tab.

Connect one slicer to multiple reports

A slicer can control more than one PivotTable when those PivotTables share a compatible source and PivotTable cache, or are based on the same Data Model. Select the slicer, open the Slicer tab, and choose Report Connections (called PivotTable Connections in some Excel versions). Check the PivotTables the slicer should control and confirm. The connected PivotCharts follow their associated PivotTables.

If a report is missing from the connections list, the PivotTables may not share the same cache or compatible data model. Creating each PivotTable separately from the same-looking range does not always make them share a cache. One practical approach is to copy an existing PivotTable before rearranging its fields, or to build reports from a common Data Model when the workbook requires broader connections. A table slicer and a PivotTable slicer are not interchangeable connections: do not assume one control can filter unrelated table and PivotTable sources at once.

Before connecting reports, decide whether the same filter should apply to all of them. A Region slicer that controls a chart of sales and a chart of returns can be helpful; connecting it to an unrelated report can silently remove data that viewers expect to see. Test the slicer in each intended state after setting its connections.

Make slicers clear and practical

A good slicer is easy to interpret and does not overwhelm the chart. Use familiar field names, short category labels, and a small number of meaningful filters. If a field has dozens of unique values, a slicer may become tall and awkward; consider a broader grouping, a PivotTable filter, or a different report design instead. Place related slicers together and label the surrounding dashboard so viewers know whether they are looking at revenue, units, or another measure.

For multiple selections, use the slicer’s multi-select control if it is shown, or hold Ctrl while selecting additional buttons in Windows. On Mac, the equivalent selection modifier can differ by Excel version and keyboard; use the slicer’s multi-select control when available. To return to all categories, clear the filter rather than clicking each selected button one by one.

Keep the workbook’s data current as well. A table expands when new records are added directly below it, but a PivotTable generally needs refreshing to include changed or added source records. Use Data > Refresh All to update workbook connections and PivotTables, then verify that the new categories appear in the slicer. A slicer cannot show a category that is absent from the refreshed source.

Common problems and fixes

If the slicer filters the table but the chart appears unchanged, check that the chart actually uses the table’s data and that it is not plotting hidden rows. Select the chart and open Chart Design > Select Data, then inspect Hidden and Empty Cells. If Show data in hidden rows and columns is enabled, the chart may continue to include filtered-out rows; turn it off when the chart should follow the table filter.

If a slicer button appears to do nothing, check whether the field contains the values you expect, whether another filter is also active, and whether the slicer is connected to the intended PivotTable. In a PivotTable report, also refresh the data if records have changed. If a new category is missing, verify that it exists in the source and is included in the PivotTable’s current source range or table.

Other common snags include slicers covering chart labels, buttons being too small to read, and a dashboard opening with an unexpected filter still selected. Resize the control, use fewer columns or a shorter list, and clear filters before saving if the workbook should open in a neutral state. Slicer selections are part of the workbook view, so save after choosing the state you want readers to see by default.

Slicers compared with other filters

Filter dropdowns on a table or PivotTable are compact and familiar, but they are less prominent and can take more clicks to inspect. Slicers use more worksheet space, yet make the active categories easier to see and select. This visibility is the main reason slicers work well in dashboards shared with people who may not know Excel’s filter controls.

A PivotTable report filter can show one selected value above a summary, while a slicer presents several selectable values as buttons. A timeline provides a more natural way to choose date ranges for a PivotTable, but it is not a general-purpose replacement for a slicer on any chart. If you need a custom interaction that filters arbitrary chart ranges or applies complex logic, alternatives include restructuring the data as a table or PivotTable, using formulas to create a dynamic chart source, or building a more specialized report. The simplest supported setup is usually easier to maintain than a custom workaround.

Frequently Asked Questions

Can I add a slicer directly to any Excel chart?
No. A slicer filters a supported table or PivotTable, not an arbitrary chart by itself. Use a table as the chart source, or create a PivotChart based on a PivotTable, then add the slicer to that data source.

Can one slicer control two charts?
Yes, if both charts are PivotCharts whose PivotTables are connected to the same slicer through Report Connections. For regular charts, a slicer filters the table they use; each chart must use data that responds to that table filter.

Can a slicer filter dates?
Yes. A regular slicer can filter a date field by its listed values. For a PivotTable, a timeline is often more convenient for selecting date ranges such as months, quarters, or years.

Why is my new category missing from the slicer?
Check that the category is in the source data and refresh the PivotTable if the report uses one. Also check the table or PivotTable source range to confirm it includes the new records.

Can I use slicers in Excel for the web?
You can interact with many slicers in workbooks opened in Excel for the web, but creation and formatting options can vary. Use the desktop version if the command or design feature you need is unavailable online.

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.