Insert a Live Excel Chart Into PowerPoint and Update It

To insert a live Excel chart into PowerPoint, copy the chart in Excel, then in PowerPoint for Microsoft 365 on Windows choose Home > Paste > Paste Special, select Paste link and Microsoft Excel Chart Object, and choose OK. The chart remains linked to its Excel workbook, so PowerPoint can refresh it when the source data changes; it does not update continuously like a live dashboard.

What a live Excel chart means

In this context, live usually means linked: the chart displayed on a PowerPoint slide gets its data from an Excel workbook. If someone changes a value in the workbook, the chart can reflect that change after the link is refreshed. The workbook is the source of truth, while the slide contains a linked chart object.

A link is different from an embedded chart. An embedded chart includes a copy of the chart data inside the PowerPoint file. It can be edited without the original workbook, but changes made later to the separate Excel file will not flow into it. A chart pasted as a picture is more limited still: it looks like a chart, but its data and chart elements are not editable as an Excel chart.

“Live” also does not mean that every open presentation instantly detects every spreadsheet edit. Updates generally happen when PowerPoint refreshes the link, such as when the presentation opens and you approve an update, or when you use an available link-update command. The source workbook must be reachable for the link to work.

Choose linked, embedded, or picture format

Choose the format based on whether you value automatic updates, portability, or visual simplicity. The paste choices may appear in PowerPoint’s Paste menu after you copy a chart, or through the Paste Special dialog.

Link the chart when the workbook will continue to be maintained and the slide needs to reflect its latest figures. This is useful for recurring reports, such as monthly sales presentations.
Embed the workbook data when the recipient should be able to edit the chart data but does not need a connection to a separate source file. The embedded copy will not stay synchronized with the original workbook.
Paste as a picture when appearance matters more than editing or updating. This can prevent accidental chart changes, but figures must be refreshed by replacing the image.

PowerPoint may offer choices such as Use Destination Theme & Link Data and Keep Source Formatting & Link Data. Both link the chart; the difference is whether its presentation styling follows the PowerPoint theme or retains Excel’s formatting. Options labelled Embed Workbook create a self-contained copy instead.

Prepare the Excel chart and workbook

Before copying, make the chart readable at the size it will appear on the slide. Check that the title, axis labels, legend, and data labels are legible, and remove worksheet elements that do not belong in the presentation. A chart can be resized after pasting, but shrinking a busy chart may make its labels hard to read.

Open the workbook in the Excel desktop app and confirm that the chart uses the intended data range.
Save the workbook in a location that will remain available, such as a shared project folder or an organization’s supported OneDrive or SharePoint location.
Click the chart’s outer border so the whole chart is selected, rather than selecting a single bar, point, or text label.
Press Ctrl+C to copy it. On a Mac, use Command+C.

If the chart uses a fixed range, adding new data outside that range may not add it to the chart. For a report that grows over time, consider building the chart from an Excel Table, then check that newly added rows are included in the chart before relying on it in slides.

Insert the chart as a link in PowerPoint

In PowerPoint for Microsoft 365 on Windows, open the presentation and select the destination slide. Use the Paste Special dialog to make the link explicit:

On the Home tab, open the Paste dropdown and choose Paste Special. You can also use Ctrl+Alt+V to open Paste Special in Windows Office apps.
In the dialog, select Paste link, then choose Microsoft Excel Chart Object from the list of formats.
Choose OK. Position and resize the chart using its corner handles, taking care not to stretch it disproportionately.

In some versions, the Paste dropdown shows linked chart choices directly, including Use Destination Theme & Link Data and Keep Source Formatting & Link Data. Choose one of those if you want to link while controlling the chart’s appearance. If the Paste link option is unavailable, verify that you copied an Excel chart object and that Excel and PowerPoint are desktop apps; a browser-based workflow may not expose the same linking choices.

On Mac, use Command+C and Command+V for copying and pasting. Paste options and Paste Special availability can differ by Office version, so inspect the options PowerPoint presents. If it does not offer a linked Excel chart choice, create the link in PowerPoint for Windows or use an embedded chart or picture as a practical alternative. PowerPoint for the web is useful for viewing and collaborating, but use the desktop apps when you need the fullest control over linked-object creation and refresh.

Refresh the chart and check that it works

After inserting the chart, test it before sharing the presentation. Change a harmless test value in the source workbook, save the workbook, return to PowerPoint, and check whether the slide offers to update the link. If it does not refresh automatically, open File > Info and look for Edit Links to Files. When that command is available, select the relevant link and choose Update Now.

PowerPoint may show a prompt asking whether to update links when a presentation opens. Updating reads information from the source workbook; declining leaves the chart showing its last saved values. The exact prompt and link controls can vary with Office version and organizational security settings. If the link is not listed under File > Info, check that the chart was pasted as a link rather than embedded.

