Gantt Excel – Gantt Chart Excel Template

Create Professional-looking Gantt Charts in Excel

Gantt Chart Excel is completely automated and it is super easy to use.
If you use Microsoft Excel, you can create a Gantt Chart with almost no learning curve by downloading our Gantt Chart Template.
Microsoft Excel is instantly familiar, so everyone on your team “gets it” and hits the ground running.

Download Now

 
4.9 out of 5 rating for Gantt Excel

Gantt Chart Excel Ribbongantt chart excel

Gantt Excel gives you the ability to see every step of your project from beginning to end.

Download NowCreate Gantt Charts in Microsoft Excel 2007, 2010, 2013 & 2016 on Windows & Excel 2016 on macOS.

“This is the best alternative to Microsoft Project. This is an Excel Template on Steroids, very Powerful yet very Simple to use.
Best Project Management tool ever, Period.” – Tony Smith (Project Manager)” 

GANTT EXCEL FEATURES

Gantt Excel Ribbon

Using this Gantt Chart Template is very straightforward. We have customized the Excel ribbon to include a Gantt Tab with buttons to add Gantt charts, Tasks, Milestones etc.

Gantt Excel Template Ribbon

blue line

Task Dependencies

You can create cascading dependencies in the Gantt Chart based on time so that you see how time changes will affect other parts of the process & the final deliverable.

Task and Milestone Dependencies

blue line

Project Dashboard

A dashboard is the best way to easily communicate key project details.
With a click of a button, the project dashboard is instantly created based on the Gantt chart.
Gantt Chart Excel Dashboard

blue line

Costs Module – Account for Project Costs

Gantt Excel doubles up as a budget and expenses template. Keep track of costs and expenditures for projects and tasks.

Gantt Chart Excel Costs

blue line

Milestones

Ability to add Milestones in the Gantt Chart.

Gantt Chart Excel Milestones

Task Progress Indicators

Show Task Progress with percent complete in the grid and in the Gantt Chart Timeline.

Gantt Chart Excel Task Percent Status

Configure Work Days

Automatically account for selected workdays.

Set Workdays

Instantly switch between Views

Daily, Weekly, Monthly, Quarterly, Half-Yearly and Yearly View.

Gantt Chart Views

Parent & Child Task Relationship

Ability to Set Parent & Child Tasks.

Gantt Chart Excel Parent Child Task Relationship

Resource Cost Module

Ability to select resources for tasks and assign costs.

Gantt Chart Excel Costs

Holiday Calendar

Set the holiday calendar to exclude holidays in the Gantt chart.

Gantt Chart Excel Holiday Calendar

Create Elegant Project Timelines

Show the right amount of detail

Show Text in Gantt Bars

blue line

Intuitive Forms to Add Tasks & Milestones in the Gantt Chart

Gantt Chart Task Form

blue line

Select Dates Using the Date Picker

Date Picker

Show Baseline, Estimated and Actual Timeline Bars

Gantt Baseline Actual Bars

Highlight Overdue Tasks

Overdue tasks show in red color or any color of your choosing.
Gantt Overdue Tasks

Customize the Gantt Timeline Bars with your Favorite Colors

Create a project timeline to impress!
Gantt Chart Colors

blue line

Gantt Chart Excel – Complete Feature List

  • Ability to create as many Gantt charts as you want
  • Add as many tasks and milestones to a gantt chart
  • Add or edit tasks using intuitive forms
  • Duplicate tasks easily
  • Set parent and child task relationships
  • Create task and milestone dependencies
  • Fine-tune dependent task dates using lag
  • Select dates using a date picker
  • Track estimated, baseline and actual dates
  • Auto-calculate duration based on start and finish dates
  • Auto-calculate end date based on start date and duration
  • Account for holidays
  • Set up work week calendar days
  • Parent tasks auto-calculate dates, percent complete and costs
  • Set project estimated and baseline budget
  • Generate project dashboard with the click of a button
  • Track estimated, baseline and actual costs
  • Set Currency per project

  • Track task percent complete
  • Highlight overdue tasks in the timeline
  • Auto-calculate percent complete or enter it manually
  • Set simple or weighted percentage for parent tasks
  • Add resources to tasks
  • Set resource per day cost
  • Add task notes
  • Insert up to 10 custom columns
  • Show or hide system and custom columns
  • Gantt chart timeline automatically updates based on any change
  • Daily, weekly, monthly, quarterly, half-yearly and yearly views
  • Show estimated, baseline and actual timeline bars
  • Task percentage complete bar overlays the estimated bar
  • Scroll timeline to start, current or end of the project
  • Customize timeline gantt bars and milestone colors
  • Show or hide dependency connectors
  • Today indicator available in the Gantt chart
  • Show text on Gantt Bars

Reviews 5 Star

Reviews From Around The Globe

People everywhere love Gantt Excel and we thrive off their feedback.
All reviews have been collected and verified on

