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?