How to Enable Chart Filter in Excel

Excel charts are a great way to visualize your data, but a static chart only tells part of the story. To truly explore your data and find meaningful insights, you need interactive filters. This guide will walk you through exactly how to enable and use chart filters in Excel, transforming your static reports into dynamic and exploratory dashboards.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Are Chart Filters and Why Should You Use Them?

A chart filter is an interactive control that lets you temporarily hide or show specific data points, series, or categories directly on the chart itself. Instead of creating dozens of separate charts to show different views of your data - one for Q1 sales, another for the East region, a third for a specific product - you can use one chart and let filters do all the work.

This feature, introduced in Excel 2013, adds a small funnel-shaped icon next to your chart. Clicking it opens a panel where you can check or uncheck the data you want to see.

So, why is this so useful?

• It Makes Your Charts Interactive: Filters turn passive viewers into active explorers. When you share a report, your team can click through different views to answer their own questions without needing you to create a new chart for every request.
• It Saves a Ton of Time: You no longer have to duplicate charts or manipulate the source data. Need to show performance without a specific outlier month? Just uncheck it. Want to compare two product lines? Hide the rest. It's that simple.
• It Leads to Better Insights: Interactivity encourages deeper analysis. By easily toggling between different data slices, you can spot trends, identify outliers, and compare performance in ways that are difficult with static visuals.
• It Keeps Your Reports Clean: Instead of cluttering your workbook with 15 different charts showing minor variations of the same data, you can consolidate them into one or two powerful, filterable visuals.

Imagine you have a chart showing monthly sales for four different regions. With filters, you can instantly answer questions like:

• "How did the North and West regions perform against each other in the second half of the year?"
• "What did our sales look like if we exclude the result from our big promotion in May?"

Answering these questions becomes a matter of a few clicks, not a major rework of your spreadsheet.

The Easiest Method: Using the Built-In Chart Filter Button

The most direct way to filter a chart is by using the on-chart controls that appear when you select it. This method is perfect for quick analysis and simple filtering without any extra setup.

Let's use a sample dataset showing monthly sales for three products: Alpha, Beta, and Gamma.

Example Data:

Step 1: Create Your Chart

First, create a basic chart. This filter feature works with most standard chart types like line, column, bar, and area charts.

1. Select your data range, including the headers (e.g., A1:D5 in our example).
2. Go to the Insert tab on the ribbon.
3. In the Charts group, choose the chart type you want. A Clustered Column or Line chart works well for this data.

Excel will instantly generate the chart and place it on your worksheet.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 2: Locate and Open the Chart Filters

Now, click once on the chart to select it. When you do, you should see three icons appear near the top-right corner of the chart: Chart Elements (a plus sign), Chart Styles (a paintbrush), and Chart Filters (a funnel).

Click on the Chart Filters icon. A new panel will slide out with filtering options divided into two sections: Series and Categories.

Note: If you don't see these icons, you may be using Excel 2010 or earlier. This feature is available in Excel 2013, 2016, 2019, 2021, and Microsoft 365.

Step 3: Filter Your Data by Series

The Series section controls the different groups of data being plotted. In our example, the series are "Product Alpha," "Product Beta," and "Product Gamma." They correspond to the columns of data in your source.

Suppose you only want to compare Product Alpha and Product Gamma. Here's how to do it:

1. In the Chart Filters panel, look under the Series heading.
2. You'll see checkboxes next to each product. By default, they are all checked.
3. Uncheck the box next to Product Beta.
4. Click the Apply button at the bottom of the panel.

Instantly, the bars or line representing Product Beta will disappear from your chart, giving you a clean view comparing the other two products. The original data in your spreadsheet remains untouched.

Step 4: Filter Your Data by Categories

The Categories section controls the labels along the horizontal axis (for column and line charts). In our example, the categories are the months: "Jan," "Feb," "Mar," and "Apr."

Let's say you want to see the performance for the first quarter only (January, February, and March).

1. With the Chart Filters panel still open, look under the Categories heading.
2. Uncheck the box next to Apr.
3. Click the Apply button.

The chart will now update to show data only for the selected months. You can combine these filters, too - for example, showing only Product Alpha and Product Gamma for just Q1.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

A More User-Friendly Option: Filtering Charts with Slicers

