Skip to main content

Questions tagged [time-series]

Time series are data observed over time (either in continuous time or at discrete time periods).

Filter by
Sorted by
Tagged with
0 votes
0 answers

How can I format my x-axis to include time in order from 6pm to 2am?

I want to create a scatterplot for Number of Days Late To School Each Month vs. Typical Bedtime from survey data provided by my stats students. However, my x axis "starts" at 12:00am and &...
Jennifer Preissel's user avatar
1 vote
1 answer

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 ...
CarP24's user avatar
  • 111
1 vote
0 answers

Setting the scale of the horizontal axis in time units, for plotting multiple time series, in Google Sheets?

I have some timestamped data from various sensors. All the sensors measure the same system, but the sample times are not correlated. The data may even have gaps To plot the above I placed that data ...
Bryce's user avatar
  • 726
1 vote
1 answer

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/...
peoro's user avatar
  • 113
1 vote
1 answer

TimeStamp syntax to appear 24 Hrs Timestamp

I am using var TIMESTAMP_FORMAT = "yyyy-MM-dd hh:mm:ss a"; var TZ = "GMT-7"; in my script code of Google document I want it to be convert into 24 hrs timestamp What changes should I do ?
Paresh Paresh's user avatar
5 votes
1 answer

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: ...
Leon Overweel's user avatar
0 votes
1 answer

Chart with events by month from a series of dates

I have a spreadsheet on google drive with a series of dates in a column, each date representing a particular event. 1998-01-07 1998-01-10 1998-01-22 1998-01-23 If I have two or more events on the ...
neptune's user avatar
  • 103
0 votes
1 answer

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 ...
user avatar
4 votes
1 answer

How to increase precision of labels in Google Spreadsheets chart?

I created a chart in my Google Spreadsheets. For the sake of example let's say that horizontal labels are months of the year, for example 01.2016, 02.2016, 03.2016 etc. and vertical labels are amount ...
Learner's user avatar
  • 143
2 votes
1 answer

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 ...
Kim Stacks's user avatar
3 votes
1 answer

Google Sheets Problem with Chart Axis

I have a Google Sheet with a some data that I need to chart. The horizontal axis should be a list of dates. When I plot the chart, though, it's inserting dates that aren't part of the data set. For ...
Pete's user avatar
  • 133
2 votes
2 answers

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 ...
victoriah's user avatar
  • 1,237
2 votes
1 answer

How to plot time series graph with categories?

I've data in Google Spreadsheets, with columns as follows: DD.MM.YYYY CATEGORY COUNTER_1 COUNTER_2 For example: 22.12.2010 APPLES 1 20 23.12.2010 APPLES 100 20 23.12.2010 ORANGES 32 12 I need ...
Alexander Gladysh's user avatar
41 votes
4 answers

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 ...
Graviton's user avatar
  • 1,445