Gantt Chart in Excel — 2 Methods: Free Template & Complete Guide (2026)

No dedicated Gantt tool? No problem. Excel can build a fully functional project timeline in two very different ways: a stacked bar chart (polished, presenter-friendly) or a conditional formatting grid (spreadsheet-native, auto-updating). This guide covers both methods from scratch, adds progress tracking, milestones, dependency logic, and ends with print-ready setup. Approximately 45 minutes start to finish.

Dr Waqas Rafique · Founder & CTO · PhD, Statistical Machine Learning
LinkedIn · About

What is a Gantt Chart?

A Gantt chart is a horizontal bar chart that maps project tasks against a timeline. Each task occupies one row; each bar’s left edge marks the start date and its length equals the duration. The result gives an immediate visual answer to two questions: what is happening right now, and how does each piece of work fit around everything else?

The format was systematised by Henry Laurence Gantt in the 1910s during his work on ship production for the US military in World War I. His insight was that scheduling decisions buried in tables were invisible to workers and supervisors alike; a horizontal bar aligned to a calendar made them legible to everyone. The approach spread quickly and has remained the dominant project visualisation format for over a century.

Essential elements of a Gantt chart

• Task list — the rows on the left, usually grouped by phase or deliverable
• Timeline — the x-axis, measured in days, weeks, or months depending on project length
• Duration bars — horizontal bars where width = duration and position = start date
• Milestones — zero-duration markers (a diamond shape) for key deliverables or approvals
• Dependencies — arrows connecting tasks that must finish before another can start (Finish-to-Start)
• % Complete — a shaded portion of the bar showing how much of the task is done
• Today marker — a vertical line showing the current date for at-a-glance schedule health

When to use a Gantt chart

Gantt charts are best suited to project planning (product launches, software sprints, construction phases), marketing campaigns (coordinating creative, media buying, and reporting timelines), event management, and any work where multiple parallel or sequential streams need to be visible on a shared timeline. They are less useful for recurring operational work with no end date, or for displaying resource utilisation across many concurrent projects simultaneously.

Excel Gantt limitations vs dedicated tools

Excel Gantt charts are free and universally accessible — every stakeholder can open the file with no software to install. The trade-offs: Excel has no native dependency arrows, no critical path calculation, no automatic resource conflict detection, and no real-time collaboration. For projects with more than 25 tasks spanning multiple teams and months, tools like MS Project, Asana, Monday.com, or Smartsheet provide better scalability. For projects that fit within a single spreadsheet, Excel is entirely sufficient and far easier to customise than any SaaS tool.

Setting Up Your Project Data

Before touching a chart or a conditional formatting rule, build a clean project data table. This table is the single source of truth for both Gantt methods. Garbage in, garbage Gantt out.

Required columns

Sample project data

Optional columns worth adding from the outset: Priority (High / Medium / Low), Notes (for scope changes and blockers), and a Baseline Start / Baseline End pair frozen at project sign-off. The baseline columns power a comparison overlay — planned vs actual — that is invaluable when stakeholders ask how far the project has slipped.

Method 1 vs Method 2 — Which Should You Use?

Live Interactive Gantt Preview

Edit task names, start dates, and durations below — the Gantt chart updates instantly. The red dashed line marks today’s date. Click + Add Task to add rows, or the ✕ button to remove them.

Step 1.Method 1 — Stacked Bar Chart Gantt

The stacked bar method is the classic Excel Gantt approach used in business presentations worldwide. The core idea: create two data series in a horizontal bar chart. The first series is invisible and positions each task bar at the correct start date. The second series is visible and shows the task duration. Together they simulate a Gantt chart with no specialised software.

1.1 Add the Days from Start helper column

In the column after your data (say column I), add the header Days from Start. In I2, enter:

Where B2 is the task’s start date and $B$2 is locked to the project start date (your first task row, absolute column and row). This returns the number of calendar days between the project start and this task’s start. Drag down for all task rows. The kickoff task returns 0; a task starting 10 days into the project returns 10. This small number is the invisible “padding” that pushes each visible bar to the right position.

1.2 Insert the stacked bar chart

