best fit straight line

[Guest]

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/ExcelTips/Polynomial.htm
http://www.tushar-mehta.com/excel/tips/trendline_coefficients.htm

Cheers
Andy