ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Gantt Chart! (https://www.excelbanter.com/charts-charting-excel/261052-gantt-chart.html)

Scott_goddard

Gantt Chart!
 
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.


Luke M[_4_]

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.





All times are GMT +1. The time now is 06:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com