Gantt Chart Project Timeline Spreadsheet: Dependencies, Work Days, Milestones (Excel + Google Sheets)

Gantt chart spreadsheet with task dependencies, work days and holidays, daily and weekly views and milestones. Excel + Google Sheets, with a setup guide and video.

Watch the setup guide & full tour

Plan a project the way it really runs, with tasks that wait for each other.

The Gantt Chart Project Timeline is a ready-to-use spreadsheet for Microsoft Excel and Google Sheets. Type your tasks, how long they take and what they wait for. Dates skip weekends and holidays, and the Gantt chart draws itself.

What’s inside (7 connected tabs)

• Start Here: 6-step setup + colour key
• Dashboard: Progress, late tasks, finish date, next milestone
• Setup: Project start, view start, holidays, phases
• Tasks: 200 tasks, depends-on, dates worked out
• Gantt Daily: 91-day chart with done shading + today line
• Gantt Weekly: 52-week chart for long projects
• Milestones: Every milestone, soonest first

Why you’ll like it

• Dependencies: type what a task waits for and its dates follow
• Working days only: weekends and your holidays are skipped
• Done part shaded on each bar, so progress is visible at a glance
• Daily and weekly views, plus a today line
• ‘Behind plan’ flag compares % done with time used

Also included

• Setup Guide PDF
• Video walkthrough https://youtu.be/y8zxf2LXYik
• Sample data that follows today’s date

Formulas only: no macros, no add-ons, no subscription. Works in Excel 2016+, Microsoft 365 and Google Sheets.

Part of the Project Management Spreadsheet collection. More tools at createdigitaltools.com