I'm sure there is a way to do this. My user wants a scatter plot chart with an R2 trendline.
Seems to me I should be able to calculate the trendline values from the data below.
Here's some sample data.
id x y trendline values
1584882.00267197.00 ?
2751996.00343395.00
3707497.00326956.00
4734634.00318450.00
5697209.00313278.00
6610973.00251555.00
7734407.00310698.00
8706128.00308050.00
9771648.00301532.00
10727772.00306192.00
11775549.00319146.00
12758982.00315869.00
13716784.00296406.00
14685281.00316689.00
15709988.00323988.00
16745016.00336162.00
17688209.00318343.00
Type A b R2
Linear regression80376.4166970.32274800000.5345480000
Bestfit = 3-2699930.392223413.3793490.5566220000
Thank you so much - to whoever has this answer!