Does Excel Have a Gantt Chart? How to Make One

Excel does not include a dedicated Gantt chart type, but you can make a useful Gantt-style schedule in Microsoft Excel for Microsoft 365. The two common approaches are a stacked bar chart, which presents tasks as bars on a date axis, and a worksheet grid colored with conditional formatting.

What a Gantt chart in Excel actually is

A Gantt chart is a timeline view of project work. Each task appears on its own row, and a horizontal bar shows when it starts and how long it is expected to last. This makes it easier to see overlapping work, gaps, and the overall project span than it is in a plain task list.

Excel treats a Gantt chart as a visual arrangement of ordinary worksheet data rather than as a distinct chart category. Its built-in chart tools do not offer a button labeled Gantt chart. Instead, a stacked bar chart can imitate one: the first data series positions each task at its start date, and a second series draws the task’s duration. The start-date series is made invisible, leaving the duration bars floating in the correct places on the timeline.

That distinction matters when you look for a chart to edit later. The result is still an Excel chart, but it depends on its source table and formatting. A conditional-formatting version is even more worksheet-like: dates run across the columns, tasks run down the rows, and cells are colored where a task is active.

Make a Gantt chart with a stacked bar chart

For a compact project plan, create a table with one row per task and columns for the task name, start date, and duration. Enter real Excel dates in the start-date column, not text that merely looks like a date. For example, a task called Design could start on April 6 and last five days. A second task can overlap it if the work is planned to happen at the same time.

Arrange the columns as Task, Start, and Duration. Use a number of days for Duration, and check that every task has a valid start date and a positive duration.
Select the task names, start dates, and duration values, including the column headings. On Windows, choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar.
If the chart plots the data in an unhelpful direction, use Chart Design > Switch Row/Column or adjust the selected data so each task is a category and Start and Duration are the two series.
Click a bar in the Start series, right-click, and choose Format Data Series. In the formatting pane, set its fill to No fill and its line to No line. The invisible series still takes up space, shifting each visible duration bar to its start date.
Format the category axis so the task order reads naturally. Excel often puts the first task at the bottom; in Format Axis, look for the option to show categories in reverse order if you want the first task at the top.
Add a useful chart title, adjust the date axis to show a sensible project period, and remove a legend entry for the invisible Start series if it is confusing.

The precise pane labels can vary slightly as Microsoft updates Excel, but the underlying chart type and formatting approach remain the same. On Excel for Mac, the chart tools are also on the Insert tab and the formatting pane is available by selecting the chart element; some ribbon layouts and pane controls differ from Windows. Excel for the web can create and edit many charts, though some detailed formatting controls may be more limited than in the desktop app.

Build a date-grid version with conditional formatting

A grid can be easier to read when the plan needs day-by-day detail or when people will update the worksheet directly. Put task names in column A, start dates in column B, and durations in days in column C. Put actual dates across row 4, beginning in E4, and leave the cells below those dates available for the task bars.

With task data in B5 and C5 and the timeline dates in row 4, select the timeline area for the task rows, such as E5:AI20. Choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format, enter the formula below, and choose a fill color. Make sure the rule applies to the full timeline area, not just the first cell.

Assuming B5 contains the task start date, C5 contains its duration in calendar days, and E4 contains the date at the top of the first timeline column, use =AND(E$4>=$B5,E$4<=$B5+$C5-1). For a task starting April 9 with a three-day duration, the cells dated April 9, 10, and 11 meet the rule; a cell dated April 12 does not. The minus one makes the start date count as the first of the three days.

When you extend the rule across the selected range, the row number for the date header stays fixed while the task-row references adjust. This is why the formula uses E$4 for the header and $B5 and $C5 for the task data. If your schedule should count working days instead of calendar days, this simple rule is not enough: weekends need to be excluded, and holidays may need separate treatment. Decide what duration means before presenting the timeline.

Start from a template or a blank workbook

A template can save setup time if you want a preformatted schedule rather than a chart-building exercise. In desktop Excel, open File > New and search the available templates for Gantt. What appears can depend on the Excel version, connected services, account, and organization settings, so a particular template is not guaranteed to be available to everyone.

Before entering project information into a downloaded or shared template, inspect how it works. Check whether dates are formulas or manually entered, whether duration means calendar or working days, and whether the chart includes weekends. Also look at the print layout and any sample data. A polished template can still use assumptions that do not match your project.

A blank workbook is often preferable for a small plan with unusual needs. You can decide which fields to track, whether to include owners or milestones, and how to handle weekends. Keep the input table separate from the visual schedule where possible; a clean source table is easier to sort, correct, and reuse than a chart whose data is scattered around the sheet.

Choose the chart or the colored grid

