I have a graph on Google Sheets (based on two columns) that plots many points (think of it like the stock market):
I would like the graph to not show the micro data and instead show trends.. something like this:
ideas?
-
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
Add a comment
|
1 Answer
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)
