Excel's intercept function takes the data points that define a line on a graph and calculates the y value for the point on the graph where x is equal to zero.

Any equation that can be rearranged into the form y = m x + c, will have a straight line graph. m is the gradient, or steepness of the graph, and c is the y - intercept, or where the line crosses ...