Link an Excel Chart to PowerPoint Without Losing Updates

To link an Excel chart to PowerPoint in Microsoft 365 on Windows, select the chart in Excel and press Ctrl+C, then in PowerPoint choose Home > Paste ▼ > Use Destination Theme & Link Data or Keep Source Formatting & Link Data. The chart stays connected to the Excel workbook, so you can update it from its source. Before you start, save the workbook and note where it is stored; PowerPoint needs access to that file to refresh the link.

A linked chart is different from a pasted picture or an embedded chart. A picture cannot update, and an embedded chart stores a separate copy of its data in the presentation. A linked chart refers back to the Excel file instead. That is useful when figures change regularly, but it also means the link can break if the workbook is moved, renamed, or unavailable.

What You’ll Need

Excel and PowerPoint for Microsoft 365 desktop apps on Windows. The steps also work in many recent desktop versions, though ribbon labels can differ slightly.
An Excel workbook containing a finished chart, saved in a location you can access. A shared network folder or OneDrive/SharePoint location can work, provided the people opening the presentation have permission to reach the source.
A PowerPoint presentation where you want the chart to appear. Keep the workbook in its intended location before you create the link.

Step-by-Step

Prepare and save the Excel chart. Open the workbook in the Excel desktop app, check that the chart displays the right data and labels, and save the file with Ctrl+S. If the chart should include new rows or columns in future, check its source range first: select the chart, then use Chart Design > Select Data to review the data range. A chart linked to a fixed range may not automatically include records added beyond that range.
Select the chart object, not just its data. Click the outer edge of the chart until the whole chart is selected and its sizing handles appear. Avoid clicking an individual bar, point, title, or legend item, since that can select only one chart element. Press Ctrl+C. If you copy cells instead, PowerPoint may offer a linked table rather than a chart.
Choose where the chart should go. Switch to PowerPoint and open the target slide. Click a blank area where you want the chart; you can resize or reposition it afterward. If the slide uses a particular design, decide whether the chart should follow the PowerPoint theme or retain its Excel appearance.
Open the paste choices. On the PowerPoint ribbon, choose Home, then click the arrow beside Paste. Select Use Destination Theme & Link Data to make the chart adopt the presentation’s theme while remaining linked, or Keep Source Formatting & Link Data to preserve more of its Excel formatting. The option names can vary slightly by Office build. Check that the option explicitly says “Link Data”; a similarly named option without “Link” may create an embedded copy instead.
Use Paste Special if you do not see a link option. With the copied chart on the clipboard, choose Home > Paste ▼ > Paste Special. In the dialog, select Paste link, choose Microsoft Excel Chart Object from the list, and click OK. Do not choose Paste if you specifically need an external workbook link. If “Paste link” is unavailable, recopy the complete chart from the desktop Excel app and make sure the workbook is saved.
Check the result in PowerPoint. Select the chart and look for chart-specific controls such as Chart Design, or right-click it and check whether options for editing or updating linked data are available. You can also use File > Info and look for Edit Links to Files. If the link is listed, PowerPoint recognizes the external source. Save the presentation with Ctrl+S.
Test that the link updates. In Excel, change a value that is represented in the chart and save the workbook. Return to PowerPoint. If asked whether to update links, choose Update Links. If there is no prompt, use File > Info > Edit Links to Files, select the workbook link, and choose Update Now if that control is available. Confirm that the displayed chart reflects the change, then save the presentation.
Keep the workbook available when sharing. Place the presentation and source workbook in a shared folder or a shared OneDrive/SharePoint location, and give recipients permission to both. Test the presentation from the location and account your audience will use. Sending only the PowerPoint file does not normally include the external workbook data required for later updates.

Mac note: In PowerPoint for Mac, copy the chart in Excel and check the Home tab’s Paste menu for a linked-data option. Depending on the Office version and clipboard contents, the exact choices may differ. You can also check Edit > Paste Special for a Paste link option. If the link-specific choice is absent, use PowerPoint for Windows for this workflow or choose an embedded chart as a self-contained alternative. In Excel for the web, open the workbook in the desktop app to copy and link the chart; browser clipboard options may not provide the same link controls.

Common Mistakes

