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. Press with mouse on the "plus" sign next to the chart.
  3. Press with left mouse button on "Trendline"
  4. The settings pane appears.
  5. Press with mouse 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 press with right mouse button on on the data series.
  2. Press with mouse on "Add Trendline...".
  3. A second moving average appears.
  4. Select it and then go to tab "Fill & Line" to customize it.