How to Make a Gantt Chart in Excel (2026 Guide)
Home›Excel Charts›Make a Gantt Chart
ExcelHow-To⏱ 4 min read

How to Make a Gantt Chart in Excel (2026)

Excel has no native Gantt chart, but you can build a clean one from a stacked bar chart in five steps. This guide walks through the whole build — from data setup to formatting for presentation.

⚡ Quick Answer

Set up 3 columns: Task, Start date, Duration. Insert stacked bar chart. Format the Start series with No Fill (invisible). Reverse the Y-axis so tasks read top-down. Done.

Step 1: Set up the data

Three columns:

Task                Start        Duration
Research            2026-01-01   14
Design              2026-01-15   21
Development         2026-02-05   35
Testing             2026-03-12   14
Launch              2026-03-26   7

Duration is in days. If you have Start and End dates, compute Duration with =EndDate - StartDate.

Step 2: Insert a stacked bar chart

  1. Select the range

    Include headers and all three columns.

  2. Insert tab → Bar chart icon → Stacked Bar

    Note: bar, not column. Bar = horizontal, which is what we need.

  3. Excel inserts a stacked bar chart

    Two series stacked: Start (which we'll make invisible) and Duration (which becomes the visible bar).

Step 3: Make the Start series invisible

The Start series is only there to push the visible bars to the right position on the timeline. Make it invisible.

  1. Click a Start series bar

    Selects the whole Start series.

  2. Right-click → Format Data Series

    Panel opens on the right.

  3. Fill → No Fill

    Series becomes invisible.

  4. Border → No Line

    Removes any outline.

Step 4: Reverse the Y-axis order

By default Excel puts the first task at the bottom. Gantt charts read top-down.

  1. Right-click the Y-axis (task labels)

    Format Axis panel opens.

  2. Tick "Categories in reverse order"

    Under Axis Options.

  3. Y-axis flips

    First task is now at the top. Tasks read chronologically top-to-bottom.

Step 5: Format the X-axis as dates

The X-axis probably shows numbers (Excel serial dates). Format them properly.

  1. Right-click X-axis → Format Axis

    Panel opens.

  2. Set minimum bound

    Set to your project start date (or a bit earlier). Enter as a date; Excel converts to serial number.

  3. Set maximum bound

    Project end date or a bit later.

  4. Number format → Date

    Format code: mmm dd or mm/dd for compact dates.

Step 6: Polish for presentation

Chart title

Rename to something descriptive: "Q1 2026 Product Launch Timeline"

Remove legend

Only one series is visible; the legend is useless. Delete it.

Add data labels (optional)

Click the Duration series → Add Data Labels. Format to show the task name or duration inside each bar.

Color code by category

Click a specific bar (second click on a specific data point). Change its fill color to categorize (e.g., research = blue, design = purple, dev = green).

Add a "today" line

To show current date on the timeline:

  1. Add a helper column with =TODAY() repeated for each task row
  2. Add that column as a new series to the chart
  3. Change it to a Line chart type
  4. Format the line vertical and colored

Showing progress on a Gantt

Add a fourth data column: =Duration * PctComplete. Add this as another stacked series.

Now each task has three stacked segments: invisible Start, completed portion (solid color), and remaining portion (lighter shade or hatched). Instant progress visualization.

Excel Gantts don't scale

Excel Gantts work well up to ~30-50 tasks. Beyond that, use Smartsheet, Microsoft Project, or a real PM tool. Excel's chart mechanics were never designed for enterprise project scheduling.

Save as a template

Once you build a Gantt that looks right, save it as a chart template (right-click chart → Save as Template). For future projects, right-click → Change Chart Type → Templates → your Gantt. Instant.

Excel Wizard

Gantt charts without the setup

The stacked-bar-with-invisible-Start trick is clever but tedious. Excel Wizard builds Gantt charts from task lists automatically — you provide tasks with start dates and durations, it structures the data, inserts the chart, and formats it. No manual bar-hiding required.

Install Excel Wizard →

Frequently asked questions

How do I make a Gantt chart in Excel?

Excel doesn't have a native Gantt chart. Build one from a stacked bar chart with two series — Start (invisible, no fill) and Duration (visible). The invisible Start series pushes each bar to the correct starting position.

What data do I need for a Gantt chart?

Three columns: Task name, Start date, and Duration (in days). Optional: End date, Assigned to, Status. Duration can be calculated from Start and End dates using =End-Start.

How do I add dependencies to an Excel Gantt chart?

Excel doesn't natively support Gantt dependencies. Workarounds: draw connector lines manually using Insert → Shapes; use conditional formatting to link related tasks; or switch to Smartsheet or a dedicated PM tool if dependencies are essential.

Can I show progress on a Gantt chart in Excel?

Yes. Add a third data series for completed duration (Duration × % Complete). Chart it as another stacked bar in a different color. You'll see the completed portion filled and remaining as a lighter shade.