Can You Make a Gantt Chart in Excel? Steps and Tips

Charts & pivot tables · Updated November 20, 2026

Yes. In Microsoft Excel for Microsoft 365 on Windows, you can make a Gantt chart by building a stacked bar chart from task names, start dates, and durations, then hiding the start-date bars. Excel does not provide a dedicated Gantt chart type, but this method creates a visual schedule you can update as dates or task lengths change.

What a Gantt chart shows

A Gantt chart displays project tasks as horizontal bars along a time scale. Each bar’s position represents when a task starts, and its length represents how long it lasts. A task list beside the chart supplies the names; the date axis gives the schedule context.

That makes a Gantt chart useful for seeing the overall timing of a project, spotting tasks that overlap, and communicating a schedule to people who do not need to read a detailed task table. For example, a small website project might include planning from March 2 to March 4, design from March 5 to March 12, and testing from March 13 to March 17. The chart makes the sequence and relative durations easier to scan than a list of dates alone.

Excel’s version is a chart built from ordinary worksheet data, not a specialized project-planning system. It can show timing clearly, but it will not automatically reschedule dependent tasks or manage a full project plan in the way dedicated project-management software may.

Prepare the task data

Start with one row per task and clear column headings. A useful layout is:

  • Task: A short label, such as Draft outline.
  • Start: The date the task is scheduled to begin.
  • End: The planned finish date, if you have it.
  • Duration: The number of days represented by the bar.

Enter start and end dates as real Excel dates, not text that merely looks like a date. Set the Duration column to a number format. Decide whether the schedule counts calendar days or working days before calculating durations; that choice affects how long bars appear. Keep task names concise, since long labels can crowd the chart.

If Start is in B2, End is in C2, and Duration is in D2, enter =C2-B2+1 in D2 and fill it down. For a task running from March 2 through March 4, the result is 3 days because this formula counts both the first and last date. If you prefer elapsed days, where the end date is not counted as a full day, omit the +1. Make sure end dates are not earlier than their start dates.

Build the basic chart in Excel

For the chart, Excel needs task labels, start dates, and durations. With headings in row 1 and tasks in rows 2 through 6, the data can be arranged as Task in column A, Start in B, End in C, and Duration in D. The End column is useful for calculation, but it is not plotted.

  1. Select the task names and start dates, including their headings, then hold Ctrl and select the matching Duration cells and heading. On a Mac, use Command to select the additional range. If selecting separate ranges is awkward, create a small adjacent chart-data table containing only Task, Start, and Duration.
  2. Choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Excel inserts a horizontal stacked bar chart.
  3. Click one of the Start series bars, right-click, and choose Format Data Series. In the formatting pane, open Fill & Line and set Fill to No fill. The start-date series remains part of the chart’s calculations but becomes invisible, leaving the Duration bars positioned at their start dates.
  4. Check that the task names appear as the category labels and that the Duration series is visible. If the data series are not arranged as expected, select the chart and use Chart Design > Select Data to review the series and category-label ranges.

The hidden Start series is the key to the technique. A standard bar chart would begin every visible bar at the same point. In a stacked bar chart, the invisible first segment shifts each duration bar along the date scale, so tasks with later start dates appear farther to the right.

Format the timeline and task order

Excel may initially scale the horizontal value axis from zero. Since Excel stores dates as serial numbers, a zero-based scale can leave the project bars squeezed near the far end. Right-click the horizontal date axis and choose Format Axis. Under Axis Options, set the Minimum bound to the serial number for the earliest start date in the project. To find that number, temporarily format a copy of the date as General; restore the original date cell afterward. Set the Maximum bound near the final planned finish date to avoid excess empty space.

In the same formatting pane, use the Number section to choose a readable date format. Adjust the major unit if the labels are too dense; a weekly interval may suit a short project, while a monthly interval can be clearer for a longer schedule. The best scale depends on the plan’s duration and the amount of detail the chart must show.

Task order may appear opposite to the order in the worksheet. Right-click the vertical category axis, choose Format Axis, and enable Categories in reverse order if you want the first task at the top. Review the horizontal axis afterward, because Excel can move where it crosses the category axis when the order changes. Add a useful chart title, remove unnecessary legend entries, and widen the chart if task names or date labels are crowded.

Show progress and dependencies

