Microsoft KB Archive/214025

= XL2000: Trendlines Unavailable for Area Chart Type =

Article ID: 214025

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214025





SYMPTOMS
In Microsoft Excel 2000, you may be unable to add a trendline to an area chart.



CAUSE
When you use the Area chart type, the Trendlines command may be unavailable (dimmed) because trendlines can be added only if the Area chart type is not stacked.



WORKAROUND
The default Area chart type is a stacked area, even if you are charting only one series. If you select this chart type, the Trendlines command (on the Chart menu) is unavailable. To unstack an Area chart type, follow these steps:
 * 1) Select the area chart.
 * 2) Click Chart Type on the Chart menu.
 * 3) In the Chart Type dialog box, make sure that Area is selected as the Chart Type on the Standard Types tab.
 * 4) On the Standard Types tab, under Chart sub-type, click the first (upper-left) sub-type, and then click OK. The area chart becomes unstacked. To create trendlines, select the series and click Add Trendline on the Chart menu.



MORE INFORMATION
In Excel, you can add trendlines to data series on a chart for the following chart types:

Unstacked 2-D areaBarColumnLine StockXY (scatter)Bubble

You cannot add trendlines to data series in 3-D, stacked, radar, pie, or doughnut charts.

To create a trendline for a particular data series, follow these steps:
 * 1) Select the series.
 * 2) On the Insert menu, click Add Trendlines.

Additional query words: greyed out grey grayed gray XL2000

Keywords: kbchart kbprb KB214025

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.