Does Excel Have a Gantt Chart Template? How to Use It

Yes. Excel has Gantt chart templates you can find through its template gallery or Microsoft Create, although the available choices can vary by Excel version, account, and region. Excel does not have a dedicated Gantt chart type; most templates display a schedule using a stacked bar chart, and you can also build a basic Gantt chart yourself.

What an Excel Gantt chart template does

A Gantt chart lays out project tasks against a calendar. Each task appears on its own row, and a horizontal bar shows when it begins and how long it lasts. A template typically supplies the layout, formulas, and chart formatting, so you can replace its example tasks and dates with your own.

Templates range from a simple project timeline to more elaborate workbooks with fields for owners, status, percent complete, milestones, or several project phases. Those extra columns are not automatically connected to the chart in every template. Check the workbook’s instructions and sample data before assuming a status field will update a bar or that a milestone will appear on the timeline.

A Gantt chart is a visual schedule, not a project-management system by itself. A basic Excel template usually will not automatically reschedule dependent tasks, manage a shared team workload, or alert colleagues when a deadline changes. Those features may require formulas, automation, or a different tool.

Where to find a Gantt chart template in Excel

In Excel for Microsoft 365 on Windows, open Excel and choose File > New. Search for Gantt in the template search box. If a suitable result appears, open it and choose to create the workbook. Template listings and names can change, so you may see project schedules or timelines rather than a result named exactly Gantt chart.

You can also look on Microsoft Create, which offers downloadable templates for Microsoft apps. Confirm that a download is from Microsoft or another source you trust, and check that it is an Excel workbook before opening it. A template may be free or may come from a third party with its own terms; do not assume every result in a web search is an official Microsoft template.

Excel for the web and Excel for Mac have template options too, but the gallery and available templates can differ. If you cannot find one inside Excel, search Microsoft Create in a browser, download an Excel-compatible workbook, and open it in your version of Excel. Be aware that a workbook containing macros or features unsupported by your version may not behave as expected.

How to choose a template

Start with the schedule you need to communicate, not the most elaborate-looking workbook. A short project with a dozen tasks may be easier to maintain in a clean timeline than in a template filled with resource assignments, dashboards, and unfamiliar formulas.

Check the time scale. Decide whether you need days, weeks, or months. A project lasting several months can become difficult to read if every calendar day gets its own column.
Look for useful fields. Task, start date, finish date, and owner are common basics. Include status or percent complete only if someone will keep that information current.
Inspect how the chart changes. Edit a sample task date in a copy and see whether the bar moves. If the chart does not update, it may be a static illustration or may need its data range expanded.
Consider printing and sharing. Check whether the chart fits on a page or remains readable when exported to PDF. Think about whether collaborators have compatible Excel versions.
Review the workbook structure. Look for clear input cells and instructions. Avoid entering data into chart helper areas or cells that contain formulas unless the template says to do so.

Make a copy before replacing sample information. That preserves a clean original if you need to check which cells were intended for input or recover a formula you overwrote.

Build a basic Gantt chart from scratch

If a template does not fit, a simple one can be made from task data and a stacked bar chart. In a worksheet, put task names in A2:A20, start dates in B2:B20, and finish dates in C2:C20. Use actual Excel dates, not text that merely looks like a date. Add a duration column in D. With the finish date in C2 and start date in B2, enter =C2-B2+1 in D2 and fill it down. For a task running March 2 through March 6, 2026, the inclusive duration is 5 days.

For charting, create a small adjacent helper table with task name, start date, and duration. The start date acts as an invisible offset that positions each visible duration bar on the calendar. Select the helper table, then choose Insert > Insert Bar Chart > Stacked Bar. The exact chart gallery layout can vary slightly with updates, but choose the stacked bar option, not a clustered bar.

In the chart, format the start-date series so it has no fill; this hides the offset while leaving the duration bars in place. Select that series and use the Format Data Series pane, under Fill & Line > Fill, to choose No fill. Then format the task axis and date axis as needed. If the task order appears upside down, open Format Axis for the category axis and turn on Categories in reverse order. Use a date number format and sensible minimum and maximum bounds so the schedule uses the available chart space.

How the chart represents dates and durations

The stacked bar is the key idea behind many Excel Gantt templates. Its first series is the number of days from the chart’s starting date to a task’s start date. Because that series is made invisible, it looks like empty space before the task. The second series is the task duration, which appears as the colored bar. Changing either the start date or duration shifts or resizes the visible bar.

