How to Insert a Dynamic Excel Chart in PowerPoint

To insert a dynamic Excel chart in PowerPoint for Microsoft 365 on Windows, select the chart in Excel, press Ctrl+C, then in PowerPoint choose Home > Paste and select Use Destination Theme & Link Data or Keep Source Formatting & Link Data. The link lets PowerPoint use the Excel chart and update it from its source workbook; make the Excel chart’s data range expandable as well if you want new rows to appear in the chart.

What “dynamic” means in a linked chart

There are two parts to a dynamic chart. First, the chart in Excel must include the data you want to display, including any new records you add later. Second, the chart pasted into PowerPoint must be linked to the Excel source rather than pasted as a static picture or an independent copy. A link connects the PowerPoint object to the chart in a particular workbook; it does not automatically make a fixed Excel chart range grow.

When the source workbook changes, PowerPoint can update the linked chart to reflect those changes. Depending on the presentation’s link settings, Office may ask whether to update links when the file opens. A link is therefore useful for a recurring report or dashboard, but it depends on PowerPoint being able to find the source workbook and on the data being refreshed in Excel.

“Dynamic” does not necessarily mean that every change appears instantly while someone edits the workbook. Save the source workbook, and update or refresh the linked object in PowerPoint when needed. A chart can also display previously saved values if the source is unavailable or the link has not been updated.

Prepare the Excel chart and data

Before copying the chart, check that it is based on the right data and that its range can include future entries. In Microsoft 365 for Windows, an Excel Table is often a convenient choice for a growing list: select the data, choose Insert > Table, confirm the range and headers, then create the chart from the table. When rows are added to the table, Excel charts based on it can include the added records. Enter new records within or immediately below the table so Excel can extend it; check the chart after adding data, especially if the workbook has unusual formatting or layout.

Review these points in Excel before you copy:

Use clear column headers and remove blank rows or columns that could be mistaken for part of the chart’s data.
Confirm the correct series and category labels appear in the chart. Use Chart Design > Select Data if you need to inspect or change the chart’s source range.
Check axis limits, date grouping, filters, and labels. A new value may be included but not visible if the chart is filtered or its axis scale is fixed.
Save the workbook in the location where it will remain available to PowerPoint users.

If your chart uses a PivotTable or PivotChart, new source records may require refreshing the PivotTable before the chart reflects them. A regular table-based chart and a PivotChart have different refresh behavior: adding a row alone does not guarantee that a PivotTable has been refreshed.

Insert the linked chart in PowerPoint

In Excel, click the chart’s outer border so the chart object is selected, then press Ctrl+C on Windows. On a Mac, use Command+C.
Switch to PowerPoint, select the slide, and click where you want the chart to sit. On Windows, open the Home tab, click the arrow beneath Paste, and choose Use Destination Theme & Link Data or Keep Source Formatting & Link Data.
Choose the first option to make the chart fit the presentation’s theme, or the second to retain more of the Excel chart’s formatting. Both options link the chart data to Excel.
Save the PowerPoint presentation. Keep the source workbook as well; the link needs a usable path to it.

On Mac, copy and paste with Command+C and Command+V. The names and placement of paste choices can differ between Office builds. If the paste menu does not show a link option, check Edit > Paste Special for a Paste Link choice and, if offered, select Microsoft Excel Chart Object. If you only see ordinary paste choices, do not assume the result is linked: select the chart in PowerPoint and inspect the available link or data-editing commands.

PowerPoint’s linked-chart options are different from an ordinary Paste, which may create an embedded chart or another kind of copy. A quick check is to right-click the pasted chart and look for a command such as Update Link, or choose Edit Data and see whether the linked source workbook opens. The exact context-menu commands can vary by Office version and object type.

Keep the chart current as Excel data changes

Update the source in Excel first. Add or correct the records, refresh a PivotTable if the chart depends on one, check that the chart shows the intended result, and save the workbook. Then open the presentation and respond to an update-links prompt if one appears. If there is no prompt, right-click the chart and look for Update Link. In some Windows versions, File > Info includes Edit Links to Files, where you can inspect or update external links; that command is not shown in every situation.

For a repeatable reporting process, use a small checklist rather than relying on the presentation to update itself:

Confirm that the workbook has refreshed data and has been saved.
Open the presentation from a location that can access the workbook, then allow the link to update if prompted.
Inspect the chart’s title, labels, totals, and date range after updating.
Save the presentation after the chart displays the current figures.

