How to Create a Gantt Chart in Excel

A Gantt chart in Excel shows project tasks as horizontal bars across a timeline. It is useful when you need to see sequencing, overlaps, milestones, and schedule risk more clearly than a normal task list allows.

The fastest route is to build a task table first, then use dates and durations to draw the timeline.

Step-by-step Gantt chart build

Step 1. Create the task table

Start with columns for phase, task, owner, start date, end date, duration, and status. Keep the table simple. If every row has a clear start and end date, the timeline will be much easier to maintain.

Use this duration formula if start date is in D2 and end date is in E2:

The +1 counts both the start day and the end day.

Step 2. Add timeline headers

Across the top of the timeline area, add dates or week-start labels. Weekly headers are cleaner for most project plans. Daily headers are useful only for short, detailed schedules.

Step 3. Fill bars with conditional formatting

If the timeline date is in H$1, the task start date is in $D2, and the task end date is in $E2, use a conditional formatting formula like:

Apply a fill color when the formula is true. Copy the rule across the timeline grid so each task becomes a visible bar.

Step 4. Add milestone rows

Milestones are usually single-date events, not long bars. Add rows for approval, launch, client review, inspection, or handoff dates and format them differently from normal task rows.

Step 5. Keep a tracker beside the timeline

A Gantt chart shows timing, but it does not replace ownership and blocker management. Use a project tracker when the team needs owner, priority, status, and next-step detail.

Common Gantt chart mistakes

When to start from a template

If you are building a project plan for construction, events, launch work, or client delivery, a blank Excel file is slower than a focused Gantt chart template. Industry variants like construction Gantt charts and event planner Gantt charts already account for approvals, vendors, inspections, and milestone-heavy work.

The Griddy way

Gantt charts are annoying to maintain because every date change can force timeline bars, milestones, and summaries to move together.

"Create a Gantt chart from this task list, group it by phase, add milestone rows, and highlight any tasks that run past launch week."

Griddy can build the timeline, apply the formulas, and update the schedule when dates or dependencies change.