Excel Gantt Chart: Build a Timeline from a Task List

Yes. In Excel for Microsoft 365 on Windows, make a Gantt chart by putting task names, start dates, and durations in a table, then inserting a stacked bar chart and hiding the start-date bars. The result is a task timeline you can update by changing dates or durations; it is a visual schedule, not a dedicated project-management system.

What an Excel Gantt chart shows

A Gantt chart places tasks down one side and time across the other. Each task appears as a horizontal bar: its position marks when the work starts, and its length represents how long it lasts. This makes sequence, overlap, gaps, and the overall schedule easier to scan than a date list alone.

Excel does not have a special, one-click Gantt chart type in its standard chart gallery. The usual approach is to adapt a stacked bar chart. One series represents the number of days from the chart’s starting point to a task’s start; a second series represents the task duration. Making the first series invisible leaves the visible duration bar positioned at the correct date.

This works well for a small project plan, an event schedule, or a simple launch timeline. A workbook chart will not automatically manage dependencies, assign resources, or warn about conflicts as project software might. Those details can be added to the worksheet, but they require explicit data and formulas.

Prepare the task table

Start with one row per task and consistent date values. For a basic chart, use three adjacent columns: task, start date, and duration. You can also keep a finish-date column and calculate duration from it. The following example uses inclusive calendar days, meaning both the first and last dates count:

Planning: start January 6, finish January 8, duration 3 days.
Drafting: start January 8, finish January 12, duration 5 days.
Review: start January 13, finish January 14, duration 2 days.
Launch: start January 15, finish January 15, duration 1 day.

With task names in A2:A5, start dates in B2:B5, and finish dates in C2:C5, put a duration heading in D1 and enter this formula in D2, then fill it down through D5: =C2-B2+1. For the example dates, the returned durations are 3, 5, 2, and 1. The plus one matters: subtracting January 6 from January 8 gives two elapsed days, but the inclusive schedule covers three calendar dates.

For the chart, make a compact three-column chart source with Task, Start, and Duration in adjacent columns, for example F1:H5, and link or copy the values there. Keeping the source table separate from notes or finish dates helps prevent unrelated columns from becoming chart series. Format start dates as dates, not text; a date typed as text may not plot at the intended position.

Build the stacked bar chart

Select the chart-source range, including the headings and all task rows, such as F1:H5.
Choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Do not choose 100% Stacked Bar: that chart normalizes the series and no longer represents actual durations.
If Excel has arranged the data incorrectly, select the chart and use Chart Design > Switch Row/Column. The task names should be the category labels and Start and Duration should be the two series.
Click a Start series bar, right-click, and choose Format Data Series. In Fill & Line, set Fill to No fill and Border to No line. The start values still position the duration bars, but the offset series is no longer visible.
Use Chart Design > Add Chart Element > Chart Title to add a descriptive title, if useful.

The hidden series is essential. Deleting it would make every duration bar begin at the same origin, rather than at its task’s start date. If the chart displays dates as task labels or shows only one bar, check the selected range and use Switch Row/Column before changing formatting.

Format the timeline so dates are readable

The horizontal value axis may initially show large serial numbers because Excel stores dates as numbers. Right-click that axis, choose Format Axis, and use the Number section to select a date format such as d-mmm or mmm d. The exact pane controls can vary slightly with updates, but the setting belongs to the value axis, not the task-name axis. A short date format usually fits better than a full date with a year on every tick.

Task order can appear upside down because bar charts commonly place the first category at the bottom. Right-click the vertical task axis, choose Format Axis, and select Categories in reverse order under Axis Options if you want the first worksheet task at the top. After reversing categories, Excel may move the date axis to an unexpected edge; adjust the horizontal axis crossing option in the same pane if needed.

Set the visible date range to the period that matters. In Format Axis, Axis Options lets you set minimum and maximum bounds; Excel uses date serial values for those bounds, so entering actual date values is often more convenient. Avoid a range much wider than the project, which can make short tasks look like tiny marks. Use a clear bar color, restrained gridlines, and a legend only if the series labels are meaningful to readers. The invisible Start series should not be mistaken for a second task type.

Keep dates and durations accurate

The example formula counts calendar days, including weekends. That is appropriate for a schedule where work continues every day, such as a conference countdown or a delivery window. For a weekday-only estimate, the calculation must use a different definition of duration; also decide whether company holidays count as nonworking days. Do not mix calendar-day durations with a chart that readers interpret as working days.

