Gantt Chart in Excel: How to Add One and Format It

To add a Gantt chart in Excel for Microsoft 365 on Windows, arrange each task with a start date and duration, select the task, start-date, and duration columns, then choose Insert > Insert Column or Bar Chart > 2-D Stacked Bar. Format the start-date series with no fill so only the duration bars show. Excel has no dedicated Gantt chart type, but this stacked-bar method creates a useful project timeline.

What an Excel Gantt chart shows

A Gantt chart places tasks in rows and dates along a horizontal timeline. Each bar begins at the task’s start date and extends for its duration, making it easier to see what is scheduled, what overlaps, and where a project has long gaps. A simple chart is useful for a personal plan, a small team project, or a presentation where readers need to understand the schedule at a glance.

Excel builds this display from a stacked bar chart. The first series is the number of days between Excel’s date-system starting point and each task’s start date. That series shifts the visible bar into position. The second series is the task duration. Making the first series transparent hides the offset while leaving the duration bar visible. The chart is therefore a visual workaround, not a separate scheduling feature.

That distinction matters: Excel will not automatically understand task dependencies or reschedule later tasks when an earlier task slips. The chart reflects the dates and durations in its source table. You need to update those values yourself, or use a project-management tool if you need automatic scheduling.

Prepare a clear task table

Start with a small, tidy table. Put one task on each row, use real Excel date values rather than text that merely looks like a date, and include column headings. For example, use columns in this order: Task, Start date, Duration, Finish date. Keeping the chart’s three input columns together makes it straightforward to select the data.

If you have start and finish dates and want to calculate an inclusive calendar-day duration, put the formula below in C2, where task names are in A2:A6, start dates are in B2:B6, and finish dates are in D2:D6. Copy it down for the remaining tasks. With a start date of January 6 and finish date of January 10 in a non-leap year, the result is 5 days, counting both the first and last dates.

=D2-B2+1

Make sure the start and finish cells contain valid dates and that the finish is not earlier than the start. This formula counts calendar days, including weekends. If your project measures duration in working days, the bar still uses a calendar timeline; weekends will appear as part of the span unless you build a more specialized workday-based chart. A simple Gantt chart also does not calculate holidays or working hours on its own.

Use short task names that remain readable beside the bars.
Choose one consistent date convention, such as dates inclusive of both the start and finish.
Break large phases into smaller tasks if a single bar would conceal important scheduling detail.
Leave out blank rows in the chart data range; blank entries can create empty categories.

Create the stacked bar chart

Once the table is ready, create the chart from the task names, start dates, and durations. In the example layout, these are columns A through C. Include the heading row so Excel can use the headings as series names.

Select the task names, start dates, and durations, including their headings. If the columns are together, select the full range, such as A1:C6.
On the ribbon, choose Insert > Insert Column or Bar Chart > 2-D Stacked Bar. Do not choose 100% Stacked Bar: that chart normalizes the bars to equal lengths and does not represent the actual schedule.
Check that task names appear as categories and that the chart contains a start-date series and a duration series. If Excel assigns the data in the wrong direction, use Chart Design > Switch Row/Column.
Move or resize the chart so task labels and the timeline are legible. You can drag it within the worksheet or use the chart formatting controls to adjust its size.

Excel may initially show both series as colored bars. That is expected. The start-date series is the invisible spacer you will format next. If the chart has the wrong categories or only one series, return to Chart Design > Select Data and confirm that the task, start-date, and duration ranges are included.

Hide the spacer and set the timeline

Click a bar in the start-date series, taking care to select that series rather than an individual task’s duration. Right-click and choose Format Data Series. In the formatting pane, open Fill & Line, set Fill to No fill, and set the border or line to No line. The start-date values still position the duration bars, but the spacer itself becomes invisible. On Mac, Excel has the same chart-formatting controls, although the pane’s appearance and ribbon layout can differ slightly.

Next, make the category order and date scale easy to read. Right-click the vertical task axis and choose Format Axis. Under Axis Options, turn on Categories in reverse order if you want the first task at the top. Reversing categories can move the horizontal date axis to the top of the chart; adjust the axis-crossing setting if you prefer it at the bottom.

The horizontal axis is based on Excel’s numeric date values. If the chart includes a large empty stretch before the first task, right-click that axis, choose Format Axis, and set its minimum bound to the Excel date serial for the project’s earliest start date. To see a date’s serial, format a copy of the start-date cell as General; restore its date format afterward. You can set the maximum bound near the project finish as well, so the chart focuses on the schedule rather than unused time.

