How to Create a Gantt Chart in Google Sheets

How to Create a Gantt Chart in Google Sheets

Achieving business success involves careful planning and managing various tasks and projects. So, as a business owner, you cannot afford to miss a tiny detail as it may cause colossal trouble later. And an excellent way to stay at the top of your game is to use Gantt charts. In this article, I will share tips on how to create a Gantt chart in Google Sheets.

Benefits of Creating Gantt Charts for Your Business

You can use a Gantt chart to keep tabs on your project progress. A modern Gantt chart can rule out the need for project management software to manage routine tasks. If you are not still sure of why you need to create Gantt charts for your business, check out the benefits below:

1. Tracks Your Progress

With a Gantt Chart, you have a complete overview of the project plan in one place. This makes it easy for you to track the progress of various tasks. As you have everything related to the project in front of you, you can easily follow up with respective team members about the progress. Also, you can add a Status Section to a Gantt chart so that the concerned team member can easily let you know once he/she has completed the task.

2. Promotes Accountability

From the first task to the last task within the project, a Gantt chart can help your team members learn about how everyone on the team is doing. Some team members completing tasks on or before the task finish date can motivate the rest of the team to buckle up.

3. Improves Team Communication

If used strategically, Gantts charts can help to improve your team cohesion. You can easily add a section to assign tasks to different team members. And sharing the Google spreadsheet with your team members enables them to know who is completing which task. If they have any queries related to other tasks in the project, they can easily contact the right person.


4. Makes Working with a Remote Team Efficiently

As you probably know, both employer and employees benefit from remote working. With a Gantt chart, you can work with a remote team efficiently. When you share information-rich Gantt charts with your remote team, they will know everything about the project schedules. So, you don’t have to remind anyone about any task’s deadline. Also, using Gantt Chart makes collaboration easier when your remote workers know whom to contact if they need any information related to other tasks in the project.

5. Encourage Transparency

A Gantt chart enables your team to know who is working on which task. Your team members become aware of each other’s workload, task progress, milestones achieved, etc. This promotes transparency.

What to Include in a Gantt Chart

A Gantt chart helps you track the progress of various tasks in your business. So, including key elements is crucial for the success of your Gantt chart.

A basic Gantt chart includes:

  • Project Tasks: You must mention all the tasks of your project in the task name column of your Gantt chart. Don’t leave out any task because it is tiny and can be finished in just a couple of hours.
  • Task Start Date: You will need the task start date of various tasks involved in the project to make a Gantt chart. Also, fill the date in the correct date format.
  • End Date: You will require to fill in end dates in the End Date column of Google Sheets.
  • Task Duration: You can easily calculate the task duration once you have the start dates and end dates of various tasks in the project. A Gantt chart being used for long projects might also include, in addition to the project schedule, milestones, current status, etc.

How to Create a Gantt Chart in Google Sheets

A Gantt chart is a popular project management tool to illustrate a project management plan. It often includes horizontal bars to depict the start date and duration of each project task. The process to prepare a Google Sheets Gantt chart is simple and straightforward.

1. Open a New Spreadsheet

Visit and click on the + sign to open a new spreadsheet.

2. Insert Project Data

After opening a new spreadsheet, insert project data, which most often include but are not limited to:

  • Project name
  • Task name
  • Task’s Start date
  • End date


3. Create Task Duration

Now, you have to calculate the duration for each task completion. For that, copy-paste the above-table 2-3 rows below from the first table.

Delete the date from the Finish Date section of the second table. And then, replace the Start Date and the Finish Date of the second table with Start on Day and Duration.

For the Start on Day column of the second table, apply =int(B2)-int($B$2) for each cell. This will give you a start day for each task.

To create a Gantt chart, you will have to calculate the task duration for the second table. In the second table, apply =( int(C2) – int($B$2) ) – ( int(B2) – int($B$2) ) formula in all the cells of the Duration section.

4. Insert a Stacked Bar Graph

Select the second table, and insert a chart from the drop-down menu of the spreadsheet. A stacked graph appears with the chart editor pane on the right side.

5. Convert the Stacked Bar Chart into a Gantt Chart

When you select all the Start on Day bars (blue ones), the chart editor menu will appear on the right side. Select the customize tab, and make Fill Capacity (mentioned on the right of Fill Color) zero percentage to get the final Gantt chart.

Final thoughts

Now that you know how to make a Gantt chart in Google Sheets, you can easily track the progress of routine tasks. For multiple projects, you can explore this list of top project management software to pick the best.

If you like this article “How to Create a Gantt Chart in Google Sheets”, please share it with your friends and family. Also, subscribe to our newsletter and YouTube Channel to ensure you don’t miss any update from us.  Finally, don’t forget to join our community to connect with others. Lastly, you can also follow us on our social media pages – TwitterFacebookInstagram and LinkedIn.

About Emmanuel Oluwatosin

Co-founder & Publisher of AfricaX. He is interested in: Technology | Media | Startup | Business | Education. Emmanuel currently lives in Calgary, Canada with his family.

View all posts by Emmanuel Oluwatosin →