Excel Gantt Charts: What’s Built In and How to Make One

Excel does not include a dedicated Gantt chart type, but you can make a Gantt chart with its stacked bar chart tools or conditional formatting. It also offers project-planning templates in some versions, so you can start from a prepared layout instead of building one from scratch.

What Excel means by a Gantt chart

A Gantt chart is a project schedule displayed on a calendar timeline. Each row represents a task, and a horizontal bar shows when that task starts and how long it lasts. The rows together make it easier to see the order and overlap of work than a plain list of dates.

Excel’s standard chart list does not have a chart type named “Gantt.” The usual chart-based workaround uses a stacked bar chart: one series positions each task at its start date, and a second series displays its duration. Formatting the start-date series so it is invisible leaves the duration bars in place on a date axis. Another option is to use a grid of dates and conditional formatting to color the cells covering each task.

These approaches can produce a useful visual schedule, but they are not the same as a dedicated project-management feature. For example, Excel does not automatically recalculate task dates from dependency links in a Gantt chart. The schedule data and any dependency logic must be managed separately.

Start with an Excel template

If you want a quick starting point, open Excel for Microsoft 365 on Windows and choose File > New. Search for “Gantt” or “project plan.” Microsoft’s available templates can change, and results may depend on your Excel version, account, and internet access. A template is a workbook design, not a separate chart type; check its formulas, date scale, and instructions before relying on it.

Templates are useful when you want a prearranged task table, timeline, or styling. They can also be a good way to learn how a particular layout works. Before entering a real project, confirm which cells are intended for task names, start dates, durations, and completion status. Some templates use formulas or conditional formatting, so replacing cells or inserting columns without checking the layout can break the display.

If the template does not fit your needs, you can adapt it or create a chart manually. A simple table with one row per task is usually the clearest foundation. Keep the schedule data in ordinary cells, rather than typing task names or dates directly into the chart, so changes are easier to maintain.

Build a Gantt chart with a stacked bar chart

For a conventional chart, arrange the data in three columns: task name, start date, and duration. For example, put task names in A2:A6, start dates in B2:B6, and durations in calendar days in C2:C6. Use real Excel dates in column B, not date-looking text. You might list “Draft outline,” “Write content,” and “Review” with starts of March 2, March 5, and March 10, and durations of 3, 5, and 2 days.

Select the task names and the start-date and duration data, including their headings.
Choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar.
If the chart does not assign the task names to the category axis and the dates and durations to the two series, use Chart Design > Select Data to correct the series and category ranges.
Select the start-date series. Open Format Data Series, go to Fill & Line > Fill, and choose No fill. The start-date series still positions each task, but its bars become invisible.
Select the vertical category axis and, in Format Axis > Axis Options, turn on Categories in reverse order if you want the first task at the top.
Format the horizontal value axis so its minimum and maximum cover the project dates. Set an appropriate date number format, and adjust the chart title, gridlines, and bar colors for readability.

The duration series now appears to begin at each task’s start date, creating the Gantt effect. In the example, the “Draft outline” bar covers three calendar days beginning March 2. If you want a different scale, such as weeks, the chart data and axis formatting need to reflect that choice. A weekend is counted in a calendar-day duration; a workday schedule needs a different way to calculate or represent durations.

Make a timeline with conditional formatting

A cell-based schedule can be easier to customize than a chart, especially when you want extra columns for owners, status, or notes. Put task names in column A, start dates in column B, and durations in calendar days in column C. Put actual dates across row 1 beginning in F1, one date per column. Apply a fill color to the cells corresponding to the task dates.

For instance, with task data in rows 2 through 20 and timeline dates in F1:AZ1, select F2:AZ20. Choose Home > Conditional Formatting > New Rule, then select the option to use a formula to determine which cells to format. With the layout just described, use this formula:

=AND(F$1>=$B2,F$1<$B2+$C2)

Choose a fill in the formatting options and confirm the rule. The formula checks whether the date at the top of each column falls on or after that row’s start date and before its end boundary. With a March 2 start and a duration of 3, it colors March 2, 3, and 4. The exclusive end boundary avoids counting an extra day. The dollar signs keep the date-header row and the start-date and duration columns fixed as the rule fills across and down.

This grid is flexible, but it has trade-offs. A long project can require many date columns, and changing the timeline scale from days to weeks takes additional setup. If you insert rows or move the schedule, check the rule’s “Applies to” range so new tasks are included. This formula treats duration as calendar days, not working days.

Which method should you choose?

