Skip to main content
25 votes
Accepted

How to plot time series graph in Google Sheets?

Google should now respect X-axis date values for Line, Area, Scatter, and Time Line charts. For example, if you have the following data*: | Date | Value | |------------|-------| | 01/01/2016 | ...
KyleMit's user avatar
  • 927
3 votes
Accepted

How to use Google Spreadsheets to chart completed tasks using time series graph?

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 Sheets Used Google searches to find: How to sum up rows above - ...
Sun's user avatar
  • 880
2 votes

How to plot time series graph in Google Sheets?

go to Insert -> Chart -> Select Data Range (grid icon) -> Add Another Range This allows you to enter 2 ranges - X and Y
mcmillab's user avatar
  • 121
1 vote
Accepted

Working with dates and times with Google Spreadsheet

A simple: =A2 + B2 retrives in column C the timestamp that is recognized by your "Timeline chart"
Daniele's user avatar
  • 2,428
1 vote

TimeStamp syntax to appear 24 Hrs Timestamp

Replace hh by HH Remove a Example function myFunction() { var TIMESTAMP_FORMAT = "yyyy-MM-dd HH:mm:ss"; var date = Utilities.formatDate(new Date(2020,5,5,18,23,3), Session.getScriptTimeZone(), ...
Rubén - Volunteer Moderator -'s user avatar
1 vote

How can I stop Google Sheets charts from rounding down durations?

This is only a partial answer as there is a glaring issue. The chart seems to have some limitations when dealing with date and time format and couldn't plot milliseconds as you've pointed out, at ...
WaterGenie's user avatar
1 vote
Accepted

Chart with events by month from a series of dates

First you should prepare your data to be plotted. One of many ways is to use QUERY. Example: =query(A1:A9,"select year(A),month(A)+1, count(A) group by year(A),month(A)+1 label year(A) 'Year', ...
Rubén - Volunteer Moderator -'s user avatar
1 vote

Stacked Bar Chart summing repeated daily likes

If the sort of chart you would like is as shown, then a change in layout might be advisable:
pnuts's user avatar
  • 17.7k
1 vote

Is there a way to count how many entries in a given column have a particular value?

As often, I suggest a pivot table. For the months and pie charts however I would recommend in addition a column to indicate the month, say just the number with something like: =month(D2) in E2 ...
pnuts's user avatar
  • 17.7k

Only top scored, non community-wiki answers of a minimum length are eligible