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

Article translations Article translations
Article ID: 264517 - View products that this article applies to.
This article was previously published under Q264517
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page


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:
276367 OFF2000: How to Obtain the Latest Office 2000 Service Pack


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.


Article ID: 264517 - Last Review: October 20, 2013 - Revision: 2.2
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
kbnosurvey kbarchive kbhotfixserver kbqfe kbbug kbfix kboffice2000presp2fix kboffice2000sp2fix kbqfe KB264517

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com