Fix Select Data for Embedded Charts in PowerPoint for Mac
Question details
The user needs to access chart data controls for an embedded Excel chart in PowerPoint for Mac.

- Product
- Microsoft PowerPoint for Mac
- Device & OS
- macOS; version not provided
- Scenario
- Editing the source data of an embedded Excel chart in a PowerPoint presentation.
- Observed behavior
- Selecting Select Data opens the worksheet but does not show the expected chart data controls.
Select the affected chart and note its chart type. In PowerPoint, choose PowerPoint > About PowerPoint to check your installed version.
Update macOS, PowerPoint, and Office add-ins
Use this approach first to resolve the issue with an up-to-date version of PowerPoint for Mac.
Open Apple menu > System Settings > General > Software Update. On older macOS versions, look under System Preferences > Software Update. Install available updates compatible with your Mac.
Open PowerPoint and choose Help > Check for Updates. Install available Office updates, including PowerPoint version 16.13 or later.
Restart your Mac, then update any installed Office add-ins using the instructions provided by their publishers.
Reopen the presentation, select the affected chart, and choose Chart Design > Select Data to check whether the expected controls appear.

Ask Microsoft Support about an earlier Office version
If updating does not resolve the issue, ask Microsoft Support whether a compatible earlier version is appropriate.
Work with presentation charts in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with presentations and spreadsheets. It supports common Microsoft Office formats for easier migration, though it does not repair PowerPoint's Select Data controls.

Frequently Asked Questions
How do I check my PowerPoint version on a Mac?
In PowerPoint, choose PowerPoint > About PowerPoint. The version number appears in the About window.
Where can I update PowerPoint for Mac?
In PowerPoint, choose Help > Check for Updates and install the available Office updates. The accepted guidance recommends PowerPoint version 16.13 or later.
What should I tell Microsoft Support if Select Data still does not work?
Describe how Select Data opens the worksheet without the expected controls, and include your PowerPoint version, macOS version, and the affected chart type.
Will an earlier version of Office fix the chart controls?
One user reported that an earlier version of PowerPoint and Excel worked after Microsoft Support helped install it. Results may vary, and older versions can have security or compatibility limitations.




