How to Graph Linear Lines in Microsoft Excel. Data is rarely so uniform and predictable that plotting data points creates a perfectly linear arrangement.

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.

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.

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