Hi,
I’m currently trying to put together a Gantt chart in MS Project.
I would like to be able to group together similar tasks ie. Tasks representing a certain business area are listed first followed by tasks representing a different business area underneath. I would also like their corresponding bar on the gantt chart to be a particular colour dependent upon what group that task is in.
I’m fairly new to Project and the only way I can think to achieve this so far is to create a column called "Group name" with ’field name’ set to "Text1". The cell contents will then be the name of the group eg "Retail","Supply Chain" etc. I would then look to create a macro that would search the "Group name" column and then change the colour of the bar dependent upon the value in the cell eg red for "retail", blue for "supply chain" etc.
Is this possible? Am I overly complicating an easy task?
Apologies if there is a simpler way round this, however my knowledge is fairly limited! Any help would be greatly appreciated.
Thank you in advance.
I’m currently trying to put together a Gantt chart in MS Project.
I would like to be able to group together similar tasks ie. Tasks representing a certain business area are listed first followed by tasks representing a different business area underneath. I would also like their corresponding bar on the gantt chart to be a particular colour dependent upon what group that task is in.
I’m fairly new to Project and the only way I can think to achieve this so far is to create a column called "Group name" with ’field name’ set to "Text1". The cell contents will then be the name of the group eg "Retail","Supply Chain" etc. I would then look to create a macro that would search the "Group name" column and then change the colour of the bar dependent upon the value in the cell eg red for "retail", blue for "supply chain" etc.
Is this possible? Am I overly complicating an easy task?
Apologies if there is a simpler way round this, however my knowledge is fairly limited! Any help would be greatly appreciated.
Thank you in advance.