Best fit lines

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you put a line of best fit on a graph? 1
best tutorials for graphs ( line of best fit) for excel 2
Adding lines of best fit 1
tangent line 1
best fit line 5
can excel automtically graph things with given data? 2
How can I make a scatter plot graph with a category x-axis? 0
How do I change the significant digits in grapg's linr regression 1

Back
Top