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?

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

1 Answer 1

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.

5
  • Maybe some scripting? Feb 12, 2013 at 9:14
  • I will take a deeper look into it, OK? Feb 12, 2013 at 9:16
  • Did you look into it? 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.... 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. 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.