Excel Activity Tracking

I am trying to track how many active projects we have on the go. Find
activities for the current month is easy but I would like to track and graph
historical projects.

Each project has a Start Date and an End Date. Whenever a project starts in
a certain month it should be added to the number of projects, and when it
ends it should come off in the month where it ends.

Any chance I could graph that with the months as the Y axis, the number of
projects as the X axis and the Year as the Data axis?

I need this to be dynamic so I cant be adding new columns for every month
and year.

Thanks!

It sounds like you need a Gantt chart template. If you do a search on "Gantt
charts", there's a number of free templates available might work for you.

--
John Mansfield
http://www.cellmatrix.net


"Slim" wrote:

I am trying to track how many active projects we have on the go. Find
activities for the current month is easy but I would like to track and graph
historical projects.

Each project has a Start Date and an End Date. Whenever a project starts in
a certain month it should be added to the number of projects, and when it
ends it should come off in the month where it ends.

Any chance I could graph that with the months as the Y axis, the number of
projects as the X axis and the Year as the Data axis?

I need this to be dynamic so I cant be adding new columns for every month
and year.

Thanks!