How to Make a Gantt Chart in Excel

Does Excel have a Gantt chart?

No — Excel has no native Gantt chart type. The Insert Chart menu offers columns, bars, lines and pies, but nothing labeled "Gantt." The universal workaround is to take a stacked bar chart and make the first segment invisible, so the visible segments float at their start dates and line up like Gantt bars. Microsoft ships a few "Gantt project planner" templates on the New workbook screen, but those use the same trick (or conditional formatting) underneath. The steps below build one from scratch.

Step 1: Build a table with task, start, end & duration

On a blank sheet, create four columns: Task, Start, End, and Duration. Enter your tasks and real dates in Start and End, formatted as dates. Then compute Duration in days with a simple formula — if Start is in B2 and End is in C2, put =C2-B2+1 in D2 and fill it down. Excel stores dates as serial numbers, so the subtraction returns a plain number of days. The +1 is there because a task that starts and ends on the same day still takes one day — without it every bar draws a day short and a one-day task vanishes. A small example, with each task starting the day after its predecessor ends:

Task	Start	End	Duration
Research	Jul 1	Jul 5	5
Design	Jul 6	Jul 12	7
Build	Jul 13	Jul 26	14
Test	Jul 27	Aug 2	7
Launch	Aug 3	Aug 4	2

If you would rather treat End as the handover moment, so the next task starts on the same date, use =C2-B2 instead. Either convention works; mixing them is what produces a chart quietly one day out on every row.

Step 2: Insert a stacked bar chart

Select the Task and Start columns, then hold Ctrl and add the Duration column (leave End out — the chart needs only Start and Duration). Go to Insert → Charts → Bar → 2-D Stacked Bar. Excel draws two series stacked in each row. It will not look like a Gantt chart yet; that is expected. If Excel picks up the wrong data, use Select Data to confirm Start is series one and Duration is series two.

Step 3: Make the Start series No Fill

This is the key move. Click once on any Start segment to select the whole Start series, right-click and choose Format Data Series, open the paint-bucket (Fill) options, and set Fill: No Fill. The Start segments vanish, leaving each Duration bar floating at its correct start date. Suddenly it reads like a Gantt chart. If you also see a border, set Border: No Line so no outline remains where the invisible segment used to be.

Step 4: Reverse the task order

Excel plots the first table row at the bottom of a bar chart, so your tasks appear upside down. Fix it by clicking the vertical axis (the list of task names), right-click, choose Format Axis, and under Axis Options tick Categories in reverse order. Your first task jumps to the top and the list now reads top-to-bottom in the same order as your table. You will usually also want to tick "Horizontal axis crosses: At maximum category" in the same panel so the date axis stays at the top.

Step 5: Format dates & colors

Two finishing touches. First, the date axis usually starts at zero, leaving a big empty gap: click the horizontal axis, open Format Axis, and set the Minimum bound to your project's start and the Maximum to its end. Excel wants these as serial numbers — type the date in an empty cell, format it as General, and read the number off. Set a major unit (7 for weekly gridlines) and a clean date format. Then recolor the Duration series and delete the legend. You now have a working Excel Gantt chart.

A worked example: six tasks, then a slip

The five steps above are mechanical. What decides whether the file survives a real project is what the formulas are, and what happens to them when the plan changes.

Adding dependencies & % complete

This is where the limits show. Dependencies are not supported natively: there are no finish-to-start arrows, and Excel has no idea one task constrains another. The workaround, as above, is a formula in Start pointing at the predecessor's End, which handles a single chain. It cannot express start-to-start or finish-to-finish links at all, needs a hidden MAX() for two predecessors, and breaks silently when someone sorts the rows — sorting moves values but leaves relative references pointing at whatever now sits above.

Percent complete needs helper columns, and the instruction usually given for it is wrong. Adding a Progress series on top of Start and Duration makes each bar longer by the work already done — a task at 100% draws at twice its true length. The correct build uses three series and drops the plain bar-length one. With % Complete in column F, add Done as =E2*F2 and Remaining as =E2*(1-F2).

