cumulative resource graph

[DavidC]

Hi,
I am looking to have a resoruce graph that shows the total resources for a
selection of resources. So as an example we have a fitter, labourer and
welder, as resources on a project among others, but I want a graph that shows
the total numbers of people from the mechanical discipline not just of each
trade, is there a way of doing it through the normal graphing process, or do
I need to write a small VB macro using "ViewShowCumulativeWork"?

Many thanks for any thoughts.

Regards

DavidC

 

[Rod Gill]

HI,

Try:

View the Resource Sheet
Window, Split
in the lower pane show the Resource Graph
In the Resource Graph select format, Bar styles
For the selected resources column select line style for both Show as
dropdown fields.
Select Format, Details and choose cumulative work

In the Resource Sheet (top pane) click on the resources you want graphed
(whilst holding hold Ctrl key down)

Is this what you need?

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[Mike Glen]

Hi David,

Welcome to the Microsoft Project newsgroup

Please see FAQ Item: 38. Combined Resource Graph

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
Project MVP

 

[DavidC]

Hi Rod,

Thanks for your response. Unfortunately I was not as succinct as I should
have been. What I am looking for is a total of a group of resources.

Where the graph will show the number or say fitters required each day, and
another for say welders, and a third for say labourers, what I am looking for
is a graph that sums the numbers of each of those trades selected from the
whole resource list, and graphs the total numbers for each day. The graph
would then show the sum total of fitters, welders and labourers on a graph.
The graph you referred to gives a running total per resource and is good for
doing the S curve.

Regards

DavidC

 

[DavidC]

Thanks Glenn,

Forgot about your articles. It was just what I was after.

Regards

DavidC

 

[DavidC]

Hi Rod,

Thanks again, Glenn's answer gave me what I was after.

Regards

DavidC

 

[Mike Glen]

You're welcome, David The FAQs are a combined effort of all the Project
MVPs, so they're not "My" articles.

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

 

[Mike Glen]

You're welcome, David The FAQs are a combined effort of all the Project
MVPs, so they're not "My" articles, though I do act as editor/webmaster on
their behalf.

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials