Gantt Chart Template Excel for Tasks: How to Build One

Charts & pivot tables · Updated November 20, 2026

For a simple Gantt chart template in Excel, list each task with its start and finish dates, then create a row of calendar dates and use conditional formatting to shade the cells that fall within each task’s date range. In Microsoft Excel for Microsoft 365 on Windows, this creates a reusable task schedule without a special add-in; the steps below show a practical layout, the rule to use, and ways to adapt it.

What an Excel task Gantt chart shows

A Gantt chart lays tasks against a timeline. Each task occupies a row, and a horizontal bar shows when it is scheduled to begin and end. This makes the sequence and overlap of work easier to scan than a plain list of dates. It is useful for a project plan, an event checklist, a product launch, or personal work with several tasks and deadlines.

An Excel Gantt chart made with cells is a visual schedule, not a project-management system. It will not automatically know that one task depends on another or reschedule later work when a date changes. You update the task dates yourself, and the colored bars respond to those dates. That can be a good fit when the plan is modest and a familiar spreadsheet is enough.

A simple template layout

Set up the first six columns for task information and use column G onward for the calendar. Put headings in row 1 and task details in rows 2 through 20, or extend the range for a larger plan:

  • A — Task: a short, specific activity such as “Draft outline.”
  • B — Owner: the person responsible, if the plan is shared.
  • C — Start: the planned first date.
  • D — Finish: the planned last date.
  • E — Duration: the number of calendar days, if useful.
  • F — Complete: a percentage such as 0%, 50%, or 100%.
  • G onward — Timeline: one date per column, beginning with the first date in the plan.

Use actual Excel dates in columns C, D, and the timeline, rather than text that only looks like a date. Select the date cells and use Home > Number Format to choose a date display. The display can be brief, such as “1-Jun,” while the underlying value remains a date Excel can compare. Format column F as Percentage and enter values such as 50% rather than the number 50.

Build the timeline and duration

Enter the earliest date you want to show in G1. For example, if the schedule starts on June 1, 2026, enter that date in G1. In H1, enter the following formula, then copy it to the right to fill the remaining calendar headings:

With G1 holding the first timeline date, enter this in H1: =G1+1. It returns the next calendar date; copying it right advances the timeline by one day in each column. Format the headings as dates and widen the columns enough to read them. If the project spans several months, use a shorter date format so the timeline does not become unnecessarily wide.

To calculate duration inclusively, with task start dates in C2:C20 and finish dates in D2:D20, enter this in E2 and copy it down: =D2-C2+1. For a task starting June 1 and finishing June 3, the result is 3 days because both the first and last dates count. This is calendar-day duration, so weekends are included. If you want working days instead, with any holiday dates listed in J2:J10, use =NETWORKDAYS(C2,D2,$J$2:$J$10) in E2 and copy down. NETWORKDAYS excludes Saturdays and Sundays and the listed holidays.

Color the task bars with conditional formatting

The key step is to shade each timeline cell when its date is between the task’s start and finish. Select the timeline area for the task rows, such as G2:AZ20. On Windows, choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Enter this formula:

With dates in G1:AZ1, task starts in column C, finishes in column D, and the selected range beginning at G2, use: =AND(G$1>=$C2,G$1<=$D2).

Choose Format, select a fill color, and confirm the rule. The formula compares each timeline heading with the start and finish dates on the same task row. The dollar signs keep the heading on row 1 and the task dates in columns C and D as the rule moves across the selected area, while the row number changes for each task. A task scheduled from June 1 through June 3 will shade the three matching date cells.

On Excel for Mac, the Conditional Formatting controls are also on the Home tab; the wording and placement of dialog controls can vary slightly by release. Excel for the web supports conditional formatting too, though some rule-editing controls may differ from the Windows desktop dialogs. If the bars appear on the wrong rows, check that the selected range starts at G2 and that the formula uses row 2 references.

Show progress and milestones accurately

Keep the planned bar distinct from completion. The conditional-formatting rule above shows the scheduled span; it does not mean that the task is finished. Use column F for a progress estimate, and optionally apply Home > Conditional Formatting > Data Bars to F2:F20. A numeric percentage gives readers a separate signal about completion. Agree on what percentages mean—for example, 50% should represent a consistent judgment of work completed, not merely half the scheduled days elapsed.

A milestone is a significant event with no meaningful duration, such as approval or a launch date. If its start and finish are the same date, the rule shades one timeline cell, which can represent it. Label the task clearly as a milestone and consider a different fill color by adding a separate conditional-formatting rule for milestone rows. Avoid giving a one-day marker a multi-day finish date just to make it more visible; that changes what the schedule says.

Worked example: a short task plan

