Gantt Chart Colours


D

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....
 
Ad

Advertisements

J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top