C cturner08 Feb 5, 2009 #1 How can I automatically capture the coefficients of a trend line equation from an excel chart, to use in other calculations?
How can I automatically capture the coefficients of a trend line equation from an excel chart, to use in other calculations?
M Mike Middleton Feb 5, 2009 #2 cturner08 - One approach is to use worksheet functions. See John Walkenbach's page at http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas - Mike Middleton Web http://www.MikeMiddleton.com Email (e-mail address removed)
cturner08 - One approach is to use worksheet functions. See John Walkenbach's page at http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas - Mike Middleton Web http://www.MikeMiddleton.com Email (e-mail address removed)
B Bernard Liengme Feb 5, 2009 #3 See http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm best wishes
