ezGantt

View a Google Spreadsheet as a Gantt Chart

ezGantt uses public Google Chart and Google Drive JavaScript APIs, so the same users who can view the Spreadsheet can see the Gantt chart. To try it, go to https://ezgantt.appspot.com/#1kYfoEFXW-psZ8AMy0Ne7wRMiM3umNKBs3v9U7nvafXA

To use it yourself, make a copy of the demo sheet and start adding tasks!

Feature Requests

• Clickable rows
• Allow both date and depends-on constraints, and choose latest one as a “no earlier than” constraint.
• Last updated date (and who?)
• Public ezgantt.appspot.com version
• Any line item task description where the task starts with a ‘#’ is ignored
• Drive API v3, Sheets API v4
• Enforce unique ID column
• Easier linking from sheet to chart
• Resources in demo = people
• Easier hash tag
• new better auth, fetch, promises flow
• removed excess drive permissions

INFO

ezgantt.apspot.com

gcloud app deploy -q --project ezgantt --version 1 --verbosity=info app.yaml

• app id: ezgantt
• api key, client id, client secret: see JS files.

QUOTES

“I think ezgantt is a great tool for small-medium projects, it’s easy to learn (took me minutes to get a good chart) and maintain.”

References

• https://developers.google.com/chart/interactive/docs/gallery/ganttchart
• https://developers.google.com/sheets/api/quickstart/js
• https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/get