Chart & Visualization Issues

Show or Hide Excel Chart Series on a Mac

Camila MilosovichCamila Milosovich Nov 14, 2026 868 views

Question details

The user wants to show or hide chart series in Excel for Mac.

Show or Hide Excel Chart Series on a Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
The user wants to control which data series appear in a chart, potentially a PivotChart.
Observed behavior
PivotChart filter buttons available in Excel for Windows may not appear in Excel for Mac.
Before you start

Check whether the chart is linked to a PivotTable or is a standard chart. The appropriate controls depend on the chart type and your Excel for Mac version.

Solution 1Recommended

Filter PivotChart data with a slicer

Use a slicer to filter the PivotTable data behind a PivotChart when chart filter buttons are unavailable.

1
Select the PivotTable

Click a cell in the PivotTable connected to the PivotChart.

2
Insert a slicer

On the PivotTable Analyze tab, choose Insert Slicer, select the field you want to filter, and click OK.

3
Choose field values

Click a value in the slicer to filter the PivotTable and its chart. Use the slicer's multi-select control to select more than one value.

4
Clear the filter

Click the Clear Filter button on the slicer to show all values again.

Filter PivotChart data with a slicer
Slicers filter field values: A slicer can change the displayed series when its field controls those series, but it may not provide an independent toggle for every chart series.
Free Microsoft Office alternative

Work with spreadsheets and charts in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface for opening Excel files and working with charts. It does not restore missing controls in Excel for Mac, and advanced features may differ between apps.

Create and edit spreadsheet charts in WPS SpreadsheetsOpen and save Microsoft Excel XLSX files for easier migrationUse a familiar interface for everyday spreadsheet workGet a free, lightweight office suite
QA img-9

Frequently Asked Questions

Why don't I see PivotChart filter buttons in Excel for Mac?

Excel for Mac may not provide the PivotChart filter buttons found in Excel for Windows. Select the connected PivotTable and use PivotTable Analyze > Insert Slicer to filter its data instead.

Can a slicer hide just one series in my PivotChart?

A slicer filters values in a PivotTable field. It can hide a series if that series corresponds to a value in the selected field, but it may not offer an independent toggle for every series.

How do I restore a series I removed from a regular chart?

Select the chart and open Chart Design > Select Data. Click Add and select the original series name and value ranges from the worksheet.

How can I ask Microsoft to add the missing chart controls?

In Excel for Mac, use Help > Feedback to describe the chart type and the series-selection controls you need.