Excel Pivot Chart: How to Remove Buttons

To remove the buttons from an Excel PivotChart in Microsoft 365 for Windows, select the chart, open the PivotChart Analyze tab, choose Field Buttons, and select Hide All. This hides the on-chart controls without deleting the chart or its underlying PivotTable; you can also hide particular button types or show them again later.

What the buttons on a PivotChart do

The gray boxes that appear over or beside a PivotChart are field buttons. They identify fields used in the chart and, in many cases, let a viewer filter or rearrange the chart directly. A button might show a category such as Region, a legend field such as Product, or a value field such as Sum of Sales. Depending on the chart’s layout, you may also see a report-filter button.

These controls are part of a PivotChart, which is connected to a PivotTable. They are not the same as a chart title, legend, axis label, or the usual filter drop-downs in a worksheet table. Hiding field buttons changes what is displayed on the chart; it does not remove the fields from the PivotTable or change the source data.

Button placement and appearance vary with the chart type and the fields in its layout. A chart with several fields may show multiple buttons, while a simpler chart may show only one or two. If you select an ordinary chart that is not a PivotChart, the PivotChart Analyze tab and its field-button controls will not appear.

Hide every field button

Use the ribbon when you want a clean chart for a report, presentation, or dashboard. The chart must be selected first, because PivotChart commands appear only while Excel has a PivotChart selected.

Click the PivotChart. If you select the PivotTable beside it instead, the contextual tab for the chart may not appear.
On the ribbon, select PivotChart Analyze.
Open Field Buttons and choose Hide All.

The buttons should disappear from the chart immediately. In many desktop builds, you can reach the same command by right-clicking a field button on the chart and choosing Hide All Field Buttons on Chart. This context-menu route is handy when the button is visible and you do not want to search the ribbon.

Hiding the controls is a display choice, not a permanent removal. The PivotChart remains connected to its PivotTable, and the chart continues to reflect changes made to that table. If your goal is simply to make a chart less cluttered, this is usually safer and quicker than rebuilding it as a different chart type.

Hide only selected button types

You do not have to hide everything. The Field Buttons menu includes controls for different field-button categories. Depending on the fields used in your chart and the Excel build, options can include axis, legend, value, and report-filter buttons. Choose the relevant hide command rather than Hide All when you want to retain some on-chart filtering.

Axis field buttons relate to fields used for the chart’s category or axis labels.
Legend field buttons relate to fields that divide the chart into series, such as product lines.
Value field buttons relate to the summarized measure, for example Sum of Sales.
Report-filter field buttons relate to report filters associated with the PivotChart.

For example, a regional sales chart might use Month on the axis, Product in the legend, and Sum of Sales as the value. You could hide the value button, which is often not useful to a viewer, while leaving the axis or legend controls available for exploration. The names and availability of individual commands depend on the chart’s layout; Excel may not offer a category that the chart does not use.

Right-clicking a particular button can also provide a command for hiding that category of buttons. If you are unsure which type a control belongs to, use the Field Buttons menu and inspect the available choices rather than removing chart elements such as the legend or axis by mistake.

Show the buttons again

To restore the controls, select the PivotChart, return to PivotChart Analyze > Field Buttons, and choose Show All. If you previously hid only one category, use the corresponding show option if it is available in the menu. The button layout returns according to the fields currently used in the chart, so it may not look exactly as it did before if the PivotTable has changed.

If you cannot click a hidden button, that is expected: the control is no longer drawn on the chart. Select the chart itself and use the ribbon to show the buttons again. If you cannot find the contextual tab, first check that the chart—not a worksheet cell or the PivotTable—is selected.

What hiding buttons changes—and what it does not

Hiding field buttons removes the visible controls from the chart area. It does not delete the PivotChart, clear filters already applied, remove PivotTable fields, or convert the chart to a standard chart. Existing filter selections generally remain in effect, so the chart can continue to show a filtered subset even when there is no on-chart button to change that selection.

To change the data after hiding the buttons, you can still use the PivotTable’s field controls or another connected report control. For instance, if a PivotTable has a Region filter, changing that filter can update its associated PivotChart. Refreshing the PivotTable when its source data changes is also separate from showing or hiding buttons.

This distinction matters when sharing a workbook. A clean chart does not necessarily mean the recipient cannot alter the analysis: they may still be able to use the PivotTable, slicers, or other worksheet controls. Hiding buttons is not a security feature and does not protect data or lock down the workbook.

