Create a Gantt Chart in Excel: A Practical Step-by-Step Guide

To create a Gantt chart in Excel, list each task, its start date, and its duration, then insert a stacked bar chart using the start dates and durations as the two data series. Hide the start-date series and format the date axis so the remaining bars show when each task runs and how long it lasts.

What a Gantt chart shows

A Gantt chart is a project schedule displayed on a timeline. Each task appears as a horizontal bar: the bar’s position shows its start and finish, and its length represents the task’s duration. A chart can also make overlaps, gaps, and the order of work easier to see than a plain list of dates.

Excel does not have a dedicated Gantt chart button in the standard chart gallery. Instead, you build one from a stacked bar chart. The first series, made from start dates, shifts each task’s visible bar to the right place on the timeline. The second series, made from durations, becomes the visible task bar.

This is useful for a small or moderately sized schedule that needs to be shared or customized in a workbook. It is not automatically a project-management system: dependencies, resource conflicts, and schedule changes require extra setup or manual attention.

Prepare the task data

Start with a simple table. Put the column headings in row 1, with task names in column A, start dates in column B, end dates in column C, and duration in column D. For example, a task running from April 6 through April 8, 2026, has a three-day calendar duration when both the start and end dates count.

With start dates in B2:B20 and end dates in C2:C20, enter this in D2 to calculate the inclusive duration for the task in row 2: =C2-B2+1. If B2 is April 6, 2026, and C2 is April 8, 2026, the result is 3. Fill the formula down for the remaining task rows. Format the start and end columns as dates and the duration column as a number.

Check the source data before making the chart:

Use real Excel date values, not dates typed as text. A quick clue is that changing a date cell to General displays a number.
Make sure each end date is on or after its start date. A negative duration indicates an input error.
Decide whether durations count calendar days or working days. The example formula counts every date, including weekends and holidays.
Keep task names concise enough to fit beside the chart, and avoid blank rows inside the data range.

If your project tracks working days only, calculate the schedule using a working-day calendar before charting it. Excel’s NETWORKDAYS function can count working days between dates, but the chart’s timeline still represents calendar dates, so a task bar may visually span weekends even if those days are not counted as work.

Insert a stacked bar chart

In Excel for Microsoft 365 on Windows, select the task names, start dates, and duration columns, including their headings. If the columns are not next to one another, select the first range, then hold Ctrl while selecting the other ranges. Choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Do not choose 100% Stacked Bar: that chart normalizes the series and does not represent the schedule correctly.

Excel may include the task names as category labels automatically. If it does not, right-click the chart and choose Select Data. In the Select Data Source dialog, check that the two plotted series are Start Date and Duration, and that the category labels refer to the task-name cells. Edit the series or label ranges there if the chart picked up the wrong columns.

Because Excel plots the start-date series as a bar, the chart initially shows a large block from the chart’s origin to each task’s start date. That block is a positioning device, not part of the task. Select one of the start-date bars, open Format Data Series, and set Fill to No fill. Set Border to No line if an outline remains. The duration bars should now appear in their correct positions along the timeline.

Format the timeline and task labels

Click the vertical category axis—the list of task names—and open Format Axis. Under Axis Options, select Categories in reverse order if you want the first task at the top. Excel often puts the first category at the bottom by default. Reversing the categories can also move the horizontal axis to the top; if that happens, look for the setting that controls where the horizontal axis crosses and choose the appropriate category position.

Format the horizontal value axis to make the dates readable. Excel stores dates as serial numbers, so the axis bounds may appear as numbers rather than familiar dates. Set the minimum and maximum bounds to the serial values for the project’s desired start and end dates, then use the Number section of Format Axis to display a date format. You can find a date’s serial value by temporarily formatting a worksheet date cell as General. Leave a little space before the first task if you want the chart to show a lead-in period.

Adjust the gap between bars in Format Data Series. A smaller Gap Width makes task bars thicker; a larger value leaves more space between them. Add a chart title, choose a restrained color, and remove the legend entry for Start Date if it is still visible. A clear title such as “Website launch schedule” is more useful than the default “Chart Title.”

For a chart that will be printed or pasted into a report, check that the date labels remain legible at the final size. Widen the chart, reduce unnecessary gridlines, and use a date format that suits the schedule, such as month and day for a short project. Avoid shrinking the font until task names become difficult to read.

Make the chart update with the schedule

A chart based on a fixed range such as A1:B10 and D1:D10 will not necessarily include new tasks added below row 10. One simple improvement is to convert the task list into an Excel table: select the data and choose Insert > Table, confirming that the table has headers. Tables expand as rows are added, and charts connected to table data can expand with them. Check the chart’s data source after adding rows, since behavior can depend on how the chart was created and edited.

