Filter data from your chart in Office 2016 for Mac

  1. To work with a subset of data, select your chart and then on the Chart Design tab, click Edit Data in Excel.

    Note: This step only applies when you are filtering charts in Word and PowerPoint.

    Office for Mac Chart Edit in Excel
  2. In Excel, select the category title and then in the Home tab, click Sort & Filter > Filter.

    Excel for Mac Sort Filter command
  3. Next, click the drop-down arrow to select the data you want to show, and deselect the data you don't want to show.

    Excel for Mac filter for chart

See Also

Create a chart in Word or PowerPoint

Create a chart in Excel

Change chart type

Format data labels in a chart

Add data series in charts

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.