Dynamic Trendline by horizontal data.

Hello Excel Pro...good day...found a dynamic trend line with a data set vertical as below:
a 50
b 29
c 67
d 46
e 69
f 48
g 46
h 64
i
j


***The offset formula is =OFFSET(Sheet1!$A$2,0,1,COUNT(Sheet1!$B:$B),1)

Now my question is what if the data is arrange horizontally as in below:
50 29 67 46 69 48 46 64
a b c d e f g h i j

***Any idea what would be the offset formula? Please help as I can't find the solution online....thanks

May be this

Please Login or Register  to view this content.