Guide · 2026-10-13

How to Draw a Gantt Chart in Excel: A 7-Step Guide [2026]

Building a project timeline in Excel can look simple until overlapping tasks, missed dependencies, and changing deadlines turn your neat plan into a confusing chart. A poorly built Gantt chart may hide delays instead of revealing them. Even a small mistake in date formatting can make bars appear in the wrong place.

But here's the truth: you can create a clear Gantt chart in Excel with a stacked bar chart, a task list, and seven practical steps. I’ll show you how to set up the schedule, create the visual timeline, format it, and keep it useful as your project changes.

The best part? You do not need advanced Excel skills. Once you understand how start dates and task durations work together, you can build a reliable planning view in minutes.

How to Draw a Gantt Chart in Excel in 7 Steps

A Gantt chart in Excel combines task names, start dates, durations, and a stacked bar chart. The hidden start-date series creates the spacing, while the duration series creates the visible task bars.

Step 1: Create the Project Schedule

Open a blank Excel workbook and create four columns with these headings:

Then add each project activity in its own row. For example, a website launch might include planning, design, development, testing, and launch preparation.

Task Start Date End Date Duration
Project planning June 1, 2026 June 3, 2026 3 days
Page design June 4, 2026 June 10, 2026 7 days
Development June 11, 2026 June 19, 2026 9 days

Keep task names short enough to read along the vertical axis. If one activity includes several distinct deliverables, split it into separate rows. Smaller task units make progress easier to track later.

Step 2: Calculate Each Task’s Duration

The duration shows how long each task lasts. In the first Duration cell, subtract the start date from the end date and add one:

=C2-B2+1

Here, column B contains the start date and column C contains the end date. The +1 counts both the first and last day.

For example, a task running from June 1 through June 3 lasts three calendar days. Without +1, Excel would calculate two days.

Copy the formula down the column. Check the results before creating the chart. A negative number usually means the end date was entered before the start date.

Step 3: Insert a Stacked Bar Chart

Select the Start Date and Duration columns, including their headings. You can hold Ctrl while selecting separate ranges if the Task column sits between them.

Next, choose:

  1. Insert from the Excel ribbon.
  2. Bar Chart.
  3. 2-D Stacked Bar.

Excel will create two horizontal series. The first represents the start-date offset, and the second represents the task duration.

You might be wondering: why use a stacked bar chart instead of a regular bar chart? A regular bar begins every task at the same position. Stacking lets each task begin at its actual place on the timeline.

Step 4: Add Task Names to the Vertical Axis

Excel may initially use row numbers instead of your task names. To correct this, right-click the chart and select Select Data.

Under the category-axis labels, choose the cells containing your task names. Confirm the selection, then close the dialog box.

Your chart should now display one task on each horizontal row. If the tasks appear in reverse order, right-click the vertical axis and choose Format Axis. Select Categories in reverse order.

This places the first project activity at the top, which usually matches how people read a project plan.

Step 5: Hide the Start-Date Series

The start-date series is necessary for positioning the bars, but you do not want it visible. Select the left-hand portion of any bar, then open Format Data Series.

Set:

The visible duration bars will remain. Their position will still reflect each task’s start date.

Let me explain: Excel still uses the hidden series in its calculations. Removing its color changes the appearance without removing the positioning logic.

Step 6: Format the Date Axis

The horizontal axis may show large serial numbers instead of calendar dates. Right-click the axis and select Format Axis.

Change the number format to a date style such as:

Set the minimum bound close to the earliest project start date. This removes unnecessary empty space before the first task.

For a six-month project, weekly or monthly labels may be easier to read than daily labels. Choose a time scale that matches the project’s level of detail.

Step 7: Improve the Chart’s Readability

Apply a consistent color to the duration bars. Use one strong color for planned work, then reserve another color for milestones or delayed activities.

You can also improve the chart by:

Keep the visual system simple. If every task has a different color, the chart becomes harder to scan during a project meeting.

How the Excel Gantt Chart Works

The chart depends on two values for every task: when the task begins and how long it lasts. Excel places the first series along the timeline, then draws the duration beside it.

Imagine a task starting on June 11. Excel creates an invisible gap from the project’s first date to June 11. The visible bar begins after that gap and extends for the calculated duration.

Here's why: the chart is visualizing calendar positions rather than simply drawing independent bars. If you change a start date, the bar moves. If you change an end date, the bar grows or shrinks.

For example, changing development from June 11–19 to June 13–22 moves the bar two days later and increases its length by one day. The chart updates after the formulas recalculate.

How to Add Milestones, Dependencies, and Progress

A basic Gantt chart shows timing. You can make it more useful by adding milestones, relationships, and completion status.

Adding Milestones

A milestone is a significant event with no meaningful duration, such as approval, testing completion, or product launch.

One practical approach is to add a milestone column containing the milestone date. You can then create a scatter series and place diamond markers on the chart.

For a simpler plan, create a one-day duration for each milestone and use a contrasting bar color. Label the task clearly, such as “Client approval” or “Launch day.”

Showing Dependencies

Excel does not automatically draw dependency arrows as smoothly as dedicated project management software. You can still show relationships through task ordering and clear labels.

For example, place “Development” after “Page design” and add a dependency note such as “Begins after design approval.” This gives the team enough context for a small project.

For complex plans with many predecessor relationships, manual arrows can become difficult to maintain. A dedicated project platform may be more efficient.

Tracking Completion

To show progress, add a Progress column with percentages such as 25%, 50%, or 100%. You can create a second duration series that represents completed work.

Suppose a task lasts eight days and is 50% complete. The completed series would represent four days, while the remaining series would represent the unfinished portion.

