Plan any project on a timeline that draws itself.
List your tasks and how long they take. The Gantt chart draws the bars, moves every task when the one before it slips, and marks today with a red line. No macros.
✓ One-off payment ✓ Instant download ✓ Excel for Windows & Mac
| Task | Owner | M | T | W | T | F | M | T | W | T | F | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Design | 63% | |||||||||||
| Wireframes | Jordan | Done | ||||||||||
| Visual design | Jordan | In progress | ||||||||||
| Copywriting | Priya | Overdue | ||||||||||
| Design approved | Alex | ◆ | Not started | |||||||||
| Build | 0% | |||||||||||
| CMS setup | Taylor | Not started |
Project plans go out of date the moment something slips
Colouring cells by hand
Most Excel Gantt charts are coloured in by hand. Change one date and you’re recolouring the lot.
One delay, ten changes
When one task runs late, every task after it needs new dates.
“Where are we?”
Hard to see what’s done, what’s late and who’s doing what at a glance.
Type the tasks. The chart does the rest.
List your tasks
Phases, tasks and milestones, with an owner and how many working days each takes.
Link them up
Give the first task a start date. For the rest, type which task they follow. Dates are worked out for you.
Track progress
Type % done as you go. Bars fill in, late tasks turn red, and the dashboard keeps score.
Change one date, and everything after it moves
Type the # of the task each one follows in After #. WORKDAY works out the start and end, skipping weekends and holidays. If a task runs a day late, every task after it moves too.
- Working days, weekends skipped
- Holidays you can edit
- Milestones at 0 days
| # | Task | After # | Days | Start | End |
|---|---|---|---|---|---|
| 2 | Kick-off meeting | 1 | Mon 7 Sep | Mon 7 Sep | |
| 3 | Gather requirements | 2 | 4 | Tue 8 Sep | Fri 11 Sep |
| 4 | Sitemap & content plan | 3 | 3 | Mon 14 Sep | Wed 16 Sep |
| 5 | Plan signed off | 4 | 0 | Thu 17 Sep | Thu 17 Sep |
| 7 | Wireframes | 5 | 5 | Fri 18 Sep | Thu 24 Sep |
See where the project stands
Overall progress, tasks done, what’s overdue, the finish date and working days to go. Plus what’s coming up next, sorted by end date, and each person’s workload.
- Coming up and overdue list
- Workload by owner
- Tasks by status chart
| Task | Owner | Ends | Status |
|---|---|---|---|
| Copywriting | Priya | Tue 29 Sep | Overdue |
| Visual design | Jordan | Fri 2 Oct | In progress |
| Design approved | Alex | Mon 5 Oct | Not started |
| CMS setup | Taylor | Fri 9 Oct | Not started |
Phases that sum themselves up
Add a Phase row above a group of tasks. Its start, end and progress are worked out from the tasks below it, and it draws as a dark bar on the chart.
- Phase start, end and progress
- Status for every phase
- 13-week timeline you can scroll
| Phase | Start | End | Progress | Status |
|---|---|---|---|---|
| Planning | 7 Sep | 17 Sep | 100% | Done |
| Design | 18 Sep | 5 Oct | 63% | In progress |
| Build | 6 Oct | 26 Oct | 0% | Not started |
| Launch | 27 Oct | 30 Oct | 0% | Not started |
For anyone running a project
Project managers
Plan, track and report on projects without paying for project software.
Small teams
Everyone can see who’s doing what, and what’s due next.
Students & personal projects
A dissertation, a house move, a wedding or a product launch.
Everything you get
- Up to 40 tasks, phases and milestones
- Tasks linked with After #: dates move when a task slips
- Working days with weekends and holidays skipped
- Bars that fill in as you type % done
- Late tasks in red and a red line for today
- Done, In progress, Behind, Overdue and Not started
- Phases worked out from their tasks
- Dashboard: progress, coming up, phases, workload and a chart
- 13-week timeline you can scroll to any date
One-off payment. Yours to keep.
Get instant access $12.99Secure checkout by Payhip · Card or PayPal
Download link emailed straight away
Hi, I’m Lee
I run Sheet Leveller on YouTube, where I make quick, no-nonsense Excel tutorials.
This planner is built on the WORKDAY and conditional formatting tricks from my tutorials, so the chart draws itself.
Questions
Do I need Microsoft Project?
No. It’s a normal Excel file with no macros, so it works in Excel for Windows and Mac.
Can a task follow more than one task?
Each task follows one task. Pick the one that finishes last.
Can I change the working week?
It uses Monday to Friday. Add your own days off, like company holidays, on the Settings tab.
How long a project can it show?
The chart shows 13 weeks at a time. Type a new date in Timeline starts to scroll through a longer project.
Does it use macros?
No. It’s a normal .xlsx file, so there are no security warnings and nothing to enable.
Which versions of Excel does it work with?
Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac. It’s built for Microsoft Excel.
Is this a subscription?
No. You pay once and the file is yours to keep.
Your project, on one page.
A Gantt chart that draws itself and keeps up when plans change.
Get the planner $12.99Not ready yet? Try the free Simple Gantt Chart.