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