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 made using the function Visualization > Line > Line Chart should already be made and present on the Page.  For instructions on how to make a line chart, see How to Create a Line Chart Visualization from a Table.

Method

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

1. Select your line chart visualization on the Page.
2. 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:

1. With the chart selected on the Page, go to Chart > DATA SERIES and change the Line thickness to 1.
2. Under Chart > DATA SERIES change the Opacity setting to 0.4.
3. Under TREND LINES change Line type to Solid.
4. Under TREND LINES change Line width to 3.

See Also

How to Create a Line Chart

How to Smooth the Curves on a Line Chart Visualization

How to Create a Line Chart Visualization from a Table

How to Add a Line to a Column Chart (Second Y-axis)