You need to place a chart in a PowerPoint slide that updates automatically when the underlying Excel data changes. Manually copying and pasting a chart creates a static image that does not refresh when you edit the source workbook. This article explains how to insert a chart from Excel into PowerPoint as a linked object so the slide chart stays synchronized with your spreadsheet. You will learn two reliable methods and how to manage the data connection.
Key Takeaways: Inserting a Live Excel Chart in PowerPoint
- Copy and Paste Link (Home > Paste > Paste Special > Paste link): Creates a chart that updates when the Excel source data changes.
- Insert Object (Insert > Text > Object > Create from file): Embeds the entire Excel workbook or a specific chart sheet as a linked object.
- Ctrl+Alt+F5 (Refresh Data): Manually forces the linked chart to update in PowerPoint when the source file has been modified.
How Linked Charts Work Between Excel and PowerPoint
A linked chart stores a reference to the source Excel file instead of embedding a copy of the data inside PowerPoint. When you open the presentation, PowerPoint reads the current data from the Excel file and renders the chart accordingly. This keeps the chart accurate without requiring you to reinsert it after every data change.
The link relies on the file path of the Excel workbook. If you move or rename the Excel file, the link breaks and the chart stops updating. You must keep the source file in the same relative location or use PowerPoint’s Edit Links to Files command to reconnect it.
Two prerequisites apply. First, the Excel workbook must already contain a chart or a data range that PowerPoint can display as a chart. Second, both the Excel file and the PowerPoint file should be saved before you create the link. Unsaved files do not have a stable file path for linking.
Method 1: Copy and Paste a Linked Chart
This method creates a linked chart that behaves like a native PowerPoint chart but pulls data from Excel. It is the fastest approach for a single chart.
- Open both files
Open the Excel workbook that contains the chart you want to link. Open the PowerPoint presentation where you want the chart to appear. - Copy the chart in Excel
Click once on the chart border in Excel to select the entire chart object. Press Ctrl+C or right-click and choose Copy. - Switch to PowerPoint and choose the slide
Click the slide where you want the chart to appear. You can insert the chart on any slide layout. - Paste as a linked object
Go to Home > Paste > Paste Special. In the dialog box, select Paste link. From the list on the right, choose Microsoft Office Graphic Object. Click OK. - Verify the link
Right-click the chart in PowerPoint and select Linked Chart Object > Links. You should see the file path of your Excel workbook listed. Click Close.
The chart now reflects the data in the Excel file. Any changes you make to the source data in Excel appear in PowerPoint after you save the Excel file and refresh the link in PowerPoint.
Method 2: Insert an Excel Chart as a Linked Object
This method inserts the entire chart sheet or a specific chart from a saved Excel file. It is useful when you want to embed the chart together with its source data range.
- Save the Excel workbook
Ensure the Excel file is saved to a location you will not move. The file path becomes part of the link. - Open PowerPoint and select the target slide
Click the slide where the chart will appear. - Go to Insert > Object
On the Insert tab, in the Text group, click Object. The Insert Object dialog opens. - Choose Create from file
Select the Create from file radio button. Click Browse, locate your Excel file, and select it. Check the box labeled Link. Do not check Display as icon unless you want an icon instead of the chart. - Click OK
PowerPoint inserts the first visible chart or the top-left object from the Excel file. If the workbook contains multiple charts, you may need to use Method 1 for precise chart selection.
The inserted object is a live linked chart. Double-clicking it in PowerPoint opens the source Excel file for editing.
Refreshing the Linked Chart Data
Linked charts do not update automatically while PowerPoint is open. You must manually refresh the data connection after you save changes in Excel.
- Save the Excel file after making changes
Press Ctrl+S in Excel to commit the data changes to disk. - Switch to PowerPoint
Click the chart to select it. Go to Chart Design > Refresh Data. Alternatively, press Ctrl+Alt+F5. - Check for update prompts
If you open the PowerPoint file later, a security warning may appear below the ribbon. Click Enable Content to allow the linked data to refresh.
If the chart does not update, the link may be broken. Go to File > Info > Edit Links to Files. Select the link and click Update Now.
Common Issues With Linked Charts
The chart shows a red X or broken image
This happens when PowerPoint cannot find the source Excel file. Move the Excel file back to its original location or use File > Info > Edit Links to Files to change the source path. Click Change Source and browse to the correct file.
Data updates do not appear after refreshing
The Excel file may not have been saved after the last change. Open Excel, press Ctrl+S, then refresh the link in PowerPoint. If the workbook contains manual calculation mode, press F9 in Excel to recalculate before saving.
The chart looks different after updating
Linked charts inherit formatting from Excel. If you apply chart styles or color themes in Excel, those changes appear in PowerPoint after refresh. To keep PowerPoint formatting separate, unlink the chart by copying it and pasting as a picture. However, that breaks the data connection.
Linked Chart vs Embedded Chart: Key Differences
| Item | Linked Chart | Embedded Chart |
|---|---|---|
| Data storage | Stored in external Excel file | Stored inside PowerPoint |
| Automatic updates | Updates when Excel file changes and link is refreshed | Does not update; requires manual edit |
| File size impact | Minimal; only link reference stored | Larger; full data and chart stored |
| Portability | Both files must travel together | Chart travels with presentation |
| Editing source data | Edit in Excel | Edit in PowerPoint using Chart Tools |
Linked charts are best for ongoing reports where data changes frequently. Embedded charts work better for one-time presentations where you do not want to manage external files.
You can now insert a chart from Excel into PowerPoint as a linked object that updates with your source data. Use the Copy and Paste Link method for a single chart or the Insert Object method for the entire workbook. Remember to save the Excel file before linking and refresh the chart using Ctrl+Alt+F5 after data changes. For presentations shared with others, package both files together or use the Edit Links to Files command to verify connections before you present.