The workbook has one sheet for the plan and one with instructions. Each row is a task with a phase, owner, start date, duration and percent complete. The end date is a formula, and a 26-week grid to the right colours the weeks each task covers.
Because it uses conditional formatting rather than a chart, the bars move as soon as you change a date, and the sheet prints like a normal table.
Free download
- Download the Excel template (.xlsx) One plan sheet with an example project, plus a How to use sheet. No macros, no sign-up.
- Download as CSV The same columns as plain text, for Google Sheets or any other app.
How to use the template
- Set the project start. Type your project's first day in the Project start cell at the top. The week headers across the grid count from that date.
- Replace the example tasks. Overwrite the Phase, Task and Owner cells. Enter each task's Start date and Duration in days; End is calculated for you.
- Chain tasks that wait on each other. Instead of typing a start date, make it a formula of the task before it, for example =F7+1 for the day after that task's end. For a task that waits on two others, use the later end: =MAX(F13,F14)+1. A change to one task then moves every task chained after it.
- Track progress. Enter Progress as a percentage. The finished part of each bar turns a darker shade, and the current week is outlined so you can see what should be done by now.
- Add rows and print. To add a task, insert a row inside the table so the formatting and formula copy down. To print, set the page to landscape and fit all columns on one page.
What's in the workbook
| Column | What it holds |
|---|---|
| Phase | The group the task belongs to, such as Plan, Build or Launch |
| Task | What the work is |
| Owner | One person responsible for it |
| Start | The first day of the task (a date) |
| Duration (days) | Calendar days, including the start day |
| End | Formula: Start + Duration - 1 |
| Progress | Percent complete, 0% to 100% |
| Week grid | 26 columns, one per week from the project start, coloured by conditional formatting |
The formulas, if you want to build your own
End date in column F, with Start in D and Duration in E:
=IF(OR(D7="",E7=""),"",D7+E7-1)The grid rules
Week start dates sit in row 6 from column H. The bar rule colours a week that overlaps the task; the progress rule darkens the weeks up to the completed share of the task; the today rule outlines the current week:
Bar: =AND($D7<>"", H$6<=$F7, H$6+6>=$D7)
Progress: =AND($D7<>"", $G7>0, H$6<=$D7+$E7*$G7-1, H$6+6>=$D7)
Today: =AND(TODAY()>=H$6, TODAY()<H$6+7)Working days instead of calendar days
The template counts calendar days so it works the same in every spreadsheet app. To skip weekends, replace the End formula with Excel's WORKDAY function, =WORKDAY(D7,E7-1), and chain the next task with =WORKDAY(F7,1).
When the template stops being enough
A spreadsheet has no idea which tasks depend on which, so it can't show the critical path, and someone has to maintain the chaining formulas. When that becomes the job, move the plan into a Gantt chart tool.
Copy the rows from your sheet, including the header row, and paste them into the box on the gantt-chart.io homepage. A column whose header contains "Task" becomes the task name and a column whose header contains "Duration" or "Days" becomes the length. Each row becomes a bar, linked one after another, up to 80 rows, with no account needed.
To keep the dates, owners and phases, save the sheet as CSV, sign in free and use Import data in the editor. The template's column names are the ones the importer reads.
Frequently asked questions
- Does Excel have a built-in Gantt chart?
- No. Excel has no Gantt chart type. The usual approaches are a stacked bar chart with the first series hidden, or conditional formatting on a grid of dates, which is what this template uses.
- Does the template use macros?
- No. It is a plain .xlsx file with formulas and conditional formatting only, so it opens without enabling macros.
- Can I use it in Google Sheets?
- Use the CSV download with our Google Sheets guide, which shows how to add the same bars with Sheets' conditional formatting or timeline view.
- How do I add more weeks?
- Copy the last week column to the right. The header formula adds seven days to the column before it, and the formatting rules apply to the copied cells.
- Can I import the template into gantt-chart.io?
- Yes. Paste the rows on the homepage for a quick chart with no account, or save as CSV and use Import data after signing in free. The Free plan saves 1 project.
Related
Try it on your own plan
Paste a task list on the homepage and get a live Gantt chart with dependencies and a critical path. No account needed to try.