Pivot Chart Hide Filters? Hide Field Buttons in Excel

Yes. In Excel for Microsoft 365 on Windows, select the PivotChart, then choose PivotChart Analyze > Field Buttons > Hide All. This hides the filter and field buttons on the chart without deleting the PivotTable, changing its source data, or removing the underlying filter settings.

What people mean by PivotChart filters

A PivotChart can display small field buttons around the chart. Depending on the chart layout, these buttons may be labeled with a field name such as Region, Product, or Month and may include a drop-down arrow. A viewer can use the arrow to filter the chart by selecting or clearing items. These on-chart controls are often what someone means by PivotChart filters.

They are not the same thing as the data labels, axis labels, or legend. Nor are they the same as the PivotTable itself. A PivotChart is linked to a PivotTable, and the buttons provide a convenient way to change which PivotTable items are shown in the chart. Hiding the buttons changes the chart’s appearance and removes those controls from its face; it does not erase the field or its data.

This distinction is useful when preparing a report. You may want a clean chart for a presentation, while keeping the PivotTable and its filtering options available elsewhere in the workbook. In that case, hiding the field buttons is usually preferable to deleting fields or rebuilding the chart.

Hide all field buttons on the chart

Use these steps in the Windows desktop version of Excel for Microsoft 365:

Click the PivotChart. The contextual PivotChart tabs should appear on the ribbon.
Open PivotChart Analyze.
In the Show/Hide area, open Field Buttons.
Choose Hide All.

The field buttons should disappear from the chart. If the PivotChart Analyze tab is not visible, first make sure you clicked the chart itself rather than a nearby cell or the PivotTable. The contextual tab only appears when the chart is selected.

There is also a chart shortcut in many desktop builds: right-click a field button on the chart and choose Hide All Field Buttons on Chart. This is useful when the ribbon is crowded or you are already pointing at the button. To reverse the change, select the chart and use PivotChart Analyze > Field Buttons > Show All. The same Field Buttons menu can also offer options to show or hide particular categories of buttons.

Hide only some kinds of buttons

Hiding every button is simple, but it may remove controls that a workbook user still needs. The Field Buttons menu can provide more selective choices, such as hiding axis field buttons, legend field buttons, value field buttons, or report-filter field buttons. The exact choices available depend on the PivotChart’s fields and layout.

For example, imagine a chart showing sales by month, with product categories displayed as separate colored series. Axis buttons may let the user change the month field, while legend buttons may let the user filter product categories. If the chart should remain interactive by product but should not show field controls for the axis, hide the axis buttons rather than selecting Hide All.

These options hide a type of button, not necessarily one named field wherever it appears. If you want to remove a field from the chart’s structure entirely, that is a different change: edit the PivotChart field arrangement, usually through the PivotChart Fields pane. Before doing that, consider whether the linked PivotTable should retain the field and whether changing the layout will affect other users or reports.

What stays filterable after the buttons are hidden?

Hiding PivotChart field buttons does not lock the chart or make its linked PivotTable read-only. The chart continues to reflect changes made through the PivotTable, and workbook users can still filter the data through other available controls. For example, they may use the PivotTable’s field drop-downs, a slicer, or a timeline if the workbook contains one.

A slicer is often the best replacement when you want a clean chart but still need an obvious way to filter it. Select the PivotTable or PivotChart, then use PivotTable Analyze > Insert Slicer or the corresponding Insert Slicer command available for the selected object. Choose the relevant field and place the slicer beside the chart. For date fields, a timeline may be available through PivotTable Analyze > Insert Timeline.

Before relying on a slicer, confirm that it controls the intended PivotTable or PivotChart. If a workbook contains multiple PivotTables, a slicer may need to be connected to additional compatible PivotTables through its Report Connections or PivotTable Connections command. A slicer that controls only one report will not filter every chart in a dashboard just because it is placed beside them.

PivotChart buttons versus PivotTable filters

A PivotChart’s field buttons and the PivotTable’s filter controls are related, but they are not the same display element. Hiding the chart buttons is designed to declutter the chart. It does not automatically hide the PivotTable’s field headers or remove report filters from the worksheet. Likewise, hiding PivotTable field headers does not necessarily hide the buttons displayed on a separate PivotChart.

