Weekly Gantt Chart in Excel

01 When a weekly Gantt chart is the right zoom

Each column is one Monday-to-Sunday week. You lose the exact day each task starts, and in return the whole project fits on one screen. For anything from about six weeks to about six months long, that’s usually the view you want.

The villa build on this page runs for about four and a half months. By the day, that’s 141 columns and a lot of sideways scrolling. By the week, it’s 21 columns, which fits on a laptop.

Most people end up using two of these, not one. Daily View while you build the plan and chase this week’s work, Weekly View when someone asks what the next three months look like. Switching is one click and changes nothing in the plan, so there’s no reason to pick one and stick with it. The monthly Gantt chart page covers the view above this one, and hourly planning the one at the other end.

02 Switch any chart to Weekly View

There is no weekly template to find. Every Gantt Excel chart can be shown by the week, including one you built last year in Daily View.

1. On the Gantt Excel tab, find the Views and Timeline group.
2. Click More Views and choose Weekly View, the green W at the top of the list. The header redraws in weeks and every bar is redrawn against the new columns.
3. Click Show Full Timeline. It fits the whole project on screen, from the Monday of the first week to the Sunday of the last.

Weekly View lives under More Views, beside Monthly, Quarterly, Half Yearly and Yearly.

Make the weeks wider or narrower

Setup Timeline opens a dialog with one column width per view. The Weekly box is the one that matters here. Each view remembers its own width, so a comfortable weekly width doesn’t squash your daily one. Narrow it to see more weeks at once, widen it when the bar labels start to crowd.

The Start Date and End Date in this dialog only change how much of the timeline you see. They don’t move any tasks.

03 Reading the header: month, week number, Monday

The timeline header has three rows, and in Weekly View they read from the widest unit down.

Top row: the month

Printed where a new month begins, such as September-2026, so you can see where one month hands over to the next.

Middle row: the week number

Printed as W36, W37 and so on. These are ISO week numbers, the international standard.

Bottom row: the Monday

The date each week starts on, such as 7 Sep. This is the row to read when you need a date.

ISO weeks always start on a Monday. Most years have 52 of them, but some have 53, and 2026 is one. You can see it in the chart at the top of this page: the week starting 28 December is W53, the next one is W1, and plastering runs straight across both. If your own chart shows a W53, it’s correct.

Daily View prints the same week numbers above each Monday, so a week number read off one view matches the other.

04 The villa build, week by week

This is the project the rest of this site uses: the Oakfield Villa build, led by Amara Whitfield. Here it’s the full programme, about four and a half months from the client brief to handover. The crews work Monday to Saturday, and each task starts when the one before it finishes. By the week, it reads as four phases:

The timeline on its own. Every column is a Monday-to-Sunday week, headed by its Monday.

Why a four-day task can look two weeks long

In Weekly View a bar fills every week it touches. Two tasks on the villa show the difference:

• Pour footings takes four working days, Tuesday to Friday of the same week. Its bar is one column wide.
• Site clearance also takes four working days, but runs Thursday to the following Monday. It crosses a weekend, so it touches two weeks and its bar is two columns wide.

Both are right. The bars show which weeks a job lands in. For the exact days, read the Start and Finish columns, which never round.

For a shorter version of the villa build drawn by the day, see the construction Gantt chart page.

05 The schedule still counts working days

A view is only a way of looking. It doesn’t change how Gantt Excel does its sums, and this catches people out when they expect a weekly chart to plan in weeks.

• Durations stay in working days. A job that takes three working weeks on a Monday-to-Friday calendar is a duration of 15, whichever view is on screen. Type the start and the duration and let the finish date work itself out around weekends and holidays. On the villa, Blockwork walls is 24 working days: four six-day weeks.
• Links behave exactly as they did. Push a task back and everything linked to it moves, weekends skipped, and the bars redraw in whichever weeks they now touch.
• Each person’s calendar still applies. On the villa, the crews work Saturdays, so Saturday counts. For someone who works Monday to Friday it doesn’t. That’s set per resource, and it drives the dates in every view.
• Weekend and holiday shading is a Daily View thing. The grey non-working columns only make sense when a column is a day. In Weekly View they’re not drawn, but they are still being skipped in every date the chart calculates.

Resources, calendars and working days explains how to set the days each person works.

06 Printing a weekly Gantt chart on one page

Weekly View is also the easiest way to print a long plan. A twelve-month project is unreadable printed by the day, and fits on one landscape page by the week.

1. Switch to Weekly View and click Show Full Timeline, so the printout covers the whole project and nothing more.
2. On Excel’s own Page Layout tab, choose Landscape and set Scale to Fit to one page wide. Set a Print Area around the task list and timeline if you only want part of the sheet.
3. Press Ctrl+P and check the preview before you print or save a PDF.

Gantt Excel Pro adds one-click export of the chart to PDF and to an XLSX file anyone can open, using the same page setup. Exporting and printing has the details, including the fix when a PDF is missing the last few weeks.

07 Common questions