By default, Excel will use the first column for the X coordinate and the second for the Y coordinate. To add additional data for the Y axis, you need corresponding data for the X axis as well.

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.