Microsoft KB Archive/211728

From BetaArchive Wiki
Knowledge Base


Article ID: 211728

Article Last Modified on 9/27/2003



APPLIES TO

  • Microsoft Excel 2000 Standard Edition



This article was previously published under Q211728


SYMPTOMS

After you apply a user-defined chart type to a chart, Microsoft Excel may fail to apply the specified colors to trendline equation labels in the chart.

CAUSE

This problem may occur if all of the following conditions are true:

  • You create a custom chart type for a chart based on data in a range of cells.


-and-

  • You specify a different color for each trendline label.


-and-

  • You apply the custom chart type to a chart based on data in a range of cells with more rows and/or columns than the range on which the original chart is based.


WORKAROUND

To work around this problem, reapply the custom chart type to the chart. To reapply the custom chart type to the chart, follow these steps:

  1. Click the chart to activate it.
  2. On the Chart menu, click Chart Type.
  3. Click the Custom Types tab.
  4. Under Select from, click User-defined.
  5. Click the custom type that you created and click OK.


STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

REFERENCES

For more information about using custom chart types, click Microsoft Excel Help on the Help menu, type save a custom chart type to apply to other charts in the Office Assistant or the Answer Wizard, and then click Search to view the topic.


Keywords: kbbug kbchart kbpending KB211728