Gantt Chart Excel Reviews

“Great product, fantastic customer service. Highly recommend this tool for all types of project managers!”

Matt
CA, United States

“The chart is amazing and easy to use. This will be a resource I use for years to come! Excellent customer service. Had questions about how to use and they provided solutions almost immediate.”

Jay
ON, Canada

“Excellent service and customer support. The product is very intuitive and easy to use. ”

Hilary Reid
Scotland, United Kingdom

“Simple but effective, easy to use but provides all you need to manage a project. Excellent customer support!!”

ON, Canada

“This is an excellent product, very easy to use, easy to buy and great value for money in saved time. You do not need to be an excel expert to use it, the automation of entry does it all for you. I recently showed the website to clients to help with their project planning. They were very pleased and will be adopting it through the company. I needed to contact support to help with a query; their response was quick, efficient and very helpful. Excellent service and great product, I thoroughly recommend Gantt Excel.”

T. Dulieu
Essex, United Kingdom

“This saved a lot of time for me. Having to update a schedule in a project, then copy to excel was very time consuming and didn’t allow real time changes in my meetings. Having this done in excel allows me to customize my schedule just like project while adding additional tabs for other information. I’ve received nothing but positive feedback from my pears. Well worth the investment and has paid for itself. ”

Jerrod
AL, United States

“I am a new at using Gantt software. So I was very impressed with the speed and thoroughness of their customer service when I had basic questions on how to use the software. They were very thorough in their responses, which made it very easy for me to use. I have purchased similar software before but found them difficult to use and there was no customer service support at all. This is a great product, at a tremendous price, with service you can count on. I have recommended this product to numerous people in my field and will continue to do so.”

Gary L
NV, United States

“Gantt Excel saved the day – And blew me away!
I needed a simple and intuitive Excel Gantt chart to quickly relay project status to business stakeholders comfortable with Excel. After trying a couple, I found GanttExcel and it exceeded expectations! I’ve been in systems for 20 years and I’m amazed at the design and features of the product – all built in Excel! And the price? Unbelievable! Many thanks – you’ve made another fan!”Chuck S
CT, United States
“Gantt Excel is the best Gantt chart excel template out there. It is very intuitive, fast and offers great features…. My clients find the Gantt Chart easy to read and understandable. Project Managers in my team love this tool. ”

Samantha Davis
United Kingdom

“Great product, allows you to customize your project to a good degree. Impressing my Boss!”

Jer
IN, United States

“Just what I was looking for, and such a helpful support team. This gives me the ability to produce professional gantt charts, at a fraction of the cost of other solutions. Well done to the team at Gantt Excel. ”

Gary Forrest
NY, United States

“We are a medium sized company, and have been using GanttExcel for almost a year now. The software is easy to use, as it is fully integrated in Excel. The software offers more than enough features and flexibility for us, to produce good quality project schedules. The Project Dashboard view is very useful for progress reporting.
Customer service is lightning fast.
Overall we are very pleased with the GanttExcel software.
Amazing it can be offered at this price level.”Albert
Sliedrecht , The Netherlands

Everything you wanted to know about Gantt Charts…

What is a Gantt Chart?

Why use Gantt Charts?

How to Create a Gantt Chart in Excel?

How to Create a Gantt Chart in Excel 2016 for MacOS?

What is a Milestone Chart?

Plan Construction Projects using Gantt Charts

Understanding Task Dependencies

 

How to Create a Gantt Chart in Excel

Step-by-Step Tutorial for Creating a Gantt Chart in Excel

We all love Microsoft Excel and we use it almost every day for everything – from a simple calculator to tracking massive projects. There’s just one thing that Excel is not good at and that is creating Gantt charts. For this reason, we created Gantt Excel, an automated excel template that allows you to create professional-looking Gantt Charts in Excel.

Before we begin, what is a Gantt Chart?

Gantt chart is a type of bar chart, adapted by Karol Adamiecki in 1896 and independently by Henry Gantt in the 1910s, that illustrates a project schedule. It is a graphical illustration of the duration of tasks against the progression of time. Gantt charts are useful tools for planning and scheduling projects.

