"november678x" <november678x.27lzby_1147293003.6097@excelforum-nospam.com>
wrote in message
news:november678x.27lzby_1147293003.6097@excelforum-nospam.com...
>
> Thank you for the reply. I am looking at the trend line formula on the
> chart and it says:
>
> Y=-12.5x+2466.7
> R2 = 0.0242
>
> To clarify this equation, If i say that the points move down every
> 12.5, the next value on the line will be 2466.7, and the closer R2 is
> to 1.0 the more accurate the trendline, am I correct?

2466.7 is the y value for x=0, i.e. the point where the line crosses the y
axis.

For more detail see
http://office.microsoft.com/en-us/as...091551033.aspx
--
David Biddulph