Gantt Chart in Excel: Build a Project Schedule

Charts & pivot tables · Updated November 20, 2026

Create a Gantt chart schedule in Excel by listing tasks, start dates, and durations, then inserting a 2-D stacked bar chart. Hide the series that represents each task’s start date; the visible duration bars will then show when tasks begin and how long they last. Before you start, decide whether your durations count calendar days or working days. The instructions below use calendar days in Microsoft Excel for Microsoft 365 on Windows.

What You’ll Need

  • Excel for Microsoft 365 on Windows. Excel for Mac has similar chart tools, though some pane labels and controls may differ. Excel for the web can create basic charts, but desktop Excel may offer more formatting controls.
  • A task list with a start date and finish date for each task. Add a duration column, or calculate it from those dates.
  • A consistent definition of duration. This example counts both the start and finish dates, so a task from April 6 through April 8 lasts three calendar days.

Step-by-Step

  1. Set up the schedule columns. In a blank worksheet, enter Task in A1, Start in B1, Duration in C1, and Finish in D1. Put each task on its own row. For example, row 2 could contain Discovery, April 6, 2026, a duration of 3, and April 8, 2026. Add later tasks on the rows below. Keeping the finish date in D makes it easy to check the schedule, while the chart will use only columns A through C.
  2. Enter real Excel dates and durations. Type the start and finish dates as dates, not as text. Excel should recognize them and display them in the date format set for your computer. To calculate inclusive calendar-day duration, with the start date in B2 and finish date in D2, enter =D2-B2+1 in C2. For April 6 through April 8, the result is 3. Fill the formula down by dragging the fill handle or copying it to the other task rows. If you prefer, enter duration numbers directly. Check that every duration is positive and that finish dates do not precede start dates.
  3. Use a small schedule to check your data. One example is Discovery (April 6–8), Design (April 9–15), Build (April 13–24), Review (April 27–29), and Launch prep (April 30–May 4). Their inclusive calendar durations are 3, 7, 12, 3, and 5 days. The Build task overlaps Design, which is normal when work can happen in parallel. Check that each task has a name, a valid start date, and a duration before making the chart; blank or incorrect cells can produce missing bars or misleading timing.
  4. Select the chart data. Select the task names, start dates, and durations, including their headings, but not the finish-date column. For the layout above, select A1:C6. On the ribbon, choose Insert > Insert Column or Bar Chart > 2-D Stacked Bar. Do not choose 100% Stacked Bar: that chart makes each task appear to have the same total length. If the chart puts task names in the legend or dates on the vertical axis, right-click the chart and choose Select Data. Use Switch Row/Column if it corrects the arrangement, or edit the series and category labels so Start and Duration are series and the task names are categories.
  5. Make sure the chart is stacked in the right order. The first series must be Start and the second must be Duration. If the order is wrong, right-click the chart, choose Select Data, and use the move up or down controls under Legend Entries (Series). A stacked bar adds the duration after the start-date value. If Duration comes first, the bars will not line up with the schedule dates, even if the data itself is correct.
  6. Hide the Start series. Click one of the bars representing Start. If all the bars are selected, the Format Data Series pane should open; otherwise, click a Start segment again to select that series. In the pane, choose Fill & Line > Fill > No fill. Set its line to No line as well if an outline remains. This series is still in the chart and positions each task at its start date, but it becomes invisible. The Duration series remains visible as the Gantt bar. Take care to format the Start series rather than Duration.
  7. Put the earliest task at the top. Click the vertical category axis that lists task names, right-click, and choose Format Axis. Under Axis Options, select Categories in reverse order. This usually places the first worksheet task at the top, which is a familiar schedule layout. Excel may move the horizontal date axis to the top when you reverse the categories; that is expected. If the task order still looks wrong, check the source range and category labels in Select Data.
  8. Format the date axis and bars. Click the horizontal date axis and choose Format Axis. Under Number, set a date-style format such as mmm d so the scale displays labels like Apr 6 rather than long date serial numbers. If the chart covers too much time, adjust the Minimum and Maximum bounds under Axis Options to the project’s earliest start and latest finish. Excel stores dates as numbers; to get a bound value, format a date cell temporarily as General and use the displayed serial number. Leaving bounds on Auto is also fine, especially when the schedule will change. Click a visible Duration bar and use the chart formatting controls to choose a readable fill color, adjust Gap Width if bars look too thin, and add a concise chart title.
  9. Check the finished schedule and keep it maintainable. Compare several bars with the worksheet: each should begin on its task’s start date and span the stated number of calendar days. If you add tasks later, update the chart’s source range through Chart Design > Select Data, or use an Excel Table to make expanding the source easier. Save the workbook, and keep the finish-date column visible so you can spot changes to task timing.

