Excel Gantt Chart With Dependencies: How to Build One

Yes. In Excel for Microsoft 365 on Windows, you can build a Gantt chart whose task dates update when predecessor tasks change: calculate start and finish dates from dependencies, then use conditional formatting to draw the bars on a date grid. Excel does not provide a dedicated dependency-aware Gantt chart tool, so the schedule logic and visual chart are worksheet formulas and formatting you maintain.

What dependencies mean in a Gantt chart

A Gantt chart places tasks against a timeline. A dependency adds a scheduling rule: one task’s timing is linked to another task, rather than chosen independently. For example, a review might not start until the draft is finished. If the draft slips by two working days, a correctly linked review date should move too.

The most common relationship is finish-to-start (FS): the successor starts after its predecessor finishes. Other standard relationships include start-to-start (SS), where tasks may begin together; finish-to-finish (FF), where they must finish together; and start-to-finish (SF), which is uncommon. A basic Excel setup is easiest to maintain when it uses FS relationships and one predecessor per task. A colored bar alone does not create a dependency: the dates must be calculated from the predecessor data.

Plan the worksheet structure

Start with one row per task and a clear, unique task ID. The example below uses working-day durations and one predecessor ID. Enter the project start date in H2, and place the timeline across row 1 beginning in column I.

A: Task ID, such as T01
B: Task name
C: Duration in working days, as a positive whole number
D: Predecessor task ID, left blank if there is no predecessor
E: Start date
F: Finish date
H2: Project start date
I1 onward: Timeline dates

Arrange dependent tasks in topological order: a task’s predecessor should appear above it. This makes the formulas below straightforward and prevents a task from relying on an unfinished calculation farther down the sheet. For instance, a small project might list requirements, then design, then build, then review. A second task, such as preparing test data, could also follow requirements and run alongside design.

Calculate starts and finishes from predecessors

For the first task, put the project start date into its start cell. With the project start date in H2 and the first task on row 2, enter =$H$2 in E2. If the project starts Monday, January 6, 2025, this returns January 6. The formula keeps the project date as the starting point if H2 changes.

For a later task on row 3, with task IDs in A2:A20, predecessor IDs in D3:D20, and calculated finish dates in F2:F20, enter the following in E3 and fill it down. The lookup range ends at the previous row, so this formula assumes any predecessor is listed above its successor.

=IF(ISBLANK(D3),$H$2,WORKDAY(XLOOKUP(D3,$A$2:A2,$F$2:F2),1))

If D3 contains T01 and T01 finishes Wednesday, January 8, the formula returns Thursday, January 9. If D3 is blank, it returns the project start date. XLOOKUP finds the predecessor’s finish date; WORKDAY advances to the next weekday. XLOOKUP is available in Microsoft 365 and Excel 2021 or later. If a predecessor ID is misspelled or missing, the lookup returns an error, so consistent IDs matter.

With task start dates in E2:E20 and positive working-day durations in C2:C20, enter this formula in F2 and fill it down:

=WORKDAY(E2,C2-1)

For a task starting Monday, January 6 with a duration of three working days, the finish is Wednesday, January 8: the start date counts as day one. For a two-day task starting Thursday, January 9, the finish is Friday, January 10. WORKDAY skips Saturday and Sunday; for a project calendar with holidays, add a holiday-date range as its optional third argument.

These formulas use a simple convention: a successor begins on the next working day after its predecessor finishes. If your project defines a different rule—for example, same-day handoffs—adjust the offset deliberately. Enter durations as positive whole numbers; a zero or blank duration can produce confusing dates or errors.

Draw the Gantt bars with conditional formatting

Put the first timeline date in I1. With the project date in H2, enter =$H$2 in I1. For a business-day timeline, enter =WORKDAY(I1,1) in J1 and fill right. The first two formulas return January 6 and January 7, 2025, if H2 is January 6. A business-day timeline skips weekends; for a calendar-day display, use =I1+1 in J1 instead. Format the headers as dates and add enough columns to cover the project.

To color task cells that fall between each task’s start and finish, select the timeline grid, such as I2:AZ20. In Excel for Microsoft 365 on Windows, choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Use this rule formula:

=AND(I$1>=$E2,I$1<=$F2)

Choose a fill color and confirm the rule. The formula checks the date at the top of each column against the start and finish dates in that row. The dollar signs lock the date row and the start/finish columns while allowing the rule to adjust as it applies across the selected grid. With a workday-only timeline, bars do not have weekend columns; with a calendar timeline, a task spanning a weekend appears as a continuous bar over those dates. Excel for Mac and Excel for the web also support conditional formatting, though some dialog labels or layout details can vary.

Handle multiple predecessors, lag, and project calendars

