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?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI 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?
Use the SMA (Simple moving average). It works as follow
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)