How to make a Gantt chart in Excel
Excel can produce a genuinely useful Gantt chart with the stacked bar chart trick — here is the exact method, its real limits, and when to move on.
Excel is where a huge share of the world's project planning quietly happens, and it deserves less scorn than it usually gets from project-management purists. It was never built to be a Gantt chart tool — there is no "Insert Gantt Chart" button — but with one well-known trick, the stacked bar chart, it can produce a genuinely useful Gantt chart, built from data you already trust, inside a workbook you already use. This guide walks through that trick step by step, then gives an honest account of where it holds up and where it quietly breaks.
None of what follows needs add-ins, macros, or a paid template. It is the standard chart tools found in any reasonably recent version of Excel, and the same approach carries over to Google Sheets with minor menu differences.
How to make a Gantt chart in Excel: the stacked bar method
The trick is a small piece of sleight of hand. A stacked bar chart normally draws two segments end to end for every row. Make the first segment — the empty days before a task starts — invisible, and only the second segment is left visible, floating exactly where the task actually falls on the calendar. Once you have seen it done, it is hard to unsee, and it is the basis of almost every "Excel Gantt chart" template you will find online.
- Lay out three columns: Task, Start Date, and Duration. Enter Start Date as a real Excel date, not text, or the chart will not plot it correctly. Duration is the number of days the task takes. If you find it more natural to think in end dates, add an End Date column and calculate Duration as End Date minus Start Date.
- Select the data. Highlight the Task, Start Date, and Duration columns together, in that order — the column order becomes the series order in the chart, and this method depends on Start Date coming before Duration.
- Insert a stacked bar chart. Go to Insert, then Charts, then Bar Chart, and choose the 2-D Stacked Bar option. Excel draws a horizontal bar for every task, each one built from two stacked segments: Start Date, then Duration.
- Hide the Start Date segment. Click directly on the first (left-hand) segment of any bar to select that entire series, open Format Data Series, and set both Fill and Border to None. Every bar's leading segment vanishes, leaving a set of floating bars that begin exactly on each task's start date.
- Reverse the task order. By default Excel draws your first row at the bottom of the chart, so the list reads upside down. Click the vertical axis, open Format Axis, and tick Categories in reverse order. This also flips the date axis to the top of the chart, which most people simply leave as is.
- Set the date axis bounds. Click the horizontal date axis, open Format Axis, and set Minimum and Maximum to your project's actual start and end dates. Left on automatic, Excel sometimes starts the axis near its own date epoch in the 1900s, wasting most of the chart on empty decades.
- Clean up the formatting. Narrow the gap width so bars read as solid blocks rather than thin slivers, colour them by phase or owner, delete a legend that only says "Start Date" and "Duration", and add data labels for task names if you want them directly on the chart.
- Add a today marker, if you want one. Excel has no built-in equivalent of a Gantt tool's today line. The usual workaround is a thin extra series, or a manually drawn vertical line shape, positioned at today's date — genuinely useful once in place, but something you have to remember to move yourself.
- Save it as a template. Once the formatting looks right, save a copy of the workbook stripped of real data, so the next project starts from a working chart rather than rebuilding the stacked-bar trick from nothing.
Most common snag: if your tasks are listed bottom-to-top instead of top-to-bottom, or the date axis shows plain numbers like 45832 instead of dates, you have hit steps 5 and 6 above. Reverse the category order and set explicit minimum and maximum dates on the axis, and both problems disappear.
What this method genuinely cannot do
The stacked bar trick produces a real, usable chart, and it is worth being honest about its ceiling. Excel has no concept of a task dependency. If Task 3 cannot start until Task 2 finishes, and Task 2 runs three days late, nothing in the workbook knows that. The bar for Task 3 sits exactly where you typed its start date, indifferent to the task beside it, until a person opens the file and drags the date across by hand.
That single gap causes most of the trouble people run into. Every change to the plan becomes a manual edit: push one task out a week, and you must remember every task downstream of it and update each of their Start Date cells yourself. On a project of eight tasks that is a minor chore done in a couple of minutes. On a project of eighty, it is a standing part-time job — and exactly the kind of job people quietly stop doing after the third revision, which is how a beautifully formatted Excel Gantt chart turns into a beautiful fiction, three weeks out of date and still being projected in status meetings.
The same ceiling shows up in a few related places. There is no critical path calculation, so nothing tells you which chain of tasks actually controls your finish date and which slip is harmless. There is no built-in baseline to compare planned dates against actual ones over time, short of duplicating columns and building the comparison by hand. Milestones have no native diamond marker; people fake one with a zero-duration bar or a styled scatter point. And collaboration means either emailing a workbook back and forth or trusting a shared cloud copy, with the usual risk of two people editing different versions of the same plan at once.
Picture a twelve-task office move: book the movers, pack IT, pack the archive, notify clients, redirect post, and so on. Draw it once in Excel and it looks perfect on day one. Then the movers reschedule by four days. In a dependency-aware tool, that single change ripples through every task booked around it automatically. In Excel, it is your job to notice which of the other eleven rows the movers actually affect, then edit each one by hand — easy to do carefully once, easy to get wrong the third time it happens.
None of that makes the chart wrong to build. It makes it a snapshot you redraw by hand, not a live model that updates itself. For plenty of projects that trade-off is completely fine. For others, it is precisely the thing that quietly costs a team its most useful asset: a schedule everyone trusts is current.
Excel versus a dedicated Gantt tool
Laid out side by side, the trade-off is fairly clean: Excel costs you build time and upkeep in exchange for staying inside a tool you already know; a dedicated tool costs you a few minutes of learning in exchange for the plan maintaining itself.
| Excel (stacked bar chart) | Dedicated Gantt tool | |
|---|---|---|
| Setup | You build the stacked-bar trick yourself | Ready in under a minute, purpose-built |
| Dependencies | None — you edit every affected date by hand | Built in; downstream tasks shift automatically |
| Critical path | Not available | Usually calculated for you |
| Rescheduling | Manual, task by task | Automatic ripple when one date moves |
| Today line / progress | Manual workaround | Usually built in |
| Collaboration | File-based, or a shared sheet with version risk | Often live and multi-user |
| Where your data lives | Your own file or drive | Varies — some run locally, some in the vendor's cloud |
| Best suited to | Small, fairly static plans | Plans that change, with real dependencies |
When Excel is genuinely the right call
Do not read the limitations above as a reason to abandon Excel outright — for a real slice of projects it is the correct tool, not just the familiar one. If your plan is small, will barely change once drawn, and does not lean on task dependencies, the manual nature of Excel is not a cost you will ever feel. It is also the right call when the chart needs to live beside other data you already track in the same workbook — a budget, a resource list, a risk log — rather than in a separate app you have to keep in sync. And if nobody on the project will ever open anything but Excel, a chart everyone can already read and edit beats a better chart nobody opens. A one-off event with a dozen fixed-date tasks, a simple renovation schedule, or a personal project you are the only one tracking are all good homes for the stacked bar method — draw it once, glance at it weekly, and you may never touch the dependency question at all.
When it is time to switch to a dedicated tool
A few honest signals tell you the stacked-bar trick has stopped paying for itself. You are editing several Start Date cells by hand every time one task slips. Your task list has grown past thirty or so rows and the chart has become hard to read at a glance. You need to show, not just tell, which task is actually driving the deadline — the question only a critical path answers cleanly. Or more than one person needs to update the plan at the same time without emailing files back and forth.
When any of that is true, moving to a purpose-built tool tends to pay for itself within the first schedule change. See how to make a Gantt chart for the tool-agnostic version of the process, and free Gantt chart tools compared for an honest look at the free options, including browser-based tools such as this one that need no install or account and handle dependencies and rescheduling automatically.
The two approaches are not really in competition. Excel is an excellent way to sketch a small, stable plan inside a workbook you already trust. A dedicated tool earns its place the moment the plan starts to move. Knowing which situation you are in — before the meeting where the chart turns out to be three weeks stale — is the whole point of this guide.
Frequently asked questions
Does Excel have a built-in Gantt chart template?
Not a true one. Excel ships bar charts and stacked bar charts; the Gantt-style templates available online are pre-built versions of the stacked bar trick described above, with the Start Date series already hidden and formatted for you.
Can Excel show task dependencies in a Gantt chart?
No. A stacked bar chart in Excel has no concept of one task depending on another, so moving a task never moves the tasks that depend on it. If dependencies matter to your plan, that gap is usually the first reason to move to a dedicated Gantt tool.
Why is my Excel Gantt chart listing tasks in the wrong order?
Excel plots the first row of your data at the bottom of the chart by default. Select the vertical axis, open Format Axis, and tick Categories in reverse order to put the first task back at the top.
How many tasks can an Excel Gantt chart realistically handle?
Comfortably up to somewhere around twenty or thirty tasks on a fairly stable plan. Beyond that, the manual work of keeping dependent dates in sync after every change grows faster than the chart stays useful, and a tool built around dependencies starts to earn its keep.
When should I move from Excel to a dedicated Gantt tool?
The clearest sign is editing several Start Date cells by hand every time one task slips. At that point, a dedicated Gantt tool that reschedules automatically will save more time than it costs to learn.
Build it free, right now
Gantt Chart Maker runs entirely in your browser — no signup, no account, nothing to install. Open it and start a plan in under a minute.
Open the app →