Select columns A (Task Name) and B (Start Date) by clicking the column A header, then holding Ctrl and clicking column B. Go to Insert → Bar Chart → 2-D Stacked Bar. Excel creates a chart with Start Date as one bar and no duration series yet — the bars start at day 1 of Excel’s calendar (1 Jan 1900), which is wrong. We fix this in the next steps.

1.3 Add the Duration and Offset series

Right-click the chart → Select Data. You should see one series (Start Date). Click Add to add a second series. Name it Duration and set the Series Values to your Duration column (C2:C9). Click Add again for a third series named Offset, setting Series Values to your Days from Start column (I2:I9). Click OK.

Now rearrange the series order so Offset is first, then Duration. In the Select Data dialog, select the Duration series and click the up arrow until it is below Offset. The chart now shows Offset as the base bar and Duration as the stacked bar on top.

1.4 Make the Offset bars invisible

Click on the Offset bars in the chart (the left portion of each stacked group). Right-click → Format Data Series. Under Fill, select No Fill. Under Border, select No Line. The offset bars disappear. The visible Duration bars now appear to start at the correct relative positions within the project timeline.

1.5 Fix the horizontal axis minimum

Right-click the horizontal (value) axis → Format Axis. Under Axis Options, set Minimum to 0. Set Maximum to your total project span in days. Optionally, set Major Unit to 7 (weekly tick marks) or 14 (fortnightly). This ensures the axis starts exactly at day 0 with no wasted whitespace.

1.6 Reverse the category order

Right-click the vertical (category) axis → Format Axis. Check Categories in reverse order. By default Excel plots the last task at the top. Reversing puts your first task at the top and the last at the bottom, matching how humans read a project plan from kickoff to delivery.

1.7 Add duration data labels

Click the visible Duration bars. Right-click → Add Data Labels → Add Data Labels. Right-click a label → Format Data Labels. In Label Options, check Value and uncheck anything else. Change the label font to white (Home → Font → Colour) for contrast. Now each bar shows its duration in days.

Target output — what your stacked bar Gantt should look like

Step 2.Method 2 — Conditional Formatting Gantt

The conditional formatting approach builds the Gantt directly in the spreadsheet grid. Each column represents one day; each row is a task. A cell is coloured if its column header date falls within the task’s start-to-end range. The result looks like a calendar-grid Gantt and updates automatically whenever you change a date or duration.

2.1 Set up the date header row

On a new sheet, place task names in column A. In cell B1, enter your project start date. In C1, enter:

Drag across as many columns as your project spans (30 days = 30 columns to the right of your task name column). Select the entire header row and format as Short Date (Ctrl+1 → Date). Reduce column width to 25–30px. At this width the date label abbreviates, but the colour fills communicate the timeline clearly.

2.2 Apply the core conditional formatting rule

Select the entire grid area (e.g. B2:AJ10 for 35 days and 9 tasks). Go to Home → Conditional Formatting → New Rule → Use a formula to determine which cells to format. Enter:

Where B$1 is the date header (row locked, column relative), $C2 is task start date (column locked, row relative), and $D2 is task end date. This returns TRUE whenever the column date falls within the task’s range. Set fill to violet. Click OK.

2.3 Add the Today marker

Add a second conditional formatting rule with higher priority than the task bar rule. In the Rule Manager (Manage Rules), add a new rule with this formula:

Set the fill to red or orange. Drag this rule to the top of the Rule Manager so it takes priority over the violet task bar colour. The today column now shows red across all rows — even rows where a task bar is running — giving an immediate visual pulse on where the project stands relative to the current date.

2.4 Grey out weekends

Add a third rule, below the task bar rule (lowest priority):

