Gantt Chart Template

What it does

• Gantt tab: ID, phase or task, type (phase or task), owner, after ID, lag, workdays, planned start, start, finish, % done, status and a check column, for up to 100 rows
• Dependencies: a linked task starts the next workday after the task it follows, plus any lag. Change one task and every task after it moves
• Workdays skip weekends and your own holidays (list up to 30 on the Setup tab)
• Phases: add a phase row and it takes its start, finish and % done from the tasks below it
• Bars show progress: dark for the part that is done, light for the part still to do, grey for phases
• Weekly or daily timeline: pick Weeks or Days at the top of the sheet. 36 columns at a time, with a Timeline from date to scroll. Today is marked in yellow, and the daily view shades weekends and holidays
• Status drop-down (Not started, In progress, Done, Blocked) and an Owner drop-down from your team list
• Schedule checks: the sheet flags tasks that are overdue, blocked, planned to start before the task they follow is done, or linked to a task that is not listed above
• Dashboard: project start and finish, total workdays, workdays left, tasks done, work done (weighted by workdays), overdue tasks, schedule issues, blocked tasks and tasks finishing in the next 7 days, plus every phase with its dates and % done and a list of what needs attention
• Formulas only: no macros and no add-ins

What you get

• XLSXGantt-Chart-Template.xlsx (blank)
• XLSXGantt-Chart-Template-with-Sample-Data.xlsx (a filled-in example: a website launch with 5 phases and 20 tasks over about 10 weeks)
• PDFQuick-start guide (PDF)

Good for

Small business owners, project coordinators, contractors, event planners and students who want a simple project timeline in a spreadsheet.