Fix Linked Excel Charts Resizing or Losing Data in PowerPoint
Question details
The user needs to stop linked Excel charts embedded in a PowerPoint presentation from automatically changing size or losing data upon being refreshed.

- Product
- Microsoft PowerPoint and Excel
- Device & OS
- not provided
- Scenario
- Updating or refreshing chart data in a presentation that is linked to a large data range in an external spreadsheet.
- Observed behavior
- The embedded chart unexpectedly loses data or its dimensions shrink/expand after the update process is triggered.
Ensure both your presentation and spreadsheet files are saved locally in the same folder before troubleshooting to prevent cloud synchronization delays from disrupting the data links.
Use Keep Source Formatting & Link Data
Changing the paste method from a standard Chart Object to a specific data link format preserves the original chart dimensions and prevents data loss during refreshes.
By default, using the Paste Special > Microsoft Excel Chart Object method can force the chart to conform to placeholder boundaries in PowerPoint. Using the direct link data option establishes a much more stable connection between the applications.
Open your source Excel workbook, click on the edge of the chart to select it, and press Ctrl+C to copy.
Navigate to the desired slide in your PowerPoint presentation. Instead of using 'Paste Special', click the drop-down arrow directly under the 'Paste' button on the Home tab.
Look for the paste option icons and select 'Keep Source Formatting & Link Data'. This embeds the chart securely while locking in its original size.

Test with a New Workbook and Update Software
Corrupted source files or outdated software versions can cause erratic behavior with linked objects.
Create and Present Flawlessly with WPS Office
If linking Excel charts in PowerPoint continues to cause layout distortions and data loss, consider switching to WPS Office. It provides a highly compatible, lightweight, and free alternative to Microsoft Office, ensuring smooth transitions and stable chart linking between spreadsheets and presentations.
- 1. Download and Install WPS Office: Visit the official WPS website and download the free, lightweight installer for your device.
- 2. Open Your Existing Files: Open your Microsoft Excel (.xlsx) and PowerPoint (.pptx) files directly in WPS Spreadsheet and WPS Presentation without losing any formatting.
- 3. Link Data Smoothly: Copy your charts from WPS Spreadsheet and paste them into WPS Presentation using built-in stable link options for seamless updates.

Frequently Asked Questions
Why do my Excel charts change size when pasted into PowerPoint?
This usually occurs when you paste the chart as a 'Microsoft Excel Chart Object' or place it inside a dynamic content placeholder. PowerPoint tries to automatically resize the object to fit the placeholder boundaries upon refresh. Using 'Keep Source Formatting & Link Data' bypasses this automatic resizing.
How can I manually force an update of linked Excel chart data in PowerPoint?
You can force an update by right-clicking the linked chart in PowerPoint and selecting 'Edit Data'. Alternatively, you can go to File > Info > Edit Links to Files, select the specific Excel document, and click the 'Update Now' button.
Will emailing my PowerPoint presentation break the linked Excel charts?
Yes, if the recipient does not have access to the original source Excel file (e.g., it is stored locally on your hard drive), the charts cannot be refreshed on their end. To prevent broken links, place both files in a shared network/cloud folder, or break the links before sending to convert the charts into standard images.