Common Mistakes

  • Choosing a regular or 100% stacked bar. A regular bar does not layer the start and duration series as needed; a 100% stacked bar normalizes every row. Choose 2-D Stacked Bar.
  • Leaving the start-date series visible. This produces a colored block before each task’s real duration. Hide Start with No fill, but do not delete it from the chart.
  • Using text instead of dates or numbers. A date pasted with an apostrophe, or a duration such as “5 days,” may be treated as text. Enter dates as dates and durations as numbers. If a date is left-aligned or refuses date formatting, check the cell and re-enter it.
  • Mixing calendar and working days. The example includes weekends in durations. If you calculate a five-working-day duration but plot it on a calendar-date axis, the bar will not automatically skip weekends. Decide what the schedule should represent before building the chart.
  • Forgetting inclusive duration. Finish minus start alone gives 2 for April 6 through April 8. Add 1 when both dates count as scheduled days, as in the formula in this guide.

Tips

  • Group related tasks with consistent colors or labels, but keep enough contrast between bars and the chart background.
  • Keep task names short and specific. “Approve draft” is easier to read on the chart than a long explanation; put detailed notes in another column.
  • Show milestones, such as a one-day approval or launch, as short tasks with a duration of 1 and a clear name. Excel’s standard bar chart does not automatically give a milestone special diamond styling.
  • For a schedule that changes often, convert the source range to a Table with Insert > Table, then review the chart’s data source when adding rows. Check that new tasks appear; chart expansion can depend on how the chart was created.
  • Use a concise title and modest date intervals. Too many axis labels can make dates collide, so widen the chart or reduce label density if the timeline is crowded.

Troubleshooting

  • Bars begin at the wrong date or appear enormous: confirm that Start is the first chart series, Duration is second, and both are numeric/date values. Check the horizontal axis bounds and make sure you have not included the Finish column as another series.
  • The chart shows dates in the legend or tasks on the horizontal axis: right-click the chart and open Select Data. Set the task-name cells as the category labels and make Start and Duration the two series. Switch Row/Column can repair a range that Excel interpreted in the opposite direction.
  • No bars appear for some tasks: inspect those rows for blank start dates, text-formatted dates, zero durations, or formula errors. Re-enter a date as a recognized date and check the duration result. If the task falls outside manually set axis bounds, expand those bounds or restore Auto.
  • Start bars remain visible: click the Start segment itself, not a Duration bar or the chart background, and set Fill to No fill. If selection is difficult, use the chart element selection list on the Format tab to choose the Start series.
  • Task order is upside down: format the vertical category axis and toggle Categories in reverse order. If the date axis shifts to the top, that is a normal result of reversing categories; adjust the axis crossing setting only if you specifically need it at the bottom.
  • Menu labels differ: Excel for Mac uses similar chart and formatting features, but ribbon and pane layouts can vary. In Excel for the web, basic chart creation is available, while some detailed axis or series controls may be limited. Open the workbook in desktop Excel if a control in these steps is missing.

Frequently Asked Questions

Can Excel create a Gantt chart automatically?
Excel does not provide a dedicated Gantt chart type in the standard chart list. A 2-D stacked bar chart with a hidden start series creates the same basic visual schedule.

Can I show task dependencies?
The basic chart does not draw dependency links automatically. Record predecessors in a separate column and use them to set realistic start dates; you can add connector shapes manually for a presentation, but they may need repositioning when the chart changes.

How do I make the chart include weekends?
Use calendar-day durations, as in the example. The bars then span every date from start through finish, including Saturdays and Sundays. This is appropriate when elapsed calendar time is what matters.

Can I schedule only weekdays?
Yes, but a standard stacked bar uses a continuous date scale and does not skip weekends. A working-day duration alone will not position later tasks correctly on that scale. For a weekday-only visual timeline, use a more customized calendar layout or specialist project-scheduling software, and verify how holidays and nonworking days are represented.

How do I update the chart when dates change?
Edit the start date, finish date, or duration in the source cells. The chart should update from its linked data. If you add a new task and it does not appear, expand the chart’s source range with Chart Design > Select Data.

Can I print the schedule on one page?
Use Page Layout settings to choose landscape orientation and adjust scaling or print area. Preview before printing: fitting a wide timeline to one page can make task names and date labels too small, so consider printing across multiple pages or exporting a readable PDF.

Related

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.