The y-intercept is the point at which a linear ... "OK" and Excel will calculate the y-intercept using the known X and Y points. Highlight all of the "X" and "Y" values on the spreadsheet.