How to Create a Gantt Chart in Excel (Step-by-Step Guide + Practice Files)

• 🛠️ Core Build
• 1️⃣ Data Table
• 📊 Stacked Bar
• ✨ Axis Inversion
• 📅 Date Bounds
• 📈 Progress Split
• ⚖️ Chart vs Formula
• ⚡ Special Scenarios
• ⭐ Best Practices
• 🔧 Troubleshooting
• ⬇ Practice File
• ❓ FAQs
• 💬 Comments

A Gantt chart is one of the most effective tools for project scheduling, workload planning, and milestone tracking. It turns a static list of tasks into an interactive horizontal bar timeline, allowing project managers and teams to visualize start dates, durations, task dependencies, and deadlines at a glance.

If you have wondered “can you create a Gantt chart in Excel without buying expensive add-ins?”—the answer is yes. While Microsoft Excel has no single “Insert Gantt Chart” button, you can easily make a Gantt chart in Excel using a standard Stacked Bar Chart and a simple formatting trick: making the baseline start-date series invisible. This step-by-step tutorial covers how to build, format, and customize a professional project timeline from a blank spreadsheet.

How to Make a Gantt Chart in Excel Step by Step

Building a custom project timeline breaks down into two core phases: structuring clean project dates, and converting a stacked bar chart into an executive-ready schedule.

The completed Excel Gantt chart with floating duration bars, date bounds, and progress split

• Prepare Your Project Data TableSet up three essential columns: Task Name, Start Date, and Duration in days.
• Populate Dates, Owners, and ProgressInput your real tasks, owners, and completion percentages.
• Insert a Blank 2D Stacked Bar ChartStart from a blank chart canvas to maintain full control over series assignments.
• Add the Task Duration SeriesThe duration series forms the visible horizontal timeline bars.
• Reverse Category Order & Hide Start BarsInvert the vertical axis so tasks read top-to-bottom, and set the start date series to “No Fill”.
• Fix the Date Axis BoundsConvert calendar dates to serial numbers to remove the empty space before your first task.
• Widen Bars & Clean Chart ClutterDelete the redundant legend, adjust Gap Width to 30–40%, and enable vertical gridlines.
• Show Percent Complete Progress BarsSplit duration into Days Complete and Days Remaining to display status on the timeline.
• Handle Special Cases & Advanced ScenariosManage dependencies, subtasks, week/month scales, and timelines without dates.

Step 1: Set Up and Prepare Your Project Data Table

To create a Gantt chart from Excel, your worksheet requires three primary data columns:

• Task Name: Clear descriptions of deliverables or phases.
• Start Date: The calendar date on which work begins.
• Duration: The active work span in days.

How to Make a Gantt Chart in Excel with Start and End Dates (Two Dates)

Most project managers prefer tracking schedules using two dates (Start Date and End Date). However, Excel’s stacked bar chart plots task length (duration) rather than a fixed finish date. To calculate Duration automatically, add a calculated column:

= [@[End Date]] - [@[Start Date]] + 1

The + 1 ensures the initial start day is included. For example, a task starting on Monday morning and ending Friday afternoon spans 5 full days, not 4. Omitting this makes every bar display one day short.

To skip weekends and calculate business working days only, use the NETWORKDAYS function:

= NETWORKDAYS([@[Start Date]], [@[End Date]])

To skip statutory holidays as well, supply an optional holiday calendar range: =NETWORKDAYS([@[Start Date]], [@[End Date]], Holidays_List).

Here is the sample 10-task schedule used throughout this tutorial:

Standardized Gantt data table in Excel with formulas calculating duration

Step 2: Add Subtasks, Owners, and Progress Percentages

You can include tracking columns such as Phase/Subtask, Owner, Percent Complete, and Status alongside your core date columns. Excel plots only the specific columns you bind to the chart engine, leaving the remaining fields available for project management.

Step 3: Insert a Blank 2D Stacked Bar Chart

To avoid Excel incorrectly guessing how to plot your table columns, insert an empty chart first:

1. Click any blank cell outside your data table.
2. In the ribbon, go to Insert > Charts > Bar Chart > 2-D Stacked Bar. An empty white box will appear on the sheet.
3. Right-click inside the blank box and click Select Data.
4. Under Legend Entries (Series), click Add:
   • Series name: Click cell Start Date (table header).
   • Series values: Select the range of start dates (exclude header).
5. Under Horizontal (Category) Axis Labels on the right, click Edit:
   • Select the 10 task names.
6. Click OK.

Step 4: Add the Task Duration Series

