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

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

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:

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.

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.