You can make a line graph in Excel in a matter of seconds using data already entered into the spreadsheet.

If you need to create a Line Chart and Scatter Plot in Excel, read through this article. We have also explained which one is right for you.

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.