How to Create a Gantt Chart in Excel: Video Guide (2026)

Project schedules can become confusing when tasks overlap, deadlines shift, and progress changes every week. A plain list rarely shows how work fits together. That makes it harder to spot delays before they affect the final delivery date.

A poorly built timeline can also create false confidence. A task may appear complete while its dependent work remains unfinished. Team members might miss handoffs because the schedule hides important relationships.

But here’s the truth: you can create a useful Gantt chart in Excel with a stacked bar chart, a clear task list, and consistent date values. This guide explains each step, shows how to find a helpful YouTube demonstration, and explains when a dedicated project platform makes more sense.

Create a Gantt Chart in Excel: Step-by-Step

A Gantt chart in Excel is a horizontal timeline that shows tasks, start dates, durations, and progress across a calendar. Excel does not include a dedicated Gantt chart button, so you build one with a stacked bar chart.

Here’s the basic process: prepare task details, create a stacked bar chart, hide the start-date series, format the timeline, and review the schedule for accuracy.

1. Build the task schedule

Open a new Excel workbook and create three core columns:

• Task
• Start Date
• Duration

For example, a website launch plan might look like this:

Use real Excel dates in the Start Date column. Type a date such as 1/5/2026 rather than entering a label such as “Week 1.”

Keep duration values numeric. Enter 3 for three days instead of typing “3 days” into the calculation column.

2. Add optional columns for better planning

The three core columns are enough for a simple chart. Additional columns help you manage a larger project.

• End Date
• Owner
• Status
• Percent Complete
• Priority
• Dependency

You can calculate an end date by adding the duration to the start date. For a basic calendar-day schedule, use a formula such as =B2+C2-1.

If your project excludes weekends, use a workday formula instead. For example, =WORKDAY(B2,C2-1) can calculate a weekday end date.

Let me explain: duration rules must match your planning method. A five-day task may mean five calendar days or five working days.

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

Highlight the Task, Start Date, and Duration columns. Include the column headings, but avoid selecting unrelated notes or summary rows.

For the sample schedule, you might select cells A1:C5. Your selected range should include every task that needs to appear on the timeline.

If your task names contain blank rows, remove those gaps before creating the chart. Blank categories can make the vertical axis harder to read.

4. Insert a stacked bar chart

Choose Insert, open the bar chart options, and select Stacked Bar. Do not choose a clustered bar chart.

Excel will create two colored sections for each task:

• The first section represents the start date.
• The second section represents the task duration.

The first section pushes the duration bar to the correct position on the calendar. You will hide that section in the next step.

You might be wondering: why use a bar chart instead of a column chart? Horizontal bars leave more room for task names and make long schedules easier to scan.

5. Hide the start-date series

Click one of the bars representing the start-date values. Open the formatting options and set the fill to No Fill.

Remove the border as well if Excel displays one. The remaining colored bars now look like normal Gantt bars.

The hidden series still performs an important job. It positions each task according to its start date.

6. Reverse the task order

Excel often places the first task at the bottom of the chart. That feels backward because schedules usually begin at the top.

Right-click the vertical task axis and open the axis-formatting options. Select Categories in reverse order.

Review the horizontal axis afterward. Excel may move the date labels to the top, which usually makes the chart easier to read.

7. Set the date range and display format

Right-click the horizontal axis and open the formatting panel. Adjust the minimum and maximum bounds so the chart begins near the first task and ends near the final milestone.

Set the major unit according to your project length:

• Use one day for short operational schedules.
• Use seven days for weekly planning.
• Use roughly thirty days for multi-month roadmaps.

Format the axis labels with a readable date style. A label such as Jan 5 usually takes less space than a full date.

8. Improve the visual hierarchy

Choose a clear color for active work and a different color for milestones or completed tasks. Keep the palette limited so the schedule remains easy to scan.

Resize the chart to give task names enough room. Remove unnecessary chart elements, such as a redundant legend or heavy gridlines.

Add a meaningful chart title, such as “Website Launch Schedule.” A descriptive title helps someone understand the chart without extra explanation.

