---
title: "How to Make a Gantt Chart in Excel (Step-by-Step, No Add-In) | GanttFather Blog"
description: "Excel has no built-in Gantt chart type, but you can create one from Task, Start, and Duration columns by formatting a stacked bar chart and hiding the Start series."
canonical: "https://ganttfather.com/article/how-to-make-gantt-chart-in-excel/"
locale: "en"
category: "methodology"
---

# How to Make a Gantt Chart in Excel (Step-by-Step, No Add-In) | GanttFather Blog

# How to Make a Gantt Chart in Excel (Step-by-Step, No Add-In)

 Excel has no built-in Gantt chart type, but you can create one from Task, Start, and Duration columns by formatting a stacked bar chart and hiding the Start series.

 ![](https://ganttfather.com/logo.png) GanttFather

 Updated August 7, 2026 9 min read

 Tags

 excel gantt-chart spreadsheet how-to

 The short answer

 Excel has no built-in Gantt chart type, but you can create one from Task, Start, and Duration columns by formatting a stacked bar chart and hiding the Start series.

## Can you make a Gantt chart in Excel?

 Yes. **Excel does not include a native Gantt chart type**, but you can simulate one with a stacked bar chart. The invisible first series offsets each task to its start date; the visible second series shows task duration. This works well for a small, presentation-oriented schedule. It does not automatically become a dependency-aware scheduling engine.

## What data do you need?

 Create a table with at least three columns:

 Task Start Duration (days)

 Confirm scope 2026-08-10 2

 Design solution 2026-08-12 5

 Build 2026-08-17 7

 Test 2026-08-24 4

 Launch 2026-08-28 1

 Use real Excel date values, not text that merely looks like a date. If you have start and finish dates instead of duration, add a Duration column with:

 =FinishCell-StartCell

 For inclusive day counts, use =FinishCell-StartCell+1 . Decide which convention you use and apply it consistently.

 If the project observes weekends, the more useful formula is:

 =NETWORKDAYS(StartCell,FinishCell,HolidaysRange)

 That calculates working days between the two dates, with an optional holiday list.

## How do you build the chart?

### Step 1: Select the source data

 Select the Task, Start, and Duration columns, including headers. Keep the range contiguous if possible.

### Step 2: Insert a stacked bar chart

 Choose **Insert → Bar Chart → Stacked Bar**. Do not choose 100% Stacked Bar; duration needs its real scale.

### Step 3: Hide the Start series

 Select the bars representing Start. In **Format Data Series**, set Fill to **No Fill** and Border to **No Line**. The series still supplies the horizontal offset but becomes invisible.

### Step 4: Reverse task order

 Excel often places the first task at the bottom. Select the vertical task axis, open **Format Axis**, and enable **Categories in reverse order**.

### Step 5: set the date range

 Format the horizontal axis. Set its minimum bound near the project start and maximum near the finish so empty months do not compress the useful chart. Apply a readable date format such as d-mmm .

### Step 6: format the duration bars

 Reduce Gap Width, choose one restrained color, and add data labels only if they help. Use a second color for critical or late work only when you can maintain that meaning reliably.

### Step 7: add today and milestone cues carefully

 Excel does not supply Gantt milestones or a today line automatically. You can add shapes, another data series, or conditional formatting in a grid-based version, but each workaround increases maintenance. If the chart will be edited weekly, document how those elements update.

 Microsoft’s official procedure follows the same core pattern: create a stacked bar chart, hide the Start series, and reverse task order.

## How do you make a formula-driven Gantt grid instead?

 For an editable planning sheet, a date grid can be easier than a chart. Put dates across row 1 and tasks down column A. Use conditional formatting on the grid with a formula like:

 =AND(DateHeader>=TaskStart,DateHeader<=TaskFinish)

 For example, if date headers begin in E$1 , Start is column B , and Finish is column C , apply this formula to the schedule grid:

 =AND(E$1>=$B2,E$1<=$C2)

 Add another rule for today:

 =E$1=TODAY()

 This version is easier to extend with status colors and weekly columns, but it remains a visual grid. It will not calculate a critical path unless you build and maintain substantial scheduling logic.

## How can Excel represent dependencies?

 Add columns such as ID, Predecessor ID, Dependency Type, and Lag. That records the logic, but formulas to propagate four dependency types, working calendars, hierarchy, constraints, and cycles become complex quickly.

 For a small finish-to-start chain, you can calculate a successor’s earliest start as the predecessor finish. Once a task has multiple predecessors, use the latest predecessor finish. Once parallel branches, lags, or non-working days appear, a purpose-built scheduler is safer.

 **Decision rule:** If moving one task should automatically reschedule several others, Excel is acting as a database and scheduling engine—not only a chart. That is usually the point to use Gantt software and keep Excel for import, export, or reporting.

## When is Excel the right choice?

 Excel is a good fit when:

- the schedule has fewer than roughly 30–50 tasks;

- one person maintains it;

- dependencies are minimal;

- the output is a static status slide or printable page;

- everyone already works in the same workbook;

- advanced collaboration and audit history are unnecessary.

 Use dedicated software when:

- several people edit simultaneously;

- dates must react to dependencies;

- you need critical path or float;

- the plan contains parent/child hierarchy;

- resources are shared across overlapping tasks;

- permissions, version history, or auditability matter;

- an API or AI agent must read and update the schedule.

## When should you move an Excel Gantt chart to GanttFather?

 Need Excel workaround GanttFather

 Draw task bars Stacked bar or conditional formatting Native interactive timeline

 Move linked work Manual formulas or edits Dependency-aware scheduling

 Four dependency types Custom model Native FS, SS, FF, SF with lag

 Critical path Custom calculation Built-in visual toggle

 Multiple live editors Coauthoring, with formula risk Real-time project collaboration

 Kanban and Gantt Separate sheets Same tasks, synchronized views

 AI agent access Custom script/API layer Native MCP server

 Spreadsheet exchange Native Excel import and export

 You do not have to choose permanently. A common workflow is to collect or clean rows in Excel, import them into GanttFather for connected scheduling, and export a snapshot when a stakeholder needs a workbook. Before import, decide which [dependency relationships](https://ganttfather.com/article/gantt-chart-dependencies-types/) the rows imply; after import, apply the [schedule quality checklist](https://ganttfather.com/article/project-schedule-quality-checklist/). A published [software release timeline](https://ganttfather.com/templates/software-release-timeline/) provides a concrete structure to compare with your sheet.

 After import, verify task names, hierarchy, dates, and owners before adding FS, SS, FF, or SF links and lag. GanttFather can then recalculate linked work and highlight the critical path, but it does not automatically resource-level overlapping assignments.

 [Create a free GanttFather project and import your Excel plan](https://ganttfather.com/) when maintaining the dependency formulas is harder than maintaining the schedule.

## Frequently asked questions

### Does Excel have a Gantt chart template?

 Microsoft provides Gantt templates, but Excel still does not have a dedicated Gantt chart object. Templates use charts or formatted cells to simulate the view.

### Can an Excel Gantt chart update automatically?

 Bars update when their source Start and Duration values change. Dependencies and downstream dates update only if you build formulas or automation for them.

### How do I show progress?

 Add a Percent Complete column and a second visible series for completed duration, or use separate conditional-formatting rules. Keep the calculation tied to typed progress values rather than manually recoloring bars.

### Can I import an Excel plan into GanttFather?

 Yes. GanttFather supports an Excel round trip. Review task-name indentation, dates, owners, and field mapping during import, then add or confirm schedule dependencies in the project.

 **Sources**

- [Microsoft Support, Present your data in a Gantt chart in Excel](https://support.microsoft.com/en-us/excel/present-your-data-in-a-gantt-chart-in-excel)

- [Microsoft Support, Work with the Gantt Chart view](https://support.microsoft.com/en-us/project/work-with-the-gantt-chart-view)

- [U.S. Government Accountability Office, Schedule Assessment Guide](https://www.gao.gov/products/gao-16-89g)

 ![](https://ganttfather.com/logo-hero.png) Want to skip the reading?

 GanttFather is free forever &mdash; no card, no trial.

[Start free](https://app.ganttfather.com/login)

 Need help?

 Reach out to our team &mdash; we're happy to help.

support@ganttfather.com

 Next up

 [Methodology Asana vs Spreadsheets: When to Stop Managing Projects in Excel](https://ganttfather.com/article/asana-vs-spreadsheets-project-management/)[Methodology What Is the Critical Path Method (CPM) and Why Does It Matter?](https://ganttfather.com/article/critical-path-method-guide-project-management/)[Methodology Dependency Management in 2026: How to Contain Scope Creep](https://ganttfather.com/article/dependency-management-2026-prevent-scope-creep/)

 ![](https://ganttfather.com/logo-hero.png) GanttFather

 The Don of Project Management

 Every feature included &mdash; Gantt, Kanban, dependencies, critical path, real-time sync, Excel and AI agents. Free tier includes 1 project you own, 2 editor seats, and unlimited viewers and guests.

[Start free](https://app.ganttfather.com/login)