Best fit Line on scatter chart
Hi,
I am trying to draw best fit line over two points using the formula y=mx+c.
I have the following data,
consider x=68, y=23 and a=82, b=30
I interchanged the above values and form the points to plot
basically using the above (x,y,a and b) I constructed (x,y),(a,y),(x,b) as points to plot.
68,23 (x,y)
82,23 (a,y)
68,30 (x,b)
I created a scatter chart based on the value, Now I want to draw the line only between (a,y) and (x,b).
Is this achievable using any other chart or ways?
Any help highly appreciated.
Thanks,
Vino