Thread: Gantt Chart!
View Single Post
  #2  
Old April 9th, 2010, 01:54 PM posted to microsoft.public.excel.charting
Luke M[_4_]
external usenet poster
 
Posts: 451
Default Gantt Chart!

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

--
Best Regards,

Luke M
"Scott_goddard" wrote in message
...
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.