Custom Spreadsheet Solutions
Productivity – powered by Excel

Filter a chart the easy way.

You can filter a chart, right on the chart. Select the graph and choose the filter button, the one that looks like a funnel. Choose which series or categories you want to be able to see. Select Apply.

Menu options when choose Filter on Excel chart.

Here is the original chart.

Bar Chart showing North, South, East, West bars.
Graph without filters

And here is the chart with North and South unselected.

Bar chart showing East and West only.
Same graph, but with North and South filtered out.