Schedule Gantt Chart in Excel: A Step-by-Step Guide

To make a schedule Gantt chart in Excel, place each task, its start date, and its duration in separate columns, then insert a 2-D Stacked Bar chart. Hide the start-date series so each visible bar begins at the right date, and format the date axis and task labels. You will get a visual timeline that makes task timing, overlaps, and the overall schedule easier to understand.

What You’ll Need

Microsoft Excel for Microsoft 365 on Windows. The steps also work in recent desktop versions of Excel; Mac ribbon labels or chart controls may differ slightly.
A task list with a start date and duration for each task. Decide whether durations are working days or calendar days before entering them.
A blank worksheet or a copy of your schedule. Keep the underlying data in a simple table so the chart is easy to update.

Step-by-Step

Set up the schedule columns. In a new worksheet, enter Task in A1, Start Date in B1, and Duration (days) in C1. Put one task on each row, with no completely blank rows inside the data. For example, rows 2–6 could list Plan, Design, Build, Review, and Launch. Enter real Excel dates in column B, not dates stored as text. Enter a positive number of days in column C. If your plan uses calendar days, include weekends in the duration; if it uses working days, be aware that a standard Gantt bar counts calendar days unless you build in a separate adjustment.
Check the sample schedule and date entries. For a small example, Plan could start on 1 June 2026 and last 3 days; Design could start on 4 June and last 5 days; Build could start on 9 June and last 8 days; Review could start on 17 June and last 3 days; and Launch could start on 22 June and last 1 day. Type the year in each date, and check that Excel recognizes each entry as a date. Select a date cell and use Home > Number Format to choose Short Date if the display is unclear. The durations in this example are elapsed calendar days, and the tasks are arranged consecutively rather than overlapping.
Select the chart data. Select the complete range, including the headings and task names, such as A1:C6 for the five-task example. Including the headings helps Excel name the series Start Date and Duration. If you have a longer list, select through the last task row. Avoid selecting unrelated notes or totals, which Excel could interpret as extra chart data.
Insert a stacked bar chart. On the ribbon, choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. The exact gallery may show the chart as Stacked Bar rather than 2-D Stacked Bar. Do not choose 100% Stacked Bar: that normalizes each row and no longer represents the tasks’ actual time spans. Excel should create one bar per task with two stacked series: the start-date offset and the duration.
Confirm the chart’s data orientation. Each task should appear as a category, and Start Date and Duration should be the two series. If Excel puts the tasks in the legend or creates the wrong arrangement, select the chart and choose Chart Design > Switch Row/Column. If that does not correct it, use Chart Design > Select Data to check that the category labels come from the task-name cells and the two series use the start-date and duration columns. This is especially useful when Excel has guessed the data layout incorrectly.
Hide the start-date series. Click a Start Date segment in the chart. Make sure you have selected that whole series, not just one data point. Right-click and choose Format Data Series, then use Fill & Line (the paint bucket) > Fill > No fill. Set Border to No line as well if an outline remains. The start-date segments become invisible, leaving each duration bar positioned at its actual start date. If the wrong part disappears, use the Format pane’s Series Options or click the series again to select the correct one.
Put the tasks in schedule order. Excel bar charts often show the first worksheet task at the bottom. Right-click the vertical task axis, choose Format Axis, and under Axis Options select Categories in reverse order. This places the first task at the top, which is usually easier to read. If the horizontal date axis moves to the top after reversing the categories, that is normal; under the same axis options, adjust the horizontal axis crossing setting if you prefer it at the bottom. The available wording can vary slightly by Excel build.
Format and finish the timeline. Right-click the horizontal date axis and choose Format Axis. Under Number, select a date format that fits, such as 1-Jun or 1-Jun-26. If the timeline has excessive empty space, set the Minimum bound to the Excel date serial for the first planned start date and the Maximum bound to cover the final task. To find a date’s serial, enter that date in an unused cell and temporarily change its number format to General; use the resulting number as the bound. Use sensible major units, such as 7 for a weekly scale or 1 for a daily scale. Give the chart a clear title, such as Project Schedule, and remove the Start Date legend entry if it remains. Resize the chart so task labels and dates are legible.

For the sample dates, the visible bars should begin on 1, 4, 9, 17, and 22 June, with lengths of 3, 5, 8, 3, and 1 days. If they do not, first check the data selection and confirm that the start-date series—not the duration series—was made transparent.

Common Mistakes

