JulieS
Thu Sep 11 17:13:26 CDT 2008
Hi Dan,
Great, thanks for the clarification. Depending upon what version of
Project you have (2003 and earlier or 2007) you can either export
the information to Excel and then create a custom graph in excel or
create an Excel Pivot table with graph.
If you are using Project 2003 or earlier, I suggest running the
Analyze Timescaled data in Excel option from the Analysis toolbar.
View the Resource Usage view and click the button from the Analysis
toolbar. The wizard will step you through the export. I'd suggest
exporting Work (scheduled hours) and Overallocation (number of hours
above max units and calendar). You can then create the graph to
your liking in Excel.
If you are using Project 2007, try the Visual Reports and see if the
Resource Availability Report shows what you need. It will create an
Excel Pivot chart and you can graph as needed.
I hope this helps. Let us know how you get along.
Julie
Project MVP
Visit
http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project
"Dan777" <Dan777@discussions.microsoft.com> wrote in message
news:EA61E150-0CD6-4D2D-B290-7C389CB6505C@microsoft.com...
> Hello JulieS,
>
> Your first assessment was correct. I'm looking to graphically
> demonstrate
> (should it be the case) that I do not have enough resources over a
> given time
> period (say 90 days) with a specified number of tasks (knowing the
> requirements/bodies needed).
>
> This could take the form of a bar graph, etc. Something useful
> for
> managment or HR to assess a need for hiring and addressing staff
> concerns
> over a period.
>
> "JulieS" wrote:
>
>> Hi Dan777,
>>
>> Could you describe more fully what you mean by resource gaps?
>>
>> Are you looking to demonstrate that you don't have enough
>> resources
>> to do the tasks in the time period required?
>>
>> Or, are you saying that you have work on a task which starts,
>> stops,
>> restarts, stops, restarts, etc. and you want to show that
>> stop/start
>> in the Gantt chart?
>>
>> Julie
>> Project MVP
>>
>> Visit
http://project.mvps.org/ for the FAQs and additional
>> information about Microsoft Project
>>
>> "Dan777" <Dan777@discussions.microsoft.com> wrote in message
>> news:AD7113CD-1E5E-473F-A6B8-B7E722BBCC25@microsoft.com...
>> > Is there a way to graphically represent resource gaps when
>> > identifying tasks
>> > over a time period...given the tasks and functional
>> > requirements
>> > are known
>> > and a pre-determined resource pool is available?
>>
>>
>>