If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Excel Activity Tracking
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! |
Thread Tools | |
Display Modes | |
|
|