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.

Excel can solve equations through several of its mathematical functions, but the single Excel tool that works on the largest variety of equations is the program's Solver Add-in. This tool reads an ...

To create a line chart in Excel, the procedure is as follows: Select the data across both the columns (from A3 to B12). Go to Insert > Line Chart. Select the appropriate line chart.

Excel can solve for unknown variables, ... You'll see the value that solves your equation in the cell that you chose for By changing cell. In our case, the solution is 135,294 units.

Solver is a linear programming / analysis tool for Excel that was included with Excel 2004 as an add-in, but dropped from Excel 2008 since it required Visual Basic for Applications (VBA).

Along with Visual Basic for Applications, the scripting language used in many business-oriented spreadsheets, Excel also lost Solver when it was upgraded to be included in Office 2008. Since ...