For recurring updates, use an Excel Table for the source data: select the range and choose Insert > Table. Tables make it easier to add task rows while retaining consistent formatting and formulas. Check that the chart source expands to include new tasks; depending on how the chart was created, a new row may need to be added through Chart Design > Select Data. After changing a start date or duration, confirm that the bar moved as expected and that the displayed date range still includes it.

If a task is a milestone rather than work lasting several days, a one-day bar can represent its date, but it may be visually indistinguishable from a short task. Label it clearly or use a separate milestone marker. A task with a finish date earlier than its start date produces a zero or negative duration in the inclusive formula; correct the dates rather than trying to hide the resulting chart problem.

Show progress and dependencies carefully

A basic Gantt chart shows planned timing, not completion status. Add a Percent Complete column to the worksheet if readers need progress information, but a number in that column will not automatically fill part of the bar in the simple two-series chart. One practical option is to add a separate progress series or use worksheet formatting and labels alongside the chart. Keep the visual key explicit so readers can distinguish planned duration from completed work.

Dependencies are relationships such as “Review cannot begin until Drafting is complete.” The basic chart does not enforce that rule. You can record a predecessor task in another column and adjust start dates when plans change, but the chart will not recalculate a successor’s schedule from that relationship by itself. For a plan with many linked tasks, changing owners, baseline comparisons, or critical-path needs, a project-management application is generally more suitable than adding more complexity to a spreadsheet chart.

Common problems and fixes

Bars all begin at zero: the Start series may have been deleted or plotted as a duration. Restore it as the first series and set its fill and border to none.
Dates display as numbers: format the horizontal value axis as a date. If dates still plot strangely, check that the source cells contain real Excel dates rather than text.
Task names are in the legend: use Chart Design > Switch Row/Column or correct the chart data range so tasks are categories.
New rows do not appear: expand the chart’s data source with Chart Design > Select Data, or confirm that the chart references the expanded table.
Bars seem too short: check whether duration counts inclusive dates and whether the axis range is too broad. A one-day task is a narrow bar, not necessarily a formatting failure.

Excel chart or another scheduling method?

A stacked bar chart is useful when you want a compact, printable view and are comfortable maintaining the task table yourself. It is flexible, familiar, and can be customized with ordinary chart formatting. Its main cost is maintenance: formulas, chart ranges, labels, and date bounds need attention as the plan changes.

A calendar-grid worksheet is an alternative when the schedule is organized by days or weeks. Conditional formatting can shade cells where a date falls between a task’s start and finish, which makes weekends or team-specific calendars easier to display. However, a grid can become very wide for long projects, while the bar chart stays compact. A project application is preferable when scheduling rules, notifications, shared ownership, or dependency calculations are central requirements.

Sharing and compatibility

These instructions target Excel for Microsoft 365 on Windows. Excel for Microsoft 365 on Mac also supports stacked bar charts and series formatting, though ribbon labels or pane placement may differ slightly. Excel for the web can display and edit many charts, but some detailed chart-formatting controls may be more limited; use the desktop app if a particular axis or series option is unavailable.

Before sharing, make sure the workbook includes the source dates and duration calculation, not just a pasted picture of the chart. A chart image is convenient for a report but cannot update when the schedule changes. If recipients need only a fixed snapshot, export or paste a picture; if they need to revise the plan, share the workbook and explain which cells are intended for editing.

Frequently Asked Questions

Does Excel have a built-in Gantt chart template?
Excel includes templates that may be available through its template gallery, but a standard worksheet chart is usually built from a task table and a stacked bar chart. Template availability can vary, so the chart method works without relying on a particular template.

Can I make a Gantt chart in Excel without dates?
You can use numbered periods, such as week 1, week 2, and week 3, instead of calendar dates. The start series then represents the number of periods before a task begins, and the duration series represents its length.

Why is my Excel Gantt chart upside down?
Bar charts may place the first category at the bottom. Right-click the task axis, choose Format Axis, and turn on Categories in reverse order to put the first task at the top.

Can Excel automatically update dependent task dates?
Not with the basic stacked bar chart alone. You must calculate or enter the successor start dates separately, or build additional scheduling logic. For a large dependency-driven plan, dedicated project software may be easier to maintain.

Can I show weekends or holidays?
Yes, but the simple chart uses elapsed calendar dates and does not skip nonworking days. You can use a working-day calculation and a suitable holiday list in the worksheet, then ensure the chart’s timeline and duration definitions match the schedule you want readers to interpret.

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.