'%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 Link an Excel Chart to PowerPoint for the Web
Question details
The user wants to insert and link a chart from an Excel workbook into a PowerPoint presentation using the web-based versions of the applications.
- Product
- PowerPoint for the Web, Excel for the Web
- Device & OS
- not provided
- Scenario
- Creating an online presentation that requires displaying data charts from an existing spreadsheet.
- Observed behavior
- PowerPoint for the web lacks full embedding capabilities and does not support creating a dynamically linked chart from Excel for the web.
Ensure you have access to the desktop versions of Microsoft Excel and PowerPoint if you need your presentation charts to update dynamically with your spreadsheet data.
Use Desktop Applications to Link the Chart
Since the web version lacks dynamic linking features, use the desktop versions of Excel and PowerPoint to create an active, linked chart.
Object Linking and Embedding (OLE) is fully supported in the desktop applications, allowing charts to update automatically when the source data changes.
Open your workbook in the Excel desktop application and open your presentation in the PowerPoint desktop application.
In Excel, click on the chart you want to link to select it, then press Ctrl+C or right-click and select 'Copy'.
In PowerPoint, navigate to the desired slide. Go to the Home tab, click the arrow below the 'Paste' button, and select either 'Keep Source Formatting & Link Data' or 'Use Destination Theme & Link Data'.
Save your PowerPoint file. The chart is now linked to your Excel workbook and will update when data changes are made on the desktop.
Copy the Chart as a Static Picture
If you are strictly limited to using PowerPoint for the web, you can paste the chart as a static image instead of a dynamic link.
Use WPS Office for Seamless Data Linking
Skip the limitations of web-based presentation tools. WPS Office provides a free, lightweight desktop suite where you can easily link spreadsheet data to your presentation slides without compatibility hurdles.
Frequently Asked Questions
Why can't I link an Excel chart directly in PowerPoint for the web?
PowerPoint for the web has limited Object Linking and Embedding (OLE) capabilities compared to the desktop versions to maintain fast browser performance. Currently, it does not support creating dynamic links to Excel for the web workbooks.
Will a chart linked via the desktop update when viewed in PowerPoint for the web?
No, active data links generally require the desktop application background processes to fetch and update new data. In PowerPoint for the web, the chart will display the last saved visual state but will not update live if the Excel data changes.
How can I request Microsoft to add dynamic web chart linking?
You can submit your feature request or feedback directly through the Microsoft PowerPoint feedback portal, which is accessible via the Help menu inside PowerPoint for the web.
