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.

How to Calculate Y-Intercept in Excel. The y-intercept is the point at which a linear equation crosses the y-axis on the x=0 plot point. The equation to determine both the slope and the y ...