XL: Linked Charts Lose Custom Colors When You Update Source Data (264517)


The information in this article applies to:

  • Microsoft Excel 2000
  • Microsoft Excel 97 for Windows
This article was previously published under Q264517

SYMPTOMS

Linked charts that use custom colors revert to the default colors, when you update the chart data in Microsoft Excel.

RESOLUTION

Excel 2000

To resolve this problem, obtain the latest service pack for Microsoft Office 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

276367 OFF2000: How to Obtain the Latest Office 2000 Service Pack


CAUSE

This problem occurs when you do the following:
  1. You create an embedded chart in Excel.
  2. You change the default colors for the chart.
  3. You paste the chart into another program, such as Microsoft Word, by using the Paste Link feature.
  4. You save and close the document in the other program.
  5. You change the original chart data in Excel, and then save and close the workbook.
  6. You reopen the document in the other program, and then update the links.
The linked chart reverts back to the default colors.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Microsoft Office 2000 Service Pack 2.
Modification Type:MinorLast Reviewed:9/23/2005
Keywords:kbHotfixServer kbQFE kbbug kbfix kbOffice2000preSP2Fix kbOffice2000sp2fix kbQFE KB264517
©2004 Microsoft Corporation. All rights reserved.