I've got data in Google Spreadsheet, with columns as follows:
DD.MM.YYYY CATEGORY COUNTER_1 COUNTER_2
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?