G Guest Mar 15, 2005 #1 how do i create a best fit line graph for results in a table? thanks in advance david
B Bernard Liengme Mar 15, 2005 #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
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
M Michael R Middleton Mar 15, 2005 #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 - 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
