Guide · 2026-09-11

How to Create an Excel Gantt Chart: A Step-by-Step Guide

Project schedules often become difficult to follow when tasks, dates, owners, and dependencies sit in separate Excel rows. A simple list may show what needs doing, yet it rarely reveals how work overlaps or where delays could affect the finish date.

That confusion grows when a project has dozens of tasks. You may spend more time formatting cells than managing the work itself. A missed date can hide inside a long worksheet until the schedule is already slipping.

Here’s the practical solution: build an Excel Gantt chart with task names, start dates, durations, and a stacked bar chart. I’ll show you each step, explain the formulas, and cover ways to keep the schedule readable as your project changes.

How to Create an Excel Gantt Chart Step by Step

An Excel Gantt chart is a horizontal timeline that represents each task with a bar showing when the task starts, how long it lasts, and when it finishes. You create one by combining a task table with a stacked bar chart.

The fastest reliable method uses two chart series: one hidden series for the task’s start position and one visible series for its duration.

Step 1: Set Up the Project Schedule

Open a blank Excel workbook and create these columns:

Enter one task per row. For example, a website launch might include planning, design, development, testing, and launch.

Task Start Date End Date Duration
Project planning 1 April 2025 4 April 2025 4 days
Page design 7 April 2025 16 April 2025 10 days
Development 17 April 2025 30 April 2025 14 days
Testing 1 May 2025 7 May 2025 7 days

Keep the task order logical. You can reverse it later inside the chart so the first task appears at the top.

Step 2: Calculate Each Task’s Duration

In the Duration column, subtract the start date from the end date and add one day if both dates count toward the schedule.

For example, if the start date is in cell B2 and the end date is in cell C2, enter:

=C2-B2+1

The +1 counts the first day. Without it, a task running from Monday through Tuesday would show one day instead of two.

If your schedule measures working days only, use:

=NETWORKDAYS(B2,C2)

For working days that exclude holidays, use a holiday range:

=NETWORKDAYS(B2,C2,$H$2:$H$10)

Place holiday dates in the referenced range. This keeps weekends and listed holidays out of the duration calculation.

Step 3: Select the Start Date and Duration Columns

Select the task names, start dates, and durations. You need the task labels for the vertical axis and the two numeric series for the bars.

If the columns are separated by other fields, hold the Control key on Windows or the Command key on Mac while selecting each range.

Leave the End Date column out of the chart. It helps calculate the schedule, but the chart needs the start position and task length.

Step 4: Insert a Stacked Bar Chart

Choose Insert, open the bar chart menu, and select 2-D Stacked Bar.

Excel will create two segments for each task:

At first, the chart may look like a collection of floating bars with an unwanted colored section. That is expected. The first series creates the horizontal position.

Step 5: Hide the Start Date Series

Click the first series in the chart, then open Format Data Series. Set the fill to No Fill and the border to No Line.

The visible duration bars will now appear to start on their actual dates. The hidden series still controls their position along the timeline.

Choose a clear color for the duration series. Blue, green, or orange can work well, provided the color contrasts with the chart background.

Step 6: Put the First Task at the Top

Excel often displays the last task at the top of a bar chart. To fix that, click the vertical task axis and open Format Axis.

Turn on Categories in reverse order. The first task will move to the top, creating the familiar schedule layout.

You may also need to set the horizontal axis to cross at the maximum category. This keeps the date labels positioned neatly below the chart.

Step 7: Format the Date Axis

Right-click the horizontal axis and choose Format Axis. Adjust the minimum and maximum bounds so the chart begins near the earliest task and ends near the final deadline.

Excel stores dates as serial numbers, so the axis may initially display numbers instead of readable dates. Change the number format to a style such as:

Set the major unit to seven days for weekly planning or one day for short projects. A two-week product sprint may need daily labels, while a six-month rollout usually benefits from monthly labels.

Step 8: Improve Bar Spacing and Labels

Click a visible bar and reduce the Gap Width. A setting between 30% and 60% often produces readable task bars without making them appear crowded.

Add a chart title that names the project and time period. Remove unnecessary chart elements, such as a legend with unclear labels.

For a small schedule, add task labels or end dates. For a large schedule, keep the chart cleaner and rely on the task list beside it.

Step 9: Add Milestones

A milestone usually has zero duration, such as an approval, release, or customer review. Excel may not display a zero-length bar clearly, so use a separate marker.

One practical approach is to create a milestone series with the milestone date and add it to the chart. Change that series to a line with a marker, then choose a diamond or triangle shape.

