I have a spreadsheet of tasks, each of which has a field for 'Start Date' and a field for 'End Date'. I would like to generate a graphical representation of how many of these tasks would be going on simultaneously. So, for example, a line graph would have the number of tasks in progress on the y-axis and the date/time on the x-axis.

What is the best way to accomplish this? I know this forum is primarily for Excel 2007, but I'm still using 2003.

Any help would be greatly appreciated.

Thanks!