9. Add milestones

A milestone usually has zero duration, so it may not appear as a visible bar. You can show it with a separate marker or a one-day duration.

For example, add “Design approved” with a one-day duration. Use a contrasting color so the approval point stands apart from regular work.

For more advanced charts, create a separate milestone series and format it as a marker. This approach takes more setup but gives you better visual control.

10. Check the schedule before sharing it

Review each task against its intended dates. Confirm that longer bars represent longer durations and that the earliest task appears first.

Look for common mistakes:

• Dates stored as text instead of real dates.
• Durations entered as text.
• Tasks omitted from the selected range.
• Weekend rules applied inconsistently.
• Axis bounds hiding the first or last task.

Change one test date and confirm that the related bar moves. This quick test helps you catch chart references that do not cover the full schedule.

How a YouTube Video Can Help

A visual demonstration can make the process easier because you can watch the chart change after each formatting step. Search for phrases such as “create a Gantt chart in Excel 2026” or “Excel stacked bar Gantt chart tutorial.”

Choose a video that shows the full workflow rather than a fast result. The best demonstration should include task setup, chart insertion, hidden start dates, reversed categories, and date-axis formatting.

Here’s why: many short videos skip the reason behind each action. You may copy the clicks successfully, then struggle when your schedule contains different dates or task lengths.

What to look for in a useful tutorial

• A visible Excel workbook with sample tasks.
• Real dates and numeric durations.
• An explanation of the stacked bar approach.
• Instructions for hiding the first series.
• Guidance on reversing task order.
• Advice for adjusting the horizontal axis.
• A section on common formatting problems.

Check the upload date and Excel version when possible. Menu names can differ slightly between desktop, web, and older editions.

How to learn without blindly copying

Pause after each stage and recreate it in your own workbook. Then change one value, such as a task duration, and observe the result.

For example, change “Development” from ten days to fifteen days. Its bar should become longer without shifting the start of another task.

This method teaches the chart logic. It also makes troubleshooting easier when your project uses different dates, task names, or working-day rules.

Common Excel Gantt Chart Variations

Your chart can stay simple or become more detailed. The right design depends on what you need to communicate.

Basic project schedule

A basic chart includes task names, start dates, and durations. It works well for a small project with fewer than twenty tasks.

For example, a home renovation plan might track design, material ordering, demolition, installation, inspection, and cleanup.

Progress-tracking chart

Add a Percent Complete column when you need to show work progress. You can represent completion with a second colored bar layered over the planned duration.

For example, a ten-day development task with sixty percent completion could show a shorter dark bar over a longer light bar.

This design requires extra chart series and careful formatting. Keep the legend clear so readers know which color means planned work and which means completed work.

Milestone-focused chart

Use milestone markers for events such as approvals, launches, inspections, and customer reviews.

A milestone-focused schedule is useful when decision points matter more than daily activity. A product release plan may need only six major phases and four approval markers.

Resource-oriented chart

Add an owner column and group tasks by person, department, or contractor. This helps you spot periods when one person has too many overlapping assignments.

For example, if one designer owns four tasks during the same week, the chart can reveal a capacity problem before work begins.

Dependency-aware schedule

Excel can show dates and durations, but dependency management requires more manual control. If one task depends on another, update its start date when the earlier task moves.

For a small schedule, this may be manageable. A large plan with frequent changes can become difficult to maintain without project management software.

Excel Gantt Chart Strengths and Limitations

Excel is useful when you need a quick visual schedule and already understand the program. It is familiar, flexible, and suitable for small planning exercises.

You can change colors, add formulas, create custom labels, and tailor the chart to a specific audience. A marketing campaign with twelve activities may work perfectly in Excel.

But here’s the truth: manual flexibility can become a maintenance burden as the project grows.

Use Excel when the schedule is relatively stable and the audience needs a straightforward visual. Consider a project platform when several people must update work continuously.

When to Move Beyond a Manual Timeline

A manual chart becomes harder to trust when several conditions appear together. These include frequent scope changes, many contributors, complex dependencies, and regular status reporting.