Neither Excel method is automatically best. A stacked bar chart is usually the clearer choice for a presentation or a high-level view across several weeks or months. It puts tasks on a shared date axis and avoids requiring a separate worksheet column for every day. It can also be resized and placed alongside project notes.

A conditional-formatting grid is useful when the team wants to scan individual dates, add notes in the same rows, or see a short schedule at daily resolution. It is also straightforward to extend with additional formatting rules, such as a different color for a milestone or a weekend shade. However, a long timeline creates a wide worksheet and can become difficult to print or view on a small screen.

Choose a stacked bar chart when the priority is a concise visual summary.
Choose a date grid when people need to inspect or update day-level cells.
Use a simpler task table when dates and owners matter more than visual timing.
Consider dedicated project software when the plan depends on many linked tasks, shared updates, or automated scheduling.

Common problems and how to fix them

The bars start in the wrong place. Check that Start is plotted as the first series and that the chart type is Stacked Bar, not Clustered Bar. Then make the Start series invisible. If it is deleted instead of hidden, Excel has nothing to position the duration bars against.

The task order looks upside down. The category axis may be displaying the first source row at the bottom. Use the category-axis formatting option for reverse order and check whether the horizontal date axis crosses at an unexpected position afterward.

The date axis covers too much time. Excel may choose broad minimum and maximum bounds based on the underlying date values. Format the horizontal axis and adjust its bounds or units where the controls allow it. Since Excel stores dates as serial numbers, avoid typing an arbitrary number without understanding what date it represents. If the axis labels look like numbers, apply a date number format.

The grid colors the wrong days. Confirm that the header cells contain real dates, the duration is numeric, and the conditional-formatting rule begins at the same top-left cell as its applied range. A one-row mismatch can make a rule refer to the wrong task. Also check whether the duration is intended to include weekends; the basic example counts every calendar day.

Changes do not appear as expected. Make sure the chart’s source range includes new tasks and that formula-driven values recalculate. Sorting only part of a task table can disconnect names from their dates, so sort the complete table or use a structured Excel table. Save a separate copy before making major formatting or structural changes.

Showing progress, milestones, and dependencies

A basic Gantt view shows planned start dates and durations; by itself, it does not tell a viewer whether work is complete or whether a task is late. To show progress in a stacked bar chart, the source data can include completed duration and remaining duration as separate series after the start-date offset. Format the offset series as invisible, then give completed and remaining work distinct colors. Keep the planned dates and progress values clear in the table so readers can distinguish the original plan from current status.

Milestones are usually zero-duration events, so they may not produce a visible bar. Represent one with a marker series or a clearly labeled symbol, or give the milestone a small visual marker that does not misstate its duration. Dependencies also need explicit information, such as a predecessor column. Excel’s basic chart will not automatically reschedule dependent tasks when one date changes; the chart reflects the values in its source data, not a project-management scheduling engine.

For a plan used in meetings, include a date of last update and identify who maintains it. A chart with accurate-looking bars can still mislead if actual progress is stale or if workdays, holidays, and task dependencies are not defined.

When Excel is enough—and when it is not

Excel is a reasonable option for a small or moderately sized plan when a few people need a flexible schedule and someone is responsible for maintaining the data. It is especially convenient when the project information already lives in a workbook and the Gantt view is a reporting aid rather than the system that controls the work.

As a project grows, manual upkeep becomes the trade-off. Excel does not automatically provide the full scheduling behavior of dedicated project-management software: task relationships, resource workloads, shared status workflows, and automatic adjustment of dependent dates may require extra design or another product. A workbook can also become harder to coordinate if several people edit separate copies. Choose based on the process you need, not just on whether Excel can draw bars.

Frequently Asked Questions

Does Excel have a built-in Gantt chart template?
Excel has no dedicated Gantt chart type, but templates may be available through File > New and a search for Gantt. Availability varies, and you can also build a chart or grid yourself.

Can I make a Gantt chart in Excel for free?
If you already have access to Excel, you can create a basic Gantt-style view with its chart and worksheet tools; there is no separate Gantt chart feature to purchase inside the workbook. Whether Excel itself is included at no additional cost depends on your license or access arrangement.

Can Excel show task dependencies?
You can record predecessors in a worksheet and draw or label relationships manually, but a standard stacked bar chart does not automatically calculate dependent task dates. For automatic scheduling, you may need a more specialized project tool.

Can I make a Gantt chart in Excel on a Mac or in a browser?
Yes. Excel for Mac has chart and conditional-formatting tools, though some ribbon and formatting-pane details differ from Windows. Excel for the web can handle many basic workbook tasks, but some chart-formatting controls may be more limited.

Should I use calendar days or working days?
Use whichever matches the project’s planning rules, and state that choice in the workbook. A simple duration bar or conditional-formatting rule commonly counts calendar days; excluding weekends and holidays requires additional logic and a defined holiday calendar.

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.