DATA PREPARATION

How to prepare Gantt chart data

Use one row per task with a name, ISO start date, inclusive ISO end date and progress from 0 to 100.

Dates and duration

Dates use YYYY-MM-DD calendar strings. End dates are inclusive, so matching start and end dates produce a one-day task. Excel date-formatted cells are converted through the workbook date system without executing formulas.

Overlap and progress

Overlapping tasks share the same proportional calendar domain. Progress is a presentation overlay from 0 to 100 and does not reschedule a task.

Gantt is not a scheduling engine

The tool does not calculate dependencies, critical path, working-day calendars, resource allocation or automatic optimization. Use Timeline for dated point events rather than duration ranges.

WORKED EXAMPLE

Example data

Demonstration values only-replace them with your own source data.

TaskStart DateEnd DateProgress
Research2026-11-012026-11-05100
Design2026-11-042026-11-1265
Build2026-11-102026-11-2430

Try the working tools

Gantt Chart MakerTimeline Maker

Related workflows and guides

GUIDE FAQ

Questions about this task

Yes.