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 ...

Learn how to calculate the equation of a line from a graph, work out the gradient from an equation, and visualise intercepts with this step-by step guide.

To determine the gradient and y-intercept from an equation of a straight line which is not in the correct form, we will need to rearrange the equation first.