How to Fix Chart Legend Spacing When Copying Excel Chart as Picture
Question details
Users experience abnormal spacing in chart legend entries after copying an Excel chart as a picture and pasting it into other applications.

- 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.
Ensure your original Excel chart layout looks correct on the screen and open a blank Excel worksheet to use as a temporary staging area.
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.
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'.
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.
Click on the newly pasted picture in the blank worksheet to select it. Right-click the image and choose 'Cut' (or press Ctrl+X).
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.

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.

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'.




