Excel template

Gantt Chart Project Schedule

Enter a task, start date and duration. The end date and Gantt bars are drawn for you, with progress shading and late tasks highlighted. Day or week view.

Get it on Gumroad · USD 7

Opens the Gumroad product page. The price shown there is the one that applies.

Need more than one template? This one is also in the Excel Templates Bundle (all 4) on Gumroad: $19 instead of $30 bought separately.

Free lite edition (xlsx): 15 tasks, day view

Direct download, no sign-up. No week view or Skip weekends.

See how it works

Animated demo in 3 steps: 1. Type your tasks and start dates. 2. Add days: end dates and bars appear. 3. Enter progress: bars fill in, status updates. Fictional sample data.
3 steps, loops. Real sheet, recalculated in LibreOffice. Sample data is fictional.

What the sheets look like

Gantt bars from start date and duration, Schedule sheet (screenshot, fictional sample data)
Gantt bars from start date and duration (Schedule sheet). Sample data is fictional.
End date, progress and status calculated, Schedule sheet (screenshot, fictional sample data)
End date, progress and status calculated (Schedule sheet). Sample data is fictional.

What it does

What it does not do

How to use

  1. On Schedule, enter one task per row: phase, task, owner, start date, duration, progress. Yellow cells are inputs.
  2. Pick the view unit (Day or Week). Optionally set the view start and Skip weekends = Y.
  3. Leave the status date blank to use today, or type a date.
  4. Read the bars: dark blue is done, light blue is remaining, late rows are highlighted.
  5. For the next project or year, change only the view start.

Sheets in the file

Compatibility

Free guide and tool

FAQ

If I move one task, do the next ones move?

No. There are no task dependencies; each task has its own start date.

Are holidays skipped?

With Skip weekends = Y, Saturdays and Sundays are skipped. Public holidays are not handled.

How long a project fits?

Up to 200 tasks. Day view shows 91 days; week view shows about 1 year 9 months.

Gantt Chart Project Schedule

Excel file (.xlsx), no macros. USD 7 on Gumroad.

Get it on Gumroad · USD 7

Digital download. If the file doesn't work for you, email within 30 days for a full refund.

Good to know