Build a Gantt Chart in Excel: Step-by-Step Guide

To build a Gantt chart in Excel for Microsoft 365 on Windows, list each task with a start date and duration, create a stacked bar chart from those values, then make the start-date series invisible. The visible bars will begin at the correct dates and show how long each task lasts; Excel does not have a dedicated built-in Gantt chart type.

What an Excel Gantt chart shows

A Gantt chart is a schedule displayed as horizontal bars against a time scale. Each row represents a task, the bar’s position shows when the task starts, and its length represents its duration. This makes it easier to see the sequence of work, overlaps, gaps, and the overall span of a project than it is in a plain list of dates.

Excel creates this effect with a stacked bar chart. The first series contains each task’s start date and acts as invisible spacing before the task bar. The second series contains the duration and appears as the visible bar. The start series is still present in the chart; hiding its fill makes it look like empty space.

A basic Gantt chart is a visual schedule, not a project-management system. It will not automatically determine dependencies, prevent resource conflicts, or reschedule later tasks when an earlier one slips. Those details can be tracked in additional columns or managed with dedicated scheduling software.

Prepare the task and date data

Start with one row per task and use actual Excel dates, rather than dates typed as text. A small planning table might include a task name, start date, finish date, and duration. For example, a project could have Research from April 6 to April 10, Draft from April 11 to April 17, and Review from April 20 to April 22. These are illustrative dates; the important point is to enter the start and finish separately.

In this layout, task names are in A2:A4, start dates in B2:B4, and finish dates in C2:C4. Enter the duration in D2 and fill the formula down for the other tasks: =C2-B2+1. With B2 set to April 6, 2026, and C2 set to April 10, 2026, the result is 5 calendar days. Adding 1 counts both the start and finish dates; without it, subtracting the dates would return 4.

Calendar-day duration is appropriate when a task is considered active across weekends. If a task is planned only for working days, decide how your team treats weekends and holidays before choosing a duration method. A chart can display either kind of duration, but its bars do not know whether a Saturday is a workday for your project.

Keep task names concise so they remain readable beside the chart.
Use consistent date conventions and confirm that Excel recognizes entries as dates.
Check that finish dates are not earlier than start dates and that durations are positive.
Include milestones as zero-duration markers only if you plan how to display them; a zero-length bar may be hard to see.

Create a chart-ready helper table

The source table contains a finish date, but the stacked-bar method needs the start date and duration as its two plotted series. Make a small, contiguous helper table in unused columns, for example F1:H4, with the headings Task, Start, and Duration. Link its rows to the source table: put each task name in F2:F4, each corresponding start date in G2:G4, and each duration in H2:H4. You can enter references such as =A2 in F2, =B2 in G2, and =D2 in H2, then fill those references down. In this example, each formula returns the value from its paired source row.

Keeping the chart data together makes chart creation more straightforward and avoids accidentally plotting the finish date as an extra series. It also makes the chart easier to maintain: when you change a source date or duration, the linked helper value updates. If you convert the source range to an Excel table with Insert > Table, new task rows can be easier to manage, although you may still need to extend or adjust the chart’s data range when adding tasks.

Insert the stacked bar chart

Select the complete helper range, including its headings, such as F1:H4.
Choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Choose Stacked Bar, not 100% Stacked Bar.
Check that task names appear as categories and that Start and Duration appear as the two chart series. If Excel assigned them incorrectly, use Chart Design > Switch Row/Column or Chart Design > Select Data to correct the chart data.
Click the chart title and replace it with a useful name, such as Website launch schedule.

Excel’s chart layout and button placement can vary slightly with window size, but the stacked bar chart is the key choice. If the bars appear as separate colored segments beginning at zero rather than positioned across dates, the chart may be a clustered bar chart instead. Change its type to Stacked Bar before formatting the axes.

Hide the start series and order the tasks

Click one of the chart’s Start segments to select that data series. Right-click and choose Format Data Series. In the formatting pane, open Fill & Line, set Fill to No fill, and set Border or Line to No line if an outline remains. The duration bars should now appear to start at their actual dates. Remove the Start entry from the legend if it is still shown: select the legend, click the Start entry, and press Delete, or remove the legend if it does not help explain the chart.

Bar charts commonly put the first category at the bottom, which can make the task order look reversed. Right-click the task-name axis and choose Format Axis. Under Axis Options, select Categories in reverse order. Depending on the chart, Excel may move the date axis to the top when you reverse the categories. If that happens, use the axis options to position the horizontal axis where it is easiest to read.

Do not delete the Start series to remove its color. Its values are what position the Duration bars along the timeline. Hiding the series preserves that offset; deleting it removes the offset and makes every task appear to begin at the chart’s origin.

Format the timeline and make the chart readable

Right-click the horizontal date axis and choose Format Axis. In Axis Options, adjust the bounds to show a useful project window and change the major unit if the labels are too crowded. A short project may be clearest with daily or weekly divisions; a long project may be easier to scan by month. Date-axis settings depend on the dates in the plotted data, so first confirm that Excel is treating the Start values as dates.

