How to Create a Gantt Chart in Excel (Step-by-Step Guide + Practice Files)

• 🛠️ Build It
• 1️⃣ Data Table
• 📊 Stacked Bar
• ✨ The Magic Step
• 📅 Fix the Date Axis
• 📈 Progress Split
• 🔧 Troubleshooting
• ⬇ Practice File
• 💬 Comments

A Gantt chart is one of the most effective tools for project planning and management. It turns a list of tasks into a horizontal timeline, so you can see at a glance what runs when, what overlaps, and whether the schedule still holds.

Excel has no built-in Gantt chart type. What it has is a Stacked Bar Chart, and with one formatting trick — making the first data series invisible — that chart becomes a Gantt chart. This guide walks through the whole build, from a blank sheet to a finished timeline with progress bars and milestone markers.

How to Create a Gantt Chart in Excel

Steps 1 to 5 get you a working Gantt chart. Steps 6 to 8 are the formatting that makes it look like the ones you’ve seen in real project plans.

The completed chart you will build in this guide

• Prepare Your Data TableThree columns: Task, Start Date, and Duration in days.
• Populate the DataEnter your real tasks, owners, and progress percentages.
• Insert a Blank Stacked Bar ChartStart from an empty chart and add the Start Date series and task labels by hand.
• Add the Task Duration SeriesThis second series becomes the visible timeline bars.
• Reverse the Order and Hide the Start BarsThe single step that turns a bar chart into a Gantt chart.
• Fix the Date Axis BoundsRemoves the large empty gap before your first task.
• Delete the Legend and Widen the BarsTwo changes that account for most of the visual polish.
• Show Progress by Splitting the BarReplace Duration with Completed and Remaining segments, and colour by status.
• Troubleshoot Common ProblemsDates showing as numbers, bars upside down, nothing plotting.

Step 1: Prepare Your Data Table

A Gantt chart needs three columns: Task Name, Start Date, and Duration in days.

Two things to get right before building the chart, because both are painful to undo later:

Building a Gantt Chart with Start and End Dates

Most project plans record a start date and an end date, not a duration. Excel’s stacked bar chart can’t use an end date directly — it needs to know how long each bar is, not where it stops. So add a Duration column and calculate it:

= End_Date - Start_Date + 1

The + 1 is there so the start day itself is counted — a task running the 1st to the 5th is five days, not four. Leave it out and every bar renders one day short.

To count working days only and skip weekends, use NETWORKDAYS instead:

= NETWORKDAYS(Start_Date, End_Date)

Add a third argument pointing at a list of holiday dates to exclude those too: =NETWORKDAYS(Start_Date, End_Date, Holidays_Range).

Keep both columns in your sheet. End dates stay readable for anyone reviewing the plan, and the duration column feeds the chart.

Here is the sample project we’ll build throughout this guide — a ten-task website redesign:

Notice that Frontend and Backend Development overlap. That’s deliberate — overlapping bars are exactly what a Gantt chart exists to reveal.

Duration is a formula: End Date minus Start Date plus one

Step 2: Populate the Data

Enter your real tasks and dates. You can add extra columns — Responsible Person, Progress %, Status — and they won’t interfere with the chart. Only the columns you explicitly select become chart series; the rest simply live alongside as your tracking log.

Keep tasks at a consistent level of detail. Mixing three-week phases with two-hour jobs in the same list produces a chart where the short bars are invisible.

The full data set, including the helper columns used in Step 8

Step 3: Insert a Blank Stacked Bar Chart

It’s tempting to select the Task and Start Date columns and insert the chart from there. Don’t. Excel guesses how to interpret a selection, and with an Excel Table it frequently guesses wrong — pulling the ID column in as a data series, or plotting tasks along the wrong axis. You then spend longer undoing its assumptions than building the chart by hand.

Start empty instead and tell Excel exactly what goes where.

1. Click any blank cell well outside your data — nothing selected from the table.
2. Go to Insert > Bar Chart > Stacked Bar. An empty chart frame appears.
3. Right-click inside the empty chart and choose Select Data.
4. Under Legend Entries (Series), click Add. For Series name click the “Start Date” header cell; for Series values select the ten start dates only, without the header.
5. On the right, under Horizontal (Category) Axis Labels, click Edit and select your ten task names — again, no header.
6. Click OK.

You should now see one set of bars, all running from the left edge, with the task names down the side. That’s correct at this stage — the start-date bars become invisible spacers in Step 5.

Insert > Bar Chart > Stacked Bar, then add the Start Date series and task labels by hand

Step 4: Add Task Duration to the Chart

Now add the second series — the one that becomes the visible bars. Same dialog as before:

1. Right-click the chart and choose Select Data.
2. Under Legend Entries, click Add again.
3. For Series name, click the “Duration” header cell.
4. For Series values, select the ten duration numbers — not the header.

The axis labels you set in Step 3 carry over. You only ever set those once.

Duration is added as a second series, below Start Date

Step 5: Reverse the Order and Hide the Start Date Bars

This is the step that turns a bar chart into a Gantt chart.

1. Reverse the task order. Right-click the vertical axis showing task names, choose Format Axis, and tick Categories in reverse order. Excel plots categories bottom-up by default, so your first task starts at the bottom; this flips it so the project reads top to bottom.
2. Make the start bars invisible. Click any bar in the first series — the one anchored to the left edge. Right-click, choose Format Data Series > Fill > No Fill, and set Border to No Line as well.

The start-date bars are still there, holding each task’s position on the timeline. They’re just transparent, and that’s what creates the staggered Gantt effect.

