We’re rewarding the question askers & reputations are being recalculated! Read more.
13

There is now a "Time Line" Chart option in the Trend category that makes a nice chart like Google Finance. Customization is limited, but the Google Finance style charts are pretty cool.


8

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


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