Can You Create a Gantt Chart in Excel? 2026 Quick Guide

Yes, you can create a Gantt chart in Excel without buying dedicated project software. A stacked bar chart can turn task dates and durations into a clear project timeline.

But here's the problem: a regular Excel chart rarely looks like a proper schedule on the first attempt. Dates may appear in the wrong order, task bars can start at zero, and progress becomes difficult to track.

That frustration can waste more time than the chart saves. You may also end up manually adjusting the timeline whenever a deadline changes.

Here's the practical solution: build a small task table, calculate each task's start offset and duration, then format a stacked bar chart. I’ll show you the complete process, explain common mistakes, and help you decide when Excel is enough.

How to Create a Gantt Chart in Excel

You can create a Gantt chart in Excel by using a stacked bar chart with two values for each task: the number of days before work begins and the task duration.

Step 1: Prepare the Project Schedule

Start with a simple worksheet containing four columns:

• Task: The activity name.
• Start Date: The day work begins.
• End Date: The planned completion date.
• Duration: The number of calendar days required.

For example, your schedule might look like this:

In the Duration column, subtract the start date from the end date and add one day if both dates count toward the schedule.

A formula such as =C2-B2+1 calculates the duration when the start date is in column B and the end date is in column C.

Step 2: Add a Start Offset

A stacked bar chart needs a hidden first series to push each visible task bar to its correct starting position.

Add a column called Start Offset. Calculate it by subtracting the earliest project start date from each task's start date.

If the project begins on March 2, 2026, use a formula such as:

=B2-MIN($B$2:$B$5)

The first task will have an offset of zero. A task beginning four days later will have an offset of four.

After adding the new column, your table should contain:

Step 3: Insert a Stacked Bar Chart

Select the Task, Start Offset, and Duration columns. Leave the start and end dates out of the chart selection.

Then follow these steps:

1. Open the Insert tab in Excel.
2. Choose Bar Chart.
3. Select 2-D Stacked Bar.
4. Check that Excel uses tasks as the vertical category labels.

Excel will display two colored sections for every task. The first section represents the waiting period before work starts. The second section represents the actual task duration.

Step 4: Hide the Start Offset Series

Click one of the Start Offset sections in the chart. Open the formatting options and set its fill to No Fill.

Remove the outline as well if Excel displays one. The duration bars will remain visible, while their position stays anchored to the correct dates.

The chart now resembles a Gantt chart because each colored bar begins on its planned start date.

Step 5: Reverse the Task Order

Excel commonly places the first task at the bottom of a horizontal bar chart. Most project schedules read more naturally from the first task at the top.

To correct the order:

1. Right-click the vertical task axis.
2. Choose Format Axis.
3. Enable Categories in reverse order.
4. Adjust the horizontal axis if Excel moves it to an inconvenient position.

This small adjustment makes the chart easier to scan during planning meetings.

Step 6: Format the Timeline

Right-click the horizontal date axis and open its formatting settings. Set the minimum bound to the project start date, then choose a suitable major unit.

For a short project, use a one-day or two-day interval. For a six-month plan, weekly or monthly intervals usually work better.

You can also change:

• Bar color for the project phase.
• Gap width between task bars.
• Chart title and axis labels.
• Gridlines for easier date reading.
• Font size for task names.

The best part? You can keep the chart simple. A clear timeline with readable dates is more useful than a heavily decorated graphic.

Step 7: Add Progress Tracking

Excel does not automatically create a progress layer for this chart. You can add one by creating a second duration value for completed work.

For example, if the Development task lasts 15 days and is 40% complete, its completed duration is 6 days.

Use a formula such as:

=Duration*Progress%

Then add the completed duration as another series. Apply a darker color to completed work and a lighter color to planned work.

For a small project, this manual method is manageable. For a schedule with frequent updates, it can become tedious because each progress value needs regular maintenance.

Why Excel Works for a Basic Gantt Chart

Excel works because dates are stored as sequential numbers. A stacked bar chart can therefore treat a start offset as invisible space and a duration as a visible bar.

For example, if one task starts on day zero and another starts on day ten, Excel places the second bar ten units farther along the horizontal axis.

Here's why this matters: you do not need a special Gantt chart button. You need a chart type that can represent position and length at the same time.

The Two-Part Chart Logic

Every task uses two numerical values:

• Start Offset: The distance between the project start and the task start.
• Duration: The amount of time the task should remain visible.

The offset is hidden after the chart is created. The duration becomes the colored task bar.

Imagine placing sticky notes on a calendar. The offset tells you where to place each note, while the duration tells you how long each note should be.

When Excel Is a Good Fit

