Charting multiple dates from the same record

[sylvar]

OK, here is the situation. I have a table with project tracking info in it. each record contains info like the name of the Project, the start date, and the end date. I need to chart the monthly status for all projects in a date range. for each month I need to plot the following data:
Number of projects started
Number of projects ended
Number of projects in progress

I am at a loss here. I can plot any one of these, but I don't know how to plot more than one on the chart. If I group by a date (say start date) it throws all the other dates out of whack. I can't see how to write a formula that will allow me to plot this out.

Any thoughts out there?

Shane

 

[Madawc]

If you give each prodject a status, started or ended or in progress, you should be able to chart status against date.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[sylvar]

But which date do you use as your axis? Is it possible to create a date axis in a formula?

They have a status, but if its a short project I need to count it twice for the month. Once for Projects Started, once for Projects ended.

Shane

 

[Madawc]

Just experiment, Crystal is good for that.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10