Excel stores dates as serial values, which is why a date can position a bar along a numeric axis. The chart may initially show numbers instead of calendar labels, or a range that starts far before the project. Formatting the axis as dates and adjusting its bounds usually makes the timeline more legible. If the chart’s first series is not hidden, you will see colored bars extending from the chart origin; that is a formatting issue, not proof that the dates are wrong.

Be consistent about whether durations count the finish day. The example formula uses inclusive calendar days, so a task beginning and ending on the same date has a duration of one. If you instead want elapsed days between dates, the calculation omits the added one. For work schedules, weekends and holidays require additional planning: a basic calendar-day Gantt chart will count them unless it has been designed to use working days.

Keeping a template accurate as a project changes

Once tasks are entered, update dates and durations in the source table rather than dragging chart bars unless the template specifically supports that workflow. Some templates use formulas or named ranges to feed the chart; typing over those cells can break the display. Add new tasks within the table or chart source range, and confirm that the chart includes them. A chart may not automatically expand if its source is an ordinary fixed cell range.

Dependencies deserve particular care. If task B must wait for task A, a basic chart will not necessarily move B when A slips. You may need to adjust the dates manually or build formulas that calculate starts from predecessor tasks. Likewise, a completion percentage does not automatically create a progress overlay unless the workbook has been set up to chart it.

For team use, agree on who updates the dates and what status labels mean. Keep a dated copy or use OneDrive or SharePoint version history if the workbook is stored there and your organization has those services enabled. A chart that looks polished but contains stale dates can be more misleading than a plain task list.

Common problems and misconceptions

There is no Gantt chart button. Excel’s standard chart types do not include a dedicated Gantt chart. Templates create the appearance with a stacked bar chart, or with a formatted grid.
Dates are treated as text. If bars do not position correctly, check that the source cells contain real dates. Re-entering the value with a recognized date format can help; changing only the display format will not convert text into a date.
The task order is reversed. This is a common category-axis behavior for horizontal bar charts. Reverse the category order in Format Axis and check whether the date axis crosses at the desired end.
New rows are missing. The chart may use a fixed source range. Update its data source or use an Excel table if the template supports expanding ranges.
Bars look too wide or too narrow. The date-axis bounds, chart size, and gap width affect the appearance. Adjust these before changing the underlying task dates.

A Gantt chart also does not prove that a plan is realistic. It visualizes the dates supplied to it; it cannot determine whether a person has too many simultaneous tasks or whether the estimate is achievable.

Excel templates compared with other options

Excel is useful when a project needs a flexible schedule, a familiar file format, and straightforward reporting. It is particularly practical for an individual or small group that already works in spreadsheets. You can tailor columns, colors, and chart labels without learning a separate application, though the workbook’s complexity can grow quickly.

Dedicated project-management tools may be a better fit when you need automatic dependencies, shared task ownership, notifications, workload views, or multiple people editing a schedule at once. Microsoft Project is designed for more extensive project scheduling; Microsoft Planner focuses on organizing team tasks and has different planning features. Other services offer their own Gantt views and licensing terms. Compare current features and costs before choosing, since plans and integrations change.

A calendar or task list may be clearer than a Gantt chart when dates are uncertain or the work is not sequential. Conversely, a Gantt view is helpful when readers need to see overlap, order, and timing at a glance. The best format is the one your audience can understand and that someone will maintain.

Frequently Asked Questions

Does Excel have a built-in Gantt chart type?

No. Excel does not provide a chart type named Gantt chart in its standard chart list. Templates and tutorials commonly make one from a stacked bar chart, while other workbook layouts use conditional formatting in a date grid.

Are Excel Gantt chart templates free?

Some templates available through Excel or Microsoft Create are free to download, but availability and terms can vary. Third-party templates may be paid or have separate licensing conditions. Check the source and terms before using a downloaded workbook.

Can I make a Gantt chart in Excel without a template?

Yes. Enter tasks, start dates, and durations, then use a stacked bar chart with the start-date series hidden. You can also build a calendar grid and use conditional formatting to color the cells that fall within each task’s date range.

Will an Excel Gantt chart automatically update when a task slips?

It will update its bars when the chart’s source dates or durations change, provided the chart references those cells. It will not automatically reschedule dependent tasks unless the workbook includes formulas or other scheduling logic for those dependencies.

Can I use an Excel Gantt template on Mac or in a browser?

Usually, yes, if the workbook’s features are supported in that version. Excel for Mac and Excel for the web may present different template galleries or chart-formatting controls from Excel for Microsoft 365 on Windows. If a formatting option is missing, try opening the workbook in the desktop version.

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.