How to Make a Weekly Gantt Chart in Excel

A weekly Gantt chart is a powerful project management tool that transforms a simple task list into a clear visual timeline. It’s perfect for tracking sprints, content calendars, or any project that moves in weekly cycles. This step-by-step guide will show you exactly how to build a dynamic weekly Gantt chart in Microsoft Excel from scratch.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is a Gantt Chart?

A Gantt chart is a type of bar chart that illustrates a project schedule. Each bar represents a task, and its position and length on the timeline correspond to the task's start date, end date, and duration. It answers the fundamental project questions: "What needs to be done?" and "When does it need to be done?"

Unlike a simple to-do list, a Gantt chart provides a bird's-eye view of your project, helping you:

• Visualize task dependencies: Understand which tasks must be completed before others can start.
• Track progress: See how far along you are at a glance.
• Manage resources effectively: Avoid overloading team members by spotting overlapping tasks.
• Communicate deadlines clearly: Keep stakeholders informed with an easy-to-understand project timeline.

For weekly planning, it helps you break down large goals into manageable, week-by-week activities, ensuring your team stays focused and on schedule.

Setting Up Your Excel Spreadsheet

Before you can build the chart, you need to structure your project data correctly. This is the foundation of your Gantt chart, so getting it right is important. Open a new Excel sheet and create a simple table with the following four columns:

• Task: A brief description of the task to be completed.
• Start Date: The date the task is scheduled to begin.
• End Date: The date the task is scheduled to be completed.
• Duration: The number of days the task will take.

Your setup should look something like this:


Enter your project tasks, along with their start and end dates. To calculate the Duration, use a simple formula. In cell D2, type:

=C2-B2

This formula subtracts the start date from the end date to give you the task's total duration in days. Press Enter and then click on the small square at the bottom-right corner of cell D2 and drag it down to apply the formula to the rest of your tasks.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Creating the Bar Chart Foundation

Now for the visual part. The secret to an Excel Gantt chart is that it is actually a modified stacked bar chart. We will use the task start dates to position the bars and the durations to determine their length.

Step 1: Insert a Stacked Bar Chart

1. Highlight your task names and start dates. To do this, select the range of your task names (e.g., A2:A8), then hold down the Ctrl key (or Cmd on Mac) and select the range of your start dates (e.g., B2:B8).
2. Go to the Insert tab on the Excel ribbon.
3. In the Charts group, click Insert Column or Bar Chart.
4. From the dropdown menu, under 2-D Bar, select Stacked Bar.

You should now have a basic chart on your worksheet. It won't look like a Gantt chart yet, but this is our starting point.


Transforming Your Bar Chart into a Gantt Chart

This is where we work a little Excel magic to make the chart look and function like a proper Gantt chart. We’ll add our duration data, reorder the tasks, and then make the starting "Start Date" bars invisible.

1. Add the Duration Data to the Chart

Next, we need to add the calculated durations as a second data series to our chart.

1. Right-click anywhere inside the chart area and choose Select Data.
2. In the Select Data Source window that pops up, under Legend Entries (Series), click the Add button.
3. A new Edit Series window will appear.
4. Click OK, and then click OK again on the Select Data Source window.

Your chart will now have two sets of bars for each task: a blue one for the start date and an orange one for the duration.


Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

2. Reverse the Task Order

You’ll notice that Excel has listed your tasks in reverse order, with the last task at the top and the first task at the bottom. Let's fix that.

1. Click on the list of tasks on the vertical axis (the Y-axis) to select it.
2. Right-click and choose Format Axis.
3. In the Format Axis pane that appears on the right, find the Axis Options section.
4. Check the box that says Categories in reverse order.

Your tasks will now appear in the correct, top-to-bottom sequence.

3. Make the Start Date Bars Invisible

This is the final touch that creates the Gantt chart effect. We want to hide the blue bars (the "Start Date" series) so that only the orange "Duration" bars are visible, making them appear to "float" along the timeline.

1. Click on any of the blue bars in your chart to select the entire Start Date data series.
2. Right-click and select Format Data Series.
3. In the Format Data Series pane, go to the Fill & Line tab (the paint bucket icon).
4. Under Fill, select No fill.
5. Under Border, select No line.

The blue bars have now disappeared, leaving you with a clean Gantt chart!


Formatting the Timeline for a Weekly View

The final step is to adjust the horizontal axis (the X-axis) so it clearly shows weekly intervals. This involves telling Excel how to frame the dates and what units to use for the gridlines.

Excel handles dates as sequential serial numbers, which allows us to set the start and end of our timeline numerically. First, let's find the numbers for our project's start and end dates.

• Click on your project's earliest start date cell. In the Home tab, change the cell format from Date to Number. Write this number down. Let’s say it's 45311 for February 1, 2024.
• Do the same for your project's latest end date cell. Let's say it's 45366 for March 17, 2024.
• Once you have a note of these numbers, you can change the cell formats back to Date.

Now, let's apply this to the chart:

1. Click on the dates along the horizontal axis at the top of your chart.
2. Right-click and choose Format Axis.
3. In the Format Axis pane, under Axis Options, you'll see a section for Bounds.
4. Next, look for the Units section. This is where we define the weekly view.

Hit Enter. The timeline will immediately adjust, giving you a perfect weekly view of your project schedule.

You can also give your chart a title by clicking "Chart Title" and typing something descriptive, like "Weekly Marketing Campaign Plan."

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Excel Gantt Chart Templates: A Faster Alternative

Building a Gantt chart from scratch is a great way to understand how Excel works, but if you're short on time, templates are a fantastic shortcut. Excel has several built-in Gantt chart templates ready to go.

To access them, simply go to File > New and type "Gantt" into the search bar. You'll find several options that you can open and customize with your own project data, saving you the initial setup time.

Final Thoughts

Building a weekly Gantt chart in Excel involves organizing your data, creating a stacked bar chart, and then cleverly formatting it to create a visual project timeline. By adjusting the axis units, you can easily tailor the view to a weekly cadence, giving you and your team clear direction and oversight for any project.

While Excel is great for building things by hand, reporting on sales or marketing projects often requires pulling data from many different sources like Google Analytics, Shopify, Salesforce, or your ad platforms. To make this easier, we built Graphed. It connects to all your data sources and automates your reporting in seconds. You can just ask for "a sales pipeline report from Salesforce formatted by week for this quarter" in plain English, and Graphed builds a live dashboard for you, freeing you from manual spreadsheet work for good.