I've data in Google Spreadsheets, with columns as follows:


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?

  • I gave a shot at it as well but without success. You have simply said, to many variables. – Jacob Jan Tuinstra Nov 27 '12 at 22:37
  • Have you found a solution to your problem in the meantime? – Jacob Jan Tuinstra Feb 10 '13 at 12:42
  • Unfortunately, no. – Alexander Gladysh Feb 10 '13 at 18:23

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.

  • Maybe some scripting? – Alexander Gladysh Feb 12 '13 at 9:14
  • I will take a deeper look into it, OK? – Jacob Jan Tuinstra Feb 12 '13 at 9:16
  • Did you look into it? – Alexander Gladysh Feb 17 '13 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.... – Jacob Jan Tuinstra Feb 17 '13 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. – Jacob Jan Tuinstra Mar 9 '13 at 20:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.