Questions tagged [time-series]
Time series are data observed over time (either in continuous time or at discrete time periods).
13 questions
1 vote
1 answer
50 views
How to plot compounded time series on google sheets
I cannot find any info on how to do this online Let's say I have a spreadsheet of daily percentage changes as shown below, which D3:D11 How would I track how the compounded capital grows and falls on ...
1 vote
1 answer
745 views
Working with dates and times with Google Spreadsheet
I have a series of values and the date and time they were recorded: Date | Time | Value -------------------------- ... | ... | ... 27/10/2021 | 11:42 | 18 27/10/2021 | 21:08 | 24 28/...
5 votes
1 answer
3k views
How can I stop Google Sheets charts from rounding down durations?
I've got a Google Sheets chart that displays the average pace of a day's rowing machine workouts (e.g. average the time to row 500m). It looks like this: The Query I'm using to get the data is this: =...
0 votes
1 answer
286 views
Stacked Bar Chart summing repeated daily likes
I have table with two columns, Date and Likes. For each row in Date, I have a value in Likes, this pair represents the the likes we received every day. I want to create stacked bar chart, grouped by ...
2 votes
1 answer
487 views
How to use Google Spreadsheets to chart completed tasks using time series graph?
I have the following columns in Google spreadsheet Date and Completed Tasks Sample data includes May 17, 2016 3 May 18, 2016 10 May 19, 2016 9 May 20, 2016 8 May 21, 2016 9 I ...
2 votes
2 answers
3k views
Is there a way to count how many entries in a given column have a particular value?
I have a spreadsheet which keeps track of duels between two players in a game. Each row has the number of the match and the winner, given by their initial, X or Y. I want to know if it's possible to ...
41 votes
4 answers
173k views
How to plot time series graph in Google Sheets?
I know it is possible to plot graph or chart in Google Sheets but the problem with current plotting way is that you can only specify the Y, but not the X, and as such there is no way to plot a time ...