How to Filter Chart in Excel Mac

Filtering a chart in Excel is one of the quickest ways to zero in on the story your data is telling. Instead of creating brand new charts for every little subset of data, you can build one and dynamically show different views. We'll walk you through several methods to filter charts in Excel for Mac, from the simple built-in tool to more advanced, interactive dashboard techniques.

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

First, Understand How Charts and Data are Linked

Before diving into the "how-to," it's important to grasp a core concept: an Excel chart is just a visual representation of your source data. When you "filter a chart," what you're really doing is hiding some of the source data temporarily, and the chart automatically updates to reflect only the visible data. This is great news because it means your original data is always safe, and filtering is non-destructive.

For our examples, let's use this simple marketing campaign performance data:

From this data, we've created a simple column chart showing Spend vs. Conversions for each channel.

Now, let's look at how to filter this chart to get more specific insights.

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

Method 1: Use the Built-in Chart Filter Icon

In modern versions of Excel for Mac (part of Microsoft 365), you get a handy set of icons right next to your chart for quick edits. One of them is a filter designed for this very purpose. This is the fastest and most direct way to filter your chart view without touching your source data table at all.

Step-by-Step Instructions:

1. Select the Chart: Click anywhere on your chart to select it. You'll see a border appear around it, and three icons will pop up on the right side.
2. Click the Filter Icon: The filter icon looks like a small funnel. Click on it to open the Chart Filters pane.
3. Choose What to Display: The filter pane has two main tabs: Values and Names (though these can be labeled differently, like Series and Categories, depending on your chart type).
4. Apply Your Changes: After unchecking the boxes for the data you want to hide, click the Apply button at the bottom of the filter pane. Your chart will instantly update.

For example, if we wanted to compare the performance of only PPC and Social Media, we would uncheck "Email" and "Content" under Categories and click Apply. The chart would immediately re-draw to show just those two channels, making the comparison easier to see.

• Pros: Incredibly fast, intuitive, and doesn't affect the visibility of your source data table.
• Cons: This feature might not be available on much older, non-subscription versions of Excel for Mac.

Method 2: Filter the Source Data using AutoFilter

This is an old-school, rock-solid method that works in virtually all versions of Excel. It involves applying filters directly to your data table headers, which in turn updates the chart.

Step-by-Step Instructions:

1. Select a Cell in Your Data: Click any single cell within your data range (like A1 or B4 in our example).
2. Turn on AutoFilter: Go to the Data tab in Excel's ribbon and click the large Filter icon. Little dropdown arrows will appear in each of your header cells (Month, Channel, Spend, etc.).
3. Apply Filters to Your Data: Click the dropdown arrow for the column you want to filter. For instance, to only see "Email" and "PPC" data:

As soon as you apply the filter, your data table will instantly hide the rows for "Social Media" and "Content." Simultaneously, your chart will automatically update to display only the data for "Email" and "PPC."

• Pros: Very powerful, works in all Excel versions, allows for complex filter logic (e.g., filter Spend > $1,000 AND Channel is "PPC").
• Cons: This method hides rows in your data table, which might not be ideal if you want to see all your data and the filtered chart at the same time.

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

Method 3: Format as a Table and Use Slicers for Interactive Filtering

For creating a report or dashboard that others will use, Slicers are the gold standard. They provide clear, interactive buttons for filtering, which is far more user-friendly than dropdown menus. To use Slicers, you first need to format your data range as an official Excel Table.

Step 1: Convert Your Data to an Excel Table

1. Click any cell within your data range.
2. Go to the Insert tab and click Table. Or, even faster, use the keyboard shortcut Cmd + T.
3. A small dialog box will appear to confirm the data range. Ensure the "My table has headers" box is checked, and click OK.

Your data range will now have alternating colored rows, and the filter dropdowns will be automatically added. But the real power comes from the "Table Design" tab that now appears in the ribbon whenever you select a cell within the table.

Step 2: Insert and Use Slicers

1. Click inside your newly created table.
2. Go to the Table Design contextual tab that appears in the ribbon.
3. Click Insert Slicer.
4. A dialog box will pop up listing all of your column headers. Check the box for the columns you want to filter. For our example, let's check "Channel." Click OK.
5. A floating slicer object will appear on your worksheet. It's a small panel with buttons for each unique item in your "Channel" column (Email, Social Media, etc.).
6. Now, simply click a button in the slicer. Clicking "Email" will instantly filter the table AND the chart to show only data for the Email channel. You can select multiple items by holding down the Cmd key while clicking.

Slicers make your report feel like an interactive dashboard and are much more intuitive for people who may not be comfortable using Excel's regular filter dropdowns.

• Pros: Extremely user-friendly, highly visual, turns a static report into an interactive dashboard.
• Cons: It requires your data to be formatted as an official Excel Table, which is good practice anyway!

Method 4: Use PivotCharts for Ultimate Flexibility

When you have a large dataset and need to summarize and filter in complex ways, a PivotTable and its corresponding PivotChart are the most powerful tools for the job.

A PivotChart is a chart that's built on top of a PivotTable. This means all the powerful filtering and data summarization capabilities of the PivotTable are directly connected to the chart.

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-by-Step Instructions:

1. Create a PivotTable: Select a cell in your data, go to the Insert tab, and click PivotTable. Click OK in the dialog box to create it in a new worksheet.
2. Build the PivotTable: In the PivotTable Fields pane, drag and drop the fields you need. For our example, you could drag "Channel" to the Rows area and both "Spend" and "Conversions" to the Values area.
3. Insert a PivotChart: With your cursor in the PivotTable, go to the PivotTable Analyze tab and click PivotChart. Choose the chart type you want (e.g., Clustered Column) and click OK.
4. Filter the PivotChart: A PivotChart has filter buttons built right in. You can click the "Channel" button directly on the chart to select or deselect the channels you want to see. Even better, you can connect a Slicer to a PivotTable (Insert > Slicer) for that clean, button-based filtering experience described in the previous method.

PivotCharts are ideal when your analysis needs go beyond simple visibility filters and require you to aggregate, summarize, and reorganize your data on the fly.

• Pros: The most powerful and flexible method for summarizing and visualizing large, complex datasets.
• Cons: Has a slightly steeper learning curve than the other methods.

Final Thoughts

Filtering charts in Excel for Mac opens up a new level of dynamic analysis, whether you're using the simple chart filter icon for a quick view or building a fully interactive dashboard with slicers and PivotCharts. Each method serves a different purpose, and understanding them allows you to choose the perfect tool for your specific task, making your reports more insightful and easier to understand.

Spending hours manually downloading CSVs, cleaning data in Excel, and applying just the right filters can often feel like a full-time job. We built Graphed to eliminate that friction completely. Instead of building these reports step-by-step, Graphed lets you securely connect your data sources—like Google Analytics, Shopify, or HubSpot—and then simply ask for what you need in plain English. You can ask, "Show me traffic source vs. conversions as a bar chart for last month," and get a live, interactive dashboard built for you in seconds, saving you all the manual effort.