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.

This difference is called its residual. A residual plot charts these values against the first variable to visually display the effectiveness of the equation.

Learn how to graph linear regression in Excel. Use these steps to analyze the linear relationship between an independent and a dependent variable.