We now have a perfectly good, working slicer. Our slicer will update to show the column name: In this example, let’s choose the “Side” column, which is the column containing data about whether the agent acted as a Buyer or Seller in the transaction. The first thing to do with a slicer is to select a column. If your cursor was outside the Pivot Table in another cell, you’ll be prompted to choose the data to use inside your slicer. If your cursor was inside the Pivot Table when you added a Slicer, it’ll be added automatically and you’ll see the default slicer control: If you’re new to Pivot Tables, have a read of Pivot Tables in Google Sheets: A Beginner’s Guideīack in the real estate dataset, insert a Pivot Table: Data > Pivot TableĬreate a simple Pivot Table in a new Sheet, for example this one shows property types and total sales price for each category:īack in the Data menu, choose: Data > Slicer

Start with this table of fictitious real estate data (from Sheet1 of the template above):

Slicer Template including the Home Sales Dashboard The Data (Note: you can absolutely choose more than one value at a time in your filter.) How do you add a Google Sheets slicer? Slicer Templateįeel free to make your own copy of this file (File > Make a copy…) You’ll also notice that the slicer has updated the drop-down to say “1 of 4” instead of “All”, to signify that we’ve filtered on one value (“Emma Johnson”) from a possible set of 4 names. The three pivot tables (labeled 1, 2 and 3 in the image below) and the chart (labeled 4) are all updated to just show the rows of data from our dataset that are associated with “Emma Johnson”.

In the Home Sales dashboard example above, we can click on the slicers to focus on a subset of agents and/or subset of lead sources.įor example, we might select “Emma Johnson” only, so that we can see data that is just relevant to this person. When you click on the drop-down arrow in the slicer, it brings up a filter menu: You’ll notice the two black boxes above the chart labeled “Agent Test Slicer” and “Lead Source”. It consists of three small pivot tables and a chart, displaying (fictional) data about house sales. Video: How Slicers Work And How To Add ThemĬonsider this basic dashboard in a Google Sheet. Slicers are extremely useful when building dashboards in Google Sheets. They make it easy to change values in Pivot Tables and Charts with a single click. Slicers in Google Sheets are a powerful way to filter data in Pivot Tables.

No scroll bar in excel timeline