Office Compatibility Issues

Fix Linked Excel Charts Resizing or Losing Data in PowerPoint

Camila MilosovichCamila Milosovich Nov 2, 2026 870 views

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.

How to Fix Linked Excel Charts Resizing or Losing Data in PowerPoint
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.
Before you start

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.

Solution 1Recommended

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.

1
Copy the Excel Chart

Open your source Excel workbook, click on the edge of the chart to select it, and press Ctrl+C to copy.

2
Open Paste Options in PowerPoint

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.

3
Select the Correct Link Option

Look for the paste option icons and select 'Keep Source Formatting & Link Data'. This embeds the chart securely while locking in its original size.

Use Keep Source Formatting & Link Data
Maintains Chart Integrity: This targeted paste method ensures that future updates to the Excel data seamlessly reflect in PowerPoint without altering the visual layout.
Free Microsoft Office alternative

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. 1. Download and Install WPS Office: Visit the official WPS website and download the free, lightweight installer for your device.
  2. 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. 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.
Fully compatible with Microsoft Excel (.xlsx) and PowerPoint (.pptx) formats.Stable and reliable object linking across Spreadsheet and Presentation apps.Lightweight design that runs smoothly even when handling large datasets.Free to use with an intuitive, familiar tabbed interface requiring no learning curve.
microsoft office alternative - wps office

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.