trolls.dev

the honest guide

How to make a Gantt chart

A Gantt chart is just a picture of a plan over time. There are four honest ways to draw one — from a sentence, a spreadsheet, a template, or by hand — and they mostly differ in one thing: what happens when a date changes.

Not sure what one even is? Start with what is a Gantt chart. Wondering whether you need a tool at all? See the honest buyer's guide. Below, the same six-week bakery-website plan we use across our worked examples.

This is what you're building toward

One row per task, each bar as long as the task's duration, positioned so a task starts when the work it depends on finishes. The highlighted bars are the critical path — the chain that sets the finish date — and the diamond is the launch milestone.

Bakery website · six-week plan Wk 1 → Wk 6
Design
14d
Build
18d
Copy
7d
Photos
10d
QA & fixes
11d
Launch
Wk 1Wk 2Wk 3Wk 4Wk 5Wk 6

on the critical path has slack milestone

Four honest ways to draw it

Every method here produces a real Gantt chart. What separates them is what happens after you make it — whether the chart understands the dependencies between tasks, and so whether it fixes itself when a date moves, or waits for you to re-type it.

Method Time Dependencies Reflows on change Shareable link Best for
Describe it in a sentence ~10 seconds Yes Yes Yes Any plan that will change
A spreadsheet 15–30 min No No No A short, stable plan
From a template 10–20 min No No No Starting from a familiar layout
By hand ~5 min In your head No No Sketching a tiny plan

From a plain-English sentence

Describe the project in a line — "design, build, then launch a bakery site over six weeks" — and ganttchart.ai draws the chart above, dependencies and milestones included. When a date slips, everything downstream moves with it.

the DIY route

In an app you already have

None of Excel, Sheets, PowerPoint, or Word has a Gantt button, but each draws one with the same stacked-bar-chart trick. We walk through the exact clicks for Excel, Google Sheets, PowerPoint, Word, and Google Docs — or, if the work already lives there, Notion's Timeline view, the one DIY method that reflows, or Jira's Timeline if your work already runs on epics and sprints. When the plan is big enough to need real scheduling, Microsoft Project computes the dates and the critical path for you — at a price. You can even have ChatGPT write the plan, though something else still has to draw it.

Five steps behind every Gantt chart

The tool changes; the thinking doesn't. Whether you type a sentence or drag bars in a spreadsheet, a good Gantt chart comes from the same five moves. (Working the other direction, from a goal? Our guide to planning a project covers the steps before this one.)

  1. List the tasks

    Write down every piece of real work, one task per line. If the list feels vague, break it down further — a work breakdown structure is just this list, taken one level deeper until each item is small enough to estimate.

  2. Estimate each task honestly

    Give every task a duration. A single number is a guess in disguise, so estimate in ranges — a fast case and a bad day — and carry the difference as one shared buffer rather than padding every bar.

  3. Map what waits on what

    Draw the dependencies: Build waits on Design, QA waits on Build. Most are finish-to-start — one task ends, the next begins. This is the step a spreadsheet can't do for you, and the reason a chart drawn by a real tool reflows itself when a date slips.

  4. Lay the tasks on a timeline

    Place each bar so it starts when its predecessors finish. The longest unbroken chain of dependent tasks is the critical path — it, and nothing else, sets your finish date. Tasks off it have slack.

  5. Mark the milestones and share it

    Add the moments that matter — kickoff, launch, sign-off — as zero-day milestones, then share the chart as a link and keep it live. A Gantt chart is only useful while it still matches reality.

When a Gantt chart isn't the answer

A Gantt chart earns its keep when time drives the work — when things have to happen in order, by a date. If your work is really a pile of interchangeable tasks, or a queue you pull from, a chart is overhead you'll stop updating by Thursday.

  • If order matters more than dates, a timeline of milestones may be enough — see how to make a project timeline.
  • If work flows through stages, a kanban board or a plain to-do list will beat a Gantt chart. Our note on Gantt chart, kanban, or to-do list walks through the one question that decides it.
  • If the plan is tiny and won't change, five minutes on a whiteboard is a perfectly good Gantt chart. Reach for a tool when it starts moving.

Making a Gantt chart, answered

What's the easiest way to make a Gantt chart?

Describe your project in one plain-English sentence and let ganttchart.ai draw it — tasks, durations, dependencies, and milestones included. It takes about ten seconds and reflows itself when a date changes. The spreadsheet methods on this page work, but they take fifteen to thirty minutes and have to be re-typed by hand every time the plan moves.

Can I make a Gantt chart for free?

Yes. ganttchart.ai is free to try in the browser with no sign-up, and both Microsoft Excel and Google Sheets can be talked into a Gantt chart with a stacked bar chart — Google Sheets is free outright. The trade-off isn't money, it's maintenance: the spreadsheet versions don't understand dependencies, so they don't update themselves.

Does Excel or Google Sheets have a built-in Gantt chart?

No — neither has a Gantt chart button. Every spreadsheet Gantt chart is a workaround: a stacked bar chart whose first series is made invisible so the remaining bars appear to float. We walk through the exact clicks for Excel and for Google Sheets, including the formulas to copy.

How do I make a Gantt chart online?

The fastest online option is ganttchart.ai: type a sentence describing the project and it renders a shareable, editable chart in the browser — nothing to install. Google Sheets also works online and for free if you prefer to build the stacked-bar chart yourself.

What should a Gantt chart include?

Four things: the tasks (the real work), each task’s duration, the dependencies between them (what waits on what), and the milestones that mark real progress. Tasks and durations alone give you a static bar picture; it’s the dependencies that make it a plan that can reflow when a date moves.

How long does it take to make a Gantt chart?

From a sentence, about ten seconds. In a spreadsheet, fifteen to thirty minutes the first time, plus a few minutes of re-typing every time a date changes. On paper, five minutes — but you lose it the moment the plan moves. The gap widens the more your project changes.

Troll mascot sketching a project plan

New to the vocabulary? Every planning term on this page is defined in the plain-English glossary.

Make one in about ten seconds

Describe your project in plain English and get the chart above — shareable, editable, dependencies and milestones included.