How to Create a Gantt Chart in Google Sheets

A Gantt chart is a commonly used type of bar chart that illustrates the breakdown of a project schedule into tasks or events displayed over time. Google Sheets has a handy feature to help you create a Gantt chart for your project.

Launch Google Sheets and open a new spreadsheet.

First, create a small table and insert some headers into the cells to get started. You will need one for tasks, start date and end date. Fill in each cell with project details. It should look like this:

Create a table with three headings: Tasks, Start Date, and End Date. Fill it in with your project data.

Then, make a similar table on the side or below the previous table, which will be used to calculate the graphs in each part of the Gantt chart. The table will have three headings for generating a Gantt chart: tasks, start day, and duration (in days) of the task. It should look like this:

Create another table below the previous one with these three headings: Tasks, Start on Day, and Duration.

After you get the titles, you need to calculate the start day and duration. The title «Tasks» will be the same as above. You can just copy the cells at the bottom, link to them directly, or overwrite them if you like.

To calculate Start on Day, you need to find the difference between the start date of each task and the start date of the first task. To do this, you first need to convert each date to an integer and then subtract it from the start date of the first task 🙁 - ). It will look like this:

  = INT (В4) -INT ($ B $ 4)

Enter the following formula and press Enter.

In the formula will always be an absolute value. Google Sheets uses the dollar sign ($) to «lock» a row or column—or, in our case, both—when referring to a value.

So when we copy the same formula for subsequent cells — which we do in the next step — using a dollar sign like this always checks that it always refers to that value in B4, which is the start of the first task.

Once you’ve pressed the Enter key, click the cell again and then double-click the little blue square.

Click on the cell where you previously entered the formula, and then double-click on the little blue square to apply the same formula to subsequent cells in the column.