Pete Mccann
Member
Dear all,
One of the Tasks that we have to monitor (and report on) contains some sub-tasks (there may be anything from 2 to 20 sub-tasks in a single Task). Some of these sub-tasks are connected (i.e. sub-task 2 cannot start before sub-task 1 completes) or the sub-tasks may be independent of each other. But all the sub-tasks must be completed before we can say that the Task is completed.
We create a baseline (Plan) set of information and then as the project progresses, we update the Plan dates with new Forecast dates for the sub-tasks.
Essentially for each task (and its associated sub-tasks) I would like to create a column chart like the "example chart" using the information in the "example data" file.
I would also like to be able to automatically color any completed sub-tasks green in the chart when the individual sub-task is completed; when all subtasks are completed, I would like all sub-task columns and the Task column itself to be automatically colored green.
In the attached spreadsheet, the information in J3:AB15 is for illustrative purposes only.
Many thanks in advance.
One of the Tasks that we have to monitor (and report on) contains some sub-tasks (there may be anything from 2 to 20 sub-tasks in a single Task). Some of these sub-tasks are connected (i.e. sub-task 2 cannot start before sub-task 1 completes) or the sub-tasks may be independent of each other. But all the sub-tasks must be completed before we can say that the Task is completed.
We create a baseline (Plan) set of information and then as the project progresses, we update the Plan dates with new Forecast dates for the sub-tasks.
Essentially for each task (and its associated sub-tasks) I would like to create a column chart like the "example chart" using the information in the "example data" file.
I would also like to be able to automatically color any completed sub-tasks green in the chart when the individual sub-task is completed; when all subtasks are completed, I would like all sub-task columns and the Task column itself to be automatically colored green.
In the attached spreadsheet, the information in J3:AB15 is for illustrative purposes only.
Many thanks in advance.