'%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)
Fix Cannot Edit PowerPoint Chart Data in the Web App
Question details
Users are unable to locate the option to edit chart data (such as a sunburst chart) when collaborating on a shared presentation in the PowerPoint web application.
- Product
- PowerPoint Web App
- Device & OS
- not provided
- Scenario
- Multiple users attempting to update chart values in a shared presentation online.
- Observed behavior
- The PowerPoint web app does not display any option to edit the chart data.
Ensure you have a desktop presentation software installed, as web-based presentation platforms often restrict full chart-editing capabilities.
Use the Desktop Application to Edit Chart Data
Switching from the web app to the fully-featured desktop application will restore the missing data editing functionalities.
PowerPoint for the Web is designed for quick edits and real-time collaboration, but it intentionally omits advanced data manipulation tools. To update complex elements like sunburst charts, you must transition your current session to a local desktop environment.
On the top ribbon of the PowerPoint Web interface, click on the 'Viewing' or 'Editing' dropdown button.
Select 'Open in Desktop App' from the dropdown menu. Confirm any browser prompts to launch the local software.
Once the file successfully loads in the desktop application, click directly on the specific chart you want to modify.
Navigate to the 'Chart Design' tab on the ribbon and click 'Edit Data' to open the spreadsheet and update your numbers.
Edit Presentation Charts Seamlessly with WPS Office
If you are frustrated by the feature limitations of web-based presentation tools, WPS Office provides a powerful, lightweight, and free desktop alternative. You get full control over your charts without sacrificing collaboration.
- 1. Download WPS Office: Get the free WPS Office installer from the official website and complete the setup.
- 2. Open your presentation: Launch WPS Presentation and open your shared .pptx file.
- 3. Edit with ease: Click your chart and easily edit the underlying data using the complete set of desktop chart tools.
Frequently Asked Questions
Why is the Edit Data button missing in PowerPoint for the web?
PowerPoint for the web is a simplified version of the desktop software. It currently lacks the full backend integration required to edit complex chart data like sunburst or waterfall charts directly in the browser.
Will my chart formatting change if I switch to the desktop app?
No, opening your web presentation in the desktop application preserves all original layouts, colors, and data. The transition is seamless and designed specifically for this exact workflow.
Can I still co-author if I open the file in the desktop app?
Yes. As long as the file remains saved on OneDrive or SharePoint and you have AutoSave toggled on in the desktop app, you can edit chart data while others continue to view or edit the presentation online.
