0

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?

Improve this question
3
  • 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, 2011 at 13:40
  • You should put up your solution as an answer to your own question; other people might find it useful too. :)
    – Ellesa
    Oct 31, 2011 at 13:43
  • I would but the system said don't have enough points to answer my own question... go figure...
    – Eddy
    Nov 8, 2011 at 9:46

1 Answer 1

Reset to default
0

  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

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .