PowerPoint for Microsoft 365 PowerPoint 2021 PowerPoint 2019 PowerPoint 2016 More...Less
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.
Newer versionsOffice 2013–2019
Change chart data on a slide
-
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.
-
OnChart Design tab, in the Data group, selectEdit Data.
-
Doone of the following:
-
To edit the data in PowerPoint, selectEdit 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, selectEdit Data in Excel.
-
-
Make the changes you want. They will be reflected in the chart in PowerPoint.
Change chart data on a slide
-
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.
-
Under Chart Tools, on the Design tab, in the Data group, click Edit Data.
-
Do one of the following:
-
To edit data in PowerPoint, selectEdit 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, selectEdit Data in Excel.
-
-
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?
Discover Community
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.
