Case #10

Calculating moving average & adding recession bands

Objectives

Using the Smoothing analysis

Displaying recession series as fill range

Solution

If you get stuck trying to replicate the example, use the video or worksheet to see what to do next.

Video

Worksheet

To the see exact construction of the document, you can download the file here.

Learning resources for this case

Different views – entry-points and how to work with them

Rate of change analysis

Smoothing analysis

Adding an alternate scale to charts

Graph layout