Best fit lines

[David White]

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

thanks in advance
david

 

[Bernard Liengme]

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

 

[Michael R Middleton]

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