How to embed a Google Chart Gantt chart into a Google Sheet?

2
votes

I currently keep my project plans in Google Sheets. I see now that Google has a Gantt Chart that can be directly embedded in a web page. I would like to embed the Gantt chart directly in a Google Sheet. The native Insert->Chart does not include a selection for the Gantt chart. Is there a way to use this control inside of Google Sheets?

1
google-sheetsgantt-chart

1 Answers

1
votes

Unfortunately, Google Spreadsheets does not offer a built in Gantt Chart option. And Google Apps Script does not afford the capability to manipulate the UI in the way your link mentions. The best option I have found is to use the SPARKLINE function to create interactive Gantt Charts with data from the spreadsheet.

=SPARKLINE({daysSinceProjectStartUntilTaskStart, daysSinceProjectStartUntilTaskFinish})

enter image description here

Here is a tutorial and demo: https://trevorfox.com/2017/01/google-spreadsheets-gantt-charts/