Gantt Chart vs Kanban Board: Which Should You Use?
They are not competing methods. They are two ways of sorting the same rows.
A Gantt chart sorts by time. A Kanban board sorts by state. Once you see it that way the choice stops being philosophical and becomes a question about which fact you need on screen this week.
The Core Difference in One Table
| Gantt chart | Kanban board | |
|---|---|---|
| Organised by | Dates | Status |
| Answers | When does what happen? | What is moving right now? |
| Requires | A start and due date on every task | A status on every task |
| Shows overlap | Yes — visually, instantly | No |
| Shows overload | Poorly | Yes — count the cards per person |
| Shows blocked work | Only if you colour it | Yes — it is a column |
| Good for | Planning, sequencing, reporting out | Running the week, stand-ups |
| Falls apart when | Tasks have no dates | The deadline is the whole point |
The Gantt is the view you show someone who is not doing the work. The Kanban is the view for the people who are.
Eight Questions That Decide It
Answer these about your actual project rather than about projects in general.
| Question | If yes |
|---|---|
| Is there a fixed external deadline? | Gantt |
| Does task B genuinely have to wait for task A? | Gantt |
| Does a client or an exec want a schedule? | Gantt |
| Do you need to know what overlaps in week 6? | Gantt |
| Does work arrive continuously with no end date? | Kanban |
| Is the recurring question “who is overloaded?” | Kanban |
| Do things get stuck waiting on other people? | Kanban |
| Do you run a short daily or weekly stand-up? | Kanban |
Three or more Gantt answers and you are planning a project. Three or more Kanban answers and you are running an operation. Most teams tick boxes on both sides, which is the normal outcome and the reason the next section exists.
The Date-Coverage Test
Before choosing the Gantt, check whether you can actually draw one. A Gantt only renders tasks that have both a start and a due date. Anything missing one simply does not appear — it does not error, it does not warn, it is just absent.
The layout used throughout this article is the one the task list uses everywhere else: C task name, D owner, F status, G start date, H due date, J % complete. So:
=COUNTIFS(G4:G200,"<>",H4:H200,"<>") / COUNTA(C4:C200)
Bound the ranges rather than using whole columns — C:C would count the header row and inflate the denominator.
Read the result honestly. These bands are my own working thresholds rather than an industry standard, but they hold up in practice:
- Above 90% — the Gantt is a fair picture of the project.
- 80–90% — usable, but know which tasks are missing.
- Below 80% — the chart is hiding a fifth or more of your work while looking complete. That is worse than no chart. Use the Kanban until the dates exist.
This test catches the most common failure of spreadsheet Gantts: they look finished long before the plan is.
Running Both Off One Task List
In a spreadsheet you never choose permanently, because both views are formulas reading the same rows. The board is the one people assume needs manual card-dragging. It does not.
Step 1 — a helper key on the task list. With status in column F, add a column — say N — that numbers each status occurrence:
=IF(C4="","",F4&"-"&COUNTIF($F$4:F4,F4))
The mixed anchoring — $F$4:F4 — makes the range grow as it fills down, so the first To Do gets To Do-1, the second gets To Do-2, and so on.
Step 2 — the board columns. Task names are in C and the helper key is in N. On a Kanban tab, under a heading of “To Do”, put this in the first card cell and fill down:
=IFERROR(INDEX('Task List'!$C$4:$C$200,
MATCH("To Do-"&ROW()-3,'Task List'!$N$4:$N$200,0)),"")
Change "To Do-" to "In Progress-", "Done-" and "Blocked-" for the other columns. Adjust the -3 so that the first card row resolves to 1.
That is the whole board. Change a status on the task list and the card moves between columns on the next recalculation. No array formulas, no macros, and it behaves identically in Excel and Google Sheets.
The Number the Kanban Gives You That the Gantt Cannot
Work in progress per person. A Gantt will happily show one owner with four overlapping bars in the same fortnight and it looks like a busy schedule. On a board it looks like what it is — four cards under one name, none of them finishing.
Per owner, with owner in D and status in F:
=COUNTIFS('Task List'!$D$4:$D$200,A2,'Task List'!$F$4:$F$200,"In Progress")
A WIP limit of 2 per person is a common starting point rather than a measured optimum — treat it as a default to argue with. Conditional-format the count red above it. The limit is not about effort. Someone holding five open tasks is not going five times faster — they are paying a context-switching cost on every one and delivering none of them, which is why a board full of half-done cards and a board with a queue often represent the same amount of finished work.
Raise it only if you can show that finished work went up, not that started work did.
And the Number the Gantt Gives You That the Kanban Cannot
A window that has opened with nothing in it. A task whose start date passed four days ago and is still sitting at 0% is invisible on a Kanban board — it is one more card in the To Do column, indistinguishable from a card due next month. On a Gantt it is obvious: the bar has begun and it is entirely unshaded.
That is the earliest reliable slip signal in any project, and it is the reason a team that runs only a board tends to discover problems at the due date rather than a week before it. The other six warning signs worth checking weekly.
The Practical Answer
Keep one task list. Look at the Kanban every day or at your stand-up, because the question that matters daily is what is moving and what is stuck. Look at the Gantt once a week and before every commitment you make to somebody outside the team, because the question that matters then is whether the calendar and the work still agree.
Choosing between them is only a real dilemma in tools where they are separate products. Here is how to build both from one sheet, and the four conditional formatting rules that draw the Gantt.
Featured on ReadySheetGo
Project Management & Gantt Chart Tracker — $14.99
Both views, one task list, already wired together. The Gantt Chart draws its bars from each task’s start and due dates across a rolling day-by-day timeline, shaded to separate completed work from remaining. The Kanban Board re-sorts itself into To Do, In Progress and Done the moment a status changes — no dragging, no duplicate entry. Alongside them: a Task List with project, owner, priority, status, dates, automatic duration, % complete, a Depends On (ID) column and budget versus actual; a Milestones tab with a days-left countdown and at-risk highlighting; a Projects roll-up across every project; and a Dashboard returning total tasks, completed, in progress, overdue, overall % complete, budget versus actual and workload by owner. Overdue tasks turn red automatically. Settings holds editable dropdowns for statuses, priorities, owners and projects.
Sample data pre-filled across four example projects. Works in Excel and Google Sheets, no macros and no add-ons.
Get the Project Management & Gantt Chart Tracker →
Frequently Asked Questions
What is the difference between a Gantt chart and a Kanban board?
A Gantt chart is organised by time and a Kanban board is organised by state. The Gantt puts every task on a calendar so you can see what runs when, what overlaps and what has to finish before something else can start. The Kanban sorts the same tasks into columns by status — To Do, In Progress, Done — with no dates at all. That is why the Gantt is the right view for planning a launch and the Kanban is the right view for a Monday morning stand-up.
Should I use a Gantt chart or a Kanban board for my project?
Use a Gantt if the project has a fixed external deadline, tasks that depend on each other, or somebody outside the team who wants a schedule. Use a Kanban if work arrives continuously with no end date, if the recurring question is who is overloaded, or if you need to spot blocked work fast. Most real projects want both, which is easy in a spreadsheet because both are views of the same task list rather than two systems to keep in sync.
Do I need dates on every task to use a Gantt chart?
Effectively yes — a Gantt only draws the tasks that have both a start and a due date, so any task missing one is invisible. With task names in C, start dates in G and due dates in H, run =COUNTIFS(G4:G200,"<>",H4:H200,"<>")/COUNTA(C4:C200) against your list. Below about 80% coverage the chart is quietly hiding a fifth of your project and a Kanban board is the more honest view until you fill the gaps in.
What is a WIP limit and how do I set one?
A work-in-progress limit caps how many tasks any one person may have In Progress at the same time — usually two, sometimes three. It exists because a person with five open tasks is not working five times faster, they are context-switching and finishing nothing. In a spreadsheet you enforce it with =COUNTIFS(Tasks!$D$4:$D$200,A2,Tasks!$F$4:$F$200,"In Progress") per owner and a conditional format that turns the count red above your limit.