Excel Pivot Chart: Hide Field Buttons and Show Them Again

To hide the buttons on an Excel PivotChart in Microsoft 365 for Windows, select the chart and choose PivotChart Analyze > Show/Hide > Field Buttons > Hide All. This removes the field buttons from the chart display, not the underlying PivotTable data or its filtering; you can show the buttons again from the same menu.

What PivotChart field buttons are

PivotChart field buttons are small, labeled controls that appear over a chart linked to a PivotTable. They let someone working with the chart filter or rearrange the fields represented in it. Depending on how the report is built, buttons may identify a category or axis field, a series or legend field, a value field, or a report filter. For example, a chart of sales by month and region might show a button for Month, one for Region, and another for the sales measure.

These controls are specific to PivotCharts. A regular chart created from a cell range does not have PivotChart field buttons, even if its source range happens to contain PivotTable results. That difference matters when looking for the command: select the actual PivotChart, rather than a nearby standard chart or the PivotTable, to reveal its chart-specific ribbon tab.

Buttons are useful while exploring a report, but they can make a finished chart look busy. They may also take up visual space or overlap a title or data label. Hiding them is a display choice: Excel keeps the chart connected to its PivotTable and retains the fields and current filter selections.

Hide every button on the chart

On Windows, use these steps to remove all PivotChart field buttons at once:

Click the PivotChart. The contextual PivotChart Analyze tab should appear on the ribbon.
Open PivotChart Analyze, then find the Show/Hide group.
Choose Field Buttons and select Hide All.

The buttons disappear from the chart, while the chart itself remains selected and editable. If you cannot see the Field Buttons command, first confirm that you clicked the chart rather than a chart title, a separate shape, or the PivotTable. The contextual tab appears only when the chart is selected. In a narrow Excel window, some ribbon commands may be collapsed into a menu, so expanding the ribbon or maximizing the window can help.

There is also a shortcut through the chart itself: right-click a visible field button and choose Hide All Field Buttons on Chart, if that command appears in the context menu. This is handy when the chart is crowded and you do not want to navigate the ribbon. The ribbon method is easier to find when the buttons are already hidden or when you need to choose a specific button category.

Hide only certain kinds of buttons

You do not have to hide every button. In the Field Buttons menu, Excel provides category-specific hide commands. Depending on the chart and version, the menu can include options for value, axis, legend, and report filter field buttons. Select the category you want to hide rather than Hide All. The menu may also offer corresponding show commands or Show All.

Axis field buttons relate to fields used for chart categories, such as Month, Product, or Department.
Legend field buttons relate to fields that divide the chart into series, such as Region or Sales Channel.
Value field buttons identify the summarized measure, such as Sum of Sales or Count of Orders.
Report filter field buttons are associated with report filters that apply to the PivotChart.

Suppose a chart compares revenue for three regions across four quarters. You might hide the value button because “Sum of Revenue” is already clear from the title, while leaving the quarter and region controls available for exploration. Conversely, for a presentation chart intended to be read but not manipulated, hiding all controls can produce a cleaner appearance.

Field labels and available choices depend on the chart’s layout. If a category is not used in the PivotChart, its corresponding button may not appear, and some menu items may be unavailable. Hiding one category does not remove that field from the PivotTable or prevent Excel from using it in the chart.

Show the buttons again

To restore the controls, select the PivotChart and go to PivotChart Analyze > Show/Hide > Field Buttons > Show All. If you hid only one type, choose the relevant show command instead. The chart returns to showing the field buttons for the fields currently used in its layout; it does not necessarily recreate a button for a field that is no longer part of the chart.

If you hid the buttons using the right-click menu, you can still restore them from the ribbon. Hiding them does not lock the chart or change its field arrangement. You can also continue to edit the chart through its PivotTable, field list, or other available PivotChart tools while the on-chart controls are out of view.

What hiding buttons changes—and what it does not

