Project Timeline · Free · No account
A Gantt chart template that fills itself in from your dates.
The weekly setup draws each task as a bar across 26 weeks, starting from the earliest start date. Each phase has its own colour, the darker part of a bar shows how much is done, overdue work turns red and milestones are marked with a diamond.
- Excel 2016 and later
- Calculations checked in LibreOffice
- Choose the viewPick one column per day, week or month, how many to show, and which day your weeks start on.
- Name the phasesType the phases in order, one per line. Each gets its own bar colour. Switch on owners, % complete and milestones if you want them.
- Type the datesDownload the workbook and type each task with its start and finish dates. The bars appear on the Timeline sheet as you type.
Build your workbook
Preview: Gantt chart template. Change the selected dates, categories or layout to update the preview.
JavaScript is required to use the builder. The workbook is made in your browser.
What you get
What is different in this setup
Anyone planning a project of a few weeks to a few months who wants a Gantt chart without building one in Excel.
- One column per week, 13, 26 or 52 weeks.
- Bars coloured by phase, with progress and overdue marked.
- Milestones shown as a diamond on their finish date.
Sheets included (5)
- Start HereHow the workbook works, what each sheet is for and the settings used.
- TasksOne row per task, with its start and finish dates. Start typing in row 6.
- TimelineEach of the first 200 tasks as a bar across 26 weeks, coloured by phase, with progress, milestones and today marked.
- ListsEdit the white lists to change dropdown choices. Shaded lists are fixed because formulas use those names.
- SettingsValues used by the workbook, such as reminder windows. Change them here.
File details
- Made for
- Excel 2016 and laterThe download is an .xlsx workbook.
- LibreOffice
- No calculation errors in our testLibreOffice recalculated every formula in the workbook with no error values, such as #VALUE! or #N/A.
- Calculations
- The Start Here sheet lists the calculations used in this workbook. Results update from the entries you add.
- Builder privacy
- The builder runs in your browser. The entries used to make the workbook stay on your device. How the utilities work
Questions
Are my builder entries sent to Due Form?
No. The builder uses them in your browser to make the workbook on your device.
Information is sent to Due Form when you submit a form or use another service described on the How it works page.
Can I change the phase colours?
Yes. Each phase takes its colour from its place in the Phases list on the Lists sheet, so reorder the list to change which phase gets which colour.
How many tasks does the Timeline show?
The first 200 tasks on the Tasks sheet. The Tasks sheet itself has as many rows as you chose in the builder.
Request a tool or send feedback
Request a tool or report a problem
Tell us what you would like to add, change or fix in the Project Timeline builder.