Gantt Chart!

S

Scott_goddard

ok so there are loads of Gantt charts out there that use days completed and
days left and only a start date....I would like to use % completed and
remaing using an end date - does anyone know how to do this?

Task description
Start date
End date
% completed
% remaining.
 
L

Luke M

Use a formula to translate % complete into days complete:
=(EndDate - StartDate) * % Complete
DaysLeft:
=EndDate - DaysComplete
 
Top