How to Add a Trend Line on an Excel Spreadsheet

Excel 2003
1. Create a chart from the data with which you want to make a trend line. Press the 'F11' key to create a chart using your default chart type, or click the 'Chart Wizard' button on the 'Standard' toolbar and follow the steps to create a basic chart.
2. Select the data series in the chart from which you want to create a trend line.
3. Go to the 'Chart' menu and select 'Add Trendline' The 'Add Trendline' dialog box will open.
4. Go to the 'Type' tab. Select the type of trend line you want to use and click 'OK.'
Excel 2007 or 2010
5. Open the Excel spreadsheet with the data from which you want to create a trend line. Select the data and make a basic chart. Press the 'F11' key to create a chart using your default chart type, or go to the 'Insert' tab and select a bar or column chart type in the 'Chart' group.
6. Click on the chart area to activate Excel's 'Chart Tools.'
7. Go to the 'Layout' tab under 'Chart Tools.'
8. Click the 'Trendline' button in the 'Analysis' group. Select the type of trend line you want to add.