Project Gantt Chart with Google Sheet


This Project Gantt Chart is made with Google Sheet and not compatible with Microsoft Excel, because some important formula is not available on Excel.

It’s not as complicated like Microsoft Project, but not very simple neither. You can input project name, activities, user (person in charge), start date, duration, and status. The graphic (colored cell) and date range will be generated automatically. The colored cell will be divided into three color, red for past days, yellow for today, and green for future days. Just delete the random number generator cells and duration (update as per your need) cells, because it just for demoing purpose.

You can visit the template from this link:
https://docs.google.com/spreadsheets/d/1ZrB1O8fkMhmRwbreCs46My2pg4sRKA_1ssT5gDfkavc/edit?usp=sharing

Project Gantt Chart with Google Sheet Screenshot
Project Gantt Chart with Google Sheet

I’ve made it read-only, so you must copy it to your own Google Drive. I hope this template is useful for you.

R. Bambang Widiatmoko

I'm an engineer and working in engineering consultant office. I have some experience in computer application in graphic design (CorelDRAW, Inkscape, GIMP), AutoCAD, and Office. I also like to read technology news.

You may also like...