4

I've got a project with tasks that are assigned to one of several resources. In my Gantt chart, I'd like the tasks assigned to the 'iOS' resources to be a different color than the tasks assigned to the 'Rails' or 'Design' or 'QA' resources.

How can I do this?

4

The best way I've found to do this is to use the build in set of Flag fields, Flag1 up to Flag20. If you have more than 20 resources to color code, this method won't work for you. Note: I'm using Microsoft Project Standard 2013.

We'll start by color coding the 'iOS' resources. Your resource names are assumed to be: iOS, Rails, Design, and QA.

In your Gantt chart view:

  1. Add the Flag1 column to your chart. Click the Add New Column button, then type Flag1 and press enter.
  2. Right click on the Flag1 column header, and choose Custom Fields.
  3. Click the Flag1 field, and click the Rename button. Name it iOS.
  4. With the newly renamed iOS field selected, click the Formula button under custom attributes.
  5. Type in this formula: IIf([Resource Names]="iOS",Yes,No)
  6. Click OK. You should now have a column that says Yes whenever an iOS resource is assigned, and No otherwise.

Now to turn that flag into a color bar.

  1. In your Gantt chart view, right click in an open area and choose Bar Styles
  2. Click on the Task bar, then the Cut Row button, and the Paste Row button twice. You should now have two bars titled Task.
  3. Rename one bar to 'iOS Task'.
  4. For the iOS Task, in the Show for ... Tasks column, edit that text to add the text ,Flag1 to the mix. The result for me was Normal,Active,Not Manually Scheduled,Flag1
  5. Now click iOS Task, and you can change it's color, text, etc. to suite your style.

Repeat these steps for the other resources.

| improve this answer | |
  • 1
    Very important, the new created Task style must be on the line below the built-in, otherwise you will not able to see the custom one! – Pedro77 Nov 30 '14 at 19:24
  • Better still, to allow for multiple resources per task, use the formula IIf(InStr([Resource Names], "iOS"),Yes,No) – Carlos P Aug 31 '17 at 9:32
2

I had trouble with the above path in Project 2010 and found an alternate way to go about doing this.

In your Gantt chart view:

  1. Add the Flag1 column to your chart. Click the Add New Column button, then type Flag1 and press enter.
  2. Right click on the Flag1 column header, and choose Custom Fields.
  3. Click the Flag1 field, and click the Rename button. Name it iOS.
  4. With the newly renamed iOS field selected, click the Formula button under custom attributes.
  5. Type in this formula: [Resource Names]="iOS"
  6. Click OK. You should now have a column that says Yes whenever an iOS resource is assigned, and No otherwise.

Now to turn that flag into a color bar.

  1. In your Gantt chart view, right click in an open area and choose Bar Styles
  2. Click Insert Row Rename the bar to 'iOS Task'.
  3. For the iOS Task, in the Show for ... Tasks column and only Flag1 to the mix.
  4. Change the color, text, etc. to suite your style.
  5. Click OK.

Thanks for the lead!

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.