Once you have created a chart in Excel, 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 Excel 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.
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.
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.
Thanks for checking out this tutorial. If you need additional help, you can check out some of our other free Excel Chart tutorials, or consider taking an Excel class with one of our professional trainers.