Gantt Chart Colours

[DTB]

Does anyone have ideas on how to change the task bar
colour on the Gantt Chart based on the task's resource?

For instance, I would like:
All Mechanical tasks to have a blue bar;
All Electrical tasks to have a green bar;
All Operations tasks to have a magenta bar etc....

 

[Jan De Messemaeker]

Hi,

First, in Bar Styles, define each color you want to see and in Show For...
put Flag1, Flag2, etc.

Then the code could look about like this

For each job in activeproject.tasks
if not job is nothing then
select case job.reourcenames
case "Mechanic"
job.flag1=true
case "Electrical"
job.flag2=true


etcetera

HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620