Document Editing Problems

How to Link PowerPoint Charts to Specific Excel Worksheets

Huma Ashraf Ch Sep 28, 2026 868 views

Question details

The user needs to link charts from separate Excel worksheets into a PowerPoint presentation rather than embedding them to keep the file size manageable.

How to Link PowerPoint Charts to Specific Excel Worksheets

Product: PowerPoint, Excel
Device & OS: not provided
Scenario: Optimizing a large presentation by linking external data sources instead of embedding the entire workbook.
Observed behavior: Currently, charts are embedded, which significantly increases the presentation file size. The goal is to establish active links to individual worksheets.

Before you start

Ensure that both your PowerPoint presentation and the source Excel workbook are saved to a stable, permanent folder on your local drive or cloud storage to prevent broken links in the future.

Solution 1Recommended

Use Paste Special to Link Excel Charts

This method establishes a direct link between the PowerPoint slide and the external Excel worksheet, preventing file bloat.

By using the Paste Link feature, PowerPoint will only display a visual representation of the chart while pulling the actual data from the separate Excel file.

Copy the Excel chart

Open your Excel workbook, navigate to the specific worksheet containing your chart, and select the chart. Press Ctrl+C or right-click and choose Copy.

Navigate to the PowerPoint slide

Open your PowerPoint presentation and go to the exact slide where you want the linked chart to appear.

Open the Paste Special dialog

Go to the Home tab on the ribbon. Instead of clicking the main Paste button, click the drop-down arrow below it and select Paste Special.

Apply the Paste Link setting

In the dialog box, select the 'Paste Link' radio button. Then, choose 'Microsoft Excel Worksheet Object' from the list and click OK.

Automating with VBA: If you have a presentation with a massive number of charts, repeating this manually can be tedious. In such cases, you may want to write or record a VBA macro in Excel or PowerPoint to automate the linking process.

Efficient Presentation Management

Link Spreadsheets to Presentations Seamlessly with WPS Office

WPS Office offers a fully integrated suite allowing you to seamlessly link charts from WPS Spreadsheet into WPS Presentation, keeping your files lightweight and professional.

1. Copy from WPS Spreadsheet: Open your data file in WPS Spreadsheet, select the chart you want to use, and copy it.
2. Open WPS Presentation: Switch to your slide deck in WPS Presentation and select the target slide.
3. Access Paste Special: Under the Home tab, click the arrow under the Paste icon and select Paste Special.
4. Link the object: Select 'Paste Link', choose the corresponding Spreadsheet object format, and click OK to finish.

Easily establish dynamic data links between Spreadsheets and Presentations.Fully compatible with Microsoft Office formats, including .xlsx and .pptx.Keep your presentation files lightweight without sacrificing data quality.Familiar user interface makes it incredibly easy to switch and start working.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my linked Excel chart not updating in PowerPoint?

This usually happens if the source Excel file was moved, renamed, or deleted. You can manually update or fix links by going to File > Info > Edit Links to Files in PowerPoint and updating the file path.

What is the difference between embedding and linking a chart?

Embedding saves a full copy of the Excel workbook inside the PowerPoint file, which increases file size but makes it easier to share. Linking only points to the external Excel file, keeping the PowerPoint lightweight and ensuring it updates automatically when the Excel file changes.

Can I share a presentation that contains linked charts?

Yes, but to ensure the recipient can see and update the data, you must send both the PowerPoint file and the linked Excel workbook, ensuring the folder structure remains the same. Alternatively, you can break the links before sending, which converts the charts into static pictures.

Document & File Issues