How to Make a Gantt Chart in Excel (2026) | Intellisoft Singapore

How to Build a Gantt Chart in Excel (Step-by-Step)

TL;DR: Excel has no built-in Gantt chart, so you build one from an ordinary stacked bar chart: set up a task table with start dates and durations, insert a stacked bar chart, make the start segment invisible with No Fill, and reverse the task order. Two formatting changes and you have a working timeline. Our hands-on Excel training in Singapore walks through this and the rest of Excel’s reporting toolkit.

A Gantt chart is the fastest way to see a whole project on one screen. Every task becomes a horizontal bar, lined up against a calendar, so you can tell at a glance what starts when and what is running long. Your boss asks “where are we on the launch?” and you point at one picture instead of reading out a list.

Here is the surprise: Excel has no built-in Gantt chart. Open the chart menu and it simply is not there. So we cheat, in a good way. We take an ordinary stacked bar chart, make the first part of each bar invisible, and flip the task order. What is left looks exactly like a Gantt chart. I have taught this in Excel classes in Singapore for 24 years, and the trick still makes people smile when the bars suddenly line up. This guide walks you through the whole build, step by step: the formulas, the two formatting snags that trip up almost everyone the first time, how to add a progress layer, and when a ready-made template is the smarter choice.

What a Gantt chart is (and why Excel can fake one)

A Gantt chart is a visual project timeline. Tasks run down the left side. Dates run across the top. Each task gets a horizontal bar, and the bar’s position tells you when the task starts while its length tells you how long it takes. Read it left to right and you see the order of work. Read it top to bottom and you see everything that has to happen.

Excel does not give you a Gantt chart as a chart type. You will find column, line, pie, and bar charts, but no Gantt option anywhere. The thing that saves us is the stacked bar chart. A stacked bar places two values end to end in one bar. Think of it like a relay race: the first runner carries the baton to a certain point (that is your start date), then the second runner takes it the rest of the way (that is your task duration). If we make the first runner invisible, only the second stretch shows, sitting at the right spot on the timeline. That is the whole secret. You are not really drawing a Gantt chart in Excel. You are dressing up a stacked bar chart until it reads as one.

Step 1: Set up your project table

Everything starts with a clean table. Before you touch the chart menu, lay out four columns:

• Task — a short name for each chunk of work, one per row
• Start Date — the calendar date the task begins
• Duration — how many days the task takes
• End Date — let Excel calculate this, do not type it

Put your tasks in rows in the order they happen, earliest first. For the End Date, let Excel do the sums instead of typing dates by hand. If Start Date sits in column B and Duration in column C, your End Date in column D is:

=B2 + C2

A simple example might look like this:

Keep the dates as real Excel dates, not text. If you type them in a format Excel recognises (1 Jun, or 1/6/2026), Excel stores them as proper dates, and the chart needs that later. If you are still finding your way around tables and formulas, our walkthrough on how to create a pivot table in Excel is a good companion piece for working with structured data.

Step 2: Insert a stacked bar chart

With the table ready, select the data you want to chart. Start simple: select the Task column and the Start Date column together. We will add Duration as a second series in a moment.

Then:

1. Go to the Insert tab on the ribbon.
2. In the Charts group, click the Bar chart icon.
3. Under the 2-D Bar section, choose Stacked Bar (not 100% Stacked Bar).

Excel drops a chart onto the sheet. To add the Duration series, right-click the chart and choose Select Data, click Add, name the series “Duration”, and point it at your Duration column. You should now see two coloured segments per bar: the start offset, and the task length.

Step 3: Turn the bar chart into a Gantt chart

This is the step that does the real work, and it is only two changes. Extremely easy once you have seen it once.

Make the start segment invisible. Click once on any bar in the first series, the start-date segment. Right-click and choose Format Data Series. Open Fill & Line, set Fill to No Fill, and set Border to No Line. The first segment vanishes, leaving each task bar floating at the right spot on the timeline.

Reverse the task order. By default Excel lists the first task at the bottom, which reads upside-down. Click the list of task names on the vertical axis. In the Format Axis pane, under Axis Options, tick Categories in reverse order. Your first task jumps to the top and the chart reads the way people expect.

That is your Gantt chart. Two formatting changes on a stacked bar chart, and the core build is done. How good is that?

Step 4: Fix the two gotchas everyone hits

Two problems show up almost every single time someone builds their first Excel Gantt chart. After 24 years of teaching this, I can tell you neither one is your fault. They are quirks of how Excel handles dates and order, and once you know them you will never be stuck again.

Dates show up as numbers. Excel stores dates as serial numbers, counting the days since the start of 1900. Sometimes those numbers land on the chart axis and display as something like 45810 instead of a date. To fix it, click the date axis, open Format Axis, and under Number choose a Date format. While you are there, set the axis Minimum to your project’s first date, otherwise the chart starts back in 1900 and squashes all your bars into a thin sliver on the right.

The bars run in the wrong direction or order. If you skipped the reverse-order step, the tasks read bottom to top. If a bar sits in the wrong place entirely, check that the start segment is the first series and the duration is the second. A swapped order puts the invisible part in the wrong place. Re-open Select Data and confirm Start Date is listed above Duration. A drop-down list for task status is a handy add-on once the chart itself behaves.

Step 5: Add a progress / % complete layer

