Gantt Chart Bar color based on task name

[guy forget]

I have seen a project in which the color of Gantt chart bar change based on task name.
The enterprise in building containers, the same tasks like: cutting, folding, welding, painting etc. comes back on regular basses.
Someone which does not work there any more did something, so that the color of the bar change based on tasks name.
I would like to learn how to do it.

[Larry Christofaro]

You don’t believe you an set a bar color based on task name itself without some sort of VBA code. Gantt styles provide the ability to format a bar based on a flag. I’ve setup a view with flags, that set a bar style/color based on what you set you Yes. Hope that helps…

[Thomas Boyle]

As Larry says, create a special bar style with “Show For…” = Flag1 (or some other custom flag field.) Then use a formula to populate the flag field based on the task name. e.g. Flag1=InStr(1,[Name],”Cut”) automatically sets Flag1 to “Yes” if the task name contains “Cut” (not case-sensitive). You would need a distinct Flag field (maximum of 20) for each distinct bar style you want to set.

[Author]

Posts