Excel is often suitable when you are planning a short initiative with a small team and limited dependencies.

Examples include:

• A two-week marketing campaign.
• A simple website redesign.
• A classroom event with ten activities.
• A home renovation with clear phases.
• A product launch involving a few departments.

It is also useful when stakeholders already understand Excel and need a quick visual overview.

How to Make the Timeline Easier to Maintain

A chart is only useful when the schedule behind it stays accurate. Use formulas, consistent date formats, and a small number of fields so updates remain manageable.

Use Formulas Instead of Manual Calculations

Calculate duration and start offsets with formulas. When a deadline changes, the chart can update after Excel recalculates the related values.

For example:

• Duration: =EndDate-StartDate+1
• Start Offset: =StartDate-EarliestProjectDate
• Completed Duration: =Duration*CompletionPercentage

Keep the earliest project date in one visible cell if you want to adjust the planning window easily.

Separate Planning Fields from Display Fields

Keep task names, owners, dates, percentages, and dependencies in organized columns. Use separate helper columns for the chart.

This makes the schedule easier to audit. If a bar appears too early, you can inspect the offset formula instead of guessing which chart setting is wrong.

Use Consistent Date Rules

Decide whether your schedule counts weekends and holidays. Calendar days and working days produce different results.

If you need working-day calculations, Excel functions such as NETWORKDAYS and WORKDAY can help. You can also list holidays in a dedicated range and exclude them from calculations.

For example, a five-day task beginning on Friday may finish on Thursday when weekends are excluded. The visual timeline should match the planning rule your team actually follows.

Keep the Chart Readable

A crowded chart becomes difficult to use. Group small activities into phases when individual bars do not add useful detail.

Use clear names such as “Approve homepage design” instead of vague labels such as “Design work.” A specific label helps everyone understand what completion means.

Common Excel Gantt Chart Problems

Most problems come from date formatting, chart selection, or hidden helper-series settings. The fixes are usually straightforward once you know what to inspect.

The Bars Begin at Zero

This happens when you chart only the duration values. Excel knows how long each bar should be, but it does not know when each task begins.

Add the Start Offset series and place it before Duration. Then hide the offset series after inserting the stacked bar chart.

The Tasks Appear in the Wrong Order

Excel reverses category order in many horizontal charts. Open the vertical axis settings and select Categories in reverse order.

If the date axis moves, change the axis crossing setting until the timeline appears in a natural position.

The Dates Show as Numbers

Excel may display dates as serial numbers when the axis format is set incorrectly. Open the horizontal axis settings and choose a date format such as month and day.

For a long project, use month labels. For a short project, a format such as Mar 2 is easier to read.

The Chart Does Not Update Correctly

Check whether the formulas point to the right cells. Also confirm that the chart series includes new rows after you add tasks.

Using an Excel Table for the schedule can help expand formulas and chart ranges more consistently.

The Schedule Becomes Too Large

Excel charts become harder to manage as task counts, dependencies, milestones, and status rules increase.

A 12-task plan may remain comfortable. A 200-task plan with several owners and weekly changes can require extensive manual upkeep.

Excel Gantt Charts Compared with Project Management Platforms

Excel gives you flexibility and quick setup. A project management platform gives you a more connected planning environment when tasks, conversations, approvals, and progress updates need to work together.

You might be wondering: when should you move beyond Excel? Consider switching when schedule changes happen daily, several teams share dependencies, or leadership needs reliable reporting.

The decision depends on coordination complexity rather than task count alone. A 20-task project with five dependent teams may need stronger controls than a 100-task personal plan.

Natural Gantt Chart Solution: ONES.com

ONES.com is a unified platform for project management and knowledge management, powered by AI through ONES Assistant. It includes ONES Project for project planning and ONES Wiki for connected team knowledge, and the products can be sold separately.

If Excel gives you a useful first timeline but becomes difficult to maintain, ONES Project offers a Jira alternative with built-in reporting, custom workflows, custom fields, sprint management, and automation.

Value Proposition

ONES Project helps you manage schedules inside a shared project workflow rather than rebuilding charts whenever plans change. It supports cloud and self-hosted deployment, including on-premise, private cloud, and air-gapped environments.

Core Capabilities

