Get hands-on help with Vocordia
You can do it the hard way - reading guides, switching tabs, figuring it out step by step.
Or you can do it the easy way.
Vocordia is your AI copilot across Excel and any software on your screen - just say what you want, and your cursor will guide you step by step, so you can get it done instantly without leaving your window.
How to Create a Gantt Chart in Google Sheets
Google Sheets has no native Gantt chart, but a **stacked bar chart** with a hidden offset series produces one. You can also use conditional formatting on a date grid for a calendar-style view.
Build the data table
Set up four columns:
| Task | Start | End | Duration |
Use formulas:
Duration=End - Start- Add a helper column Days from start =
Start - <project start>(the chart''s invisible offset).
Insert the stacked bar chart
- Select Task, Days from start, and Duration.
- Insert → Chart.
- In the Chart editor → Setup, change Chart type to Stacked bar chart.
Hide the offset series
- Customize → Series → pick Days from start.
- Set Color to None (transparent), and turn off the legend entry.
- The remaining colored bars represent durations starting from each task''s start date.
Optional: calendar-style Gantt
- Put dates across Row 2 and tasks down Column A.
- Use a conditional formatting rule like
=AND(D$2>=$B3, D$2<=$C3)(start in B, end in C) to color cells inside each task''s span.
Try it faster with guidance
Skip the chart-editor maze—let Vocordia guide you through it with voice and on-screen cursor guidance so you can build the Gantt without rebuilding the helper columns.
Had to scroll back or switch tabs a few times?
That's the hard way.
Next time, just say what you want - and let your cursor guide you step by step to the result.