How to Make a Gantt Chart in Excel: 7 Easy Steps [2026]

Project schedules can become confusing fast. Tasks overlap, deadlines move, and a long list of activities rarely shows what needs attention first.

A plain Excel grid may tell you when work starts and ends, but it makes dependencies and delays harder to spot. That can lead to missed handoffs, overloaded teammates, and last-minute surprises.

Here’s the good news: you can build a useful Gantt chart in Excel with seven practical steps. You only need a task list, dates, and a stacked bar chart.

But here’s the truth: Excel works best for small, straightforward plans. I’ll show you how to create the chart, improve its readability, avoid common mistakes, and know when a dedicated project platform makes more sense.

How to Make a Gantt Chart in Excel in 7 Steps

A Gantt chart in Excel is a timeline that displays project tasks as horizontal bars across calendar dates. The chart usually uses one invisible series to position each task and one visible series to show its duration.

Here’s the basic workflow: prepare task details, calculate task length, create a stacked bar chart, hide the positioning series, format the dates, and refine the final view.

1. Build your task planning table.

   Open Excel and create three columns named Task, Start Date, and Duration. Add one row for every activity in your project.

   Task	Start Date	Duration
   Research requirements	01/06/2026	5
   Create wireframes	01/13/2026	7
   Build prototype	01/22/2026	10
   Review with stakeholders	02/05/2026	4

   Use real Excel date values in the start-date column. A value that only looks like a date may not work correctly when Excel plots the timeline.

2. Calculate the duration for each task.

   Duration means the number of calendar days between the start and finish dates. If you have separate start and finish columns, use a formula such as:

   =Finish Date - Start Date + 1

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

   =C2-B2+1

   The +1 counts both the first and last day. Without it, a task beginning on January 6 and ending on January 6 would show zero days.

   If you want to count weekdays only, use:

   =NETWORKDAYS(B2,C2)

   Choose one method and apply it consistently. Mixing calendar days and working days can make your schedule appear shorter or longer than expected.

3. Select the task, start-date, and duration columns.

   Highlight the range containing your task names, start dates, and durations. Include the column headings, but avoid unrelated notes or totals.

   For a first chart, the selection might be A1:C5. Including the task names helps Excel create category labels automatically.

4. Insert a stacked bar chart.

   Go to Insert, choose Bar Chart, and select Stacked Bar. Avoid the regular bar chart because it does not layer the start position and task length in the required way.

   Excel will create two series:

   • The start-date series positions each task along the timeline.
   • The duration series creates the visible task bar.

   At this stage, the chart may look unusual. The start-date bars usually appear as a large colored block, while the duration bars sit beside them.

5. Make the start-date series invisible.

   Click one of the bars representing the start-date series. Open the formatting panel, choose Fill, and select No Fill. Remove the border as well if Excel displays one.

   Now only the duration bars should remain visible. They appear to begin on their correct dates because the transparent series still reserves the required space.

   Let me explain: the hidden series is not decorative. It acts like an invisible spacer. Removing it entirely would make every task begin at the same point.

6. Reverse the task order.

   Excel often places the first task at the bottom of a horizontal bar chart. To correct this, right-click the vertical task axis and choose Format Axis.

   Enable Categories in reverse order. The first activity should now appear at the top, matching the normal reading order of a project plan.

   You may also need to adjust the horizontal axis so the earliest project date appears at the left. Set the minimum bound close to your first start date rather than accepting a broad automatic range.

7. Improve the chart’s readability.

   Remove the legend if the series names are no longer useful. Add a clear title, adjust the bar spacing, and use a color that remains readable when printed.

   Consider adding milestone markers or a separate column for owners. You can also add a vertical line for today’s date, although that takes an extra series or a shape.

   Before sharing the chart, check three things:

   • Every task has a valid start date.
   • Every duration matches the intended calendar.
   • The timeline covers the entire project without excessive empty space.

What a Gantt Chart Should Show

A useful schedule does more than display colorful bars. It should help you answer practical questions quickly: What happens next? Which tasks overlap? Where might work stall?

At a minimum, include the activity name, planned start date, planned finish date, duration, and responsible person. For larger projects, add status, priority, dependencies, and milestone information.

Tasks and milestones

Tasks describe work that takes time, such as “write landing page copy.” Milestones represent points in time, such as “design approved.” A milestone normally has no duration, so you can show it with a diamond or a narrow marker.

For example, a website launch plan might include “Prepare product pages” as a 10-day task and “Content approved” as a one-day milestone.

Overlapping activities

Overlapping bars show parallel work. This matters when two activities depend on the same person or team.

Suppose testing and training overlap for five days. The schedule may be reasonable, or it may reveal a staffing problem. The visual comparison helps you investigate before the conflict becomes urgent.

Dependencies

Dependencies explain sequence. A developer may need approved wireframes before building a prototype. A marketing team may need final product details before preparing campaign content.

Excel does not provide the same dependency management as dedicated planning software. You can still add a predecessor column, use notes, or draw connector lines, but those elements require more manual upkeep.

How to Format the Timeline for Clarity

