How to Link Excel Charts or Tables to PowerPoint on Mac
Question details
Users need to link or embed specific Excel charts and tables into a PowerPoint presentation on a Mac without encountering formatting errors.
- Product
- Microsoft PowerPoint and Excel for Mac
- Device & OS
- macOS
- Scenario
- Copying and pasting data or charts from an Excel spreadsheet into a PowerPoint slide to present data.
- Observed behavior
- When an Excel table or chart is copied to PowerPoint on a Mac, it often appears as random characters. Furthermore, Microsoft 365 for Mac currently does not support linking dynamic Excel data or embedding only specific parts of a file.
Keep in mind that Microsoft Office for Mac lacks full support for Object Linking and Embedding (OLE) for partial files. Ensure your Office suite is fully updated before attempting workarounds.
Embed the Entire Excel Workbook
Since linking specific charts or partial data is not supported on Mac, the official workaround is to embed the entire Excel file into your presentation.
While you cannot link or embed just a single chart, embedding the full workbook allows you to access the source data directly from your PowerPoint slide. Be aware that this may increase your presentation's file size.
Navigate to the PowerPoint slide where you want the data. Click on the 'Insert' tab in the top ribbon and select 'Object'.
In the dialog box, choose 'From File' and browse your Mac to locate the specific Excel workbook containing your chart or table.
Click 'Insert' or 'OK'. The workbook will be embedded, and you can double-click it during editing to access the underlying Excel data.
Paste the Chart or Table as a Picture
To bypass the random character formatting errors, paste your Excel content as a static image.
Try WPS Office for a Seamless Presentation Experience
If you are frustrated by the cross-app linking limitations and clipboard errors of Microsoft Office for Mac, WPS Office offers a highly compatible, lightweight, and free alternative. Switch between Spreadsheets and Presentations effortlessly within a single, tabbed workspace.
- 1. Download and Install WPS Office: Visit the official WPS website, download the macOS installer, and follow the on-screen instructions.
- 2. Open Your Files in One Window: Launch WPS Office and open both your spreadsheet and presentation in the same tabbed workspace.
- 3. Copy and Paste Seamlessly: Copy your chart or table from WPS Spreadsheet and paste it directly into WPS Presentation without encountering random character glitches.
Frequently Asked Questions
Why do my Excel tables turn into random characters in PowerPoint on Mac?
This happens due to clipboard and compatibility glitches in Microsoft 365 for Mac when it attempts to translate complex Excel formatting into PowerPoint objects. Pasting the content as a static picture prevents this.
Can I make an Excel chart update automatically in Mac PowerPoint?
Currently, Microsoft Office for Mac does not support Object Linking and Embedding (OLE) for dynamic links to partial files. You can only embed an entire workbook, but it will not automatically push live updates without being opened.
Is there any way to embed just one sheet instead of the whole workbook?
No. The Mac version of Microsoft Office restricts embedding to the entire file. If privacy or file size is a concern, create a new Excel file containing only the specific sheet you need, and embed that new file instead.
