How to Estimate the Y Intercept in Excel. When you graph a series of (x,y) coordinates in Microsoft Excel 2010, you can use the program's built-in functions to display the equation for the line ...

From the graph, we can also see that the y-intercept is 6, therefore we can say that the equation of the straight line is y = m x + 6. Now we need to find the gradient.