You want to insert a chart into a Word document that automatically updates when the source data in Excel changes. A linked chart keeps the data connection between the two files active, so you do not need to manually rebuild the chart after each data edit. This article explains how to create a linked chart using Paste Special and how to manage the link to ensure the chart stays current.
Key Takeaways: Inserting a Linked Excel Chart in Word
- Copy the chart in Excel (Ctrl+C): Start by selecting and copying the chart from your Excel worksheet.
- Paste Special > Paste link > Microsoft Excel Chart Object: Use Paste Special in Word to create a live link instead of embedding a static copy.
- Right-click the chart > Update Link: Refresh the chart in Word whenever the source Excel file changes to display the latest data.
Understanding Linked Charts and Prerequisites
A linked chart in Word maintains a connection to its original Excel workbook. When you edit the data in Excel, the chart in Word updates to reflect those changes. This is different from an embedded chart, which becomes a static copy inside Word and does not update when the source file changes.
Before you start, make sure you have the following:
- Microsoft Word and Excel installed on your computer (Microsoft 365, Word 2021, Word 2019, or Word 2016).
- An Excel workbook with a chart already created. The chart can be a column chart, line chart, pie chart, or any other type.
- Both the Word document and the Excel workbook should be saved before linking. If the Excel file is not saved, the link will not work correctly.
You must keep the Excel file in the same location after linking. If you move or rename the Excel file, the link will break and the chart will stop updating.
Steps to Insert a Linked Chart From Excel Into Word
- Open and save the Excel workbook
Open the Excel file that contains the chart you want to link. Go to File > Save to make sure the workbook is saved on your computer. Note the file path because you will need the file to remain there. - Select and copy the chart in Excel
Click once on the chart to select it. A border appears around the chart. Press Ctrl+C to copy the chart to the clipboard. Alternatively, right-click the chart and choose Copy. - Switch to Word and position the cursor
Open or create the Word document where you want the chart. Click at the location where the chart should appear. - Use Paste Special to create a link
On the Home tab in Word, click the arrow below Paste and select Paste Special. In the Paste Special dialog, click the radio button for Paste link. In the As list, choose Microsoft Excel Chart Object. Click OK. - Verify the linked chart appears
The chart appears in your Word document. When you click the chart, you should see the chart border and sizing handles. The chart is now linked to the Excel file.
To test the link, go back to Excel, change a data value that affects the chart, save the Excel file, then return to Word. Right-click the chart and select Update Link. The chart updates to show the new data.
Managing and Updating the Linked Chart
After inserting the linked chart, you can control how and when it updates. Use these steps to manage the link.
- Update the chart manually
Right-click the chart in Word and choose Update Link. The chart refreshes with the latest data from the Excel file. - Change link update settings
Go to File > Info > Edit Links to Files (or File > Info > Related Documents > Edit Links to Files in some versions). In the Links dialog, select the link and click Change Source to point to a different Excel file, or click Break Link to remove the connection. - Set automatic or manual update
In the Links dialog, select the link and click the Update method. Choose Automatic to update the chart every time you open the Word document, or choose Manual to control updates yourself.
Common Problems With Linked Charts
The chart does not update after changing data in Excel
This usually happens when the Excel file is not saved after the data change. Save the Excel file, then right-click the chart in Word and select Update Link. If the link still does not update, open the Links dialog and verify the source file path is correct.
Word shows a broken link message
If you move or rename the Excel file, the link breaks. To fix it, go to File > Info > Edit Links to Files, select the broken link, and click Change Source. Browse to the new location of the Excel file and select it.
The chart appears as a placeholder or icon
This occurs when the Paste Special option is set to display as an icon. Delete the chart and repeat the Paste Special steps. Make sure you select Paste link and choose Microsoft Excel Chart Object, not Display as icon.
The chart formatting looks different in Word
Word uses its own theme colors and fonts by default. To maintain the exact formatting from Excel, use the Keep Source Formatting option in Paste Special instead of the default Use Destination Theme. However, note that Keep Source Formatting may not be available for all chart types.
Linked Chart vs Embedded Chart: Key Differences
| Item | Linked Chart | Embedded Chart |
|---|---|---|
| Data connection | Maintains a live link to the Excel file | No connection; data is stored in Word |
| File size | Smaller because data stays in Excel | Larger because chart data is duplicated |
| Update behavior | Updates when Excel data changes | Does not update; must be re-created |
| Portability | Requires the Excel file to remain accessible | Works independently without the Excel file |
| Best use case | Reports that need live data from a changing source | One-time presentations or documents sent to others |
You can now insert a chart linked to Excel in Word and keep it updated automatically or on demand. Try using the Edit Links to Files dialog to manage multiple linked objects in a single document. For advanced control, consider using the Paste Link option with a specific chart element rather than the whole chart object.