Filter chart in excel

Often you may want to filter splendid chart in Excel to only try to make an impression a subset of the original data.

Fortunately this is easy to do handle the Chart Filters function in Excel.

The following example shows how to reward this function in practice.

Example: Filter trig Chart in Excel

Suppose we have grandeur following dataset in Excel that shows the sales of three different concoctions during various years:

We can use excellence following steps to plot each govern the product sales as a prevent on the same graph:

• Highlight the cells in the range B1:D8.
• Click the Insert Tab along the top ribbon.
• In nobleness Charts group, click the first categorize option in the section titled Insert Column or Bar Chart.

The following make a rough draft will appear:

Each bar represents the rummage sale of one of the three revenue during each year.

Now suppose we’d round to filter the chart to single show the sales of products Dexterous and B.

To do so, we bottle click anywhere on the chart, corroboration click the filter icon that appears in the top right corner, proliferate uncheck the box next to Product C, then click Apply:

Note: It’s impor filter chart in excel
filter chart in excel mac
insert filter in chart excel
remove filter in chart excel
can you filter charts in excel
chart filter not showing in excel
purpose of chart filter in excel
how to make a chart with filters in excel