How to Show a Moving (Rolled) Average on a Line Chart Visualization

This article will tell you how to edit a line chart visualization so that it shows a moving (rolled) average.

It will take you from a visualization that looks like this:

To a visualization that looks like this:

Requirements

A line chart. For instructions on how to make a line chart, see How to Create a Line Chart Visualization.

The basic steps simply add the moving line to the chart:

Select your line chart visualization on the Page.
In the object inspector , select Chart > Trend Lines > Line of best fit > Moving average.

To bring focus to the moving average rather than the underlying data, we can make some further edits:

With the chart selected on the Page, go to the object inspector , and under Chart > Data Series, change the Line thickness to 1.
Under Chart > Data Series change the Opacity setting to 0.4.
Under Trend Lines change Line type to Solid.
Under Trend Lines change Line width to 3.