Google Sheet users can now do more with the new Slicer feature on the platform. In one of our previous tutorials, we used checkboxes to control what data is displayed in our charts. In this tutorial, we will do the same thing but using the Slicer.
Here are the steps:
Step 1: Create a sheet containing the data to be displayed in the chart. Make sure that each column will contain a data point. Google Sheets will process it as an entry on the x-axis. Also, make sure that the column containing the row headings for specific data has its own header. For our example, I added a “Metrics” header to the column containing the row headers. This will be important later on.
Step 2: Insert a chart that will use the data from the sheet. You can check our tutorial on creating charts here if you need a refresher.
Step 3: Click on any cell inside the table, and then insert a slicer by clicking Data and then Slicer.
Step 4: A sidebar will be loaded on the right side, prompting you to select a column. Select the column containing the row headers. For this example, I will select Metrics.
Step 5: After selecting the column, click on the inverted triangle in the Slicer widget. By default, the Filter by values is selected, with a list of row headers, all checked.
To select which ones to hide, uncheck the row headers you don’t want to be included, then click Ok. For example, if I only want the Total profit displayed, then I will uncheck all the other entries and then click Ok. If you want to include the unchecked item, just click the entry and it will be checked again. Here’s the result:
You can do much more with the Slicer + Charts to create more flexible and interactive workbooks in Google Sheets!
However, if you're having a hard time pulling all your data for the month and importing it onto Google Sheets, consider trying Lido. Not only do we automatically load your selected data from various platforms, but we also have a robust report creator that includes similar functions to the Google Sheets' Slicer.
-Finding the Slope in Google Sheets
-Flipping X and Y Axes Google Sheets
