How do I get the R² value outside side of a graph (exp regression
 

Hi,

Through a trendline in a chart, I know which R² is used to draw an
exponential regression. I can get the exp. regression data with the growth
function. But how can I get the R² value in a cell without copying it from
the graph?

thanks

How do I get the R² value outside side of a graph (exp regression
 

Have a look at LINEST
LINEST works with many equations; see
http://people.stfx.ca/bliengme/exceltips/Polynomial.htm
http://www.tushar-mehta.com/publish_...nalysis/16.htm
http://spreadsheetpage.com/index.php...line_formulas/
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Karine" wrote in message
...
Hi,

Through a trendline in a chart, I know which R² is used to draw an
exponential regression. I can get the exp. regression data with the growth
function. But how can I get the R² value in a cell without copying it from
the graph?

thanks