Choose a stacked bar chart when you want a compact visual with a genuine date axis, or when you expect to present the schedule as a chart. Choose conditional formatting when the schedule needs to sit beside detailed task information in the same worksheet. A template may be fastest when its structure already matches your project.

Template: A convenient starting point for a familiar project-plan layout, provided its formulas and assumptions suit your schedule.
Stacked bar chart: A clear timeline for communicating task timing, but it requires separate spreadsheet data and manual chart formatting.
Conditional formatting: A flexible, worksheet-based timeline that can show extra task details, though it can become wide for long schedules.
Dedicated project software: Worth considering when you need features such as linked dependencies, resource management, or automated rescheduling.

Think about who will update the plan, how often dates change, and whether the schedule is for tracking work or simply communicating dates. A small project with a handful of tasks may be well served by Excel. A complex plan with many interdependent tasks may be harder to maintain in a manually formatted workbook.

Limitations and common problems

The most common chart problem is that the first task appears at the bottom. Reverse the category order in the vertical axis settings. Another is a chart whose horizontal axis begins far earlier than the project: the hidden start-date series still determines where the duration bars sit, so adjust the axis bounds rather than deleting that series.

Also check that start dates are stored as dates. Excel stores dates as serial numbers, which is why a stacked bar chart can use them as positions. Text that merely looks like a date may not behave as expected. If the axis displays large numbers instead of calendar dates, change its number format. If a bar seems one day too long or short, verify whether your duration is counted inclusively and whether the schedule uses calendar days or working days.

Excel’s chart workaround does not provide automatic task dependencies. If task B must begin after task A, you need to enter or calculate task B’s start date yourself unless you build additional spreadsheet logic. Similarly, a colored bar does not prove that a task is complete; completion status needs its own data and, if desired, separate formatting. Avoid treating a visually polished schedule as a substitute for checking the underlying dates and assumptions.

Finally, charts can be less convenient to edit in a shared workbook if several people change the source data or chart formatting. Keep the source table clearly labeled, use consistent date conventions, and test changes on a copy or a small sample before changing a large schedule.

Excel versus dedicated Gantt software

Excel is useful when a team already works with spreadsheets, the project is modest in size, and the schedule needs to be customized or combined with other worksheet data. It is familiar, and a workbook can be shared or printed alongside budgets, notes, and status tables. The chart methods described here do not require a separate Gantt application, although Excel itself may require a Microsoft 365 or Office license depending on how you access it.

Dedicated project-management tools generally focus more directly on dependencies, progress tracking, resource assignments, notifications, and schedule changes that affect later tasks. Their capabilities and prices vary, and some may offer free tiers while reserving advanced features for paid plans. If those functions are central to the work, compare the tools’ current features, collaboration options, and costs rather than assuming a spreadsheet chart will provide them automatically.

Excel is not inherently unsuitable for project planning; the question is how much scheduling behavior you need. A chart that communicates a fixed set of dates is different from a system that recalculates a network of dependent tasks when one date moves.

Frequently Asked Questions

Does Excel have a built-in Gantt chart template?
Excel may show Gantt or project-plan templates under File > New, but availability can vary. Excel does not have a dedicated Gantt chart type in its standard chart list.

Can I make a Gantt chart in Excel for free?
The chart and conditional-formatting methods use Excel spreadsheet features, but access to Excel may be subject to a Microsoft 365 or Office license. You can also check whether Excel for the web or another spreadsheet tool meets your needs and has the features required for your layout.

Can Excel update task dates automatically when a dependency changes?
Not through the Gantt chart itself. You can build formulas to calculate dates, but Excel’s stacked bar chart does not provide automatic dependency scheduling as a dedicated project-management feature would.

Can I create a Gantt chart in Excel for Mac or the web?
Excel for Mac and Excel for the web offer spreadsheet chart and formatting tools, but their interfaces and available controls can differ from Excel for Microsoft 365 on Windows. Look for the equivalent stacked bar chart, axis-formatting, and conditional-formatting controls; some detailed chart options may be arranged differently.

Should I use a chart or conditional formatting?
Use a stacked bar chart when you want a presentation-style timeline with a date axis. Use conditional formatting when you want the timeline integrated into a detailed worksheet table. Either method still depends on accurate source dates and durations.

The practical answer

Excel can display a Gantt-style schedule, but it does not offer a dedicated Gantt chart type that automatically manages project logic. For a quick start, look for a template; for a custom visual, use a stacked bar chart; and for a schedule embedded in task data, use conditional formatting. Choose based on the amount of automation and collaboration your project actually requires.

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.