Fix Excel 2016 for Mac VBA Pasting Charts as Blank Pictures in Word
Question details
The user needs to copy an Excel range containing charts to Word without the pasted picture appearing blank.
- Product
- Microsoft Excel 2016 for Mac and Microsoft Word for Mac
- Device & OS
- macOS
- Scenario
- A VBA routine copies a worksheet range containing charts and pastes it into a Word document.
- Observed behavior
- The pasted image may be blank when the range contains charts, while text-only ranges paste correctly. Switching worksheets may also be unusually slow.
Open the workbook and Word document, and identify a range that reproduces the blank picture. Check whether the chart itself displays correctly in Excel before testing the paste.
Update Office and test the chart separately
Use this approach to check for a Mac compatibility issue and determine whether the chart or the combined range causes the blank paste.
In Excel, select Help > Check for Updates and install any available Office updates through Microsoft AutoUpdate.
Open System Settings or System Preferences and select Software Update. Install updates supported by your Mac and Office version.
In Excel, select the chart border and choose Edit > Copy. Switch to Word and choose Edit > Paste, or try Edit > Paste Special and select a picture format if one is available.
Copy and paste a text-only range, then retry the original range containing the chart. If only the combined range produces a blank image, test a separate chart export or paste.
Export the chart and insert it into Word
Use a separate image file when copying a range with an embedded chart produces a blank picture.
Test a supported Office version and report the issue
Use this option if updates and separate chart export do not resolve the problem.
Work with Excel Charts and Word Documents in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets and documents. Open common Office files to make migration easier, but test chart rendering and VBA compatibility before relying on an existing macro.

Frequently Asked Questions
Why does a text-only range paste correctly while a chart range is blank?
The chart may be affected by a rendering or compatibility issue when Excel creates the pasted picture. Copy the chart alone and compare it with the combined range to narrow down the problem.
How do I update Excel 2016 for Mac?
In Excel, select Help > Check for Updates, then follow the Microsoft AutoUpdate prompts to install available Office updates.
Can I insert the chart without pasting the entire Excel range?
Yes. If available, use Save as Picture on the selected chart or export it with VBA, then use Word's Insert > Pictures command to insert the resulting image.
Will changing hardware acceleration fix the blank picture?
Not necessarily. A hardware-acceleration option may not be present in Excel 2016 for Mac. If your version has a relevant display setting, you can test it, but also try updating Office and exporting the chart separately.