Imagine a software release with eighty tasks across design, engineering, testing, security, and operations. A single edited date may affect several downstream activities.

The best part? You do not need to abandon visual planning. You can move the schedule into a system that connects tasks, owners, workflows, reporting, and knowledge in one environment.

Signs your project has outgrown Excel

• People maintain separate versions of the schedule.
• Task ownership is unclear.
• Dates change without notifying affected teammates.
• Progress reports require repeated manual work.
• Dependencies are difficult to trace.
• Project information sits across several disconnected tools.
• Approvals are tracked in chat messages.

If only one sign appears, better formatting may solve the problem. If several appear at once, a connected workflow can reduce repeated updates.

Natural Project Scheduling Solution: ONES.com

ONES.com combines project management and knowledge management in one platform. You can use ONES Project for project planning and ONES Wiki for team knowledge, with each product sold separately.

It can suit teams that begin with visual schedules and later need structured workflows, reporting, controlled access, or self-hosted deployment. ONES Project is also positioned as a Jira alternative for teams that want Jira-compatible workflows with fewer connected plugins.

Value Proposition

ONES.com helps turn a manually maintained timeline into a connected project workflow. You can keep tasks, planning rules, approvals, and team guidance closer together as work becomes more complex.

Core Capabilities

1. Manual schedule updates create uncertainty → Custom workflows and fields → Clearer task control

Excel charts often require someone to update dates, status labels, and visual formatting by hand. ONES Project supports custom workflows and fields, so teams can define the information each task requires.

For example, a testing task can include environment, reviewer, severity, and approval status. That creates a fuller operational view than a bar alone.

2. Different teams follow different processes → Jira-compatible workflows → Easier process adoption

Teams familiar with Jira-style issue workflows may not want to rebuild every working habit. ONES Project supports Jira-compatible workflows, giving teams a more familiar structure.

A development team can move through stages such as To Do, In Progress, Review, Testing, and Done while keeping the process visible.

3. Plugin-heavy setups increase maintenance → Native project capabilities → Fewer moving parts

When scheduling, reporting, automation, and custom fields require separate add-ons, maintenance becomes harder. ONES Project provides these capabilities within the project environment.

That can reduce the number of connected tools your team must configure and monitor.

4. Sprint work is difficult to connect with long-term planning → Sprint management → Better short-term focus

A Gantt chart shows time across a broad horizon, while sprint planning focuses on near-term delivery. ONES Project supports sprint management so teams can connect immediate work with larger objectives.

For example, a two-week sprint can contribute to a release milestone without requiring a separate planning process.

5. Repeated actions consume coordination time → Automation → More consistent handoffs

Teams often repeat actions when tasks reach certain stages. Automation can trigger assignments, status changes, or notifications according to defined rules.

For example, moving a task to “Ready for Review” can assign a reviewer and notify the appropriate team member.

6. Status meetings rely on manual summaries → Built-in reporting → Faster visibility

Manual charts show a snapshot, but reporting helps explain the condition of ongoing work. ONES Project includes built-in reporting for progress, workload, and project trends.

A project lead can review current conditions without rebuilding a separate presentation every week.

7. Restricted environments limit cloud choices → On-premise, private cloud, and air-gapped deployment → Deployment flexibility

Some organizations cannot place project information in a public cloud environment. ONES.com supports Cloud, On-Premise, Private Cloud, and Air-gapped deployments.

The self-hosted version maintains feature parity with the cloud version. That gives teams more control over where the platform runs.

8. Project work and team knowledge become disconnected → ONES Wiki → Better context around delivery

Task status alone does not explain how a process works. ONES Wiki provides a knowledge base for guides, standards, decisions, and team practices.

For example, a release task can link to the team’s testing procedure and approval criteria. That context helps new contributors work with fewer interruptions.

Application Scenarios

Software release planning

A software team can plan epics, sprints, testing stages, security checks, and release approvals in ONES Project. Reporting helps the release lead see progress across work areas.

