Excel: Chart in Word Loses Color when UpdatedLast reviewed: September 12, 1996Article ID: Q100980 |
The information in this article applies to:
SYMPTOMSWhen you double-click a Microsoft Excel chart that is linked as a picture in a Microsoft Word document, the linked chart is opened or activated in Microsoft Excel. If you then update the chart in Microsoft Excel, when you return to Microsoft Word, the chart may have lost its color, and it will be displayed in black and white. This will not occur in a second instance of Microsoft Excel nor will it occur with linked cell objects.
CAUSEWhen Microsoft Excel updates the link, it sends information about the chart's colors based on how the chart will appear when you print it. (This process is similar to the one that occurs when you choose Copy Picture from the Edit menu and select the As Shown When Printed option for the appearance.) When you choose Copy from the Edit menu, and then, in Microsoft Word, choose Paste from the Edit menu or choose Paste Special and select the Picture option, the chart will be printed in black and white if your default printer is not a color printer. However, when the chart is pasted as a picture, it will appear in color regardless of the method you used to copy it. When you double-click it to update it, Microsoft Excel updates the colors as they would appear when printed. The exception to this is when you are using custom colors for your chart data series. In this case, Microsoft Excel sends the actual color index to the printer driver and allows the driver to map the color to an appropriate gray scale. Since the linked chart is updated based on the information that Microsoft Excel sends to the printer driver, the actual chart colors appear. When you use Microsoft Excel's automatic colors, Microsoft Excel maps these colors to gray scale before sending information to the printer driver; as a result, these colors are converted to gray scale.
WORKAROUNDSTo work around this problem, use any one of the following workarounds:
from the Format menu. Under Area, select the Custom option and choose OK. -or- -or-
STATUSMicrosoft has confirmed this to be a problem in the versions of Microsoft Excel listed above. This problem was corrected in version 5.0 of Microsoft Excel for Windows.
MORE INFORMATIONThis problem also occurs in Microsoft Write and other object linking and embedding (OLE) client applications in which you can link objects as pictures.
|
KBCategory: kbprb
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |