New plan10 templates a month$14.95/month, cancel anytime

Start your plan
Microsoft Excel Gantt Chart Template with Dependencies, Baseline and Resource Workload preview 1 of 3
Project Management · Gantt Charts & Timelines

Microsoft Excel Gantt Chart Template with Dependencies, Baseline and Resource Workload

A Microsoft Excel Gantt chart project planner: phases and tasks with WBS numbers, finish-to-start, start-to-start, finish-to-finish and start-to-finish dependencies with lag, a baseline with slip, a Gantt chart by day or week, resource workload, a look-ahead list and a project dashboard.

Get this template

.xlsx · 7 sheets · includes charts

This template

$7.95single payment

  • Nothing renews
  • Download it again whenever you need
  • Yours to keep and edit
Buy this template
Cheaper than buying 2 separately

Monthly plan

$14.95/month

  • This template plus 9 more every month
  • About $1.50 a template if you use all 10
  • Thousands of templates to choose from
  • Cancel anytime
Start your plan
  • Secure checkout via Creem
  • Instant download after payment
  • 14-day refund policy

Gantt Chart Project Planner turns a task list into a working project schedule in Microsoft Excel. On the Plan tab, list phases at level 1, tasks at level 2 and subtasks at level 3. Each row gets a WBS number such as 2.2.1, and phase rows take their start, finish and progress from the tasks under them, with progress weighted by duration.

Give each task a duration in workdays, or a finish date, and the ID of the task it follows. Links can be finish-to-start, start-to-start, finish-to-finish or start-to-finish, with a lag or lead in workdays and a second predecessor. A task can follow a single task or a whole phase. Start and finish dates skip weekends and the holidays you list, and you can choose which days are non-working. A start-no-earlier-than date holds a task back when needed, and links that point to a missing task are flagged.

The Gantt Chart tab draws a bar for every task by day or by week. Done work is shaded darker than work to do, late tasks turn coral, phases show as summary bars, milestones as diamonds, the baseline as an amber underline and the status date as a coral line. Change the scale or the first date to move around the plan, and print it as a one-page landscape chart.

Save a baseline by pasting the agreed dates into the baseline columns, and every task and phase shows how many workdays it has slipped. Status compares each task's progress with where the plan says it should be on the status date: Done, In progress, Behind, Late, Not started or Upcoming. The Dashboard shows overall progress against plan, forecast finish against the baseline finish, late and behind counts, the next milestone, phase progress, a milestone list and the tasks that need attention.

The Resources tab lists the people on the project with their availability and shows each person's load week by week, with over-allocation in red, plus a team workload chart against capacity. The Look-ahead tab lists what is in progress, due and starting in the next few weeks for the weekly meeting. Capacity covers 200 rows and 15 resources. Calculated cells are locked and sheet protection has no password. Sample data from a fictional warehouse system rollout is included. Built for Microsoft Excel 2016 or later (desktop or Excel for the web) and contains no macros.

What's inside

  • 7 tabs, from a quick-start guide to Settings
  • Phases, tasks and subtasks with WBS numbering
  • Phase rollup of dates and progress
  • FS, SS, FF and SF dependencies with lag or lead
  • Second predecessor and links to whole phases
  • Workday durations with custom weekends and holidays
  • Gantt chart by day or week with progress shading
  • Milestones, baseline underline and status date line
  • Baseline slip in workdays for tasks and phases
  • Status: Done, In progress, Behind, Late, Not started
  • Resource workload by week with over-allocation
  • Look-ahead list and project dashboard
  • Locked formulas, no macros
#microsoft excel gantt chart#gantt chart excel#microsoft excel gantt chart template#gantt chart excel template#excel gantt chart with dependencies#create gantt chart in excel#gantt chart maker excel#project gantt chart in excel#weekly gantt chart excel template#gantt chart excel template with subtasks#project planner#baseline#resource planning#excel

More in Project Management