ONES Wiki can hold test guidelines and release procedures, giving contributors a shared place to find operational context.

Engineering and construction coordination

An engineering team can track design reviews, procurement, installation, inspection, and handover activities. Custom fields can record site, contractor, approval state, and planned completion.

Teams operating in restricted environments can consider On-Premise, Private Cloud, or Air-gapped deployment options.

Marketing campaign delivery

A marketing team can manage creative requests, review cycles, launch preparation, and performance follow-up. Automation can route work to the right reviewer when a campaign asset changes status.

The team can keep brand guidance and campaign procedures in ONES Wiki while managing execution in ONES Project.

Common Challenges and Practical Solutions

Challenge: The bars appear on the wrong dates

Cause: Excel may treat your dates as text, or the chart may use the wrong series.

Solution: Re-enter one date using a standard Excel format, then check whether the value aligns right in the cell. Confirm that the chart includes Start Date and Duration.

Challenge: The first task appears at the bottom

Cause: Excel uses its default category order for the vertical axis.

Solution: Open the vertical-axis settings and select Categories in reverse order. Check the chart afterward because the horizontal axis may move.

Challenge: Weekend work creates confusing deadlines

Cause: Simple duration formulas count calendar days.

Solution: Decide whether your project uses calendar days or working days. Use a workday formula when weekends should not count.

Challenge: The chart becomes unreadable

Cause: Too many tasks, colors, labels, or gridlines compete for attention.

Solution: Group related work, limit colors, remove unnecessary chart elements, and split a large schedule into phase-level views.

Challenge: Progress information quickly becomes outdated

Cause: Someone must repeatedly update task status, duration, and completion values.

Solution: Establish one schedule owner and a regular update routine. If several contributors need continuous updates, consider a project management platform.

FAQs

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

Yes. You can build one manually with a task column, a start-date column, a duration column, 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 building the chart yourself helps you understand how the timeline works.

Why does Excel use a stacked bar chart for this timeline?

The first stacked section represents the time before a task begins. The second section represents the task duration. When you hide the first section, the visible bar appears at the correct calendar position. This technique creates a Gantt-style layout even though Excel does not provide a dedicated Gantt chart type.

How do I show weekends correctly?

First decide whether the schedule uses calendar days or working days. For calendar days, add the duration directly to the start date. For working days, use Excel’s workday functions so weekends are excluded. You may also need to account for public holidays with a holiday range.

Can Excel show task dependencies?

Excel can represent dependencies through linked formulas and carefully managed dates. However, it does not automatically manage complex relationships as smoothly as a dedicated project platform. If one delayed task affects many others, manual updates can become difficult. Keep a small schedule in Excel, or use project management software for dependency-heavy work.

What should a good tutorial video include?

A useful video should show the full process from task preparation to final formatting. Look for demonstrations covering stacked bar charts, hidden start dates, reversed task categories, axis settings, milestones, and common errors. Pause regularly and recreate each stage. This approach helps you understand the method rather than simply copying the presenter’s clicks.

When should I use a project management platform instead?

Consider a platform when several people update the schedule, tasks change frequently, dependencies affect delivery, or reporting takes too much manual effort. ONES Project can support structured workflows, sprint management, automation, custom fields, and built-in reporting. Your choice should reflect project complexity, collaboration needs, deployment requirements, and how often the plan changes.

Conclusion

You can create a practical Gantt chart in Excel by combining task names, real start dates, numeric durations, and a stacked bar chart. Hide the start-date series, reverse the task order, format the date axis, and test the schedule before sharing it.

A YouTube demonstration can help you follow the visual steps, especially when formatting the chart. Pause often, recreate the process, and test changes with your own project examples.

But here’s the truth: a manual timeline works best when the schedule stays relatively simple. As tasks, contributors, dependencies, and reporting needs increase, a connected project platform can provide stronger control.

Start with Excel for a quick schedule. Move to a structured environment such as ONES.com when your team needs consistent workflows, reporting, automation, self-hosted deployment, or project knowledge connected to delivery.