R² expression for trendline in chart
 

Using trendline in a chart, and forcing the trendline to cross the origin, I
get a R² value. The R² expression, in the help, is wrong in this case (origin
crossing).
What is the true exression used for R² calculation ?
Thanks

jean -

Using trendline in a chart, and forcing the trendline to cross the origin,
I get a R² value. The R² expression, in the help, is wrong in this case
(origin crossing). What is the true exression used for R² calculation ?
Thanks <

Perhaps this knowledge base article is relevant:

http://support.microsoft.com/default...b;en-us;829249

- Mike

www.mikemiddleton.com