While the horizontal axis is selected, set its number format to a readable date format and choose a suitable major unit. A major unit of 7 displays weekly intervals; a smaller interval may suit a short plan, while monthly labels may be clearer for a long project. The right choice depends on the project’s timescale and the space available. If the chart labels overlap, widen the chart or show fewer date labels rather than shrinking text until it is difficult to read.

Improve readability and communicate status

Give the chart a specific title, such as Product launch schedule, and remove the legend if it only lists the hidden start-date series and duration series. To remove it, select the legend and press Delete. A clear title and a visible date scale often communicate more than a default legend. Use consistent colors for task bars, and reserve a distinct color for a meaningful category such as a milestone or a critical phase.

A basic Gantt chart uses one bar per row, so it does not automatically display progress within a task. You can show progress by adding a separate progress series or by making an additional bar for completed work, but that takes careful setup and can make a small chart harder to maintain. For a quick status view, a simpler option is to add a Progress column to the source table and use labels or colors to distinguish tasks that are not started, underway, or complete. Do not imply that a bar is actual progress if it only represents planned duration.

For a chart intended for printing or sharing, check the worksheet at its final size. Long task names may be cut off, small date labels may become unreadable, and colors that look distinct on screen may be hard to distinguish in grayscale. Consider adding a data-source note or an as-of date if readers might mistake a snapshot for a live schedule. A chart title, clear date units, and a visible status date help prevent that misunderstanding.

Common problems and fixes

The bars start near the beginning of Excel’s timeline: The horizontal axis may start at zero, leaving a huge blank area. Set the minimum bound to the earliest task start date’s serial value.
The chart shows colored bars before every task: The spacer series has not been hidden, or it has a visible border. Set both its fill and line to No fill and No line.
Tasks appear in the opposite order: Format the category axis and change Categories in reverse order. Check where the date axis moves afterward.
All bars look nearly the same length: Confirm that you selected 2-D Stacked Bar, not 100% Stacked Bar, and that the duration cells contain numbers rather than text.
Dates display as numbers: Select the date axis and apply a date number format. Also confirm that source dates are valid Excel dates.
Changing a date does not appear to update the chart: Check that the edited cell is inside the chart’s source range and that calculation and chart data are current. Use Chart Design > Select Data to inspect the range.

Another common misconception is that bars automatically show task dependencies. A bar chart only shows the values in its table. If Task B must begin after Task A, Excel will not enforce that relationship in this chart. You must revise Task B’s start date when the schedule changes, or use software that supports linked tasks and dependency logic.

When Excel is enough—and when to use another tool

Excel is a practical choice when the schedule is relatively small, the dates are maintained by one person or a small group, and the main need is a visual summary. It is flexible: you can add columns for owners, status, or workstream, filter the source table, and customize the chart for a report. A basic chart can be made with standard Excel features and does not require a paid add-in.

The trade-off is manual maintenance. The chart does not provide a full project-management system, automatic dependency scheduling, resource leveling, or built-in collaboration workflows. A template can save setup time, but inspect its formulas, chart ranges, and assumptions before relying on it. Some templates include macros; macros may be blocked by security settings and should only be enabled when you trust the file’s source.

For many linked tasks, changing deadlines, shared updates, or resource assignments, compare Excel with a dedicated project-planning application. Such tools may calculate downstream dates from dependencies and offer collaboration features, but they may involve subscriptions, setup, or learning a new workflow. Choose based on what the schedule must do, not just on how attractive its chart looks.

Frequently Asked Questions

Does Excel have a built-in Gantt chart?
Excel does not have a dedicated Gantt chart type in the standard chart menu. The common method is to make a 2-D stacked bar chart, use start dates as an invisible offset series, and display durations as the visible bars.

Can I make a Gantt chart in Excel without a template?
Yes. Create a task table with start dates and durations, insert a 2-D Stacked Bar chart, hide the start-date series, and format the axes. A template is optional; making the chart yourself can make its source data and assumptions easier to inspect.

How do I show weekends in an Excel Gantt chart?
A basic chart’s date axis spans calendar dates, so weekends appear between weekdays. If your duration is calculated using working days, decide whether you want bars to span calendar time or use a more advanced design that excludes nonworking days; the simple stacked-bar setup does not automatically skip weekends.

Can I make a Gantt chart in Excel for Mac?
Yes. Excel for Mac also supports stacked bar charts and series formatting. The ribbon or formatting-pane layout can differ from Windows, but the core process—charting task, start-date, and duration columns, then hiding the start-date series—is the same.

Will the chart update when I change a task date?
It should update when you change a value inside the chart’s source range. If it does not, inspect the range through Chart Design > Select Data and confirm the edited date is a real Excel date and that the chart includes that row.

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.