resource and gantt views

wasn't sure if someone had figured a solution yet, but posting a question
submitted in July from someone else. I am looking for the same solution, or
rather the boss is.

Hi,

In the Resource Usage view, Is there a way of showing the Gantt Bars
for each task that each Resource is working on. I cannot get the Gantt
bars to show up in this type of view. I'll try to demonstrate:

Resource 1
Task 1 xxxxxxxxxxxxxxxxxxxx
Task 2 xxxxxxxxxxxxxxxxxx xx
Task 3 xxxxxxxxxxxxxxxx
Resource 2
Task 16 xxxxxxxxxxxx
Task 5 xxx xxxx
Task 44 xxxxxxxxxxxxxxxx


where 'xxxxx' is the project timeline for each task.

Thanks in advance.

John
Tue Oct 09 13:17:11 PDT 2007

In article <FC6916D5-3A3E-4D5A-9CDF-209A973DF3CD@microsoft.com>,
Brad <Brad@discussions.microsoft.com> wrote:

> wasn't sure if someone had figured a solution yet, but posting a question
> submitted in July from someone else. I am looking for the same solution, or
> rather the boss is.
>
> Hi,
>
> In the Resource Usage view, Is there a way of showing the Gantt Bars
> for each task that each Resource is working on. I cannot get the Gantt
> bars to show up in this type of view. I'll try to demonstrate:
>
> Resource 1
> Task 1 xxxxxxxxxxxxxxxxxxxx
> Task 2 xxxxxxxxxxxxxxxxxx xx
> Task 3 xxxxxxxxxxxxxxxx
> Resource 2
> Task 16 xxxxxxxxxxxx
> Task 5 xxx xxxx
> Task 44 xxxxxxxxxxxxxxxx
>
>
> where 'xxxxx' is the project timeline for each task.
>
> Thanks in advance.

Brad,
Gantt bars cannot be shown in either usage (Resource or Task) view,
however, you can do a split screen (Resource Usage on top and Gantt
Chart on the bottom) to show what you want.

John
Project MVP

Brad
Tue Oct 09 13:35:05 PDT 2007

John,
That is what I thought. I found the resource allocation view, but the boss
wants to see the bottom right of that screen to match up with the top left
screen. I have found something close in sorting the gantt chart by resource
name, but if more than one person is working on a project.....well it makes
things a mess.....and the boss wont like it. Let me know if you can think of
any other way to use this program to show a graphic of who is working on what
and what the time frame is.

"John" wrote:

> In article <FC6916D5-3A3E-4D5A-9CDF-209A973DF3CD@microsoft.com>,
> Brad <Brad@discussions.microsoft.com> wrote:
>
> > wasn't sure if someone had figured a solution yet, but posting a question
> > submitted in July from someone else. I am looking for the same solution, or
> > rather the boss is.
> >
> > Hi,
> >
> > In the Resource Usage view, Is there a way of showing the Gantt Bars
> > for each task that each Resource is working on. I cannot get the Gantt
> > bars to show up in this type of view. I'll try to demonstrate:
> >
> > Resource 1
> > Task 1 xxxxxxxxxxxxxxxxxxxx
> > Task 2 xxxxxxxxxxxxxxxxxx xx
> > Task 3 xxxxxxxxxxxxxxxx
> > Resource 2
> > Task 16 xxxxxxxxxxxx
> > Task 5 xxx xxxx
> > Task 44 xxxxxxxxxxxxxxxx
> >
> >
> > where 'xxxxx' is the project timeline for each task.
> >
> > Thanks in advance.
>
> Brad,
> Gantt bars cannot be shown in either usage (Resource or Task) view,
> however, you can do a split screen (Resource Usage on top and Gantt
> Chart on the bottom) to show what you want.
>
> John
> Project MVP
>

Dave
Wed Oct 10 08:48:04 PDT 2007

You could do this in Excel by exporting the timescaled data to a
spreadsheet and then colouring those cells that had data in them but it
seems rather pointless.

You already have what you want in the Resource Usage view in that the
numbers indicate when somebody is working. Your description doesn't
include anything to show the level of effort so your boss just wants
colours? Can't you educate the boss (or give the boss an etch-a-sketch).

