Pivot Chart: Remove Filter Labels in Excel

To remove the filter labels from an Excel PivotChart, select the chart and choose PivotChart Analyze > Show/Hide > Field Buttons > Hide All. This hides the on-chart filter controls, not the filters themselves; your PivotChart can still be filtered through its PivotTable, slicers, or other available controls.

What Excel means by PivotChart filter labels

The small boxes or buttons displayed over a PivotChart are called field buttons. Depending on the fields in the underlying PivotTable, they can display names such as Axis, Legend, Values, or a report-filter field, often with a drop-down arrow. The arrow opens filtering options, while the button identifies the field associated with that part of the chart. People sometimes call these controls filter labels, chart filters, or PivotChart buttons.

These controls are different from the labels that form part of the chart’s presentation. Category names along an axis, a chart title, a legend, and data labels showing values on bars or lines are not field buttons. Hiding field buttons will not remove those elements. If the unwanted text is printed beside the columns or along the chart’s horizontal axis, you likely need to change the chart labels or the source field instead.

Field buttons are useful while exploring a report: a viewer can use them to include or exclude categories without opening the PivotTable. Once a chart is ready to present, though, the buttons may make it look cluttered or may invite viewers to change the view. Hiding them is a display choice, not a conversion of the PivotChart into an ordinary chart.

Hide every field button on the chart

In Excel for Microsoft 365 on Windows, use these steps:

Click the PivotChart. If the contextual chart tabs do not appear, click the chart again or make sure you selected the chart rather than a nearby cell.
Open the PivotChart Analyze tab on the ribbon.
In the Show/Hide group, open Field Buttons.
Choose Hide All.

The field buttons disappear from that chart. The chart title, axis labels, plotted data, and legend remain as they were. This command is generally the quickest option when the goal is a clean chart with no interactive field controls visible.

You can also right-click a field button directly on the chart and choose Hide All Field Buttons on Chart. This is convenient when the button is visible and you do not want to find the ribbon command. The wording and available options can vary slightly with the Excel build, but the ribbon’s Field Buttons menu is the main place to look.

Hide only certain button types

You do not have to hide every button. The Field Buttons menu can offer choices for hiding specific types, such as axis field buttons, legend field buttons, value field buttons, or report-filter field buttons. The exact choices depend on the PivotChart and the fields it uses. For example, a chart may not have a report-filter button to hide if no report filter is present.

Use the selective commands when viewers still need some controls. Suppose a chart has a year field on the horizontal axis and a region field in the legend. You might hide the axis field button to reduce clutter but leave the legend field button visible so a user can switch regions. Conversely, if users need to change the displayed year but should not rearrange the series, hide the legend button and keep the axis button.

After changing one type, inspect the chart at its normal viewing size. Buttons can overlap a title or occupy space near the plot area, and a setting that looks fine while editing may be distracting in a report or presentation. If you are unsure which button corresponds to which field, open the drop-down before hiding it and note the field name and selected items.

Field buttons are not the same as chart labels

A common source of confusion is that Excel uses the word label for several different chart elements. If you hide field buttons and the unwanted words remain, identify where they appear before changing anything else:

Drop-down boxes on the chart: These are PivotChart field buttons. Hide them through the Field Buttons menu.
Names along an axis: These are category or axis labels. Change the axis field, filter its items, or adjust the axis formatting rather than hiding field buttons.
Numbers printed on bars, points, or slices: These are data labels. Select the chart and use the chart elements controls or the chart design options to turn data labels off.
Series names beside the chart: These are legend entries. You can hide the legend or change the fields used to create the series.
Text above the chart: This is usually the chart title, which can be edited or removed independently.

For example, hiding all field buttons will remove the box that says Region with a drop-down arrow, but it will not remove region names that appear as separate colored series in the legend. Those names describe the data, rather than provide a filter control. Keeping the two categories separate helps prevent accidentally removing useful context from a chart.

What happens to filtering after you hide the buttons?

Hiding field buttons removes their visible controls from the chart; it does not lock the report to its current selection or remove the field from the PivotTable. A user who can access the associated PivotTable may still filter it there, and a connected slicer or timeline can continue to filter the PivotChart. Refreshing the PivotTable also remains a separate action.

