Dashboard to PowerPoint
Copy the chart in Excel (click its border to select the whole chart, then Ctrl+C), and PowerPoint's Paste Options decide what happens next, because the choices behave very differently. Embed (the default) copies the source data into the .pptx itself — double-clicking the chart later opens that private copy to edit, disconnected from your real workbook, and it bloats the file. Link instead ties the chart to the external Excel file by its file path, so it can refresh when the source changes — but move, rename, or fail to send along that file, and the chart freezes on its last-known data until re-linked. Paste as Picture drops the connection entirely: a static image that never updates.
A worked example
A clustered bar chart sits on Sheet1 of Q3-Report.xlsx, built from a small summary table, and needs to land on a slide in an existing PowerPoint deck.
Select the chart's border (not one bar) in Excel, Ctrl+C, switch to PowerPoint, and either Ctrl+V (embeds by default) or open Paste Options first and choose Link Data instead.
Embedded: PowerPoint gets a private copy of the data, so nothing changed in Q3-Report.xlsx afterward reaches the slide. Linked: the same chart instead re-reads Q3-Report.xlsx by its saved file path — move or rename that workbook and the chart stops refreshing until the link is pointed at the new location.
Which one do I need?
| If you want to… | Use |
|---|---|
| You haven't built the chart in Excel yet | Build it there first — Insert > Chart on the summary data |
| The slide only needs to show the chart once, and it should never change | Paste as Picture — smallest file size, but it's an image with no chart data behind it |
| The presentation should reflect the latest numbers, and the Excel file will stay in the same place | Paste Options > Link Data — keeps the chart tied to the external .xlsx by its file path |
| The presentation needs to be sent or shared without its source workbook attached | The default paste (Embed) — the data travels inside the .pptx, so nothing breaks without the Excel file |
| A linked chart's source workbook was later moved, renamed, or is missing | The chart freezes on its last-refreshed data — repoint it via File > Info > Edit Links to Files once the workbook is back at a known path |
| The chart should match the slide's theme rather than keep Excel's original colors | Pick a "Use Destination Theme" paste option instead of "Keep Source Formatting," whether embedding or linking |
Frequently asked questions
Why did my linked chart show old numbers after I updated the Excel file?
A linked chart only refreshes when PowerPoint checks the source again — right-click the chart and choose Refresh Data (or Edit Data, then close it) after changing the workbook. It stays frozen on stale data with no warning if the source file was also moved or renamed, since PowerPoint can't find it to check at all.
What's the actual difference between Embed and Link when pasting a chart?
Embed copies the chart's underlying data into the PowerPoint file itself, so the slide displays correctly with no other file present, but changes to the original workbook never reach it. Link instead points at the external Excel file by its saved path and can pull fresh numbers from it — at the cost of breaking the moment that file moves or isn't shared alongside the presentation.
Does linking keep the PowerPoint file smaller than embedding?
Yes. A linked chart stores almost none of the source data inside the .pptx, so a deck built from several linked charts stays far smaller than one where each chart embedded its own copy of the workbook.
Is there a Google equivalent for putting a chart into a slide deck?
Yes — in Google Slides, Insert > Chart > From Sheets lets you pick a chart from a Google Sheets file and choose Link to spreadsheet, which adds an Update button you click to pull in the latest numbers, or paste it unlinked as a static image. It's the same embed-vs-link-vs-picture choice as PowerPoint, under different menu names.
New guides and tools, once a month
DE + EN · double opt-in · no spam