No Fill on the Start Date series plus reversed category order creates the Gantt layout

Step 6: Remove the Empty Gap Before Your First Task

Your chart works now, but a large blank space probably sits on the left before the first bar. Excel starts the date axis at zero — 1 January 1900 — so it’s plotting more than a century of nothing.

To fix it you need your project’s start date as a serial number:

1. Click an empty cell and enter your earliest project start date (here, 2026-09-01).
2. Format that cell as General. The date becomes a five-digit number. That’s Excel’s internal date serial.
3. Right-click the horizontal date axis and choose Format Axis.
4. Under Bounds, set Minimum to that number.
5. For Maximum, use your latest end date plus one day — 2026-11-17 in this example. See the note below for why.

The timeline now spans only your project. Under Units, set Major to 7 for weekly gridlines or 1 for daily.

Setting axis bounds removes the empty space before the first task

Step 7: Delete the Legend and Widen the Bars

Two quick changes account for most of the visual difference between a rough chart and a finished one:

• Delete the legend. It only names “Start Date” and “Duration,” and one of those is invisible. Click it, press Delete.
• Widen the bars. Right-click any visible bar, choose Format Data Series, and drag Gap Width down to roughly 20–40%. Excel’s default of 150% leaves thin bars floating in white space.

While you’re in Format Data Series, set the bar fill to a single flat colour rather than Excel’s default gradient — one colour reads better across a long timeline. Add a chart title, and turn on vertical gridlines under Chart Elements > Gridlines so bars can be traced back to dates.

Lower Gap Width thickens the bars; the legend is deleted

Step 8: Show Progress by Splitting the Bar

The chart you have now shows each task as one solid bar of its full duration. That’s fine if all you need is the schedule. To show how far along each task is, you split that single bar into two coloured segments — work done and work remaining — which stack end to end and add back up to the full duration.

If you took the shortcut at the end of Step 4 and already added Days Complete and Remaining, your bars are split already. Skip to the colouring note below.

Add two helper columns beside your data:

Days Complete = Duration * Progress
Remaining     = Duration - Days Complete

Days Complete plus Remaining always equals Duration, so the total bar length never changes — you’re only dividing it.

Now swap the series:

1. Right-click the chart and choose Select Data.
2. Select the Duration series and click Remove.
3. Click Add. Series name: the “Days Complete” header. Series values: the ten Days Complete figures.
4. Click Add again. Series name: the “Remaining” header. Series values: the ten Remaining figures.
5. Check the order top to bottom reads Start Date → Days Complete → Remaining. Use the arrows to fix it if not.
6. Click OK, then colour the two series: a solid dark shade for Days Complete, a lighter tint of the same colour for Remaining.

Each bar now reads as a progress bar in place — the dark portion is finished work, the pale portion is what’s left. A fully complete task shows as solid dark; a task not yet started shows as entirely pale.

Duration is replaced by two series that stack back to the same length

Colouring Individual Bars by Status

To make one task stand out — an overdue phase, a blocked task — colour that bar alone rather than the whole series. Click once on a bar to select its series, then click again on the same bar to select just that data point. Right-click, choose Format Data Point, and set the fill.

Apply this to the Remaining segment, since that’s the part that signals unfinished work. Red on a task whose end date has passed reads immediately as slipped.

Step 9: Troubleshooting Common Problems

Practice File for This Tutorial

One workbook with everything in it: the ten-task data set, the Duration, Days Complete and Remaining formulas already written, the axis bound helpers from Step 6, and the finished Gantt chart. Follow along on your own copy, or open the chart and click through its settings to see how each step was applied.

Download: Gantt Chart Excel Practice File (.xlsx)

Two Ways to Build a Gantt Chart in Excel

The stacked bar method in this tutorial is one of two approaches, and they behave quite differently once a project is actually running.

The chart method — what you’ve just built — produces a genuine Excel chart object. It’s the right choice when you need to paste the timeline into a slide deck or report, or when you want a graphic that scales cleanly at any size. The cost is that every change means going back into chart settings, and adding a task can mean re-checking axis bounds and series ranges.

The conditional formatting method uses coloured worksheet cells instead of a chart. Each cell in the timeline grid tests whether its date falls inside a task’s window and fills itself if so. Nothing to reformat when you add rows, no axis bounds to reset, and the whole plan stays editable as a normal spreadsheet. The trade-off is that it isn’t a chart object, so it doesn’t copy into PowerPoint as cleanly.

What the Chart Method Can’t Do

Two things are worth knowing before you commit to building charts for every project.

Milestone markers. Excel won’t combine a horizontal bar chart with a scatter series — bar is the one chart type excluded from combo charts. So the usual trick of overlaying diamond markers isn’t available here. The workaround is to give each milestone its own row with a duration of zero or one day and colour that bar differently, which works but takes a row rather than sitting on the timeline as a marker.

A “today” line. For the same reason, there’s no dynamic way to draw a vertical line at the current date. You can position a line manually with Insert > Shapes, but it won’t move on its own — you’d reposition it every time you open the file.

Both are straightforward with the cell-based approach, where a column can simply test =TODAY() and shade itself.

For a plan you’ll update weekly, conditional formatting is usually less work over time. For a one-off timeline that needs to look polished inside a document, build the chart.

If setting up these axis bounds and formatting rules is taking longer than the project itself, you can skip the manual build entirely — our pre-configured, macro-free Simple Gantt Chart Excel Template already has the timeline logic, progress tracking and milestone markers in place.

Found this guide useful, or got stuck on a step? Let us know in the comments.