VBA & Macro Problems

Fix Excel 2016 for Mac VBA Pasting Charts as Blank Pictures in Word

Natalie TaylorNatalie Taylor Nov 20, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Update Office

In Excel, select Help > Check for Updates and install any available Office updates through Microsoft AutoUpdate.

2
Check macOS updates

Open System Settings or System Preferences and select Software Update. Install updates supported by your Mac and Office version.

3
Copy the chart alone

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.

4
Compare the results

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.

Display settings vary: A hardware-acceleration setting may not be available in Excel 2016 for Mac. If you find a relevant display setting in your version, test it and restart Excel; do not assume the setting exists.
Free Microsoft Office alternative

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.

View and edit spreadsheet charts alongside document contentCompatible with common Microsoft Office formats, including XLSX and DOCXFamiliar spreadsheet and document interfacesFree, lightweight office suite
microsoft office alternative - wps office

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.