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
    Commented Nov 27, 2012 at 22:37
  • Have you found a solution to your problem in the meantime?
    – Jacob Jan
    Commented Feb 10, 2013 at 12:42
  • Unfortunately, no. Commented Feb 10, 2013 at 18:23

1 Answer 1


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? Commented Feb 12, 2013 at 9:14
  • I will take a deeper look into it, OK?
    – Jacob Jan
    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....
    – Jacob Jan
    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.
    – Jacob Jan
    Commented Mar 9, 2013 at 20:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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