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

Excel does not have a native Gantt chart type. What Excel does have is a stacked bar chart that you can format to look like a Gantt chart, combined with a lot of manual work to make it behave like one. This approach works -- it's been used by project managers for decades -- but it comes with real limitations that become painful as your project grows.

This guide shows you exactly how to build a Gantt chart in Excel, including the most common stumbling blocks. It also tells you honestly where the Excel approach breaks down and what to use instead.

What You'll Build

A functional Excel Gantt chart with:

• Task names on the vertical axis
• A horizontal timeline across the top
• Color-coded task bars showing duration
• Dependency tracking (manual)
• A baseline you can update as the project changes

Step-by-Step: Building the Gantt Chart

Step 1: Set Up Your Data Table

In a new Excel worksheet, create a table with these columns:

Enter your tasks in rows. Your start dates should be actual calendar dates, not day numbers. This lets Excel's date axis work correctly.

Example:

Step 2: Insert a Stacked Bar Chart

1. Select your Task Name (column A), Start Date (column B), and Duration (column C) columns -- hold Ctrl to select non-adjacent columns.
2. Go to Insert > Charts > Bar Chart > Stacked Bar Chart.
3. Excel will generate a chart. It will not look like a Gantt chart yet.

Step 3: Configure the Axes

The chart needs two fixes to look right:

Reverse the task order (so tasks read top to bottom):

1. Click on the vertical axis (task names).
2. Right-click > Format Axis.
3. Check "Categories in reverse order."
4. Check "Maximum axis crosses at maximum category." This moves the horizontal axis to the top of the chart.

Set the horizontal axis to start at your project start date:

1. Click on the horizontal axis (dates).
2. Right-click > Format Axis.
3. Change "Minimum" from Auto to a fixed value. Enter the numeric equivalent of your start date. (In Excel, dates are stored as numbers. Your start date's number is visible if you format the cell as a number temporarily.)
4. Adjust "Maximum" similarly to match your project end date.

Step 4: Make the "Start" Bars Invisible

Your stacked bar chart has two series: Start Date (the left portion of each bar) and Duration (the right portion). The Start Date portion is a visual spacer -- it should be invisible.

1. Click on one of the Start Date bars (the left portion).
2. Right-click > Format Data Series.
3. Set Fill to "No fill."
4. Set Border to "No line."

Now only the Duration bars are visible, which creates the Gantt bar appearance.

Step 5: Format the Duration Bars

1. Click on a Duration bar.
2. Right-click > Format Data Series.
3. Set the fill color to your preferred task bar color. If you're color-coding by phase, you'll need to manually change the color of each task's bar individually (or use a macro).

Step 6: Add a "Today" Marker (Optional)

To add a vertical line showing today's date:

1. Add a new data series to your chart with a single X value of TODAY() and two Y values spanning the full height of the chart.
2. Change this series to a Line chart type (you'll use a combo chart for this).
3. Format the line as a dashed vertical line in a contrasting color.

This is one of the more technically fiddly steps and often requires some troubleshooting.

Step 7: Add Data Labels and Formatting

1. Add task name labels to the bars: right-click the Duration bars > Add Data Labels > select "Value From Cells" and point to column A.
2. Adjust the chart area to be wider -- Gantt charts need horizontal space.
3. Add gridlines for major date intervals (weekly, monthly) via Chart Design > Add Chart Element > Gridlines.

Feature Comparison: Excel vs. Dedicated Gantt Tools

The Real Limitations of Excel Gantt Charts

No automatic dependency cascading. This is the biggest one. In a real Gantt chart tool, if you move the start date of a predecessor task, all dependent tasks shift automatically. In Excel, you have to manually update every affected row. On a 20-task project with 15 dependencies, a single date change can require 10+ manual updates -- and if you miss one, your chart lies to you.

Formatting is fragile. Excel's chart formatting is stored separately from the data. Add a row, sort differently, or paste data over the range, and the chart formatting can break. You'll spend as much time maintaining the chart as you do updating the data.

Collaboration is awkward. Excel files shared via email create version conflicts. SharePoint and OneDrive help, but simultaneous editing of a complex chart is unreliable. External stakeholders -- clients, contractors -- cannot easily view the chart without Excel installed.

Scaling to 50+ tasks is painful. A 10-task Excel Gantt chart is manageable. A 50-task chart with phases, subtasks, and color-coding by owner becomes a full-time maintenance job. The chart area becomes cramped, label formatting breaks, and scrolling becomes tedious.

No milestone markers without workarounds. Excel doesn't have a milestone chart type. You can approximate milestones with a zero-duration bar and custom formatting, but it's another manual configuration step that breaks easily.

When Excel Is the Right Choice

Despite these limitations, Excel Gantt charts make sense in specific situations:

• You already have the data in Excel and need a quick visual for a one-time presentation. Building the chart takes an hour and serves its purpose.
• Your organization has no budget for other tools and Microsoft 365 is already licensed. The cost argument is real.
• The project has fewer than 15 tasks and no complex dependencies. At this scale, the manual maintenance overhead is acceptable.
• You need to embed the chart in a PowerPoint or Word document. Excel charts paste cleanly into other Office applications, which dedicated Gantt tools cannot match.

The Faster Alternative

For anything beyond a simple, static timeline -- especially projects with dependencies, shared with clients, or updated regularly -- a dedicated Gantt chart tool removes the manual overhead entirely. gantt-chart.io lets you build the same timeline that takes an hour in Excel in under two minutes, with automatic dependency cascading, a shareable link, and a today marker built in. No chart type workarounds, no formatting fragility, no version conflicts.

Frequently Asked Questions

Q: Does Excel have any Gantt chart templates?

Yes. Search "Gantt chart" in Excel's template gallery (File > New > search). Microsoft provides several pre-built templates that give you a starting structure. These still use the stacked bar approach and have the same fundamental limitations, but they save you the initial setup steps.

Q: Can I use conditional formatting instead of a bar chart for a Gantt chart in Excel?

Yes, and many people prefer this approach. You create a grid where each column represents a day (or week) and use conditional formatting to fill cells that fall within a task's start-to-end date range. This is more flexible for updating individual tasks but even more time-consuming to build initially.

Q: Can Google Sheets do the same thing?

Yes, Google Sheets can replicate the stacked bar chart Gantt chart approach with similar steps. Google Sheets has slightly better real-time collaboration than Excel, but the same fundamental limitations around dependency cascading and formatting fragility apply.

Q: How do I add percent complete to an Excel Gantt chart?

Add a "Percent Complete" column to your data table. You can create a second series in the stacked bar chart using the formula Duration * Percent_Complete to show a completion bar overlaid on the task bar. This works but requires careful series ordering and formatting to look correct.

---

Start building your project Gantt chart at gantt-chart.io: free, no account required.