Mode 2 sets Monday=1, so Saturday=6 and Sunday=7. The formula returns TRUE for both. Set fill to a dark grey (#1a1a2e). Now non-working days are visually de-emphasised across the entire chart. If your project works 7 days a week (retail, events, construction close-out), skip this rule.

2.5 Add milestone markers

For milestone rows (single-day tasks with special significance), add a formula in the date cells that places a visible marker. In a milestone row, in the body cell formula enter:

Apply a separate conditional formatting rule for milestone rows: =AND(B$1=$C2, $I2="Milestone") (where I2 is a Type column with the value “Milestone”) and set fill to gold / amber. The diamond character appears at the exact milestone date with a distinct background.

Step 3.Adding Dynamic Date Headers

Static date headers mean every time the project start date changes, you manually re-enter all header dates. A named range and a single formula eliminates this completely.

3.1 Create a ProjectStart named range

Go to your Settings sheet (or any reference cell). Click the cell holding the project start date. In the Name Box (top-left where the cell address shows), type ProjectStart and press Enter. This creates a workbook-level named range.

3.2 Dynamic header formula

Replace your B1 header with:

Replace C1 and all subsequent headers with:

Now changing the ProjectStart date on your Settings sheet cascades to every column header, which in turn shifts every conditional formatting bar automatically. The entire Gantt re-renders from a single cell change.

3.3 Add week number labels

Insert a row above the date headers. In the week number row (say row 1, with date headers now in row 2), enter:

Drag across all columns. Apply a conditional formatting rule to highlight Mondays: =WEEKDAY(B$2,2)=1 with a subtle background so week boundaries are visually clear without being distracting.

3.4 Month header labels

Insert another row above week numbers for month labels. Use this formula to show the month name only on the first day of each month:

This shows “Jun 2026” only in the column corresponding to 1 June and leaves other cells blank. Merge across the month’s cells (carefully, as merging can interfere with conditional formatting references) or simply allow the label to overflow visually into adjacent blank cells.

Step 4.Tracking Progress

A Gantt chart without progress tracking shows only the plan, not the reality. Adding a % Complete overlay turns your Gantt into a live status dashboard that immediately reveals slippage.

4.1 The two-layer conditional formatting approach

With % Complete values in column F (as decimals: 0.40 = 40%), add a second conditional formatting rule above your standard task bar rule. This fills the completed portion of each bar in a darker violet:

Breaking down the right-hand side: $C2 is the start date; $D2-$C2 is the total duration in days; multiplied by $F2 (the fraction complete) gives the number of completed days; adding back to start gives the “progress end date.” A 10-day task at 40% complete shows the darker bar up through day 4.

Set the completed portion fill to deep violet (#7c3aed) and the planned portion (from the original rule) to lighter violet (#a855f7 at reduced opacity). Give the completed rule higher priority in the Rule Manager. The two-tone bar communicates at a glance: dark = done, light = remaining.

4.2 Project-level overall progress

Add a summary cell on your Settings or header sheet:

This is a duration-weighted completion: a 10-day task at 50% complete contributes proportionally more to the overall percentage than a 1-day task at 100%. Format the result as a percentage and wrap it in a prominent header cell above the Gantt for immediate project health visibility.

4.3 Milestone tracking

Milestone rows have Duration = 0 (or 1). Set % Complete to 0 (upcoming) or 1 (passed). Use an additional conditional formatting rule for milestone rows:

Set this to gold fill for upcoming milestones, and a separate rule with $F2=1 in green for passed milestones. At a glance, you can see which milestone gates are approaching and which have cleared.

Step 5.Adding Dependencies

Excel cannot draw dependency arrows, but you can make the spreadsheet enforce Finish-to-Start logic. When the predecessor task’s duration changes, the dependent task’s start date shifts forward automatically — cascading through the entire project plan.

5.1 Add a Depends On column

In column H, add the header Depends On. For each dependent task, enter the predecessor task name exactly as it appears in column A (e.g. Requirements Gathering). Leave blank for parallel tasks and the first task.

5.2 Calculated Start formula

Add a Calculated Start column (column J or next available). In J2, enter:

This formula scans the End Date column for the row where Task Name matches the Depends On value, returns that end date, and adds 1 day to get the start of the dependent task. If no match is found (empty Depends On or no matching name), it falls back to the project start date.

Now update column B (Start Date) to reference column J instead of containing hard-coded dates. Or keep B as the manual override and use J only as a validation check — highlight discrepancies in red using a conditional formatting rule =$B2<>$J2.

5.3 Visual dependency indicator

Excel cannot draw arrows between bars in a conditional formatting Gantt. The practical workaround: add a thin connector using Insert → Shapes → Elbow Connector. Draw it between the end of the predecessor bar and the start of the dependent bar. These shapes float above the grid and do not move when dates change, so treat them as cosmetic additions for printed or exported snapshots only — not for living trackers.

Step 6.Making Your Gantt Print-Ready

A Gantt that looks great on screen but prints across seven landscape pages is not ready to share with a client or senior stakeholder. These settings produce a clean, controlled printout.

6.1 Landscape orientation and scale

Go to the Page Layout tab. Set Orientation to Landscape. In the Scale to Fit group, set Width to 1 page and Height to Automatic. Excel scales everything horizontally to fit one page wide, using as many vertical pages as needed.

6.2 Freeze panes

Click cell B2 (first task row, first date column intersection). Go to View → Freeze Panes → Freeze Panes. This freezes the task name column and header rows. When you scroll right to see later dates on screen, task names stay visible. When the file prints across multiple pages wide, the task column repeats on each printed page.

6.3 Define a print area

Select only the range you want to print: task name column and date columns, but not helper columns (offset, calculated start, depends on). Go to Page Layout → Print Area → Set Print Area. Only this region prints. To clear: Page Layout → Print Area → Clear Print Area.

6.4 Hide helper columns

Select helper columns (Days from Start, Calculated Start, Depends On). Right-click → Hide. They remain active in formulas but are invisible on screen and in print output. Unhide: Home → Format → Hide & Unhide → Unhide Columns.

6.5 Add a project header

Insert 3 rows at the top of your Gantt sheet. Add: project name (font size 14, bold), version number and date prepared (small, grey), and optionally a company logo. Go to Page Layout → Print Titles and add the header rows to “Rows to repeat at top” so the date row header appears on every printed page. Use Insert → Header & Footer to add a print date and page number in the footer.

Gantt Chart Best Practices for Excel

The difference between a Gantt that helps and a Gantt that confuses is almost always in how consistently it is maintained. These practices come from years of project planning work across product launches, software builds, and marketing campaigns.

• Cap at 20–25 tasks per sheet. Beyond this threshold, the chart becomes cluttered and the complexity warrants a dedicated PM tool. Break large projects into phases with separate Gantts per phase and a roll-up summary Gantt at the top.
• Colour-code by phase. Discovery = blue, Design = violet, Development = indigo, Testing = orange, Launch = green. Consistent phase colours across all project files create instant visual fluency for team members who work on multiple projects.
• Keep task names under 30 characters. Long task names truncate or overflow the task column, resizing the chart layout and making printed output messy. Use a Notes or Description column for detail; the Gantt shows only the short label.
• Maintain a baseline snapshot. When the plan is signed off, copy your start and end dates into Baseline Start and Baseline End columns. Add a second set of conditional formatting rules to show the baseline bars in a lighter shade. Actual vs baseline slippage becomes immediately visible.
• Update % Complete weekly. Set a recurring Monday task to update completion percentages. A Gantt showing all tasks at 0% complete three weeks into the project is not a planning tool — it is a false confidence display. If teams resist updating, use a simpler RAG (Red/Amber/Green) status column instead of percentages.
• Version control date-stamped copies. Every time the schedule changes significantly, save a copy named Project_Gantt_2026-06-15.xlsx. This gives an audit trail when stakeholders ask when the delivery date was moved and why.

Gantt Chart Templates by Use Case

The same Excel Gantt structure works across industries. The task list and phase structure are the only things that change. Below are the four most common use cases with recommended phase breakdowns.

Marketing campaign Gantt

Software sprint Gantt

For a 2-week sprint, each task maps to a user story or feature. Use Task Name for the story title, Assigned To for the developer, and % Complete updated from your daily standup notes. Sprint review and retrospective are milestone rows at the end of each sprint block. Use a separate tab for the release Gantt spanning multiple sprints with milestone markers at each release boundary.

Construction project Gantt

Construction Gantts typically span months — switch date columns from days to weeks (each column = 7 days). Phases: Site Preparation, Foundation, Structure, MEP (Mechanical / Electrical / Plumbing), Finishes, Commissioning, Handover. Construction has heavy dependency chains; the MAXIFS formula is essential here. Add a Weather Risk row with float (buffer days) shown as a lighter bar colour.

Event planning Gantt

Work backwards from the event date. Major task streams: Venue (book, confirm, logistics walkthrough), Catering (brief, quote, confirm, pre-order), Entertainment (research, contract, technical briefing), Marketing (invitations, social content, PR pitches), Day-of logistics (run sheet, staff briefing, setup, breakdown). Milestones: contract signing deadlines, RSVP cutoff, final headcount, technical rehearsal sign-off.