this is alraeady avble in exce. once a chart is created you get additional
menu <charat
click this menu and click <add trendline
choose <type tab
and click <linear
you get the least square st. line trend


Kelly J. <Kelly wrote in message
...
Hi,

I'd like to know how to plot the best straight line for a set of data
points
in an Excel chart, minimising error using least squares regression method.

Greatly appreciate if anyone could help :) I know there's such a method,
but
can't figure out how to do it.

Thanks in advance!