Pivot Chart Hide Buttons: How to Remove Field Buttons

To hide PivotChart buttons in Excel for Microsoft 365 on Windows, select the chart, then choose PivotChart Analyze > Show/Hide > Field Buttons > Hide All. This removes the field controls from the chart’s display, but it does not delete the PivotTable, its fields, or its data.

What PivotChart buttons are

The buttons on a PivotChart are field buttons: small controls that appear on or around the chart and identify the fields used to build it. Depending on the chart’s layout, they may include labels such as Axis, Legend, Values, or a report-filter field. Clicking a button can open a menu for sorting, filtering, or changing which items appear in the chart.

These controls are useful while you are exploring data, but they can make a finished chart look crowded. For example, a chart showing monthly sales by region may display buttons for Month and Region. If the chart is being placed in a report or presentation, those labels may overlap the plot area or distract from the title and data.

Field buttons are specific to PivotCharts. They are not the same as a chart legend, axis labels, data labels, or the filter arrows in a worksheet table. Hiding field buttons changes the chart’s controls; it does not remove the legend or the chart’s plotted categories.

Hide all field buttons in Excel for Windows

Use the contextual PivotChart ribbon tab. It appears when you select a PivotChart, so it will not necessarily be visible while another worksheet object or cell is selected.

Click the PivotChart. If it is difficult to select, click its outer edge rather than a data point.
Open PivotChart Analyze on the ribbon.
In the Show/Hide group, open Field Buttons.
Choose Hide All.

The field buttons disappear from that chart. If the ribbon is simplified or narrow, the Show/Hide controls may be tucked into a menu, but the command remains on the PivotChart Analyze tab. You can also right-click a field button on the chart and choose the command to hide field buttons, if the context menu offers it in your Excel build.

Check that you selected a PivotChart before looking for the command. A standard chart does not have PivotChart Analyze or field buttons. If you selected the associated PivotTable instead, Excel shows PivotTable tools rather than the PivotChart controls.

Hide only particular button types

Hiding every button is not the only option. The Field Buttons menu can offer separate commands for categories such as value, axis, legend, and report-filter field buttons. These let you keep some controls visible while removing others. The exact choices depend on the fields and chart layout in use.

For instance, a chart might need an interactive Region filter but not need the Values button, because the viewer does not need to change the measure being displayed. In that case, hide the value field buttons and leave the report-filter control available. This can preserve a useful interaction without showing every field label.

To hide one button, right-click the relevant button on the chart and look for a command that hides that button type. Excel’s wording can refer to hiding all buttons of that type on the chart, rather than just the one you clicked. Read the menu item before choosing it. If a button category is not offered, use the Field Buttons dropdown on the ribbon and select from the available options.

Show the buttons again

Hiding field buttons is reversible. Select the PivotChart, return to PivotChart Analyze > Show/Hide > Field Buttons, and choose Show All. If you had hidden only one type, use the corresponding show command where available, or choose Show All to restore every field button.

Showing the controls does not reset the chart’s filters or restore a previous view automatically. It makes the field buttons visible again so you can use them. If the chart still looks filtered, open its field controls or use the connected PivotTable and check which items are selected.

What hiding buttons changes—and what it does not

Hiding buttons is a presentation change, not a data operation. It does not remove fields from the PivotChart, delete source records, change the PivotTable’s source range, or prevent the chart from updating when its connected PivotTable changes. It also does not convert the PivotChart into a regular chart.

The important trade-off is that viewers lose the field-button menus on the chart. They may no longer be able to filter or rearrange the chart directly from those controls. If the workbook is meant to be explored, hiding every button can make it less obvious how to change the view. If the chart is intended as a fixed summary, removing the controls can make it cleaner.

Hiding buttons also does not necessarily make the chart’s underlying PivotTable private or inaccessible. A user who can access the worksheet may still be able to select the PivotTable, use its controls, or inspect the workbook data, depending on workbook protection and permissions. Do not treat hidden field buttons as a security feature.

Keep filtering available with slicers or the PivotTable

If you want a clean chart but still need interactive filtering, consider adding a slicer. Select the associated PivotTable or PivotChart and use PivotTable Analyze > Insert Slicer or the relevant Insert Slicer command available for the selected object. Choose a field, then place and size the slicer beside the chart. Clicking a slicer item filters the connected PivotTable and chart, subject to the workbook’s connections.

For date fields, a timeline may be a better control. Select the PivotTable and use PivotTable Analyze > Insert Timeline, then choose a date field. A timeline offers a visual way to select periods without leaving field buttons across the chart. It is available only when the PivotTable includes a supported date field.

You can also leave the field buttons hidden and let users filter through the connected PivotTable. This works well when the chart and PivotTable sit together on a detail sheet, while a separate dashboard sheet displays the cleaner chart. If you add a slicer, check its report connections when multiple PivotTables or PivotCharts are involved; a slicer does not automatically control every object in every workbook.

Common problems and fixes

The Field Buttons command is missing: Select the chart itself. The contextual PivotChart Analyze tab appears only when a PivotChart is selected. If the selected object is a regular chart, field-button commands do not apply.
The buttons disappear, but labels remain: Check whether the remaining text is a chart title, legend, axis title, axis label, or data label. Those are separate chart elements and must be formatted or removed separately.
The chart is still filtered: Hiding a button does not clear its filter. Reopen the field buttons, use the PivotTable, or use a connected slicer to change the selection.
The chart changes when the PivotTable changes: That is expected. A PivotChart is linked to its PivotTable, so edits to the PivotTable layout or filters can affect the chart even while its buttons are hidden.
A right-click menu does not show the command: Right-click directly on a visible field button, not on a bar, line, legend, or blank chart area. Otherwise, use the ribbon dropdown.

Excel for Mac and Excel for the web

On Excel for Mac, select the PivotChart and look for the contextual chart analysis tab and its Field Buttons controls; tab names and ribbon placement can differ between Mac releases. If the ribbon does not show the same path as Windows, use the chart’s contextual ribbon or right-click a visible field button to locate the hide command. Avoid assuming that a Windows keyboard shortcut applies on Mac.

Excel for the web has a more limited and changing set of PivotChart editing controls than the desktop application. If you cannot find the Field Buttons command in the browser, open the workbook in the Excel desktop app and use the Windows steps above, or the corresponding Mac controls. A workbook saved after changing the chart in desktop Excel retains the chart formatting when reopened, although available editing options can vary by platform.

Frequently Asked Questions

Can I hide PivotChart buttons without deleting the chart?
Yes. Choose Hide All from the Field Buttons menu. The chart and its connection to the PivotTable remain in place.

Does hiding PivotChart buttons remove filters?
No. Existing filter selections remain in effect. Hiding the controls only removes the on-chart buttons used to access those selections.

Can I hide just one PivotChart button?
You can often hide a category of buttons, such as axis or value field buttons, from the Field Buttons menu. The available categories depend on the chart. Check the menu wording because a command may hide every button of that type on the chart.

How do I remove the arrows or labels from a regular Excel chart?
A regular chart has no PivotChart field buttons. If you see unwanted text or symbols, identify whether they are a legend, axis labels, data labels, or a filter control and change that chart element separately.

Will hidden buttons stay hidden when I save the workbook?
Yes, the chart’s display setting is saved with the workbook. You can show the controls again later from the Field Buttons menu.

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.