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

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!