Gantt Chart Template Excel: Build a Task Tracker

Charts & pivot tables · Updated November 20, 2026

Yes. An Excel Gantt chart task tracker can list tasks, owners, start dates, durations, finish dates, and progress, then use conditional formatting to draw a timeline bar for each task. In Microsoft Excel for Microsoft 365 on Windows, you can make a reusable tracker with ordinary cells and one conditional-formatting formula; no add-in or macro is required.

A Gantt chart is a schedule shown on a calendar: each task occupies a row, and its bar spans the dates when work is planned. Excel does not provide a single dedicated Gantt chart worksheet button, but a formatted grid can show the same basic schedule and remains easy to edit. The important distinction is that the task table stores the project information, while the colored timeline is a visual representation of it.

What an Excel Gantt task tracker contains

A useful starter template keeps task details in columns and dates across the timeline. For a small project, arrange the worksheet like this:

  • Task: a specific deliverable or activity, such as “Draft project brief.”
  • Owner: the person responsible. This is a tracking field, not an automatic assignment feature.
  • Start: the planned first day of the task.
  • Duration: the planned number of calendar days, or workdays if you deliberately use a workday-based calculation.
  • Finish: a calculated end date.
  • % complete: a manually updated progress estimate, such as 0%, 50%, or 100%.
  • Timeline: date headings across columns, with conditional formatting displaying the task bars.

For example, a project might include “Confirm requirements,” “Prepare design,” “Build prototype,” and “Review.” Putting each activity on its own row makes it possible to see overlaps and gaps. Keep task names concise; lengthy descriptions are better placed in a notes column or a separate project brief.

Set up the task table and date calculations

In a blank worksheet, use row 1 for headings: A1 Task, B1 Owner, C1 Start, D1 Duration, E1 Finish, and F1 % complete. Enter each task on a new row, beginning in row 2. Format the Start and Finish columns as dates, Duration as a number, and % complete as a percentage. In Excel for Microsoft 365 on Windows, select the relevant cells and use Home > Number Format to choose an appropriate display. The date format changes how a value looks; it does not change the underlying date.

With the task start date in C2 and the duration in D2 measured in calendar days, enter this in E2:

=C2+D2-1

The minus one makes the start date count as the first day. If C2 is November 3, 2026, and D2 is 5, the result is November 7, 2026. Copy the formula down the Finish column for the other task rows. Check that each duration is a positive whole number and each start cell contains a real Excel date, not text that merely looks like a date.

Calendar days include Saturdays and Sundays. If the schedule should count Monday through Friday instead, and C2 is the start date and D2 is the number of workdays, use this formula in E2:

=WORKDAY(C2,D2-1)

For a start date of Tuesday, November 3, 2026, and five workdays, the result is Monday, November 9, 2026. WORKDAY excludes weekend days; it does not know about company holidays unless you supply a holiday range as an additional argument. Choose one duration convention and label it clearly, or readers may mistake a five-day task for five working days when it actually represents five calendar days.

Build the timeline bars with conditional formatting

Place the first date of the visible schedule in H1, then put the following formula in I1 and fill it right to create consecutive daily headings:

=H1+1

If H1 is November 3, 2026, I1 will display November 4, 2026. Format the date headings in a compact style, such as a day number with a month label at weekly intervals, while keeping the underlying cells as dates. The timeline needs one column for every period you want to show. Daily columns suit short schedules; weekly columns can be easier to read for longer projects, but require a consistent choice of what date each column represents.

To draw bars, select the schedule grid, for example H2:AZ100, and choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. With task starts in column C, finishes in E, timeline dates in row 1, and the selected range beginning at H2, enter:

=AND(H$1>=$C2,H$1<=$E2)

Choose a fill color and confirm the rule. Excel evaluates the date at the top of each timeline column against the start and finish dates in that row. The dollar signs keep the date heading on row 1 and the task dates in columns C and E while the rule adjusts across the grid. The result is a colored cell for each date that falls within the task’s planned span.

Extend the selected range or update the rule’s Applies to range if you add tasks or timeline columns. Avoid applying the rule to hundreds of unnecessary columns: a very wide grid becomes harder to navigate and may make the sheet feel slow on a large workbook. In Excel for Mac, the same conditional-formatting feature is available through the Home tab, though the dialog layout can differ. Excel for the web also supports conditional formatting, but some advanced rule-management controls may differ from the Windows desktop interface.

Track progress without confusing it with the schedule

The bar produced by the rule shows planned dates, not proof that work happened. Update the % complete column separately during status reviews, and agree on what the percentage means. A task at 50% might mean half of its deliverables are finished, or it might be an informed estimate; the tracker cannot determine that by itself. For more reliable updates, describe completion criteria in a notes field—for example, “first draft shared” rather than an ambiguous “mostly done.”

You can use color to distinguish task categories or status, but keep the meaning visible in a small legend. A common simple scheme is one color for planned task bars, a separate fill for milestones, and a text status such as Not started, In progress, or Complete. If you add a completion overlay to the timeline, treat it as an estimate unless you record actual start and finish dates. A bar filled from the beginning of a task may imply continuous work even when the task has been interrupted.

