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

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:

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?

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 the rows imply; after import, apply the schedule quality checklist. A published 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 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

1. Microsoft Support, Present your data in a Gantt chart in Excel
2. Microsoft Support, Work with the Gantt Chart view
3. U.S. Government Accountability Office, Schedule Assessment Guide