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.

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. STEP 1 - Draw ...

One way to assess this fluctuating data is to add a linear trend line to the Excel 2013 graph. This visual element considers all the data and displays the overall direction the values are taking.