R-squared Value on Chart vs Formula Results Different, why?

[mcmuney]

I have these 2 columns of data sets:

column B

23
34.6
31.9
31.9
28.5
28.9
24
24.7
37.9
30.4

column C

22
35
35
29
26
28
24
22
38
30

Formula =CORREL(C16:C28,B16:B28) Result = 0.9540

R-squared value on chart R² = 0.9965

0.9540 vs 0.9965, why is there a difference and how can I sync them?

Thanks in advance.

 

[AhoyNC]

I get R squared should be 0.9101.

If you the correlation coefficient R = 0.9540 then R^2 = 0.9101.
When I chart your data it also gives 0.9101
The Excel function for R^2 is RSQ

Book2
	A	B	C	D	E	F
1		23	22
2		34.6	35		0.954016	=R
3		31.9	35		0.910146	=R^2
4		31.9	29		0.910146	=R^2
5		28.5	26
6		28.9	28
7		24	24
8		24.7	22
9		37.9	38
10		30.4	30
Sheet1

Cell Formulas
Range	Formula
E2	E2	=CORREL(B1:B10,C1:C10)
E3	E3	=E2^2
E4	E4	=RSQ(C1:C10,B1:B10)

 

[myall_blues]

I think you have checked the 'Set intercept' option on your trendline.