How to Make a Gantt Graph on Google Sheets – Google Sheets are able to make specific Gantt diagrams in your spreadsheet.
Eventhough you did not having an experience about their format. Google can help you doing it easily.
Create Your Schedule Project
Before entering into creating a Gantt chart, you must first determine your project assignments and their dates in a simple table.
1. Launch Google Sheets and open a blank spreadsheet.
2. Choose a suitable location near the top of your spreadsheet, and type the names of the following headings in the same row, each in its own column, as shown in the screenshot above:
Name of assignment:
To make it easier for yourself later in the tutorial, you might want to utilize the same location that we have used in our example (A1, B1, C1).
3. Enter each of your project assignments together with the appropriate date in the appropriate column, using as many rows as needed. They must be listed in the order of events (top to bottom = first to last) and the date format must be as follows: MM / DD / YYYY.
Other formatting aspects of your table (border, shadow, alignment, font style, etc.) Are pure arbitrary in this case because the main purpose is to enter data that will be used by the Gantt chart later. It’s entirely up to you whether you want to make further modifications so that the table is more visually appealing. However, if you do, it’s important that the data itself stays in the correct row and column.
Read More: How to Make a Graph on Google Sheets
Create a Calculation Table
Simply entering a start and end date is not enough to create a Gantt chart because its layout is very dependent on the actual amount of time that passes between these two important milestones.
To handle this requirement, you need to create another table that calculates this duration:
1. Scroll down a few rows from the initial table that you created above.
2. Type the names of the following titles in the same row, each in its own column:
Name of assignment:
3. Copy the task list from your first table into the Task Name column, ensuring that they are listed in the same order.
4. Type the following formula into the Start Day column for your first assignment, replace A with the column letters containing the Start Date in your first table, and 2 with the row number:
= int (A2) -int ($ A $ 2)
5. Press Enter when finished. The cell will now display 0.
6. Selecting and copy the cell where you just entered this formula by using either keyboard shortcuts or Edit -> Copy from the Google Sheets menu.
7. Select all the remaining cells in the Start Day column and paste, through Edit> Paste.
If copied correctly, the Initial Day value for each assignment must reflect the number of days from the start of the project to be started. You can validate that the Beginning Day formula in each row is correct by selecting the cell and ensuring that it is identical to the formula typed in Step 4, with one important exception: the first value (int (xx)) matches the cell that matches the location in the first table You.
8. Next is the Total Duration column, which needs to be filled with other formulas that are a little more complicated than the previous one. Type the following into the Total Duration column for your first assignment, replacing the cell location reference with the one related to the first table in your actual spreadsheet (similar to what we did in Step 4):
= (int (B2) -int ($ A $ 2)) – (int (A2) -int ($ A $ 2))
Note: If you have problems determining the location of cells that fit your specific spreadsheet, this formula key will help: (end date of current task – project start date) – (current task start date – project start date).
9. Press the Enter key when finished.
10. Selecting and copy the cell where you entered this formula.
11. After the formula is copied to the clipboard, select it and paste it into all the remaining cells in the Total Duration column. If copied correctly, the Total Duration value for each assignment must reflect the number of days between each start and end date.
Generate a Gantt Chart
Now your assignment is ready along with the date and duration. It is time to make a Gantt chart:
1. Select each cell in the calculation table, including the header.
2. Go to Insert> Chart.
3. A new chart will appear, and titled Start Day, and then Total Duration. Selecting and drag to position it below or next to the table; but not above it.
4. Select a chart once, and from the top right menu, choose Edit chart.
5. Under Chart type, scroll down to the Bar section and select Stacked bar charts (middle option).
6. From the Customization tab in the chart editor, select Series so that it opens and displays the available settings.
7. On the Apply to all series menu, select Start Today.
7. Select the Color option and select None.
Your Gantt Chart is now created, and you can see each Starting Day Number and Total Duration by hovering over each area in the graph. You can also make other modifications you want through the chart editor, including date, task name, title, color scheme, and more.