Excel Gantt Chart Template XLS: How to Find or Build One

Yes—an Excel Gantt chart template can be opened or built in Excel, but “XLS” is the older Excel file format. For a new project, use an .xlsx workbook or an Excel template; if you specifically need an .xls file, save a copy in that format and check for compatibility warnings. A simple Gantt chart needs task names, start and finish dates, and a timeline whose cells are shaded across each task’s duration.

What “Excel Gantt chart template XLS” means

A Gantt chart is a schedule displayed as horizontal bars against a calendar. Each row represents a task, and the bar shows when that task is planned to start and finish. The chart is useful for seeing overlap, sequence, and gaps at a glance. It is not, by itself, a complete project-management system: a basic chart will not automatically resolve conflicts, calculate resource capacity, or guarantee that a deadline is feasible.

People searching for an “Excel Gantt chart template XLS” may mean any of three things: a ready-made workbook, an editable spreadsheet that can be saved as an Excel file, or a file specifically ending in .xls. These are not identical. Modern Excel workbooks normally use .xlsx; macro-enabled workbooks use .xlsm; and older Excel templates may use .xlt. The current template format is generally .xltx or, when it contains macros, .xltm.

Where to get a template

In Excel for Microsoft 365 on Windows, use File > New and search the available templates for terms such as “Gantt” or “project timeline.” Template availability can vary with your Excel installation, account, and connected online services, so a search may not show the same choices for every user. You can also start with a blank workbook or obtain a template from a source you trust. Before entering project data, check whether it contains formulas, macros, external links, or instructions that do not fit your needs.

When evaluating a downloadable file, inspect the layout and the file extension before enabling anything. A basic Gantt template usually needs no macro. If a file asks you to enable macros or connect to an unfamiliar external source, do not do so unless you understand why and trust the source. A downloaded template should be treated as a starting point: replace sample tasks and dates, confirm its date scale, and test that the bars respond correctly to edits.

Choose the right file format

For current Excel use, .xlsx is usually the sensible format because it supports modern workbook features and does not store VBA macros. Use .xlsm only when a workbook genuinely needs macros. The legacy .xls format can be necessary when exchanging files with older software, but saving a modern workbook as .xls may remove or change features that the older format cannot represent. Excel may warn about such compatibility issues when you save.

To save a workbook in Excel for Microsoft 365 on Windows, choose File > Save As, select a location, and choose the file type in the Save as type list. For a normal new project, select Excel Workbook (.xlsx). If a recipient explicitly requires the older format, select Excel 97-2003 Workbook (.xls) and review any compatibility message. Keep an original .xlsx copy so you can return to the version with current-format features. Excel for Mac also offers format choices in its Save As workflow, though the dialog and labels can differ slightly.

Build a basic Gantt chart in a worksheet

A conditional-formatting Gantt chart is often easier to maintain than a decorative chart object. It uses ordinary cells for the calendar and colors the cells that fall within each task’s dates. The following layout assumes task names are in A, start dates in B, finish dates in C, and timeline dates start in D1. Put one task per row, beginning in row 2.

Enter headings in A1:C1, such as Task, Start, and Finish. Enter real Excel dates in columns B and C, not dates stored as text. For example, a task might start on 3 March 2026 and finish on 6 March 2026.
Enter the first calendar date in D1. In E1 and the cells to its right, enter the following dates in sequence. You can fill a date series by entering two consecutive dates, selecting both cells, and dragging the fill handle to the right. Choose daily, weekly, or monthly intervals based on the project’s useful level of detail.
Select the timeline grid for the task rows, such as D2:AG20. On the Home tab, choose Conditional Formatting > New Rule > Use a formula to determine which cells to format. Set the rule formula to =AND(D$1>=$B2,D$1<=$C2), choose a fill color, and confirm the rule.

This formula assumes the timeline dates are in D1:AG1, task start dates are in B2:B20, task finish dates are in C2:C20, and the rule applies to D2:AG20. It returns TRUE for a cell when that column’s date is on or after the task start and on or before the finish; for a task running 3–6 March, the cells for 3, 4, 5, and 6 March are shaded. The dollar signs keep the date row and date columns fixed appropriately as the rule is evaluated across the grid, while the task row changes for each row.

To display the calendar more clearly, make the timeline columns narrow, format the header dates as short dates or day numbers, and freeze the task labels if the schedule is wide. In Excel for Windows, select the cell below and to the right of the rows and columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. On Mac, the Freeze Panes command is also on the View tab, although the menu presentation can differ. Excel for the web has related view controls, but exact options may depend on the current interface.

Show task duration and milestones

Duration can be useful as a separate planning field, especially when checking estimates. With task start dates in B2:B20 and finish dates in C2:C20, enter this in D2 and fill it down: =C2-B2+1. For a task beginning 3 March and finishing 6 March, the result is 4 calendar days because the calculation counts both the first and last dates. Put the duration in another column and shift the timeline to the right if you use this layout; the example assumes the timeline is not already occupying column D.