Changes to the chart’s design in Excel may also appear after an update, depending on the linked object and paste choice. If the presentation needs a different look from the workbook, set that look in PowerPoint after linking and check it again after subsequent updates. Avoid assuming that every formatting change will remain untouched when the source chart changes.

Choose between linking, embedding, and pasting a picture

Linking is best when the presentation should reflect changes made in a separate Excel workbook. The trade-off is a dependency: moving, renaming, deleting, or restricting access to the workbook can break the link or prevent an update. If several people will use the presentation, store the workbook in a shared location they can access and test the presentation from another user’s account or device. A link to a file on one person’s computer is a fragile choice for a team.

Embedding stores a copy of the chart data within the PowerPoint file rather than maintaining a live connection to the original workbook. It is more portable, but later edits to the original workbook do not automatically flow into the embedded copy. You can edit the embedded chart’s data from PowerPoint, but that is a separate copy to maintain.

Pasting as a picture is appropriate when the chart only needs to look right and should not be edited as chart data in PowerPoint. It is usually stable in appearance and avoids an external workbook link, but it cannot update from Excel. Pick the format based on what matters most:

Linked chart: choose it for a report that should be refreshed from a maintained workbook.
Embedded chart: choose it when the presentation needs editable chart data but should travel without depending on the original file.
Picture: choose it for a fixed visual where updating or editing the chart data is unnecessary.

Common link and update problems

If PowerPoint shows old values, first confirm that the Excel workbook was saved after the data changed. Then check whether the chart itself includes the new data, whether a PivotTable was refreshed, and whether PowerPoint updated the link. Updating the PowerPoint link cannot correct a chart whose Excel source range excludes the new rows.

If PowerPoint cannot find the source, restore the workbook to its expected location or use the link-management options available in your version to locate the correct file. Avoid changing file names or moving either file after linking. If you must move them, update the link and test it before distributing the deck. A recipient may see a link prompt or stale chart if their computer cannot access the workbook.

If the chart looks wrong after updating, compare it with the source chart in Excel. The selected paste option affects theme and formatting, and the presentation may have its own layout constraints. Check that the chart is not displaying a filtered subset, that labels have not been clipped, and that a fixed axis range still suits the updated values. Widening the chart or adjusting its formatting in PowerPoint may help, but verify the result after the next link update.

Also consider what data the file exposes. A linked chart relies on an external workbook; an embedded chart can carry data inside the presentation. Do not treat hidden rows, hidden sheets, or chart labels as a reliable way to protect confidential information. If recipients should see only chart-ready figures, use a separate workbook containing only the information intended for sharing and check the files before sending them.

Practical workflow for recurring presentations

For a monthly sales slide, for example, keep the transaction data in an Excel Table and create a chart from that table. Add the latest month’s records, refresh any PivotTable involved, verify the chart in Excel, and save the workbook. Open the PowerPoint deck, update the linked chart, then check that the month labels and scale make sense. This is more dependable than pasting a new chart each month and hoping that its style, size, and placement match the previous slide.

Keep the workbook and presentation together in a stable shared folder where possible, and agree on who maintains the source. Before distributing the deck, open it from the location recipients will use and confirm that the chart displays the intended figures. If the presentation must work offline or be independent of the source, consider embedding a final copy or pasting a picture instead, while recognizing that neither will stay linked to future Excel changes.

Frequently Asked Questions

Will a PowerPoint chart update automatically when I change Excel?
A linked chart can be updated from its Excel source, but it may not refresh instantly while you edit. Save the workbook, then update the link in PowerPoint or accept an update prompt. An embedded chart or picture does not stay connected to the original workbook.

How do I make the chart include new Excel rows?
Build the chart from an Excel Table and add records to that table. Confirm that Excel has extended the table and that the chart includes the new entries. If the chart uses a fixed range or a PivotTable, adjust or refresh its source as appropriate.

Why does PowerPoint show old chart data?
The workbook may not have been saved, the chart’s source range may not include the new data, a PivotTable may need refreshing, or PowerPoint may not have updated the link. Check those steps in that order before recreating the chart.

Can I edit a linked Excel chart in PowerPoint?
You can usually select and format the chart in PowerPoint, and Edit Data may open its Excel source. Changes to the underlying data are maintained in the source workbook, so save that workbook and update the PowerPoint link to show the latest result.

What happens if I email the PowerPoint without the Excel file?
The chart may continue to show its last saved appearance, but PowerPoint may not be able to refresh it. Include the source workbook in an accessible location when recipients need current data; otherwise, use an embedded chart or a picture if a self-contained, non-live result is more suitable.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.