Can You Do a Gantt Chart in Excel? A Step-by-Step Guide 2026

Project schedules can become difficult to follow when tasks, dates, owners, and dependencies sit across scattered worksheets. A simple list may show what needs doing, yet it rarely reveals how one delay affects the rest of the plan. That makes status meetings longer and deadline risks harder to spot.

The good news is that you can build a useful Gantt chart in Excel without buying specialist software. You need a task list, start dates, durations, and a stacked bar chart. After a few formatting changes, Excel can show your project timeline clearly.

Here’s the practical approach: prepare your schedule, create the chart, hide the positioning series, and improve the design for real project tracking. I’ll also cover Excel’s limits and when a dedicated platform may save you time.

How to Create a Gantt Chart in Excel

Yes, you can create a Gantt chart in Excel by combining a task list with start dates and durations, then turning those values into a stacked bar chart. The start-date series positions each task, while the duration series displays its timeline.

Excel does not include a dedicated Gantt chart type in every version. However, a stacked bar chart produces the same visual result with a few adjustments.

Step 1: Plan the schedule fields

Start with four columns. Keep the structure simple so the chart remains easy to maintain.

• Task: the activity name, such as “Approve wireframes.”
• Start date: the day work begins.
• End date: the planned completion date.
• Duration: the number of calendar days between the start and end dates.

For example, a small website project might include research, wireframes, visual design, development, testing, and launch preparation.

Step 2: Calculate task duration

In the Duration column, subtract the start date from the end date. If the start date is in column B and the end date is in column C, use:

=C2-B2+1

The +1 counts both the first and last working day as calendar days. Without it, a task running from January 6 through January 9 would show three days instead of four.

If you want to exclude weekends, use the NETWORKDAYS function:

=NETWORKDAYS(B2,C2)

For a Monday-to-Friday project, this usually provides a more realistic duration. You can also add holiday dates to the formula when public holidays affect the plan.

Step 3: Insert a stacked bar chart

Select the Task, Start date, and Duration columns. Then choose Insert, select Bar Chart, and choose Stacked Bar.

Excel creates two colored segments for each task. The first segment represents the time before the task begins. The second segment represents the task duration.

At this stage, the chart may look like a normal horizontal bar chart. That is expected. The next formatting steps turn it into a Gantt-style timeline.

Step 4: Put tasks in the correct order

Excel often displays the first task at the bottom. To reverse the order, right-click the vertical task axis and open Format Axis.

Enable Categories in reverse order. Your first task should now appear at the top, matching the way people usually read a project plan.

This small adjustment matters during meetings. Team members can begin at the top and move down the schedule without mentally reversing the task sequence.

Step 5: Hide the start-date series

Click one of the bars representing the start-date values. Open Format Data Series, then set the fill to No Fill and the border to No Line.

The start-date series still positions each task on the timeline, but it becomes invisible. Only the duration bars remain visible.

That is the key technique behind an Excel Gantt chart. You are using a hidden bar as spacing, then showing the actual work period beside it.

Step 6: Format the date axis

Right-click the horizontal date axis and choose Format Axis. Adjust the minimum and maximum bounds so the chart focuses on the project period rather than showing unnecessary space.

You can also change the major unit. A unit of seven displays weekly intervals, while a unit of one displays daily intervals.

For a three-month project, weekly intervals usually keep the chart readable. For a five-day sprint, daily intervals offer better detail.

Step 7: Improve readability

Use one strong color for active task bars and a lighter color for milestones or completed work. Avoid adding many colors unless each color has a clear meaning.

Reduce the gap width between bars if the tasks look too thin. Add a clear chart title, remove unnecessary borders, and keep task names short enough to scan quickly.

You can also add a vertical line for today’s date. A simple extra series can show the current day and make overdue work easier to identify.

Step 8: Add progress tracking

To show progress, add a Progress column. Enter a percentage such as 25%, 60%, or 100%, then create a second duration series for completed work.

For example, if a task lasts ten days and is 40% complete, the completed portion equals four days. A formula can calculate this value:

=Duration*Progress

Place the completed series in front of the planned duration series. Use a darker shade for completed work and a lighter shade for remaining work.

Step 9: Test the schedule

Change one start date and confirm that the corresponding bar moves. Change one duration and check that the bar grows or shrinks correctly.

Test a task that crosses a month boundary. Then check a short task, a long task, and a milestone with zero duration.

If the chart does not react correctly, review the date formats, formulas, and chart range before relying on it for project decisions.

What an Excel Gantt Chart Shows

A Gantt chart places tasks vertically and time horizontally. Each horizontal bar shows when an activity begins, how long it lasts, and where it sits within the wider plan.

For instance, a testing bar that begins after development ends makes the sequence easy to understand. If testing overlaps development, the visual immediately shows parallel work.

Tasks and time periods

The vertical axis lists project activities. The horizontal axis displays days, weeks, or months.

