TEACHING EXCEL FOR DATA ANALYSIS: HANDS ON Create a trendline

 

Create a trendline

You would like to add a moving average trendline to a chart that illustrates sales data over the period of several weeks.

1. Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.

https://github.com/alcadelina/Excel-

2. Click to select the large chart that appears on Sheet1 of the current workbook:

3. Click Chart Design → Add Chart Element → Trendline → More Trendline Options:

4. The Format Trendline task pane now appears on the right side of the Excel window. Click the Moving Average radio button:

5. Ensure that the Period setting is set to “2” and that the Trendline Name radio button is set to Automatic:

6. Close the Format Trendline task pane by clicking the Close button (x) in its upper right-hand corner:

7. Examine the graph and you will see that the trendline that has been added better illustrates the fluctuation in this data over time:

8. Save the current workbook as Activity 4-3 Complete and then close Microsoft 365 Excel to complete this exercise.

9. Now, you can check out an example of a completed document in the link below:

https://github.com/alcadelina/Excel-