Excel Pivot Chart: How to Remove Filter Buttons Easily

To remove filter buttons from an Excel PivotChart in Microsoft 365 for Windows, select the chart and choose PivotChart Analyze > Show/Hide > Field Buttons > Hide All. This hides the buttons from the chart without deleting the PivotTable, changing its data, or turning off its filters.

What PivotChart filter buttons are

The gray labels and drop-down arrows displayed over or beside a PivotChart are called field buttons. They let a viewer filter or rearrange the fields used to build the chart. Depending on the chart and PivotTable layout, you might see buttons for categories, series, report filters, or values. For example, a chart of quarterly sales by region might show a Region button and a Quarter button.

These controls are part of the PivotChart interface, not ordinary chart labels or data. That distinction matters: hiding field buttons is a display choice, not a way to remove the underlying fields or permanently filter out records. The chart remains connected to its PivotTable and source data.

Field buttons also differ from the Field List pane, which is the panel used to choose or arrange PivotChart fields. Hiding chart buttons does not necessarily close the Field List. If that pane is open, close it separately using its close button or the Field List command on the contextual PivotChart Analyze tab.

Hide all buttons from the PivotChart

Click inside the PivotChart. Excel displays the contextual chart tabs on the ribbon.
Open PivotChart Analyze.
In the Show/Hide group, select Field Buttons.
Choose Hide All.

The buttons should disappear immediately. If you cannot see PivotChart Analyze, first click the chart itself; clicking a cell in the worksheet instead activates the ordinary worksheet tabs. Depending on the ribbon width, Excel may compress the Show/Hide group or its commands, so maximize the window or inspect the ribbon overflow if Field Buttons is not obvious.

To bring the controls back, select the chart again and use the same Field Buttons menu, then choose Show All. The hide/show setting applies to the selected PivotChart; it is not a workbook-wide switch for every PivotChart.

Hide only certain types of field buttons

You do not have to hide every button. In the Field Buttons menu, Excel offers choices for hiding specific classes of buttons, such as axis field buttons, legend field buttons, report filter field buttons, and value field buttons. The exact choices that are useful depend on the fields in that chart.

Suppose a PivotChart plots monthly revenue as columns, with product groups in the legend. You might keep the Month button so readers can change the displayed period, while hiding the Legend buttons if viewers should not change the product series. Select the relevant hide option rather than Hide All. To restore one type later, return to the menu and use its corresponding show command, or choose Show All if you want every field button visible again.

This selective approach is helpful when one control is useful but the full set makes the chart crowded. Check the result after applying it: some button types may overlap or occupy more space depending on the chart layout and the number of fields.

Hide buttons with the chart context menu

For a quick change, right-click a field button displayed on the PivotChart and select Hide All Field Buttons on Chart. This is a convenient alternative when the ribbon is minimized or you do not remember where the Field Buttons command sits. If the menu offers hide options for a particular button type, you can use those to keep other controls visible.

Be careful to right-click a field button rather than a data point, axis, or chart area. Those parts of the chart have different context menus. If the button has already been hidden, use the ribbon route to show it again; there is no button left on the chart to right-click.

What still works after the buttons are hidden

Hiding field buttons does not clear selections already applied to the PivotChart or its associated PivotTable. The chart continues to display the currently filtered results, and changes made through the PivotTable can still flow through to the chart. For instance, if the PivotTable is filtered to show two regions, hiding the chart buttons does not add the other regions back.

You can still filter the report through other controls. Use the drop-down fields on the connected PivotTable, or add a slicer when you want a visible, reader-friendly filter. A slicer is a separate object on the worksheet, so it can remain available even when the chart’s field buttons are hidden. Slicers can also be connected to compatible PivotTables or PivotCharts that share the same source or PivotCache; check the slicer’s Report Connections or PivotTable Connections settings when coordinating multiple reports.

The trade-off is discoverability. A reader looking only at the chart may not know that the displayed figures are filtered or how to change them. If the workbook is meant to be interactive, provide a slicer, a clearly labeled PivotTable filter, or a short instruction near the chart. If the chart is a static presentation element, hiding the buttons usually makes it cleaner.

