How to Use Excel Slicers and Timelines to Filter Dashboards

If you build an Excel dashboard summarizing millions of dollars in regional sales using five different PivotTables and three PivotCharts, the standard way to filter that data is terrible. You have to click the tiny gray filter dropdown arrow at the top of each PivotTable, uncheck “Select All,” and check the specific region you want to see. Not only is this visually unappealing, but you have to repeat the process for all five PivotTables manually just to see the data for one region. To build truly interactive, professional-grade dashboards that executives can use with a single click, you must use Slicers and Timelines.

What is a Slicer?

A Slicer is a graphical user interface (GUI) button panel that floats on top of your spreadsheet. Instead of interacting with tiny dropdown menus, the user clicks large, color-coded buttons (e.g., “North,” “South,” “East,” “West”). When a button is clicked, the PivotTable instantly filters the data. The true power of a Slicer is that a single Slicer can be connected to multiple PivotTables simultaneously.

Step 1: Insert a Slicer

You must have at least one working PivotTable before you can insert a Slicer.

1. Click anywhere inside your existing PivotTable.
2. On the ribbon, navigate to the PivotTable Analyze tab.
3. In the Filter group, click Insert Slicer.
4. A dialog box will appear listing every column in your original dataset. Check the box for the category you want to filter by (e.g., “Region”).
5. Click OK.

A floating box will appear containing a button for every unique region in your data. Click one of the buttons, and watch your PivotTable instantly update.

Step 2: Connect the Slicer to Multiple PivotTables

If you have a PivotChart showing Sales by Product, and another PivotTable showing Sales by Salesperson, you want them both to update when you click the “North” region button.

1. Right-click the header of the Slicer (the top bar).
2. Select Report Connections…
3. A window will appear listing every PivotTable in your workbook.
4. Check the boxes next to all the PivotTables you want this Slicer to control.
5. Click OK.

Now, when you click “North,” every connected chart and table on your dashboard will instantly filter to show only Northern data. It acts as a master control switch.

Step 3: Insert a Timeline

Slicers are great for text categories (like Regions or Products), but they are terrible for dates. If you have three years of daily sales data, a Slicer will generate 1,095 individual buttons. To filter dates interactively, you need a Timeline.

1. Click inside a PivotTable.
2. Go to PivotTable Analyze and click Insert Timeline. (Excel will only show columns that contain officially formatted Date values).
3. Check the box for your “Order Date” column and click OK.

A horizontal slider will appear. It allows you to drag a bar to highlight specific timeframes (e.g., Q3 of 2023). Just like a Slicer, you can right-click the Timeline, select Report Connections, and link it to all your charts.

Step 4: Formatting Slicers for a Dashboard

By default, Slicers are a single vertical column, which takes up too much space on a dashboard. You can customize them to look like a horizontal navigation bar.

1. Click the Slicer to select it.
2. A new Slicer tab will appear on the ribbon.
3. Look for the Buttons group on the right side of the ribbon.
4. Change the Columns value from 1 to 4.

The buttons will instantly align horizontally. You can now drag the edges of the Slicer to make it wide and short, and place it at the very top of your dashboard. You can also use the Slicer Styles gallery on the ribbon to change the colors to match your corporate branding.

By combining Slicers, Timelines, and Report Connections, you transform a static spreadsheet into an interactive software application.