I have the following columns in Google spreadsheetDate and Completed TasksSample data includesMay 17, 2016     3May 18, 2016     10May 19, 2016     9May 20, 2016     8May 21, 2016     9I want to create a time series chart and to see moving average, variance plotted on it.How do I do that?Tasks will always be integer.
How to use Google Spreadsheets to chart completed tasks using time series graph?
google spreadsheets
I assume you know how to make a chart where the X is date, Y is your moving average (if you have the value).Moving Average Google SheetsUsed Google searches to find:How to sum up rows above - modified to select previous column and to include current row=SUM(INDIRECT(ADDRESS(1,COLUMN()-1)&:&ADDRESS(ROW(),COLUMN()-1)))Row function - Row function used to display current row number minus 1 to adjust for a row header=ROW()-1Divide SumRowsAbove with RowNum (C/D) which returns your definition of MovingAverage (E).