If filter buttons remain visible

When the buttons seem to survive Hide All, check that you selected the PivotChart itself and changed its field-button setting. A regular chart may have a different control, such as the Chart Filters button that appears when the chart is selected. PivotChart field buttons are the gray field labels on the chart; the funnel-style Chart Filters control is not the same feature and does not use the PivotChart Field Buttons menu.

Also check whether you are looking at the PivotTable rather than the chart. Hiding buttons on a PivotChart does not remove the filter arrows from the PivotTable’s column headings or report-filter area. If the worksheet displays both objects, each has its own controls and purpose. Keep the PivotTable filters if users still need to change the report through that table.

If the Field Buttons command is unavailable, select a chart that is actually a PivotChart. A standard chart based on a range or an Excel Table does not have PivotChart field buttons. If it is a PivotChart but the ribbon does not show the command, confirm that the chart is selected and that Excel is displaying its contextual PivotChart Analyze tab. In a workbook opened in a browser, open it in the desktop Excel app if the relevant PivotChart controls are missing or limited.

Keep the chart clean without losing interactivity

Hiding buttons is one way to make a PivotChart easier to read, but it is worth deciding how people will interact with the report before removing every control. A chart with no visible filters can look polished, yet viewers may mistake a filtered result for a complete one. A concise note such as Data shown: North and West, or a slicer placed beside the chart, makes the current scope clearer.

For a dashboard, a common arrangement is to hide all chart field buttons, add one or two slicers for the important choices, and keep the PivotTable on a separate worksheet if readers need detailed filtering. Slicers use clear labeled buttons instead of small drop-downs and show which items are selected. They do occupy worksheet space, however, and they can make the workbook more complex if many filter fields are added.

For a chart that is only being printed or pasted into a presentation, hide the field buttons and retain the active filter state. Then check the chart at its intended size and confirm that titles, legends, and axis labels still explain what the figures represent. Hiding field buttons does not hide the legend, data labels, or chart title; those are separate chart elements.

Excel for Mac and Excel for the web

The instructions above target Excel for Microsoft 365 on Windows. Excel for Mac also uses contextual chart tabs when a PivotChart is selected, but ribbon layout and labels can vary by build. Look for the PivotChart Analyze tab and its Field Buttons control; if that command is not visible, expand the ribbon or check the contextual tab after selecting the chart. The Windows right-click instructions and ribbon placement should not be assumed to match every Mac release exactly.

Excel for the web may not expose the same PivotChart management commands as the desktop application, and available controls can vary as Microsoft updates the web app. If Field Buttons or the required hide option is absent, choose Open in Desktop App and make the change there. The workbook’s saved state can then be opened again in the browser.

Frequently Asked Questions

Can I remove PivotChart filter buttons without deleting the PivotChart?
Yes. Choose PivotChart Analyze > Show/Hide > Field Buttons > Hide All. The chart and its connection to the PivotTable remain in place.

Does hiding the buttons clear the filters?
No. It hides the controls on the chart, but the current filter selections remain. The chart continues to show the results for those selections.

How do I get PivotChart filter buttons back?
Select the chart, open PivotChart Analyze > Show/Hide > Field Buttons, and choose Show All. You can also restore individual button types from that menu if you only hid some of them.

Can I hide just the legend or axis buttons?
Yes. Open the Field Buttons menu and choose the option for the button type you want to hide, such as axis or legend field buttons. The available choices depend on the fields used in the chart.

Why are filter arrows still visible in my PivotTable?
PivotTable filter controls are separate from PivotChart field buttons. Hide All applies to the selected chart, not to the associated table. Use the PivotTable’s own field settings if you want to change its controls.

Can viewers still filter a chart after I hide its buttons?
Yes, if the workbook provides another route, such as a connected slicer or the associated PivotTable’s filter controls. Hiding the chart buttons alone does not create a replacement control, so add one if viewers need to change the view.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.