Here are the steps to create Gantt Charts in Excel

  1. Download our Free Gantt Chart Template

    Gantt Chart Excel
    Save
    the excel template to your Desktop or your My Documents folder. Note, our template works in Excel 2007, Excel 2010, Excel 2013 and Excel 2106 on Windows and Excel 2016 on the Mac.

  2. Open the Gantt Chart Template

    Click on the Enable Macros & Enable Editing button. Note that there is no installation. It’s just a simple excel template and it opens just like any other excel file.

    The Gantt tab in the excel ribbon will instantly load.Gantt Excel Ribbon

  3. Create a New Gantt Chart

    Click on the Add New Gantt Chart button to bring up the Project Details window.

    Enter the Project Name, Worksheet Name, Project Lead and the Estimated/ Baseline Budget for the Project.
    Add New Gantt Chart

    Click the Ok button when done. A new Gantt Chart is automatically created for you. You don’t have to bother about setting up complicated conditional formatting or creating any graphs.
    Everything is automated and that’s the best part.Default Timeline

  4. Add Tasks

    Gantt charts don’t give useful information unless they include all of the tasks/ milestones needed for a project to be completed.
    So, to start, list all of the activities as tasks. There are three ways to add tasks in Gantt Excel

    Method 1: Type directly into the excel grid. If you type a task where it says “Type here to add a new task“, it will automatically create a new task with default start and end dates and the timeline will instantly update.

    Method 2: Click the Add Task button on the Gantt tab

    The task details form will open up where you can enter all the task details including task resource, estimated, baseline, actual – start and end dates. You can also keep track of costs including estimated, baseline and actual costs, therefore making it an excellent budget and costs planner.
    Task notes can also be captured to include a short description of your task to clarify its purpose or scope and to provide additional info to everyone involved.Gantt Chart Task Form
    Click the Ok button when you are done. The newly added task will show up in the excel grid with all the details.

    Go ahead and add a few tasks like in the example below and set the start and finish dates.
    tasks in gantt chart excel

    Importantly, note that the Work Break Structure (WBS) is automatically calculated and set for you.

  5. Set Parent and Child Tasks

    If a task is relatively large and requires several users with different skills to manage, break the task into subtasks and create parent-child relationships.

    To set parent-child relationships, select a task that you want to convert to a child task and click on the Make Child button.
    make-child-task
    To create a parent task from a child task click on the Make Parent button.
    make-parent-task
    As a result, when you group child tasks together under a parent, values such as dates, costs etc. aggregate and roll up to the parent task.

    This is how the tasks look when I set a few tasks as child tasks.

  6. Set Task Dependencies

    Setting dependencies between tasks is the most powerful feature of Gantt Excel. The in-built auto-scheduling automation of the template is able to update the dates based on changes made to its dependent tasks.
    To Add task dependencies doubleclick task 1.2. This will open up the Edit Task Details window.
    Adding Task Dependencies

    In this example, we are setting 1.1.1 as the predecessor task with a Finish to Start dependency. Click Add and then Ok to confirm.
    This basically means that this task can start only when task 1.1.1 finishes. Also, notice how the taskbar in the timeline moves automatically after the end date of the predecessor task.

    Click here to read more about task and milestone dependencies.

  7. Add Milestones

    Milestones help your team stay on track and to more accurately determine whether or not your project is on schedule.
    Use a key deadline as a milestone to reflect when a section of tasks or key task is completed.

    To Add a Milestone click on the Add Milestone button in the Gantt tab.
    Add Milestone

    This will bring up the Add Milestone details window. In this case, I’m setting this milestone to be dependent on task 1.2 with a Finish to Start dependency with a lag of 1 day. Click Ok when done.
    Milestone Details

    To illustrate, see the example below. The milestone and a diamond-shaped symbol appear in the timeline.

Gantt Excel Settings

Equally important, is to set up the Gantt chart correctly. Let’s look at all the settings screens and go through them one by one.
Click on the Settings icon in Gantt tab.

Display Settings
By default, the Display tab opens up first. Here you can set all the different timeline bar and milestone colors.
You can also choose to show additional timeline bars for baseline, actual dates and the overdue bar for all overdue tasks.

If you want to see more of the timeline then you can increase the “No of weeks to display in timeline” setting.

Lastly, one of the most sought out features is to show Text within the Gantt Bars. You can check the Enable Text display option and select any text from any column to show within the Gantt bars.

This is how it looks when the Show Text in Gantt Bars is enabled. We think it is one of the finest features of Gantt Excel.
Show Text in Gantt bars
Calendar Settings
The calendar tab is where you can select Workdays. You can also select the way the week numbers are calculated by either using Excel’s week calculation or use the ISO week calculation.

Other Settings
Switch over to the Others tab to set Currency symbol and Date format.
Additionally, you can define how Percentage complete is calculated for the tasks. You can use the Manual or Automatic mode for entry and use simple or weighted calculation for the Parent task roll-up calculation.

Columns Settings
Finally, we have the columns tab where you can hide or unhide existing columns. In like manner, you can also insert your own custom columns or delete them if required.

Columns Settings

Gantt Chart Excel – The Smart Way to Plan

In Conclusion, the beauty of Gantt Excel is we have six calendar views to choose from namely Daily, Weekly, Monthly, Quarterly, Half-Yearly and Yearly View.

From here you can easily customize the Gantt chart by changing timeline colors, and adding various details like percent complete, costs etc…  As shown below, with some tweaks you can create a timeline that’s sure to impress.

Gantt Chart Excel Template – Download Now

It is the best free Gantt chart software out there.