How to Make Gantt Chart in Google Sheets
Step 1: Open Browser
Go to your preferred browser and visit the Google page
Step 2: Go on Google Sheets
After logging into Google, you will see nine dots at the top right corner. Click on it, and you will see the Google Sheets option while scrolling. Tap on it.
Step 3: Click on the Blank sheet
When entering Google Sheets, see the first option: Blank Sheet. Click on it.
Step 4: Input data into the Sheet
Enter your data in any cell of your choice.
For the first table, label the columns as follows:
- Column A: Task Name
- Column B: Start Date
- Column C: Duration
Then label the cells as follows:
- Cell A2: Task #1
- Cell A3: Task #2
Note:
Keep going until the Gantt chart has enough rows for every project job you wish to see. In addition to the header row, the table should include four rows if your project consists of four jobs, for instance.
Step 5: Add matching start and finish dates
Write starting and ending dates simultaneously, as shown in the image below.
Step 6: Make the second table
By creating it two or three rows below the first. In this instance, row 8 is where we begin the second table. Give the cells the following labels:
- Cell A8: Name of Task
- Cell B8: Begin on the Day
- Cell C8: Length
Step 7: Determine the Difference
Determine the difference between each taskās start date (column B) and your projectās initial task (probably in cell B2). This will indicate the days each job starts following the first one.
Step 8: Enter the Formula
In cell B9 (assuming your first task details start in row 2), type the following formula:
=int(B2)-int($B$2).
Note:
Explanation of the formulae
- The int() method ensures that the start day value is a whole number (days).
- B2: This refers to the cell (in our case) with the current taskās start date.
- Hit the Enter key. Press Enter on your keyboard to finish.
Step 9: Use the same formula for each job in the Start on Day column
=int(B2) -int($B$2) To access the final project job, click cell B9 and then move the little blue Box located in the cellās bottom-right corner.
Step 10: Enter the following formula in the first cell
(C9) of the Duration column =(INT($B$4)-INT(C4))-(INT($B$4)-INT(B4) . On the keyboard, hit Enter. The value in the cell will automatically fill.
Note:
The cell numbers may change depending on where you put the project data in the sheet (for example, C4 may become C10), but the rest of the formula should stay the same.
Step 11: Use the following formula for each job in the Duration column:
=(INT($B$4)-INT(C4))-(INT($B$4)-INT(B4). After selecting cell C9, click and drag the little blue Box in the cellās lower-right corner to bring you to the final project assignment.
Step 12: Create a Bar Graph
Highlight the second table.
Step 13: Click Insert on the menu
Click on the insert option on the upper side of the sheet. Then click Chart underneath it. As you select it, a stacked bar chart appears on the page.
Step 14: Turn Your Stacked Bar Chart into a Gantt Chart
Click on any Start on Day bar in the Chart. This should highlight all the Start on Day bars.
Configure the Chart.
Step 15: Click the customizable Tab
In the Chart editor panel on the right, click the Customize tab. Click Series, then click the dropdown menu and Start on Day. Click the Color button, then click None. The Chart should now resemble a Gantt chart.
How to Create Gantt Chart in Google Sheets ā Free Templates
How to Make a Gantt Chart in Google Sheets ā Easy Steps
- Open Google Sheets >>Enter your Data
- Go to Insert >>Click on Chart
- Select Stacked Bar Chart
- Customize the Chart>>Format your Gantt Chart
- Label and Share your Gantt Chart
Managing project timelines can be tricky, but Google Sheets can help. With a Gantt chart, you can see your project schedule at a glance. In this guide, weāll show you how to create a Gantt chart in Google Sheets, use a Google Sheets Gantt chart template, and make a Gantt chart from scratch. Letās make project planning easy and keep everything on track with these simple steps.
Table of Content
- What is the Gantt Chart in Google Sheets?
- How to Make Gantt Chart in Google Sheets
- How to Customize Gantt Chart in Google Sheets
- Free Gantt Chart Template for Google Sheets
- How to Remove the Chart
- How to Use Google Sheets Gantt Charts with Dependencies
- Why use Gantt Chart in Google Sheets?
- Conclusion
- FAQs on Google Sheets Gantt Chart
Contact Us