'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix PowerPoint Linked Excel Charts Changing Size After Refresh
Question details
Users experience linked Excel charts embedded in PowerPoint unexpectedly resizing or changing their aspect ratio when updating data links.
- Product
- Microsoft PowerPoint and Excel
- Device & OS
- not provided
- Scenario
- Updating links of Excel charts embedded in a PowerPoint presentation while using a multi-monitor setup with varying display scaling.
- Observed behavior
- The linked charts automatically change their size or aspect ratio in the presentation slides after the data refresh is triggered.
Before making changes to your display settings or repairing software, ensure you save a backup of both your PowerPoint presentation and the linked Excel workbook to prevent accidental layout loss.
Adjust Monitor Scaling and Disconnect Additional Displays
Resolve scaling conflicts that cause chart resizing by aligning display resolutions or temporarily using a single monitor.
Differences in monitor scaling and display resolution across multiple screens are the most common cause of this issue. When PowerPoint and Excel are open on monitors with mismatched scaling percentages, refreshing the data forces the chart to recalculate its dimensions based on the active monitor's DPI.
Temporarily disconnect any external monitors so you are only working on your primary laptop or desktop screen.
Open the PowerPoint presentation and click 'Refresh Data' on the linked Excel charts to see if they maintain their original size.
If you must use multiple monitors, right-click your Windows desktop, select 'Display settings', and ensure all monitors are set to the exact same 'Scale and layout' percentage (e.g., 100%).
Move both the Excel workbook and the PowerPoint application to the same display with matching scaling before refreshing the data links.
Perform an Online Repair of Microsoft 365
If the issue affects all presentations regardless of your monitor setup, repair your Office installation to fix underlying application bugs.
Try WPS Office for Stable Presentation and Chart Workflows
If you frequently encounter scaling bugs and linking issues between Microsoft PowerPoint and Excel, consider switching to WPS Office. It provides a highly compatible, lightweight environment for handling spreadsheets and presentations smoothly without frustrating multi-monitor scaling conflicts.
- 1. Download WPS Office: Install the free WPS Office suite on your device.
- 2. Open your files: Open your existing .pptx presentation and .xlsx workbook directly in WPS Office.
- 3. Update your charts seamlessly: Manage your chart data and presentation visuals natively without worrying about unexpected resizing bugs.
Frequently Asked Questions
Why do my PowerPoint charts resize when I send the file to another user?
If the recipient has a different monitor resolution or display scaling setting than you do, refreshing the data links on their device triggers the same scaling conflict, causing the chart to resize based on their screen's DPI.
Can I lock the aspect ratio of my linked Excel charts in PowerPoint?
Yes, you can right-click the chart in PowerPoint, select 'Size and Position', and check the 'Lock aspect ratio' box. While this maintains proportions, severe scaling conflicts from multi-monitor setups may still alter the overall dimensions.
Does pasting the chart as a picture prevent it from resizing?
Yes. If you do not need the data to update automatically in the future, pasting the Excel chart as a picture (using Paste Special > Picture) severs the live data link and completely prevents any unexpected resizing caused by display scaling.
