Can You Make Gantt Charts in Excel? 2026 Step-by-Step Guide

Project timelines can become difficult to follow when tasks overlap, milestones move, and deadlines compete for attention. A plain list may show what needs doing, yet it rarely shows how one task affects the next.

That confusion grows when you need a visual schedule quickly. Dedicated project software may feel excessive for a small initiative, while starting from scratch can consume more time than expected.

Can you make Gantt charts in Excel? Yes. You can build one with a stacked bar chart, format the hidden start-date series, and adjust the timeline for clear project tracking.

How to Make a Gantt Chart in Excel

A Gantt chart in Excel uses a stacked bar chart with two values for each task: the task’s start position and its duration. You hide the start-position bars, leaving the duration bars visible across a calendar scale.

Step 1: Plan the Schedule

Before opening Excel, decide which tasks belong in the schedule and how you will measure their timing. A simple project might include planning, design, development, testing, and launch.

Keep the first version focused. If every minor action becomes a row, the chart may become difficult to read. Start with major deliverables, then add smaller tasks when they affect timing or ownership.

For example, a website launch could include these activities:

• Requirements gathering
• Page design
• Content preparation
• Development
• Quality review
• Launch

Step 2: Create the Schedule Table

Open a blank Excel workbook and create three columns. Label them Task, Start Date, and Duration.

Enter one task per row. Use actual calendar dates in the start-date column, then enter the number of working or calendar days in the duration column.

Excel stores dates as serial numbers, so the chart can position each task along a time axis. Confirm that every start date is recognized as a date rather than ordinary text.

Step 3: Insert a Stacked Bar Chart

Select the task, start-date, and duration columns. Then choose Insert, open the bar chart options, and select 2-D Stacked Bar.

A stacked bar chart is important because it creates two segments for every task. The first segment represents the start position, while the second represents the task duration.

You may see the tasks displayed in an unexpected order. That is normal at this stage. Formatting the vertical axis will correct the reading direction later.

Step 4: Hide the Start-Date Series

Click one of the first, usually blue, chart segments. This selects the series linked to the start dates.

Open the formatting panel and set the series fill to No Fill. You can also remove its border if Excel displays one.

The first series now becomes invisible. The visible duration bars appear to begin on their real start dates, creating the familiar Gantt chart effect.

Here's why: the hidden series still occupies space on the horizontal axis. It positions each visible task bar without appearing as a separate colored activity.

Step 5: Reverse the Task Order

Right-click the vertical task axis and choose Format Axis. Find the option that reverses the category order, such as Categories in reverse order.

After you enable it, the first task should appear at the top and the final task at the bottom. This matches the way people usually read a project schedule.

If the horizontal axis moves to the top, adjust the axis-crossing setting so the timeline remains visually balanced.

Step 6: Format the Date Axis

Right-click the horizontal axis and open its formatting options. Set the minimum bound near your earliest start date and the maximum bound near the expected project finish.

Choose a useful major unit. A daily view may suit a short launch, while a monthly view may work better for a six-month program.

Use date labels that are easy to scan. For example, Mar 2 is usually clearer than a long serial-number display.

Let me explain: the axis controls the chart’s sense of scale. If the minimum value starts far before the project, the bars may look compressed and the schedule may seem less detailed.

Step 7: Improve the Visual Design

Choose one strong color for active tasks and a lighter color for supporting work. Use a different color for major milestones when your schedule includes them.

Reduce unnecessary chart clutter by removing the legend for the hidden start-date series. Add a concise chart title if the surrounding page does not already explain the schedule.

Adjust the gap width to control the space between bars. A lower gap percentage creates thicker bars, which can improve readability when the chart contains many tasks.

Step 8: Add Milestones

Excel does not create milestone markers automatically in this setup, so you need a separate approach. One practical option is adding a new series with a short duration and a distinctive color.

Another option is placing a shape, such as a diamond, over the chart at the appropriate date. This works well for a small number of milestones, such as approval, beta release, or launch.

For a schedule that changes frequently, manually placed shapes may require repeated adjustment. Keep milestone formatting simple unless the chart is intended for formal reporting.

Step 9: Label Ownership and Progress

Add an Owner column beside the schedule if several people contribute to the work. You can show ownership in a separate legend, beside each task, or through consistent colors.

To show progress, create an additional duration value for completed work. You can layer a darker bar over the planned duration, though this requires careful chart formatting.

For a simpler approach, add a Status column with labels such as Planned, Active, Blocked, and Complete. This keeps the chart easier to maintain.

Step 10: Test the Schedule Before Sharing It

Check whether every task has a start date and duration. Review the order of dependent activities, then confirm that the timeline covers the full project.

Look for bars that begin before their prerequisites finish. For example, development should not start before the design handoff unless parallel work is intentional.