Formatting determines whether people can understand your plan in seconds. A chart with accurate dates can still fail if labels are cramped or colors have no clear meaning.

Here’s why: people scan a timeline visually. When every bar uses a different color, the chart becomes decoration instead of a planning aid.

Use a limited color system

Assign colors by meaning rather than by individual task. For example, blue can represent planned work, green can represent completed work, and orange can flag tasks at risk.

Keep the same color rules across project reviews. If orange means “at risk” one week and “in progress” the next, the visual cue loses its value.

Choose useful date intervals

A short two-week plan may benefit from daily labels. A six-month project usually works better with weekly or monthly intervals.

If the chart shows too many dates, reduce the label frequency. If the timeline feels vague, increase the detail. The best interval depends on how often you make decisions.

Make task names easy to scan

Use short, specific names. “Prepare customer interview questions” is more useful than “Research.” Long labels may be cut off, so widen the category area or shorten the wording.

Group related activities with headings only when the chart remains easy to maintain. Excessive grouping can make the schedule harder to update.

How to Add Progress and Milestones

The basic chart shows planned timing. You can extend it to show progress, but avoid turning one chart into a crowded reporting dashboard.

Show task completion

Add a Percent Complete column. Then calculate completed duration with a formula such as:

=Duration*Percent Complete

You can use a second stacked series to display completed work inside the planned bar. For instance, a 10-day task that is 60% complete would show six days of progress.

Keep planned duration visible as a lighter background bar. This lets you compare actual progress with the original expectation.

Mark important dates

For a small schedule, you can add a milestone as a one-day activity. Give it a distinct color and a name that describes the outcome.

Examples include:

• Prototype approved
• Security review passed
• Training complete
• Release candidate ready

Milestones work best when they represent decisions or deliverables. A vague marker such as “Check-in” does not tell the team what success means.

Add a current-date indicator

A vertical line showing today’s date helps you see whether the project is ahead or behind schedule. In Excel, you can create a helper series that uses the current date and a fixed value.

This technique requires careful axis formatting. If the chart is used only once, a manually positioned line may be faster. If the plan is reviewed often, a formula-driven series is more reliable.

How to Keep an Excel Schedule Accurate

A Gantt chart is only as useful as its maintenance routine. A carefully designed chart can become misleading when dates are edited manually or completed work is not recorded.

The best part? A few simple habits prevent most scheduling errors.

Separate planned and actual dates

Keep planned start and finish dates separate from actual start and finish dates. This lets you compare the original expectation with what really happened.

For example, a task planned for January 12–16 may actually run from January 14–20. That difference helps you identify delay patterns instead of silently overwriting history.

Use formulas consistently

Calculate duration from dates whenever possible. Manually typed durations can become wrong after a date change.

Check formulas after inserting rows or copying sections. A reference that points to the wrong row can distort several bars while still looking reasonable.

Review the plan on a regular rhythm

For an active project, review the schedule at least once each week. Update completed work, move unfinished activities, and record decisions that affect timing.

If your plan changes daily, consider whether Excel is creating more maintenance work than value. Frequent edits, several contributors, and complex dependencies are warning signs.

When an Excel Gantt Chart Stops Being Enough

Excel is a practical choice for a personal plan, a small event, or a simple project with one coordinator. It becomes less comfortable when many people need to update the same schedule.

Imagine a product launch with 80 activities, five teams, and several approval gates. A change to one delivery date may affect design, engineering, testing, training, and marketing. Tracking those effects manually can take longer than the original planning.

Consider a dedicated planning platform when you need:

• Shared, real-time project updates.
• Task ownership and accountability.
• Automatic notifications and reminders.
• Dependencies that adjust when dates change.
• Reusable workflows for recurring projects.
• Progress reporting across multiple teams.
• Permission controls for sensitive work.

That does not make Excel a poor choice. It means the planning problem has grown beyond a static chart. Choose the simplest approach that gives your team reliable visibility.

Natural Project Scheduling Solution: ONES.com

ONES.com combines project management and knowledge management in one platform, with AI support through ONES Assistant. ONES Project is the project management product and a Jira alternative, while ONES Wiki is the knowledge management product and a Confluence alternative. They are sold separately.

If your schedule needs shared ownership, structured workflows, and ongoing reporting, ONES.com can reduce the manual work involved in maintaining a large project plan.

Value Proposition

ONES.com helps teams move from manually maintained timelines to connected project workflows. You can keep planning, execution, reporting, and team knowledge aligned without relying on repeated chart edits.

Core Capabilities

Scattered schedules → Unified project planning

When activities sit across separate planning areas, progress becomes difficult to compare. ONES Project brings tasks, owners, dates, and status into a shared workspace, giving the team one operational view.

Manual timeline adjustments → Jira-compatible workflows

If your team already understands Jira-style planning, changing systems can create friction. ONES Project supports Jira-compatible workflows, helping teams preserve familiar work patterns while using another platform.

Complex project rules → Custom workflows and fields

A standard task list may not reflect your approval process. Custom workflows and fields let you capture stages such as review, security approval, release readiness, and completion.

