Gantt Chart Bar color based on task name

Home Forums Microsoft Project Discussion Forum Gantt Chart Bar color based on task name

Viewing 2 reply threads
  • Author
    • #413276
      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.

    • #413279
      Avatar photoLarry 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…

    • #413281
      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.

Viewing 2 reply threads
  • You must be logged in to reply to this topic.