Loading...
Quick Links

Gantt Chart Bar color based on task name

Home Forums Discussion Gantt Chart Bar color based on task name

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #413276 Reply
    guy forget
    Participant

    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.

    #413279 Reply
    Larry ChristofaroLarry Christofaro
    Participant

    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…

    #413281 Reply
    Thomas Boyle
    Guest

    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.

Viewing 3 posts - 1 through 3 (of 3 total)
Reply To: Gantt Chart Bar color based on task name
Your information: