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.

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.

Voila!  The formula calculates the remaining cells in that column.

Now, in order to calculate the duration, you need to determine how long each task will take. This calculation is a bit more complex and finds the difference between a few more variables. The formula will resemble the format (-)-(-) and will look like this:

  = ( INT ( C4 ) - INT ( $ B $ 4 ) ) - ( INT ( B4 ) - INT ( $ B $ 4 ) ) 

To calculate the number of days each task must pass, enter the following formula and press the Enter key.

As before, you must convert each date format to an integer if you refer to it in a formula. Also, variables that will remain the same across all cells are referenced using dollar sign characters.

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

As before, click on the previous cell and then double-click on the little blue square to apply the formula to the remaining cells in the column.

Similarly, Sheets fills in the remaining cells for you.

As with magic, the cells are filled with the duration of the days it will take to complete each task.

Select the entire table.

Select the entire second table.

Then click Insert > Chart.

Click Insert > Chart.» width=»557″ height=»477″ src=»https://gadgetshelp.com/wp-content/uploads/images/htg/content/uploads/2019/11/x2019-11-12_15h29_01-1.png.pagespeed.gp+jp+jw+pj+ws+js+ rj+rp+rw+ri+cp+md.ic.FBYVGzSWWr.png»></p>
<p><noscript><img class=

Finally, click on any of the light red stripes, click on the color selector, and then select «None» at the top of the color selector.

Click on any of the light red sections of the chart, click on the color picker in the chart editor panel, and then select

After that, go to the Customize tab in the Chart Editor panel, click on Chart and Axis Titles, and give the chart a name.

Next, give the Gantt chart a title by clicking on the Customize tab, Chart and Axis Titles, and then enter it in the appropriate Title Text field.

Here you are. After that, you have created a fully functional Gann chart that updates in real time.

And there you have it.  Nicely done Gantt chart.

Похожие записи