When a task date or duration changes, the chart updates if its plotted ranges still point to the correct cells. Keep the chart and source table in the same workbook, label the data clearly, and avoid typing over formula cells. If you share the workbook, explain whether durations mean calendar days or working days; otherwise, readers may interpret the bars differently.

Excel’s standard chart does not automatically understand task dependencies. If Task B must start after Task A, changing Task A’s dates will not necessarily move Task B. You can calculate dependent dates with worksheet formulas, but that is a separate scheduling design decision. For a small plan, an explicit predecessor column and regular review may be enough; complex dependencies need a tool designed to manage them.

Common problems and fixes

The chart shows a solid block from the left edge. The start-date series is probably still visible. Select that series and set its fill to No fill.
Dates appear as large numbers. The axis is displaying Excel date serials. In Format Axis, change the Number format to a date format.
The tasks run in the wrong order. Reverse the category order on the vertical axis, then check whether the horizontal axis needs to be repositioned.
Bars are missing or oddly short. Confirm that start and end entries are real dates, duration values are positive numbers, and the chart uses Stacked Bar rather than 100% Stacked Bar.
New tasks do not appear. Extend the chart’s data range or use a table-based source and verify the chart’s selected ranges.
Weekends make a task look longer than expected. The chart uses a continuous calendar timeline. A duration that counts workdays is not the same as the number of calendar dates spanned by the bar.

Excel Gantt charts compared with other options

Excel is a practical choice when you already maintain project information in a spreadsheet, want control over the appearance, or need a chart for a report. It is also easy to distribute as part of a workbook. The tradeoff is that you create and maintain the chart yourself; Excel will not automatically provide every project-management feature.

Dedicated project-planning applications are generally better suited to large schedules with many dependencies, assigned resources, baselines, changing calendars, or progress tracking. They can calculate how a change affects linked tasks and may provide collaboration features that a manually assembled Excel chart does not. Google Sheets can also create a similar stacked-bar-chart workaround, but its menu names and chart controls differ from Excel’s.

There is no separate charge for using the standard Gantt-chart technique beyond access to Excel. Whether Excel is available to you depends on your Microsoft 365 or Office arrangement. A specialist app may have its own subscription or licensing costs, so compare the features you actually need rather than choosing based on the chart alone.

Excel for Mac and Excel for the web

The core method works in current Excel for Mac and Excel for the web: organize the task data, insert a stacked bar chart, hide the start-date series, and format the axes. Ribbon labels and the location or availability of individual formatting controls can differ from Excel for Microsoft 365 on Windows. If a named control is not visible, select the chart element and look for its formatting pane or chart-formatting options.

On a Mac, Ctrl-click is commonly used in place of a Windows right-click when a mouse or trackpad is configured for that action. Keyboard shortcuts also differ: Windows uses Ctrl for many commands, while Mac versions commonly use Command. The steps above rely on chart menus and controls rather than a particular shortcut, so they are easier to follow across platforms. Excel for the web may offer fewer detailed chart-formatting controls than the desktop application.

Frequently Asked Questions

Does Excel have a built-in Gantt chart template?
Excel may offer project templates through its template gallery, and available templates can vary. The standard chart method does not rely on a dedicated Gantt chart type: it uses a stacked bar chart with a hidden start-date series.

Can I make a Gantt chart without an end-date column?
Yes. If you already have a duration for every task, use the start date and duration as the plotted series. If you have start and end dates instead, calculate duration by subtracting the start date from the end date and adding one when both dates count.

How do I show task progress?
Add a progress value to the task table, then decide how to represent it. A simple approach is to use a second bar or a separate progress column in the worksheet; building a progress overlay into the chart requires additional series and careful formatting. Do not confuse percentage complete with elapsed days.

Can Excel show task dependencies?
A basic Gantt chart can display tasks in a chosen order, but it does not create or enforce dependencies by itself. You can add predecessor information and formulas to calculate dates, but linked schedule updates require deliberate setup.

Why does my chart start in 1900?
The hidden start-date series is being displayed, or the horizontal axis bounds have not been set to the project’s date range. Hide the start-date series and adjust the axis bounds so the timeline begins near the first planned task.

Can I save or share the chart separately?
You can copy the chart into another Office document or keep it in the workbook with its source data. If sharing a standalone image, remember that it will not update when task dates change; keep the workbook if recipients need an editable schedule.

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.