For a simpler chart, add a vertical line or place a symbol beside the milestone task. This works well when the schedule has only a few key checkpoints.

Step 10: Add Progress Tracking

You can show progress by adding a Percent Complete column. For example, a task that is halfway finished can display a darker overlay covering half of its planned duration.

This approach requires an additional chart series. Calculate completed duration with:

=Duration*Percent Complete

Then format the completed portion with a darker color and leave the remaining duration in a lighter shade.

Use progress tracking carefully. A task can be 80% complete while still threatening the deadline if the remaining work contains a difficult dependency.

How the Excel Gantt Chart Method Works

The chart works because Excel treats each calendar date as a numeric position. The start-date series pushes the visible task bar across the timeline, while the duration series determines its length.

For example, a task beginning on 10 April with a five-day duration receives a starting position tied to 10 April and a visible bar five days long. Hiding the first series makes the bar appear to begin exactly where the task begins.

Here’s why this method remains useful: you can update dates in the task list, and the chart shifts automatically when the formulas and chart ranges are connected correctly.

Calendar Days Versus Working Days

Choose one counting method before building the schedule. Calendar days include weekends, while working days usually exclude Saturdays and Sundays.

Imagine a review task that begins on Friday and ends on Monday. It lasts four calendar days, yet only two working days. Both views can be correct, depending on how your team plans work.

Use calendar days for equipment rentals, service windows, or elapsed time. Use working days for team capacity and task effort.

Dependencies and Date Changes

A basic chart shows timing, but it does not automatically manage every dependency. If development depends on design approval, a delayed approval may require a manual date update.

You can create simple linked formulas. If Task B begins one working day after Task A ends, use a formula such as:

=WORKDAY(C2,1)

Here, C2 represents Task A’s end date. Add a holiday range when necessary:

=WORKDAY(C2,1,$H$2:$H$10)

For complex relationships, such as finish-to-finish or lagged dependencies, manual formulas become harder to maintain. Keep the workbook simple enough for the project team to understand.

Conditional Formatting for Status

Conditional formatting can make schedule changes easier to spot. Apply colors to status cells such as Planned, In Progress, Blocked, and Complete.

You can also highlight overdue tasks with a formula such as:

=AND($C2<TODAY(),$E2<>"Complete")

This example highlights tasks whose end date has passed while the status is not Complete. Adjust the cell references to match your columns.

Ways to Make the Timeline Easier to Read

A chart becomes useful when a person can understand it quickly. Avoid decorating every task with a different color. Reserve special colors for meaning, such as blocked work, critical milestones, or completed tasks.

The best part? Small formatting decisions can make a greater difference than advanced formulas. A weekly axis, consistent date format, and sensible task order often improve clarity immediately.

Use Consistent Task Names

Write task names as clear actions. “Approve homepage design” is easier to interpret than “Homepage.” Action-based labels help people understand responsibility and expected progress.

Keep the names short enough to fit beside the chart. If a task needs more context, place the explanation in a notes column rather than creating a long label.

Group Related Work

Large projects become easier to scan when tasks are grouped under phases such as Planning, Design, Build, Test, and Launch.

You can create blank phase rows with bold formatting, or use a separate Phase column. Avoid giving phase rows confusing duration values unless you want them represented as summary bars.

Mark the Current Date

A vertical “today” line shows whether work is ahead or behind schedule. You can create a helper series containing the current date and add it as a line on a secondary axis.

For a simpler approach, add a cell displaying =TODAY() and use that value when reviewing the chart. A daily refresh keeps the review current without requiring manual date changes.

Keep the Chart Focused

Show the level of detail your audience needs. A project manager may need individual tasks, while an executive review may need only major phases and milestones.

For example, a product launch chart might show “Prepare campaign,” while the working schedule separately tracks copywriting, creative review, and channel setup.

Common Excel Gantt Chart Variations

You can adapt the basic stacked bar method to several planning needs. The right variation depends on whether you care most about deadlines, ownership, progress, or workload.

Simple Deadline Schedule

This version uses Task, Start Date, End Date, and Duration. It works well for personal planning, small events, and short marketing campaigns.

Use it when the team needs a quick timeline without detailed dependency logic.

Team Responsibility Schedule

Add an Owner column and use colors to distinguish responsible people or teams. For example, marketing tasks could be green, engineering tasks blue, and legal reviews purple.

Limit the number of colors. If a project has twelve owners, color by department instead and keep the owner name visible in the task list.

Progress-Based Schedule

Add Percent Complete and create a completed-duration series. This gives stakeholders a quick view of progress against planned work.

Remember that progress percentage should reflect meaningful work completed. A task with finished preparation may still have its most difficult approval remaining.

