- Free Gantt Chart Google Sheets Template
- How to Make a Gantt Chart in Google Sheets?
- Gantt Chart with Dependencies in Google Sheets
- How to Automate Your Data on Top of Google Sheets?
The Gantt chart is a very useful project management tool. It allows you to keep track of tasks and shows progress in a visually intuitive way. Initially, creating a Gantt chart can be intimidating, as you’re not yet familiar with the components.
In this post, you will learn how to create and customize Gantt charts in Google Sheets. You have step-by-step instructions on how to create a simple Gantt chart, how to customize it, and how to add dependencies to your Gantt chart. Finally, you can download a ready-to-use Gantt chart template so that you can get started right away.
You can download this free Gantt chart template to skip setting up the basic components. You can then easily customize the template for your own specific needs and add dependencies, as shown below.
How to Make a Gantt Chart in Google Sheets?
Gantt charts can be intimidating if you don’t know the components or what you can achieve with them. However, once you understand these components and how they work together, you’ll be able to create your own. Follow the steps below to create a Gantt chart in Google Sheets.
Set Up in Google Sheets
Open Google Sheets and go to the sheet where you want your Gantt chart. The first step is to build a table to keep track of the start and end dates for each task, which we will use to work out the start day and the duration of each task.
- 1. First, add the headers you need for the table: task, start date, end date, start day, and duration.
- 2. Select the columns with the start and end dates. Go to Format > Number > Date.
Add Project Data
Now that you’ve set up the table, you need to add your project data. You’ll need to add each task to the table, starting with the earliest task.
- 1. In the first column, add the relevant task names.
- 2. In the second column, add the start date for each task.
- 3. In the third column, add the end date for each task.
Calculate Start Day and Duration
Using the data added in the previous step, you can work out the start day and duration of each task. Fortunately, Google Sheets has a very useful function to do this for you: DATEDIF. For the start day, we need the difference between each task’s start date and the earliest start date, which is the start date for task 1.
- 1. To calculate the start day, type in the DATEDIF function.
- 2. The first parameter is the start date for the project, which is the same as the start date for the first task. Use absolute referencing for the start date so you can copy the formula down.
- 3. For the end date, select the first task’s start date, but with relative referencing - no dollar symbols - so that you can copy the formula down to the other tasks.
- 4. The last parameter indicates the unit, so you need to use “D” to get the result in days.
- 5. You can use the suggested autofill or simply grab the cell’s fill handle and drag it down to the last task.
- 6. You can also use the DATEDIF function to find the tasks’ duration. However, make sure you don’t use absolute referencing for any of the parameters.
- 7. As before, accept the selected autofill or grab the fill handle to copy down to the last task.
A free Google Sheets Gantt Chart Template to organize your project tasks, track progress and timelines, and identify critical paths or deadlines.USE TEMPLATE
Now that you have all the required data, it's time to add a stacked bar chart.
- 1. Select the columns with the task, the start day, and the duration.
- 2. Go to Insert > Chart.
- 3. In the chart editor, select the stacked bar chart type.
Convert to Gantt Chart
A few modifications will convert your bar chart into a Gantt chart.
- 1. In the ‘Customize’ tab in the chart editor, click ‘Chart & axis titles’ to type in your preferred title.
- 2. Go to ‘Series’ and change the color of the first series, start day.
- 3. Next, click ‘Legend’ and select ‘None’ as shown below.
- 4. Select the vertical axis title and delete the text to remove it.
- 5. Your chart now looks like a traditional Gantt chart. However, you can modify it further to match your style guide
A free Google Sheets plug-and-play template to keep a comprehensive overview of your project’s progress across multiple workstreams.USE TEMPLATE
Gantt Chart with Dependencies in Google Sheets
There are four different types of dependencies you can add to your Gantt chart. Follow the instructions below to add different types of dependencies to your Gantt chart.
This kind of dependency refers to tasks that need to be finished for another task to start. In this example, the third task cannot begin until the first is completed.
- 1. In the cell corresponding to the third task’s start date, type in the MAX function and select the first task’s end date. Add 1 to ensure the task starts the next day.
- 2. The third task’s start date now depends on the first task’s end date.
This type of dependency refers to tasks that must be started before another task can be finished. In this example, the fifth task cannot be completed until the sixth has started.
In this case, you need to use the MIN function for the fifth task’s end date, then add 1.
This type of dependency occurs when a task must start before another task can start. In this example, the fifth task must start before the sixth can begin.
The final type of dependency requires that one task finishes before the other can finish. In this case, the eighth task must be completed before the ninth can finish.
That’s it. You can add as many dependencies as you need.
How to Automate Your Data on Top of Google Sheets?
Layer is an add-on that equips you with the tools to increase efficiency and data quality in your processes on top of Google Sheets. Share parts of your Google Sheets, monitor, review and approve changes, and sync data from different sources – all within seconds. See how it works.
Using Layer, you can:
- Share & Collaborate: Automate your data collection and validation through user controls.
- Automate & Schedule: Schedule recurring data collection and distribution tasks.
- Integrate & Sync: Connect to your tech stack and sync all your data in one place.
- Visualize & Report: Generate and share reports with real-time data and actionable decisions.
Limited Time Offer: Install the Layer Google Sheets Add-On today and Get Free Access to all the paid features, so you can start managing, automating, and scaling your processes on top of Google Sheets!
As you have seen, creating a Gantt chart in Google Sheets is not that scary. If you follow the steps, it's a straightforward process. However, you can always use the template provided to skip the initial setup. There will be dependent or concurrent tasks in almost any project, and the Gantt chart allows you to reflect that. You now know how to create a simple Gantt chart in Google Sheets, how to customize it to your needs and preferences, and how to add dependencies. Additionally, you have a Gantt chart template available, so you can skip the setup and start adding your project data.