Gantt Chart in Excel: How to Insert One Step by Step

To insert a Gantt chart in Excel, arrange each task with a start date and duration, then insert a 2-D Stacked Bar chart. Hide the start-date bars so the remaining bars show each task’s schedule across a timeline. Excel does not have a dedicated Gantt chart type, but this method creates a practical, editable chart from ordinary worksheet data.

What You’ll Need

Excel for Microsoft 365 on Windows, or a recent Excel version with stacked bar charts.
A task list with a start date and finish date for each task. Use real Excel dates, not dates typed as text.
A blank column for each task’s duration, plus a little time to format the chart.

The example below uses four tasks. Its dates are illustrative; replace them with your project dates. The basic chart represents calendar days, so a task that spans a weekend also has a bar across the weekend.

Step-by-Step

Set up a simple task table. In a blank worksheet, use four adjacent columns with these headings: Task, Start, Duration, and Finish. Enter one task per row, starting in row 2. For example, put Research in A2, its start date in B2, its duration in C2, and its finish date in D2. Keep the task names unique if you may later sort or filter the list.

For an example schedule, enter Research from June 1 to June 3, Design from June 4 to June 8, Build from June 9 to June 18, and Review from June 19 to June 22. Enter dates as dates in Excel, such as 6/1/2026, rather than typing labels such as “June 1” if Excel does not recognize them as dates.
Calculate each duration. With task names in A2:A5, start dates in B2:B5, finish dates in D2:D5, and duration cells in C2:C5, enter =D2-B2+1 in C2 and fill it down through C5. The added 1 counts both the start and finish date: Research, June 1 through June 3, returns 3 days; Build, June 9 through June 18, returns 10 days. Check that every finish date is on or after its start date.

If your organization counts elapsed time rather than including both endpoints, use the duration convention your project follows. The chart’s bar length will reflect the number in the Duration column, so an off-by-one choice affects the displayed finish.
Select the columns the chart needs. Select A1:C5, including the headings and all task rows. The selection should contain task names, start dates, and durations, but not the Finish column. Excel uses the start date as the invisible offset and the duration as the visible task bar. Including Finish as another series would produce an unwanted bar.

If your table has more or fewer tasks, select the full range from the first heading through the last task row. Avoid selecting blank rows below the data, since they can appear as empty categories in the chart.
Insert a stacked bar chart. On the ribbon, choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Do not choose Clustered Bar: the stacked option places the duration after the start-date offset. Excel should make one bar for each task and show two series, usually named Start and Duration.

If the chart looks unlike a schedule, confirm that you chose Stacked Bar rather than 100% Stacked Bar or a column chart. The 100% version converts the series into proportions and is not appropriate for dates and durations.
Make the task order readable. Click the task labels along the chart’s vertical axis. Right-click and choose Format Axis. In the Format Axis pane, open Axis Options and select Categories in reverse order if you want the first task at the top. Excel often places the first category at the bottom by default, which can make the schedule read backwards.

After reversing the order, the date axis may move to the top. If you prefer it at the bottom, look in the same axis options for the setting that controls where the horizontal axis crosses and choose the option for the maximum category. The precise pane layout can vary slightly between Excel builds.
Hide the Start series. Click one of the bars that represents Start to select that series, then right-click and choose Format Data Series. In the pane, open Fill & Line, set Fill to No fill, and set Line to No line. The start series still positions each duration bar on the date axis, but it no longer appears as a colored bar.

Make sure you selected the entire Start series, not only one individual data point. If you remove the series from the chart altogether, durations will begin at the axis origin instead of at their scheduled start dates.
Format the timeline as dates. Click the horizontal value axis and choose Format Axis. In the Format Axis pane, use the Number section to apply a date format such as mmm d. If the axis shows large numbers, it is displaying Excel’s underlying date serial values; changing the number format makes those values readable as dates.

You can also set the horizontal axis bounds to the project’s earliest start and latest finish, if needed. Excel’s bounds fields use date serial numbers, so entering a date directly may not work in every version. One reliable approach is to format a worksheet cell as General, note the serial number for the desired date, and enter that number as the bound. Leave a small margin if labels or bars appear cramped at the chart edges.
Add a useful title and check the result. Click the chart title and replace it with a clear name, such as “Project Schedule.” Resize the chart so task names and date labels are easy to read. Confirm that each task’s bar begins at its start date and spans the duration you expect. If you want to distinguish phases or highlight a deadline, format selected duration bars or add a separate milestone marker rather than changing the hidden Start series.