That combination helps you answer practical questions quickly:

• Which tasks are active this week?
• What work is scheduled next?
• Which activities overlap?
• Where could a delay affect the launch date?

Dependencies and overlap

Excel can show overlapping dates, but it does not automatically manage relationships between tasks. You must decide which activity depends on another and update the schedule yourself.

Suppose development begins before the design review finishes. The chart can display both bars, yet it will not warn you that the sequence may create rework.

Use a dependency column or notes area to record relationships such as “starts after approval” or “finishes before release.”

Milestones

A milestone represents an important point rather than a long activity. Examples include contract approval, product review, launch, or customer sign-off.

You can show a milestone with a short duration, a separate marker, or a diamond-shaped symbol. Keep the meaning consistent throughout the chart so people understand it without extra explanation.

How to Make the Schedule More Accurate

A polished chart can still mislead you if the schedule underneath contains unrealistic dates. Accuracy comes from clear planning rules, consistent duration calculations, and regular updates.

Choose calendar days or working days

Decide whether durations include weekends. A marketing campaign may run across calendar days, while a software sprint usually counts working days.

Mixing both approaches creates confusion. A five-day task may appear to last seven days when the chart uses calendar dates, or finish too early when weekends are excluded.

Separate planned and actual dates

Keep planned dates visible even after work begins. Add actual start and actual end columns when you need to compare the plan with reality.

For example, a task planned for January 10 may begin on January 13. Keeping both dates reveals the three-day slip and helps explain its effect on later activities.

Use a consistent status method

Choose simple status labels such as Not started, In progress, Blocked, and Complete. Pair those labels with colors only when the team understands the legend.

A red bar should mean the same thing everywhere. If red means “blocked” in one section and “completed” in another, the visual creates more work instead of reducing it.

Add ownership

A chart becomes more useful when every major activity has an owner. Add a Responsible column beside the task name or include initials in the label.

“Prepare release notes — Maya” gives a team more direction than “Prepare release notes” alone. You can then filter or group the schedule during a status review.

Excel Gantt Chart Limitations to Consider

Excel works well for a small, stable schedule. Its limitations become more visible when a project has many contributors, frequent changes, or complex dependencies.

Manual updates take time

When one date changes, you may need to update related dates, formulas, chart ranges, progress values, and notes manually.

Imagine a two-week delay in design. Five following activities may need new dates. Excel can display the revised plan, but it will not automatically reschedule every dependent activity for you.

Collaboration can become difficult

Several people editing the same workbook can create conflicting changes or unclear ownership. Comments may also become separated from the work they describe.

Cloud collaboration improves access, yet it does not automatically create a complete project history or a reliable approval process.

Dependencies need extra effort

Excel has formulas and visual tools, but it does not provide the same dependency management experience as a dedicated project platform.

You may need helper columns, formulas, conditional formatting, and careful review to show predecessor relationships accurately.

Reporting is often limited

A single chart shows timing, but project leaders may also need workload, risk, issue, sprint, and progress views.

Creating each view manually can turn routine reporting into a recurring administration task. The more views you need, the more valuable connected project information becomes.

When to Move Beyond a Manual Chart

Excel remains practical when one person maintains a short plan with a few dozen tasks. Consider a dedicated project workspace when the schedule changes daily or several teams depend on it.

Warning signs

• People circulate different versions of the plan.
• Task owners cannot see updates quickly.
• Dependencies are tracked in comments or memory.
• Progress meetings spend more time checking dates than solving risks.
• Reports require repeated copying and formatting.
• Permission, audit, or self-hosting requirements are becoming important.

Here’s why: the chart itself is rarely the real problem. The bigger issue is maintaining reliable task relationships, ownership, status, and history as the project grows.

A small product launch might begin with 15 tasks in Excel. After adding design reviews, engineering work, testing, localization, approvals, and release preparation, the same plan may contain hundreds of linked activities.

Natural Gantt Chart Solution: ONES.com

ONES.com combines project management and knowledge management in one platform. ONES Project provides project planning and tracking, while ONES Wiki supports shared team knowledge. You can purchase them separately.

For teams that have outgrown manual timeline maintenance, ONES Project offers Jira-compatible workflows, reporting, sprint management, automation, and deployment choices that include Cloud, On-Premise, Private Cloud, and Air-gapped environments.

Core Capabilities

Manual schedule updates create cascading work

ONES capability: Custom workflows, fields, and automation help teams define how work moves between stages.

Result: Status transitions and routine actions require fewer manual updates, giving you a clearer project flow.

Basic charts do not show enough project context

ONES capability: ONES Project combines timeline planning with task details, ownership, status, sprint information, and reporting.

Result: You can review timing alongside the work details that explain why a task is late or blocked.

Complex dependencies are difficult to maintain in Excel

ONES capability: Jira-compatible project workflows support structured task relationships and configurable processes.

Result: Teams can manage dependent work in a more consistent way as the schedule grows.

