Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/171234

From BetaArchive Wiki
Knowledge Base


XL97: Trendline Equation Label Uses Different Color

Article ID: 171234

Article Last Modified on 11/11/2000



APPLIES TO

  • Microsoft Excel 97 Standard Edition



This article was previously published under Q171234


SYMPTOMS

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

CAUSE

This problem may occur if 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 do this, follow these steps:

  1. Select the chart.
  2. On the Chart menu, click Chart Type.
  3. Click the Custom Types tab.
  4. Click User-defined in the Select From box.
  5. Click the custom type that you created and click OK.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


Additional query words: XL97

Keywords: kbchart kbprb KB171234