1

I have a graph on Google Sheets (based on two columns) that plots many points (think of it like the stock market):

enter image description here

I would like the graph to not show the micro data and instead show trends.. something like this:

enter image description here

ideas?

1
  • Please checkout Add & edit a trendline. If you need further details create a demo spreasheet including the data to create the chart.
    – Rubén
    Aug 26, 2018 at 21:26

1 Answer 1

3

Use the SMA (Simple moving average). It works as follow

  • Take W points back (e.g. 3, 5 or 10, that's your window size) and do an average for them. This will create a new point
  • Use those newly created points to plot your line.

NOTE: at the end you'll have N-W+1 points where N is original number of points and W is your window size

Here is an example google sheet for Milk production per pound per month with smoothing via a window 3 and window 10 and the trend line (straight line)

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.