GanttChartGantt Chart Version 1.7.3©2006-2012 Vertex42 LLC 0 HELP[Project Name][Company Name]Today’s Date:2/24/2009 Tuesday(vertical red line)Project Lead:[Name][42]Start Date:1/2/2012 Monday[42]First Day of Week(Mon=2):2 1/2/2012 1/3/2012 1/4/2012 1/5/2012 1/6/2012 1/7/2012 1/8/2012 1/9/2012 1/10/2012 1/11/2012 1/12/2012 1/13/2012 1/14/2012 1/15/2012 1/16/2012 1/17/2012 1/18/2012 1/19/2012 1/20/2012 1/21/2012 1/22/2012 1/23/2012 1/24/2012 1/25/2012 1/26/2012 1/27/2012 1/28/2012 1/29/2012 1/30/2012 1/31/2012 2/1/2012 2/2/2012 2/3/2012 2/4/2012 2/5/2012 2/6/2012 2/7/2012 2/8/2012 2/9/2012 2/10/2012 2/11/2012 2/12/2012 2/13/2012 2/14/2012 2/15/2012 2/16/2012 2/17/2012 2/18/2012 2/19/2012 2/20/2012 2/21/2012 2/22/2012 2/23/2012 2/24/2012 2/25/2012 2/26/2012 2/27/2012 2/28/2012 2/29/2012 3/1/2012 3/2/2012 3/3/2012 3/4/2012 3/5/2012 3/6/2012 3/7/2012 3/8/2012 3/9/2012 3/10/2012 3/11/2012 3/12/2012 3/13/2012 3/14/2012 3/15/2012 3/16/2012 3/17/2012 3/18/2012 3/19/2012 3/20/2012 3/21/2012 3/22/2012 3/23/2012 3/24/2012 3/25/2012 3/26/2012 3/27/2012 3/28/2012 3/29/2012 3/30/2012 3/31/2012 4/1/2012 4/2/2012 4/3/2012 4/4/2012 4/5/2012 4/6/2012 4/7/2012 4/8/2012 4/9/2012 4/10/2012 4/11/2012 4/12/2012 4/13/2012 4/14/2012 4/15/2012 4/16/2012 4/17/2012 4/18/2012 4/19/2012 4/20/2012 4/21/2012 4/22/2012 4/23/2012 4/24/2012 4/25/2012 4/26/2012 4/27/2012 4/28/2012 4/29/2012 4/30/2012 5/1/2012 5/2/2012 5/3/2012 5/4/2012 5/5/2012 5/6/2012 5/7/2012 5/8/2012 5/9/2012 5/10/2012 5/11/2012 5/12/2012 5/13/2012 5/14/2012 5/15/2012 5/16/2012 5/17/2012 5/18/2012 5/19/2012 5/20/2012 5/21/2012 5/22/2012 5/23/2012 5/24/2012 5/25/2012 5/26/2012 5/27/2012 5/28/2012 5/29/2012 5/30/2012 5/31/2012 6/1/2012 6/2/2012 6/3/2012 6/4/2012 6/5/2012 6/6/2012 6/7/2012 6/8/2012 6/9/2012 6/10/2012 6/11/2012 6/12/2012 6/13/2012 6/14/2012 6/15/2012 6/16/2012 6/17/2012 6/18/2012 6/19/2012 6/20/2012 6/21/2012 6/22/2012 6/23/2012 6/24/2012 6/25/2012 6/26/2012 6/27/2012 6/28/2012 6/29/2012 6/30/2012 7/1/2012 7/2/2012 7/3/2012 7/4/2012 7/5/2012 7/6/2012 7/7/2012 7/8/2012 7/9/2012 7/10/2012 7/11/2012 7/12/2012 7/13/2012 7/14/2012 7/15/2012 7/16/2012 7/17/2012 7/18/2012 7/19/2012 7/20/2012 7/21/2012 7/22/2012 7/23/2012 7/24/2012 7/25/2012 7/26/2012 7/27/2012 7/28/2012 7/29/2012 7/30/2012 7/31/2012 8/1/2012 8/2/2012 8/3/2012 8/4/2012 8/5/2012 8/6/2012 8/7/2012 8/8/2012 8/9/2012 8/10/2012 8/11/2012 8/12/2012 8/13/2012 8/14/2012 8/15/2012 8/16/2012 8/17/2012 8/18/2012 8/19/2012 8/20/2012 8/21/2012 8/22/2012 8/23/2012 8/24/2012 8/25/2012 8/26/2012 WBS Tasks TaskLead Start End Duration(Days)%Complete Working Days Days Complete Days Remaining 02-Jan-12 09-Jan-12 16-Jan-12 23-Jan-12 30-Jan-12 06-Feb-12 13-Feb-12 20-Feb-12 27-Feb-12 05-Mar-12 12-Mar-12 19-Mar-12 26-Mar-12 02-Apr-12 09-Apr-12 16-Apr-12 23-Apr-12 30-Apr-12 07-May-12 14-May-12 21-May-12 28-May-12 04-Jun-12 11-Jun-12 18-Jun-12 25-Jun-12 02-Jul-12 09-Jul-12 16-Jul-12 23-Jul-12 30-Jul-12 06-Aug-12 13-Aug-12 20-Aug-12 1 Task Category 1[Name]1/2/12 1/31/12 30 0%22 0 30 1.1 Sub Task level 2 1/2/12 1/6/12 5 0%5 0 5 1.2 Sub Task level 2 1/7/12 1/11/12 5 0%3 0 5 1.2.1 Sub Task level 3 1/12/12 1/16/12 5 0%3 0 5 1.2.2 Sub Task level 3 1/17/12 1/21/12 5 0%4 0 5 1.3 Sub Task level 2 1/22/12 1/26/12 5 0%4 0 5 1.4 Sub Task level 2 1/27/12 1/31/12 5 0%3 0 5 2 Task Category 2[Name]1/2/12 1/27/12 26 25%20 6 20 2.1 Sub Task level 2 1/2/12 1/6/12 5 25%5 1 4 2.2 Sub Task level 2 1/9/12 1/13/12 5 25%5 1 4 2.3 Sub Task level 2 1/16/12 1/20/12 5 25%5 1 4 2.4 Sub Task level 2 1/23/12 1/27/12 5 25%5 1 4 3 Task Category 3[Name]1/2/12 1/28/12 27 50%20 13 14 3.1 Sub Task level 2 1/2/12 1/7/12 6 50%5 3 3 3.2 Sub Task level 2 1/9/12 1/14/12 6 50%5 3 3 3.3 Sub Task level 2 1/16/12 1/21/12 6 50%5 3 3 3.4 Sub Task level 2 1/23/12 1/28/12 6 50%5 3 3 4 Task Category 4[Name]1/2/12 1/21/12 20 0%15 0 20 4.1 Sub Task level 2 1/2/12 1/6/12 5 0%5 0 5 4.2 Sub Task level 2 1/7/12 1/11/12 5 0%3 0 5 4.3 Sub Task level 2 1/12/12 1/16/12 5 0%3 0 5 4.4 Sub Task level 2 1/17/12 1/21/12 5 0%4 0 5 TEMPLATE ROWS:Copy and insert the entire section,or just the specific sub tasks,depending on which level you want to use(formulas are different for different WBS levels)1 Task Category 1 1/5/09 1/5/09 1 0%1 0 1 1.1 Sub Task level 2 1/5/09 1/5/09 1 0%1 0 1 1.1.1 Level 3 Task 1/5/09 1/5/09 1 0%1 0 1 1.1.1.1 Level 4 task 1/5/09 1/5/09 1 0%1 0 1©Gantt Chart Template©2008-2009 Vertex42 LLChttp://www.vertex42.com/ExcelTemplates/excel-gantt-chart.htmlGanttChartProGantt Chart Template Pro Gantt Chart Template Pro is similar to this free version,but it is unlocked,more feature-packed,and includes other bonus content such as sample project schedules.Already spent a lot of time working with this free version?That’s okay.In addition to downloading the Gantt Chart Template Pro files,you will be given the password for unlocking this spreadsheet.Learn More About Gantt Chart Template Pro http://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html-View screenshots-Watch demo videos Benefits and Features of Gantt Chart Template Pro Unlocked(worksheets are not password-protected)By unlocking the free version or using Gantt Chart Template Pro,you will be able to use all of the functions and features available in Excel,such as formatting cells,inserting columns,and grouping rows.More Ways to Define a Task Choose from a larger set of template rows that provide more options for defining the Start date,End date,duration,and dependency of tasks.Define a task based on the…-Start date and End date-Start date and Work days-Start date and Calendar days-Predecessor and End date-Predecessor and Work days-Predecessor and Calendar days Easily Create Task Dependencies Though you can still use your own formulas for creating task dependencies,the new Predecessor options make it very simple.One of the demo videos discusses this in detail.Exclude Holidays from Work Days List holidays in a separate sheet that you want to exclude from work days.Sample Project Schedules To get a head start on defining your project schedule,you can use one of the 3 sample gantt charts:-Home Construction Project Schedule-Custom Software Project Schedule-Website Development Project Schedule New Excel 2007+Version(XLSX)In addition to Gantt Chart Template Pro for Excel 2003,you will be able to download an XLSX version,for Excel 2007 or later,that allows you to easily color-code the bars of the gantt chart.Learn More About Gantt Chart Template Pro TermsOfUse。
""""""此处省略40%，请
登录会员，阅读正文所有内容。
