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

Straight answer: you build a Gantt chart in Excel by listing your tasks with start dates and durations, then turning a stacked bar chart into a timeline using a simple "start date" invisible bar plus a "duration" visible bar. It takes about 20 minutes to set up, works on any version of Excel from 2013 onwards, and costs nothing beyond the software you already have.

I built my first Excel Gantt chart in 2011 for a client launch that had eleven moving parts and a marketing agency that kept "forgetting" deadlines. I did not have budget for project software. I had Excel, a Tuesday afternoon, and a deadline of my own. Fifteen years later I still use the same method for smaller projects, and I teach it to clients who assume they need to pay for Asana or Monday before they have even mapped out what they are managing.

What you need before you open Excel

Do not open Excel first. Open a blank page and write down three things: every task in the project, roughly how long each one takes, and what has to finish before the next thing can start. Most people skip this and end up rebuilding their chart three times because they missed a dependency.

For a real example, here is what a small website redesign project looks like once it is broken down:

• Content audit: 3 days
• Wireframes: 4 days
• Design mockups: 5 days
• Client review: 2 days
• Development: 10 days
• QA testing: 3 days
• Launch: 1 day

That is 28 working days of task time, but the project might run 5 or 6 weeks calendar time once you factor in weekends and the client sitting on their review for four days instead of two, which they always do. If you want a slightly more detailed structure before building this in Excel, my guide to planning a project timeline using a spreadsheet template walks through how to sequence tasks like this before you touch a chart.

Step by step: building the actual Gantt chart

Here is the exact method, no plugins, no add-ins, just native Excel.

Step 1: Build your data table

In columns A to D, set up:

• Column A: Task name
• Column B: Start date
• Column C: Duration (in days)
• Column D: End date, calculated as =B2+C2

Type every task from your list, one row each. Use real dates, not placeholders, because the chart pulls directly from these.

Step 2: Insert a stacked bar chart

Select your Task, Start Date, and Duration columns (skip End Date for now). Go to Insert, then Chart, then choose Bar Chart, then Stacked Bar. Excel will give you an ugly chart with two series stacked on top of each other. That is exactly what you want.

Step 3: Make the start date bar invisible

Click on the blue bar (your start date series), right click, choose Format Data Series, and set Fill to No Fill. This is the trick that makes the whole thing work. Your visible bar (duration) now floats at the correct starting point on the timeline instead of starting from zero.

Step 4: Reverse the task order

By default Excel plots your first task at the bottom. Click the vertical axis, Format Axis, and tick Categories in Reverse Order. Now your first task sits at the top, which is how everyone reads a Gantt chart.

Step 5: Format the date axis

Click the horizontal axis, Format Axis, and set the minimum bound to your project's actual start date and the major unit to 7 (for weekly gridlines) or 1 (for daily). This stops the chart showing three months of empty white space before your project even begins.

Adding the details that make it usable

A bar chart with dates on it is not a project plan. Here is what turns it into something you can manage a team against.

Percent complete

Add a fifth column for percent complete and a sixth column that calculates completed duration: =C2*E2. Add this as a third series in your stacked bar chart, formatted in a solid darker colour, sitting on top of the duration bar. Now anyone glancing at the chart sees exactly how far through each task you are, not just when it is supposed to happen.

Conditional formatting for overdue tasks

Add a column that checks =IF(AND(D2Weekends and working days

Do not use a straight +7 for a week. Use the WORKDAY function: =WORKDAY(B2,C2) instead of =B2+C2 for your end date, and Excel will skip weekends automatically. If your team works a specific set of bank holidays, list those dates in a separate column and reference them as the third argument in WORKDAY so those get skipped too.

The part nobody tells you about Excel Gantt charts

Here is the uncomfortable bit. An Excel Gantt chart does not know what a dependency is. If your development task slips by four days because the client sat on approval, the QA task underneath it does not automatically shift. You have to go in and manually update the start date on every task downstream of the delay. On a small project with seven tasks that is a two minute job. On a 40-task project with three parallel workstreams, it becomes a genuine chore, and it is exactly where people quietly stop updating the chart and it turns into a document nobody trusts by week three.

I have seen agencies build gorgeous Gantt charts for a client pitch, present them once, and then never open the file again because updating it by hand felt like admin rather than management. If that is you, the chart was never a planning tool, it was a slide. There is nothing wrong with that if you are honest about it, a lot of client-facing Gantt charts exist purely to make a proposal look organised. But if you are running the project week to week, you need either the discipline to update start dates every Friday, or you need to accept that at a certain size of project, Excel is the wrong tool and something with built-in dependency logic, like a proper project management tool, will save you more hours than it costs to learn.

When Excel is the right call and when it is not

Excel earns its place for projects under about 15 to 20 tasks, run by one person or a small team who already live in spreadsheets, with a timeline under three months. Beyond that, the manual update burden and the risk of a formula breaking when someone inserts a row in the wrong place start to outweigh the fact that it is free.

I still use Excel for client-facing timelines because a Gantt chart someone can open without a login is more useful in a client meeting than a link to software they have never seen before. For internal team management on anything with real interdependencies, I have moved to proper tools. Both things are true at once.

A shortcut if you do not want to build the formulas yourself

If the stacked bar chart method above feels like more setup than you want, Microsoft has a downloadable Gantt chart template built into Excel itself. Go to File, New, and search "Gantt chart" in the template search box. It gives you the invisible-bar trick already built and formatted, though you will still need to add your own conditional formatting for overdue tasks and your own WORKDAY formulas if you want weekends handled correctly. It is a good starting point if this is a one-off project rather than something you will be maintaining monthly.

If you are running enough projects that you are rebuilding this chart every month, it might be worth talking to someone about where automation and AI tools can take that admin off your plate entirely, which is exactly the kind of thing I cover with clients through AI implementation coaching, where we look at which parts of your project admin can run themselves.

Frequently asked questions

Can I build a Gantt chart in Excel without any add-ins?

Yes. The stacked bar chart method uses only native Excel features available since Excel 2013, no add-ins or plugins required. You need a data table with start dates and durations, a stacked bar chart, and one formatting trick to make the start-date series invisible.

How do I make my Excel Gantt chart update automatically when dates change?

Use formulas rather than typed dates wherever possible, such as =B2+C2 for end dates or =WORKDAY(B2,C2) to skip weekends. This makes the chart bars redraw automatically when you change a start date or duration, though dependent tasks further down the list still need manual adjustment since Excel has no built-in dependency logic.

What is the biggest limitation of using Excel for a Gantt chart?

Excel does not understand task dependencies, so when one task slips, every task that relies on it has to be updated by hand rather than shifting automatically. On projects with more than about 20 tasks or several parallel workstreams, this manual updating becomes enough of a burden that dedicated project management software usually saves more time than it costs to learn.

Is a free Excel Gantt chart template available?

Yes. Open Excel, go to File, then New, and search "Gantt chart" in the template box. Microsoft provides a built-in template using the same invisible-bar technique described in this guide, though you will still want to add your own conditional formatting for overdue tasks and WORKDAY formulas for weekends.

Sources worth reading

• Microsoft's own Excel documentation

Related reading: What Makes a Good Excel Checklist Template for Daily Tasks and What Is The Best Free Excel Template For Creating Price Quotations.