Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

 Google Sheets Tutorials

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 1: Click on a blank area of the chart

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 2: Click on the Chart Filters button next to the chart

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.

Step 3: Select Data Tables from the Chart Filters window

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.


Google Online Self-Paced Training Value Package Only $149


"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills BBB Profile