How to Create a Gantt in Excel

Gantt charts often look intimidating and reserved for hardcore project managers, but you can build a clean, effective one right inside Excel. If you have a simple list of tasks and dates, you can transform it into a professional project timeline that provides a clear visual overview of your entire schedule. This tutorial will walk you through creating a dynamic Gantt chart using a clever stacked bar chart method and will also cover a few advanced tricks to make it even more powerful.

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 Exactly is a Gantt Chart?

Before building one, let's quickly recap what a Gantt chart is and why it's so useful. At its core, a Gantt chart is a type of bar chart that illustrates a project schedule over time. It visually represents critical information in a way that’s easy to understand at a glance:

• What the tasks are: The individual to-do items listed vertically.
• When tasks start and end: The position and length of the horizontal bars show the lifespan of each task.
• Task overlaps and dependencies: You can immediately see which tasks are happening simultaneously and which must be finished before others begin.
• Overall project timeline: It shows the entire project from start to finish in one compact view.

In short, it turns a chaotic list of deadlines into a clear, organized roadmap. It’s perfect for managing marketing campaigns, product launches, content calendars, or any multi-step project where timing is crucial.

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: Set Up Your Project Data in a Table

The foundation of a good Gantt chart is a well-organized data table. You don’t need anything complicated, just a few essential columns to get started. Open a blank Excel sheet and create a table with the following headers.

The Essential Columns

For our Gantt chart to work, your table must include these four columns:

1. Task Name: A brief description of the task (e.g., "Draft Blog Post," "Design Graphics," "Schedule Social Media"). List these in chronological order if possible.
2. Start Date: The date the task is scheduled to begin.
3. End Date: The date the task is scheduled to be completed.
4. Duration (in days): This is the number of days the task will take. You can calculate this automatically to avoid manual counting and errors.

Here’s what your initial data table might look like:

(Example Data Table)

How to Automatically Calculate Duration

Manually calculating duration is tedious. Instead, use a simple formula. In the first cell of your "Duration" column (e.g., cell D2), type:

=C2-B2+1

Drag this formula down for all your tasks. We add +1 because the calculation needs to count the start date itself as part of the total duration. Before moving on, make sure your Start Date and End Date columns are formatted as "Date" in Excel, and Duration is formatted as "Number."

Step 2: Create a Stacked Bar Chart

Now for the fun part. We're going to create a bar chart which will serve as the skeleton for our Gantt chart.

1. Select Your Data: Click on the first task in your "Task Name" column, hold down the Ctrl key (or Cmd on a Mac), and select all the dates in your "Start Date" column. By using Ctrl, you can select non-contiguous columns.
2. Insert the Chart: Go to the Insert tab on the Ribbon. In the Charts section, click "Insert Column or Bar Chart," and under the "2-D Bar" section, choose Stacked Bar.

Excel will drop a chart onto your worksheet. Don't worry if it looks nothing like a Gantt chart yet - that’s normal. It's just a stack of blue bars that are all the same length. We're about to fix that.

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 3: Add the Task Durations to the Chart

Next, we need to add our "Duration" data, which will give our task bars their correct lengths.

1. Right-click anywhere inside the chart area and choose Select Data….
2. In the "Select Data Source" window that appears, under "Legend Entries (Series)," click the Add button.
3. A new "Edit Series" window will pop up. For the Series name: field, click into your header cell for "Duration" (e.g., cell D1).
4. For the Series values: field, delete the default text, then click and drag to select all the numerical data in your "Duration" column (e.g., D2 through D6).
5. Click OK on this window and then OK again on the "Select Data Source" window.

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

Step 4: Transform the Stacked Bar into a Real Gantt Chart

This is where the magic happens. We’ll make the "Start Date" portion of the bars invisible, leaving only the "Duration" bars visible and creating the illusion of a floating timeline.

Make the "Start Date" Bars Invisible

1. Click on any of the blue bars in your chart. This will select all the bars in that data series (the ones representing the Start Dates).
2. Right-click on one of the selected blue bars and choose Format Data Series….
3. A formatting pane will open on the right side of your screen. Click on the paint bucket icon (Fill & Line).
4. For Fill, select No fill.
5. For Border, select No line.

Poof! The blue bars disappear, leaving the orange "Duration" bars floating, precisely where they should be on the timeline. We're incredibly close now.

Flip the Task Order

You'll probably notice one annoying thing: your tasks are in reverse order on the chart (the last task is at the top). Let's fix that.

1. Click on the list of task names on the left side of the chart (the vertical axis).
2. Right-click and choose Format Axis….
3. In the "Format Axis" pane, under "Axis Options," look for a checkbox that says Categories in reverse order. Check it.

The tasks will now appear in the correct order, matching your data table.

Step 5: Stylize and Refine Your Gantt Chart

Your chart is functional, but a little bit of cleanup will make it much easier to read and present.

• Remove the Legend: The legend (showing "Start Date" and "Duration") is now irrelevant since one series is invisible. Click on the legend and press Delete.
• Adjust the Timeline Range: The date range on your horizontal axis might start at an odd date or stretch on for too long. To fix this, right-click on the dates and choose Format Axis…. In the "Axis Options" tab, you can set the Minimum and Maximum bounds to better fit your project's start and end dates.
• Add a Chart Title: Give your chart a clear descriptive title like "Q4 Marketing Campaign Timeline."
• Adjust Colors: Click on the bars and use the "Format Data Series" pane to change the fill color to match your company's branding or your own preference.

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

Advanced Trick: Add Progress Bars

Want to take your Gantt chart to the next level? You can add another layer to your bars that visually shows the completion percentage of each task.

1. Add Two New Columns: In your data table, add columns for "Progress %" (where you'll manually input the percentage complete, e.g., 25%, 50%, 100%) and "Completed."
2. Calculate "Completed": In the "Completed" column, use the formula =[Progress %] * [Duration]. This calculates how many days' worth of work is done. So, if a 10-day task is 50% complete, this cell will show "5".
3. Add a New Data Series: Right-click your chart, go to Select Data, and add the "Completed" column as a new series, just like you did with "Duration." It will appear as a third, gray bar on your chart.
4. Change Chart Type for this Series: We want this new series to overlap the original duration bar, not stack next to it.
5. Align the Axes: Now you have two horrifying horizontal axes. We need to make them identical. Format both the primary and secondary horizontal axes so their Minimum and Maximum bounds match exactly. Once they're aligned, you can delete the top axis (the secondary one).
6. Format the Progress Bar: Finally, click on your "Completed" series bars. Right-click and choose Format Data Series…. Under "Series Options," slide the Gap Width down so the progress bar is a bit thicker and sits nicely inside the main duration bar. Change its color to something darker, like a dark green or blue, to show progress.

This adds an incredibly useful at-a-glance status update directly into your timeline without cluttering it up.

Final Thoughts

You now have all the steps needed to turn a simple task list into a clear, professional-looking Gantt chart in Excel. By using the stacked bar chart method and refining the formatting, you can create a powerful project management tool that helps keep your team aligned and on track without needing specialized software.

While Excel is great for building these kinds of reports, the real challenge comes with keeping them updated. Manually refreshing the chart every time a deadline shifts or a new task is added can become its own project. At Graphed, we built our platform to eliminate this exact type of manual work. You can connect your marketing and sales data sources just once and ask for reports or dashboards in plain English. This way, your reports stay up-to-date in real time without you ever having to manipulate a chart in a spreadsheet again.