Use a darker color for completed work and a lighter color for remaining work. This makes schedule status visible without adding long notes.

Common Excel Gantt Chart Mistakes

Most chart problems come from the setup rather than the chart tool itself. A few checks can prevent confusing results.

Using Text Instead of Real Dates

If Excel treats “June 1, 2026” as text, date subtraction will fail or produce unexpected results. Test a date by changing its format. If the value behaves like a number when formatted, Excel probably recognizes it correctly.

Entering dates consistently also helps. Avoid mixing formats such as 6/1/26, June 1, and 1 June 2026 across the same schedule.

Forgetting the Inclusive Day

Many people calculate duration with:

=End Date-Start Date

That formula excludes one endpoint. If your project counts both the beginning and ending day, use:

=End Date-Start Date+1

For a task from Monday through Friday, the inclusive result is five calendar days.

Leaving the Start Series Visible

If you forget to hide the start-date series, the chart displays two colored bars for every task. This can make the timeline look like each activity has an incorrect extra duration.

Set the start series to no fill and no line. Keep the duration series visible.

Making the Timeline Too Detailed

A daily timeline may suit a two-week campaign. It can become unreadable for a two-year program.

Choose weekly, monthly, or quarterly labels based on the planning horizon. You can also create separate summary charts for executives and detailed charts for the delivery team.

When Excel Is the Right Choice

Excel works well when one person owns a small plan, the schedule changes occasionally, and the team needs a familiar format.

For example, a three-person event team planning a one-month workshop can manage tasks, dates, and simple progress tracking in one workbook. The chart is quick to create and easy to share internally.

Excel becomes less convenient when several people edit the schedule, tasks have complex dependencies, or managers need live reports. Version confusion can appear when several copies circulate with different dates.

The decision depends on coordination needs. A simple timeline may need only Excel. A cross-functional program may need shared workflows, permissions, notifications, and reporting.

How to Keep the Timeline Updated

A Gantt chart only helps when it reflects the current plan. Set a regular review rhythm, such as every Monday morning or at the end of each project meeting.

During each review, check three items:

Use formulas instead of typing repeated durations manually. A formula-driven schedule updates more reliably when dates change.

You can also add a status column with labels such as Planned, In Progress, Blocked, and Complete. Conditional formatting can then apply colors automatically.

The best part? A five-minute weekly review can reveal schedule drift before it affects a major milestone.

Gantt Chart Solution: ONES.com

ONES.com product screenshot

Value Proposition

ONES.com brings project management and knowledge management together in one platform. ONES Project can support teams that need shared schedules, Jira-compatible workflows, reporting, and stronger coordination than a manually maintained chart.

It is available through Cloud, On-Premise, Private Cloud, and Air-gapped deployments, with full feature parity between cloud and self-hosted versions.

Core Capabilities

Application Scenarios

Software release planning: A product team can organize backlog items, sprint work, approvals, and release milestones in one workspace. Instead of updating a separate chart after each planning session, the team works directly in the project process.

Hardware development: Engineering, design, procurement, and quality teams can coordinate long-running activities with custom fields and workflows. An air-gapped deployment may suit an organization with restricted network requirements.

Marketing campaign delivery: A campaign team can track creative work, reviews, launch tasks, and post-launch activities. Reporting gives managers a broader view than a static timeline alone.

Common Challenges and Practical Solutions

Challenge: The Chart Becomes Too Wide

Solution: Adjust the timeline scale. Use weekly labels for a monthly plan and monthly labels for a long program. Create a separate detailed view when daily planning is necessary.

Challenge: Dates Change Frequently

Solution: Keep start dates, end dates, and duration formulas separate. Update the dates, then allow the formulas and chart to recalculate automatically.

Challenge: Several People Need to Update the Plan

Solution: Use shared access controls and a clear editing routine. If edits, approvals, and comments become difficult to coordinate, move the workflow into a collaborative project platform.

Challenge: Progress Is Hard to See

Solution: Add a progress percentage and a completed-work series. Use contrasting colors for finished and remaining work, then review the values during each status meeting.

FAQs

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

Yes. You can build one manually with task names, start dates, end dates, duration formulas, and a stacked bar chart. The key step is hiding the start-date series after creating the chart. Excel then uses that series for positioning while displaying only the duration bars.

What formula calculates task duration in Excel?

Use =End Date-Start Date+1 when you count both the first and last calendar day. For example, a task running from June 1 through June 5 produces a five-day duration. If you use working days only, consider Excel’s NETWORKDAYS function instead.

Why does my Excel Gantt chart show numbers instead of dates?

Excel stores dates as serial numbers, so the axis may display those numbers when its format is set to General. Right-click the horizontal axis, open Format Axis, and choose a date format such as mmm d or mmm-yy.

How do I reverse the task order in an Excel Gantt chart?

Right-click the vertical axis and open Format Axis. Select Categories in reverse order to place the first task at the top. You may also need to adjust the horizontal axis position so the timeline remains easy to read.

Can Excel show task dependencies?

Excel can represent dependencies through task order, notes, and manual arrows. However, maintaining many connected activities can become time-consuming. If dependencies change often, a project management platform with workflow and relationship support may provide a more dependable approach.

Conclusion

You can draw a practical Gantt chart in Excel by building a task schedule, calculating durations, inserting a stacked bar chart, hiding the start-date series, formatting the timeline, and adding progress details.

Start with a small project so you can test the formulas and formatting. Then review dates regularly, use milestones where they add meaning, and avoid overcrowding the timeline with unnecessary detail.

But here's the truth: the chart is only useful when the plan stays current. Excel suits straightforward schedules, while ONES.com can help teams coordinate more complex work through shared workflows, reporting, automation, and deployment choices.