Free Gantt Chart

  • Version
  • 3779 Downloads
  • 2.5 Mb File Size
  • February 13, 2012 Updated
  • 59 Number of comments
  • Yes Free
  • Rating

Gantt chart is a graphical representation of the duration of the tasks against the progression of time where it usually represent a project schedule and achievement. Some people are creating Gantt chart in Microsoft Excel to simplify their project, but with lack of ready-made duration calculation, the Gantt chart created in Excel usually only being used to just show time progress only. That is one reason I created my own Gantt chart.

I need a Gantt chart that can be adjusted to represent a project with 5, 6 or 7 days duration per week. And it is flexible enough to adjust the duration by entering end date information or just week duration. And I didn’t found that kind of Excel Gantt chart in internet. People just suggested to use Microsoft Office Project for that purposes.

Gantt Chart

Basic Gantt Chart Template

I finished this Gantt chart a month ago. You can use this template if you just need a basic task bar chart to map your project plan.

It is a single worksheet template with guidance to use it are as follows :

  1. Fill your project name in project name row
  2. Fill your project description in project description row
  3. Fill your project start date in start date row
  4. Select your project period reference by ticking end date or number of weeks row. And fill the needed information in the row where you tick your reference. The blue cell is shown up to remind you that this cell doesn’t need to be filled because it contain formula that will calculate the projected end date or number of weeks based on your input.
  5. Select your working days. There are three options available there, Monday – Friday (5 days), Monday – Saturday (6 days) and Monday – Sunday (7 days). This information needed to calculate your project week duration (WD), days completed (DC) and days remain (DR). And it will be used also to give you the correct holidays mark inside the chart.
  6. Activate/Deactivate today’s marker by selecting yes or no in the today’s marker cell. If you activate today’s marker, you will see a blue color in today’s date cell inside the chart.
  7. Activate/Deactivate holiday’s marker by selecting yes or no in the holiday’s marker cell. This is not a national holiday marker, this is just holiday marker based on your working days preference.

After finishing step 1 to 7, basically you already setup your Gantt chart. The next step is filled the chart with your project detail. In the chart, just fill Level, Task, PIC, Start Date and Finish Date column. The remaining column will be filled by itself. I put sample project in the template to ease you understand my Gantt chart. And this Gantt chart is full of conditional formatting format to adjust the layout automatically. Feel free to do some experiment with this template to see the result based on your input. There are three type of Gantt chart I created for you to choose.

Gantt Chart Weekly

Gantt Chart with Day Column

You will see that there is a date on top of each column inside the Gantt chart.

Gantt Chart with Week Column

This Gantt chart hides the date information, so the chart will be shorter.

Excel 207 Gantt Chart

Gantt Chart with More Custom Features

I have created a new Gantt Chart template that require Excel 2007 for Windows and Excel 2008 for Mac. And following the update of my Gantt Chart template for excel 2007/2010, as you can download below, I have created the premium edition of this template.

Excelindo Gantt Chart Template - Weekview

How To Use This Gantt Chart

Below are brief description 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

  • Today:
    • 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”
  • Holiday:
    • 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”

Display
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.

Features

Ξ Flexible End Date Option

You can choose between the date of finishing their project based on fixed date or fixed week

Ξ Flexible Work Days

Some projects required different holidays instead of normal Saturday or Sunday. Using this flexible work days feature, users can select their own work days within one week.

Ξ Custom holiday and leave dates

These features will allow users to add their company holidays and their personal leaves into the chart and being included in total workday calculation which will make the plan more precise.

Ξ Smart workdays calculation

Based on flexible workdays and custom holidays, the formula inside Workday column will calculate precisely users workdays.

Ξ Chart Marker

These are features that will colorize your chart based on your personal setting. There are five date markers

  • Today: To mark today’s date on gantt chart (blue border color surrounding the area below corresponding date).
  • Holiday: To mark holiday’s date on gantt chart (Red color for non working dates within a week, orange color for national/company holidays).
  • Leave: To mark employee leave’s date on gantt chart (Dark violet solid color on corresponding leave dates).
  • Start/End: To mark the beginning and the end of one task period (Black solid color in the beginning or end of any task period).
  • Passing Days: To view the progress and mark the number of days that has been passed from the beginning of any tasks until today’s date (Blue solid color on corresponding dates).

Ξ Flexible Project Display Period with scrolling function

You can select project plan frame preference to be displayed and printed in Excel, and you can visually scroll the plan weekly or daily.

Ξ Task and Remaining Days Alert

With this feature, any project managers can be reminded on how many parallel tasks in the same day that can be carry on by his/her teams and on how many days left to complete their projects.

Template Contents

Here is a full list of files includes with this template:

  • Gantt Chart Premium With Sample Team Project Day View
  • Gantt Chart Premium With Sample Team Project Week View
  • Gantt Chart Lite Personal Project Day View Mac
  • Gantt Chart Lite Personal Project Day View
  • Gantt Chart Lite Personal Project Week View Mac
  • Gantt Chart Lite Personal Project Week View
  • Gantt Chart Lite Team_Project Day View Mac
  • Gantt Chart Lite Team_Project Day View
  • Gantt Chart Lite Team_Project Week View Mac
  • Gantt Chart Lite Team_Project Week View
  • Gantt Chart Daily Weekly
  • Gantt Chart Premium Personal Project Day View Mac V3.46.xlsx
  • Gantt Chart Premium Personal Project Day View
  • Gantt Chart Premium Personal Project Week View Mac
  • Gantt Chart Premium Personal Project Week View
  • Gantt Chart Premium Team Project Day View Mac
  • Gantt Chart Premium Team Project Day View
  • Gantt Chart Premium Team Project Week View Mac
  • Gantt Chart Premium Team Project Week View
  • Gantt Chart Premium With Sample Personal Project Day View
  • Gantt Chart Premium With Sample Personal Project Week View
  • Gantt Chart V1.1
  • Project Gantt Chart Template Week View

How useful was this template?

Click on a star to rate it!

Average rating / 5. Vote count:

As you found this template useful...

Follow us on social media!

We are sorry 🙁

Help us improve!

Invoice Generator

11.5 Mb / 4259 downloads
Retail Business Accounting Templates

2.8 Mb / 322 downloads
Service Business Accounting Templates

111 KB / 3502 downloads
Cost of Goods Sold Calculator

10.7 Mb / 15597 downloads
Sales Task List and Pipeline Manager

10.3 Mb / 2705 downloads
Employee Time Sheet Manager Excel Template

31.3 Mb / 32989 downloads
View Comments