17

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 | 3 | | 02/01/2016 | 4 | | 03/01/2016 | 5 | | 03/15/2016 | 6 | | 09/01/2016 | 3 | | 12/01/2016 | 3 | *where the date values are stored ...


3

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 - modified to select previous column and to include current row =SUM(INDIRECT(ADDRESS(1,COLUMN()-1)&":"&ADDRESS(ROW(),COLUMN()-1))) Row function - Row ...


2

Use COUNTIF, e.g. to get a percentage for how many of the total matches have been won by player X: =(COUNTIF(A2:A10,"=X")/COUNTA(A2:A10)*100. For the grouping, I think you need to use QUERY (GROUP BY).


2

go to Insert -> Chart -> Select Data Range (grid icon) -> Add Another Range This allows you to enter 2 ranges - X and Y


1

A simple: =A2 + B2 retrives in column C the timestamp that is recognized by your "Timeline chart"


1

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 least from the chart editor provided (I do not know if this can be achieved using scripts). However, it has no such limitation when working with number ...


1

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', month(A)+1 'Month', count(A) 'Count'") NOTE: month(A)+1 is used because 0 is January, 1 February and so on, but people use 1 for January, 2 for February and so on. ...


1

If the sort of chart you would like is as shown, then a change in layout might be advisable:


1

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 copied down to suit. The pie charts can be plotted by selecting such as shown in the image for February. Percentages won by player can be derived from the Grand ...


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