How to Graph Linear Equations in Excel 2007. ... Use historical data to forecast trends to use in sales, ... Excel provides accessible tools to create a graph and display the linear equation.

For instance, when you create a forecast, Excel creates a new worksheet that includes both a table of the historical and predicted values. You also see a chart that expresses this data.

Click "Insert" in Excel's ribbon. Click "Pie" in the Charts group, and click one of the "2D Pie Chart" options to create a blank chart. Right-click the chart.

The TREND function analyzes past data and observes a series' past performance. On the other hand, the FORECAST function predicts a series' future performance. However, both use similar algorithms, ...