Guide · 2026-08-19

How to Make a Gantt Chart in Excel: A Step-by-Step Guide

Project schedules can become confusing quickly. Tasks overlap, deadlines move, and a simple list rarely shows what should happen next. When your team cannot see timing clearly, small delays can spread across the entire project.

That frustration gets worse when you need a visual plan but do not have dedicated project software. You may spend more time formatting cells than planning the work itself. A poorly built chart can also hide dependencies and make progress difficult to track.

Here’s the solution: you can create a practical Gantt chart in Excel by arranging tasks, dates, durations, and progress in a stacked bar chart. I’ll walk you through the process, explain common mistakes, and show when a dedicated project platform may be a better fit.

How to Make a Gantt Chart in Excel

To make a Gantt chart in Excel, create a task table with start dates and durations, insert a stacked bar chart, hide the start-date series, and format the chart so each bar represents a task timeline. You can then add progress, milestones, owners, and deadline markers.

The basic method works in Excel for Microsoft 365 and most recent desktop versions. The menu names may vary slightly between versions, but the process remains similar.

Step 1: Build the project schedule table

Start with a simple table containing the information Excel needs to position each task on a timeline.

Task Start Date End Date Duration
Define requirements April 1 April 4 4 days
Create wireframes April 5 April 10 6 days
Build prototype April 11 April 19 9 days
Run testing April 20 April 24 5 days

Enter real Excel dates rather than typing dates as plain text. Excel can then calculate durations and position bars correctly along the horizontal axis.

For each task, calculate the duration with a formula such as:

=C2-B2+1

In this example, column B contains the start date and column C contains the end date. Adding one counts both the first and last day.

Step 2: Add optional project details

You can keep the first version simple, then add useful planning details. Helpful columns include:

For example, a task might show “Design team,” “High,” and “50% complete.” These details do not create the timeline automatically, but they make the schedule more useful during project reviews.

Here’s why: a visual schedule tells you when work occurs, while supporting columns explain who owns it and whether it is moving as planned.

Step 3: Select the start date and duration columns

Highlight the task names, start dates, and durations. Include the column headings, but do not include the end dates unless you plan to use them for another chart element.

For the example above, you might select:

The start-date series creates the invisible spacing before each task begins. The duration series becomes the visible bar.

Step 4: Insert a stacked bar chart

With the relevant cells selected, open the Insert tab in Excel. Choose Bar Chart, then select 2-D Stacked Bar.

Excel will create a chart with two colored sections for each task. One section represents the time before the task begins. The other represents the task duration.

You might be wondering: why use a stacked bar chart instead of a regular bar chart? A regular bar chart starts every bar at the same point. A stacked bar chart lets Excel shift each task according to its start date.

Step 5: Reverse the task order

Excel often places the first task at the bottom of the chart. That feels backward because project schedules usually read from the first task at the top to the final task at the bottom.

To correct it:

  1. Right-click the vertical task axis.
  2. Select Format Axis.
  3. Open the axis options.
  4. Enable Categories in reverse order.

The first task should now appear at the top. Excel may move the horizontal date axis, so check its position after reversing the order.

Step 6: Hide the start-date series

The start-date section is necessary for positioning, but it should not remain visible in the finished chart.

To hide it:

  1. Click one of the start-date sections in the chart.
  2. Open the formatting options.
  3. Choose No Fill.
  4. Choose No Line if Excel displays an outline.

The duration sections will remain visible. They should now appear to float at their correct positions on the calendar.

The best part? The chart still uses the start-date series behind the scenes. You are only making that series invisible.

Step 7: Format the horizontal date axis

The horizontal axis controls the calendar scale. If the chart starts too early or ends too late, adjust the minimum and maximum bounds.

Right-click the horizontal axis and choose Format Axis. Then review:

For a two-week project, daily labels may be useful. For a six-month initiative, weekly or monthly labels will usually make the chart easier to read.

Step 8: Improve the visual design

Good formatting helps people understand the schedule without studying every cell.

Avoid using a different color for every task. Too many colors make the chart look busy and weaken the meaning of color.

Step 9: Add progress tracking

Excel does not automatically turn a basic Gantt chart into a live progress tracker. You need an additional series or a visual convention.

One practical method is to add a Completed Duration column. If the task is 60% complete, calculate completed duration like this:

=Duration*Percent Complete

You can add that series to a stacked bar chart and use a darker shade for completed work. The remaining duration can use a lighter shade.

For example, a nine-day task at 60% completion would show 5.4 days completed. You can round the value if your planning method uses whole working days.

Step 10: Add milestones

Milestones usually have no duration, so they need a different visual treatment. You can represent them with:

A launch approval on April 25, for example, could appear as a diamond at the end of the testing period. This makes an important decision point visible without pretending it is a multi-day task.

Step 11: Test the chart with a schedule change

Change one start date and confirm that the related bar moves. Change one end date and confirm that the duration updates.

This quick test catches common problems, such as dates stored as text or formulas pointing to the wrong row. If a bar does not move as expected, inspect the cell format and formula before polishing the design.