That inclusive calculation counts calendar days, including weekends. If your project tracks working days instead, consider whether weekends and holidays should be excluded and make that choice consistent throughout the plan. A milestone is usually a zero-duration event or a date marker rather than a multi-day bar. You can identify milestones with a separate symbol or conditional-formatting rule, but avoid treating a milestone as a task with an arbitrary one-day duration if that would misrepresent the plan.

Daily, weekly, or monthly timelines?

The right scale depends on the schedule’s time span and the decisions people need to make. A daily grid is easy to read for a short event or a detailed work plan, but it becomes very wide for a year-long project. A weekly grid gives a useful overview for many multi-month schedules; a monthly grid can summarize a long roadmap but hides day-level timing. Match the date steps to the precision of the start and finish estimates rather than displaying detail that the plan cannot support.

Daily: useful for short projects, launches, and near-term task coordination.
Weekly: a practical compromise for plans spanning several months.
Monthly: useful for high-level roadmaps where exact days are not yet known.

For a weekly timeline, decide whether each column represents the week’s first day or another consistent anchor date. The conditional-formatting rule compares actual dates, so a weekly column shaded when its header date falls within the task dates may fail to show a task that occupies only later days in that week. If you want any overlap with a week to shade the column, the rule must compare the task interval with the full week interval, not just the header date. State the convention in the worksheet so readers do not mistake a summary view for a daily schedule.

Gantt worksheet versus a stacked bar chart

Conditional formatting is a strong choice when you want an editable calendar grid, clear task labels, and quick changes to dates. It is also easy to extend with columns for owner, status, or notes. A stacked bar chart is another way to create a Gantt-like display: one series represents the offset from a start point and another represents task duration, with the offset series formatted so it is not visible. That approach can look more like a conventional chart and can be useful for presenting a compact schedule.

The trade-off is control. A grid is straightforward to inspect cell by cell, while a chart may need extra work to make task order, date axes, labels, and duration ranges readable. Neither approach automatically manages dependencies or updates downstream dates when a task slips. If your schedule needs dependency logic, resource allocation, baselines, or frequent multi-person updates, a dedicated project-management tool may be a better fit than a single Excel template.

Common problems and fixes

No bars appear: confirm that the timeline header cells contain actual dates and that the start and finish cells are dates rather than text. Check the conditional-formatting rule’s applied range and make sure the formula’s first timeline reference matches the top-left cell of that range.
Bars shift onto the wrong rows or columns: review the dollar signs in the formula. For a grid beginning at D2, D$1 refers to the header date in the current column and $B2 and $C2 refer to the date columns on the current task row.
A task has no bar: check that its finish date is not earlier than its start date and that the timeline includes the task dates. A task outside the visible calendar cannot be shaded in the current view.
The bar includes an unexpected date: decide whether the finish date is inclusive. The example rule includes both endpoints. If dates contain times as well as dates, time values can affect comparisons; use date-only values for a simple day-based chart.
The file changes after saving: if you saved to .xls, inspect Excel’s compatibility warning and compare the saved version with the original .xlsx. Keep the modern-format copy as your working master.

Keeping the schedule readable and reliable

Make the chart understandable to someone who did not build it. Give the project a title, label the date scale, explain colors, and include an owner or status only when those fields will be maintained. Use consistent date formats and avoid merging cells in the task data area; merged cells make sorting and editing more difficult. If the chart will be printed, set a sensible print area and orientation, and check the print preview because a long timeline may otherwise be split across pages.

Sort tasks carefully. Sorting only the task-name column separates names from their dates, so select the full task table before using Data > Sort. Keep a separate copy before making broad structural changes, and avoid relying on color alone to communicate a critical status; add text such as “At risk” when the meaning matters. A Gantt chart is a visual summary, so a short notes column can explain blockers or assumptions that the bars cannot show.

Frequently Asked Questions

Is there a free Excel Gantt chart template?
Excel’s File > New template search may show options, and blank workbooks can be used to build a chart without buying a template. Availability varies, and third-party files have their own terms and risks. Check the source and workbook contents before using a download.

Can I download a Gantt chart as an XLS file?
Some templates may be available in the older .xls format, but modern Excel templates commonly use .xlsx or .xltx. If a recipient requires .xls, use Save As to choose Excel 97-2003 Workbook and review compatibility warnings. Keep a modern-format copy as well.

Does Excel have a built-in Gantt chart type?
Excel does not offer a standard chart type named Gantt in the same way it offers common chart types such as column or line charts. Users typically create a Gantt-like view with conditional formatting or adapt a stacked bar chart.

How do I show weekends in a Gantt chart?
A daily timeline can include every date, including weekends, as the basic formula does. To distinguish weekends, add a separate conditional-formatting rule for weekend header dates or use a different fill. If the schedule uses working days only, define how weekends and holidays are handled before interpreting durations.

Will the chart update when I change a task date?
Yes, if the dates are entered in the cells referenced by the conditional-formatting rule and the rule covers the relevant grid. Changing a start or finish date should move the shaded range accordingly, as long as the timeline includes the new dates and the cells contain valid Excel dates.

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.