A | B | C | D | E | F | |
1 | m | b | ||||
2 | -1 | 6 | A2:B2: {=LINEST(B5:B7, A5:A7)} | |||
3 | ||||||
4 | x | y | ||||
5 | 2 | 3 | ybeg | 4 | E5: =A5*$A$2 + $B$2 | |
6 | 3 | 5 | | |||
7 | 4 | 1 | yend | 2 | E7: =A7*$A$2 + $B$2 |
Click on the points at either end to see the coordinate values.
Or display the trendline equation to see the parameters and solve for y at xmin and xmax
Or use LINEST:
A
B
C
D
E
F
1
m
b
2
-1
6A2:B2: {=LINEST(B5:B7, A5:A7)}
3
4
x
y
5
2
3
ybeg
4E5: =A5*$A$2 + $B$2
6
3
5
7
4
1
yend
2E7: =A7*$A$2 + $B$2
<tbody>
</tbody>
when you said "click on the points at either end to see the coordinate values" were you talking about the trend line or the data series line?
I have displayed the equation on the chart and am not sure what that data is telling me.