Can we Dynamically change gantt bars?

[Dora Tarver]

Hello

Is it possible to change the individual gantt or taskbar colors dynamically
based on schedule details? I am using Project 2000. I am famililar with
custum columns and adding formula into custom columns, however I want to
display different gantt or taskbar colors dynamically based on data in the
schedule.

Any insight would be greatly appreciated.

 

[John]

Hello

Is it possible to change the individual gantt or taskbar colors dynamically
based on schedule details? I am using Project 2000. I am famililar with
custum columns and adding formula into custom columns, however I want to
display different gantt or taskbar colors dynamically based on data in the
schedule.

Any insight would be greatly appreciated.

Dora,
Why are you posting again? Both Julie and I answered this question this
morning. Did you check my last response to that thread?

John

 

[Dora Tarver]

Hi John

Actuall you and julie did not answer my question.

 

[Dora Tarver]

Hi John,

You did not answer my question.

 

[JulieS]

Dora,

Let's try again. Insert two flag fields: Flag1 and Flag2

I assume you can create the test to show "XYZ" or "MNO" in a custom
field, let's call it customfield1.

In the Flag1 field, customize the field (just like you did when you
created the custom formula for the stop light reports.)

The formula for Flag1 would be something like:

IIf([customfield1] = "XYZ", yes, no)

This will change the Flag1 field to Yes for tasks where the custom field
= "XYZ"

In the Flag2 field create a custom formula something like:
IIf([customfield1] = "MNO", yes, no)

This will set the Flag2 field to Yes where your custom field = "MNO".

Then, as the FAQ 31 states:,
From the Gantt view you will go to Format > Bar Styles. Make a copy of
the Task Bar - Cut row/Paste row (to pit it back again). Change the
task bar name to XYZ, then change its color/pattern/end shapes to suit.
Click in the Show For.... area. Delete Normal, Non-Critical, click the
drop down arrow and select Flag 1. This will now show those XYZ tasks
where Flag1 = yes to the bar style of your choice.

Repeat the process for MNO tasks.

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

 

[Rod Gill]

Dora,

From what I can read Julie has certainly answered your question, and I
suspect John gave the same answer but his post isn't visible on my system!

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: www.projectvbabook.com

Dora,

Let's try again. Insert two flag fields: Flag1 and Flag2

I assume you can create the test to show "XYZ" or "MNO" in a custom field,
let's call it customfield1.

In the Flag1 field, customize the field (just like you did when you
created the custom formula for the stop light reports.)

The formula for Flag1 would be something like:

IIf([customfield1] = "XYZ", yes, no)

This will change the Flag1 field to Yes for tasks where the custom field =
"XYZ"

In the Flag2 field create a custom formula something like:
IIf([customfield1] = "MNO", yes, no)

This will set the Flag2 field to Yes where your custom field = "MNO".

Then, as the FAQ 31 states:,
From the Gantt view you will go to Format > Bar Styles. Make a copy of
the Task Bar - Cut row/Paste row (to pit it back again). Change the task
bar name to XYZ, then change its color/pattern/end shapes to suit. Click
in the Show For.... area. Delete Normal, Non-Critical, click the drop down
arrow and select Flag 1. This will now show those XYZ tasks where Flag1 =
yes to the bar style of your choice.

Repeat the process for MNO tasks.

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

Hi John

Actuall you and julie did not answer my question.

 

[Steve House]

Dora, the others did answer your question but I'll try to explain it another
way, maybe it will help.

Gantt Chart bars cannot always be DIRECTLY formatted based on schedule data
but they can be INDIRECTLY formatted as you want. Right click on the Gantt
chart and choose "Bar Styles ..." from the popup menu. In the middle of
that chart of style definitions, you'll see "Show For ... Tasks." Click in
one of the cells in that column and open the pull down. That will give you
a list of all the task attributes that you can define a specific bar
style/colour etc for. If the schedule detail you want to assign a unique
bar colour to is in that list, all you need to do is create a new bar style,
format it the way you want it, and assign that attribute as its trigger.
If, for instance, you want a task bar to turn green when work begins on it,
add a new bar style to the list and select "In Progress" from the pulldown
as its trigger. But if the exact trigger you want - for example, lets say
you want all tasks with a duration over 10 days to be purple - is not in the
list, at the bottom of the attribute list you'll find all the Flag fields
listed. Customize the flag field of your choice so that it has the value
"True" is the condition you're interested in (as in Duration > 10 days) is
met and "False" if the condition you're interested in is not met. Then
create a new bar style formatted the way you want and make that particular
flag field the trigger to set the bar to that style. The style will be
applied to all bars for whom the flag condition is "True" and not applied to
the others.

If this doesn't answer your question, then we'll need more details about
exactly what you need to do, exactly what circumstances should trigger a
particular colour change.

 

[John]

Hi John,

You did not answer my question.

Dora,
Well, that's now three of us that gave you the same answer. If it still
isn't what you want, then you will need to enlighten us all.

John
Project MVP

 

[John]

Dora,

From what I can read Julie has certainly answered your question, and I
suspect John gave the same answer but his post isn't visible on my system!

Rod,
Wow, how could I not be visible! Sometimes it feels like the whole world
is looking at me. Oh oh, here come those two guys in the white coats
again. Noooooo....... (fade to black)

John

NEW!! Project VBA Book, for details visit: www.projectvbabook.com

Dora,

Let's try again. Insert two flag fields: Flag1 and Flag2

I assume you can create the test to show "XYZ" or "MNO" in a custom field,
let's call it customfield1.

In the Flag1 field, customize the field (just like you did when you
created the custom formula for the stop light reports.)

The formula for Flag1 would be something like:

IIf([customfield1] = "XYZ", yes, no)

This will change the Flag1 field to Yes for tasks where the custom field =
"XYZ"

In the Flag2 field create a custom formula something like:
IIf([customfield1] = "MNO", yes, no)

This will set the Flag2 field to Yes where your custom field = "MNO".

Then, as the FAQ 31 states:,
From the Gantt view you will go to Format > Bar Styles. Make a copy of
the Task Bar - Cut row/Paste row (to pit it back again). Change the task
bar name to XYZ, then change its color/pattern/end shapes to suit. Click
in the Show For.... area. Delete Normal, Non-Critical, click the drop down
arrow and select Flag 1. This will now show those XYZ tasks where Flag1 =
yes to the bar style of your choice.

Repeat the process for MNO tasks.

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

Hi John

Actuall you and julie did not answer my question.

:

Hello

Is it possible to change the individual gantt or taskbar colors
dynamically
based on schedule details? I am using Project 2000. I am famililar
with
custum columns and adding formula into custom columns, however I want
to
display different gantt or taskbar colors dynamically based on data in
the
schedule.

Any insight would be greatly appreciated.

Dora,
Why are you posting again? Both Julie and I answered this question this
morning. Did you check my last response to that thread?

John