Gantt Chart With Dependencies in Excel, and Where It Stops

Excel can draw a Gantt chart with dependencies, but only because you build the dependency logic yourself: a start-date formula that reads the predecessor's finish date, plus a bar chart drawn from those dates. Excel has no scheduling engine, so nothing recalculates a link for you. Raymond Panko's survey of spreadsheet research (What We Know About Spreadsheet Errors, 2005) reports field audits in which 90 percent of spreadsheets over 150 rows held at least one significant error, which is the risk every hand-built schedule carries.

In short. A Gantt chart with dependencies in Excel works for a short plan with one editor and finish-to-start links only. The method is a start formula built on WORKDAY and a stacked bar chart. It breaks on multiple predecessors, other link types, working calendars and shared editing, and at that point the sheet should move into a tool with a real scheduling engine.

How do you build a Gantt chart with dependencies in Excel?

Build the schedule as a table first and draw the chart second. The chart is only a picture of the dates, so the dependency logic lives in the columns.

1. Create columns for ID, Task, Predecessor (an ID), Lag (working days), Duration (working days), Start and Finish.
2. Type the start date of each task that has no predecessor.
3. For tasks with a predecessor, set Start to the working day after the predecessor finishes, plus the lag: =WORKDAY(INDEX($G$2:$G$40, MATCH(C3, $A$2:$A$40, 0)), 1 + D3)
4. Set Finish from the start and the duration: =WORKDAY(F3, E3 - 1)
5. Insert a stacked bar chart using Start as the first series and Duration as the second. Set the first series to no fill and reverse the task axis so the first row sits at the top.
6. Set the date axis minimum to the project start date, and add a conditional format on a grid of dates (=G$1=TODAY()) if you want a today marker.

Change a predecessor's duration and every dependent start moves, which is the one thing a dependency is for. The diagram below shows that chain: a finish date feeds the next start through the formula.

Where does an Excel Gantt chart with dependencies stop working?

Four things break it, and each one is a limit of the sheet rather than of your formulas.

The first two are the ones people hit early. A task that waits on two others needs MAX over two lookups, and a start-to-start link means rewriting that row's start by hand, so the sheet slowly becomes a set of exceptions only its author understands. The four dependency types are the vocabulary to use when you document them.

The third and fourth show up late. Once a colleague overwrites a date to "just fix it", the chart still draws, so the broken link is invisible until a milestone moves and a dependent task does not.

When is Excel enough for dependencies?

Excel is enough when all of these hold: one person edits the file, every link is finish-to-start, the plan has a few dozen tasks, and you do not need a critical path or a baseline. In that case the formula method above is quick and costs nothing. Stop when any one stops being true, because the fix gets more expensive with every row you add.

How do you move an Excel Gantt chart into a real scheduler?

Import the sheet instead of retyping it. Onplana accepts Excel and CSV files through the same import pipeline as .mpp files, rebuilds the task hierarchy from an outline-level column, a WBS code, a parent column or indentation, and reads a Predecessor column as finish-to-start links. Details are in importing a project schedule from Excel or CSV.

A short checklist for the move:

1. Replace the formula cells in Start and Finish with their values, so the import reads dates, not formulas.
2. Keep the ID and Predecessor columns, and add an outline level if the plan has a hierarchy.
3. Import the file, then check the dependency count against your sheet.
4. Set any start-to-start, finish-to-finish or lag links in the Gantt, where they are enforced rather than typed.

The Gantt, the critical path, baselines and all four link types are available on every Onplana plan, including Free, so the move does not require a paid tier. See Gantt charts with critical path and import and export for what carries across, and task dependencies for the commercial overview.

Check the plan you already have with the free Schedule Health Check Upload a schedule file and see dangling tasks, broken logic and missing links before you commit to it. No signup required. → Open the Schedule Health Check