google sheetsgoogle-sheets-chartstime series
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 to plot this data on a graph, with separate lines for each category and counter. I can't figure out how to do this.
Any clues?
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 as dates. If not, you can use =DateValue() to convert a date string to a date value.
You'd should see a lot of data in the beginning followed by a lull of activity in the middle of the year.
Area, Line, Scatter, and Time Line (located in Other) should all do so:
By contrast, bar charts continue to treat date values as a simple string and return each of the values sequentially:
And here's a public spreadsheet with all of the included examples
The new behavior is likely due to an internal change since the last update introducing the new Google Sheets. My suggestion would be to add an intermediary sheet to connect to the commute chart. The new sheet would contain linked values from the Times sheet. You could then perform arithmetic and formatting operations on it while keeping the Times sheet untouched. At the end, you could also hide the supporting sheet.
An example: https://docs.google.com/spreadsheet/ccc?key=0AvNKw_kDnGPQdHVncl9BNkY0cGIteHpjNVZla0RVMVE&usp=sharing#gid=4
The downside is that the time representation you used to achieve on the chart may no longer be possible. In fact, once formatted the duration values become single points in time instead of differences between times.
Best Answer
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 somebody else finds the solution.