Guide · 2026-09-23

How to Make a Weekly Gantt Chart in Excel: 7 Easy Steps

Planning a week-by-week project in Excel can become frustrating quickly. Dates drift, task bars stop lining up, and a simple schedule turns into a maze of cells. Then someone asks which tasks are late, what comes next, or whether the team can meet the deadline.

That confusion usually comes from building the visual timeline before organizing the work underneath it. A better approach is to create a clean task list, assign weekly start and finish dates, then use conditional formatting to display each task as a colored bar.

Here’s the practical solution: build a weekly Gantt chart in seven steps. You’ll set up the schedule, calculate the timeline, highlight active weeks, and add progress details without needing advanced Excel skills.

How to Make a Weekly Gantt Chart in Excel

A weekly Gantt chart shows project tasks across calendar weeks. Each row represents a task, while colored cells show when that task starts, continues, and finishes.

The simplest method uses an Excel schedule with conditional formatting. You do not need a specialized chart template or complex visual object.

Step 1: Create the Task Information

Open a blank Excel worksheet and create these columns:

For example, a website launch might begin with the following tasks:

Task ID Task name Owner Start date End date Status Progress
1 Confirm requirements Mia April 7, 2025 April 11, 2025 Complete 100%
2 Create page designs Leo April 14, 2025 April 25, 2025 In progress 60%
3 Build landing page Sam April 28, 2025 May 9, 2025 Not started 0%

Keep one task per row. Avoid combining several activities into one line, because the chart will not clearly show ownership or timing.

Step 2: Add Weekly Timeline Headers

Choose a column after your task details for the first weekly period. Label it with the week’s starting date.

For example, enter April 7, 2025 in cell H1. In the next cell, enter:

=H1+7

Copy that formula across the row. Each header will advance by seven days:

Format the headers as dates so they remain easy to read. You can use a custom format such as mmm d, which displays April 7 as Apr 7.

Here’s why weekly headers matter: they reduce visual clutter. A daily timeline may require dozens of narrow columns, while a weekly view makes a three-month plan easier to scan.

Step 3: Align Each Week With a Seven-Day Period

Decide whether each weekly column represents the week’s starting date or any date within that week. Using the start of the week is usually clearer.

If your schedule begins on a Wednesday, you have two practical choices:

  1. Start the timeline on that Wednesday and continue in seven-day blocks.
  2. Start on the following Monday and show the partial week separately.

For most team schedules, Monday-based weeks are easier to understand. You can calculate the Monday for any date with:

=A2-WEEKDAY(A2,2)+1

If cell A2 contains a date, this formula returns the Monday of that week. This helps when tasks come from different planning conversations and do not already use consistent weekly boundaries.

Step 4: Apply Conditional Formatting to the Timeline

Select the timeline area, such as H2:Q20. Then open Excel’s conditional formatting menu and create a formula-based rule.

Use this formula if the week header represents the first day of each week:

=AND(H$1<=$E2,H$1+6>=$D2)

In this example:

Choose a fill color, such as blue, and apply the rule. Excel will shade a cell whenever the task overlaps that week.

Let me explain: the formula checks whether the task’s date range intersects the weekly date range. A task does not need to begin on Monday to appear in that week.

Step 5: Add Separate Colors for Status or Progress

A single color shows timing, but additional visual cues help you understand project health.

You can create separate rules for common statuses:

For example, a delayed-task rule could use:

=AND(H$1<=$E2,H$1+6>=$D2,$F2="Delayed")

Place more specific rules above general rules in the conditional formatting manager. If Excel applies several rules to the same cell, rule order determines which color you see.

You can also display progress in its own column. A 60% value tells you how much work is complete, while the colored bar shows when that work should happen.

Step 6: Improve the Layout for Weekly Planning

Small formatting improvements can make the schedule much easier to use.

Set each weekly column to a narrow, equal width. Then use a slightly darker border after every four or five weeks to mark monthly boundaries.

The best part? These changes improve readability without changing any formulas. A clean layout helps you spot gaps, overlapping activities, and overloaded owners faster.

Step 7: Review, Test, and Maintain the Schedule

Test the chart with three simple cases:

  1. A task that starts and ends within one week.
  2. A task that crosses several weeks.
  3. A task that begins midweek and ends early in the next week.

Check that every expected week receives a colored cell. If a task is missing, inspect the start and end dates for hidden time values or inconsistent formatting.

When the schedule changes, update the dates rather than manually coloring cells. The formatting rule should redraw the timeline automatically.

Review the chart at least once each week. Compare planned dates with actual progress, identify delayed activities, and adjust later work when a dependency moves.

