Charts and Graphs

[motor_mouth]

Is there a way to put my tasks and manpower together in some kind of line
chart that spans my dates?

 

[John]

Is there a way to put my tasks and manpower together in some kind of line
chart that spans my dates?

motor-mouth,
Your post is a little sketchy on exactly what you want but did you try
doing a split screen with a Resource Graph as one of the panes? You
might want to go to our MVP website at:
http://www.mvps.org/project/faqs.htm
and look at FAQ 38 - Combined Resource Graph.

Hope this helps.
John
Project MVP

 

[motor_mouth]

It was a little vague, sorry. I have several tasks entered in with the
required manpower listed to complete each task. I wanted to create a line
graph or chart that showed the increase in needed manpower for each task. I
wanted this to span the same timeline my Gnatt graph did so I could see the
projected need for manpower. Hope that makes more sense. Thanks John.

 

[John]

It was a little vague, sorry. I have several tasks entered in with the
required manpower listed to complete each task. I wanted to create a line
graph or chart that showed the increase in needed manpower for each task. I
wanted this to span the same timeline my Gnatt graph did so I could see the
projected need for manpower. Hope that makes more sense. Thanks John.

motor_mouth,
Oh sure, now the whole story comes out ;-)

The Resource Graph view in Project is by resource rather than by task
assignment so you are probably not going to get the information
directly. There are a couple of options. The option I would chose (and
have used on some of my projects) may be a little advanced because it
involves using a VBA macro to export the necessary data to Excel and
then plotting it in a manpower curve. However, an equivalent process can
be used without a custom VBA macro. Starting from the Task Usage view,
use the "analyze timescale data in Excel" untility/add-in found on the
"Analysis" toolbar (I would export the Work field). Once the data is in
Excel, use Excel's charting capability to develop the graph you want.

Just for reference you might want to consider using a rolling average
instead of exact monthly values when it comes to reviewing manpower
needs, (I used a 3 month rolling average), otherwise you will end up
with hiring/layoff spikes that don't reflect reality.

Hope this helps.
John
Project MVP