Brad wrote:
> wasn't sure if someone had figured a solution yet, but posting a question
> submitted in July from someone else. I am looking for the same solution, or
> rather the boss is.
>
> Hi,
>
> In the Resource Usage view, Is there a way of showing the Gantt Bars
> for each task that each Resource is working on. I cannot get the Gantt
> bars to show up in this type of view. I'll try to demonstrate:
>
> Resource 1
> Task 1 xxxxxxxxxxxxxxxxxxxx
> Task 2 xxxxxxxxxxxxxxxxxx xx
> Task 3 xxxxxxxxxxxxxxxx
> Resource 2
> Task 16 xxxxxxxxxxxx
> Task 5 xxx xxxx
> Task 44 xxxxxxxxxxxxxxxx
>
>
> where 'xxxxx' is the project timeline for each task.
>
> Thanks in advance.
>

John
Wed Oct 10 08:59:28 PDT 2007

In article <7432E383-11C3-4A1F-9450-100B97B4171E@microsoft.com>,
Brad <Brad@discussions.microsoft.com> wrote:

> John,
> That is what I thought. I found the resource allocation view, but the boss
> wants to see the bottom right of that screen to match up with the top left
> screen. I have found something close in sorting the gantt chart by resource
> name, but if more than one person is working on a project.....well it makes
> things a mess.....and the boss wont like it. Let me know if you can think of
> any other way to use this program to show a graphic of who is working on what
> and what the time frame is.

Brad,
Bosses can be pretty fussy some times, can't they. Unfortunately, you
can't get there from here using Project. There may be some third party
applications that can get closer to what you want but the only one I
know of is Milestones by Kisada and I don't think it will do what your
boss wants either.

If no one else chimes in with a suggestion of a third party application
and your boss is insistent on getting the display he wants, there is
always VBA. A VBA macro could export the necessary Project data to a
more graphics friendly application. It will cost you something to have
someone develop the code, but it can be done.

John
Project MVP
>
> "John" wrote:
>
> > In article <FC6916D5-3A3E-4D5A-9CDF-209A973DF3CD@microsoft.com>,
> > Brad <Brad@discussions.microsoft.com> wrote:
> >
> > > wasn't sure if someone had figured a solution yet, but posting a question
> > > submitted in July from someone else. I am looking for the same solution,
> > > or
> > > rather the boss is.
> > >
> > > Hi,
> > >
> > > In the Resource Usage view, Is there a way of showing the Gantt Bars
> > > for each task that each Resource is working on. I cannot get the Gantt
> > > bars to show up in this type of view. I'll try to demonstrate:
> > >
> > > Resource 1
> > > Task 1 xxxxxxxxxxxxxxxxxxxx
> > > Task 2 xxxxxxxxxxxxxxxxxx xx
> > > Task 3 xxxxxxxxxxxxxxxx
> > > Resource 2
> > > Task 16 xxxxxxxxxxxx
> > > Task 5 xxx xxxx
> > > Task 44 xxxxxxxxxxxxxxxx
> > >
> > >
> > > where 'xxxxx' is the project timeline for each task.
> > >
> > > Thanks in advance.
> >
> > Brad,
> > Gantt bars cannot be shown in either usage (Resource or Task) view,
> > however, you can do a split screen (Resource Usage on top and Gantt
> > Chart on the bottom) to show what you want.
> >
> > John
> > Project MVP
> >

shedseven
Fri Jun 27 04:58:01 CDT 2008

Hello,

