Project values

1. Select at least two cells that contain the starting values for the trend.

   If you want to increase the accuracy of the trend series, select additional starting values.

2. Drag the fill handle in the direction you want to fill with increasing or decreasing values.

   For example, if the selected starting values in cells C1:E1 are 3, 5, and 8, drag the fill handle to the right to fill with increasing trend values, or drag it to the left to fill with decreasing values.

Tip

1. Select at least two cells that contain the starting values for the trend.

   If you want to increase the accuracy of the trend series, select additional starting values.

2. Hold down the right mouse button and drag the fill handle in the direction you want to fill with increasing or decreasing values.

   For example, if the selected starting values in cells C1:E1 are 3, 5, and 8, drag the fill handle to the right to fill with increasing trend values, or drag it to the left to fill with decreasing values.

3. Release the mouse button, and then click Growth Trend on the shortcut menu.

Tip

1. Select the cell where you want to start the series. The cell must contain the first value in the series.

   When you use the Series command, the resulting series replaces the original selected values. If you want to save the original values, copy them to a different row or column, and then create the series by selecting the copied values.

2. On the Edit menu, point to Fill, and then click Series.
3. Do one of the following:

   • To fill the series down the page, click Columns.

   • To fill the series across the page, click Rows.

4. In the Step value box, enter the value that you want to increase the series by.

   Series type	Step value result
   linear	The step value is added to the first starting value and then added to each subsequent value.
   growth	The first starting value is multiplied by the step value. The resulting product and each subsequent product is then multiplied by the step value.

5. Under Type, click Linear or Growth.
6. In the Stop value box, enter the value you want to stop the series at.

Note  If there is more than one starting value in the series and you want Microsoft Excel to generate the trend, select the Trend box.

1. Click the data series to which you want to add a trendline or moving average.
2. On the Chart menu, click Add Trendline.
3. On the Type tab, click the type of regression trendline or moving average you want.

   • If you select Polynomial, enter in the Order box the highest power for the independent variable.

   • If you select Moving Average, enter in the Period box the number of periods to be used to calculate the moving average.

Notes

• The Based on series box lists all the data series in the chart that support trendlines. To add a trendline to another series, click the name in the box, and then select the options you want.
• If you add a moving average to an xy (scatter) chart, the moving average is based on the order of the x values plotted in the chart. To get the result you want, you might need to sort the x values before adding a moving average.

1. On the Tools menu, click Data Analysis.

   If Data Analysis is not available, load the Analysis ToolPak.

   How?

   1. On the Tools menu, click Add-Ins.

   2. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.

   3. If necessary, follow the instructions in the setup program.
2. In the Data Analysis dialog box, click the name of the analysis tool you want to use, then click OK.
3. In the dialog box for the tool you selected, set the analysis options you want.

   You can use the Help button on the dialog box to get more information about the options.