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:
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:
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)
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.
Like magic, Sheets will use the same formula, but be sure to specify the correct cell above for the cells below it, completing the sequence.