While the built-in filter icon is great for quick analysis, it's not the most intuitive option for end-users who might not be familiar with Excel's interface. For dashboards or shared reports, Slicers are a much better choice.

Slicers are basically large, interactive buttons that allow anyone to easily filter your data with a single click. To use them with a standard chart, you first need to convert your data range into an official Excel Table.

Step 1: Format Your Data as a Table

An Excel Table provides the structured data that Slicers need to work. Don't worry, this is simple.

1. Click anywhere inside your data range.
2. Go to the Insert tab and click Table, or just press the keyboard shortcut Ctrl + T.
3. A small dialog box will appear to confirm the data range. Make sure the "My table has headers" box is checked if your data has column titles. Click OK.

Your data range will now have alternating colored rows, and filter dropdowns will appear on the header row. You've successfully created a table!

Step 2: Insert a Slicer

Now that your data is in a Table, you can add a slicer.

1. Click anywhere inside your table.
2. Go to the Insert tab.
3. In the Filters group, click Slicer.
4. A dialog box will appear, listing all the columns from your table. In our running sales example, you might see "Month" and "Product". (Note: Slicers work best on category-based data. If your data is laid out with products in separate columns, you'll need to restructure your data to have a single "Product" column and a single "Sales" column for slicers to work effectively).

Data Restructuring for Slicers: Before vs. After

To make our data slicer-friendly an "unpivoted" format is much better.

Before:

After:

Step 3: Connect the Slicer to Your Chart

With your new data structure, create a chart again. Here's a tip: it's often best to create a PivotChart from your Table data, as Slicers integrate seamlessly with them.

1. Click inside your new, unpivoted Table.
2. Go to Insert > PivotChart.
3. Set up your PivotChart (e.g., Months in Axis, Product as a Slicer, Sum of Sales in Values).
4. With a PivotTable or PivotChart selected, go to Insert > Slicer, and select a field like "Product." A Slicer will appear with buttons for "Product Alpha," "Product Beta," and "Product Gamma."

Now, when you click a button on the slicer, the connected chart instantly updates. Clicking "Product Beta" will show only data for Product Beta. You can hold Ctrl to select multiple items, providing a seamless and highly professional way for users to interact with your dashboard.

The Power User Method: Using PivotChart Filters

If you're already using or are willing to use PivotTables, you have access to the most powerful filtering tools in Excel. A PivotChart is simply a chart based on a PivotTable, and it inherits all of its powerful filtering capabilities.

Step 1: Create a PivotTable and PivotChart

Start with a properly formatted dataset (like our "unpivoted" sales data above).

1. Select your data.
2. Go to Insert -> PivotChart. This will create both a PivotTable and a PivotChart at the same time.
3. In the PivotChart Fields pane, drag your fields to the appropriate areas. For instance:

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 2: Use the In-Chart Pivot Filters

Notice that your new PivotChart has several gray interactive buttons directly on it. These are your filters! You'll typically see one for your Axis fields and one for your Legend fields.

Clicking the button next to "Product," for example, will open a dropdown menu where you can check or uncheck which products to display - just like the regular chart filter, but it's part of the chart itself.

Step 3: Use the Filters Area and Slicers

For even more power, you can use the Filters area in the PivotChart Fields pane. Dragging a field here (for instance, a "Region" column if you had it) creates a master filter that controls the entire PivotTable and PivotChart. It appears as a dropdown menu above your chart, providing a clean way to filter everything at once.

And as we discussed, you can connect Slicers and Timelines (a special type of slicer for dates) for the absolute best user experience.

Final Thoughts

Mastering chart filters is a huge step toward making your Excel reports more dynamic and professional. Whether you use the simple on-chart filter button for quick analysis, slicers for user-friendly dashboards, or the integrated filters within PivotCharts for handling complex data, interactive visualizations help uncover insights that static charts leave hidden.

While Excel is incredibly powerful, building these interactive reports still requires manual steps: structuring data, inserting tables, configuring pivot fields, and designing slicers. At Graphed, we created a way to skip these hurdles and get straight to the insights. Instead of manually building and filtering reports, we let you ask for a dashboard using simple language. You can just ask things like, "Show me product sales for the last quarter by region," and get an interactive, real-time dashboard instantly - no PivotTables or slicer setup needed.