Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

If your PowerPoint presentation contains a chart, you can edit the chart data directly in PowerPoint, whether the chart is embedded in or linked to your presentation. You can also update or refresh the data in a linked chart without having to go to the program in which you created the chart.

Change chart data on a slide

  1. On the slide, select the chart that you want to change. When you do so, two contextual tabs appear on the ribbon: Chart Design and Format. If you do not see the Chart Design and Format tabs, make sure that you click the chart to select it.

  2. On Chart Design tab, in the Data group, select Edit Data.

    The Edit Data options on the contextual Chart Design tab in PowerPoint.
  3. Do one of the following:

    • To edit the data in PowerPoint, select Edit Data. This will open a window from your spreadsheet.

      Note: If the workbook you're working with has special startup requirements, such as enabling content, you'll need to also do that within the window.

    • To edit the data directly in Excel, select Edit Data in Excel.

  4. Make the changes you want. They will be reflected in the chart in PowerPoint.

Change chart data on a slide

  1. On the slide, select the chart that you want to change. When you do so, the Chart Tools contextual tab appears on the ribbon, as illustrated below. If you do not see the Chart Tools tab or the Design tab under it, make sure that you click the chart to select it.

    Note: The Design tab under Chart Tools is not the same as the default Design tab in PowerPoint. The Chart Tools tab appears only when a chart is selected, and the Design, Layout and Format tabs under it provide different commands that relate only to the selected chart.

  2. Under Chart Tools, on the Design tab, in the Data group, click Edit Data.

    Chart tools with Edit data selected
  3. Do one of the following:

    • To edit data in PowerPoint, select Edit Data. This will open a window from your spreadsheet.

      Note: If the workbook you're working with has special startup requirements, such as enabling content, you'll need to also do that within the window.

    • To edit data directly in Excel, select Edit Data in Excel.

  4. Make the changes you want. They will be reflected in the chart in PowerPoint.

What if the "Edit Data" button is unavailable?

If the Edit data button isn't available, read these troubleshooting articles from the Office Answers forum:

Insert a chart into a PowerPoint presentation

To learn how to insert an Excel chart into a presentation, see Use charts and graphs in your presentation.

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.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×