How to Make a Project Plan Gantt Chart in Excel

A Gantt chart is one of the most effective ways to visualize a project timeline, but you don't need fancy, expensive software to create one. You can build a surprisingly powerful and professional-looking Gantt chart right within Microsoft Excel. This article will walk you through a detailed, step-by-step process for making a Gantt chart from scratch, and also show you the quick-and-easy template method.

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?

At its core, a Gantt chart is simply a horizontal bar chart that visually represents a project schedule over time. It’s a project manager’s best friend because it transforms a flat list of tasks and deadlines into an easy-to-understand timeline. This makes it instantly clear who is doing what, when it starts, when it ends, and how the entire project fits together.

A typical Gantt chart has two main parts:

• A vertical task list: Down the left side, you'll see a list of all the individual tasks that need to be completed for the project.
• A horizontal timeline: Across the top, you'll see a timeline broken down into units like days, weeks, or months.

Within the chart, each task is represented by a horizontal bar. The position and length of the bar show the task's start date, end date, and overall duration. A quick glance tells you the project’s entire scope, current status, and any potential overlaps or roadblocks.

Why Use Excel for Your Gantt Chart?

While dedicated applications like Microsoft Project or Asana have more advanced features, Excel is often the perfect tool for the job, especially for small to medium-sized projects. Here’s why:

• It's Accessible: Almost every business professional has access to Excel. There’s no new software to purchase, install, or get budget approval for.
• It’s Flexible: You have complete control over the formatting. You can change colors, add columns for extra information (like task owner or budget), and tailor the look and feel to match your company's branding.
• It’s Great for Getting Started: If you're new to project management, building a chart in a familiar program like Excel is far less intimidating than learning a complex new tool from scratch.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 1: Creating a Gantt Chart From Scratch in Excel

Building your own Gantt chart might seem complicated, but it's really just a cleverly formatted stacked bar chart. Follow these steps carefully, and you'll have a custom chart in minutes.

Step 1: Set Up Your Project Data

First, open a blank Excel sheet and structure your project information. You need at least four columns:

• Task Name: A brief description of the task (e.g., "Draft Blog Post," "Design Graphics").
• Start Date: The date the task is scheduled to begin.
• End Date: The date the task is scheduled to be completed.
• Duration: The total number of days the task will take.

Enter your tasks and their start and end dates. To calculate the duration automatically, click into the first cell of the "Duration" column (D2 in our example) and enter a simple formula. If your End Date is in column C and Start Date is in column B, the formula is:

=C2-B2+1

We add "+1" because if a task starts and ends on the same day, we want the duration to be 1 day, not 0. Drag the fill handle (the small square at the bottom-right of the cell) down to apply this formula to all your tasks. Your data should look something like this:

Example Project Data:

Step 2: Insert a Stacked Bar Chart

Now we’ll create the chart that will eventually become our Gantt chart.

1. Select your list of task names (just the names, not the header).
2. While holding the Ctrl key (or Cmd on a Mac), select all of the data in your Start Date column.
3. With both columns selected, go to the Insert tab on the Ribbon.
4. In the Charts group, click Insert Column or Bar Chart > 2-D Bar > Stacked Bar.

You should now have a basic bar chart on your sheet. Don't worry about how it looks yet, we're about to transform it.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Add the Duration Data to Your Chart

Next, we need to add the task durations to the chart. This will create the bars that represent each task’s timeline.

1. Right-click anywhere inside the chart area and choose Select Data.
2. In the "Select Data Source" window, under "Legend Entries (Series)," click the Add button.
3. An "Edit Series" window will pop up.
4. Click OK twice to close the windows.

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.

Step 4: Format it to Look Like a Gantt Chart

This is where the magic happens. We’ll tweak the chart formatting to make it look and function like a real Gantt chart.

Reverse the Task Order

1. Click on the vertical axis (where the task names are listed) to select it.
2. Right-click and choose Format Axis.
3. In the Format Axis pane that appears, under Axis Options, find and check the box that says Categories in reverse order.

Make the "Start Date" Bars Invisible

To create the floating bar effect of a Gantt chart, we hide the first set of bars (the blue ones) that represent the start dates.

1. Click on any of the blue bars in your chart to select the entire "Start Date" series.
2. Right-click and choose 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.

The blue bars will disappear, leaving only the duration bars "floating" in their correct timeline positions.

Adjust the Horizontal Timeline

Finally, we need to tighten up the start of the horizontal date axis so there isn’t a huge empty space before your first task bar.

1. Click on the horizontal axis (the dates at the top of the chart) to select it.
2. Right-click and choose Format Axis.
3. In the Format Axis pane, look for the Bounds section under Axis Options. Here you can set the Minimum and Maximum dates shown.
4. Enter that number into the Minimum bound field. Press Enter, and your chart will immediately update to cut out the empty space.

And that’s it! You've successfully built a Gantt chart. You can now resize it, give it a title, and change the bar colors to match your preferences.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 2: Using an Excel Gantt Chart Template

If you need a Gantt chart in a hurry, or if the "from scratch" method feels daunting, using a pre-built template is an excellent alternative.

1. Open Excel and go to File > New.
2. In the search box that says "Search for online templates," type "Gantt chart" and press Enter.
3. Excel will show you several options. Look for one named "Simple Gantt Chart" or something similar and click on it.
4. Click the Create button.

Excel will instantly generate a new workbook complete with a perfectly formatted Gantt chart and a corresponding data table. All you need to do is replace the placeholder content with your own project's tasks, dates, and durations. The chart will update automatically as you type.

Pro Tips for a More Effective Gantt Chart

Building the chart is just the first step. Here are a few tips to make it a more powerful tool for managing your project.

• Keep it Simple and Readable: Avoid overloading the chart with dozens of minor sub-tasks. Focus on the main project phases and key deliverables.
• Add Milestones: To highlight important deadlines or project gateways, add them as tasks with a duration of 1 day. You can then color these bars differently (e.g., bright yellow) so they stand out as milestones.
• Track Progress: Add another column to your data titled "% Complete." As you work on tasks, fill in the progress (e.g., 25%, 50%, 100%). You can use this data with conditional formatting to create even more advanced visual trackers.
• Update it Regularly: A Gantt chart is a living document. Make sure to update it weekly, or whenever project timelines shift, to ensure it remains a reliable source of truth.

Final Thoughts

Whether you build one from the ground up or leverage a pre-built template, Excel stands as a powerful and accessible tool for creating a clear project timeline. These charts are invaluable for keeping stakeholders informed, teams aligned, and projects on track from start to finish.

While an Excel Gantt chart is perfect for planning a single project, managing real-time reporting across all your different team platforms - from analytics tools to sales and marketing apps - can be challenging. At Graphed, we streamline this entire process for you. By plugging your data sources into Graphed, you can build dashboards and get insights just by asking questions in plain English. This frees up your time to focus on what the data means for your strategy, instead of spending hours manually piecing it all together.