|
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.
Input Sheet 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 |
Task 6 | 2/1/2005 | 2/20/2005 | Team Green |
Task 7 | 1/1/2005 | 1/16/2005 | Team Red |
Task 8 | 4/1/2005 | 4/15/2005 | Bob |
Task 9 | 2/1/2005 | 3/10/2005 | Courtney |
Task 10 | 3/1/2005 | 4/1/2005 | Jim |
Task 11 | 4/5/2005 | 4/15/2005 | Dave |
Task 12 | 3/1/2005 | 4/10/2005 | Jenn |
Task 13 | 2/15/2005 | 2/26/2005 | Team Alpha |
Task 14 | 1/20/2005 | 1/31/2005 | Mike |
Task 15 | 3/31/2005 | 4/21/2005 | Jimmy |
Task 16 | 3/1/2005 | 4/1/2005 | Andy |
Task 17 | 2/1/2005 | 2/15/2005 | Cynthia |
Task 18 | 3/10/2005 | 4/30/2005 | Dawn |
Task 19 | 4/15/2005 | 4/30/2005 | Jenn |
Task 20 | 2/3/2005 | 3/3/2005 | Wendy |
Task 21 | 1/7/2005 | 1/31/2005 | Tim |
Task 22 | 3/12/2005 | 3/25/2005 | Don |
Task 23 | 4/10/2005 | 4/28/2005 | Dave |
Task 24 | 2/10/2005 | 2/28/2005 | Joe |
Task 25 | 1/15/2005 | 2/1/2005 | James |
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