Consider that you have X1 Y1 X2 Y2 as the pairs of values being used. This tutorial shows how to find a line given a point and a slope by using the point slope formula. Enter the point and slope that you want to find the equation for into the editor.
M is the slope of the line b is the y-intercept of the line.
X1 x2 are the coordinates of x-axis and y1 y2 are the coordinates of y-axis. Suppose we have the Xs values located in the excel sheet range from A1 to A10 and Ys values located in the given excel sheet from range B1 to B10 then we can calculate the SLOPE here by using the below VBA functions. X1 x2 are the coordinates of x-axis and y1 y2 are the coordinates of y-axis. The line is then solved in slope intercept form and sketc.