Best fit lines
 

how do i create a best fit line graph for results in a table?

thanks in advance
david

See Help for info on the TREND and FORECAST functions if the fit is linear,
or GROWTH if exponential.
If more complex fit, please tell us more
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"David White" wrote in message
...
how do i create a best fit line graph for results in a table?

thanks in advance
david

David -

Here are three alternatives:

(1) Use the ChartWizard to create an XY (Scatter) chart, and use Add
Trendline.

(2) Use the Regression tool of the Analysis ToolPak add-in, which will
create a chart with a fitted line.

(3) Use worksheet functions (TREND, GROWTH, etc.) to get fitted values, and
then use the ChartWizard to create the chart.

- Mike

www.mikemiddleton.com

"David White" wrote in message
...
how do i create a best fit line graph for results in a table?
thanks in advance
david