How to Display All Weeks in Excel Gantt Chart

Creating a Gantt chart in Excel is great for managing projects, but getting the timeline to look right can be surprisingly frustrating. One of the most common challenges is shifting the view from daily to weekly intervals to better track progress over several months. This guide will show you exactly how to build a flexible Gantt chart in Excel and configure the timeline to clearly display all the weeks in your project.

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

Setting Up Your Project Data for an Excel Gantt Chart

Before building the chart, you need a well-organized data table. Your chart will pull directly from this table, so having the right columns from the start makes everything easier. For a standard Gantt chart, you only need three key pieces of information for each task.

Set up a simple table with these three columns:

• Task: The name of each task in your project.
• Start Date: The date each task is scheduled to begin.
• Duration: The number of days the task will take to complete.

If you have an "End Date" column instead of "Duration," you can calculate the duration easily. Just subtract the start date from the end date. For example, if your End Date is in column C and your Start Date is in column B, the formula would be:

=C2-B2

With this simple structure in place, you’re ready to start building the visual part of the Gantt chart.

Step-by-Step: Creating a Basic Gantt Chart

We're going to use a clever trick with a Stacked Bar Chart to create the Gantt chart effect. This method involves displaying two sets of data - the start date and the duration - and then hiding the first one to create the floating bars of a Gantt chart.

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

Step 1: Insert a Stacked Bar Chart

First, insert a blank chart into your worksheet. Don't select your data yet, we will add it manually to ensure it’s set up correctly.

1. Click on any empty cell in your spreadsheet.
2. Go to the Insert tab on the ribbon.
3. Find the Charts group and click the icon for Insert Column or Bar Chart.
4. From the dropdown menu, select Stacked Bar under the 2-D Bar section.

You’ll now have a blank white box on your sheet. This is your chart canvas.

Step 2: Add Your Project Data to the Chart

Now, we need to tell your blank chart which data to use.

1. Right-click on the blank chart and choose Select Data… from the menu.
2. The "Select Data Source" window will open. In the left-hand box labeled Legend Entries (Series), click the Add button.
3. A smaller "Edit Series" window will pop up. For the Series name, click the cell that contains your "Start Date" header. For the Series values, delete what's there and select all the actual start dates in your table. Click OK.
4. Back in the "Select Data Source" window, click Add again to add your second data series.
5. For this new series, select the "Duration" header for the Series name. Then, select all of your duration values for the Series values field. Click OK.
6. Finally, on the right side under Horizontal (Category) Axis Labels, click the Edit button. Select your entire range of task names (e.g., A2:A8). Click OK.

Your "Select Data Source" window should now correctly list your data ranges. Click OK to close it. You'll see a stacked bar chart with blue bars representing start dates and orange representing durations.

Step 3: Format the Chart to Look Like a Gantt Chart

Now for the trick. We need to make the "Start Date" bars (the blue parts) invisible, leaving only the "Duration" bars floating, just like a real Gantt chart.

1. Click on any of the blue bars in your chart. This will select the entire "Start Date" data series.
2. Right-click on one of the selected blue bars and choose Format Data Series….
3. In the formatting pane that appears on the right, click on the paint bucket icon for Fill & Line.
4. Under the "Fill" section, select No fill.

The blue bars will disappear, and you’ll be left with orange bars that seem to start at the right time. The last formatting touch is to reverse the task order. Excel plots the first task at the bottom, but we want it at the top.

• Click on the vertical axis (where your task names are).
• Right-click and select Format Axis….
• In the "Axis Options" section of the format pane, check the box for Categories in reverse order.

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

Formatting the Timeline to Display Weeks

With the basic chart structure in place, you can now format the horizontal axis to display weekly increments instead of random dates. This involves setting the start and end points of your timeline and defining the interval between gridlines.

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

Step 1: Understand How Excel Handles Dates

Before you adjust the axis, it’s helpful to know that Excel stores all dates as serial numbers. For example, January 1, 1900, is stored as the number 1, January 2, 1900, is 2, and so on. Understanding this makes it clear why we need to provide numeric values for our timeline's start and end points.

To find the serial number for any date, simply type the date into a cell, then change that cell’s format from "Date" to "General" or "Number".

Step 2: Set the Timeline's Start and End Dates

First, we’ll define the boundaries of your project’s timeline. This prevents Excel from displaying unnecessary future or past dates.

1. Find the earliest start date and the latest end date in your project. In a scratchpad area of your sheet, type these two dates into cells.
2. Convert these two dates to their serial numbers by changing the cell format to General. Jot them down or keep the cells handy.
3. Now, click on the horizontal axis (the dates at the top) of your Gantt chart.
4. Right-click and choose Format Axis….
5. The Format Axis pane will open. Under "Bounds," enter the serial number for your project’s start date into the Minimum field. Enter the serial number for your project’s end date into the Maximum field.

Your timeline will immediately rescale to fit the exact duration of your project.

Step 3: Set the Axis Units to Weekly Intervals

This is the most important step for displaying your timeline in weeks. By default, Excel chooses the date units for you. We’re going to manually set it to 7-day increments.

1. With the horizontal axis still selected, look for the "Units" section in the Format Axis pane.
2. In the box next to Major, type 7.

That's it! Excel will now place a major gridline and date label on your chart every 7 days. This creates a clear weekly structure for your timeline, making it easy to gauge progress week by week.

Step 4: Improve Date Readability

Your chart's gridlines are now set to weeks, but the axis labels might look like long, clunky dates. Let's fix that.

• In the Format Axis pane, scroll down until you see the Number section.
• Change the Category dropdown to "Date", and then choose a concise format like m/d (e.g., 3/14) from the Type list.
• Alternatively, you can create a custom format. To show just the day and month abbreviation, use this custom format code: d-mmm.

Bonus Tips for a Polished Gantt Chart

Your chart is functional, but a few final touches can make it significantly more professional and easier to read.

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

Color-Code Your Project Phases

If your project has distinct phases (e.g., Planning, Development, Launch), use color to make them stand out. To color an individual bar, you need to click it twice. The first click selects the entire data series (all the bars). The second click selects only that specific bar. Once it's selected, you can use the Format tab or the right-click menu to change its fill color.

Add a Clear Title and Remove the Legend

Give your chart an informative title like "Q3 Product Launch Timeline." You can also delete the legend, as the colored bars are self-explanatory. Simply click on the legend box and press the Delete key.

Reduce the Gap Between Bars

To make the bars thicker and more substantial, right-click any bar, choose Format Data Series…, and in the "Series Options" section, decrease the Gap Width. A value around 50% usually looks good.

Final Thoughts

Building a Gantt chart in Excel and setting it to a weekly view is entirely achievable with the right steps. By leveraging a stacked bar chart and carefully formatting the horizontal axis to use 7-day increments, you can create a functional and clear project timeline that helps everyone track progress week by week.

While Excel is capable, the process of creating and maintaining these charts can feel clunky, requiring manual updates every time a deadline shifts. For those who need to get answers from their data without the manual setup, we built Graphed. You can connect all your data sources and create real-time dashboards just by asking questions. Instead of fighting with axis settings, you could simply ask, "create an e-commerce dashboard showing revenue vs ad spend from Shopify and Facebook Ads," and get back to making decisions.