Color coding resources?

[Franzi]

Hi,

is it possible to color code the bars of a GANTT chart in relation to the
resources they use?

Green for joiners, blue for laminators.....

Would make it a lot easier to review our complex GANTT charts once they are
printed.

Thanks for your help,

Franziska

Ps.: We use Project 2002

 

[Franzi]

Sorry I overlooked the thread:

How to set up different color for each resource in Project Gantt?

It has appropriate answers,

regards,

Franzi

 

[Gérard Ducouret]

Franzy,

It's possible but that needs a little work:
Insert a Flag field (Flag1) for example, in any task table
Right click the name Flaag1 / Customize Fields
Formula : IIf(InStr([Resource Names],"Joiners"),True,False)
Use the Flag2 for Laminators...

Format / Bar styles...
Create a new symbole bar named "Joiners task" with green color
In the Show For column,select : Normal, Flag1
Do the same thing for Laminators....

Hope this helps,

Gérard Ducouret

 

[Franzi]

Dear Gerard,

thanks for your help!

I followed your instructions but still have it not working, I think this is
due to using a german project version.
What I have done is:

1.I, created a new column of the Flag (in the German version I use, I think
this is called "Attribut") type.
2.Named the column laminators.
3. Went to customize fields.
4.Choose the tab customizeed fields
5.Choose for field Attribut 1
6.Went to userspecified properties
7. Clicked formula and wrote in there:

IIf([Ressourcennamen]="Lamination team",true,false)

8. When I go back to the GANTT view I do only get a NEIN in the new column
also it should read read at least Ja in some task rows where I have only set
"Lamination team" as resource.

Ja=yes, Nein=no

