What are Slicers in Google Sheets?

Reading Time: 3 minutes
Example of filtered view using slicers

Objective

Learn how to use Slicers in Google Sheets and its variations.

Why use Slicers in Google Sheets?

To analyse huge datasets, one generally uses various filters to have different views of the data. However, these views change as soon as you change filter parameters. The slicer buttons remain on your sheet, so you can easily change filter parameters to analyse your data. Alternatively, you can perform a similar task using Filter Views.

How to use Slicers in Google Sheets to analyse data?

1. Create PIVOT tables of your data

  • Select your dataset.
  • Navigate to Insert → Pivot Table.

Create Pivot Table of your data
Figure 1: Create Pivot Table of your data
  • Enter your dataset range in the Data Range parameter.
  • Select the destination cell for the pivot table.
  • Select Create.

Verify parameters to create pivot table
Figure 2: Verify parameters to create pivot table

2. Go to Data → Add a Slicer

  • Now navigate to Data → Add a Slicer.

Add slicers
Figure 3: Add slicers
  • Verify that the range in the Data Range is the same as your pivot table range.
  • Select a column of interest to create a slicer.
  • Here, I have chosen Weekday.

Choose column for slicer
Figure 4: Choose column for slicer

3. Customise your Slicer

  • Click on the 3 vertical dots.
  • Click on Edit Slicer.

Edit your slicer
Figure 5: Edit your slicer
  • Go to Customise → Background colour to differentiate your slicers.

Style your slicer
Figure 6: Style your slicer

Example: Filter Data Using Slicers in Google Sheets

  • Go to Data → Add a Slicer.

Add new slicers
Figure 7: Add new slicers
  • Filter out specific entries. Here, I have filtered out 5 Star Hotels from the Restaurant type slicer.

Filter out rows
Figure 8: Filter out rows
  • Output is Average Order Value of Cafe, Fine Dine and Street side. You can see that in the pivot table on the left, as well as on the graph.

Filtered view using slicers
Figure 9: Filtered view using slicer
  • On the other hand, I have kept data of only Sunday and Wednesday in the Weekday slicer.

Filter out rows
Figure 10: Filter out rows
  • The output is data of selected days of the week, as seen in the pivot table in the bottom left corner of the image below:

Example of filtered view using slicers
Figure 11: Example of filtered view using slicers

See Also

Filter data in Google Sheets using Slicer | Slice Table rows conditionally: Learn how to Filter data in Google Sheets using Slicer.

How to Create a Drop-Down List in Google Sheets: Learn how to create drop-down lists in Google Sheets.

shalinamigo

←
→

Leave a Reply