Repeated reporting takes too much effort

ONES capability: Built-in reporting provides reusable views for progress, workload, and project status.

Result: You spend less time rebuilding charts for every meeting and more time discussing decisions.

Sprint work and long-term planning are disconnected

ONES capability: Sprint management works alongside broader project planning.

Result: Agile teams can connect near-term iteration work with release milestones and wider delivery goals.

Plugins increase maintenance overhead

ONES capability: Core project management functions are available natively, including workflows, fields, reporting, sprint planning, and automation.

Result: You may reduce the number of separate plugins needed to reproduce a complete planning environment.

Hosting restrictions limit platform choices

ONES capability: ONES.com supports Cloud, On-Premise, Private Cloud, and Air-gapped deployments.

Result: Teams can choose an environment that matches security, infrastructure, and network requirements.

Self-hosted teams need feature consistency

ONES capability: The self-hosted versions provide feature parity with the cloud version.

Result: You can select a controlled deployment without giving up the main project management capabilities.

Application Scenarios

Software release planning

A development team may begin with an Excel timeline for discovery, design, coding, testing, and launch. As sprint commitments and dependencies increase, ONES Project can connect task-level work with release planning.

Instead of rebuilding the chart after every sprint, the team can review project status through structured workflows and reporting.

Regulated or restricted environments

A team operating in an air-gapped environment may need project planning without an external cloud connection. An air-gapped ONES deployment supports that operational model while preserving core project capabilities.

This approach suits organizations that need tighter control over infrastructure and access.

Teams replacing Jira

A team searching for a Jira alternative may want familiar workflows without assembling many additional plugins. ONES Project supports Jira-compatible workflows, custom fields, sprint management, automation, and built-in reporting.

The team can evaluate the migration around its actual processes rather than recreating a timeline manually in Excel.

Common Challenges and Practical Solutions

Challenge: Dates display as numbers

Excel stores dates as serial values. If the date column is formatted incorrectly, the chart may show numbers instead of readable calendar dates.

Solution: Format the cells as dates before creating the chart. Then check the horizontal axis formatting after insertion.

Challenge: Tasks appear upside down

The first task often appears at the bottom because of Excel’s category-axis behavior.

Solution: Open the vertical axis settings and select Categories in reverse order. Confirm that the first activity now appears at the top.

Challenge: The chart includes too much empty space

A very early minimum date or distant maximum date can make the task bars look compressed.

Solution: Set sensible axis bounds around the project period. Leave a small margin for context, but remove unused months or years.

Challenge: Progress colors are confusing

Too many colors make the schedule harder to interpret. Team members may spend more time reading the legend than reviewing the plan.

Solution: Use a restrained color system. For example, gray can show planned work, blue can show active work, green can show completion, and red can show a blocked task.

Challenge: The schedule becomes outdated

A chart only helps when its dates and statuses remain current. A visually attractive plan can still mislead the team after several unrecorded changes.

Solution: Assign one person to maintain the schedule, define an update rhythm, and review changes during a regular planning meeting.

FAQs

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

Yes. You can build one manually with a task column, start dates, durations, and a stacked bar chart. Hide the start-date series, reverse the task order, and format the date axis. A template can save time, but it is not required. Building the chart yourself also helps you understand how the positioning and duration values work together.

Which Excel chart type works for a Gantt schedule?

A stacked bar chart is the standard choice. The first series represents the time before each task starts, while the second series represents its duration. You hide the first series so only the task bars remain visible. A regular bar chart cannot position activities along a timeline as effectively.

Can Excel show task dependencies?

Excel can show the timing created by dependencies, but it does not automatically manage those relationships in the same way as dedicated project software. You can add predecessor columns, formulas, arrows, or conditional formatting. For a complex plan, manual dependency maintenance may become difficult and prone to missed updates.

How do I show weekends in an Excel timeline?

Use calendar-day durations if weekends should appear as active timeline days. If your team works Monday through Friday, calculate durations with NETWORKDAYS. You can also format weekend columns or axis areas with a lighter shade. Choose one rule and explain it clearly so everyone interprets the schedule consistently.

Is Excel suitable for a large project?

It can work for a small team and a relatively stable plan. Larger projects often need stronger dependency management, permissions, history, workload reporting, automation, and collaboration. If several people update the schedule daily, a project platform may reduce administration and give you more reliable visibility than a manually maintained chart.

Conclusion

So, can you do a Gantt chart in Excel? Yes. A stacked bar chart, hidden start-date series, and visible duration series are enough to create a practical timeline.

Start with accurate dates, decide whether you are counting calendar or working days, add ownership, and test the formulas before sharing the schedule. Excel is a sensible option for small and straightforward projects.

But here’s the truth: a manual chart becomes harder to maintain as tasks, contributors, dependencies, and reporting needs increase. When that happens, a structured platform such as ONES.com can help you manage the work behind the timeline, not just the visual schedule.