Microsoft Excel Gantt Chart Template: Build and Customize It

Charts & pivot tables · Updated November 20, 2026

To get a Microsoft Excel Gantt chart template, open Excel for Microsoft 365 on Windows, choose File > New, and search for Gantt; select a suitable result and replace its sample tasks and dates. You can also make a simple Gantt chart yourself with a task table and conditional formatting, which gives you more control over the schedule and layout.

A Gantt chart is a schedule displayed as horizontal bars across a calendar. Each bar shows when a task starts and finishes, making it easier to see overlaps, gaps, and the overall project period than a plain list of dates. Excel does not have a dedicated Gantt chart command or chart type, so templates typically create the display with a stacked bar chart or a formatted grid.

What an Excel Gantt template usually includes

Most templates provide a task list beside a timeline. Depending on the design, the table may include a task name, start date, end date or duration, assigned person, status, and percentage complete. The timeline then represents each task as a bar spanning its scheduled dates. Some templates also include milestone markers, summary tasks, or a project start date at the top.

Templates vary in how much they automate. Some use formulas and conditional formatting, while others rely on a chart with helper columns. A polished template is not automatically a better fit: a small, short project may need only task names and dates, while a project with many contributors may need ownership and status fields too. Check whether the sample schedule uses real Excel dates and formulas or merely colored cells before relying on it.

Find and choose a ready-made template

In Excel for Microsoft 365 on Windows, select File > New and enter Gantt in the template search box. Choose a result to preview it, then create a workbook from the template if it meets your needs. The available search results can change, and some templates may require an internet connection. You can also look in Microsoft’s template collection, but confirm that the file is an Excel workbook and review its formulas before entering project information.

Compare templates using practical criteria rather than appearance alone:

  • Time scale: Does the timeline show days, weeks, or months at a useful level of detail?
  • Schedule logic: Can you enter start and finish dates directly, or does the sheet calculate one from a duration?
  • Project size: Is there room for your tasks, or will adding rows break formulas or chart ranges?
  • Tracking fields: Do you need owners, status, completion percentage, or milestones?
  • Maintainability: Can you understand how the bars update when dates change?

For Excel on Mac or the web, the template gallery and its labels may differ from the Windows desktop interface. Search the available template gallery for Gantt, or open a workbook and use the construction steps below. If a template uses macros, check whether they are necessary; a basic schedule can usually work without them.

Build a simple Gantt grid from scratch

A conditional-formatting grid is a straightforward option when you want a transparent schedule rather than a chart object. Start a blank worksheet and make a table with Task in A1, Start in B1, and Finish in C1. Enter one task per row, using actual Excel dates in columns B and C. In D1, enter Duration. With the task’s start date in B2 and finish date in C2, enter =C2-B2+1 in D2 and fill the formula down. For a task starting November 3 and finishing November 7, the inclusive duration is 5 days.

The plus one matters when both the start and finish dates count as work scheduled on the task. If you instead want elapsed days between two dates, use the difference without the plus one. Decide which convention the project uses and apply it consistently; mixing inclusive and elapsed durations can make totals appear off by a day.

Next, add consecutive calendar dates across row 1, beginning in E1, and place the dates for the task rows beneath that timeline. In practice, it is often clearer to keep the task headers on row 2 and the timeline dates on row 1, with the task data beginning in row 2; the conditional-formatting formula must match the arrangement you choose. For example, use A2:C2 for the first task, place the first timeline date in E1, and apply the rule to E2 and the rest of the grid. Select the full grid range, such as E2:AI30, and use Home > Conditional Formatting > New Rule. Choose the option to use a formula to determine which cells to format.

For a grid where timeline dates are in E1:AI1, each task’s start and finish dates are in columns B and C, and the selected range begins at E2, use this formula for the rule: =AND(E$1>=$B2,E$1<=$C2). Choose a fill color and confirm the rule. The formula returns TRUE for a cell whose date falls on or between that task’s start and finish dates, so Excel colors those cells. The dollar signs keep the timeline row and date columns fixed as the rule is applied across the grid, while the task row changes as the rule moves down.

Make sure your date headers are genuine dates, not text that only looks like dates. Format them to display compactly, such as day numbers or abbreviated dates, without changing their underlying values. If you want a longer timeline, extend the date headers and the conditional-formatting range. Freeze the task-name columns or top timeline row if scrolling makes it difficult to follow a bar across the sheet.

Use a stacked bar chart instead