Use the Number section of the Format Axis pane to choose a date display, such as a short month-and-day format. Formatting the axis changes how dates are displayed, not the underlying task dates. Avoid showing so many labels that they collide. You can also widen the chart, reduce the font size modestly, or shorten task names rather than forcing every date label into a narrow space.

For a clear chart, use a single strong color for ordinary task bars and reserve a second color for a meaningful category or phase. To color bars by workstream, add separate duration series for those categories and use blank or zero values where a task does not belong to a series; this takes more setup than the basic chart. For a simple schedule, one duration series is usually easier to maintain. Add data labels only when readers need exact durations, because labels on a crowded chart can obscure the bars.

Excel dates are stored as serial numbers, which is why a date axis can be scaled numerically. If you manually set axis bounds, use values that correspond to the desired dates and check the resulting labels; do not type a date in a format Excel rejects for that setting. The simplest approach for a first chart is to let Excel choose bounds, then refine the displayed range in Format Axis.

Update the schedule and share it

When a task’s start or finish date changes, update the source table and verify the duration. The helper cells should reflect the revised values, and the chart should move or resize the associated bar. When adding a task, add a row to the source and helper data, then confirm that the chart includes the new row. A chart based on a fixed cell range may not expand just because data was typed below it.

Before sharing, check the chart against the task table. Confirm that every task appears once, that the first and last dates are visible, and that the bar lengths match the intended durations. If the schedule is printed, use a landscape page layout or move the chart to a chart sheet if that improves readability. Save the workbook as an Excel workbook to preserve editable chart data. Exporting or printing a chart is useful for a static report, but recipients will not be able to change the schedule from an image or PDF.

For collaboration, store the workbook in a shared location supported by your organization, such as OneDrive or SharePoint, and make clear who owns updates to the schedule. Excel for the web can open and edit many workbooks and charts, but some advanced chart-formatting controls may differ from the Windows desktop app. On Mac, the same stacked-bar approach applies, though ribbon labels and formatting-pane placement may differ. If a particular axis or series control is hard to find, use the chart’s formatting pane rather than assuming the Windows screen layout is identical.

Common problems and practical limitations

Every bar starts at the same point: the chart may be clustered rather than stacked, or the Start series may have been removed. Choose Stacked Bar and retain the Start series, then hide its fill.
Dates appear as numbers: apply a date number format to the horizontal axis. Also check that the source cells contain real Excel dates rather than text that only looks like dates.
Tasks appear in reverse order: use Categories in reverse order on the task axis and check where the horizontal axis moves.
Bars are too thin or too far apart: right-click a duration bar, choose Format Data Series, and reduce Gap Width. A smaller gap makes bars thicker.
The chart omits a new task: inspect Chart Design > Select Data and extend the chart data range to include the new helper row.
The duration is one day short: for inclusive calendar-day counting, subtract the start from the finish and add 1. Confirm that this convention matches how your team defines a task’s duration.

A basic Gantt chart also has limits beyond formatting. It does not automatically show task dependencies, calculate a critical path, or update successor dates when a predecessor changes. You can add columns for predecessor IDs, owners, status, or completion percentage, but those fields will not create scheduling logic by themselves. For a small project with a modest number of tasks, that simplicity can be an advantage. For a large project with many linked activities, frequent replanning, or resource allocation needs, manual chart upkeep can become error-prone.

Excel versus templates and dedicated project tools

Building the chart yourself gives you control over the data layout, colors, and reporting context. It is also useful when the schedule must sit beside budgets, notes, or other workbook calculations. A prebuilt Excel template can save setup time, but inspect its formulas, date assumptions, and chart range before relying on it. Templates vary, and a design that looks polished may still have fixed ranges or hidden assumptions about weekends.

Dedicated project-planning tools are worth considering when dependencies, shared ownership, automatic rescheduling, workload balancing, or portfolio reporting matter. Those capabilities vary by product and plan, so compare the features you actually need. Excel remains a reasonable choice for a straightforward timeline that a small group can update consistently; it is not necessary to move to another tool just because a schedule is displayed as bars.

Frequently Asked Questions

Does Excel have a built-in Gantt chart type?

No. Excel does not provide a chart type specifically named Gantt chart in the standard chart list. The common approach is to use a stacked bar chart, hide the start-date series, and display duration as the visible bars.

Can I make a Gantt chart without finish dates?

Yes, if you already know each task’s start date and duration. The chart needs a start value and a duration value for each task. If you only have a start date, you still need to estimate or otherwise supply a duration to draw a bar of meaningful length.

How do I show weekends in an Excel Gantt chart?

The date axis covers calendar time, including weekends. A task bar whose start and finish span Saturday or Sunday will cross those dates. If your duration counts workdays only, calculate that duration using your work calendar, but remember that a bar scaled across calendar dates can still visually span weekend days.

Can Excel show task dependencies automatically?

Not with the basic stacked-bar chart. You can record predecessor information in another column and manually adjust dates, but the chart does not automatically move dependent tasks when a date changes. Use a project tool with scheduling logic if automatic dependency management is essential.

Will the chart update when I add a task?

Only if the chart’s data range includes the new row or expands to include it. Check Chart Design > Select Data after adding tasks. Using a well-maintained Excel table or deliberately extending the chart range can reduce the chance that a new task is left out.

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.