How to Create a Gantt Chart in Excel with Dates

Building a Gantt chart to manage your project timeline doesn’t require expensive, specialized software. You can create a surprisingly powerful and clear Gantt chart right within Excel using a simple stacked bar chart and a little bit of formatting. This guide will walk you through setting up your project data and transforming it into a professional Gantt chart, step-by-step.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is a Gantt Chart, Anyway?

A Gantt chart is a type of bar chart that visually illustrates a project schedule. It’s one of the most popular and useful tools for project managers because it turns a list of tasks and dates into an easy-to-understand timeline. At a glance, you can see what needs to be done, who is responsible, when each task begins and ends, and how tasks overlap.

The main components are:

• Tasks: The individual activities or steps that make up the project. These are usually listed on the vertical axis.
• Timeline: The total duration of the project, displayed on the horizontal axis in days, weeks, or months.
• Task Bars: Horizontal bars that represent each task. The length and position of the bar correspond to the task's start date, end date, and duration.

In short, it’s a visual map of your project, making it much easier to track progress, spot potential delays, and keep everyone on the same page.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Set Up Your Project Data

Before you can make a chart, you need to organize your project data in a table. The structure of this table is the foundation for your Gantt chart, so getting it right is the most important step. Open a new Excel sheet and create columns for the key pieces of project information.

You’ll need at least three core columns:

• Task Name: A brief description of the task. (e.g., "Phase 1: Research")
• Start Date: The date the task is scheduled to begin.
• End Date: The date the task is scheduled to be completed.

While not strictly necessary to start, adding a Duration column will make the process easier and the chart more intuitive. This column will calculate the number of days each task will take.

Here’s an example of how your table should look:

Calculating Duration

Instead of manually counting the days for each task, you can have Excel do the work for you. In the "Duration" column (column D in our example), enter the following formula in the first cell (D2):

=C2-B2+1

Let's break that down:

• C2-B2 subtracts the start date from the end date to find the timespan.
• +1 is added because if a task starts and ends on the same day, you want the duration to be 1 day, not 0.

After entering the formula, click the small square (the fill handle) at the bottom-right corner of the cell and drag it down to apply the formula to the rest of your tasks.

Step 2: Insert a Stacked Bar Chart

Now that your data is organized, it's time to create the basic chart that we'll transform into a Gantt chart. We’ll be using a Stacked Bar chart.

1. Click on an empty cell. This is important to ensure Excel doesn't try to guess what data you want to plot.
2. Go to the Insert tab in the ribbon.
3. In the Charts section, click the Insert Column or Bar Chart icon.
4. From the dropdown menu, under the 2-D Bar section, select Stacked Bar.

You will now have a blank white chart area on your worksheet. Don't worry, we're about to add data to it.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Add Your Data to the Chart

This is where we tell Excel which pieces of our table to visualize. It can seem a bit intimidating at first, but just follow these steps carefully.

1. Right-click on the blank chart area and choose Select Data... from the context menu.
2. In the Select Data Source window, under the Legend Entries (Series) box on the left, click the Add button.
3. An Edit Series dialog box will appear. Here’s how you'll fill it out for the first data series, which is the Start Date:
4. You'll be back in the Select Data Source window. Now, let’s add the Duration data. Click the Add button again.
5. In the Edit Series box, add the second data series:
6. Finally, we need to add the task names to the vertical axis. Back in the Select Data Source window, look at the Horizontal (Category) Axis Labels box on the right side. Click the Edit button.
7. In the Axis Labels window that pops up, click and drag to select your list of task names (e.g., cells A2 through A6). Click OK.
8. Your Select Data Source window should now display "Start Date" and "Duration" in the left box and show the range for your task names in the right box. Click OK to close it.

You should now have a colored stacked bar chart. It doesn't look like a Gantt chart yet, but you're on the right track! The blue bars represent the start date (as empty time from the project's start), and the orange bars represent the duration of each task.

Step 4: Format the Chart into a Gantt Chart

This is the magic step where we make the chart actually look like a Gantt chart. We're going to make the "Start Date" portion of each bar invisible, leaving only the "Duration" bars floating, which creates the classic Gantt chart look.

1. Click on any of the blue bars in your chart (the ones representing the Start Date). This will select all of them.
2. Right-click on one of the selected blue bars and choose Format Data Series... from the menu.
3. A formatting pane will open on the right side of your Excel window.
4. Click on the Fill & Line icon (it looks like a paint bucket).
5. Under the Fill section, select No fill.
6. Under the Border section, select No line.

The blue bars will vanish, leaving just your duration bars hanging on the timeline. It’s starting to look like a Gantt chart!

Step 5: Tweak the Formatting for Readability

You’re almost there, but there are a few final adjustments needed to make your Gantt chart professional and easy to read.

Reverse the Task Order

You'll probably notice that your tasks are listed in the reverse order of your table (e.g., "Project Launch" is at the top). It's an odd Excel quirk, but it’s an easy fix.

1. Click on the list of tasks on the vertical axis (the Category Axis) to select it.
2. Right-click and choose Format Axis...
3. In the Format Axis pane on the right, under Axis Options, check the box for Categories in reverse order.

Your tasks will now appear in the correct, logical order.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Adjust the Timeline (Horizontal Axis)

Your timeline on the horizontal axis might have a lot of empty space at the beginning before your project's first task. Let's clean that up so the chart starts closer to your project's kickoff date.

1. Click on the dates along the top of your chart (the Horizontal Axis) to select them.
2. Right-click and choose Format Axis...
3. In the Format Axis pane, under Axis Options, you'll see a section for Bounds.
4. The Minimum bound is what we need to change. To do this, find the very first start date of your project (in our example, it's 10/1/2024). Click on the table cell containing this date. Now, go to the Home tab and in the Number section, change the format from "Date" to "General" or "Number". You'll see a number like 45565. This is Excel’s serial number for that date. Make a note of this number and then change the cell format back to Date.
5. Go back to the Format Axis pane and type that number (e.g., 45565) into the Minimum bound box and press Enter. The horizontal axis will immediately adjust, removing the unnecessary white space at the beginning.

Final Touches

• Add a Title: Click on "Chart Title" at the top and give your chart a descriptive name, like "Project Marketing Plan Q4 2024".
• Remove the Legend: The chart now has a legend for "Duration" and "Start Date." Since the Start Date bars are invisible, the legend is no longer needed. Click on the legend and press the Delete key to remove it.
• Adjust Colors: If you don’t like the default orange, right-click on the task bars, go to Format Data Series > Fill & Line, and choose a new color that fits your report.

Final Thoughts

Creating a Gantt chart in Excel from scratch gives you full control over visualizing your project timeline without relying on rigid templates. By arranging your tasks, dates, and durations into a simple table and transforming a stacked bar chart, you can build a clear and effective project management tool exactly suited to your needs.

Once you’ve built your first chart, the process becomes much faster. However, as projects grow, constantly downloading CSVs, wrangling dates, and manually updating charts in spreadsheets can become a tedious chore. At Graphed, we automate this data-wrangling process. Instead of spending your time pulling and formatting data, you can connect your sources directly to us and create real-time, interactive dashboards just by asking questions in plain English. This allows you to spend less time building reports and more time acting on the insights they provide.