Excel Gantt Chart: Free Templates and How to Make One

Yes. You can make a Gantt chart in Excel for free using Excel for the web and a Microsoft account, or start from a free template; a desktop copy of Excel is not required for a basic schedule. In a blank workbook, list each task, its start date, and its duration, then create a stacked bar chart and hide the start-date bars so only the schedule bars remain visible.

What an Excel Gantt chart shows

A Gantt chart is a project schedule displayed as horizontal bars along a date timeline. Each row represents a task; the bar’s position shows when that task begins, and its length shows how long it is expected to take. Unlike a normal bar chart, the bars do not all start at zero: they begin at their scheduled dates.

Excel does not have a dedicated Gantt chart type in its standard chart gallery. Instead, a common approach uses a stacked bar chart with two data series: a start-date value that offsets each task, and a duration value that draws the visible bar. Making the first series invisible creates the familiar Gantt appearance. The chart is still an ordinary Excel chart, so it can be edited, formatted, printed, and shared like other charts.

A Gantt chart is useful for communicating a plan, but it is not automatically a full project-management system. A simple chart will not, by itself, calculate resource conflicts, manage approvals, or update dependent tasks when a schedule changes. Those features require additional formulas, careful workbook design, or a dedicated planning tool.

Is Excel genuinely free for this?

Excel for the web is available at no cost with a Microsoft account, and it can create and edit workbooks in a browser. That is enough for many small Gantt charts. Microsoft 365 desktop Excel is a paid product or part of certain paid plans; access to it should not be confused with free web access. Features and interface details can differ between web and desktop versions, and an organization may restrict which services its account can use.

You can also look for a free workbook template through Microsoft Create or another reputable template provider. Template availability can change, and some sites require an account or offer paid upgrades alongside free downloads. A template saves setup time, but it is still worth checking its formulas, date range, and chart behavior before relying on it. A workbook that appears free may also contain macros or links you do not need.

Excel for the web: a practical free option for building and sharing a basic chart online.
Desktop Excel: useful when you need fuller chart formatting, offline work, or other desktop features; it may require a paid license.
A free template: a shortcut if its layout fits your project, but inspect the workbook rather than assuming every calculation suits your schedule.

Build a basic chart from a blank workbook

In Excel for Microsoft 365 on Windows, set up a small table with one row per task. For example, use columns A through D for Task, Start, End, and Duration. Enter task names in A2:A4, start dates in B2:B4, and end dates in C2:C4. Use real Excel dates, not text that merely looks like a date. For a project with three tasks, you might enter planning from October 5 to October 9, design from October 8 to October 16, and review from October 17 to October 20 of the same year.

With end dates in C2:C4 and inclusive calendar-day durations in D2:D4, enter this in D2 and fill it down: =C2-B2+1. For planning, October 5 through October 9 returns 5 days; October 8 through October 16 returns 9; and October 17 through October 20 returns 4. The plus one counts both the first and last calendar dates. If your project counts working days rather than calendar days, this simple subtraction is not the right measure; weekends and holidays need to be handled separately.

Select the task names and the Start and Duration columns, including their headers. In the example, select A1:B4, then also include D1:D4 as the chart data. Because those columns are not next to each other, you can select A1:A4, then hold Ctrl on Windows while selecting B1:B4 and D1:D4. Alternatively, make a compact chart-input table with Task, Start, and Duration side by side, which is often less error-prone.
Choose Insert > Insert Column or Bar Chart > 2-D Stacked Bar. Check that Excel has used the task names as categories and Start and Duration as the two series. If the chart is wrong, use Chart Design > Select Data to correct its ranges and series.
Click a Start series bar, open the Format Data Series pane, and set its fill to No fill. The Start series still occupies space and positions the other series, but it is no longer visible. Do not delete the series: doing so removes the offset that places each task on its correct date.
Right-click the task-name axis and choose Format Axis. Under Axis Options, select Categories in reverse order if the first task appears at the bottom. Format the horizontal value axis as dates, and adjust its bounds or number format if the schedule is difficult to read.
Add a useful chart title, choose a readable bar color, and resize the chart. Keep the underlying dates and durations in the worksheet so the chart can be updated when the plan changes.

Excel for the web supports charts, but some formatting controls and their locations can differ from the Windows desktop interface. If you cannot find a particular formatting option in the browser, open the workbook in desktop Excel if you have access to it. Excel for Mac also supports stacked bar charts; ribbon wording is generally similar, but selection gestures and some pane layouts differ. The Windows Ctrl multi-selection instruction above is not a Mac instruction: use Command-click to select separate ranges on a Mac.

Templates, customization, and useful additions

