Excel Templates | Excel Spreadsheets | Project Gantt Chart Template

Project Gantt Chart Template

Posted on February 25, 2012
Filed Under Productivity | 6 Comments

It has been 2.5 years since I released my first Gantt Chart template for excel. There were many feedback come to me directly through email or via my comment box to add more features and function to ease them creating their plan. With the release of Excel 2007/2010, most of those requirement and features are becoming easy to accomplish, especially the requirement of having more than three conditions to be implemented in one cell. Instead of updating the Gantt Chart post, I decided to publish a new post, because there are major changes have been made in the new Gantt Chart. This Gantt Chart templates are still created without Macro, but require Microsoft Excel 2007/2010 to make all the functions working well.

Below are short guidance about features and how to use this template :
Holiday List Worksheet
A worksheet to put your country holiday and your company official holiday dates. There are 24 holiday dates can be entered.
Date: Enter your holiday dates
Holiday: Enter your holiday short description.

Gantt Chart Worksheet
There are 2 big areas in this worksheet. Those area are setting at the left side of the worksheet and Gantt Chart area. I put the setting on the left side of this worksheet to ease you seeing the effect of changing your setting in Gantt Chart area.

Setting Area
Date Information
Start Date: Enter your project start date here
End Date:
> End Date: Select this type, and enter your date, if your project has a fixed end date
> Week Period: Select this type, and enter your week period, if your project has a fixed week period
Working Days:
Do not tick anything if your workdays is from Monday to Friday, tick Saturday if your workdays is until Saturday and tick Saturday and Sunday if you work without holidays.
Today’s Date (Set Today’s Date marker to “Yes” to reveal the date marker inside Gantt Chart):
> Actual: Select this type, if you want to refer today’s date with actual today’s date
> User Defined: Select this type, and enter your specific date, if you want to refer today’s date with your date other than actual date

Date Marker
> Function: to mark today’s date on gantt chart. There will be a blue border color surrounding the area below corresponding date.
> How to activate: Type of select “Yes”
> Function: to mark holiday’s date on gantt chart. There will be red and orange solid color in your gantt chart to mark it as non working days (red color) and  country holidays (orange color)
> How to activate: Type of select “Yes”
Passing Days:
> Function: to view the progress and mark the number of days that has been passed from the beginning of any tasks until today’s date.  There will be a gray solid color revealed on corresponding dates.
> How to activate: Type of select “Yes”

There is no option in lite edition. The Gantt Chart will show a 52-week period with weekly scroll bar.

Gantt Chart Area
The top part of this are is a place to input you project initial information
Project Name: Enter your Project Name here
Description: Enter your Project Description here
Leader: Enter your Project Leader here

The second part below project description information is the part where you can see your project timeframe information that has been set in setting area. You can see your Start Date, End Date, Project Length and Displayed Week Period. There is a scroll bar at the bottom left side where you can scroll it left or right to move between week period.

Below project time frame part, there is a table to write your project plan. The first 5 columns in this chart (Level, Task, Assignment, Start Date and Finish Date) are the area to populate this chart.
Level: Type the level based on WBS or Non WBS level as you have set in Setting area
Tasks: Type or write a short description your employee tasks
Assignment: Select your employee name (To add new employee name, go to Employee name worksheet)
Start Date: Type your task start date
Finish Date: Type your task finish date
After finishing all of your information in the first 5 columns, you will see a task bar revealed. You can set the markers in Setting area to enable or disable date color markers
Working Days: This column will show you a real working day within any task period by calculating the number of working days based on your working days selection and  holidays.
Finish Date Realization: Enter your actual finish date if you want to see your task completion performance. The ahead of/behind schedule will show you the dates based on your information. It will give you “check” warning if your date is beyond task period
Remaining WD (Workdays): The formula inside this column will calculate the remaining days left to complete the task.

There are some notes that you have to put attention when you are running this template:
> The weekday in the chart is begin Monday
> The date below W# corresponds with the first date of the week
> Maximum rows/tasks available to be entered is 100 tasks
> A new row will be revealed automatically if you type a level
> A number of week should be different with window week due to window  week always start on Monday, and week could start in any day
> Do not insert new rows if you want to insert a new task. It will break the formula. Copy the tasks and paste it one row below. And you can type a new one.
> The date format is included with day name information to remind you about what day it is when you enter dates
> Some parts/worksheets are protected with password.

The ones that you download below are the lite version. I made the premium version which has been added many tools to ease your planning tasks, you can proceed HERE to read more information about the premium ones.

Project Gantt Chart Template – Week V3.12 Get it from CNET Download.com!

Below are other templates with different task bar arrangement.

  Project Gantt Chart Template - Day V3.13 (188.5 KiB, 25,799 hits)

And here is the Macintosh version, but it also runs well in Windows environment

  Project Gantt Chart Template for Mac - Team - Day V3.13 (174.3 KiB, 1,466 hits)

  Project Gantt Chart Template for Mac - Team - Week V3.13 (168.3 KiB, 1,491 hits)

(Visited 5,322 times, 1 visits today)


6 Responses to “Project Gantt Chart Template”

  1. respuzy on February 28th, 2012 10:06 am

    Great template, very beautifully designed, thumbs up

  2. Gantt Chart Template for Excel on May 12th, 2012 3:11 pm

    […] You can download the weekview model below. It needs Microsoft 2007/2010 to make all the function running well. And, you can read further instruction on how to use this template here. […]

  3. Wilber on May 22nd, 2012 12:14 pm

    I have heard that Gantt charts enable users (software developers, for example) to visualize and schedule tasks, activities and events in their own software applications in a flexible way. However, I am starting to become a little underwhelmed by the concept. I am discovering that it does not even do the basic task of sorting topics and sub topics in Gantt view unless I assign priorities. Any help would be appreciated!

  4. Anjan Roy on August 17th, 2012 5:09 pm

    Does this sheet allow to change and ammend all formula based on my customized needs?

    Can i insert more rows , columns etc ?

  5. Emad on October 20th, 2012 11:27 pm

    where is the password plz to unprotect the sheet plz

  6. iJones on July 22nd, 2013 5:11 pm

    also looking for the password???

Leave a Reply