Suppose a small website update has three tasks: “Write page copy,” scheduled June 1–3; “Review copy,” June 4–5; and “Publish update,” June 8. Put those names in A2:A4, the start dates in C2:C4, and the finish dates in D2:D4. Enter June 1, 2026, in G1 and continue the dates across row 1. The conditional-formatting rule shades three cells for the first task, two for the review, and one for publishing. The gap on June 6–7 remains visible rather than suggesting that work is scheduled on those dates.

This small example also shows why the timeline scale matters. A daily grid is clear for a plan lasting a few weeks, but a year-long plan would require hundreds of date columns. For a longer project, consider weekly columns or a dedicated project tool. If you use weeks, define consistently whether each heading represents the week’s start date and how a task spanning only part of a week should appear.

Choose a blank, built-in, or downloaded template

Building the grid yourself makes the date logic transparent and lets you choose the columns and colors. It is a sensible option if you need a lightweight schedule and want to understand how edits affect the chart. A prebuilt Excel template may save setup time and may include areas for owners, status, or milestones, but inspect its formulas and assumptions before entering project data.

Excel’s available templates can vary by Microsoft 365 version, account, and organization settings. You can look for project or Gantt templates from Excel’s template start screen, but do not assume every workbook labeled “Gantt chart” works the same way. Check whether it expects calendar days or workdays, whether bars update when dates change, and whether it contains macros. A workbook that uses macros may prompt for permission and is not necessary for the basic conditional-formatting method described here.

When comparing options, consider these practical points:

  • Can you add tasks without breaking formulas or formatting?
  • Are weekends shown, excluded, or merely colored differently?
  • Can the intended users open and edit the file in their version of Excel?
  • Does it distinguish planned dates from actual progress?
  • Are formulas and any macros understandable and appropriate for your organization?

Common problems and useful fixes

  • No bars appear: confirm that start and finish values are real dates, not text, and that the conditional-formatting range includes the timeline cells for the task rows.
  • Bars are shifted: check that the rule’s first date reference matches the first selected timeline column. For a range starting at G2, the formula should refer to G$1.
  • The last day is missing: confirm that the rule uses less than or equal to the finish date. A strict less-than comparison excludes the finish date.
  • Dates look like numbers: apply a date number format to the cells. Excel stores dates as serial values, so a number format controls how they are displayed.
  • Blank task rows look odd: keep unused rows outside the formatted range, or add a task-name check to the rule if you deliberately format many empty rows.
  • New tasks have no bars: extend the conditional-formatting range to cover them. A rule applied to G2:AZ20 will not necessarily cover task row 21.

It is also easy to mistake a colored schedule bar for a dependency. If “Review copy” must happen after “Write page copy,” the chart’s dates do not enforce that order. Add a dependency or predecessor column for readers, and revise dates when the plan changes. For a simple manually maintained plan, that may be enough; for frequent changes, many linked tasks, or resource conflicts, it becomes harder to keep the workbook reliable.

When Excel is enough—and when it is not

A cell-based Gantt chart is often adequate for a single project with a manageable number of tasks, one person maintaining the plan, and relatively few date changes. It is easy to share as a workbook, print, and customize. Keep a clear “last updated” date and name an owner for the schedule so readers know whether the displayed dates are current.

Consider another approach when you need automatic dependency scheduling, several people editing at once, notifications, workload balancing, or a detailed record of changes. Project-management applications may provide those capabilities, but their features, access rules, and costs vary. A plain Excel task list without a calendar bar can be better than a Gantt view when the main need is tracking owners and due dates rather than visualizing schedule overlap. Choose the simplest format that answers the team’s real planning question.

Frequently Asked Questions

Does Excel have a built-in Gantt chart?
Excel does not offer a dedicated Gantt chart type in the standard chart list. You can create a Gantt-style schedule with cells and conditional formatting, or use a workbook template that implements a similar layout.

How do I make a Gantt chart for tasks in Excel?
List tasks, owners, start dates, and finish dates; add consecutive dates across the top; then apply a conditional-formatting formula that shades dates between each task’s start and finish. The formula and layout above provide a basic version.

Can Excel show weekends in a Gantt chart?
Yes. A daily timeline includes weekends unless you choose to hide or visually distinguish those columns. NETWORKDAYS can calculate a weekday duration, but that function does not remove weekend columns from the chart by itself.

Can I use this template in Excel for Mac?
Yes. The date calculations and conditional-formatting approach work in current Excel for Mac, although dialog wording and placement can vary by release. Excel for the web can also handle basic versions of the chart.

How do I show task completion?
Keep completion separate from planned dates: enter a percentage in a dedicated column and optionally apply data bars to those percentage cells. The schedule bar alone shows the planned date range, not how much work is complete.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.