Can we Dynamically change gantt bars?

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
Fri Oct 27 16:07:54 CDT 2006

In article <A420BF25-2179-40AA-ABAE-61557610C349@microsoft.com>,
Dora Tarver <DoraTarver@discussions.microsoft.com> wrote:

> 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

DoraTarver
Fri Oct 27 16:16:02 CDT 2006

Hi John

Actuall you and julie did not answer my question.

"John" wrote:

> In article <A420BF25-2179-40AA-ABAE-61557610C349@microsoft.com>,
> Dora Tarver <DoraTarver@discussions.microsoft.com> wrote:
>
> > 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
>

DoraTarver
Fri Oct 27 16:19:02 CDT 2006

Hi John,

You did not answer my question.

"Dora Tarver" wrote:

> 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.
>

JulieS
Fri Oct 27 16:46:55 CDT 2006

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


"Dora Tarver" <DoraTarver@discussions.microsoft.com> wrote in message
news:9A5FB981-03A4-486E-B3BB-3412630E618F@microsoft.com...
> Hi John
>
> Actuall you and julie did not answer my question.
>
> "John" wrote:
>
>> In article <A420BF25-2179-40AA-ABAE-61557610C349@microsoft.com>,
>> Dora Tarver <DoraTarver@discussions.microsoft.com> wrote:
>>
>> > 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
>>

Rod
Fri Oct 27 19:23:14 CDT 2006

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


"JulieS" <passport6847 at maine dot rr dot com> wrote in message
news:OpwArFh%23GHA.3256@TK2MSFTNGP02.phx.gbl...
> 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
>
>
> "Dora Tarver" <DoraTarver@discussions.microsoft.com> wrote in message
> news:9A5FB981-03A4-486E-B3BB-3412630E618F@microsoft.com...
>> Hi John
>>
>> Actuall you and julie did not answer my question.
>>
>> "John" wrote:
>>
>>> In article <A420BF25-2179-40AA-ABAE-61557610C349@microsoft.com>,
>>> Dora Tarver <DoraTarver@discussions.microsoft.com> wrote:
>>>
>>> > 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
>>>
>
>

Steve
Sat Oct 28 08:38:32 CDT 2006

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.

--
Steve House [Project MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs



"Dora Tarver" <DoraTarver@discussions.microsoft.com> wrote in message
news:35446C43-C78A-47B3-A853-F6F7897CA759@microsoft.com...
> Hi John,
>
> You did not answer my question.
>
> "Dora Tarver" wrote:
>
>> 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
Sat Oct 28 11:26:56 CDT 2006

In article <35446C43-C78A-47B3-A853-F6F7897CA759@microsoft.com>,
Dora Tarver <DoraTarver@discussions.microsoft.com> wrote:

> 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
>
> "Dora Tarver" wrote:
>
> > 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
Sun Oct 29 12:48:57 CST 2006

In article <OJcXCdi#GHA.4712@TK2MSFTNGP03.phx.gbl>,
"Rod Gill" <rod AT project-systems DOT co DOT nz> wrote:

> 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

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
>
>
> "JulieS" <passport6847 at maine dot rr dot com> wrote in message
> news:OpwArFh%23GHA.3256@TK2MSFTNGP02.phx.gbl...
> > 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
> >
> >
> > "Dora Tarver" <DoraTarver@discussions.microsoft.com> wrote in message
> > news:9A5FB981-03A4-486E-B3BB-3412630E618F@microsoft.com...
> >> Hi John
> >>
> >> Actuall you and julie did not answer my question.
> >>
> >> "John" wrote:
> >>
> >>> In article <A420BF25-2179-40AA-ABAE-61557610C349@microsoft.com>,
> >>> Dora Tarver <DoraTarver@discussions.microsoft.com> wrote:
> >>>
> >>> > 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
> >>>
> >
> >