Chart & Visualization Issues

How to Fix Chart Legend Spacing When Copying Excel Chart as Picture

Steve KSteve K Nov 11, 2026 870 views

Question details

Users experience abnormal spacing in chart legend entries after copying an Excel chart as a picture and pasting it into other applications.

How to Fix Chart Legend Spacing When Copying an Excel Chart as a Picture
Product
Microsoft Excel 2016
Device & OS
not provided
Scenario
Copying an Excel chart as a picture and pasting it into a Word or Hangul document.
Observed behavior
The legend entries in the pasted chart image display unusual, distorted, or incorrect spacing.
Before you start

Ensure your original Excel chart layout looks correct on the screen and open a blank Excel worksheet to use as a temporary staging area.

Solution 1Recommended

Use an Intermediate Excel Worksheet to Paste the Picture

Pasting the copied chart picture back into Excel before transferring it to Word preserves the exact layout and corrects abnormal legend spacing.

When using the 'Copy as Picture' feature in Excel, pasting directly into a word processor like Word or Hangul can sometimes distort the meta-data or formatting of the chart elements. Using a blank Excel sheet as an intermediate clipboard destination stabilizes the image formatting before the final paste.

1
Copy the chart as a picture

Select the chart in your Excel workbook. Go to the 'Home' tab on the ribbon, click the drop-down arrow next to 'Copy', and select 'Copy as Picture'.

2
Paste into a blank worksheet

Open a new or blank Excel worksheet. Right-click any empty cell and select 'Paste' (or press Ctrl+V) to insert the picture into the spreadsheet.

3
Cut the picture from Excel

Click on the newly pasted picture in the blank worksheet to select it. Right-click the image and choose 'Cut' (or press Ctrl+X).

4
Paste into the final document

Open your target Word or Hangul document, place your cursor where you want the chart to appear, right-click, and select 'Paste' to insert the perfectly formatted chart image.

Use an Intermediate Excel Worksheet to Paste the Picture
Layout Preserved: This method ensures the chart legend spacing and overall proportions remain exactly as they appeared in the original Excel file.
Free Microsoft Office alternative

Try WPS Office for Seamless Chart Exporting

If you frequently encounter layout glitches like distorted legend spacing when copying and pasting in Microsoft Excel, consider switching to WPS Office. It provides a highly compatible, lightweight, and free alternative with stable chart rendering and cross-application exporting capabilities.

Flawlessly export and copy charts as pictures without legend spacing or layout issues.Highly compatible with Microsoft Excel formats (.xlsx, .xls) and charting tools.Free and lightweight office suite featuring a familiar and intuitive user interface.Seamlessly copy and paste data visualizations between WPS Spreadsheet and WPS Writer.
microsoft office alternative - wps office

Frequently Asked Questions

Why does the chart legend spacing change when copied to Word?

When you copy an Excel chart as a picture directly into Word, the applications attempt to render the image vectors and fonts based on the destination document's settings, which can occasionally miscalculate the spacing in delicate elements like legends.

Can I fix this by changing the paste options in Word?

Sometimes using 'Paste Special' in Word and selecting 'Enhanced Metafile' or 'Bitmap' can help. However, the intermediate Excel pasting method is often more reliable for preserving the exact original layout of the chart.

Does this legend spacing issue happen in newer versions of Excel?

While this specific legend spacing glitch is highly prominent in Excel 2016, similar layout distortions can occasionally occur in newer versions depending on your display scaling settings and default printer drivers.

How do I access the 'Copy as Picture' tool in Excel?

Click to select your chart, navigate to the 'Home' tab on the ribbon, find the Clipboard group on the far left, click the small dropdown arrow next to the 'Copy' button, and choose 'Copy as Picture'.