Next, add the second data series that forms the visible timeline bars:

1. Right-click the chart and choose Select Data.
2. Under Legend Entries, click Add.
3. Series name: Click the Duration header cell.
4. Series values: Select the 10 duration numbers.
5. Click OK.

Step 5: Reverse the Task Order & Hide Start Date Bars

This formatting step converts the stacked bar chart into an authentic Gantt chart:

1. Reverse Task Order: Right-click the vertical task name axis, click Format Axis, open Axis Options, and check Categories in reverse order. Excel plots categories bottom-up by default; this reverses the order so Task 1 sits at the top.
2. Make the Baseline Spacer Bars Invisible: Click any of the start-date bars (the left-hand bars anchored to the axis). Right-click and select Format Data Series. Set Fill to No Fill and Border to No Line.

The start-date bars remain in the worksheet to offset each task along the timeline, but their transparent fill gives the appearance of floating schedule bars.

Step 6: Fix the Date Axis Bounds (Remove Empty Blank Space)

Because Excel defaults its horizontal date axis to day 0 (representing January 1, 1900), the chart will show a wide empty gap before your first task. To align the timeline with your actual schedule, set custom axis bounds using Excel date serial numbers:

1. In a blank worksheet cell, type your project start date (2026-09-01).
2. Change that cell’s format to General. Excel reveals its internal 5-digit date serial number (e.g., 46266). Copy this number.
3. In another cell, calculate the project finish boundary: =MAX(End_Dates) + 1. Convert it to General and note the serial number.
4. Right-click the horizontal date axis at the top of the chart and select Format Axis.
5. Under Bounds, set Minimum to your start date serial number, and Maximum to your finish date serial number.

Step 7: Delete the Legend and Widen Timeline Bars

To finalize the presentation:

• Delete the Legend: Click the legend block and press Delete. Because the start date series is invisible, the legend is unnecessary.
• Widen the Bars: Right-click any visible timeline bar and choose Format Data Series. Reduce Gap Width from 150% down to 30% – 40%. This thickens the bars for improved visual readability.
• Enable Vertical Gridlines: Click the chart, select the + (Chart Elements) button, and check Gridlines > Primary Major Vertical so task end dates align clearly with calendar headers.

Step 8: Show Percent Complete with Split Progress Bars

To show progress directly on each bar, divide the Duration series into two distinct stacked segments: Days Complete and Days Remaining.

Add two calculated helper columns to your table:

Days Complete = [@[Duration]] * [@[Progress %]]
Remaining     = [@[Duration]] - [@[Days Complete]]

To update the chart:

1. Right-click the chart and choose Select Data.
2. Highlight the existing Duration series and click Remove.
3. Click Add: Series name = Days Complete; Series values = column data.
4. Click Add: Series name = Remaining; Series values = column data.
5. Confirm the top-to-bottom series order: Start Date → Days Complete → Remaining.
6. Click OK. Format the Days Complete segment with a darker fill (e.g., solid green or navy), and the Remaining segment with a softer, muted tint.

Stacked Bar Chart vs. Conditional Formatting Timeline

There are two distinct ways to build an Excel Gantt chart:

To build a Gantt timeline with conditional formatting:

1. List tasks down column A, start dates in column B, and end dates in column C.
2. Create calendar date headers across row 4 (e.g., cell D4 = 2026-09-01, E4 = =D4+1).
3. Select your timeline grid (D5:Z14) and navigate to Home > Conditional Formatting > New Rule.
4. Select Use a formula to determine which cells to format and enter:

=AND(D$4>=$B5, D$4<=$C5)

Apply a background fill color. As dates are entered or modified, grid cells highlight automatically to form a dynamic timeline.

Special Cases & Advanced Scenarios

Best Practices for Building and Managing Excel Gantt Charts

To ensure your Excel project schedule remains maintainable, visually clear, and resilient to ongoing date revisions, follow these six professional guidelines:

Step 9: Troubleshooting Common Excel Gantt Chart Problems

Download the Free Excel Gantt Chart Practice File

Download the practice workbook containing the 10-task schedule, calculated progress formulas, dynamic date-axis bounds, and the formatted Gantt chart:

Download: Gantt Chart Excel Practice File (.xlsx)

Excel Gantt Chart Solutions & Advanced Techniques

Quick answers and practical formula solutions for common Excel project scheduling, automation, and design questions.

Frequently Asked Questions About Excel Gantt Charts

Have questions about setting date boundaries or configuring progress formulas? Leave a note below in the comments.