Author: Oscar Cronquist Article last updated on October 18, 2018

A moving average smooths out short-term variations to show a long-term trend or cycle. The chart above shows random values combined with a sinus curve, the moving average is calculated, in this case, based on the last three values.

How to build

  1. Select the chart.
  2. Click on the "plus" sign next to the chart.
  3. Click "Trendline"
  4. The settings pane appears.
  5. Click on radio button "Moving Average".
  6. Change the period value, the chart will update instantly with the new value.
  7. Go to tab "Fill & Line" to customize the moving average to your preference.

How to add a second moving average

  1. Simply right-click on the data series.
  2. Click on "Add Trendline...".
  3. A second moving average appears.
  4. Select it and then go to tab "Fill & Line" to customize it.