How to add a trend line with Excel 2007

One of the features in Microsoft's Excel spreadsheet program, including the 2007 version, is the ability to create charts. Based on the data you are using, there is a variety of customizable graphics to suit almost any need. One of the ways that chats can be customized in Excel 2007 is to add a trend line so that those who see a chart can distinguish a trend between two data points. You can add a trend line in Excel 2007, by following some steps.

• Excel 2007

one

Select the chart to which you want to add the trend line . Click once on the data series that you want to appear on the trend line.

two

Click on the "Add trend line" option in the "Table" menu. This action will open a separate window.

3

Click on the "Type" tab. Select the type of trend line you want to add from the list of available options. Click on the "OK" button to add the trend line to the chart.