Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Trendlines Unavailable for Area Chart Type

XL2000: Trendlines Unavailable for Area Chart Type

View products that this article applies to.

This article was previously published under Q214025

↑ Back to the top

Symptoms

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

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: KB214025, kbprb, kbchart

↑ Back to the top

Article Info
Article ID : 214025
Revision : 4
Created on : 9/27/2003
Published on : 9/27/2003
Exists online : False
Views : 273