A stacked bar chart can be useful when the schedule needs to look like a conventional chart or fit into a presentation. Create columns for Task, Start, and Duration, then select the relevant data and choose Insert > Insert Bar Chart > Stacked Bar. Excel plots the start-date series and duration series as adjacent segments. Format the start-date series with no fill so it becomes an invisible offset; the visible duration segment then appears to begin on the task’s start date.

Chart setup takes more adjustment than the grid method. You may need to reverse the task order on the vertical axis, set the horizontal date-axis bounds, reduce the gap width, and hide the legend entry for the invisible start series. Exact controls appear in the Format Axis and Format Data Series panes. A chart also needs its source range to include new tasks; check the chart’s data source if added rows do not appear. Choose the grid for easy editing and day-by-day visibility, and a stacked bar chart when a compact visual is more important.

Customize dates, milestones, and progress

Choose the timeline scale to match the decisions readers need to make. Daily columns are useful for a short event or a tightly managed launch, but they become unwieldy across a year. Weekly or monthly columns make a long project easier to scan, though they cannot show every day precisely. A practical compromise is to use a detailed view for near-term work and a broader summary view for the full project.

Milestones are events, not tasks with meaningful durations. You can give a milestone the same start and finish date and format it with a distinct color or symbol, or create a separate milestone row. Keep the legend clear so readers do not mistake a milestone for a multi-day task. For completion tracking, add a percentage-complete field and use a separate visual convention, such as a progress column or a contrasting bar segment. Do not rely on color alone to communicate status; include a text label such as Not started, In progress, or Complete when accessibility or printing matters.

To make the sheet easier to maintain, use consistent date formats, distinguish input cells from calculated cells, and include a small legend explaining colors. Avoid merging cells inside the task table, since merged ranges make sorting and filtering harder. If you add dropdowns for status or owner, use Data Validation and test how new task rows inherit the settings.

Common problems and fixes

  • No bars appear: Check that the dates are numeric Excel dates, that the rule applies to the intended grid, and that its row and column references match the layout. A finish date earlier than the start date will also produce no useful bar.
  • Bars shift by one day: Decide whether the finish date is included. The inclusive duration formula uses plus one; the conditional-formatting rule colors both endpoints.
  • Dates display as serial numbers: The underlying dates may be correct. Apply a date number format to the timeline or task-date cells.
  • New tasks are not formatted: Extend the conditional-formatting range, formulas, or chart source range to cover the added rows.
  • Weekend shading looks wrong: A basic date grid colors every calendar day between the endpoints. If the plan uses working days only, build the timeline and duration logic around the project’s working calendar rather than assuming calendar days.

One common misconception is that a Gantt chart automatically manages project dependencies. A basic Excel template normally displays dates; it does not necessarily recalculate a task’s start when a predecessor is delayed. Unless the workbook explicitly contains dependency formulas or another scheduling mechanism, update affected dates yourself and verify the impact on the rest of the plan.

Excel templates compared with project tools

Excel is a good choice for a small or moderately sized schedule when people already know how to edit a workbook and the plan does not require automatic scheduling. It is flexible, easy to print, and can combine the timeline with notes or project data. The tradeoff is that users must manage formula ranges, versions, and changes carefully, especially when several people edit separate copies.

Dedicated project-management tools may offer linked dependencies, resource views, notifications, shared updates, or workload management. Those features can reduce manual coordination on complex projects, but they may require subscriptions, setup, and training. A spreadsheet template is not a substitute for those capabilities simply because it contains bars on a calendar. Choose based on the scheduling work you actually need to perform, not only on the chart’s appearance.

Frequently Asked Questions

Does Excel have a built-in Gantt chart template?
Excel does not include a dedicated Gantt chart type, but its File > New template search may offer Gantt workbooks. You can also create one with conditional formatting or a stacked bar chart.

How do I make a Gantt chart in Excel without a template?
List tasks with start and finish dates, add calendar dates across columns, and use a conditional-formatting formula to color dates within each task’s range. This keeps the schedule visible in a worksheet grid.

Can Excel update task dates automatically when another task slips?
Not in a basic Gantt template. Automatic dependency scheduling requires formulas or project-management features specifically designed for it, so check the workbook’s logic rather than assuming bars are linked.

Can I use an Excel Gantt template on Mac or Excel for the web?
Many ordinary workbook templates and conditional-formatting rules work across Excel platforms, but template galleries and some controls differ. If a file depends on Windows-only features or macros, test it in the version you plan to use.

Should I use a Gantt grid or a bar chart?
Use a grid when you want editable daily cells and straightforward date checks. Use a stacked bar chart when you need a compact chart-style view, and are comfortable adjusting chart axes and data ranges.

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.