Choosing a paste option that is not linked. “Keep Source Formatting” or “Use Destination Theme” alone may paste an embedded chart rather than a live link. Read the full option label and choose the one that includes “Link Data.” If unsure, use Paste Special and confirm that Paste link is selected.
Moving or renaming the workbook after linking. The presentation stores a reference to the source location. If the file path changes, PowerPoint may be unable to find the workbook. Establish the shared folder first, then create the link; if a move is unavoidable, use Edit Links to Files to change the source.
Sharing the presentation without the source file. A recipient may see the last saved chart but be unable to refresh it. Share the workbook as well and ensure the recipient has access. A link to a file on your computer, such as a local Downloads folder, will not be useful to someone else.
Expecting every chart adjustment to flow both ways. A linked chart is primarily a way for PowerPoint to display the Excel chart and refresh its data. Some formatting edits made in PowerPoint may not be written back to Excel. Make source-data or chart-design changes in Excel when you want the workbook to remain authoritative.
Assuming new rows are included automatically. If the chart’s source range covers rows 2 through 20, adding a record on row 21 may not expand the chart. Use an Excel table as the chart source or revise the range through Chart Design > Select Data, then save and refresh the PowerPoint link.

Tips

Use a clear source-file name and stable folder. Names such as QuarterlySales.xlsx are easier to identify in link-management dialogs than a series of files named Final2 or Copy. Avoid changing the folder structure after linking, especially near a presentation deadline.
Choose formatting deliberately. Use Destination Theme when the presentation’s fonts and colors should control the chart. Use Keep Source Formatting when the Excel chart’s specific styling matters. Linking data does not guarantee that every font or layout detail will look identical across machines, so inspect the slide at presentation size.
Save both files after changes. Save the Excel workbook after changing data, then update and save the PowerPoint presentation. This helps preserve the latest chart appearance for people who open the deck without refreshing links.
Plan for offline use. If the presentation must work with no access to the workbook, an external link is a poor fit. Keep an embedded chart or paste a picture for a fixed snapshot instead. A picture is most reliable visually but cannot be edited as chart data.
Keep a second copy before changing many links. If you need to break or redirect several links, save a copy of the presentation first. Breaking a link usually leaves a static version of the chart, but it removes the connection needed for future updates.

Troubleshooting

The chart pastes, but it does not update. Check how it was pasted: in PowerPoint, open File > Info > Edit Links to Files. If the workbook is listed, select it and choose Update Now. If no link is listed, the chart was likely embedded or pasted as a picture. Copy it again from Excel and select a paste choice containing “Link Data.”
PowerPoint says it cannot find the source. Confirm that the workbook still exists at the saved location and that you can open it. In Edit Links to Files, use Change Source if available to point to the workbook’s new location. If the file is on a shared drive or cloud service, check that you are signed in and connected, and that permissions allow access.
The update prompt does not appear. Use File > Info > Edit Links to Files to update the source manually. Office security settings can also affect external links. Only update a link when you trust the workbook and its location; do not enable content from an unexpected file just to make the prompt disappear.
The chart looks different after pasting. Try the other linked paste choice: switch between Use Destination Theme & Link Data and Keep Source Formatting & Link Data. Check the chart’s size, fonts, and colors in Slide Show view. If a particular appearance is essential, adjust the chart in Excel and refresh it in PowerPoint.
The chart shows old values even after an update. Save the Excel workbook, verify the changed cells are inside the chart’s source range, then select Update Now in the link dialog. If the workbook contains formulas, confirm their results have recalculated and saved. Close and reopen the presentation if necessary, then check the link again.

Frequently Asked Questions

Does a linked Excel chart update automatically in PowerPoint?
It can update when the presentation opens or when you request an update, depending on the link and security settings. If you do not see current values, use File > Info > Edit Links to Files and update the source.

Can I link a chart if the Excel workbook is closed?
Yes, the workbook does not have to remain open after you create the link. It does need to remain available at the saved path when PowerPoint refreshes the chart.

What is the difference between linking and embedding a chart?
A linked chart refers to a separate Excel workbook and can refresh from it. An embedded chart keeps chart data in the PowerPoint file, making the presentation more self-contained but separating it from the original workbook.

Can I send someone the PowerPoint without sending the Excel file?
You can send it, but the recipient may only have the chart’s last saved display and may not be able to update it. Share the source workbook too, with a location and permissions the recipient can access.

Can I edit a linked chart directly in PowerPoint?
You can resize and position it, and some visual formatting may be available. For dependable changes to chart data, labels, or the underlying design, edit the chart in Excel, save the workbook, and refresh the link.

What if I want a chart that never changes?
Use a picture for a fixed visual, or embed the chart if you want recipients to edit its data inside PowerPoint. Neither choice maintains a live connection to the original Excel workbook.

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.