I can change the Ja to Nein manually, but it does not show automatically
right ;-(

Any ideas whats wrong?

Thanks,

Franzi

Franzy,

It's possible but that needs a little work:
Insert a Flag field (Flag1) for example, in any task table
Right click the name Flaag1 / Customize Fields
Formula : IIf(InStr([Resource Names],"Joiners"),True,False)
Use the Flag2 for Laminators...

Format / Bar styles...
Create a new symbole bar named "Joiners task" with green color
In the Show For column,select : Normal, Flag1
Do the same thing for Laminators....

Hope this helps,

Gérard Ducouret

Hi,

is it possible to color code the bars of a GANTT chart in relation to the
resources they use?

Green for joiners, blue for laminators.....

Would make it a lot easier to review our complex GANTT charts once they
are
printed.

Thanks for your help,

Franziska

Ps.: We use Project 2002

 

[Jan De Messemaeker]

Hallo,

Versuchen Sie mal Ja und Nein statt True und False.
Gruesse,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Dear Gerard,

thanks for your help!

I followed your instructions but still have it not working, I think this
is
due to using a german project version.
What I have done is:

1.I, created a new column of the Flag (in the German version I use, I
think
this is called "Attribut") type.
2.Named the column laminators.
3. Went to customize fields.
4.Choose the tab customizeed fields
5.Choose for field Attribut 1
6.Went to userspecified properties
7. Clicked formula and wrote in there:

IIf([Ressourcennamen]="Lamination team",true,false)

8. When I go back to the GANTT view I do only get a NEIN in the new column
also it should read read at least Ja in some task rows where I have only
set
"Lamination team" as resource.

Ja=yes, Nein=no

I can change the Ja to Nein manually, but it does not show automatically
right ;-(

Any ideas whats wrong?

Thanks,

Franzi

Franzy,

It's possible but that needs a little work:
Insert a Flag field (Flag1) for example, in any task table
Right click the name Flaag1 / Customize Fields
Formula : IIf(InStr([Resource Names],"Joiners"),True,False)
Use the Flag2 for Laminators...

Format / Bar styles...
Create a new symbole bar named "Joiners task" with green color
In the Show For column,select : Normal, Flag1
Do the same thing for Laminators....

Hope this helps,

Gérard Ducouret

"Franzi" <[email protected]> a écrit dans le message de
(e-mail address removed)...

Hi,

is it possible to color code the bars of a GANTT chart in relation to
the
resources they use?

Green for joiners, blue for laminators.....

Would make it a lot easier to review our complex GANTT charts once they
are
printed.

Thanks for your help,

Franziska

Ps.: We use Project 2002

 

[Franzi]

Dear Jan,

thanks, the formula seems to accept "Ja" but not "Nein". With true & false
the formula gets accepted but results in the above mentioned situation ;-(

Any other thoughts?

Regards,

Franzi

Hallo,

Versuchen Sie mal Ja und Nein statt True und False.
Gruesse,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Dear Gerard,

thanks for your help!

I followed your instructions but still have it not working, I think this
is
due to using a german project version.
What I have done is:

1.I, created a new column of the Flag (in the German version I use, I
think
this is called "Attribut") type.
2.Named the column laminators.
3. Went to customize fields.
4.Choose the tab customizeed fields
5.Choose for field Attribut 1
6.Went to userspecified properties
7. Clicked formula and wrote in there:

IIf([Ressourcennamen]="Lamination team",true,false)

8. When I go back to the GANTT view I do only get a NEIN in the new column
also it should read read at least Ja in some task rows where I have only
set
"Lamination team" as resource.

Ja=yes, Nein=no

I can change the Ja to Nein manually, but it does not show automatically
right ;-(

Any ideas whats wrong?

Thanks,

Franzi

Franzy,

It's possible but that needs a little work:
Insert a Flag field (Flag1) for example, in any task table
Right click the name Flaag1 / Customize Fields
Formula : IIf(InStr([Resource Names],"Joiners"),True,False)
Use the Flag2 for Laminators...

Format / Bar styles...
Create a new symbole bar named "Joiners task" with green color
In the Show For column,select : Normal, Flag1
Do the same thing for Laminators....

Hope this helps,

Gérard Ducouret

"Franzi" <[email protected]> a écrit dans le message de
(e-mail address removed)...
Hi,

is it possible to color code the bars of a GANTT chart in relation to
the
resources they use?

Green for joiners, blue for laminators.....

Would make it a lot easier to review our complex GANTT charts once they
are
printed.

Thanks for your help,

Franziska

Ps.: We use Project 2002

 

[Jan De Messemaeker]

Hi Franzi,

Then don't you have a leading or trailing blank in the resource name?
Try with a simpler name or use Gerard's suggestion to use the Instr
function.

Hope this helps,
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Dear Jan,

thanks, the formula seems to accept "Ja" but not "Nein". With true & false
the formula gets accepted but results in the above mentioned situation ;-(

Any other thoughts?

Regards,

Franzi

Hallo,

Versuchen Sie mal Ja und Nein statt True und False.
Gruesse,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Dear Gerard,

thanks for your help!

I followed your instructions but still have it not working, I think
this
is
due to using a german project version.
What I have done is:

1.I, created a new column of the Flag (in the German version I use, I
think
this is called "Attribut") type.
2.Named the column laminators.
3. Went to customize fields.
4.Choose the tab customizeed fields
5.Choose for field Attribut 1
6.Went to userspecified properties
7. Clicked formula and wrote in there:

IIf([Ressourcennamen]="Lamination team",true,false)

8. When I go back to the GANTT view I do only get a NEIN in the new
column
also it should read read at least Ja in some task rows where I have
only
set
"Lamination team" as resource.

Ja=yes, Nein=no

I can change the Ja to Nein manually, but it does not show
automatically
right ;-(

Any ideas whats wrong?

Thanks,

Franzi





:

Franzy,

It's possible but that needs a little work:
Insert a Flag field (Flag1) for example, in any task table
Right click the name Flaag1 / Customize Fields
Formula : IIf(InStr([Resource Names],"Joiners"),True,False)
Use the Flag2 for Laminators...

Format / Bar styles...
Create a new symbole bar named "Joiners task" with green color
In the Show For column,select : Normal, Flag1
Do the same thing for Laminators....

Hope this helps,

Gérard Ducouret

"Franzi" <[email protected]> a écrit dans le message de
(e-mail address removed)...
Hi,

is it possible to color code the bars of a GANTT chart in relation
to
the
resources they use?

Green for joiners, blue for laminators.....

Would make it a lot easier to review our complex GANTT charts once
they
are
printed.

Thanks for your help,

Franziska

Ps.: We use Project 2002

 

[Franzi]

Hi,

already tried the Instr function. same story ;-(

I'll see what happens if I use a resource name without space.

Later more. I'll try at home.

Thanks for your help and have a great weekend.

Cheerio,

Franzi

Hi Franzi,

Then don't you have a leading or trailing blank in the resource name?
Try with a simpler name or use Gerard's suggestion to use the Instr
function.

Hope this helps,
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Dear Jan,

thanks, the formula seems to accept "Ja" but not "Nein". With true & false
the formula gets accepted but results in the above mentioned situation ;-(

Any other thoughts?

Regards,

Franzi

Hallo,

Versuchen Sie mal Ja und Nein statt True und False.
Gruesse,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
Dear Gerard,

thanks for your help!

I followed your instructions but still have it not working, I think
this
is
due to using a german project version.
What I have done is:

1.I, created a new column of the Flag (in the German version I use, I
think
this is called "Attribut") type.
2.Named the column laminators.
3. Went to customize fields.
4.Choose the tab customizeed fields
5.Choose for field Attribut 1
6.Went to userspecified properties
7. Clicked formula and wrote in there:

IIf([Ressourcennamen]="Lamination team",true,false)

8. When I go back to the GANTT view I do only get a NEIN in the new
column
also it should read read at least Ja in some task rows where I have
only
set
"Lamination team" as resource.

Ja=yes, Nein=no

I can change the Ja to Nein manually, but it does not show
automatically
right ;-(

Any ideas whats wrong?

Thanks,

Franzi





:

Franzy,

It's possible but that needs a little work:
Insert a Flag field (Flag1) for example, in any task table
Right click the name Flaag1 / Customize Fields
Formula : IIf(InStr([Resource Names],"Joiners"),True,False)
Use the Flag2 for Laminators...

Format / Bar styles...
Create a new symbole bar named "Joiners task" with green color
In the Show For column,select : Normal, Flag1
Do the same thing for Laminators....

Hope this helps,

Gérard Ducouret

"Franzi" <[email protected]> a écrit dans le message de
(e-mail address removed)...
Hi,

is it possible to color code the bars of a GANTT chart in relation
to
the
resources they use?

Green for joiners, blue for laminators.....

Would make it a lot easier to review our complex GANTT charts once
they
are
printed.

Thanks for your help,

Franziska

Ps.: We use Project 2002

 

[Robert]

<I can change the Ja to Nein manually, but it does not show automatically>

Franzy,

If you are able to do that (change the Ja to Nein manually) that means that
their is no formula in your "Attribut" (Flag) field.

Gérard Ducouret

 

[JulieS]

Franzi,

Pardon me for bumping in here -- where did you place the Flag field?
From reading your post, it looks like you may have put the flag field
plus formula in the Resource view? The flag field and formula needs to
go into a Task view (like Gantt chart). When you note that you can
manually change the field results to yes or no, that indicates that
there is no formula in that specific field.

I hope this helps.

Julie

Hi,

already tried the Instr function. same story ;-(

I'll see what happens if I use a resource name without space.

Later more. I'll try at home.

Thanks for your help and have a great weekend.

Cheerio,

Franzi

Hi Franzi,

Then don't you have a leading or trailing blank in the resource name?
Try with a simpler name or use Gerard's suggestion to use the Instr
function.

Hope this helps,
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Dear Jan,

thanks, the formula seems to accept "Ja" but not "Nein". With true
& false
the formula gets accepted but results in the above mentioned
situation ;-(

Any other thoughts?

Regards,

Franzi

:

Hallo,

Versuchen Sie mal Ja und Nein statt True und False.
Gruesse,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
Dear Gerard,

thanks for your help!

I followed your instructions but still have it not working, I
think
this
is
due to using a german project version.
What I have done is:

1.I, created a new column of the Flag (in the German version I
use, I
think
this is called "Attribut") type.
2.Named the column laminators.
3. Went to customize fields.
4.Choose the tab customizeed fields
5.Choose for field Attribut 1
6.Went to userspecified properties
7. Clicked formula and wrote in there:

IIf([Ressourcennamen]="Lamination team",true,false)

8. When I go back to the GANTT view I do only get a NEIN in the
new
column
also it should read read at least Ja in some task rows where I
have
only
set
"Lamination team" as resource.

Ja=yes, Nein=no

I can change the Ja to Nein manually, but it does not show
automatically
right ;-(

Any ideas whats wrong?

Thanks,

Franzi





:

Franzy,

It's possible but that needs a little work:
Insert a Flag field (Flag1) for example, in any task table
Right click the name Flaag1 / Customize Fields
Formula : IIf(InStr([Resource Names],"Joiners"),True,False)
Use the Flag2 for Laminators...

Format / Bar styles...
Create a new symbole bar named "Joiners task" with green color
In the Show For column,select : Normal, Flag1
Do the same thing for Laminators....

Hope this helps,

Gérard Ducouret

"Franzi" <[email protected]> a écrit dans le
message de
(e-mail address removed)...
Hi,

is it possible to color code the bars of a GANTT chart in
relation
to
the
resources they use?

Green for joiners, blue for laminators.....

Would make it a lot easier to review our complex GANTT charts
once
they
are
printed.

Thanks for your help,

Franziska

Ps.: We use Project 2002

 

[Franzi]

Hi Julie, hi Robert,

I found out why it did not work. In the individual projects this does work
as described but in my masterplan, which combines two projects it does not.
Any chance to do the same thing in such a "combination" file?

Thanks for your help!!!

Franzi

 

[Franzi]

One more thing, how do I color the link lines also automatically in as long
as they link two tasks with identical resources?

 

[JulieS]

Hello Franzi,

The Flag field formulas should carry over on inserted project files.
The custom bar formatting to can be copied over by copying the view from
one of the subproject files.

For example, if you have created the custom coloring in the Gantt chart
view: in Project A and Project B Create the master project file by
inserting the subprojects (A & B). Open one of the subprojects (Project
A) and display a view other than the Gantt chart view. Go to Tools >
Organizer and click the Views tab. At the bottom of the Organizer, on
the right side select Project A, on the left side at the bottom select
the name of your master project file. Select the Gantt chart view from
Project A and copy it to the master project.

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

 

[JulieS]

Hello Franzi,

I believe the link line color is driven by the order the custom bar
definitions appear in the view. So if you have the bars for your
lamination team green, move the custom bar definition above the
definition for Task and Critical task.

Julie

 

[Franzi]

Chere Julie,

ca marche!

Thanks a lot, it's working fine now.

Havea great weekend,

Franzi

 

[JulieS]

You're welcome Franzi and thanks for the feedback. Enjoy your weekend
as well!

Julie

Chere Julie,

ca marche!

Thanks a lot, it's working fine now.

Havea great weekend,

Franzi

<snip>

 

[Mike Glen]

Hi,

I thought that the link colour is driven by the successor colour.

Mike Glen
Project MVP

 

[JulieS]

Hi Mike,

Hmm. Actually in looking closely at the test file I made, it appears as
though they take the color of the predecessor task, but I believe the
order the bar styles appear in the dialog box are also involved. You've
inspired me to do some digging and I came across the following page that
Jack D. did some time ago.

http://zo-d.com/blog/archives/ms-project-tips/formatting-task-links-in-ms-project.html

Julie

 

[Mike Glen]

Good catch, Julie, I haven't seen that before.

Mike Glen
Project MVP

 

[Trivikram]

Something new and exciting for me...

Thanks guys... 3vikram...