Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Best fit lines
how do i create a best fit line graph for results in a table?
thanks in advance david |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save as Web Page with grid lines | Excel Discussion (Misc queries) | |||
How do I delete filtered lines in Excel 2000? | Excel Worksheet Functions | |||
Add more lines and more columns in Excel | Excel Worksheet Functions | |||
How to force continuous lines in line charts | Charts and Charting in Excel | |||
Bold Grid Lines | Excel Discussion (Misc queries) |