Get hands-on help with Vocordia
Employees can follow this guide step by step - or open a ticket and wait for support.
Or they can finish inside the app.
Vocordia gives voice and cursor guidance directly inside the tools they already use - just say what they need, and Vocordia shows them where to click, step by step, without leaving the 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.
Still routing this to IT or HR?
There's a faster way.
Next time, employees can ask by voice and get step-by-step guidance inside the app - no manual, no ticket.