How the Excel Gantt Chart Works

An Excel Gantt chart is a visual schedule that places project tasks across a calendar. Each horizontal bar shows when a task starts, how long it lasts, and how it relates to nearby work.

Excel does not offer a standard one-click Gantt chart type. Instead, you create one by adapting a stacked bar chart. The chart combines two values:

After you remove the fill from the start-date series, only the duration bars remain visible. The result resembles a traditional project timeline.

The four building blocks

A useful schedule typically contains four elements:

  1. Tasks: the work your team must complete.
  2. Dates: when each task begins and ends.
  3. Duration: the amount of time allocated to each task.
  4. Relationships: which tasks depend on other work.

For example, testing may depend on a completed prototype. If the prototype moves three days later, the testing period may need to move as well.

Calendar days versus working days

The simplest duration formula counts calendar days. That works for projects running every day, but it may overstate duration when your team works Monday through Friday.

For working days, use a formula such as:

=NETWORKDAYS(B2,C2)

This excludes weekends by default. You can also provide a holiday range when your schedule must exclude company holidays.

Consider a task starting Friday and ending Monday. Calendar counting produces four days, while weekday counting produces two. Choosing the wrong method can make the entire schedule misleading.

Common Excel Gantt Chart Mistakes

Using text instead of real dates

If Excel treats “April 1” as text, it cannot position the bar reliably. Click the cell and check whether Excel recognizes it as a date. Changing the cell format to Date may resolve the problem, but text values may need to be entered again.

Including the wrong columns

If you select end dates instead of durations, the chart may create bars that are far too long. The visible series should represent elapsed time, not the calendar date when a task finishes.

Forgetting the hidden spacing series

Deleting the start-date series removes the positioning logic. Hide it instead. The chart needs the series even though viewers do not need to see it.

Making the chart too detailed

A schedule with 150 individual rows may be technically accurate but difficult to review. Group small activities into phases when the audience needs a management-level view.

For example, combine “draft headline,” “review headline,” and “approve headline” into a “Content planning” phase. Keep the detailed activities elsewhere for the people performing the work.

Failing to update dependencies

A bar may move when you change its date, but related tasks will not necessarily move automatically. This creates a false sense of control.

Review dependent tasks after every major schedule change. If several relationships need constant manual adjustment, Excel may be reaching its practical limit for your project.

Ways to Make the Schedule Easier to Use

Separate planning from presentation

Keep calculation columns separate from presentation columns. You might use hidden helper columns for duration, working days, and completion percentage while displaying only the fields your audience needs.

This approach keeps the visible schedule clean without sacrificing calculation accuracy.

Use a consistent update routine

Choose a regular review cycle. For example, update the schedule every Tuesday morning and discuss changes during a Wednesday project meeting.

A consistent routine prevents the chart from becoming an attractive but outdated image. The value comes from current information, not decoration.

Mark the baseline

If you want to compare planned dates with actual dates, preserve the original schedule before making changes. You can then add planned and actual bars or include a baseline column.

Suppose a design phase was planned for April 5–10 but actually ran from April 7–14. Showing both periods reveals the delay more clearly than a revised date alone.

Keep one owner for schedule maintenance

When several people edit the same schedule without coordination, formulas and formatting can drift. Assign one person to maintain the main planning view and collect updates from task owners.

This does not prevent collaboration. It creates accountability for the version people use during decisions.

When Excel Is the Right Choice

Excel works well for small projects, short schedules, and teams that need a quick visual plan. It is especially practical when one person owns the timeline and updates happen occasionally.

For example, a marketing team planning a two-week campaign can create a clear schedule with ten tasks, three owners, and one launch milestone. The chart may be all the team needs.

Excel also makes sense when you need a printable planning view or want to experiment with dates before committing to a project workflow.

Signs you may need more structure

A dedicated project platform becomes more useful when the schedule includes frequent changes, many contributors, or complicated relationships between tasks.

Here’s the truth: an Excel chart can show the plan, but it does not automatically manage the work behind the plan.

Natural Topic Solution: ONES.com

ONES.com product screenshot

Value Proposition

ONES.com combines project management and knowledge management in one platform, powered by ONES Assistant. ONES Project is a Jira alternative for structured project work, while ONES Wiki is a Confluence alternative for organized team knowledge. They are sold separately.

If your Excel schedule has become difficult to maintain, ONES.com can move planning, task ownership, progress tracking, and team context into a more connected workflow.

Core Capabilities

Manual timeline updates create maintenance work

ONES capability: ONES Project supports structured project planning with tasks, dates, sprint management, and custom workflows.

Result: Your team can manage work through a repeatable process instead of repeatedly rebuilding chart formulas.

Unclear task relationships cause schedule surprises

ONES capability: Jira-compatible workflows help teams organize statuses, transitions, approvals, and dependencies in a familiar project structure.

Result: A change in one part of the workflow is easier to evaluate before it affects delivery.

Different teams need different processes

