2

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?

Improve this question
3
  • I gave a shot at it as well but without success. You have simply said, to many variables. Commented Nov 27, 2012 at 22:37
  • Have you found a solution to your problem in the meantime? Commented Feb 10, 2013 at 12:42
  • Unfortunately, no. Commented Feb 10, 2013 at 18:23

1 Answer 1

Reset to default
3
+25

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:
enter image description here
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.

Improve this answer
5
  • Maybe some scripting? Commented Feb 12, 2013 at 9:14
  • I will take a deeper look into it, OK? Commented Feb 12, 2013 at 9:16
  • Did you look into it? Commented Feb 17, 2013 at 9:14
  • I've prepared a script, but wasn't able to make it happen, right-a-way. I will continue @AlexanderGladysh with it along the way.... Commented Feb 17, 2013 at 9:16
  • @AlexanderGladysh I've added a pivot table and graph to te example file. In the pivot table you will be able to select te different dates. The CHART_3 will show the respective summations. I will stop to try and make it work in a GAS, because it simply isn't possible. Good luck with the solutions. Commented Mar 9, 2013 at 20:47

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.