It's kind of hard to explain the problem without this picture, so here you go:

10qks4w.png

The odd rows are the time spent on various tasks (in minutes) and the even rows is the quantifiable progress. I would like to chart the progress of these on one chart with 10 lines, one for each task, comparing the time spent to the progress. For the record, I'll be tracking each by week for one year, so that will be 520 different points of time in total.

Is there a way to do this in Excel? If not, is there another way to do this? I could split these into three different graphs or, if all else fails, round to quarter-hours (1, 1.25, 1.5, etc.). For that last one, I think I could do it myself, but I'd really prefer one of the other two.

I do want the length of each line between points to be relative to time, so if I spend 30 minutes one week on one task and 60 minutes on it the next week, the 60 minute line will be twice the length of the 30 minute line. Which is why I'd do it by quarter-hours, as I imagine that the average time spent by the end of the year to be about 60 hours each, and I know I'm limited to 255 in a data series in Excel 2003.

I would appreciate any help you could provide.