Steps to Create a Linear Trendline in Microsoft Excel 1.1 2008/04/04 15:29:21.989 GMT-5 2008/04/04 16:55:54.774 GMT-5 Jerry J. Visser jerry.visser@sdstate.edu Jerry J. Visser jerry.visser@sdstate.edu Excel Trendline After creating a chart in MS Excel, insert a trendline for the data series.

Trendline

Overview Microsoft Excel is commonly used for business analysis of data sets. For this example, MS Excel 2007 will be used.

Start Point The starting point for this example will be a pre-existing chart.

Steps Right mouse click on the data series. Select Add Trendline. (Figure 1)

Choose Linear. Optionally select “Display Equation on chart” Forecast forward 1 to 2 periods for effect