1. Manual timeline upkeep becomes repetitive → Gantt-style project views and structured task planning → Your schedule stays connected to task status and ownership.
2. Dependencies are difficult to track in Excel → Linked work items and workflow relationships → Teams can see how one activity affects the next.
3. Different teams use inconsistent processes → Custom workflows and fields → You can adapt project stages, approvals, and metadata to your operating model.
4. Sprint planning requires separate coordination → Built-in sprint management → Agile teams can plan iterations alongside broader project milestones.
5. Recurring updates consume administrative time → Automation rules → Routine status changes and workflow actions can happen with less manual effort.
6. Leadership lacks a consistent project view → Built-in reporting → Stakeholders can review progress, workload, and delivery signals in one environment.
7. Plugins create fragmented processes → Native project management capabilities → Teams may reduce the number of extensions needed for everyday planning.
8. Cloud-only tools conflict with security requirements → Four deployment choices: Cloud, On-Premise, Private Cloud, and Air-gapped → You can choose an environment that fits operational and compliance needs.
9. Migration from Jira creates workflow concerns → Jira-compatible workflows and ONES Project as a Jira alternative → Teams can preserve familiar planning concepts while evaluating a different platform.

ONES.com offers a free plan for up to 30 seats. Its self-hosted versions maintain feature parity with the cloud version, which helps teams avoid choosing between deployment control and core capabilities.

Application Scenarios

Software delivery: A development team can connect backlog items, sprints, testing work, approvals, and release milestones. Project leads gain a broader schedule view than a manually maintained Excel chart.

Restricted-network programs: A team working in an air-gapped environment can manage project activities without depending on public cloud access. The deployment model can align with strict network controls.

Cross-functional launches: Marketing, design, product, and operations teams can use custom workflows and shared reporting for one launch plan. ONES Wiki can hold supporting procedures and team knowledge beside project work.

Common Challenges and Practical Solutions

Challenge: Your Chart Does Not Show Dependencies

Problem: Two bars may appear beside each other even when one task cannot begin until another finishes.

Solution: Add a dependency column, review predecessor dates, and update start dates when upstream work changes. For complex dependency networks, use a project platform with linked work items.

Challenge: Weekends Distort the Schedule

Problem: A task planned for five working days appears to last seven calendar days.

Solution: Decide whether the chart should show calendar days or working days. Use working-day formulas and label the timeline clearly so stakeholders understand the calculation.

Challenge: Progress Becomes Outdated

Problem: The chart looks polished, but completion percentages are several days old.

Solution: Set a regular update routine. Assign an owner for status maintenance and use a shared project system when several people need to report progress.

Challenge: The Chart Contains Too Much Detail

Problem: Dozens of small bars make the schedule difficult to scan during meetings.

Solution: Create separate views for executives, project leads, and delivery teams. Show major phases in the overview and keep detailed activities in the working plan.

Challenge: Multiple Versions Cause Confusion

Problem: Different team members refer to different schedules after several rounds of edits.

Solution: Establish one maintained schedule, record update dates, and control editing rights. A shared project workspace can reduce conflicting copies and improve visibility.

FAQs About Making a Gantt Chart in Excel

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

Yes. You can build one manually with a stacked bar chart. Create columns for task names, start dates, end dates, duration, and start offset. Chart the offset and duration, then hide the offset series. Templates can save setup time, but they are optional.

Which Excel chart type should I use?

Use a 2-D Stacked Bar chart. A regular bar chart cannot place each task at a different start date. The stacked format provides an invisible offset section and a visible duration section, which creates the timeline effect.

Can Excel show task dependencies?

Excel can represent dependencies through formulas, predecessor columns, and linked dates. However, you must design and maintain those relationships yourself. If a project has many dependencies, frequent changes, or several contributors, a dedicated project management platform may be easier to control.

Can I track task completion in an Excel Gantt chart?

Yes. Add a completion percentage and calculate completed duration. Then add that value as another chart series with a contrasting color. This method works for small schedules, although regular manual updates can become time-consuming as the project grows.

Should I use calendar days or working days?

Choose calendar days when the schedule includes weekends or continuous activity. Choose working days when tasks follow a Monday-to-Friday pattern. Use Excel functions such as NETWORKDAYS when you need to exclude weekends and selected holidays.

When should I move from Excel to project software?

Consider a project platform when you need live collaboration, dependency management, automated workflows, reusable reporting, permission controls, or frequent status updates. Excel remains practical for quick planning, small initiatives, and situations where a simple visual timeline is all you need.

Conclusion

Yes, you can create a useful Gantt chart in Excel with a stacked bar chart. The essential steps are simple: calculate each task’s duration, calculate its start offset, chart both values, hide the offset, and format the timeline.

But here's the truth: Excel works best when the schedule is small, changes are limited, and one person can maintain the calculations. Dependencies, progress tracking, collaboration, and reporting add effort quickly.

If your project has become difficult to coordinate, ONES.com can provide a more connected environment through ONES Project, its Jira alternative for structured project management. You can start with Excel for a quick timeline, then choose a platform when manual upkeep begins slowing the work down.