Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I've got data in Google Spreadsheet, 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?

share|improve this question

migrated from superuser.com Dec 23 '10 at 12:35

This question came from our site for computer enthusiasts and power users.

    
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

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.

share|improve this answer
    
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
    
Thank you, Jacob! –  Alexander Gladysh Feb 17 '13 at 10:47

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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