How to Hide Filter Buttons in Excel Chart

Filter buttons hovering on your Excel chart can be a useful tool for quick data slicing, but they can also be a visual distraction, cluttering up a clean chart you've prepared for a presentation or report. Thankfully, hiding them is straightforward. This tutorial will walk you through several methods to remove those filter buttons, giving you full control over your chart's appearance.

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

Why Hide Filter Buttons on an Excel Chart?

Before jumping into the "how," let's quickly cover the "why." You're not just being picky, there are good reasons to remove those floating grey buttons:

• Cleaner Aesthetics: The most common reason is to create a professional, polished look. Extra buttons can make a chart look busy and divert attention from the data itself. A clean chart is easier to read and looks better in a dashboard, a PowerPoint slide, or a printed document.
• Prevent Unintended Changes: When you share a workbook, you may not want others to accidentally click a filter and change the data view. Hiding the buttons prevents end-users from altering the intended analysis, ensuring everyone sees the same information.
• Improved Focus: Your chart is designed to tell a story or highlight an insight. The filter buttons are a functional element, not part of the narrative. Removing them helps your audience focus solely on the data and the message you want to convey without being distracted by interactive elements.

Method 1: The Quickest Way Using Chart Elements

For a single chart, the fastest way to hide the filter buttons is by using the context-sensitive menu that appears when you select your chart.

Here’s the step-by-step breakdown:

1. Select Your Chart: Simply click anywhere on your chart. You'll know it's selected when you see a border appear around it, along with three buttons on the top-right corner: a plus sign (+), a paintbrush, and a funnel.
2. Click the 'Chart Elements' Button: Click the plus sign (+) icon. This opens the "Chart Elements" menu, which gives you a checklist of all the components you can add or remove from your chart, like axes, titles, gridlines, and more.
3. Uncheck the Box: In the menu that pops up, scroll down and find the item labeled "Chart Filters." It will have a checkmark next to it. Simply click the checkbox to uncheck it.

Instantly, the chart filter button (the one that looks like a funnel) will disappear from the side of your chart, giving you a cleaner view. If you ever want to bring it back, just follow the same steps and re-check the box.

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 2: Use the Right-Click Menu

If you prefer using your mouse, the right-click menu offers another direct path to the same result. Some users find this even faster as you don't have to aim for the tiny + icon.

1. Select and Right-Click: First, select your chart. Then, right-click on the specific chart filter button you want to remove.
2. Choose 'Hide Chart Filter': A context menu will appear. The first or second option will be "Hide Chart Filter" or something similar depending on your Excel version. Click it.

Just like with the Chart Elements menu, the buttons vanish. This method is particularly useful if you want to be very direct and get rid of the button with just two clicks.

Method 3: A Special Trick for PivotCharts

PivotCharts are a bit different from standard charts. They are connected to a PivotTable and have multiple "Field Buttons" that serve as powerful, interactive filters directly on the chart. These can be overwhelming visually, but Excel gives you granular control over them.

Here’s how to hide field buttons on a PivotChart:

1. Select the PivotChart: Click on your PivotChart to activate it. You'll see two new tabs appear in the top ribbon: "PivotChart Analyze" and "Format."
2. Navigate to the 'PivotChart Analyze' Tab: Click on the "PivotChart Analyze" tab in the ribbon. This is where you find all the controls specific to PivotCharts.
3. Find the 'Field Buttons' Dropdown: Look for a group on the ribbon called "Show/Hide." Within this group, you'll find a button labeled "Field Buttons." This is a dropdown menu, so click the little arrow on it.
4. Hide the Buttons: From the dropdown menu, you have several options. You can hide specific types of buttons (like Legend or Axis buttons) or, for the cleanest look, simply click "Hide All."

All the grey filter buttons will be removed from your PivotChart at once, leaving you with a standard-looking chart that's perfect for static reports.

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 Quick Note on Printing and Exporting to PDF

It's important to know that even if the filter buttons are visible while you work, Excel is smart enough to hide them in most final outputs.

If you simply click away from the chart to deselect it, the buttons will temporarily disappear. When you then go to File &gt, Print or File &gt, Save As &gt, PDF, the buttons will not appear in the print preview or the final PDF file. Excel assumes you don't want interactive elements cluttering a static document. So, if your only goal is a clean exported document, you often don't need to do anything at all!

Bonus: Hiding PivotChart Buttons with VBA

If you find yourself creating multiple PivotCharts and repeatedly hiding their field buttons, you can automate the process with a simple Visual Basic for Applications (VBA) macro. This is perfect for standardizing reports.

Here's how to create a macro that hides all field buttons on every PivotChart on your current worksheet:

1. Open the VBA Editor: Press Alt + F11 on your keyboard (or Fn + Alt + F11 on some laptops) to open the VBA Editor.
2. Insert a New Module: In the VBA editor menu, go to Insert &gt, Module. A blank code window will appear.
3. Paste the Code: Copy and paste the following code into the module window:

Sub HideAllPivotChartFieldButtons()
    ' A simple macro to loop through all charts on the active sheet
    ' and hide the field buttons if the chart is a PivotChart.

    Dim chtObj As ChartObject

    For Each chtObj In ActiveSheet.ChartObjects
        ' First, we check if the chart is a PivotChart type
        If chtObj.Chart.ChartType >= xlPivotChart Then
            chtObj.Chart.ShowAllFieldButtons = False
        End If
    Next chtObj

End Sub

1. Run the Macro: Close the VBA Editor and go back to your Excel sheet. Press Alt + F8 to open the Macro dialog box, select HideAllPivotChartFieldButtons, and click "Run."

The code will instantly loop through all chart objects on your sheet and turn off the field buttons for any that are PivotCharts. It’s a huge time-saver for anyone who builds complex reports regularly.

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

Final Thoughts

Controlling the appearance of your Excel charts is a small but important step toward creating clear, professional reports. Whether you’re using the quick Chart Elements menu for a standard chart or the "PivotChart Analyze" ribbon for a PivotChart, hiding distracting filter buttons only takes a few clicks and greatly enhances the final look.

Of course, manually building and cleaning up charts is one of the more tedious parts of reporting. We built Graphed to eliminate that friction entirely. By connecting your data sources and simply describing what you want to see in plain English, you can generate clean, professional, and real-time dashboards in seconds. You don't have to worry about tweaking small design elements because the visualizations are designed for clarity from the start, letting you focus on the insights, not the formatting.