How to Create a Gantt Chart in Excel

What you will build

We will build a simple project timeline for October 2026. The chart will use the task name as the category, the Start Date as an invisible offset, and Duration (days) as the visible bar length. The Status column is useful for your project table, but it is not part of the chart series.

Excel for Windows and Excel for Mac use the same basic chart idea, although a menu may be labelled slightly differently. If you want a fuller planning table before you start, see this project tracker with status and due dates. For another chart that makes progress visible at a glance, continue with the Excel progress bar chart tutorial.

Step 1: Prepare the source table

Start with a clean table before inserting any chart. A Gantt chart becomes much easier to fix when every task is on its own row and Excel recognises the start values as real dates.

1. Open a blank worksheet and enter the headers Task, Start Date, Duration (days), and Status in cells A1:D1.
2. Enter the five task rows exactly as shown above. Use dates such as 10/1/2026, 10/3/2026, 10/8/2026, 10/15/2026, and 10/18/2026 in column B.
3. Enter whole numbers in the duration column: 2, 5, 7, 3, and 1. Do not type “2 days” as text.
4. Format column B as a Date if Excel displays serial numbers or an unexpected format.
5. Optionally convert A1:D6 to an Excel Table with Insert → Table. This makes future rows easier to manage, even though the first chart will use the current five tasks.

Step 2: Insert a Stacked Bar chart

The Gantt layout is made from a horizontal Stacked Bar chart. Excel will initially display two visible series: Start Date and Duration. That is expected; the Start Date series becomes the invisible spacing that positions each task.

1. Select A1:C6, including the headers but excluding Status. Selecting Status would add an unrelated text series.
2. Open the Insert tab.
3. Choose Insert Column or Bar Chart.
4. Under 2-D Bar, choose Stacked Bar.
5. Move or resize the chart if it covers the source table.

Step 3: Hide the Start Date series and reverse the task order

Now convert the ordinary stacked bars into a Gantt layout. Start Date must remain in the chart because it controls the horizontal offset, but it should not remain visible as a coloured bar.

1. Click one of the first coloured sections that represents the Start Date series.
2. Right-click it and choose Format Data Series.
3. In the Format Data Series pane, open Fill & Line and set Fill to No fill. If a border remains, set the line to No line.
4. Click the vertical task axis, right-click, and choose Format Axis.
5. Under Axis Options, select Categories in reverse order. This puts Plan at the top and Launch at the bottom.

Step 4: Format the date axis

Automatic axis bounds often create unnecessary empty space. A tighter project window makes the schedule easier to scan and makes the start and finish dates obvious.

1. Click the horizontal date axis and choose Format Axis.
2. Under Axis Options → Bounds, set Minimum to 10/1/2026.
3. Set Maximum to 10/19/2026. The extra day gives the one-day Launch bar enough visual room.
4. Under Units, set Major to 2 and choose Days.
5. If the axis shows serial numbers, open the Number section and choose a short date format such as mmm d or mmm d, yyyy.

Step 5: Polish the chart for a reader

A technically correct chart still needs a clear title and restrained formatting. Keep the visual hierarchy focused on task timing rather than chart furniture.

1. Click the chart title and replace it with Project Timeline.
2. Remove the legend if only the Duration series is visible. It no longer adds useful information once Start Date has no fill.
3. Right-click a visible bar, choose Format Data Series, and adjust Gap Width until the bars are thick enough to read but still separated.
4. Use one calm accent colour for the bars. Reserve a second colour for status highlights in the source table or for a specific milestone.
5. Resize the chart so task names and dates remain readable at the width where you will share it.

If your project needs a stronger status dashboard, you can pair this chart with a progress visual such as a progress bar chart. Keep each chart responsible for one clear question: the Gantt chart answers “when does each task happen?”

Step 6: Verify every bar against the source data

Before sharing the workbook, reconcile the visual result with the table. The chart should not merely look balanced; each bar must begin and end where the dates and durations say it should.

1. Plan: starts October 1 and spans two days, ending October 2.
2. Design: starts October 3 and spans five days, ending October 7.
3. Build: starts October 8 and spans seven days, ending October 14.
4. Test: starts October 15 and spans three days, ending October 17.
5. Launch: starts October 18 and spans one day.
6. Check that Plan is at the top, Launch is at the bottom, and no Start Date colour is visible.

Common mistakes and quick fixes

Frequently asked questions

Final checklist

• The source range includes Task, Start Date, and Duration.
• Start Date remains in the chart but has no fill.
• Categories are reversed so the first task appears at the top.
• The date axis uses a readable project window and date format.
• The chart title and bar spacing are easy to read.
• Every bar has been compared with the source dates and durations.

Once this works, you can reuse the same structure for a launch plan, client implementation schedule, content calendar, or internal operations tracker. The key idea is simple: Start Date positions the bar, Duration controls its length, and the final verification protects the reader from a polished but inaccurate chart.