up vote 0 down vote favorite
share [g+] share [fb]

I have a bunch of CSV data imported in Excel: tuples are Timestamp, Type, Type Count. I'd like to plot multiple per-type line graphs but Excel keeps choking on me; can anyone suggest how should I order the columns?

link|improve this question
Ok ok... found it: 1. make pivot out of tuple, timestamp on Row, Type on Column, Count on Value 2. change summarize-by method on value field from - the (brain dead) default - count to sum 3. plot chart as wished – Eddy Oct 31 '11 at 13:40
You should put up your solution as an answer to your own question; other people might find it useful too. :) – Kaze Oct 31 '11 at 13:43
I would but the system said don't have enough points to answer my own question... go figure... – Eddy Nov 8 '11 at 9:46
feedback

1 Answer

up vote 0 down vote accepted

  1. Make pivot out of tuple, timestamp on Row, Type on Column, Count on Value

  2. Change summarize-by method on value field from - the (brain dead) default - count to sum

  3. Plot chart as wished

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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