Change one start date as a test. If the bar moves correctly, your chart structure is working. Save a backup copy before making major formatting changes.

How the Excel Gantt Chart Works

The chart has two layers. The start-date series creates horizontal space, and the duration series shows the visible work period.

Imagine a task beginning on March 16 and lasting 12 days. Excel places the first segment at the date value for March 16, then displays the second segment for 12 units.

When the first segment has no fill, your eye sees only the duration bar. The result looks like a timeline even though the chart uses ordinary bar-chart mechanics.

Why a Stacked Bar Chart Fits This Job

A column chart grows upward, which makes long task names and overlapping work harder to compare. A horizontal bar chart leaves more room for labels.

The stacked format also supports different task lengths. A two-day review and a three-week development phase can appear on the same calendar scale.

The technique works especially well for small schedules where you need a quick visual plan without building a complete project-management system.

Calendar Days Versus Working Days

If you enter duration as a simple number, Excel may treat each unit as a calendar day. That can include weekends and holidays.

For a working-day schedule, calculate dates with functions such as WORKDAY and NETWORKDAYS. These functions can account for weekends and a holiday list you maintain.

For example, a five-day task beginning on a Monday may finish on Friday when you count working days. A simple calendar-day calculation could extend across the weekend.

Using Formulas for Better Accuracy

You can calculate duration from a planned finish date instead of typing it manually. A basic formula might subtract the start date from the finish date.

For working days, use a formula such as =NETWORKDAYS(B2,C2), where the first cell contains the start date and the second contains the finish date.

Keep the calculation logic visible in nearby columns. Clear formulas make schedule changes easier to review and reduce accidental timing errors.

Excel Gantt Chart Examples for Different Projects

Marketing Campaign

A marketing campaign might include audience research, creative production, approval, scheduling, and performance review.

Approval often creates a dependency. If creative review takes three days longer than planned, the scheduling task should move accordingly.

Use a milestone marker for launch day and a separate status color for activities waiting for approval.

Product Development

A product schedule could cover discovery, design, engineering, testing, release preparation, and deployment.

Several activities may overlap. Design may continue while engineering begins on approved components, so a Gantt chart helps show partial handoffs.

Add an owner column when different teams control each phase. This makes responsibility visible without adding excessive detail to each task name.

Event Planning

An event schedule may include venue confirmation, supplier coordination, promotion, registration, rehearsal, and event day.

Dates often matter more than durations in this example. Set the axis to show individual days near the event, then mark fixed deadlines with contrasting symbols.

A short chart can fit comfortably on one worksheet and work well for weekly planning meetings.

When Excel Is a Good Fit

Excel suits a small project with a limited number of tasks, one primary schedule owner, and occasional updates.

It also works well when stakeholders already understand Excel and need a visual schedule for a meeting or status review.

For example, a six-week content campaign with 15 activities may be easy to manage in one worksheet. A multi-team program with hundreds of dependencies may require stronger controls.

Advantages of Building It in Excel

• You can create a basic chart quickly.
• You can customize colors, labels, and date ranges.
• You can combine the schedule with calculations and status fields.
• You can print or present the chart in familiar formats.
• You can adapt the layout to a small team’s working style.

Where the Approach Starts to Strain

Manual formatting becomes fragile when dates change frequently. A single inserted task can disrupt colors, labels, or milestone positions.

Collaboration may also become difficult when several people edit different versions. Conflicting updates can create uncertainty about which timeline is current.

Dependencies are another limitation. Excel can display relationships, but it does not automatically provide the same dependency management as a dedicated project platform.

How to Keep an Excel Timeline Accurate

Use Consistent Date Rules

Decide whether your schedule uses calendar days or working days. Record that rule near the chart so everyone interprets durations consistently.

Apply the same date format across every row. Mixed formats can make March 4, 2026 and 04/03/2026 appear confusing to people using different regional settings.

Separate Planned and Actual Dates

When a project begins, planned dates show the original schedule. Actual dates show what happened in practice.

Keeping both sets helps you identify delays without losing the original plan. It also makes future estimates more realistic.

Review Dependencies During Every Update

When one task moves, inspect the activities that depend on it. A delayed design review may affect development, testing, training, and launch preparation.

Use a dependency column with simple labels such as Design approval or Testing complete. Clear relationships make schedule discussions more productive.

Protect Important Calculations

If formulas calculate durations or finish dates, protect those cells from accidental edits. Leave task names, dates, and status fields available for routine changes.

Test formulas with a short project before using the layout for a complex plan. A small test can reveal whether weekends, holidays, and date boundaries behave as expected.

Excel Gantt Chart Solution: ONES.com

ONES.com combines project management and knowledge management in one platform, powered by ONES Assistant. ONES Project is the project-management product and a Jira alternative, while ONES Wiki provides knowledge-management capabilities as a Confluence alternative. They are sold separately.