ONES capability: Custom workflows and custom fields let you adapt work items to your project type.

Result: A software team, marketing team, and operations team can use suitable processes without forcing every project into one template.

Progress reporting takes too much formatting

ONES capability: Built-in reporting provides project visibility without requiring you to manually format every status update.

Result: Project leads can spend more time interpreting progress and less time preparing visual summaries.

Repeated actions slow the team down

ONES capability: Automation can handle recurring workflow actions and routine project changes.

Result: Common steps become more consistent, reducing manual follow-up.

Plugins create fragmented workflows

ONES capability: ONES Project provides native capabilities for project management, reporting, workflows, fields, sprint planning, and automation.

Result: Teams can reduce dependence on multiple plugins for everyday project operations.

Restricted networks limit cloud-only tools

ONES capability: ONES.com supports four deployment options: Cloud, On-Premise, Private Cloud, and Air-gapped.

Result: Organizations with strict infrastructure or security requirements can choose an environment that fits their operating model.

Moving platforms can create capability gaps

ONES capability: ONES.com maintains full feature parity between its cloud and self-hosted versions.

Result: Teams can select a self-hosted deployment without giving up the core capabilities available in the cloud version.

Small teams need a low-risk starting point

ONES capability: The free plan supports up to 30 seats.

Result: A smaller team can test a structured project workflow before making a larger commitment.

Application Scenarios

Software release planning

A development team may begin with an Excel timeline for a release. As requirements, coding, testing, and approvals become interconnected, ONES Project can provide workflows, sprints, reports, and automation in one project environment.

Marketing campaign coordination

A campaign team can manage creative tasks, review steps, launch approvals, and ownership without keeping separate schedule tabs for each department. ONES Wiki can hold campaign guidance when the team also needs a shared knowledge area.

Organizations with restricted infrastructure

A company that cannot place project information in a public cloud can consider On-Premise, Private Cloud, or Air-gapped deployment. The team can retain a structured project workflow while meeting its infrastructure requirements.

Common Challenges

Challenge: The bars show the wrong dates

Solution: Confirm that start dates are recognized as dates and that duration values are numbers. Check the chart series so the start-date column creates spacing and the duration column creates visible bars.

Challenge: Weekend work distorts the timeline

Solution: Replace calendar-day calculations with NETWORKDAYS when your team works on weekdays. Add holiday exclusions if the schedule covers public or company holidays.

Challenge: The chart becomes unreadable

Solution: Create separate views for executives and contributors. Use phases for the high-level view, then keep detailed activities in a supporting planning area.

Challenge: Progress is difficult to maintain

Solution: Add a percentage-complete field and a completed-duration series. If updates happen daily across a large team, consider a project platform with built-in status workflows and reporting.

Challenge: Schedule changes break related work

Solution: Review dependent tasks whenever a major date changes. For complex projects, use a system that can represent relationships, approvals, notifications, and ownership more directly.

FAQs

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

Yes. You can build one manually with a task table, start dates, durations, and a stacked bar chart. The key steps are hiding the start-date series and reversing the task order. Templates can save time, but building the chart yourself helps you understand how the timeline works and makes troubleshooting easier.

What formula should I use for task duration?

For calendar days, use =EndDate-StartDate+1. For weekdays, use =NETWORKDAYS(StartDate,EndDate). Choose the formula that matches how your team actually works. A schedule that counts weekends for a weekday-only team can make tasks appear longer than their practical working time.

How do I show task progress in Excel?

Add a percentage-complete column and calculate completed duration by multiplying total duration by completion percentage. Then add completed duration as another stacked series and use a darker color for finished work. Update the percentage regularly so the visual reflects current progress rather than an old estimate.

Can an Excel Gantt chart show dependencies?

It can show the timing created by dependencies, but Excel does not automatically manage relationships in a basic chart. You must update related dates yourself or build more advanced formulas. If a project has many linked tasks, approvals, or frequent changes, a dedicated project management platform may be more reliable.

Should I use calendar days or working days?

Use calendar days when work can continue throughout the week or when you need to show elapsed time. Use working days when weekends and holidays are unavailable for project work. For instance, a Monday-to-Friday team should usually calculate a Friday-to-Monday task as two working days, not four calendar days.

When should I move from Excel to project management software?

Consider changing tools when several people update the plan, status changes happen frequently, or you need automation, permissions, reports, and dependency tracking. Excel remains useful for quick planning and small projects. A dedicated platform becomes more valuable when manual coordination starts consuming time or causing missed handoffs.

Conclusion

You can create a clear Gantt chart in Excel by combining task names, start dates, durations, and a stacked bar chart. Hide the start-date series, reverse the task order, format the calendar axis, and add progress or milestones when needed.

Start with a small schedule and test one date change before adding advanced formatting. That simple check can prevent misleading timelines later.

But here's the truth: Excel is excellent for a lightweight visual plan, while complex projects need stronger workflow control. If manual updates, dependencies, reporting, or restricted deployment requirements are becoming obstacles, ONES.com offers a structured path beyond a manually maintained chart.