This distinction matters when preparing a workbook for other people. Hiding buttons can make the chart easier to read, but it is not a security feature and does not prevent someone with workbook access from changing the underlying PivotTable or data. If the chart should remain interactive, add or retain a slicer that makes the intended choices clear. To add one, select a PivotTable or PivotChart and look for the relevant Insert Slicer command on the PivotTable Analyze or PivotChart Analyze ribbon; available commands can depend on the selected object and Excel build.

For a report that should be viewed but not edited, consider workbook protection and sharing permissions separately. Those controls have their own limits and should be chosen for the workbook’s needs. Do not rely on hidden field buttons to protect confidential data: the values may still exist in the workbook or its source data.

Common problems and how to fix them

The Field Buttons command is missing. First check that the selected object is a PivotChart. An ordinary chart does not have PivotChart field buttons, and selecting a cell in the PivotTable will show PivotTable-related ribbon commands instead. Click the chart itself and look for the contextual PivotChart Analyze tab.

The buttons disappeared, but labels are still visible. Those remaining words are probably axis labels, legend entries, data labels, or the chart title. Use the distinctions above to identify the element. Do not delete a field from the PivotTable just to remove a button; removing a field can change the chart’s structure and the data it summarizes.

Some buttons remain after choosing a selective option. A command to hide axis buttons affects axis field buttons, not necessarily legend or report-filter buttons. Open the Field Buttons menu again and choose Hide All if the intention is to remove every field button. If you selected a specific field-button type, verify that the remaining buttons belong to a different type.

The chart changes when someone filters the PivotTable. That is expected when the chart is linked to that PivotTable. Hiding the chart controls does not disconnect the chart. If viewers should be able to filter, provide a clear alternate control such as a slicer. If they should not change the report, manage access or editing separately rather than treating button visibility as a restriction.

The chart looks different after refresh. A PivotTable refresh can update the values and categories represented in the chart. That is separate from the display of field buttons. Check the PivotTable’s filters, field layout, and source data if the plotted results change; use the Field Buttons command only to control whether on-chart buttons are shown.

Excel for Mac and Excel for the web

On Excel for Mac, select the PivotChart and look for the contextual PivotChart Analyze or Analyze tab and its Field Buttons controls. Ribbon labels and placement can differ between versions, so the right-click menu on a visible button may be the easier route if it offers the hide command. If the ribbon does not show the command, confirm that the selected object is a PivotChart and consult the commands available in that Excel build.

Excel for the web has a different interface and may not expose every PivotChart editing control found in the Windows desktop app. If you cannot find a Field Buttons option in the web ribbon, open the workbook in Excel for Microsoft 365 on Windows or Mac to change the chart’s field-button display. The workbook can then be saved and reopened in the browser, though editing capabilities in the browser may still differ.

Frequently Asked Questions

Can I remove PivotChart filter buttons without deleting the filters?
Yes. Choose PivotChart Analyze > Show/Hide > Field Buttons > Hide All. The buttons are hidden, while the PivotTable filters and connected slicers remain available.

How do I hide just the filter button for one field?
Excel’s Field Buttons menu generally hides buttons by type, such as axis or legend buttons, rather than offering a separate visibility switch for every individual field. Use the selective type options if they match your chart, or hide all buttons if you want none displayed.

Will hiding the buttons stop other people from filtering the chart?
No. It only removes the visible on-chart controls. People may still be able to filter through the PivotTable or connected slicers, depending on workbook access and layout.

Why are category names still showing after I hide all field buttons?
Category names along an axis are chart labels, not field buttons. Hiding buttons does not remove the plotted categories. Change the axis field or its displayed items if those are the labels you intend to change.

How do I get the PivotChart buttons back?
Select the chart, open PivotChart Analyze > Show/Hide > Field Buttons, and choose Show All. If you hid only one type, use the matching show option if available.

Does hiding field buttons turn a PivotChart into a regular chart?
No. The chart remains a PivotChart connected to its PivotTable. It can still respond to changes in the PivotTable and connected filters; only the visible field-button controls are hidden.

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.