What a Weekly Gantt Chart Should Show

A useful weekly Gantt chart answers four questions quickly:

The timeline is the visual layer. The task details provide the context behind each colored bar.

Tasks and Milestones

Tasks describe work that consumes time. Milestones mark important events, such as approval, launch, or testing completion.

For a milestone, use the same start and end date. You can apply a diamond symbol or a distinct fill color to make it stand out.

For example, “Design approved” may occur on April 25. It does not need a five-day bar because it represents a decision point rather than a long activity.

Dependencies

Dependencies show why one task cannot begin until another activity reaches a certain point.

Consider this sequence:

  1. Confirm requirements.
  2. Create page designs.
  3. Approve designs.
  4. Build the landing page.

If approval takes two extra days, development may need to move. Excel can display the date change, but you must review the affected tasks manually.

Add a “Depends on” column when the project has several linked activities. This small addition makes schedule changes easier to understand.

Baseline and Actual Dates

A basic schedule uses planned start and finish dates. A more useful planning view can also include actual dates.

For example, add:

Use one color for the plan and another for actual progress. If work finishes later than planned, the difference becomes visible instead of remaining hidden in a status label.

Useful Excel Formulas for a Weekly Timeline

Formulas reduce repetitive updates and make your schedule more reliable. You can adapt them to your column arrangement.

Calculate Task Duration

To calculate calendar days, use:

=E2-D2+1

To count working days while excluding weekends, use:

=NETWORKDAYS(D2,E2)

To exclude holidays listed in cells M2:M10, use:

=NETWORKDAYS(D2,E2,$M$2:$M$10)

This distinction matters. A task lasting seven calendar days may contain only five working days.

Calculate a Finish Date

If you know the start date and working-day duration, use:

=WORKDAY(D2,G2-1)

Here, D2 contains the start date and G2 contains the number of working days. Subtracting one counts the starting day as the first working day.

Flag Overdue Tasks

To flag unfinished work that has passed its end date, use:

=AND(E2<TODAY(),F2<>"Complete")

Apply a red font or fill to the result. This helps you find schedule risks without scanning every row.

Show the Current Week

You can highlight the current week with:

=AND(H$1<=TODAY(),H$1+6>=TODAY())

Apply a border or pale yellow fill instead of the same color used for task bars. The current-week marker should guide attention without hiding task status.

Common Mistakes When Building the Chart

Most weekly Gantt chart problems come from inconsistent planning habits rather than difficult Excel features.

Using Text Instead of Real Dates

If Excel treats “April 7” as plain text, formulas may not work correctly. Test a date by changing its format. If the value changes appearance, Excel recognizes it as a date.

Enter dates consistently, such as 4/7/2025, and apply your preferred display format afterward.

Manually Coloring Task Cells

Manual fills may look quick at first. They become unreliable after a task moves from one week to another.

Conditional formatting keeps the visual timeline connected to the schedule. Change the dates, and the bars move with them.

Making the Timeline Too Detailed

A weekly view should support weekly decisions. Adding every day, hour, or minor activity can make the chart difficult to scan.

Use a separate detailed planning view when the team needs daily coordination. Keep the weekly version focused on milestones, major tasks, and delivery timing.

Ignoring Non-Working Days

A bar that spans Saturday and Sunday may suggest active work when the team does not work those days.

Decide whether the chart represents calendar time or working time. Then explain that choice in a note near the timeline.

Weekly Gantt Chart Solution: ONES.com

Excel works well for a small, mostly static schedule. As tasks, dependencies, approvals, and progress updates grow, you may need a workspace designed for ongoing project coordination.

ONES.com product screenshot

ONES.com combines project management and knowledge management on one platform. ONES Project provides project planning and tracking, while ONES Wiki supports team knowledge management. They are sold separately.

Value Proposition

ONES.com can help you move from a manually maintained weekly timeline to a connected project workflow with shared visibility, structured updates, and fewer disconnected tools.

Core Capabilities

Scattered task planning → ONES Project task management → One shared view of work

When tasks sit across separate schedules and conversations, owners may miss changes. ONES Project centralizes tasks, assignments, dates, and status updates so the team can work from the same project view.

Manual timeline maintenance → Gantt-style project planning → Faster schedule updates

Changing several dates by hand can create errors. Timeline planning in ONES Project connects task timing with project progress, reducing repetitive schedule maintenance.

Unclear dependencies → Linked project relationships → Earlier risk visibility

When one delayed activity affects another, the impact can remain hidden in a basic worksheet. Dependency planning helps you see how tasks connect and where a delay may affect delivery.

