Show or Hide Excel Chart Series on a Mac
Question details
The user wants to show or hide chart series in Excel for 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.
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.
Filter PivotChart data with a slicer
Use a slicer to filter the PivotTable data behind a PivotChart when chart filter buttons are unavailable.
Click a cell in the PivotTable connected to the PivotChart.
On the PivotTable Analyze tab, choose Insert Slicer, select the field you want to filter, and click OK.
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.
Click the Clear Filter button on the slicer to show all values again.

Change the series in a standard Excel chart
Use Select Data to remove a series from a chart that is not a PivotChart.
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.

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.




