Display % complete on Gantt without extending status bar?

**drewship** · 09-21-2010, 11:29 AM

Hello all. I have been researching the forums and adapted the attached Gantt.

I need to be able to enter a % complete and have the applicable task status bar change color to represent the % entered by the user.

Currently, I use column F for the user to enter the % Complete. Column D calculates the numerical value needed by the chart by subtracting the Start Date from the End Date and multiplies this value by the % Completed entered by the user.

Please Login or Register  to view this content.

So if a task is scheduled for 10 days, a 50% Complete entry would yield a numerical value of 5 which the Task status bar would then (theoretically) change the color of half of the bar. What is happening is the status bar is being lengthened by the amount of the numerical value.

Can someone please assist?

Thanks,
Andrew.

**Andy Pope** · 09-22-2010, 04:01 AM

Can you explain the logic behind the formula in column E.

Should it not be
=(C7-B7)*(1-F7)

**drewship** · 09-22-2010, 07:35 AM

Hello Andy. I need to show the actual days remaining for each task so the formula ensures that the remaining days are displayed every time the sheet is opened. Just because the days advance does not mean that any progress has been made on the task, that is what the % Completed is used for. I figured out a rough way of meeting my need in the attached workbook, but need to have a way to add new tasks and have the chart update automatically with the added task information. Could a named range work for this?

Thanks,
Andrew

**Andy Pope** · 09-22-2010, 08:47 AM

Yes you should be able to use named ranges to automatically extend number of tasks.

Days remaining makes sense if you are not using it as part of the chart data.
As it is simply the number of days from today to the completion date for each task.

**drewship** · 09-22-2010, 09:13 AM

Thanks. Looking through the forum now for solutions...

**drewship** · 09-22-2010, 12:44 PM

Andy, I looked through the forum and some of the websites referenced as well but I am having trouble implementing the named range for my chart. I created the named ranges and tried to link them in the chart with:

Please Login or Register  to view this content.

Since I am actually changing the length of the blue and red bar together to simulate the completion %, I am at a loss how to incorporate the named ranges to allow the addition of tasks as the project progresses while reflecting the changes automatically on the chart.

Any help would be appreciated.

Thanks,
Andrew