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.
- Enter your dataset range in the Data Range parameter.
- Select the destination cell for the pivot table.
- Select Create.
2. Go to Data → Add a Slicer
- Now navigate to Data → Add a Slicer.
- 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.
3. Customise your Slicer
- Click on the 3 vertical dots.
- Click on Edit Slicer.
- Go to Customise → Background colour to differentiate your slicers.
Example: Filter Data Using Slicers in Google Sheets
- Go to Data → Add a Slicer.
- Filter out specific entries. Here, I have filtered out 5 Star Hotels from the Restaurant type slicer.
- 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.
- On the other hand, I have kept data of only Sunday and Wednesday in the Weekday slicer.
- 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:
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.