Graphing a Count within date range

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!

You could create a new column with a list of dates that you want to display (every day, weekdays only, months only, ...). Call it column DateDisplay. Then in an adjacent column, count the number of times DateDisplay occurs in your list, using IFs and COUNT.

Thanks for the reply.

I'm not sure if that approach would work, because the only dates that I have are start dates and end dates. So those would be the only dates that would get counted, right? How would I go about accounting for the entire range of dates, from start to finish?