View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default 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