Milestones usually have no duration or represent a single date, such as an approval or launch. A basic rule requiring a date to fall between Start and Finish will draw a one-day bar if the milestone has the same start and finish date. You can identify milestone rows with a label or a separate type column, then format them differently. Do not use a zero duration without deciding how the finish formula and conditional-formatting rule should display it.

Make the template easier to maintain

Before sharing the workbook, make it clear which cells users should edit and which cells contain formulas. Use a consistent date convention, descriptive column names, and a legend. Freeze the task headings so that task names remain visible while scrolling across a long timeline: in Excel for Windows, select the cell just below and to the right of the rows and columns to keep visible, then use View > Freeze Panes > Freeze Panes. For example, selecting H2 freezes the first row and columns A through G.

Other practical improvements include:

  • Turn the task list into an Excel table using Home > Format as Table, or Insert > Table, so the task information is easier to filter and sort. Keep the timeline outside the table if automatic table expansion would interfere with its layout.
  • Use Data Validation to limit entries in a status column. On Windows, select the input cells and choose Data > Data Validation; a list can help prevent variations such as “In progress,” “In Progress,” and “Doing.”
  • Use filters to find tasks by owner or status, but remember that sorting only the task-detail columns separately from the timeline can detach dates and bars from their tasks. Select and sort the full task row range.
  • Save a clean copy as a template file if you want to reuse the layout. Preserve a separate project copy for each schedule rather than overwriting the blank starting point.

These steps make the sheet more usable, but they do not turn it into a full project-management system. Excel will not automatically resolve competing assignments, notify owners of overdue work, or calculate a sound plan from task names. Those details require additional formulas, processes, or software.

Common problems and limitations

If no bars appear, first check that the timeline headings and task dates are real date values and that the conditional-formatting rule covers the intended grid. Confirm that the rule uses the correct starting cell: a formula written for H2 may shift incorrectly if the selected range starts elsewhere. Also verify that the start date is not later than the finish date and that the timeline actually includes the task dates.

If bars appear one day too long, review the duration convention. The calendar-day formula uses an inclusive finish date, so a one-day task starts and finishes on the same date. If you instead define finish as the date after work is complete, the formula and conditional-formatting comparison need a different convention. Mixing inclusive and exclusive dates is a frequent source of off-by-one errors.

A Gantt chart is also not automatically a dependency network. You may list a predecessor task in another column, but changing one task’s date will not move dependent tasks unless you build that behavior. Nor does a bar prove that a deadline is feasible: duration estimates, staff availability, approvals, and resource conflicts still need review. Treat the worksheet as a communication and tracking aid, not as a substitute for planning decisions.

Excel template versus other ways to make a Gantt chart

A self-built Excel tracker is useful when a team needs a familiar, editable schedule and only basic coordination. It offers control over columns, colors, and print layout, and it can be shared as a workbook. A prebuilt Excel template can save setup time, but inspect its formulas, date assumptions, and formatting before entering important project data. Templates vary, so do not assume every file handles weekends, dependencies, or progress in the same way.

Dedicated project-management tools are more appropriate when many people need simultaneous updates, notifications, dependency scheduling, permissions, or reporting across projects. A calendar can be simpler when the main need is to reserve dates rather than show task duration and sequence. A spreadsheet remains a reasonable option for a small project, a one-time plan, or a schedule that needs a custom presentation. The best choice depends on collaboration and scheduling needs, not on which display looks most like a Gantt chart.

There is no separate charge for creating a chart with cells and conditional formatting if Excel is already available to you, but access to Excel itself depends on the license or plan used. A workbook template may also be offered by a third party under its own terms. Check the source and workbook contents before enabling macros or entering sensitive project information; the basic method described here does not require macros.

Frequently Asked Questions

Does Excel have a built-in Gantt chart template?
Excel does not have a dedicated Gantt chart chart type in the same way it has a bar or line chart. You can use a prebuilt workbook template if available, or create a task table and conditional-formatting timeline. The cell-based method is straightforward to customize and does not require a chart object.

How do I make a Gantt chart in Excel from a task list?
Enter task names, start dates, durations, and finish dates, add a row of consecutive date headings, then apply a conditional-formatting formula to the timeline grid. The formula colors a cell when its column date falls between that row’s start and finish dates.

Can Excel show weekends in a Gantt chart?
Yes. A daily timeline can include every calendar date, including weekends. If task durations should count only weekdays, calculate finish dates with WORKDAY and decide whether weekend columns should remain visible or be hidden. The date display and the duration calculation are separate choices.

Can the chart update when I change a task’s dates?
Yes, if the bars are produced by a conditional-formatting rule based on the task’s start and finish cells. Changing either date updates which timeline cells meet the rule, as long as the new dates fall within the displayed timeline range.

Can Excel automatically move dependent tasks?
Not with the basic template. A predecessor column can document task order, but automatic rescheduling requires additional logic or project-management software. For a simple tracker, review dependent dates during schedule updates and make changes deliberately.

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.