Fix Disabled Treemap Chart Data Editing in PowerPoint for Mac
Question details
The user needs to edit the underlying data of a treemap chart in PowerPoint for Mac.

- Product
- Microsoft PowerPoint for Mac 2016
- Device & OS
- Mac
- Scenario
- The user wants to replace a treemap chart's sample data with their own data.
- Observed behavior
- Edit Data in Excel, Switch Row/Column, and Select Data are disabled or produce a missing linked-file error.
In PowerPoint, select the treemap chart and check whether the chart data commands are available. Check your PowerPoint version under PowerPoint > About PowerPoint before looking for updates.
Update PowerPoint for Mac and check the treemap controls
Use this approach to check whether a newer PowerPoint release supports editing your treemap chart.
Treemap chart data editing was not fully implemented in PowerPoint for Mac at the time of the reported issue. Updating may help, but availability depends on your Office version and macOS compatibility.
In PowerPoint, select Help > Check for Updates to open Microsoft AutoUpdate, then install any available Office updates.
Reopen the presentation, select the treemap chart, and check the chart-related ribbon tabs for Edit Data, Switch Row/Column, and Select Data.
If no update is available or the controls remain disabled, check Microsoft's current Office and macOS requirements before upgrading to a supported PowerPoint release.

Try editing the treemap in PowerPoint for Windows
Use another supported PowerPoint installation to check whether it can access the chart's data.
Send treemap editing feedback to Microsoft
Report the issue if the controls remain unavailable after updating.
Work with Presentations and Chart Data in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with presentations and spreadsheets. Open Microsoft Office files to make migration easier, and review complex charts for compatibility.

Frequently Asked Questions
Why is Edit Data disabled for my treemap chart?
Treemap data editing was not fully implemented in the affected PowerPoint for Mac releases. Select Help > Check for Updates, then retest the chart in an available newer version.
Does a missing linked-file message mean my chart data is gone?
Not necessarily. The chart may refer to an external workbook that was moved, renamed, or deleted. Look for the original workbook and make it available before trying to edit the chart again.
Can I edit the treemap on a Windows computer?
You can try opening the presentation in PowerPoint for Windows, selecting the chart, and choosing Chart Design > Edit Data. The underlying data or linked workbook must be accessible.
Will joining the Microsoft 365 Insider program fix this issue?
An Insider build may provide access to newer features, but it does not guarantee a fix. Check Microsoft's current eligibility and installation instructions before joining.
How do I report the disabled chart controls?
In PowerPoint, choose Help > Feedback or the feedback option available in your version. Include your PowerPoint version and the exact error message.




