How to make a Gantt chart in Excel — without drawing the bars

There are two ways to build a Gantt chart in Excel. The one every tutorial teaches turns a stacked bar chart into something that looks like a Gantt chart. It works, and I walk through it below, because sometimes a picture for a slide is all you need. The other way is to let the spreadsheet work out the dates and draw the bars itself, which is what the free template on this page does — and it then shows the thing neither method usually does: the days your plan quietly assumes more people than you actually employ.

Download the template (.xlsx)

No email, no signup. Works in Excel and Google Sheets.

Method 1: the stacked bar chart trick

This is the method behind almost every “how to make a Gantt chart in Excel” result, and it is worth knowing because it needs no template at all.

1. Build three columns: Task, Start date and Duration in days. Nothing else.
2. Select all three, then Insert → Bar Chart → Stacked Bar.
3. Click the first series — the one drawn from the start dates — and set its fill to No fill. The bars now appear to float, which is the whole trick: the invisible series is the offset.
4. Right-click the task axis, choose Format Axis, and tick Categories in reverse order, so task one sits at the top where a reader expects it.
5. Set the date axis minimum to your earliest start date, or Excel wastes half the chart on empty weeks before the project begins.

The same five steps work in Google Sheets, with the chart editor in place of the ribbon.

Why that version stops being useful

It draws a picture of dates you typed. It does not know that task 12 cannot start until task 7 finishes, so when task 7 slips by three days — and it will — you retype every start date downstream by hand, and the chart happily redraws whatever you typed, mistakes included. It also has no idea that four tasks in week six all need the same electrician. That is not a flaw in the tutorial: a bar chart is a drawing, and a drawing cannot hold a rule.

If the plan is going to change even once, it is worth having the dates calculated rather than typed. That is the second method.

Method 2: the template on this page

What it does on its own

• Type a task, how many days it takes, and which task IDs must finish first. The start dates work themselves out and the bars draw themselves.
• Weekends are skipped and shaded. Set WorkDaysPerWeek to 7 if you work straight through.
• Underneath the chart, a daily resource load panel turns red on any day you need more of a trade than you have.
• Type a date over a Start cell and tick the Pin column to nail a task in place; everything else still calculates around it.

What it does not do

It draws the plan you describe. It will not reshuffle the work to fit your crew — no spreadsheet formula can, because that problem is NP-hard and needs a solver. That is what the free resource leveling and critical path scheduler is for: upload this same file and it hands it back with the dates rearranged, the red gone, and a straight answer on what your real headcount costs you in days.

The columns

• Days — duration in working days.
• Predecessors — task IDs, comma separated. 12 means finish-to-start. 12FS+3 adds three days of lag, 7SS starts with task 7, 4FF-2 finishes two days before task 4 does.
• Resource and Crew/day — who does it and how many of them, matched against the resources sheet.

Limits: 60 tasks and 95 days in the template. List a task below the tasks it depends on — the Check column tells you when you haven't.

Common questions

Does Excel have a built-in Gantt chart? No. There is no Gantt chart type in the Insert menu — every method, Microsoft's own guidance included, is a stacked bar chart with the first series hidden.

Will this work in Google Sheets? Yes. The template's formulas and conditional formatting both survive the import, and the manual method above works there too.

How do I show the critical path? A spreadsheet will not find it for you — that needs a forward and a backward pass over the whole network. Upload this same file to the free critical path and resource leveling scheduler and it comes back with the critical tasks marked and the float on every other one.

Can I get it into MS Project? The scheduler exports MS Project XML, so the round trip is: build the plan here, solve it there, open it in Project.