A linear equation is drawn as a straight line on a set of axes. To draw the graph we need coordinates. We generate these coordinates by substituting values into the linear equation.

Learn how to calculate the equation of a line from a graph, work out the gradient from an equation, and visualise intercepts with this step-by step guide.

Capture relationships between data sets by graphing linear equations in Microsoft Excel 2007. Linear equations allow you to predict values within your data set and view the overall trend.

Click the cell in your spreadsheet in which you would like Excel to display the y-intercept of your line. Type "=INTERCEPT (" without quotes in the formula bar above 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.

Calculating a Least Squares Regression Line: Equation, Example, Explanation If you want a simple explanation of how to calculate and draw a line of best fit through your data, read on!