A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.
10

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

Alexander, as stated in my comment on the 27th of November 2012, I see no possibility to add all the series into one chart, like the way you present them. I did however found a way to do it, but this approach is heavily compromised: The trick is to create fruit dependent counters. See example file I've created: Fruit Counters I hope I'm wrong and that ...


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 ...


1

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


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