% completed in a Gantt Chart

[Michael B.]

Is there a way to show the percentage completed for a given task? I would
like the bars in my Gantt chart to show how much of the task is completed,
either by manual input of a % completed column, or based on calendar days.
For example, on a given task's bar, 75% of the bar would be blue, the
remaining 25% green, indicating the % completed.

 

[Paul Herber]

Is there a way to show the percentage completed for a given task? I would
like the bars in my Gantt chart to show how much of the task is completed,
either by manual input of a % completed column, or based on calendar days.
For example, on a given task's bar, 75% of the bar would be blue, the
remaining 25% green, indicating the % completed.

The task bars have a yellow control at the left hand end, if you drag
this to the right you'll get a pink bar overwriting the task bar.
Now, the formulae for length of the blue and pink bars can be copied
and pasted into user-defined cells of any other shape. The ratio of
the 2 values *100 will give you your %age.