This matters when a dashboard contains both a chart and its underlying PivotTable. If the PivotTable is visible, a reader may still be able to filter the report there, even though the chart itself has no buttons. If the PivotTable is on another worksheet, the chart may look presentation-ready while the analysis controls remain available on that sheet.

Think of the change as hiding an interface element, not as protecting data or restricting access. If the purpose is to prevent users from changing a report, hiding buttons alone is not a security measure. Worksheet protection and workbook design can limit accidental edits, but neither should be treated as a way to secure confidential source data. Keep sensitive information out of a workbook shared with people who should not see it.

When to hide buttons and when to keep them

Hide field buttons when the chart is intended for reading rather than hands-on exploration. They can overlap a chart title or plot area, make a chart look crowded, and distract from the trend or comparison. A printed report, an executive summary, or a slide-ready chart may benefit from a cleaner appearance.

Keep them visible when users are expected to explore the chart directly and need to change fields without visiting the PivotTable. A button can make the chart’s current field arrangement easier to understand and provides immediate access to filtering. If users need a clear, touch-friendly interface, slicers are often easier to discover than small buttons embedded in a chart.

Choose Hide All for a static-looking chart when no on-chart controls are needed.
Hide selected button categories when some controls should remain available.
Use slicers or a timeline when you want visible, separate filtering controls.
Keep the PivotTable accessible if users need its field filters or want to inspect the supporting summary.

Common problems and practical checks

If Hide All appears to do nothing, verify that the selected object is a PivotChart. A regular chart built from worksheet cells does not have PivotChart field buttons, so its controls and menus are different. Also check whether the buttons are actually hidden behind another object or outside the visible chart area before repeating the command.

If buttons return later, check whether someone chose Show All, changed the chart, or copied and recreated it. Hiding the buttons is a display setting for the chart, not a permanent removal of the PivotChart’s fields. When distributing a workbook, save it after making the change and reopen it to confirm that the saved view looks as intended.

If the chart still seems to have filters, identify which control you are seeing. A slicer, a timeline, a PivotTable drop-down, and a PivotChart field button are separate objects or features. Hiding field buttons will not remove a slicer or a filter control placed on the worksheet. Select the specific object and remove or reposition it only if that is what the report design requires.

Finally, hiding buttons does not refresh stale source data. If the chart shows old results, use Data > Refresh All or right-click the PivotTable and choose Refresh, depending on the workbook setup. Refreshing updates the PivotTable from its source; it is separate from hiding or showing chart controls.

Excel on Mac and Excel for the web

In Excel for Mac, select the PivotChart and look for the contextual PivotChart Analyze tab and its Field Buttons command. Ribbon labels and placement can vary by Excel version, so the command may not appear in exactly the same location as in Windows. If the ribbon offers Hide All, use it; if not, try right-clicking a visible field button and checking for a hide command.

Excel for the web has a different interface and may not expose every desktop PivotChart layout command. If you cannot find the Field Buttons control in the browser, open the workbook in the Excel desktop app and hide the buttons there. The change is saved in the workbook, so it can then be viewed in the browser, subject to the web app’s support for the workbook’s chart features.

There is no need for a formula or VBA macro to hide PivotChart buttons. The ribbon command is the simplest option and avoids altering the PivotTable layout or source data.

Frequently Asked Questions

Can I hide PivotChart filters without deleting the PivotTable?
Yes. Choose PivotChart Analyze > Field Buttons > Hide All. This hides the chart’s field buttons and leaves the linked PivotTable in the workbook.

Will hiding the buttons stop the chart from updating?
No. The chart remains linked to its PivotTable. Changes made through the PivotTable or another connected filter can still update the chart.

How do I show PivotChart filters again?
Select the chart, open PivotChart Analyze > Field Buttons, and choose Show All. If you hid only one category, use the matching show option.

Can I hide just one field button?
The menu generally offers controls for categories of field buttons, rather than a simple hide command for one individual field while leaving every other button unchanged. Check the available category options; changing the field layout is another option, but it can affect the chart itself.

Does Hide All remove slicers too?
No. Slicers are separate worksheet controls. Hide or delete a slicer separately if you do not want it displayed, and remember that removing it also removes that visible filtering interface.

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.