The Best Free Gantt Chart Excel Template

Download the free Excel gantt template, on us. Its completely free, we dont even ask for your email

There are a lot of gantt chart excel templates out there…How do you know which one is the best? I’m glad you asked! We’ve done the heavy lifting for you and created a brand new gantt chart excel template that you can download now for free! The gantt chart is compatible with Excel versions 2000 and up on Mac and Windows.

Using our pre-made Excel gantt chart schedule template can save you tons of time by organizing your project plan and tackling the tedious planning work for you! All you need to do is plug in your tasks and the dates and you will have a presentation quality Excel gantt chart. Want to learn how to get started? First, download the template then read on or watch the video above.

Download TeamGantt's Free Excel Template
INSTANT FREE DOWNLOAD

How to use your free excel gantt chart template

We’ve made this gantt chart template as easy, powerful, and painless to use as possible for managing your projects. This gantt chart can be used for anything from construction projects to website redesigns and beyond.

The template is already set up and ready for you to start plugging in your project’s tasks. Below, are details on how to set up each task, align task dependencies, set task dates, and automate task durations and timeframes.

That should be cover the basics for enough for most projects, but if you need to add more it’s really easy to customize the template. To jump ahead to the “Customizing Your Template” section of this guide, click here.

1

How to set up new tasks

First, rename existing tasks to fit your own project. Tasks are numbered by default. Just click on any cell in the column "Task Name" and rename it.
2

Update your task start and end dates.

Next, update your task start and end dates within the gantt excel schedule template. These cells are pre-formatted as date cells in the standard US format, however; you can change that format to whatever you prefer for your preference or location.
2

Update your task start and end dates.

Next, update your task start and end dates within the gantt excel schedule template. These cells are pre-formatted as date cells in the standard US format, however; you can change that format to whatever you prefer for your preference or location.
3

Task durations are automatically calculated

The duration column for each task is automatically calculated within the gantt chart template by subtracting the start date from the end date. As you enter your start and end dates the duration column will populate on it’s own. Duration is in days by default.

Customizing your excel gantt chart template

How to add a title to your gantt chart

You know what your project is all about, make sure everyone else does, too.

1. To add a title to your chart, highlight the chart and then click on ‘Chart Design’ at the top of the Excel Menu.

2. Then click ‘Add Chart Element’ > ‘Chart Title’ > Above Chart.

3. Enter the name you’d like to give your chart. If you want to format the text, you can do it from the home menu the same way you would format any other text in a worksheet

Changing taskbar colors within your gantt chart

Let’s make it pretty

1. Click on a single bar twice. Don’t double click it, just click it once to highlight all of the bars in the gantt chart and then click it again to highlight just the task bar that you’d like to change. Then, right click that bar and select “format data point.”

2. Select the Paint Bucket and then choose a color for the taskbar. Repeat for any other taskbar you want to change.

Adding additional rows within your gantt chart

Projects come in all shapes and sizes. Here is how to expand the gantt chart template to fit your needs.

If your project needs more than 25 rows in the template, it’s simple and easy to add additional rows:

1. Highlight the last filled row in the chart and scroll up to the top of the template in the [side] and click Insert < rows.

2. Then, a row will be added that has the appropriate formula for calculating the task duration and the same formatting as the other taskbars.

Printing Your Gantt Chart

I mean, some people still use paper, right?

1. To print just the gantt chart, we first need to set a print area. Click in a cell behind one of the corners of the gantt chart and drag out a selection that covers the entire chart. Then go up to File > Print Area > Set Print Area.

2. Now that that print area is set, go back to File > Print. Depending on the size of your chart, you’ll probably need to either adjust the scale of the chart to fit on a single page, or have the chart span multiple pages and then manually tape them together to make one big print out.

3. To print the entire workbook, including the gantt chart, just go up to File > Print. Again, depending on the size of your chart, you’ll probably need to either adjust the scale of the chart to fit on a single page, or have the chart span multiple pages and then manually tape them together to make one big print out.

Looking for an intuitive free gantt chart solution?
Read on...

A better, faster and more collaborative way to build a gantt chart with TeamGantt

Creating simple, beautiful, and super easy to manage and update gantt charts is exactly what TeamGantt was designed from the ground up to do.

Forget having to keep track of multiple Excel files for each project and wasted time making sure all your charts are presentation ready. TeamGantt makes it easy, and dare we say, FUN to create and manage your projects with shareable gantt charts.

1. Go to teamgantt.com/signup to sign up for your free account to get started.

2. Once you log in, go to My Projects in the sidebar and click on ‘+ New Project’, then ‘Create New Project’.

3. Give your project a name and choose a template to get you started, if you want. Choose the days of the week to be shown in your project and select ‘Save New Project

4. Your project is created and you’re ready to start adding your tasks!

5. Once you’ve added your tasks to the task list, just click and drag each task out for as long as it should take.

6. If you have tasks that can’t begin until the task before it is complete, you can add a dependency to make sure those tasks are always done in the proper order.

7. To add a dependency, just click the gray dot to the right of the first task and drag the dependency to the dependent task.

You’re all done! Congratulations on creating your first project in TeamGantt!