A
Andrew Carstens
I am developing an ICT Roadmap for a large Governement org in Australia,
which looks forward 3 years and maps out a range of tasks (each a
multi-million project) towards a desired future state.
The total gantt chart is a master project made up of 5 sub-projects
I want to colour code the three different types of tasks.
1) Approved and funded tasks (typically year 1)
2) Approved but unfunded tasks (typically year 2)
3) Tasks which are not yet approved (typically year 3)
A critical path is not required for colour coding purposes
I tried to make a single field, with entry 1,2,or 3 in it, but was unable to
make that work, either for filtering (I did not perservere) or for bar
colouring.
I did achieved the goal with a clumsy set of three fields (flag1, flag2,
flag3), which have yes/no against each, which can then be used in Bar Types
to set colours. I must have 2 no, and 1 yes, which is a manual process, and
is subject to change over time as we roll the roadmap forward each year (or
quarter) and project status changes.
Can anyone suggest a more elegant way of achieving this ?
which looks forward 3 years and maps out a range of tasks (each a
multi-million project) towards a desired future state.
The total gantt chart is a master project made up of 5 sub-projects
I want to colour code the three different types of tasks.
1) Approved and funded tasks (typically year 1)
2) Approved but unfunded tasks (typically year 2)
3) Tasks which are not yet approved (typically year 3)
A critical path is not required for colour coding purposes
I tried to make a single field, with entry 1,2,or 3 in it, but was unable to
make that work, either for filtering (I did not perservere) or for bar
colouring.
I did achieved the goal with a clumsy set of three fields (flag1, flag2,
flag3), which have yes/no against each, which can then be used in Bar Types
to set colours. I must have 2 no, and 1 yes, which is a manual process, and
is subject to change over time as we roll the roadmap forward each year (or
quarter) and project status changes.
Can anyone suggest a more elegant way of achieving this ?