A template can provide a prebuilt chart and a place to enter tasks, dates, and progress. Before using one, confirm whether its bars are driven by formulas or manually formatted cells, and identify which cells are intended for editing. Some templates use conditional formatting across a date grid rather than a chart object. Both methods can look like a Gantt chart, but they behave differently when rows, dates, or columns are added.

For a small project, customize the chart only enough to make it easy to read. A clear title, a sensible date scale, and distinct colors for task groups are usually more valuable than decorative effects. You might add a Status column for labels such as Not started, In progress, and Complete. Excel will not automatically recolor the chart by those labels unless you build separate chart series or use another design; a status label in the table alone does not control the bars.

Milestones, such as a launch date or approval deadline, are often single dates rather than tasks with a duration. A basic stacked-bar setup is not ideal for showing a zero-length milestone because a zero-duration bar may not be visible. You can represent a milestone with a small duration, add a separate marker series, or simply label the date in the worksheet. Choose a method that does not imply a milestone lasts longer than it really does.

When a spreadsheet chart works well—and when it does not

Excel is a reasonable choice when the schedule is short, one person or a small group maintains it, and the main goal is a visual overview. It is particularly convenient if the rest of the project information already lives in a workbook. You can place assumptions, a task list, and the chart together, then export or print the schedule for a meeting.

A workbook becomes harder to maintain as the project grows. If many tasks depend on one another, dates change frequently, several people edit at once, or the plan needs automatic critical-path and resource calculations, a manually maintained chart can become misleading. Excel will not automatically infer dependencies just because two bars touch or overlap. A linked formula-based schedule can calculate dates from predecessor tasks, but it takes deliberate setup and testing.

For collaborative work, Excel for the web can support shared editing when the workbook is stored in a compatible Microsoft cloud location and the account has access. Shared editing does not solve version-control problems if people download separate copies and edit them independently. Agree on one source of truth, identify who may change the schedule, and record meaningful updates. For complex projects, dedicated project-planning software may offer dependency management, notifications, workload views, and audit features that a simple chart lacks.

Common problems and how to fix them

Bars all begin at the same point: confirm the chart is a stacked bar chart and that Start is the first series. Hide its fill rather than removing the series.
Task order looks upside down: format the category axis and enable Categories in reverse order. The horizontal date axis may move to the top; adjust its axis-crossing setting if needed.
Dates display as large numbers: Excel stores dates as serial values. Apply a date number format to the horizontal axis, and check that the source cells contain actual dates.
The chart includes too much blank time: inspect the horizontal axis bounds and the earliest start and latest end in the data. A very old accidental date can stretch the timeline.
Bars appear a day short: decide whether duration means elapsed intervals or inclusive calendar days. For a task scheduled from October 5 through October 9 inclusive, use five calendar days; for elapsed time between the date values, the difference is four days.
Changes to the table do not appear: check the chart’s data range through Chart Design > Select Data. Rows added below the original range may not be included automatically in every setup.

Also check the workbook’s assumptions before presenting it. A chart can look polished while still using the wrong year, missing a task, or treating a planned date as a confirmed commitment. Label the schedule as provisional when dates are estimates, and include the date it was last updated if readers may rely on a printed copy.

Free alternatives to Excel

If you do not need Excel specifically, other spreadsheet applications can create a Gantt-style view using dates, durations, and stacked bars or colored cells. Free project-planning tools may be more suitable if you need dependencies or shared task updates, but free tiers can have limits on users, projects, storage, or features. Check the current plan details and export options before moving project data into a service.

A spreadsheet remains attractive because it is familiar and flexible, but portability is not guaranteed for every chart feature. A workbook may render differently in another spreadsheet app, especially if it uses complex formatting, formulas, or macros. If collaborators use different software, test a copy of the file and agree on whether the workbook or a PDF export is the authoritative version.

Frequently Asked Questions

Does Excel have a built-in Gantt chart template?
Excel does not offer a dedicated Gantt chart type in its standard chart gallery. You can create the effect with a stacked bar chart, or use a suitable template if one is available from Microsoft Create or another source.

Can I make an Excel Gantt chart without a paid subscription?
Yes. Excel for the web is available free with a Microsoft account and can handle a basic chart. Desktop Excel is a separate access question and may require a paid license or an eligible plan.

Can I download a free Gantt chart template for Excel?
Often, yes, although availability and download requirements vary by provider. Check whether the template works in your Excel version, whether it contains macros, and whether its date and duration calculations match your project.

Why do I hide the Start series instead of deleting it?
The Start values position the visible Duration bars along the date axis. Hiding the fill preserves that offset; deleting the series makes the duration bars start at the chart’s baseline instead.

Is Excel good for a large project schedule?
It can display a large list, but the chart may become difficult to read and maintain. If you need automatic task dependencies, critical-path analysis, workload management, or frequent team updates, compare Excel with project-planning software designed for those jobs.

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.