How to Filter Charts in Google Sheets |
Onec you have created a chart in Google Sheets, you may want to filter the information that is visible on your chart to focus on specific details or data points. This tutorial will teach you how to filter your Google Sheets chart.
Step 1: Click on a blank area of the chart
Use the cursor to click on a blank area on your chart. Make sure to click on a blank area in the chart. The border around the entire chart will become highlighted. Once you see the border appear around the chart, then you know the chart editing features are enabled.
Step 2: Click on the Chart Filters button next to the chart
Once the chart name area is highlighted, you will see the Chart Filters button next to upper right hand side of the chart. The button looks like a funnel. Doing this will open the Chart Filters window.
Step 3: Select the data you want to appear in the Chart Filters window
Once you have opened the Chart Filters window, you will see a number of items you can select or deselect to filter your chart data. Once you have made your changes, click the Apply button and your changes will appear on the chart.
Topic #11
How to Make Trendlines in Google Sheets Charts
Thanks for checking out this tutorial. If you need additional help, you can check out some of our other free Google Sheets Chart tutorials, or consider taking an Google Sheets class with one of our professional trainers.
Guide Topics
- How to Make a Chart or Graph in Google Sheets
- How to Change the Chart Type in Google Sheets
- How to Move and Resize Charts in Google Sheets
- How to Change the Chart Style in Google Sheets
- How to Add a Title to a Chart in Google Sheets
- How to Add a Legend to a Chart in Google Sheets
- How to Add and Remove Gridlines in Google Sheets
- How to Add Axis Labels to a Chart in Google Sheets
- How to Make Trendlines in Google Sheets Charts