A basic Gantt chart communicates planned dates, not actual completion. To show progress, add a Progress column as a percentage and use a separate series or a carefully designed progress bar. One practical option is to make a second duration series representing completed time and format it with a distinct color. The chart data then needs to distinguish completed duration from remaining duration, and the plotted segments must add up to the planned task duration. Label the meaning clearly so readers do not confuse progress with a revised schedule.

Dependencies need similar care. Excel’s basic stacked bar chart does not automatically connect tasks or move later tasks when an earlier task slips. You can add predecessor information in a separate column, use arrows or connectors as annotations, or update start dates manually after a change. In a schedule with many linked tasks, frequent revisions, or resource assignments, this manual upkeep can become a source of errors.

For example, if design cannot begin until research is complete, record that relationship in the task table as well as showing the dates. A chart can make the planned sequence visible, but the underlying dependency information is what helps a team reason about what should happen after a delay.

Calendar days, workdays, and weekends

The simple duration formula counts calendar days, including weekends. That is appropriate for tasks that continue every day, such as a waiting period, but it may overstate the time available for work scheduled only Monday through Friday. For a workday count, Excel’s NETWORKDAYS function counts weekdays between two dates, including both endpoints when they are weekdays. If Start is in B2 and End is in C2, use =NETWORKDAYS(B2,C2). It returns 5 for a Monday-to-Friday task with no holidays in that span. You can also provide a range of holiday dates as an optional third argument.

A working-day count does not by itself create a business-calendar axis: the chart’s date axis still represents calendar time, so weekends occupy space. That is often acceptable for a simple overview. If weekends must disappear from the timeline or the plan follows complex calendars, Excel’s ordinary bar chart may need extensive customization or a different tool.

Common problems and fixes

  • Bars all start at the same point: Confirm that the chart is a stacked bar chart and that Start is the first series. Hiding the Start series should not mean deleting it.
  • The chart has a huge empty area: Set the horizontal axis minimum near the earliest project start date instead of leaving it at zero.
  • Tasks are in the wrong order: Use Categories in reverse order on the vertical category axis, then check where the horizontal axis crosses.
  • Dates appear as large numbers: Format the horizontal axis labels as dates. The underlying Excel dates are numeric values.
  • Bars are unexpectedly long or short: Check whether Duration counts calendar days or workdays, and verify that dates are genuine date values.
  • Changes do not appear: Check that the chart’s source ranges include the edited rows. If the task list will grow, consider converting it to an Excel table with Home > Format as Table before creating or adjusting the chart.

Keep a copy of the task data in the worksheet even if you share the chart by itself. The chart is only as accurate as its source values, and retaining the table makes it easier to audit date changes or correct a mistaken duration.

When Excel is enough—and when to choose another tool

Excel is a good fit for a small or moderately sized schedule when the main need is a visual overview, the dates change occasionally, and someone can maintain the source table. It is flexible, familiar to many readers, and does not require a special Gantt-chart add-in. The chart can also be copied into a report or presentation, though it may need resizing and formatting after pasting.

A dedicated project-planning application is worth considering when the plan has many task dependencies, frequent baseline changes, shared updates, workload or resource constraints, or automated rescheduling requirements. Such tools can provide scheduling features that a manually maintained Excel chart does not. The trade-off is learning the tool and potentially paying for a service or license. There is no universal task-count limit at which Excel stops working; complexity and how often the plan changes matter more than the number of rows alone.

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 menu. Templates may be available through Excel’s template options, but the commonly used chart method is a stacked bar chart with the start-date series hidden.

Can I make a Gantt chart in Excel without a formula?
Yes. You can enter duration values directly if they are already known. A formula is useful when you have start and end dates and want the duration to update automatically when either date changes.

Can the Gantt chart update when I change a date?
Yes, if the chart’s source range includes the changed cell. The bar position or length should update when its start date or duration changes. A change to one task will not automatically reschedule tasks that depend on it.

Can I make a Gantt chart in Excel on a Mac?
Yes. The stacked bar chart approach is available in Excel for Mac. Ribbon wording and the formatting pane can vary slightly by release; use Command rather than Ctrl when selecting separate ranges. Excel for the web can also create and format charts, though some chart-formatting controls may differ from the Windows desktop app.

Can Excel show project milestones?
Yes, but milestones are not a special feature of the basic chart. You can represent one with a zero- or one-day task and format it distinctly, or add a marker as a separate chart series. Check the scale and labels so the milestone remains visible.

Related

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.