View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default Trend line in Excel

That is correct
See also http://www.stfx.ca/people/bliengme/E...Polynomial.htm
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"deacs" wrote in
message ...

Hi all,

I'm messing around with the trend line function in excel. I see there
are 6 different types of trend/regression types:

- Linear
- Logarithmic
- Polynomial
- Power
- Exponential
- Moving Average


I have a list with 30 data points that I would like to plot on chart
with the different trend/regression lines. I notice that the Power and
Exponential options are greyed out, so that I can not choose them. Is
this because 2 of the 30 numbers are negative?

Thanks!


--
deacs
------------------------------------------------------------------------
deacs's Profile:
http://www.excelforum.com/member.php...fo&userid=2321
View this thread: http://www.excelforum.com/showthread...hreadid=511723