A plain Gantt chart shows the plan. A better one shows how much of each task is actually done, and that is the version your manager will ask for the moment they see the first one. Most basic tutorials stop before this part, but it only takes one more column and one more series.

Add a % Complete column to your table. Put 100% for finished tasks, 40% for a task that is partly done, and so on. Then add a third data series that represents the completed portion of each bar, which is duration multiplied by percent complete. Format this new series in a darker shade of the task colour so it sits on top of the lighter “planned” bar. Now each task bar shows a solid filled section for work done and a lighter section for work still to go. At a glance you can see which tasks are on track and which are slipping. That is the chart that gets you out of the status meeting early. If you want to summarise that progress numerically too, SUMIF and SUMIFS let you total completed days by phase.

Use a ready-made template instead (when it’s worth it)

If you build a Gantt chart once a year, doing it from scratch is fine. If you build them often, a template saves you the fiddly formatting every single time.

Excel itself ships Gantt-style templates. Open File > New and search for “Gantt” to see project planners and timeline templates built right into the app. Microsoft’s own guide covers more, and free options like the well-known Vertex42 Simple Gantt Chart give you a working chart with the formulas already wired up. Download one, replace the sample tasks with your own, and the chart updates itself.

A template is worth it when you want consistency across projects, when a colleague needs to open your file and understand it in seconds, or when you simply do not want to do the No-Fill-and-reverse dance again. Building from scratch is worth it when you need a specific layout, when you are learning how the chart actually works, or when a template carries more columns than you need. Both are valid. Pick the one that gets you to the answer faster.

When Excel is the wrong tool for the job

Excel makes a perfectly good static Gantt chart, and for a small project with a handful of tasks it is hard to beat. But it has real limits, and I would rather you hear them from me than discover them at 11pm before a deadline.

Excel does not handle task dependencies on its own. If Task B can only start when Task A finishes, you manage that with formulas. The WORKDAY function helps shift dates around weekends, but when a date changes upstream you are updating things by hand. Excel does not do live collaboration well for a moving project plan, it has no built-in critical path or resource levelling, and a chart with fifty tasks across six months gets unwieldy fast. Dedicated tools, like a project planner app or Microsoft Project, exist precisely because real project management outgrows a spreadsheet. There are also newer AI tools that will draft a chart from a plain-text task list, and Copilot can help set up the table, though for most office work the manual Excel method stays the most controllable. If you do want to push Excel further for reporting, our courses on advanced data analytics and visualisation with Excel and on Copilot across Microsoft 365 Office pick up where this guide leaves off.

Here is the honest version, and it is a stance I hold after 24 years: the chart is the easy part. Anyone can learn the No-Fill trick in ten minutes. The hard part is the judgement of which tasks matter, who owns what, and what to do when the plan slips, and no chart type teaches you that. Use Excel for the planning view. Reach for a proper tool when dependencies, teams, and constant change take over.

Frequently asked questions

Does Excel have a Gantt chart template?
Yes. Excel does not have a Gantt chart type, but it does ship Gantt templates. Go to File > New and search for “Gantt” to find built-in project planners and timeline templates. Microsoft’s online gallery has more, and free third-party templates like the Vertex42 Simple Gantt Chart come with the formulas already set up. If you do not want to build the chart from a stacked bar yourself, a template is the quickest route there.

How do I add dates to a Gantt chart in Excel?
The dates come from your data table, not the chart. Give each task a Start Date column and a Duration column, and the stacked bar chart positions the bars along the timeline for you. If the dates on the chart axis show up as plain numbers, click the axis, open Format Axis, and choose a Date number format. Then set the axis Minimum to your project’s first date so the timeline starts in the right place instead of in 1900.

How do I show progress on an Excel Gantt chart?
Add a % Complete column to your table, then add a third data series equal to duration multiplied by percent complete. Format that series in a darker colour so it overlays the lighter planned bar. Each task bar then shows a solid filled section for work done and a lighter section for work remaining. It is the quickest way to turn “we are roughly on track” into something your manager can actually see.

Can Excel handle task dependencies in a Gantt chart?
Not automatically. Excel has no native dependency engine, so if one task must wait for another, you manage it with formulas, usually by basing a task’s start date on the previous task’s end date and using the WORKDAY function to skip weekends. This works fine for small plans. It gets fragile as the project grows. For heavy dependency management, a dedicated project tool is the better fit.

What is the difference between a Gantt chart and an Excel project planner?
A Gantt chart is the visual timeline, the bars laid across a calendar. An Excel “project planner” usually means a fuller template that bundles the task table, the chart, and extras like owners, status, and progress into one workbook. The Gantt chart is one component. The project planner is the whole tracking sheet built around it.

Is there an AI way to make a Gantt chart in Excel?
Yes — there are AI tools and add-ins that generate a chart from a typed list of tasks and dates, and Copilot in Excel can help set up the underlying table. They can save you setup time, but underneath they still produce the same stacked-bar-based chart, and you will usually want to check the formatting and dates yourself. For most office users, learning the manual method gives you far more control over the result.

I hope you’ll find this useful. Open a blank workbook, type in five tasks with their start dates and durations, and try the No-Fill-and-reverse trick once. The first time the bars line up along the timeline, it clicks, and you will be making these in minutes after that. If you want to go further with Excel for real work reporting, do have a look at our hands-on Excel training in Singapore.