Did anyone get to the bottom of this? I have seen an image of this exactly
as you describe but I have been trying to replicate this in Project to no
avail. The closest I have got is a view of the resources using a custom group
and this is by resource name but even this is not perfect (because I cannot
see ALL tasks for a resource together because it is like this:

Resource 1
Task 1 xxxxxxxxxxxxxxxxxxxx
Task 2 xxxxxxxxxxxxxxxxxx xx
Task 3 xxxxxxxxxxxxxxxx
Resource 2
Task 16 xxxxxxxxxxxx
Task 5 xxx xxxx
Task 44 xxxxxxxxxxxxxxxx

Resource 1, Resource 2
Task 8 xxxxxxxxxxxxxxxxxxxx
Task 9
xxxxxxxxxxxxxxxxxxxx

Which isn't perfect, like I said I HAVE seen this but I cannot get the right
answer just yet.
"Brad" wrote:

> wasn't sure if someone had figured a solution yet, but posting a question
> submitted in July from someone else. I am looking for the same solution, or
> rather the boss is.
>
> Hi,
>
> In the Resource Usage view, Is there a way of showing the Gantt Bars
> for each task that each Resource is working on. I cannot get the Gantt
> bars to show up in this type of view. I'll try to demonstrate:
>
> Resource 1
> Task 1 xxxxxxxxxxxxxxxxxxxx
> Task 2 xxxxxxxxxxxxxxxxxx xx
> Task 3 xxxxxxxxxxxxxxxx
> Resource 2
> Task 16 xxxxxxxxxxxx
> Task 5 xxx xxxx
> Task 44 xxxxxxxxxxxxxxxx
>
>
> where 'xxxxx' is the project timeline for each task.
>
> Thanks in advance.
>

Jan
Fri Jun 27 05:35:10 CDT 2008

Hoi,

Project Menu
Group by...
More Groups
New
Give a group name
In Group By select Resource Names

OK, OK, Appl;, etc

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
"shedseven" <shedseven@discussions.microsoft.com> wrote in message
news:1A6D7BD0-5BF0-4675-B63F-D409A2691D95@microsoft.com...
> Hello,
>
> Did anyone get to the bottom of this? I have seen an image of this exactly
> as you describe but I have been trying to replicate this in Project to no
> avail. The closest I have got is a view of the resources using a custom
> group
> and this is by resource name but even this is not perfect (because I
> cannot
> see ALL tasks for a resource together because it is like this:
>
> Resource 1
> Task 1 xxxxxxxxxxxxxxxxxxxx
> Task 2 xxxxxxxxxxxxxxxxxx xx
> Task 3 xxxxxxxxxxxxxxxx
> Resource 2
> Task 16 xxxxxxxxxxxx
> Task 5 xxx xxxx
> Task 44 xxxxxxxxxxxxxxxx
>
> Resource 1, Resource 2
> Task 8 xxxxxxxxxxxxxxxxxxxx
> Task 9
> xxxxxxxxxxxxxxxxxxxx
>
> Which isn't perfect, like I said I HAVE seen this but I cannot get the
> right
> answer just yet.
> "Brad" wrote:
>
>> wasn't sure if someone had figured a solution yet, but posting a question
>> submitted in July from someone else. I am looking for the same solution,
>> or
>> rather the boss is.
>>
>> Hi,
>>
>> In the Resource Usage view, Is there a way of showing the Gantt Bars
>> for each task that each Resource is working on. I cannot get the Gantt
>> bars to show up in this type of view. I'll try to demonstrate:
>>
>> Resource 1
>> Task 1 xxxxxxxxxxxxxxxxxxxx
>> Task 2 xxxxxxxxxxxxxxxxxx xx
>> Task 3 xxxxxxxxxxxxxxxx
>> Resource 2
>> Task 16 xxxxxxxxxxxx
>> Task 5 xxx xxxx
>> Task 44 xxxxxxxxxxxxxxxx
>>
>>
>> where 'xxxxx' is the project timeline for each task.
>>
>> Thanks in advance.
>>

shedseven
Fri Jun 27 07:22:01 CDT 2008

Thanks for the quick reply Jan, that is what I did to get the below items :)

What I want is for the items that I can currently get to, which is:

Resource 1
Task 1 xxxxxxxxxxxxxxxxxxxx
Task 2 xxxxxxxxxxxxxxxxxx xx
Task 3 xxxxxxxxxxxxxxxx
Resource 2
Task 16 xxxxxxxxxxxx
Task 5 xxx xxxx
Task 44 xxxxxxxxxxxxxxxx

Resource 1, Resource 2
Task 8 xxxxxxxxxxxxxxxxxxxx
Task 9 xxxxxxxxxxxxxxxxxxxx

To be displayed as:

Resource 1
Task 1 xxxxxxxxxxxxxxxxxxxx
Task 2 xxxxxxxxxxxxxxxxxx xx
Task 3 xxxxxxxxxxxxxxxx
Task 8 xxxxxxxxxxxxxxxxxxxx
Task 9 xxxxxxxxxxxxxxxxxxxx
Resource 2
Task 16 xxxxxxxxxxxx
Task 5 xxx xxxx
Task 44 xxxxxxxxxxxxxxxx
Task 8 xxxxxxxxxxxxxxxxxxxx
Task 9 xxxxxxxxxxxxxxxxxxxx

This will allow me to hand out lists of tasks to the team members (I am 90%
of the way there, I just need the final bit.

Any ideas or is that confirmed item as good as it gets, because I have seen
the image of the tasks shown in teh form above but I can only get it to the
group level.

Thanks


> Hoi,
>
> Project Menu
> Group by...
> More Groups
> New
> Give a group name
> In Group By select Resource Names
>
> OK, OK, Appl;, etc
>
> --
> Jan De Messemaeker
> Microsoft Project Most Valuable Professional
> +32 495 300 620
> For availability check:
> http://users.online.be/prom-ade/Calendar.pdf
> "shedseven" <shedseven@discussions.microsoft.com> wrote in message
> news:1A6D7BD0-5BF0-4675-B63F-D409A2691D95@microsoft.com...
> > Hello,
> >
> > Did anyone get to the bottom of this? I have seen an image of this exactly
> > as you describe but I have been trying to replicate this in Project to no
> > avail. The closest I have got is a view of the resources using a custom
> > group
> > and this is by resource name but even this is not perfect (because I
> > cannot
> > see ALL tasks for a resource together because it is like this:
> >
> > Resource 1
> > Task 1 xxxxxxxxxxxxxxxxxxxx
> > Task 2 xxxxxxxxxxxxxxxxxx xx
> > Task 3 xxxxxxxxxxxxxxxx
> > Resource 2
> > Task 16 xxxxxxxxxxxx
> > Task 5 xxx xxxx
> > Task 44 xxxxxxxxxxxxxxxx
> >
> > Resource 1, Resource 2
> > Task 8 xxxxxxxxxxxxxxxxxxxx
> > Task 9
> > xxxxxxxxxxxxxxxxxxxx
> >
> > Which isn't perfect, like I said I HAVE seen this but I cannot get the
> > right
> > answer just yet.
> > "Brad" wrote:
> >
> >> wasn't sure if someone had figured a solution yet, but posting a question
> >> submitted in July from someone else. I am looking for the same solution,
> >> or
> >> rather the boss is.
> >>
> >> Hi,
> >>
> >> In the Resource Usage view, Is there a way of showing the Gantt Bars
> >> for each task that each Resource is working on. I cannot get the Gantt
> >> bars to show up in this type of view. I'll try to demonstrate:
> >>
> >> Resource 1
> >> Task 1 xxxxxxxxxxxxxxxxxxxx
> >> Task 2 xxxxxxxxxxxxxxxxxx xx
> >> Task 3 xxxxxxxxxxxxxxxx
> >> Resource 2
> >> Task 16 xxxxxxxxxxxx
> >> Task 5 xxx xxxx
> >> Task 44 xxxxxxxxxxxxxxxx
> >>
> >>
> >> where 'xxxxx' is the project timeline for each task.
> >>
> >> Thanks in advance.
> >>
>
>
>

JulieS
Fri Jun 27 08:54:26 CDT 2008

Hello shedseven,

No, sorry. To the best of my knowledge, Project does not have the
capacity to draw such a Resource Gantt chart. If a task has multiple
resource assigned it will show the task as you note, with Resource1,
Resource 2.

Have you considered using the left side of the Resource Usage view?
You can add Start and Finish to the Usage table and just print the
left side of the view. No pretty Gantt bars though.

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


"shedseven" <shedseven@discussions.microsoft.com> wrote in message
news:600FCA9A-5A2E-4AE2-9486-4E147AD4F8E1@microsoft.com...
> Thanks for the quick reply Jan, that is what I did to get the below
> items :)
>
> What I want is for the items that I can currently get to, which is:
>
> Resource 1
> Task 1 xxxxxxxxxxxxxxxxxxxx
> Task 2 xxxxxxxxxxxxxxxxxx xx
> Task 3 xxxxxxxxxxxxxxxx
> Resource 2
> Task 16 xxxxxxxxxxxx
> Task 5 xxx xxxx
> Task 44 xxxxxxxxxxxxxxxx
>
> Resource 1, Resource 2
> Task 8 xxxxxxxxxxxxxxxxxxxx
> Task 9 xxxxxxxxxxxxxxxxxxxx
>
> To be displayed as:
>
> Resource 1
> Task 1 xxxxxxxxxxxxxxxxxxxx
> Task 2 xxxxxxxxxxxxxxxxxx xx
> Task 3 xxxxxxxxxxxxxxxx
> Task 8 xxxxxxxxxxxxxxxxxxxx
> Task 9 xxxxxxxxxxxxxxxxxxxx
> Resource 2
> Task 16 xxxxxxxxxxxx
> Task 5 xxx xxxx
> Task 44 xxxxxxxxxxxxxxxx
> Task 8 xxxxxxxxxxxxxxxxxxxx
> Task 9 xxxxxxxxxxxxxxxxxxxx
>
> This will allow me to hand out lists of tasks to the team members (I
> am 90%
> of the way there, I just need the final bit.
>
> Any ideas or is that confirmed item as good as it gets, because I
> have seen
> the image of the tasks shown in teh form above but I can only get it
> to the
> group level.
>
> Thanks
>
>
>> Hoi,
>>
>> Project Menu
>> Group by...
>> More Groups
>> New
>> Give a group name
>> In Group By select Resource Names
>>
>> OK, OK, Appl;, etc
>>
>> --
>> Jan De Messemaeker
>> Microsoft Project Most Valuable Professional
>> +32 495 300 620
>> For availability check:
>> http://users.online.be/prom-ade/Calendar.pdf
>> "shedseven" <shedseven@discussions.microsoft.com> wrote in message
>> news:1A6D7BD0-5BF0-4675-B63F-D409A2691D95@microsoft.com...
>> > Hello,
>> >
>> > Did anyone get to the bottom of this? I have seen an image of
>> > this exactly
>> > as you describe but I have been trying to replicate this in
>> > Project to no
>> > avail. The closest I have got is a view of the resources using a
>> > custom
>> > group
>> > and this is by resource name but even this is not perfect
>> > (because I
>> > cannot
>> > see ALL tasks for a resource together because it is like this:
>> >
>> > Resource 1
>> > Task 1 xxxxxxxxxxxxxxxxxxxx
>> > Task 2 xxxxxxxxxxxxxxxxxx xx
>> > Task 3 xxxxxxxxxxxxxxxx
>> > Resource 2
>> > Task 16 xxxxxxxxxxxx
>> > Task 5 xxx xxxx
>> > Task 44 xxxxxxxxxxxxxxxx
>> >
>> > Resource 1, Resource 2
>> > Task 8 xxxxxxxxxxxxxxxxxxxx
>> > Task 9
>> > xxxxxxxxxxxxxxxxxxxx
>> >
>> > Which isn't perfect, like I said I HAVE seen this but I cannot
>> > get the
>> > right
>> > answer just yet.
>> > "Brad" wrote:
>> >
>> >> wasn't sure if someone had figured a solution yet, but posting a
>> >> question
>> >> submitted in July from someone else. I am looking for the same
>> >> solution,
>> >> or
>> >> rather the boss is.
>> >>
>> >> Hi,
>> >>
>> >> In the Resource Usage view, Is there a way of showing the Gantt
>> >> Bars
>> >> for each task that each Resource is working on. I cannot get the
>> >> Gantt
>> >> bars to show up in this type of view. I'll try to demonstrate:
>> >>
>> >> Resource 1
>> >> Task 1 xxxxxxxxxxxxxxxxxxxx
>> >> Task 2 xxxxxxxxxxxxxxxxxx xx
>> >> Task 3 xxxxxxxxxxxxxxxx
>> >> Resource 2
>> >> Task 16 xxxxxxxxxxxx
>> >> Task 5 xxx xxxx
>> >> Task 44 xxxxxxxxxxxxxxxx
>> >>
>> >>
>> >> where 'xxxxx' is the project timeline for each task.
>> >>
>> >> Thanks in advance.
>> >>
>>
>>
>>

salgud
Fri Jun 27 11:37:35 CDT 2008

On Fri, 27 Jun 2008 02:58:01 -0700, shedseven wrote:

> Hello,
>
> Did anyone get to the bottom of this? I have seen an image of this exactly
> as you describe but I have been trying to replicate this in Project to no
> avail. The closest I have got is a view of the resources using a custom group
> and this is by resource name but even this is not perfect (because I cannot
> see ALL tasks for a resource together because it is like this:
>
> Resource 1
> Task 1 xxxxxxxxxxxxxxxxxxxx
> Task 2 xxxxxxxxxxxxxxxxxx xx
> Task 3 xxxxxxxxxxxxxxxx
> Resource 2
> Task 16 xxxxxxxxxxxx
> Task 5 xxx xxxx
> Task 44 xxxxxxxxxxxxxxxx
>
> Resource 1, Resource 2
> Task 8 xxxxxxxxxxxxxxxxxxxx
> Task 9
> xxxxxxxxxxxxxxxxxxxx
>
> Which isn't perfect, like I said I HAVE seen this but I cannot get the right
> answer just yet.
> "Brad" wrote:
>
>> wasn't sure if someone had figured a solution yet, but posting a question
>> submitted in July from someone else. I am looking for the same solution, or
>> rather the boss is.
>>
>> Hi,
>>
>> In the Resource Usage view, Is there a way of showing the Gantt Bars
>> for each task that each Resource is working on. I cannot get the Gantt
>> bars to show up in this type of view. I'll try to demonstrate:
>>
>> Resource 1
>> Task 1 xxxxxxxxxxxxxxxxxxxx
>> Task 2 xxxxxxxxxxxxxxxxxx xx
>> Task 3 xxxxxxxxxxxxxxxx
>> Resource 2
>> Task 16 xxxxxxxxxxxx
>> Task 5 xxx xxxx
>> Task 44 xxxxxxxxxxxxxxxx
>>
>>
>> where 'xxxxx' is the project timeline for each task.
>>
>> Thanks in advance.
>>

With some effort, this could be created in XL.