Prev: Chart daily data and add a trend line for each week
Next: Please help with complex graph!
From: Scott_goddard on 8 Apr 2010 15:38
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.

From: Luke M on 9 Apr 2010 08:54
Use a formula to translate % complete into days complete:
=(EndDate - StartDate) * % Complete
DaysLeft:
=EndDate - DaysComplete

--
Best Regards,

Luke M
"Scott_goddard" <Scottgoddard(a)discussions.microsoft.com> wrote in message
news:CF26A365-1662-42C2-B78C-8DD98675A4EC(a)microsoft.com...
> 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.
>


 | 
Pages: 1
Prev: Chart daily data and add a trend line for each week
Next: Please help with complex graph!