Office for Mac Issues

Fix Disabled Treemap Chart Data Editing in PowerPoint for Mac

Natalie TaylorNatalie Taylor Nov 22, 2026 868 views

Question details

The user needs to edit the underlying data of a treemap chart in PowerPoint for Mac.

Fix Disabled Treemap Chart Data Editing 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.
Before you start

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.

Solution 1Recommended

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.

1
Check for updates

In PowerPoint, select Help > Check for Updates to open Microsoft AutoUpdate, then install any available Office updates.

2
Retest the chart

Reopen the presentation, select the treemap chart, and check the chart-related ribbon tabs for Edit Data, Switch Row/Column, and Select Data.

3
Consider a supported release

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.

Update PowerPoint for Mac and check the treemap controls
Missing linked file: If the chart refers to an external workbook, an update cannot restore a file that has been moved or deleted. Locate the original workbook if possible.
Free Microsoft Office alternative

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.

Work with presentation slides and spreadsheet data in one office suite.Open and edit Microsoft PowerPoint PPTX and Excel XLSX files.Use a familiar ribbon-style interface when moving from Microsoft Office.Review chart appearance after opening a presentation in WPS.
microsoft office alternative - wps office

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.