Project Timeline · Free · No account
Draw a timeline from task start and finish dates.
The workbook includes a Tasks sheet and a Timeline. Type each task with its start and finish dates; the duration is worked out and the Timeline draws the bar across days, weeks or months, coloured by phase, with progress, milestones and today marked.
- 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: Project by week. 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
Dates in, bars out
Type a start and a finish; the duration is worked out and the bar is drawn. No formatting rules to write.
Day, week or month
One column per day for an event, per week for most projects, or per month for a long one.
Colour by phase
Each phase gets its own bar colour, so overlapping stages are easy to tell apart.
Prints across pages
Landscape across as many pages as it needs, with the task names repeated on every page.
The Project by week example
Five phases from Plan to Launch, % complete and milestones, across 26 weeks from the earliest start date, with each phase in its own colour.
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
Examples
Gantt chart template
Anyone planning a project of a few weeks to a few months who wants a Gantt chart without building one in Excel.
Event timeline by day
People planning a party, a wedding, a conference or a launch over a few weeks, who need to see what happens on which day.
Construction schedule by month
Home renovators and small builders running a project over many months, who need to see each stage and how they overlap.
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.
Do I type a duration?
No. Type the start and finish dates and the duration is worked out. A row with only one date, or a finish before its start, is highlighted and draws no bar until it is fixed.
How do I see a later part of a long project?
The Timeline starts at the earliest start date. On the Settings sheet, type how many days, weeks or months to move it on, and the whole chart moves.
Can I print it?
Yes. The Timeline prints landscape across as many pages as it needs, with the task names repeated on every page.
Does it link tasks that depend on each other?
No. Each task uses the dates you enter, and its dates do not change when another task changes. Record dependencies in Notes.
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.