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

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