Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Word for Microsoft 365 for Mac PowerPoint for Microsoft 365 for Mac Excel 2024 PowerPoint 2024 Excel 2024 for Mac Word 2024 for Mac PowerPoint 2024 for Mac Excel 2021 Excel 2021 for Mac Word 2021 for Mac PowerPoint 2021 for Mac Excel 2019 Word 2019 for Mac Excel 2016

After you create a chart, you can change the data series in two ways:

  • Use the Select Data Source dialog box to edit the data in your series or rearrange them on your chart.

  • Use chart filters to show or hide data in your chart.

Edit or rearrange a series

  1. Right-click your chart, and then choose Select Data.

    Select Data Source dialog box
  2. In the Legend Entries (Series) box, click the series you want to change.

  3. Click Edit, make your changes, and click OK.

    Changes you make may break links to the source data on the worksheet.

  4. To rearrange a series, select it, and then click Move Up or Move Down .

You can also add a data series or remove them in this dialog box by clicking Add or Remove. Removing a data series deletes it from the chart—you can’t use chart filters to show it again.

If you want to rename a data series, see Rename a data series.

Filter data in your chart

Let’s start with chart filters.

  1. Click anywhere in your chart.

  2. Click the Chart Filters button Chart Filters button next to the chart.

  3. On the Values tab, check or uncheck the series or categories you want to show or hide.

    Values tab in the Chart Filters gallery
  4. Click Apply.

  5. If you want to edit or rearrange the data in your series, click Select Data, and then follow steps 2-4 in the next section.

Edit or rearrange a series

  1. Click on the chart.

  2. On the ribbon, click Chart Design and then click Select Data.

    On the Chart Design tab, click Select Data

    This selects the data range of the chart and displays the Select Data Source dialog box.

  3. To edit a legend series, in the Legend entries (series) box, click the series you want to change. Then, edit the Name and Y values boxes to make any changes.

    Note: Changes you make may break links to the source data on the worksheet.

  4. To rearrange a legend series, in the Legend entries (series) box, click the series you want to change and then select the or arrows.

Filter data in your chart

  1. In Word and PowerPoint: Select your chart and then on the Chart Design tab, click Edit Data in Excel.

    Office for Mac Chart Edit in Excel

    In Excel, select the category title and then in the Home tab, click Sort & Filter > Filter.

    Excel for Mac Sort Filter command
  2. 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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.