To keep the chart connected to its data, edit the dates or durations in the source table. The chart should update automatically. If you add tasks beyond the original selected range, expand the chart’s data range using Chart Design > Select Data, or convert the source range to an Excel table before adding many rows.

Common Mistakes

Choosing the wrong chart type: Clustered Bar puts the series beside each other, while 100% Stacked Bar scales them to percentages. Use the ordinary 2-D Stacked Bar chart.
Deleting the Start series instead of hiding it: The start values create the offset that places each task on its date. Set the series fill and line to No fill and No line rather than removing it.
Using text instead of actual dates: A date that Excel treats as text may not position correctly. If a date is left-aligned or the axis behaves oddly, check the cell format and re-enter the date in a format recognized by your regional settings.
Counting duration inconsistently: The formula with +1 counts the start and finish dates. If your plan uses elapsed days, choose that convention deliberately and use it for every task.
Expecting weekends to disappear: The simple chart shows calendar time. A five-day task starting Friday will span the weekend on the timeline if its finish date includes those days. Use working-day start and finish dates if the project schedule is intended to skip weekends.

Tips

Keep the source table in chronological or dependency order before inserting the chart, then use the category-axis setting to control which task appears at the top. A consistent, short task label is easier to scan than a full sentence. If labels wrap, widen the chart or shorten the task names instead of shrinking the text until it is hard to read.

For a longer schedule, choose axis bounds that cover the project rather than leaving a large empty span before the first task. Set the horizontal axis number format to a compact date style and adjust the major unit only if the labels are too dense. For example, a weekly interval can suit a multi-month plan, while a short project may be clearer with daily or monthly labels. The correct interval depends on the schedule length and how much detail readers need.

Save a copy of the workbook before experimenting with formatting if the chart is part of a shared reporting file. You can also duplicate the worksheet to keep an untouched data view. When you add tasks regularly, an Excel table can make the source easier to maintain, though you should confirm that the chart’s data range includes newly added rows.

Troubleshooting

Every bar starts at zero: The Start series may have been removed, or the chart may not include the Start column. Open Chart Design > Select Data and check that Start and Duration are both listed. Then hide Start with No fill and No line.
The task bars are missing or extremely short: Check that durations are positive numbers, start dates are real dates, and the selected chart is Stacked Bar. A text date or blank duration can leave Excel with nothing useful to plot.
The date axis displays numbers: Select the horizontal axis, open Format Axis, and set its number format to a date such as mmm d. Do not change the source dates to text just to make the labels look different.
The first task is at the bottom: Format the vertical category axis and turn on Categories in reverse order. If the date axis moves to the top, adjust where the horizontal axis crosses the categories.
Some tasks do not appear: Check the selected data range in Chart Design > Select Data. Expand it to include the missing rows, and verify that the task, start, and duration cells are all populated.
The timeline starts too early or ends too late: Review the horizontal axis bounds. Clear a manually entered bound to let Excel choose automatically, or reset the minimum and maximum to the project’s actual date range. Check that the finish dates and duration calculations agree.

In Excel for Mac, the chart type and general method are the same, although ribbon labels and the formatting pane can be arranged differently. In Excel for the web, you can insert and format charts, but some detailed axis controls may be limited or placed differently; open the workbook in the desktop app if a specific bound or formatting option is unavailable.

Frequently Asked Questions

Does Excel have a built-in Gantt chart type?

No. Excel does not offer a dedicated Gantt chart type in the standard chart list. A stacked bar chart with the start-date series hidden is the usual way to build one from worksheet data.

Can I make a Gantt chart without formulas?

Yes. You can type the durations directly into the Duration column and chart them with the start dates. A formula is useful when you already have start and finish dates because it recalculates duration when either date changes.

Can the chart show progress as well as dates?

Yes, but progress needs an additional data series or a separate visual treatment. A common approach is to add a percent-complete column and use a second bar or conditional formatting in the worksheet. Keep the basic schedule chart clear so progress does not obscure the task dates.

How do I show dependencies between tasks?

The basic stacked bar chart does not draw dependency arrows automatically. Add a dependency column to the task table for planning, and use chart shapes or a project-management tool if you need visible connector lines. Be aware that manually drawn arrows may need repositioning when dates or chart size change.

Can I exclude weekends from the Gantt chart?

The basic chart uses calendar dates and does not automatically skip weekends. You can plan start and finish dates using working-day rules, but a calendar-date axis still spans weekends. A schedule that compresses nonworking days needs a more specialized layout or a dedicated project-planning tool.

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.