The command controls whether field buttons are displayed on the PivotChart. It does not delete source records, remove fields from the PivotTable, convert the PivotChart into a standard chart, or clear the existing report filters. Refreshing the PivotTable does not mean that hidden buttons have been turned back on; the visibility setting is separate from the source data refresh.

Hiding buttons also does not guarantee that a viewer cannot change the report. If the workbook remains editable, someone may be able to use the PivotTable, a slicer, a timeline, or other workbook controls to change what is displayed. For example, a slicer connected to the PivotTable can still filter the chart even when all field buttons are hidden. If the goal is simply a cleaner appearance, hide the buttons. If the goal is to limit what another person can change, consider the workbook’s sharing, sheet protection, and report design separately; hiding a control is not a security feature.

The chart’s current filtering and layout determine what readers see. If a chart appears incomplete after hiding buttons, check the PivotTable’s filters and any connected slicers before assuming that hiding the controls removed data. You can also use the PivotTable field list to inspect which fields are assigned to the chart’s axis, legend, values, and filters.

Common problems and version differences

The PivotChart Analyze tab is missing. Click inside the chart area, not just the worksheet or a nearby PivotTable. If the selected object is a standard chart, it will not expose PivotChart field-button controls. If the ribbon is simplified or collapsed, expand it and look for the contextual chart tab.

The buttons are gone, and you cannot right-click one. Use the ribbon route: select the chart, then open PivotChart Analyze > Show/Hide > Field Buttons. The menu remains available even when the buttons themselves are hidden.

The chart is still interactive. That is expected. Hiding field buttons removes those on-chart controls, not every possible way to filter a PivotChart. Check for slicers, timelines, PivotTable filters, or other controls connected to the report.

In Excel for Mac, select the PivotChart and look for its contextual PivotChart analysis tab and Field Buttons controls; ribbon labels and placement can vary by release. Excel for the web may not expose all the same PivotChart commands as the Windows desktop app. If you do not see the field-button options in the version you are using, open the workbook in desktop Excel and use the steps above.

Choose a clean chart without losing useful filtering

The right setting depends on who will use the workbook. For a chart used during analysis, retaining buttons can make it easier to change fields without opening the PivotTable field list. For a report shared with readers, hiding some or all buttons can reduce clutter and make the chart easier to scan. A useful middle ground is to hide the value button when the measure is stated in the title, while keeping category controls that readers need to explore.

If readers still need a simple way to filter the report, add a slicer or timeline where appropriate rather than leaving every field button visible. A slicer presents filter choices as clickable controls, often making them easier to discover. Before relying on one, confirm that it is connected to the relevant PivotTable or PivotChart. Slicers are separate report objects, so hiding field buttons will not remove them.

For a static publication or a chart that should not be changed, you could also copy the chart and paste it as a picture, or export the worksheet or workbook to a suitable sharing format. Those approaches trade interactivity for a fixed appearance. Keep an editable copy if the chart may need future updates; a picture will not respond to PivotTable refreshes or filters.

Frequently Asked Questions

Can I hide PivotChart buttons without hiding PivotTable buttons? Yes. Use the Field Buttons menu while the PivotChart is selected. This changes the chart’s on-chart buttons; it does not, by itself, hide field headers or filter controls displayed in the associated PivotTable.

Can I hide just the filter button on a PivotChart? You can hide a category of PivotChart field buttons, such as report filter buttons, through the Field Buttons menu when that option is available. The exact options depend on the fields and layout used by the chart. This does not necessarily remove other filters connected to the report.

Will hiding field buttons change the PivotChart data? No. Hiding the buttons is a display setting. The PivotChart remains linked to its PivotTable, and its existing field arrangement and filter selections remain in place.

Why can I still filter the chart after choosing Hide All? Hide All applies to PivotChart field buttons, not to every filtering method in the workbook. A connected slicer, timeline, or PivotTable filter may continue to control the chart.

How do I hide buttons on a regular Excel chart? Regular charts do not have PivotChart field buttons, so the Field Buttons command does not apply. If you mean chart elements such as a legend or title, select the chart and use the chart design or chart element controls to change those instead.

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.