Multi-Series Charts in Excel

I am increasingly fascinated with, and frustrated by, spreadsheets. Like most computer scientists, I have mostly ignored them, thinking that they were toys for non-programmers. The more I play with Excel for managing grading and other tasks, though, the more impressed I am. But now I have a problem. I have three columns of data: the first is a date, the second is a project name, and the third is a count of lines of code. I want a time-series chart that shows the size of each project over time. The samples are irregularly spaced, and different projects are sampled at different times. Damned if I can figure out how to get Excel to do it. If anyone knows...
2005-11-08 Red 71897
2005-11-12 Blue 1728
2005-11-29 Red 73443
2005-12-01 Green 96101
2005-12-02 Green 96437
2006-01-14 Red 73599
... ... ...
comments powered by Disqus