best fit straight line

[Priscilla]

How do i draw a bit fit line in a chat?

[Andy Pope]

Hi,

Right click the series and add a trendline.

Here are a couple of pages that may help you get further.
http://www.stfx.ca/people/bliengme/E...Polynomial.htm
http://www.tushar-mehta.com/excel/ti...efficients.htm

Cheers
Andy

Priscilla wrote:
> How do i draw a bit fit line in a chat?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info