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 |
... | ... | ... |