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.
Method
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 Chart > Data Series and 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.
Next
How to Create a Line Chart Visualization