To verify more than the numbers, compare the chart title, categories, series, and displayed values with Excel. A linked chart can show stale figures if the source file was not saved after editing, or if the chart’s data range does not include recently added rows. For a final presentation, save both files after the last update and reopen the slide deck to confirm the chart displays the intended data.

Keep the workbook link from breaking

A linked chart depends on PowerPoint being able to find its source workbook. Moving, renaming, deleting, or restricting access to that file can break the relationship. A link that works on the author’s computer may not work for a colleague whose account cannot access the same network folder or cloud file.

Keep the presentation and workbook in a stable shared location, and make sure intended viewers have permission to open the workbook.
When moving a project, move both files and then test the presentation from its new location. If necessary, use File > Info > Edit Links to Files and choose Change Source to point to the workbook’s new location.
Send or share the source workbook with the presentation when recipients need the chart to update. A slide deck alone may not contain the separate source file.
Before distributing a final deck, decide whether the recipient needs an active link. If not, use an embedded chart or picture so the slide does not depend on an external path.

Cloud storage does not remove the need to check access. A recipient may need to sign in to the account or organization that can open the workbook. Do not assume that attaching a presentation to an email also includes, or grants access to, its linked workbook.

Format and edit a linked chart

You can often resize and position a linked chart in PowerPoint like other objects. Some visual formatting can also be applied in the presentation, but the chart’s source data still belongs to Excel. If you need to change the underlying values, categories, or chart structure, edit the source workbook, save it, and refresh the link rather than treating the slide as the authoritative data source.

Use the formatting option that matches the deck. Keep Source Formatting preserves the Excel chart’s styling; Use Destination Theme makes it fit more closely with the PowerPoint theme. Neither choice changes the underlying data connection. If the chart becomes hard to read after fitting it to a slide, simplify its labels or split it into separate charts instead of shrinking it until text is unreadable.

Double-clicking a linked chart may open or activate its source content, depending on the object and installed Office apps. It is not a safe substitute for checking the workbook itself. Confirm which workbook is being edited, especially if several similar copies exist.

Common problems and fixes

The chart does not update: Save the Excel workbook, then use the available update command in PowerPoint. Confirm that the chart was linked, not embedded, and that the source file is accessible.
PowerPoint asks to update links: This is expected for linked content. Update only when you trust the source file and want its latest data; otherwise, keep the saved values and investigate the link first.
The link is broken: The workbook may have moved, been renamed, or become unavailable to your account. Restore access or use Change Source in Edit Links to Files to select the correct workbook.
New rows are missing: Check the chart’s source range in Excel. The chart may be based on a fixed cell range that excludes the new records.
Formatting changes unexpectedly: The chosen paste option may apply the destination theme. Re-paste using Keep Source Formatting & Link Data if that option is available, or format the chart for consistency after insertion.

Link-update prompts are also a security consideration: linked files can contain information that should not be shared. Only update links from sources you recognize, and review the source workbook’s contents and sharing permissions before distributing a deck.

Frequently Asked Questions

Does a linked Excel chart update automatically in PowerPoint?
A linked chart can refresh from its workbook, but it is not guaranteed to update instantly whenever a cell changes. Save the workbook and refresh or approve the link update in PowerPoint. Embedded charts do not synchronize with the separate workbook.

Can I send the PowerPoint without sending the Excel file?
You can send the presentation, but recipients may not be able to refresh a linked chart unless they can access its source workbook. If they only need to view the current chart, consider embedding the data or pasting a picture before sharing.

Can I edit the data from PowerPoint?
For a linked chart, make data changes in its source workbook and then refresh the link. An embedded chart contains its own data copy and can generally be edited without the original workbook, but those edits do not change that separate file.

What is the difference between linking and embedding?
Linking keeps a connection to a separate workbook and can reflect updates from it. Embedding stores chart data in the presentation, making the deck more self-contained but leaving it independent of later changes to the original workbook.

Why is Paste link missing?
Check that you copied the chart itself in the Excel desktop app and are pasting into the PowerPoint desktop app. The available choices can vary by platform and version; if no linked option appears, use a supported Windows desktop workflow or choose an embedded chart.

Which option is right for a recurring presentation?

For a recurring report, a linked chart is usually the better fit when one maintained workbook supplies the numbers and the presentation needs periodic refreshes. Keep the files in a stable, accessible location, check the chart’s data range, and verify the update before presenting. For a deck that must travel independently or remain unchanged, embed the chart data or use a picture instead. The important distinction is simple: linked means refreshable from a source file, not automatically synchronized under every circumstance.

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.