A task can depend on more than one task. In that case, its earliest FS start is the next working day after the latest finish among all its predecessors. For example, if a test phase requires both the build and test data, it cannot begin until whichever prerequisite finishes last. One predecessor cell cannot represent that rule by itself.

For a small schedule, you can give a task several predecessor columns and calculate its start from the latest applicable predecessor finish. For a larger schedule, keep dependencies in a separate table with one row per predecessor-successor relationship. This avoids putting comma-separated IDs into one cell, which are hard to validate and look up reliably. Either approach needs a clear policy for blank predecessor entries and missing IDs.

Lag is an intentional wait between related tasks, such as allowing paint to dry before inspection. A lead permits overlap, as when a successor starts before its predecessor is fully complete. The simple formula above supports neither explicitly: it schedules the successor for the next working day after the predecessor’s finish. Add a clearly named lag field and incorporate it into the date logic if your plan needs waiting time; model overlap separately and check that the resulting dates match the real process.

WORKDAY treats Saturday and Sunday as nonworking days by default, but many teams use other weekends, shifts, or site-specific closures. Excel’s WORKDAY.INTL function allows different weekend patterns, and a holiday range can be supplied to WORKDAY. Make the calendar assumption visible in the workbook. Otherwise, a date may be mathematically consistent yet operationally wrong for a team that works Saturdays or closes for local holidays.

Common problems and useful checks

Bars do not move when a dependency changes: Check that start dates are formulas, not typed values, and that the predecessor ID matches exactly. Recalculate the workbook if calculation is set to manual.
A successor starts too early: Confirm that it references the predecessor’s finish date, not its start date, and check whether your handoff rule requires a one-day gap.
Dates show as numbers: Apply a date format to start, finish, and timeline cells. Excel stores dates as serial numbers; formatting changes their display.
There is a lookup error: Check that IDs are unique, predecessor IDs exist, and each predecessor is above its successor. Avoid accidental spaces in IDs.
The bar covers unexpected columns: Check that the conditional-formatting rule applies to the full grid and that its references start with the top-left cell of the selected range.
The chart shows weekends as task time: Decide whether the timeline should be calendar days or working days. The date headers and the WORKDAY-based schedule need to reflect the same planning convention.

It also helps to distinguish a task’s duration from the time between its start and finish on a calendar. A five-working-day task beginning Monday may finish Friday, while holidays or a nonstandard workweek can change the apparent calendar span. Include a status or actual-progress column only if someone will keep it updated; planned bars alone do not report completed work.

When Excel is enough—and when to use another tool

Excel is a sensible choice for a small or moderate project when the team already uses spreadsheets, the dependency rules are uncomplicated, and one person can maintain the schedule. The workbook can be shared like other Microsoft 365 files, and there is no separate Gantt-chart application to buy if Excel is already included in the organization’s plan. Licensing and sharing rights depend on the organization’s Microsoft 365 subscription.

The trade-off is that Excel does not automatically provide the full scheduling behavior of project-planning software. In this worksheet, changing one task can update formula-linked successors, but a complex network still requires careful formulas and review. Resource leveling, baselines, critical-path analysis, multiple relationship types, permissions, and change tracking may need extra design or a dedicated project-management product. Microsoft Project and other project tools are alternatives when those capabilities matter; they have their own licensing and setup considerations.

Before relying on an Excel schedule for a consequential deadline, test it with a small change: move a predecessor’s duration and confirm that each affected successor shifts as expected. Also review tasks with no predecessor, milestones, holidays, and any overlapping work. A spreadsheet can make dependencies visible and useful, but it will not know whether the assumptions behind them are realistic.

Frequently Asked Questions

Can Excel automatically update Gantt dates when a task changes?
Yes, if start and finish dates are formula-driven from predecessor IDs and durations. Changing a predecessor’s duration then recalculates linked dates. Typed dates, unlinked tasks, or incomplete dependency formulas will not update automatically.

Does Excel have a built-in Gantt chart with dependencies?
Excel does not have a dedicated dependency-aware Gantt scheduling feature in the standard worksheet interface. You can build the schedule with formulas and display it using conditional formatting or a chart, but you are responsible for setting up and checking the dependency logic.

Can one task have two predecessors in Excel?
Yes. Model both predecessor relationships and set the successor’s start based on the latest required predecessor finish. For a larger plan, a separate dependency table is usually easier to review than several IDs combined in one cell.

Can I make a Gantt chart that skips weekends?
Yes. Use WORKDAY to calculate working-day finishes and put working dates across the timeline with WORKDAY as well. If your workweek or holidays differ from the default, use the appropriate calendar settings or holiday dates consistently.

Will this work in Excel for Mac or Excel for the web?
The core worksheet formulas and conditional formatting are available in current Excel versions on Mac and the web, although the ribbon or dialog presentation may differ. XLOOKUP requires Microsoft 365 or Excel 2021 or later; confirm function availability if you are using an older release.

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.