Keep filtering with slicers or the PivotTable

If you want a polished chart but still need interactive filtering, consider replacing the on-chart buttons with slicers. A slicer presents filter choices as visible, clickable controls that can be positioned beside the chart. To add one, select the associated PivotTable or PivotChart and use PivotTable Analyze > Insert Slicer; select the field or fields you want to filter and confirm. The precise contextual tab shown depends on which object you selected.

Slicers can make a dashboard easier to understand because users can see available choices without opening field-button menus. A slicer can also control more than one PivotTable or PivotChart when those objects share a compatible data source and are connected through the slicer’s report connections. If a slicer changes one chart but not another, inspect its connections rather than assuming the chart buttons need to be restored.

You can also leave filtering in the PivotTable and hide all chart buttons. This works well when the PivotTable is visible and intended for the person using the workbook. If viewers should interact only with the chart, slicers are often clearer; if the chart is meant to be a static visual, hiding the buttons may be enough.

Windows, Mac, and Excel for the web

The steps above are for Excel for Microsoft 365 on Windows. In Excel for Mac, select the PivotChart and look for the contextual PivotChart Analyze tab and its Field Buttons control. The ribbon arrangement and wording can differ by Mac version, but the relevant command is to hide or show the chart’s field buttons.

Excel for the web may not show the same full set of PivotChart controls as the desktop application. If you do not see a field-button command in the browser, open the workbook in the Excel desktop app and use the ribbon steps above. Avoid assuming that a missing browser command means the chart has been converted or that its buttons have been permanently removed.

Common problems and quick checks

There is no PivotChart Analyze tab. Click the chart area, not a cell in the worksheet or the PivotTable. Also confirm that the selected object is a PivotChart rather than a standard chart.
The buttons remain after using the ribbon. Reopen Field Buttons and check that you chose Hide All, not a command for just one button category. Make sure the chart is still selected.
The chart looks filtered even though its buttons are gone. Hiding buttons does not clear an existing filter. Check the PivotTable filters or any slicers connected to the chart.
A viewer can still change the report. Hidden buttons are not access controls. If you need to restrict editing, use appropriate workbook or worksheet protection settings and consider what data is included in the file.
You want to remove a title or legend, not a field button. Those are chart elements. Use the chart’s element controls or formatting options; hiding field buttons will not remove a chart title, legend, or axis labels.

PivotChart buttons versus a regular chart

A PivotChart is designed to summarize and explore data through its linked PivotTable. Field buttons are useful during analysis because they reveal which fields are in use and provide quick filtering or layout controls. They can be distracting in a finished presentation, which is why Excel lets you hide them without changing the chart’s PivotChart identity.

A standard chart does not have PivotChart field buttons because it is not controlled by a PivotTable field layout. If you need a chart with no PivotChart controls and do not need the chart to behave as a PivotChart, a standard chart may be an alternative. However, converting or recreating a chart can change how it responds to PivotTable filtering and updates. For most cases, hide the buttons first; choose a standard chart only when its different behavior suits the workbook.

Frequently Asked Questions

Can I remove just one button from an Excel PivotChart?

Usually, you can hide a button category rather than an individual field button. Select the chart, open PivotChart Analyze > Field Buttons, and choose the relevant category’s hide command. Available categories depend on the chart layout.

Does hiding PivotChart buttons stop the chart from updating?

No. Hiding buttons affects their visibility, not the chart’s PivotTable connection. The chart can still update when its PivotTable changes or refreshes, and connected filters or slicers can still affect it.

How do I remove the filter buttons from a PivotChart permanently?

Excel’s hide command is reversible, so it is not a permanent deletion. You can leave the buttons hidden, or use a standard chart if you do not need PivotChart behavior. Hiding controls should not be treated as a way to prevent other people from editing the workbook.

Why can I still see a filtered result after hiding the buttons?

The chart retains the filter state that was already applied. Change the relevant field in the PivotTable or use a connected slicer to adjust the selection; showing the chart buttons again is not required to clear a filter.

Can I hide PivotChart buttons in Excel for the web?

The browser version may not provide the same PivotChart field-button commands as desktop Excel. If you cannot find Field Buttons, open the workbook in Excel for Microsoft 365 on Windows or Excel for Mac and change the setting there.

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.