How to Embed Multiple Excel Charts in Word Without Broken Links
Question details
The user wants to insert multiple Excel charts into a Word document without causing bloated file sizes from repeated embedded workbooks, or broken link warnings if the external source file is moved.

- Product
- Microsoft Word / Excel
- Device & OS
- not provided
- Scenario
- Creating fixed reports (such as annual reports) that require multiple charts from an Excel workbook to be displayed in a Word document without unintended data changes.
- Observed behavior
- Linking charts causes missing-file warnings or unexpected updates when the source file is moved or changed, while embedding charts normally duplicates the underlying workbook, drastically increasing the Word document's file size and complexity.
Before embedding your charts, determine if your Word report requires live data updates or a static snapshot. Ensure your source Excel workbook is fully finalized and saved to prevent pasting incomplete data.
Paste Excel Charts as Static Pictures
Use this method to create a fixed snapshot of your charts without external link dependencies or bloated document sizes.
Pasting a chart as a picture entirely removes links to the original Excel file. This is the safest method for final reports where data will not change, as it prevents broken link warnings if the file is moved or shared with others.
Open your Excel workbook, click on the outer edge of the chart you want to export, and press Ctrl+C or right-click and select 'Copy'.
Switch to your Word document and place your text cursor exactly where you want the chart to appear.
Right-click the document area. Under 'Paste Options', select the 'Picture' icon (or click the Paste dropdown on the Home tab and choose 'Paste as Picture').
Use Paste Special to Embed the Chart Object
Use this method if you need to retain the ability to edit the chart design or data within Word, without linking to an external file.
Effortlessly Manage Charts and Data with WPS Office
WPS Office allows you to seamlessly copy and paste charts between WPS Spreadsheet and WPS Writer. With its intuitive interface and lightweight design, you can easily embed static pictures or chart objects without crashing or unnecessarily bloating your document.
- 1. Copy the chart: Open your data in WPS Spreadsheet, select the chart, and press Ctrl+C.
- 2. Switch to your report: Open your target report in WPS Writer.
- 3. Choose your paste option: Click the 'Paste' dropdown on the Home tab.
- 4. Select the format: Select 'Paste as Picture' for a static, lightweight report, or 'Keep Source Formatting & Embed Workbook' for editable data.

Frequently Asked Questions
Why does my Word document size increase so much when I embed multiple Excel charts?
When you use the standard embed option, Word often embeds an entire hidden copy of the underlying Excel workbook for each chart you paste. To reduce file size, consider pasting the charts as pictures instead.
How can I update a linked chart if the Excel file was moved?
If you linked a chart and moved the source file, you can update the link by going to File > Info > Edit Links to Files in Word. Select the broken link from the list, click 'Change Source', and locate the new Excel file path.
Can I edit the data of a chart pasted as a picture?
No, once a chart is pasted as a picture, it loses all its underlying data connection and becomes a static image. You will need to update the data in the original Excel file and copy-paste it again to reflect any changes.




