Excel Gantt Chart Template: Build and Customize One

An Excel Gantt chart template is a worksheet that lays out tasks against dates, then uses colored cells or bars to show when each task starts and finishes. In Microsoft Excel for Microsoft 365 on Windows, you can make a reusable version by entering tasks and dates, adding a row of timeline dates, and applying conditional formatting to the task grid; a stacked bar chart is another option when you need a conventional chart.

What an Excel Gantt chart template does

A Gantt chart turns a schedule into a visual timeline. Each row represents a task, and its colored bar spans the dates when the task is planned. This makes it easier to see the order of work, overlapping tasks, gaps, and deadlines than it is in a plain list of dates.

Excel does not offer a dedicated Gantt chart type in its standard chart list. Templates therefore create the effect with worksheet formatting or adapt a stacked bar chart. A worksheet-based template is often the simplest starting point: it keeps task names, owners, dates, and the visual schedule together, and you can change the timeline by editing cells.

A template is a starting structure, not a project-management system. It will not automatically know that a task is delayed, that a dependency has changed, or that a person is overloaded unless you add data and rules to represent those facts.

Choose a template or build your own

If you want a quick start, search Excel’s template gallery or Microsoft’s template listings for terms such as Gantt chart or project planner. Available designs can change, so check that a candidate includes editable task dates and a timeline that fits your planning horizon. Downloaded workbooks may use formulas, conditional formatting, charts, or macros; review the workbook and enable macros only when you trust the source and have a reason to use them.

Building a small template yourself gives you control over columns, date scale, and print layout. It is also easier to understand why the bars move when you change dates. A useful choice depends on the project:

Choose a daily grid for a short project where day-by-day timing matters.
Choose a weekly or monthly grid for a longer plan where daily columns would make the sheet too wide.
Choose a stacked bar chart when you need a compact visual for a presentation, especially if task names and dates are already in a table.
Choose a ready-made workbook when its layout meets your needs and you are comfortable checking its formulas and rules.

Plan the worksheet layout

Start with a clear table of project information. For example, put Task in A4, Owner in B4, Start in C4, Finish in D4, and Duration in E4. Put the first timeline date in F4 and later dates in G4, H4, and onward. Enter each task on a separate row beginning in row 5. Keep the timeline headings as real Excel dates, not text that merely looks like dates, because comparisons and date formatting depend on Excel recognizing them as dates.

Decide whether your dates represent calendar days or working days before making the timeline. A simple continuous daily grid includes weekends. That is appropriate for work that can continue every day, but it may mislead a team that plans only Monday through Friday. A weekly grid or a separate working-day schedule can be more suitable for that case. Also agree on whether a finish date is included in a task’s duration; the example below treats both the start and finish dates as included.

Freeze the task information if the schedule is wide or long. In Excel for Windows, select the cell immediately below and to the right of the rows and columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For the example layout, selecting F5 keeps rows above and columns to the left visible while you scroll. Adjust the selection if your headings occupy additional rows.

Build the colored timeline grid

Enter task names, owners, start dates, and finish dates in columns A through D. Use actual dates, and make sure each finish date is on or after its start date.
In F4, enter the first date in the project timeline. Add the next calendar date in G4, then continue across the row. Format the headings as short dates if space is limited.
In E5, calculate the inclusive calendar duration. With the task’s start date in C5 and finish date in D5, and an example task running April 6 through April 10, 2026, enter =D5-C5+1. The result is 5 days: April 10 minus April 6 is 4, plus 1 to include both dates. Copy the formula down for the other task rows.
Select the timeline cells for the task rows, such as F5:AZ20, changing the final column and row to fit your schedule. Choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format.
With the timeline dates in row 4 and task start and finish dates in columns C and D, enter =AND(F$4>=$C5,F$4<=$D5) as the rule formula. For a task starting April 6 and finishing April 10, a grid cell whose header is April 6 returns TRUE and is filled; a cell headed April 11 returns FALSE and is not filled.
Choose Format, select a fill color, and confirm the rule. Check the Applies to range so it covers the timeline cells for all tasks. The dollar signs keep the date header on row 4 and the start and finish columns fixed as Excel evaluates different cells.

The formula uses inclusive date comparisons, so the bar appears on both the start and finish dates. If a bar does not appear, check that the header dates and task dates are real dates, that the rule applies to the intended grid, and that the formula’s row numbers match the first selected task row.

Make the template useful as a working schedule

Once the basic bars work, add only the information that helps people make decisions. A status column can record Not started, In progress, or Complete. A notes column can capture a brief constraint or handoff. Too many fields make the schedule harder to scan, so keep detailed descriptions in a separate project document if they do not belong in the timeline.

For repeat use, turn the task list into an Excel table by selecting its range and choosing Insert > Table. Tables make it easier to filter task records and extend the structured list as work is added. The timeline grid may remain a separate range beside the table, because a table is not automatically a Gantt chart and does not create colored bars by itself.

