View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Can't add trendline in Excel 2007

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Lionel" wrote in message
...
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