|
This MS Excel spreadsheetGantt Chart Creator is designed for those who need a quick and easy Gantt chart to present their project's progress. It can accommodate up to 25 project tasks and team members. Simply input the project's Start and end dates followed by tasks and their individual Start and end dates.
Screenshot of Input Sheet With 5 Tasks Filled In Back to:Gantt Chart Creator
Project Name | Sample | ||
Project Start Date | 1/1/2005 | ||
Project End Date | 4/15/2005 | ||
Task Name | Task Start Date | Task End Date | Responsible Party |
Task 1 | 1/1/2005 | 2/1/2005 | Matt |
Task 2 | 2/1/2005 | 3/1/2005 | Julie |
Task 3 | 1/1/2005 | 2/28/2005 | Tom |
Task 4 | 2/1/2005 | 2/28/2005 | John |
Task 5 | 3/1/2005 | 3/31/2005 | Katie |
INSTRUCTIONS |
ONLY MODIFY CELLS IN SHADED AREAS!!!! |
Insert Project Name in Cell B1 |
Insert Project Start Date in Cell B3 |
Insert Project End Date in Cell B5 |
Insert Task Names in Cells A10 to A34. If entering fewer than 25 tasks, make sure to delete any task names in the shaded area that you don't want to show up in your GanttChart. |
Insert Task Start Dates in Cells B10 to B34 that correspond to the tasks you entered in the previous step. |
Insert Task End Dates in Cells C10 to C34 that correspond to the tasks you previously entered. |
Insert Names of Responsible Parties in Cells D10 to D34 that correspond to the tasks you previously entered. |
Sit back and take a look at your automatically-calculated Gantt Chart!!!! |
Back to: Gantt Chart Creator
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALLpurchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader PackageTechnical Analysis in Excel With $139.00 of FREE software!
Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft