Excel Gantt Chart: 3 Ways to Build One (2026 Guide)

By Ryan Kramer, founder of Wisegrid. Last updated September 2026.

Excel has no Gantt chart button. Every “Excel Gantt chart” you’ve ever seen is one of three workarounds: a stacked bar chart with its first series hidden, a grid of cells painted by conditional formatting, or a template someone else built using one of those two tricks. All three genuinely work, and this guide walks through each one step by step, including the part most tutorials skip: what each method can’t do, so you’re not surprised in week three of the project.

Quick transparency note: I’m the founder of Wisegrid, a spreadsheet-native project tool with a real Gantt view. The last section covers when to graduate off the Excel workaround, and it’s marked clearly. Everything before it is a straight Excel tutorial that works with no other product involved.

Key takeaways – Method 1 (stacked bar chart): best-looking output, ~10 minutes, good for status decks. Bars don’t live next to your task rows. – Method 2 (conditional-formatting grid): the timeline lives right beside your task list and updates as you edit dates. More setup, very maintainable. – Method 3 (template): fastest start. Grab our free one at /templates/excel-gantt-chart-template. – All three share hard limits: no task dependencies, no critical path, and every schedule shift is manual date math.

Before you start: set up the task table

Every method starts from the same simple table. Put it in columns A through D:

Two setup tips that prevent most Gantt-tutorial frustration:

1. Make End Date a formula, not a typed value: in D2, =B2+C2-1 (subtracting 1 so a 1-day task starts and ends the same day). If weekends shouldn’t count, use =WORKDAY(B2,C2-1) instead.
2. Confirm the date cells are real Excel dates (right-align by default), not text. A “date” typed as text is the number-one reason the chart methods below silently fail.

Method 1: the stacked bar chart, step by step

This is the classic. The trick: build a horizontal stacked bar chart where the first segment of each bar runs from the timeline’s start to the task’s start date, then make that first segment invisible. What remains looks exactly like a Gantt.

1. Select the Task and Start Date columns (A1:B6 in our example), hold Ctrl (Cmd on Mac), and also select the Duration column (C1:C6).
2. Insert > Charts > Bar > Stacked Bar. Excel draws each task as a bar with two segments: Start Date, then Duration.
3. Fix the task order: click the vertical (task) axis, press Ctrl+1 to open Format Axis, and check Categories in reverse order so the first task appears at the top. In the same pane, set Horizontal axis crosses: At maximum category so the date axis stays at the bottom.
4. Hide the first segment: click any Start Date segment once (that selects the whole series), then Format > Shape Fill > No Fill, and Shape Outline > No Outline. The floating Duration segments are now your Gantt bars.
5. Tighten the date axis: click the horizontal (date) axis, open Format Axis, and set Minimum to your project’s first date and Maximum to its last. Type them as dates; Excel converts them to serial numbers. Without this step the chart wastes half its width on empty time.
6. Clean up: delete the legend, shrink the gap width (click a bar > Format Data Series > Gap Width around 30 to 50 percent) so the bars read as a schedule, and title the chart.

Total time: about ten minutes. The output is presentation-grade, which is why this method owns the status-deck use case.

Where it falls short: the chart is a picture floating over your worksheet, not part of it. You can’t read a task’s bar next to its row, per-task coloring (say, by owner or status) means manually formatting individual data points, and every added task means re-checking the selected ranges and the axis bounds.

Method 2: the conditional-formatting grid

This method builds the timeline directly in the worksheet: one column per day (or week), one row per task, with conditional formatting painting a cell when that date falls inside the task’s date range. Your “chart” lives right next to your task list and repaints itself whenever a date changes.

1. Keep the task table from above in columns A through D.
2. In F1, enter the project’s first date. In G1, enter =F1+1, and fill right for as many days as the project needs. (For a weekly view, use =F1+7 and fill right; the formula in step 4 works unchanged.) Format the row with a short date format, and set the columns narrow, around 3 characters.
3. Select the timeline body: the rectangle from F2 to the last date column and last task row.
4. Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format, and enter: =AND(F$1>=$B2,F$1<=$D2) The mixed references are the whole trick: the date row is locked (F$1) and the start/end columns are locked ($B2, $D2), so every cell in the grid tests its own column’s date against its own row’s task.
5. Click Format > Fill, pick your bar color, and confirm. Colored bars appear across the grid, one per task.
6. Optional today-marker: add a second rule on the same range with the formula =F$1=TODAY(), a contrasting fill, and move it to the top of the rules list. You get a vertical today line that moves every day.

Why people who live in Excel prefer this one: it scales with your table (new task row, same formatting, instant bar), it repaints live as you edit dates, and you can stack extra rules for status coloring (for example, a rule keyed to a Status column that turns done tasks gray).

Where it falls short: a long project means very many narrow columns, horizontal scrolling gets old, and it’s a grid of colored cells rather than a chart you can drop into a slide. Printing a six-month daily view is nobody’s idea of fun; switch to the weekly variant for anything past a couple of months.

Method 3: start from a template

If you’d rather not build either version, use a template: the table, formulas, conditional-formatting rules, and a today-marker are already wired, and you just type tasks and dates.

We keep a free one, no email required, at /templates/excel-gantt-chart-template. It uses the conditional-formatting method under the hood (so it repaints live as you edit), includes the WORKDAY weekday variant, and has a pre-built weekly view for longer projects.

One honest warning about templates in general, ours included: a template inherits every limitation of the method it’s built on. It saves you the hour of setup; it does not give Excel abilities Excel doesn’t have. Which brings us to the section most tutorials leave out.

The honest limitations of every Excel Gantt

These apply to all three methods, because they’re limits of faking a Gantt in a spreadsheet rather than of any particular recipe:

• No dependencies. A real Gantt knows Build starts when Design finishes. In Excel, that relationship exists only in your head. You can chain start dates with formulas (=D3+1), but the chain is invisible, fragile, and breaks silently the first time someone types over a formula.
• No critical path. Excel can’t tell you which tasks actually determine your end date, which is the single most useful thing a real Gantt does when a deadline slips.
• Manual date math forever. When one task slips a week, you get to find and update every downstream date by hand. On a 40-task plan, this is the whole job.
• No assignment or workload view. Owners are just a text column; nobody can see that one person owns six overlapping bars.
• Sharing is screenshots. The “live” plan is whichever copy of the file was emailed most recently. Version drift is the default, not the exception.

None of this means Excel is the wrong choice. For a short project with one owner and a handful of tasks, an Excel Gantt is genuinely the right amount of tool. The limits start to bite at roughly the point where tasks depend on each other and more than one person edits the plan.

When to graduate to a real Gantt

Disclosure, as promised: Wisegrid is my product, so weigh this section with that in mind.

Wisegrid is a spreadsheet-native project platform, which matters here for a specific reason: your Excel Gantt is already rows of tasks and dates, and Wisegrid speaks rows. Import the same Excel file and the same rows become a real Gantt view:

• Dependencies with arrows: link Build to Design once, and when Design slips, Build (and everything downstream) reschedules itself. No more hunting date formulas.
• Critical path: one toggle highlights the chain of tasks that actually sets your end date.
• Still a spreadsheet: the grid behind the Gantt supports formulas with the [Column]@row syntax, so the calculated columns you built in Excel keep working as formulas rather than flattening to values, and Excel export gets you back out anytime.
• Sharing without file-emailing: view-only collaborators are free, so the team reads one live plan instead of six attachments.

Pricing is one plan at $19 per editor per month, and the 7-day trial needs no credit card, so the realistic path is: keep the template for small plans, and when a plan grows dependencies and co-editors, import that same file and see it as a real Gantt in a few minutes. If you’re evaluating the broader category first, our alternatives guide maps the landscape honestly.

FAQ

Does Excel have a built-in Gantt chart?

No. Excel has no native Gantt chart type. Every Excel Gantt is a workaround: a stacked bar chart with the first series hidden, a conditional-formatting grid, or a template built on one of those two techniques. Both workarounds are legitimate and covered step by step above.

How do I make a Gantt chart in Excel quickly?

Fastest: download a pre-built template (ours is free at /templates/excel-gantt-chart-template) and type your tasks and dates. Fastest from scratch: the stacked-bar method, about ten minutes: build a stacked bar chart from Task, Start Date, and Duration, set No Fill on the Start Date series, reverse the category order, and tighten the date-axis bounds.

Can an Excel Gantt chart show task dependencies?

Not really. You can chain dates with formulas so one task starts after another ends, but Excel draws no dependency arrows, computes no critical path, and won’t reschedule downstream tasks reliably when something slips. If dependencies are central to your plan, that’s the signal to move to a dedicated Gantt tool.

What’s the best free Excel Gantt chart template?

Any good one needs three things: end dates computed by formula (with a WORKDAY option for business days), conditional-formatting bars that repaint when dates change, and a today marker. Our free template at /templates/excel-gantt-chart-template includes all three plus a weekly view for longer projects, with no email gate.

How do I show weekends or a today line in an Excel Gantt?

With the conditional-formatting method, add extra rules on the same range: =F$1=TODAY() with a contrasting fill for a today line, and =WEEKDAY(F$1,2)>5 with a light gray fill for weekend shading. Order matters, so put the today rule above the bar rule in the rules manager.

---

Outgrew the workaround?

Import the same Excel file into Wisegrid and your rows become a real Gantt: dependency arrows, critical path, live sharing, with the spreadsheet still underneath. $19 per editor per month, viewers free.

Start the 7-day trial, no card – Free Excel Gantt template – Best Smartsheet alternatives

---

About the author Ryan Kramer is the founder of Wisegrid, a spreadsheet-native work platform built around a 1,000,000-cell-per-sheet grid, conflict-safe collaboration, and a real Gantt view with critical path. He writes practical guides for teams running projects out of spreadsheets. More from Ryan