Pivot Chart Hide Fields? What You Can Hide in Excel

To hide the field buttons on an Excel PivotChart, select the chart and choose PivotChart Analyze > Show/Hide > Field Buttons > Hide All. This hides the controls drawn over the chart; it does not remove fields, filter the data, or change the linked PivotTable.

What “hide fields” can mean in a PivotChart

People use “hide fields” to describe several different Excel actions. The distinction matters because some actions only tidy the chart, while others change which information it displays. A PivotChart is connected to a PivotTable, and its fields determine the chart’s categories, series, values, and filters.

Hide field buttons: Remove the interactive buttons displayed on the chart, leaving its current data and appearance in place.
Hide the Field List pane: Close the side panel used to arrange PivotChart fields. This does not hide the chart’s field buttons.
Filter a field: Exclude selected items, such as one region or product, from the PivotChart and its linked PivotTable.
Remove a field from the layout: Stop using it as an axis, series, value, or filter. This changes the report’s structure, not the source data.

If the chart is correct but looks cluttered, hide its buttons. If a particular category or series should not appear, apply a filter instead. If the chart should no longer group or summarize by a field, remove that field from the layout.

Hide all field buttons in Excel for Windows

In Microsoft Excel for Microsoft 365 on Windows, use the contextual ribbon tab that appears when the PivotChart is selected. The usual steps are:

Click the PivotChart. If the ribbon tab is not visible, make sure you selected the chart rather than a nearby cell or its linked PivotTable.
Open PivotChart Analyze.
In the Show/Hide group, open Field Buttons.
Choose Hide All.

The buttons disappear, but the chart keeps its existing categories, series, values, and filter selections. To restore them, select the chart, return to PivotChart Analyze > Show/Hide > Field Buttons, and choose Show All. You can also right-click a field button on the chart and choose Hide All Field Buttons on Chart, where that command is available.

Hiding the buttons is a display choice, not a security feature. Someone who can access the workbook may be able to show the buttons again, inspect the linked PivotTable, or change its filters. Do not use this control to conceal confidential information.

Hide only certain types of buttons

You do not always have to hide every button. The Field Buttons menu can offer separate commands for button types, including axis, legend, report-filter, and value field buttons. The exact choices depend on the PivotChart’s layout. Select the relevant hide command if you want to retain other controls.

For example, a chart of monthly sales by region might have month buttons along the horizontal axis and region buttons for the series. If viewers need to switch months but should not see a row of region controls, hide the legend field buttons while leaving the axis buttons visible. The chart still shows the same regions; only the on-chart controls for that field type are removed.

These commands work by type, not as a general way to hide just one named field button while leaving all other buttons of that same type visible. If you need to remove one field from the chart’s structure, use the Field List. If you need to omit some of its items, filter the field.

Close the Field List without changing the chart

The Field List is a separate panel, usually displayed to the right of the worksheet. It contains the available fields and the areas where you can place them, such as Filters, Legend (Series), Axis (Categories), and Values. Closing this panel does not remove the buttons drawn on the chart.

To close it, select the PivotChart and use PivotChart Analyze > Show/Hide > Field List to toggle the pane off. Depending on the window layout, you can also close the pane using its close button. To reopen it, select the chart and toggle Field List back on. If you cannot see a field button but the panel is open, you may be looking at the wrong control: the panel and the chart buttons have independent visibility settings.

Filter or remove data fields instead

To keep a field in the report but exclude selected items, use its field button’s drop-down arrow and change the selection. For instance, clear the checkbox for one product category and apply the filter. The PivotChart then omits that category, and the linked PivotTable reflects the corresponding filter. The underlying source records are not deleted.

To stop using a field altogether, open the Field List and remove it from its layout area. You can usually drag it out of the area or clear its checkbox; if a field is used in more than one area, check the layout before changing it. Removing a category field can combine values that were previously shown separately. Removing a value field can eliminate a plotted measure. These are report changes, so the chart may look substantially different.

For example, suppose a PivotChart shows revenue by month, with region as the legend series. Hiding field buttons leaves the monthly regional comparison unchanged. Filtering out the East region removes East from the displayed comparison. Removing Region from the Legend area changes the grouping, so the chart may show total revenue by month instead. Those outcomes are not interchangeable.

Why a field may still appear or a chart may change

A few common misunderstandings explain many “hide field” problems:

The ribbon command is missing: The chart may not be selected, or the window may be too narrow to show the full ribbon group. Select the chart and look for the contextual PivotChart tab.
The Field List is gone, but buttons remain: Closing the pane does not hide chart buttons. Use the Field Buttons menu separately.
A field button is hidden, but its data remains: That is the expected result. Hiding a button does not apply a filter.
Filtering the PivotTable affects the chart: The chart and table share the PivotTable’s report structure and filters, so changes can carry across.
A chart changes after removing a field: Removing a category or series can regroup the remaining values. It is not merely a cosmetic change.
The same items return after a refresh: Check the current filter selection and the refreshed source data. A refresh can update the PivotTable’s available values and results.

Before changing a report for other users, consider whether they need to interact with it. Hiding buttons makes a chart cleaner for a presentation or printed report, but retaining them can make exploration easier. If you want a clean view and a way to change filters later, save the workbook with the buttons hidden; you can restore them when you need to edit the report.

Excel on Mac and Excel for the web

Ribbon labels and available PivotChart commands can differ between Excel for Windows, Excel for Mac, and Excel for the web, and they can change between builds. On a Mac, select the PivotChart and look for its contextual PivotChart or PivotChart Analyze tab and a Field Buttons control. If that control is not shown, check the ribbon options available in your version; the Windows path may not match exactly.

Excel for the web has a different interface and may not expose every desktop PivotChart command. If you cannot find the button-visibility options in the browser, open the workbook in the Excel desktop app and use the desktop ribbon. A workbook saved with field buttons hidden will generally retain that chart presentation when reopened, although editing options vary by app.

Frequently Asked Questions

Can I hide PivotChart field buttons without changing the data?

Yes. Select the chart and choose PivotChart Analyze > Show/Hide > Field Buttons > Hide All. This hides the chart controls without filtering records or removing fields from the PivotChart layout.

How do I hide just the filter buttons on a PivotChart?

Open the Field Buttons menu and choose the hide command for report-filter field buttons, if that option is offered for the chart. The menu can include separate controls for other button types as well.

Does hiding a field button hide the field’s values?

No. It hides the button, not the categories, series, or values represented in the chart. To omit values, filter the field; to change how the chart is grouped, remove or move the field in the Field List.

Can I hide one field button but keep other buttons of the same type?

The standard hide commands generally apply to all buttons of a type or to all field buttons. To change one field’s role, edit that field in the Field List; to exclude particular items, filter that field.

Why can’t I see the Field Buttons command?

First select the PivotChart itself and look for the contextual PivotChart ribbon tab. If you are using Excel for Mac or the web, the command may be in a different place or unavailable in that version; try opening the workbook in Excel for Microsoft 365 on Windows.

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.