Microsoft KB Archive/49196

Losing Chart Colors When Pasting into Word

PSS ID Number: Q49196 Article last modified on 11-02-1994

1.00 1.10 1.10a 2.00 2.00a 2.00a-CD 2.00b 2.00c

WINDOWS

Summary:

To retain the color of an Excel chart when pasting the chart into Word for Windows, copy the chart from Excel as a metafile to the Clipboard, as follows:


 * 1) Select the chart in Excel.
 * 2) In Excel, hold down the SHIFT key and choose Edit; release the SHIFT key and choose Copy Picture.
 * 3) Select As Shown on Screen from the Copy Picture dialog box. This causes the picture to be copied to the Clipboard as a metafile.
 * 4) Open the Word for Windows document, and place the insertion point where you want the chart placed, and choose Edit Paste. The chart will be placed in Word, maintaining its color.

You can then crop and size the chart using the Format Picture command in Word for Windows.

If a chart is losing it’s colors when paste linked from Excel into Word, in Excel while viewing the chart, from the Format menu select Patterns and select the Custom button from the Border and Area dialogs. Choose OK.

More Information:

When the chart is copied from Excel with the Edit Copy command while NOT holding down the SHIFT key, the chart image will be based on which printer is active. If the active printer in Excel does not support color when the Edit Copy command is used, the image is sent to the Clipboard without color.

An image copied into Word for Windows with the Edit Copy command from Excel can also be cropped and sized with the Format Picture command in Word for Windows.

KBCategory: kbinterop KBSubCategory: Additional reference words: w4wexcel 1.00 1.10 1.10a 2.00 2.00a 2.00a-CD 2.00b 2.00c grphflt ============================================================================= Copyright Microsoft Corporation 1994.