XL2000: Trendline Equation Label Does Not Use the Specified Color (211728)


The information in this article applies to:

  • Microsoft Excel 2000
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.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbbug kbchart kbpending KB211728
©2003 Microsoft Corporation. All rights reserved.