Critical Path View

Highlight tasks that directly affect the final deadline. You can calculate slack by comparing the latest permitted finish date with the planned finish date.

Use a strong color for critical tasks and a neutral color for flexible work. This directs attention toward schedule risk rather than visual noise.

Natural Excel Gantt Chart Solution: ONES.com

Excel works well for a lightweight timeline. When several people need to update tasks, manage dependencies, discuss requirements, and track progress in one place, ONES.com offers a broader project management environment.

ONES.com product screenshot

ONES.com combines project management and knowledge management through ONES Project and ONES Wiki. ONES Project is a Jira alternative for teams that need structured planning, sprint management, reporting, automation, and configurable workflows.

Core Capabilities

Application Scenarios

A software team might use ONES Project for sprint planning, defect tracking, release coordination, and custom approval stages. The team can still use a timeline view for major releases while managing daily work through tasks and workflows.

An engineering organization with restricted network requirements might choose an On-Premise or Air-gapped deployment. The full feature parity between cloud and self-hosted versions helps the team retain a consistent working model.

A project office could use ONES Project for delivery management and ONES Wiki for knowledge management. The products are sold separately, allowing the organization to choose the combination that matches its needs.

Common Challenges and Practical Solutions

The Chart Shows Numbers Instead of Dates

Problem: Excel displays serial values such as 45748 on the horizontal axis.

Solution: Open Format Axis, choose Number, and apply a date format. Confirm that the chart series uses real Excel dates rather than text that only looks like dates.

The Bars Begin at the Same Position

Problem: Every visible task bar starts at the left edge.

Solution: Confirm that the chart type is Stacked Bar, not Clustered Bar. The start-date series must remain in the chart, even after you make its fill transparent.

The Task Order Looks Backward

Problem: The final task appears at the top.

Solution: Format the vertical axis and enable Categories in reverse order. Check the axis crossing option if the date labels move to an awkward position.

New Tasks Do Not Appear

Problem: You add rows to the schedule, but the chart remains unchanged.

Solution: Convert the task range into an Excel Table before building the chart. New rows are more likely to become part of the connected range automatically.

The Schedule Becomes Difficult to Maintain

Problem: Multiple formulas, helper columns, and custom series make updates risky.

Solution: Keep a clear calculation area, use consistent formulas, and add a short legend for special colors. When the project requires frequent collaboration or advanced workflow control, consider a dedicated project management platform.

FAQs About Building Gantt Charts in Excel

Can I create a Gantt chart in Excel without a template?

Yes. You can build one with a task list, start dates, end dates, duration formulas, and a stacked bar chart. The key step is hiding the start-date series so the duration bars appear at their correct timeline positions. A template can save setup time, yet building the chart yourself helps you understand how to adjust it later.

What formula calculates task duration?

For calendar days, use =EndDate-StartDate+1. For working days, use =NETWORKDAYS(StartDate,EndDate). You can also provide a holiday range to exclude company holidays. Decide whether the project measures elapsed calendar time or working time before entering formulas.

Why does my chart display the wrong task order?

Bar charts often place the final row at the top. Select the vertical axis, open Format Axis, and enable Categories in reverse order. This moves the first task to the top and makes the schedule read naturally from the beginning of the project to the end.

How do I show milestones?

Milestones usually have no duration, so a regular bar may be invisible. Add a separate milestone series with milestone dates, then format it with a marker or diamond. You can also use a vertical line when the chart has only a few major checkpoints.

Can Excel show task dependencies automatically?

Excel can support simple dependency formulas, such as starting one task after another ends. However, complex relationships and frequent schedule changes can become difficult to manage manually. For larger projects, a project management platform can provide clearer dependency handling, workflow states, and progress reporting.

When should I use a project management platform instead?

Excel is a practical choice for a small project with one main editor and limited dependencies. Consider a dedicated platform when multiple people need to update work, tasks require approvals, reporting is frequent, or the schedule changes every week. The decision depends on collaboration needs and workflow complexity.

Conclusion

To create an Excel Gantt chart, prepare task names and dates, calculate duration, insert a stacked bar chart, hide the start-date series, reverse the task order, and format the timeline.

Use calendar-day or working-day formulas consistently. Add milestones, progress indicators, owners, and status colors only when they improve the planning conversation.

But here’s the truth: a chart can reveal schedule pressure, yet it cannot manage every discussion, approval, dependency, or change by itself. For a small project, Excel may be enough. For collaborative delivery, ONES.com can provide a more connected way to manage tasks, workflows, reporting, and project knowledge.