Can't add trendline in Excel 2007

L

Lionel

I have created a simple two line chart and I'm trying to add a trendline to
both, however, under layout tab, the trendline box is greyed out (under
analysis) preventing me from selecting the type of trendline that I want to
add (linear). I checked the Microsoft site related to adding trendlines in
Excel 2007 to no avail as the steps provided is what I'm trying to do and
still the trendline box is greyed out. Any assistance that can be provided
would be much appreciated.

Thanks,

Lionel
 
A

Andy Pope

Hi,

Double check the chart type. A stacked line chart will not allow trendlines.

Cheers
Andy
 
Top