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.

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.

Watch this video to find out how the equation 𝑦 = 𝑚𝑥 + 𝑐 can be used to work out the gradient and 𝑦-intercept on a straight line graph.

Let's look at the idea of what an x and y intercept are. Basically, an x intercept is where it intercepts the x axis, and the y intercept is where it intercepts the y axis.