How to Make a Linked PowerPoint Chart Match Excel Structure Changes
Question details
The user needs to ensure that when they add new categories or columns to an Excel chart, the linked chart in PowerPoint updates its overall structure, rather than just updating the existing data values.

- Product
- Microsoft PowerPoint / Excel
- Device & OS
- not provided
- Scenario
- Updating a linked chart in a presentation after expanding the source data structure in a spreadsheet.
- Observed behavior
- The linked PowerPoint chart successfully updates numerical values but fails to display new categories or columns when the source Excel chart structure is modified.
Ensure both your Excel source file and PowerPoint presentation are saved locally on your computer. Keep both files open while establishing the link to prevent temporary synchronization errors.
Create the Chart Link Using Paste Special from Excel
Establishing the link by copying from Excel and using the 'Paste Special' feature in PowerPoint ensures that both data values and chart structure synchronize perfectly.
When a chart is created directly within PowerPoint and linked to an external Excel file, the link often restricts synchronization strictly to data values. By copying the chart directly from Excel and using Paste Special, PowerPoint embeds an OLE (Object Linking and Embedding) link. This allows PowerPoint to read the entire structural composition of the chart, including newly added series and categories.
Open your Excel workbook, select the outer border of the chart you want to link, right-click, and choose 'Copy' (or press Ctrl+C on your keyboard).
Switch to the target slide in your PowerPoint presentation. Go to the 'Home' tab on the ribbon, click the drop-down arrow under the 'Paste' button, and select 'Paste Special'.
In the Paste Special dialog box, select the 'Paste link' radio button. Choose 'Microsoft Excel Chart Object' from the available list and click 'OK'.

Easily Link and Sync Charts with WPS Office
WPS Office provides a highly reliable experience for linking charts between Spreadsheets and Presentation. Enjoy robust data synchronization, ensuring your presentations always display the latest structural updates without complex workarounds.
- 1. Create and copy the chart in Spreadsheets: Open your data in WPS Spreadsheets, highlight your data to create your chart, select it, and copy it using Ctrl+C.
- 2. Paste into WPS Presentation: Open your slide in WPS Presentation, right-click on the canvas, and select 'Keep Source Formatting & Link Data' from the immediate paste options.
- 3. Refresh data effortlessly: When your spreadsheet data expands with new columns, simply click 'Refresh Data' on the chart in your presentation to pull in all structural changes immediately.

Frequently Asked Questions
Why does my linked PowerPoint chart only update values but not new columns?
This usually happens if the chart was inserted natively from PowerPoint using the 'Insert Chart' tool and linked afterward. To sync structural changes like new columns, you must build the chart in Excel first, copy it, and use 'Paste Special > Paste Link' in PowerPoint.
How do I manually force a linked chart to update in PowerPoint?
Select the linked chart in your PowerPoint slide, navigate to the 'Chart Design' tab on the top ribbon, and click 'Refresh Data'. This prompts PowerPoint to fetch the latest values and structural information from the source Excel file.
Can I link an Excel chart to PowerPoint without keeping the original Excel file?
No, a linked chart acts as a window to the original source file. If you move, rename, or delete the source Excel file, the link will break, and the PowerPoint chart will no longer update. Always keep the source file accessible.
How can I fix a broken Excel link in my PowerPoint presentation?
Go to 'File' > 'Info' in PowerPoint and click on 'Edit Links to Files' located in the bottom right properties area. Select the broken link from the list, click 'Change Source', and browse to select the newly relocated or renamed Excel file.




