Step by step process of building your Gantt Chart 1. Some other details could be a more granular aspect such as geography or where the project is to be implemented, details of the tasks and etcetera. The Timelines or schedules should primarily have tasks or subtasks, those responsible or assigned and other details you find necessary. This should better inform the data schema and ensure a seamless ETL process (Extraction, Transform, and Loading of data) for visualization.Īn example of why you are creating a Gantt Chart could be to visualize a project timeline or classroom schedule. Creating a Gantt Chart starts off with knowing the purpose or reasons for which it's being created. There are a few questions you need to ask yourself before creating your Gantt Chart.

In this article, I’ll show you how to build an automated Gantt Chart with Google Sheets.

Gantt Charts is a good way to illustrate a project schedule and there are a handful of project management tools in the likes of Asana and Trello that I have used and would recommend.īut what happens if the tools fall short and you want to work with something that will serve the purpose? Google Sheets is that one solution that should come in handy with a few tweaks here and there your way. As long as you are a project manager, at some point, you must work with Gantt Charts.

Gantt chart maker google sheets