Unclear delivery timing → Sprint management

Long timelines can hide short-term priorities. Sprint management helps teams organize near-term work, monitor commitments, and connect sprint progress with broader project goals.

Repetitive coordination → Automation

Repeated status changes, assignments, and notifications consume attention. Automation can handle routine transitions so you can focus on exceptions and decisions.

Limited visibility → Built-in reporting

A manually formatted chart may show dates without explaining performance. Built-in reporting helps teams examine progress, workload, status, and delivery trends in a more repeatable way.

Plugin-heavy workflows → Native feature parity

When essential planning functions depend on many add-ons, maintenance becomes harder. ONES Project emphasizes native parity between its cloud and self-hosted versions, helping reduce reliance on plugins.

Restricted hosting requirements → Flexible deployment

Some teams cannot place project information in a standard cloud environment. ONES.com supports Cloud, On-Premise, Private Cloud, and Air-gapped deployments, giving organizations more control over hosting.

Separate team knowledge → Connected knowledge management

Project decisions can become difficult to find when knowledge lives elsewhere. ONES Wiki provides a knowledge management option that can support requirements, procedures, and team guidance alongside project work.

Application Scenarios

Software release planning: A product team can organize backlog work, sprints, testing, approvals, and release milestones. Custom fields can distinguish defects, features, risks, and readiness checks.

Enterprise transformation: Several departments can coordinate work across a shared program while reporting progress by team, stage, or initiative. Automation can reduce repetitive updates during recurring review cycles.

Restricted-network engineering: An organization with air-gapped requirements can use a self-hosted deployment while retaining the same core feature parity available in the cloud version.

Common Challenges When Creating a Gantt Chart

Challenge: The bars begin on the wrong dates

Cause: Excel may be treating date values as text, or the chart includes an incorrect range.

Solution: Re-enter one date manually, check the cell format, and confirm that the start-date series is included. Set the horizontal axis minimum bound near the first project date.

Challenge: The first task appears at the bottom

Cause: Excel’s default category order often reverses the task list.

Solution: Open the vertical-axis settings and enable Categories in reverse order. Check the result after changing the horizontal-axis position.

Challenge: The chart has too much empty space

Cause: The axis range extends well before the first task or after the final activity.

Solution: Adjust the minimum and maximum bounds manually. Leave enough space for context, but remove unused weeks or months.

Challenge: The chart becomes difficult to update

Cause: Dates, durations, colors, and labels may be maintained manually in several places.

Solution: Use formulas for duration, keep the planning range organized, and limit formatting exceptions. If several people update the plan frequently, evaluate a shared project platform.

Challenge: The chart looks attractive but does not guide decisions

Cause: Color and decoration may have replaced useful information.

Solution: Add owners, milestones, status, and dependencies. Ask whether someone can identify the next decision or likely delay within a few seconds.

FAQs

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

Yes. You can build one with a task column, a start-date column, a duration column, and a stacked bar chart. The key step is making the start-date series transparent. That hidden series positions each visible duration bar along the timeline. Templates can save time, but building the chart yourself helps you understand how to maintain it.

Should duration use calendar days or working days?

Use calendar days when weekends and holidays count toward delivery. Use working days when the team works on business days only. Excel’s NETWORKDAYS formula can calculate weekdays between two dates. Decide which calendar your project follows before creating the chart, then apply that rule consistently.

How do I show task dependencies in Excel?

You can add a predecessor column that identifies the task each activity depends on. Connector lines can also be drawn between bars, but they require manual adjustment after schedule changes. For a small plan, that approach may be sufficient. For complex dependencies, a dedicated project platform usually provides more reliable relationship tracking.

Can Excel show percentage completion?

Yes. Add a percent-complete column and calculate completed duration from the planned duration. A second stacked series can display completed work inside the planned bar. Use a darker progress color over a lighter planned bar so the difference remains visible.

How many tasks should an Excel Gantt chart contain?

There is no fixed limit, but readability declines as the chart grows. A plan with 10 to 30 well-defined activities is usually easier to review than one with hundreds of tiny rows. For a large project, group work into phases and maintain detailed tasks in a structured project management platform.

When should I use a project management platform instead of Excel?

Consider switching when several people need to update the plan, dependencies change often, or you need permissions, automation, reporting, and auditability. Excel remains useful for quick planning and lightweight schedules. A platform becomes more valuable when coordination and maintenance take more effort than the visual timeline saves.

Conclusion

Creating a Gantt chart in Excel takes seven main steps: organize tasks, calculate duration, insert a stacked bar chart, hide the start-date series, reverse the task order, format the timeline, and review the result.

The chart becomes more useful when you add milestones, owners, progress, dependencies, and a clear color system. Keep formulas consistent and review the schedule regularly.

But here’s the truth: the chart is only a planning aid. If it reveals constant conflicts, repeated manual edits, or complex coordination needs, that is a signal to improve the workflow behind it.

For a small project, Excel may be all you need. For collaborative delivery across teams, ONES.com can provide structured project management, reporting, automation, and flexible deployment options beyond a manually maintained timeline.