Chart Start, Done and Remaining in that order: Start on No Fill, Done dark, Remaining light. The two visible segments always sum to E, so each bar keeps its true calendar footprint and fills from the left as work progresses. Every added task then means re-checking the data range and the series order, which Excel will cheerfully rearrange when that range changes.

Automatic Gantt via conditional formatting

If you would rather avoid charts entirely, build a conditional-formatting Gantt in the cells. It is sturdier, because there is no chart object with a data range to fall out of date.

Keep the same table in A–E. Put a calendar across row 1 from column G: =B2 in G1, =G1+1 in H1, dragged right for the length of the project — 2 March to 1 June inclusive is 92 days, so out to column CT. Format the row as ddd and narrow the columns to about 20 pixels.

Select G2:CT7 with G2 as the active cell — that matters, because the formula is written from the active cell's point of view and offset for every other. Under Home → Conditional Formatting → New Rule → Use a formula, add three rules in this order:

1. =AND(G$1>=$B2, G$1<=$C2) — your bar colour. The mixed references are the whole trick: G$1 locks the row so each column reads its own date, $B2 locks the column so each row reads its own task's dates.
2. =WEEKDAY(G$1,2)>5 — light grey. Return type 2 numbers Monday as 1 through Sunday as 7, so >5 is exactly Saturday and Sunday. The default type 1 starts on Sunday and would shade the wrong two days.
3. =G$1=TODAY() — a coloured left border, giving you a today line.

Rules evaluate top down and the first fill wins, so the bar rule must sit above the weekend rule or every bar grows grey stripes on Saturdays. This updates the moment a date changes, prints cleanly, and tolerates inserted rows better than the chart — but milestones and progress still need manual rules, and it still knows nothing about dependencies.

What Excel does and does not give you

Both methods draw a perfectly respectable picture of a schedule. Neither of them schedules anything. That distinction is easy to lose once the bars look right, so here it is plainly:

Capability	Stacked-bar chart	Conditional formatting	A real scheduler
Weekends and holidays excluded	Yes, via WORKDAY	Yes, via WORKDAY	Yes, built in
Single FS chain reschedules	Yes, if Start is a formula	Yes, if Start is a formula	Yes
Visible dependency arrows	No	No	Yes
Two predecessors on one task	Only as a hidden MAX()	Only as a hidden MAX()	Yes
SS, FF and SF link types	No	No	Yes
Lag on a link, labelled	No — a bare +5 in a formula	No — a bare +5 in a formula	Yes
Critical path	No	No	Calculated
Float / slack per task	No	No	Calculated
Resource levelling	No	No	Yes
Over-allocation warning	No	No	Yes
Baseline & variance	Copy the columns by hand	Copy the columns by hand	Saved and compared
Survives inserting a row	Formulas must be retyped	Mostly	Yes
Survives sorting the rows	No — references follow position	No	Yes
Milestones as diamonds	Manual marker series	Manual rule	Yes

That is a specific claim, not a dismissal: a stacked-bar chart is a drawing of a schedule you worked out somewhere else. For a dozen tasks running roughly in a line that is sufficient, and the spreadsheet is the right tool. But the middle rows of that table are exactly what you get asked in a status meeting, and the file cannot answer any of it.

Free Excel template

If you just want a working file, start from our ready-made free Excel Gantt chart template. It already has the task table, the stacked-bar setup, reversed axis, and formatted dates in place — you drop in your tasks and dates and the chart updates. You can also browse the full template library for industry-specific plans like construction, marketing, and software.

The faster alternative — build online & export to Excel

The stacked-bar method works, but it is slow to set up and painful to change. If you want the Excel file without the busywork, build the chart in gantts.app first — free, no sign up, no download. You type tasks, drag bars and link dependencies, and it calculates the critical path automatically. Then export to Excel in one click (or PowerPoint, PDF, PNG). New to the format? Start with how to make a Gantt chart step by step.

Frequently asked questions