Inconsistent processes → Custom workflows and fields → More reliable project control

Different teams often track approvals and statuses differently. Custom workflows and fields let you define stages that match your process, such as review, approval, development, testing, and release.

Separate progress calculations → Built-in reporting → Clearer project health

Manual status summaries take time and may become outdated. Built-in reporting gives you a clearer view of progress, workload, and delivery trends.

Repeated administration → Automation → Fewer routine updates

Recurring assignments, status changes, and notifications can consume attention. Automation handles defined actions so the team can focus on project decisions.

Familiar Jira workflows → Jira-compatible project management → Easier transition

If your team already uses Jira-style workflows, ONES Project can support familiar working patterns. That makes it a practical Jira alternative for teams seeking native workflow parity with fewer plugins.

Restricted deployment requirements → On-premise, private cloud, or air-gapped deployment → More control over where work runs

Some teams cannot place project information in a public cloud environment. ONES.com supports Cloud, On-Premise, Private Cloud, and Air-gapped deployments, with full feature parity between cloud and self-hosted versions.

Application Scenarios

A software team could use ONES Project to plan a release across design, development, testing, and deployment. Dependencies would connect each stage, while reports would show whether the release remains on schedule.

A construction or engineering team could organize approval-heavy work with custom fields for inspection status, responsible parties, and delivery dates. Managers could review high-risk activities without rebuilding a weekly chart.

A restricted-network organization could use an air-gapped deployment when project coordination must remain within a controlled environment. The team would still retain the same core platform capabilities available in other deployment options.

Common Challenges and Practical Solutions

Challenge: The Chart Becomes Too Wide

A long project may require dozens of weekly columns. This makes task names difficult to keep visible.

Solution: Freeze the task columns, group older weeks, and create separate views for near-term planning and the full project horizon.

Challenge: Dates Change Frequently

Project schedules rarely remain fixed. Manual colors quickly become inaccurate when work moves.

Solution: Use formulas and conditional formatting instead of hand-filled timeline cells. Update the dates and let Excel redraw the bars.

Challenge: People Cannot Tell What Is Delayed

A blue bar may show planned timing, but it does not explain whether work is progressing.

Solution: Add status, progress, and actual-date columns. Use a separate delayed rule that stands out from the regular task color.

Challenge: Several Tasks Share One Owner

Each individual task may appear reasonable, yet one person may have too much work in the same week.

Solution: Filter or sort by owner, then compare overlapping bars. Consider adding a workload view when capacity planning becomes a regular concern.

Challenge: The Schedule Stops Reflecting Reality

A chart can look polished while remaining outdated. This happens when updates are treated as occasional administrative work.

Solution: Assign a weekly review owner. During the review, confirm completed work, revise dates, record blockers, and communicate changes to affected people.

FAQs

Can I create a weekly Gantt chart in Excel without a template?

Yes. You can build one with task details, weekly date headers, and conditional formatting. The key formula checks whether a task’s start and end dates overlap each weekly period. This approach gives you more control than a fixed template because you can change the columns, colors, statuses, and formulas to match your project.

What formula colors a task across several weeks?

Use a formula that compares each week with the task’s date range. If the week begins in H1, the task starts in D2, and it ends in E2, use =AND(H$1<=$E2,H$1+6>=$D2). The cell receives formatting whenever at least one day in that week overlaps the task period.

Should each weekly column start on Monday?

Monday-based columns are usually easiest for team planning because many work schedules use Monday through Friday. However, another starting day can work for global teams or special operating cycles. Choose one convention, apply it consistently, and label the headers clearly so nobody misreads the periods.

How do I show milestones in a weekly schedule?

Give the milestone the same start and end date, then apply a separate conditional formatting rule or symbol. For example, “Client approval” may occur on April 25. A diamond, bold marker, or contrasting color will distinguish that event from tasks lasting several days.

When should I use a project management platform instead of Excel?

Excel is suitable for small projects with limited collaboration and occasional schedule changes. A project management platform becomes more useful when you need dependencies, activity history, automation, workload visibility, recurring updates, approval workflows, or controlled deployment options.

Conclusion

A weekly Gantt chart in Excel is easiest to maintain when you separate task details from the visual timeline. Start with clear owners, start dates, end dates, and statuses. Then create weekly headers and use conditional formatting to display task bars automatically.

Test the chart with short, long, and midweek tasks. Add progress, milestones, dependencies, and overdue indicators when the project needs more context.

But here’s the truth: a polished schedule cannot fix unclear ownership or irregular updates. Review it weekly, keep dates current, and move to a connected project workflow when the plan outgrows manual maintenance.