Skip to content
GanttPal
Log in Get started

How to Make a Gantt Chart in Excel: Template and Step-by-Step Guide

Excel has no dedicated Gantt chart type, but a stacked bar chart can be shaped into one in about 15 minutes. The approach below uses a small task table, hides the offset series, and formats the axis as dates. It suits smaller plans — roughly fewer than 50 tasks — where manual updates are manageable.

What an Excel Gantt chart is — and when it fits

A Gantt chart places each task as a horizontal bar against a calendar axis, so start, finish and length can be read at once. In Excel the visible bar is not drawn directly from the dates: an invisible Start Date segment pushes the visible Duration segment to the right position. That two-series trick is the core of the method.

Decision check before you start:

  • Use Excel when the plan is small, one-off, or already lives in spreadsheets, and the team is comfortable maintaining it.
  • Consider dedicated scheduling software when you need live collaboration, automatic dependency shifts, resource balancing, portfolio views, or frequent updates across many tasks.
  • Excel trade-offs to plan for: every change is manual, dependencies do not cascade, and sharing relies on file workarounds.

1. Set up the task table

Create four required columns: Task name, Start date, End date and Duration. Enter dates consistently as MM/DD/YYYY. Duration is calculated, not typed: in the first Duration cell enter =C3-B3+1, where C is End Date and B is Start Date, then copy it down. The +1 counts both the first and last day, so Monday to Friday returns 5 rather than 4.

Useful optional columns: % Complete (0–100%), Assigned to, Priority, Predecessors and Notes. For phases, insert a phase row above its tasks, give it the earliest start and latest finish of the group, and let Duration calculate as usual. A phase row then appears as a summary bar above its tasks.

2. Build the chart from a stacked bar

Select the table including headers, go to Insert, choose Column or Bar Chart, then 2-D Bar and Stacked Bar. Right-click the chart and open Select Data. Remove any default series, then add two series: one named Start Date using the Start Date column, and one named Duration using the Duration column. Set Horizontal (Category) Axis Labels to the Task Name column and click OK.

Next, hide the offset: click a Start Date segment, open Format Data Series, set Fill to No Fill and Border to No Line. Only the Duration segments remain visible, positioned by their start dates.

Finish the timeline formatting: right-click the vertical axis, open Format Axis and tick Categories in reverse order so the first task appears at the top. Right-click the horizontal axis, open Format Axis, set Number category to Date, and set bounds with a little padding — for example from the Sunday before the first start to the Saturday after the last finish — so bars are not clipped. For intervals, set Major unit to 7 for weekly or 30 for monthly, and optionally Minor unit to 1 for daily ticks.

3. Format for readability

Add a chart title via Chart Design, Add Chart Element, Chart Title, Above Chart, and name the project. Colour-code by clicking a bar twice to select a single task, then Format Data Point and apply a solid fill; brighter colours can mark priority and gold can mark milestones. Give phase rows a neutral grey fill so they read as dividers. Reduce Gap Width in Format Data Series to thicken bars, and add Primary Major Vertical gridlines if date alignment matters more than a clean look. A hand-drawn vertical line can mark today, but it must be moved manually. For long tables, freeze panes below the headers and right of the task column via View, Freeze Panes.

4. Add progress, milestones, dependencies and a dashboard

Progress inside the bars: add % Complete, then two numeric columns — Completed as Duration multiplied by % Complete, and Remaining as Duration minus Completed. Replace the Duration series with Completed and Remaining, ordered Start Date, Completed, Remaining. Shade Completed darker than Remaining so finished work reads instantly.

Progress in the table instead: select % Complete and apply Home, Conditional Formatting, Data Bars. For phase rows, a duration-weighted average using =SUMPRODUCT(DurationRange, PercentCompleteRange) / SUM(DurationRange) reflects larger tasks more fairly than a plain average.

Milestones: add a one-day row, colour it gold, and optionally place a diamond shape on it. Dependencies: add a WBS column — phases as 1, 2, 3, tasks as 1.1, 1.2, subtasks as 1.1.1 — and a Predecessor column holding the WBS number that must finish first. This documents relationships but does not shift dates.

Simple dashboard formulas to place above the table or on a separate sheet: total duration as =MAX(EndDateColumn) - MIN(StartDateColumn) + 1; overall completion as =AVERAGE(PercentCompleteColumn); days remaining as =MAX(0, MAX(EndDateColumn) - TODAY()); tasks complete as =COUNTIF(PercentCompleteColumn,1); tasks in progress as =COUNTIFS(PercentCompleteColumn,">0",PercentCompleteColumn,"<1"); tasks not started as =COUNTIF(PercentCompleteColumn,0).

5. Troubleshoot common issues

Dates showing as numbers such as 44562: right-click the horizontal axis, open Format Axis, Number, and change the category to Date.

Bars misaligned with dates: check axis bounds against the project dates, confirm consistent date formatting, and remove any text values from date columns.

Chart not updating: open Select Data, confirm ranges cover all rows, check for broken references, and ensure calculation is set to Automatic.

Printing cut off: clear the print area via Page Layout, Print Area, Clear Print Area, reselect the full range and set a new print area, then use File, Print scaling such as Fit Sheet on One Page.

Slow performance with 100+ tasks: limit conditional formatting, avoid volatile formulas such as NOW() or TODAY() where possible, and split the plan into smaller charts. Persistent lag is a sign the plan has outgrown a spreadsheet.

Template checklist and habits that keep it working

A template saves the setup work: look for prebuilt duration formulas, a Predecessor column, presentation-ready formatting, sample data, an expandable structure for up to about 100 tasks, a print-ready layout, and a dashboard with overall progress, task counts and days remaining. Replace the sample rows with your own tasks and dates, then extend the formulas and chart ranges as you add rows.

Keep the finished chart healthy: start with the basic version before adding extras, save dated versions so you can roll back, comment complex formulas, save a clean copy as a template for the next project, review it weekly, make sure teammates can update it, and test with sample data before relying on it.

Excel Gantt chart field map
ColumnPurposeHow to fill it
Task nameLabels each barClear, specific task description
Start datePositions the barDate as MM/DD/YYYY
End dateSets the finishDate as MM/DD/YYYY
DurationSets bar lengthFormula =C3-B3+1 copied down
% CompleteTracks progressValue from 0% to 100%
PredecessorNotes dependenciesWBS number of the prior task

Required columns first; optional columns only if you will maintain them.

Frequently asked questions

Is there a Gantt chart template in Excel?

Excel itself offers only simple timeline files, not a full interactive Gantt chart. A downloadable template with formulas, formatting and sample data is the practical way to start with a ready-made structure.

How do I make a weekly Gantt chart in Excel?

Format the horizontal axis, open Axis Options, and set the major unit to 7 so labels step by week.

How do I make a monthly Gantt chart in Excel?

Use the same axis setting with a major unit of 30. That approximates months, although real months vary in length.

How do I add milestones to a Gantt chart in Excel?

Add a separate row with a one-day duration, then make it stand out with a gold fill or a diamond shape. A diamond is presentation-friendly but will not move on its own if dates change, so a one-day bar is easier to maintain.

How do I track task progress in Excel?

Add a % Complete column, then either split each bar into completed and remaining segments or apply data bars to the % Complete cells in the table.

Can Excel automatically adjust dependencies in a Gantt chart?

No. Excel does not recalculate task dates when a predecessor changes. You can note predecessors with WBS references for reference, but dates must be edited manually.