Use a clear legend if colors communicate different information. For example, one color can represent the planned schedule and another can indicate completed work, but do not use color alone to convey a critical status. Add a text status or symbol as well, so the meaning remains available when printed in grayscale or viewed by someone who cannot distinguish the colors.

Show progress without confusing the plan

A planned bar answers when the task is scheduled; it does not prove that work has happened. Keep planned dates separate from actual progress. One simple design uses a progress percentage column and a different color for completed portions, but that requires additional conditional-formatting rules and a clear definition of what percentage complete means. For example, 50 percent could mean half the effort is done, not necessarily half the calendar duration has passed.

For a lightweight tracker, use a status field and update it during project reviews. If you change a finish date to reflect a delay, consider recording the original baseline date elsewhere. Otherwise, the current plan can overwrite the evidence of what was originally agreed. For projects with many dependencies, resource assignments, or frequent schedule changes, a spreadsheet can become difficult to maintain; a dedicated project-planning tool may be more appropriate.

Grid template versus stacked bar chart

The conditional-formatting grid is a good fit when users need to edit a schedule directly in the worksheet. It is easy to read across a daily or weekly calendar, and task details remain close to their bars. Its main limitation is width: a daily timeline for many months can require extensive horizontal scrolling and can print poorly.

A stacked bar chart can be more compact. It typically uses a hidden first series for the offset from the project start and a visible duration series for each task. Formatting the first series with no fill makes the visible duration appear to start later along the date axis. This approach can make a cleaner presentation graphic, but it takes more chart setup, and long task labels or detailed cell-level editing may be less convenient.

Neither method is automatically better. Use the grid for a practical schedule people will update; use a chart when the visual needs to stand alone in a report or presentation. A chart may also need manual attention when new tasks are added, depending on how its source data is organized.

Common problems and fixes

Bars shift by a day: Check whether the timeline headings include times as well as dates. A date-time value can fail an exact-looking comparison if its hidden time differs. Use date-only values consistently.
Every cell is colored: Verify that the rule formula refers to the top row of the selected grid and that the Applies to range is not accidentally set to the whole worksheet.
Dates show as numbers: Excel stores dates as serial values. Apply a date format using Home > Number Format rather than replacing valid dates with text.
Weekend bars are unexpected: The basic daily grid includes weekends. Decide whether that is correct for the project, then use a suitable timeline scale or add explicit rules for nonworking days.
The sheet is hard to print: Reduce the timeline to weekly or monthly columns, use landscape orientation, and review the print preview. For a focused printout, set a print area around the task list and relevant dates.
New rows have no bar: Extend the conditional-formatting Applies to range when adding tasks, or establish a range with room for expected additions and confirm the rule covers it.

Sharing, printing, and platform notes

Save a reusable template as an Excel template file if you want Excel to create a fresh workbook from it, or keep a clean workbook copy and duplicate it for each project. Before sharing, remove sample task names and dates that could be mistaken for live project information. Check whether the workbook contains external links or macros, especially if it came from another source.

On Windows, the instructions above use Microsoft 365 ribbon paths. Excel for Mac has corresponding conditional-formatting and freeze-pane features, though some menu labels and dialog layouts can differ by release. Excel for the web can open and edit many workbooks, but if a rule or chart is difficult to configure in the browser, open the file in the desktop app and verify the saved result afterward. If several people edit the same file, agree who owns schedule changes to avoid conflicting updates.

For printing, use Page Layout to choose orientation and scaling, then inspect the preview before distributing the sheet. Scaling a very wide daily schedule to one page can shrink text until it is unreadable. A sensible weekly summary or a printout limited to the next few weeks is often clearer than forcing every date onto one page.

Frequently Asked Questions

Does Excel have a built-in Gantt chart template?
Excel does not have a dedicated Gantt chart type in the standard chart list. You can search available Microsoft templates for a suitable workbook, or build a Gantt-style schedule with conditional formatting or a stacked bar chart.

How do I make a Gantt chart in Excel with dates?
List tasks with start and finish dates, place real dates across a header row, select the task timeline cells, and create a conditional-formatting rule that colors a cell when its header date falls between that row’s start and finish dates.

Can an Excel Gantt chart show task progress?
Yes, but the basic date bars show scheduled timing, not completion. Add a progress or status field and use a separate visual rule if needed. Define what progress means and update it from reliable project information.

Can I make an Excel Gantt chart by week instead of by day?
Yes. Put one date per week in the timeline and adjust the rule to represent the week, such as coloring a week when it overlaps the task dates. Weekly columns save space, but they show less precise start and finish timing.

Why is my Gantt chart not updating when I change a date?
Check that the date is stored as an Excel date, the conditional-formatting formula points to the correct start and finish columns, and the Applies to range includes the affected cell. Also check whether another formatting rule is overriding the bar color.

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.