Using a regular bar chart. A clustered bar chart does not layer the invisible start offset and duration as needed. Choose Stacked Bar, not Clustered Bar or 100% Stacked Bar.
Entering dates as text. A value that looks like a date may be stored as text and can produce unexpected chart positions. Re-enter it in a recognized date format or use Home > Number Format to check its display. Changing a cell’s appearance alone will not convert text into a date.
Making the duration series invisible. If the bars vanish, the wrong series may have been formatted with No fill. Restore the duration fill, then select Start Date and hide that series instead.
Confusing duration with an end date. The chart needs a numeric duration for its visible bar. If your source has start and finish dates, calculate or enter the elapsed days in a separate duration column, and make sure your chosen counting convention is consistent. For example, a task running from Monday through Wednesday is three days if both endpoints count.
Leaving the axis at an unhelpful scale. Automatic bounds can leave a wide gap before the first task or make short tasks hard to distinguish. Set reasonable date bounds and units, but leave enough room to show the full schedule.

Tips

Convert the task list to an Excel table. Select the data and choose Insert > Table. A table makes it easier to maintain consistent headings and formatting as tasks are added. Check the chart’s data source after adding rows; depending on how the chart was created, you may need to extend its range through Chart Design > Select Data.
Use consistent duration rules. State whether your schedule is based on calendar days or working days, and use the same rule for every task. A basic stacked bar displays elapsed days. It does not automatically skip weekends or holidays.
Keep the chart readable. Use a restrained color for duration bars, a short chart title, and a date format that suits the schedule length. Weekly labels may work better for a multi-month plan, while a short project can use daily labels.
Show progress separately if needed. A simple duration bar shows the planned span, not how much work is complete. Add a separate percent-complete column for tracking, or use a distinct visual style for completed work. Avoid changing the duration to indicate progress because that alters the planned schedule.
Save a reusable copy. Once the chart is formatted, save the workbook as a template or duplicate the worksheet before replacing the task list. This preserves your chart layout while giving you a clean starting point for another schedule.

Troubleshooting

The chart shows dates as large numbers. The dates are being plotted as Excel serial values, but the axis number format is not set to a date. Open Format Axis, go to Number, and choose a date display. If needed, clear the Linked to source option before choosing a different format.

Bars all begin at zero or share the same starting point. Confirm that the chart type is Stacked Bar and that Start Date and Duration are separate series. In Chart Design > Select Data, inspect the source ranges and check that the Start Date values are included. Then hide only the start-date series.

Task names appear in the wrong order. Use Format Axis on the vertical category axis and toggle Categories in reverse order. If the date axis shifts position, adjust the horizontal axis crossing option rather than changing the task data.

The chart does not update when a task is added. Select the chart and open Chart Design > Select Data to see whether the new row is included in the chart data range. Expand the range to include the added task and its start date and duration. If the data is an Excel table, verify that the new row was entered directly below the table so it becomes part of it.

There is too much blank space or the last task is cut off. Adjust the horizontal axis Minimum and Maximum bounds to include the schedule’s first start and final finish. Leave a small margin if you want the bars to breathe, and check that the duration values are positive numbers. If a bar looks too short, check whether you entered a duration of one less than intended by excluding one endpoint.

The chart commands look different on Mac or Excel for the web. In Excel for Mac, the same chart type and Format Data Series controls are available, though the ribbon layout or pane labels can differ. In Excel for the web, chart formatting controls may be more limited or arranged differently; use desktop Excel if you cannot access the axis bounds or No fill setting you need. On Mac, common shortcuts also differ: Command is often used where Windows uses Ctrl, but the menu paths above are the most reliable way to locate chart controls.

Frequently Asked Questions

Can I make a Gantt chart in Excel without a template?
Yes. A task, start-date, and duration table is enough. Insert a Stacked Bar chart, hide the start-date series, and format the axes. A template can save setup time, but it is not required.

Can an Excel Gantt chart show task dependencies?
A basic stacked bar chart does not draw dependency links or enforce task order. You can add a dependency column to your schedule for planning, but the chart will not automatically move a dependent task when an earlier date changes. Update the affected dates and refresh the chart data as needed.

How do I show weekends or working days?
The basic chart uses elapsed calendar dates, so its bars span weekends. For a working-day plan, calculate start dates and durations according to your work calendar before charting, or use a more advanced schedule model. Do not label calendar-day bars as working days unless you have accounted for nonworking days.

Can I show milestones?
Yes, but a milestone has no duration, so a zero-length bar may not be visible. Give it a small positive duration or add a separate milestone series and format it as a marker. For a simple schedule, another option is to add a clearly labeled milestone task with a one-day bar.

How do I change the chart when dates change?
Edit the start date or duration in the source table; the chart should reflect the changed value if the data range includes that cell. If new tasks are not shown, expand the chart’s data source through Chart Design > Select Data. Recheck the axis bounds if the updated schedule extends beyond the displayed timeline.

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.