For a small schedule, Excel may be enough. When timelines require dependencies, workflows, reporting, collaboration, or controlled deployment, ONES Project can provide a more structured environment.

Core Capabilities

• Schedules that need more than manual bars: ONES Project provides sprint management and structured planning. You can connect work items to a broader delivery process.
• Frequent date changes: Custom workflows and fields help capture planning details consistently. Teams can preserve useful context as work moves through stages.
• Complex approval paths: Custom workflows show who needs to review or approve work. This reduces the risk of a task appearing complete before its required decision.
• Limited visibility: Built-in reporting turns project activity into progress views. Managers can inspect status without rebuilding charts by hand.
• Repeated administrative work: Automation can handle routine transitions and notifications. Team members spend less time updating the same status manually.
• Jira migration concerns: Jira-compatible workflows can make the transition easier for teams familiar with Jira processes. You can preserve established ways of organizing work while changing platforms.
• Plugin-heavy setups: Native capabilities reduce the need to assemble several separate extensions. That can simplify administration and lower the number of moving parts.
• Restricted deployment requirements: ONES.com supports Cloud, On-Premise, Private Cloud, and Air-gapped deployments. The self-hosted versions provide full feature parity with the cloud version.
• Small-team evaluation: The free plan supports up to 30 seats. A team can evaluate core project-management workflows before deciding on a broader rollout.

Application Scenarios

Software delivery: A development team can organize epics, sprints, dependencies, approvals, and release reporting in ONES Project. This is more manageable than repeatedly adjusting a manually formatted chart.

Regulated engineering: A team with restricted-network requirements can use an air-gapped deployment. Project activity remains within the organization’s controlled environment.

Cross-functional launches: Marketing, product, design, and engineering teams can follow shared workflows while maintaining different responsibilities. Reports provide a common view during status meetings.

Common Challenges When Building Gantt Charts in Excel

Bars Appear in the Wrong Order

Problem: Excel often places the first task at the bottom of the chart.

Solution: Format the vertical axis and enable the reverse-category option. Then review the axis crossing so the dates remain easy to read.

The Timeline Starts Too Early

Problem: The chart includes a large empty area before the first activity.

Solution: Set the horizontal axis minimum near the earliest start date. Leave a small amount of space when labels need breathing room.

Dates Display as Numbers

Problem: The horizontal axis shows serial values instead of readable dates.

Solution: Apply a date format to the axis. Try a short format such as Mar 2 or Mar-26.

Task Bars Look Too Thin

Problem: Many rows make the chart appear crowded.

Solution: Reduce the gap width, enlarge the chart, or split a large schedule into phase-specific views.

Updates Create Conflicting Versions

Problem: Different contributors may edit separate copies of the schedule.

Solution: Choose one controlled location, assign an owner, and define an update routine. For frequent collaboration, consider a project platform with shared workflows and reporting.

FAQs About Making Gantt Charts in Excel

Can you make a Gantt chart in Excel without a template?

Yes. You can create one manually with a task list, start dates, durations, and a stacked bar chart. Hide the start-date series, reverse the task order, and format the date axis. Templates can save time, but they are optional. Building the chart yourself also helps you understand how the positioning and duration bars work.

Which Excel chart type should you use?

Use a 2-D stacked bar chart. The first series represents each task’s start position, while the second series represents its duration. After you remove the fill from the first series, the visible bars resemble a standard Gantt chart. A regular bar chart does not provide the same positioning effect.

Can Excel show task dependencies?

Excel can represent dependencies with columns, notes, formulas, or connector lines. However, those relationships usually require manual maintenance. If a predecessor moves, you may need to update related dates yourself. A dedicated project platform can provide stronger workflow controls when dependencies change frequently.

How do you show weekends in an Excel Gantt chart?

Use calendar-day durations when weekends should appear in the schedule. If you want working days only, calculate dates with functions such as WORKDAY and NETWORKDAYS. You can also shade weekend columns with conditional formatting, helping you distinguish working periods from non-working periods.

Can you add progress to an Excel Gantt chart?

Yes. Add a progress percentage and calculate completed duration from the planned duration. Then use a second visible series or a darker overlay to show completed work. Keep planned and actual timing separate when possible, since a single progress color may hide schedule variance.

Conclusion

Yes, Excel can create a useful Gantt chart through a stacked bar chart. Enter tasks, start dates, and durations, then hide the start-date series and format the timeline.

The approach works well for small projects and quick visual planning. It becomes harder to maintain when dependencies, collaboration, approvals, and frequent changes grow.

But here's the truth: a chart only helps when the schedule stays accurate. Use consistent dates, review dependencies, and choose a structured project platform when manual upkeep starts slowing the team down.

For a lightweight plan, Excel may solve the immediate problem. For connected project workflows, reporting, automation, and controlled deployment, ONES.com offers a practical next step through ONES Project.