How to Create a Gantt Chart in Excel: 10 Simple Steps [2026]

Creating a Gantt chart in Excel can feel harder than planning the project itself. You enter dates, add tasks, format bars, and still end up with a chart that is difficult to read. A small mistake in the timeline can also make completed work look late or upcoming work look finished.

That frustration grows when your project has dependencies, changing deadlines, or several people updating progress. Excel gives you flexibility, but it does not automatically build a clear project timeline.

But here's the truth: you can create a useful Gantt chart with a simple stacked bar chart and a few helper columns. In this guide, I’ll show you how to generate a Gantt chart in Excel through 10 practical steps, explain common formatting problems, and show when a dedicated project platform may save you time.

How to Generate a Gantt Chart in Excel in 10 Steps

A Gantt chart in Excel uses a stacked bar chart to show when each task begins and how long it continues. The first series creates invisible spacing, while the second series displays the visible task bar.

Here’s why: Excel does not offer a dedicated Gantt chart type in every version. However, the stacked bar method works reliably in current desktop versions and can be adapted for many project schedules.

1. Plan the information you need.

   Before opening Excel, decide which project details your timeline should show. At minimum, you need task names, start dates, and task durations.

   For a more useful schedule, add columns for task owners, status, priority, completion percentage, and dependencies. Keep the first version focused. You can add advanced tracking after the basic chart works.

2. Create the project schedule in a worksheet.

   Open a blank workbook and create these columns:

   • Task
   • Start Date
   • End Date
   • Duration
   • Owner
   • Status

   For example, a website launch might include “Research,” “Design,” “Development,” “Testing,” and “Launch.” Put one task on each row, beginning below the header row.

3. Enter start and end dates.

   Enter a calendar date for each task’s start and end. Use a consistent format, such as 1/5/2026 or Jan 5, 2026.

   Check that Excel recognizes the entries as dates. A quick test is to change the cell format to a date style. If the value behaves like text, the duration formula may not calculate correctly.

4. Calculate each task’s duration.

   In the first Duration cell, subtract the start date from the end date:

   =C2-B2+1

   Here, column B contains the start date and column C contains the end date. The +1 counts both the first and final day.

   If a task runs from January 5 through January 7, the result is three days. Without the extra one, Excel would return two days.

5. Choose whether weekends count.

   Calendar duration includes every day. If your team works only Monday through Friday, use a workday formula instead:

   =NETWORKDAYS(B2,C2)

   For a schedule with holidays, add a range containing non-working dates:

   =NETWORKDAYS(B2,C2,$H$2:$H$10)

   This approach helps when a project spans public holidays or planned office closures. Use the same rule across every task, or your timeline may become inconsistent.

6. Select the task, start date, and duration columns.

   Highlight the task names, start dates, and duration values. You can hold the Ctrl key while selecting separate ranges if the columns are not next to each other.

   Do not include the end date, owner, or status columns in the chart. The chart needs only the category labels and two numeric series: the starting position and the visible length.

7. Insert a stacked bar chart.

   Go to Insert, choose Bar Chart, and select Stacked Bar. Avoid the regular bar chart because it does not create the offset needed for a timeline.

   Excel will create two colored sections for each task. One section represents the start date, and the other represents the duration.

8. Make the start-date series invisible.

   Click one of the bars representing the start-date values. Open the formatting panel, choose Fill, and select No Fill. Remove the outline if Excel displays one.

   The remaining colored section now appears to float over the correct calendar position. This invisible series is the spacing mechanism behind the chart.

9. Reverse the task order.

   Excel often places the first task at the bottom. To restore the natural top-to-bottom order, right-click the vertical task axis and choose Format Axis.

   Enable Categories in reverse order. You may also need to adjust the horizontal axis so the earliest date appears on the left.

10. Improve readability and verify the timeline.

    Apply a clear color to the duration bars, remove unnecessary chart elements, and add a short title. Format the horizontal axis with a suitable date display.

    Finally, compare every bar with the schedule. Check that short tasks look short, long tasks look long, and the first task begins at the correct date.

Example Schedule for a Small Project

Imagine you are organizing a product release. Your worksheet might look like this:

The start-date values create the empty space before each task bar. The duration values create the visible work periods.

How to Add Today’s Date

You can add a vertical marker for the current date with a helper series. Create a new column called Today and enter:

=TODAY()

Copy the formula down the task rows, then add the series to the chart. Format it as a narrow line or a contrasting marker.

This works well for weekly reviews. You can immediately see which tasks should have started, which are active, and which remain in the future.

How to Show Progress

To show completion, add a Progress column with values such as 0%, 25%, 50%, or 100%. A simple chart can show planned duration, while conditional formatting in the worksheet shows progress.

For a more visual chart, calculate completed duration:

=D2*E2

Here, D2 is the total duration and E2 contains the completion percentage. You can add completed duration as another chart series, though the formatting becomes more complex.

Prepare Your Timeline Before Building the Chart

A Gantt chart is only as reliable as the schedule behind it. If task dates are vague, the visual timeline will create false confidence.

Start by defining the project outcome. Then break the work into tasks that have a clear beginning and end. “Build campaign” is broad, while “Approve campaign message” is easier to schedule.

Here’s an example. A mobile app launch might include requirements, interface design, coding, quality assurance, store review, and release. Each activity should have an owner and a date range.

Keep task names short enough to read beside the chart. If a name needs a full sentence, place the extra explanation in a nearby notes area rather than widening the chart excessively.

Use Consistent Time Rules

Decide whether your duration counts calendar days or working days. Calendar days suit events, travel, and construction work that continues throughout the week. Working days suit office projects with regular weekday schedules.

For example, a five-day design task may run from Monday to Friday. A five-calendar-day task beginning Friday may finish Tuesday, depending on your planning rule.

Write the rule near the schedule so everyone interprets the bars consistently.

Separate Milestones from Longer Tasks

A milestone is a point in time, such as approval, launch, or delivery. Give it the same start and end date.

Excel may display a one-day milestone as a very thin bar. You can make it clearer by changing its color or adding a diamond marker with a separate chart series.

Format the Chart for Fast Reading

A useful Gantt chart should answer three questions quickly: What needs to happen, when does it happen, and what is happening now?

Use one main color for planned work. Reserve another color for completed work or delayed tasks. Too many colors make the chart resemble a busy calendar rather than a project view.

Reduce the gap width between bars so related tasks appear as substantial timeline blocks. In Excel, right-click a bar, choose Format Data Series, and lower the gap width.

Set a Practical Date Range

Excel may choose a horizontal axis that begins before your project or extends far beyond its finish. Adjust the minimum and maximum bounds to focus attention on the active schedule.

For a January project, an axis covering December through April may waste valuable chart space. A narrower range makes task overlaps and gaps easier to notice.

Use Labels Carefully

Data labels can show duration, task status, or completion. Add them only when they improve understanding.

For example, labels showing “3 days” may help a short executive timeline. On a detailed schedule with 40 tasks, labels can overlap and reduce clarity.

Place the chart beside the worksheet rather than covering the cells that contain your planning information. You should be able to review the numbers and the visual timeline together.

Manage Dependencies, Changes, and Progress

A static Gantt chart shows timing, but project work changes. A delayed approval can push development, testing, and launch dates.

Excel will not automatically reschedule every dependent task when you change one date. You need formulas, manual updates, or a project platform that supports dependency logic.

For a small project, manual updates may be enough. For example, moving a three-task marketing campaign by two days is manageable when one person maintains the schedule.

For a larger project, repeated manual changes increase the chance of conflicting dates. A schedule that looks correct can still hide an outdated dependency.

Create a Basic Dependency Check

Add a Predecessor column that names the task that must finish first. Then compare the next task’s start date with the predecessor’s end date.

A simple check might use:

=IF(B3<C2,"Review timing","OK")

This formula flags a task that begins before the prior task finishes. It does not replace full dependency management, but it helps catch obvious overlaps.

Track Baseline and Current Dates

If your project changes often, keep the original start and end dates in separate columns. Add current dates beside them.

This lets you compare the planned schedule with the present schedule. A two-day shift becomes visible, even if the current timeline appears reasonable by itself.

Know When Excel Is the Right Choice

Excel works well for personal planning, small projects, simple schedules, and occasional presentations. It is familiar, flexible, and quick to customize.

It becomes harder to manage when several people edit the schedule, dependencies change regularly, or project information needs to connect with discussions and decisions.

Consider a team of 12 people managing 80 tasks. If every change requires one person to update dates, formulas, colors, and chart ranges, maintenance can consume more time than planning.

You might be wondering: when should you move beyond Excel? Look for warning signs such as repeated version conflicts, unclear ownership, missed updates, and limited visibility into project health.

Excel Strengths and Limitations

Natural Project Timeline Solution: ONES.com

ONES.com combines project management and knowledge management in one platform, with ONES Project providing project planning and ONES Wiki supporting team knowledge. ONES Project can serve as a Jira alternative for teams that need structured workflows and timeline visibility.

The platform may suit teams that have outgrown manually maintained Excel charts while still needing flexible workflows, reporting, and controlled deployment options.

Value Proposition

ONES.com helps you connect project work with the context behind that work. You can plan tasks, manage progress, and keep related team knowledge accessible without relying on numerous plugins.

Core Capabilities

• Scattered task information → unified project planning → clearer ownership and progress visibility.

• Manual timeline updates → sprint management and structured task workflows → fewer repeated scheduling adjustments.

• Inconsistent approval steps → custom workflows and fields → more predictable handoffs.

• Limited reporting in a basic chart → built-in reporting → faster reviews of project health and delivery trends.

• Repeated administrative work → automation rules → less time spent on routine updates.

• Heavy reliance on plugins → native project capabilities → fewer connected tools to maintain.

• Jira workflow migration concerns → Jira-compatible workflows → a smoother transition for teams evaluating a Jira alternative.

• Deployment restrictions → Cloud, On-Premise, Private Cloud, and Air-gapped options → greater control over where project work operates.

• Different capabilities across deployment models → full feature parity between cloud and self-hosted versions → more consistent planning and administration.

• Separate project and knowledge areas → ONES Project and ONES Wiki within ONES.com → easier access to decisions, procedures, and delivery work.

ONES Project and ONES Wiki are sold separately. ONES.com offers a free plan for up to 30 seats, which can help a small team test the workflow before making a larger commitment.

Application Scenarios

Growing software team: A development team may begin with an Excel Gantt chart, then add sprints, automation, reporting, and workflow rules as releases become more frequent. ONES Project can provide a more structured project view while retaining Jira-compatible workflows.

Restricted-network team: An organization working in a restricted environment may need an air-gapped deployment. A self-hosted ONES.com setup can support project planning where cloud access is unsuitable.

Cross-functional launch: Marketing, product, and engineering teams can connect launch tasks with related knowledge in ONES Wiki. This reduces the need to search through separate work areas for decisions and procedures.

Common Challenges When Building an Excel Gantt Chart

Challenge: The Bars Start on the Wrong Dates

Problem: Excel treats your dates as text, so the chart cannot position the bars correctly.

Solution: Re-enter the dates using a recognized date format. Test one cell by changing its format and checking whether the value aligns to the right by default. Then recalculate the duration column.

Challenge: Tasks Appear in Reverse Order

Problem: The first task appears at the bottom, making the schedule difficult to follow.

Solution: Open the vertical axis settings and enable Categories in reverse order. Review the horizontal axis afterward because Excel may reposition it.

Challenge: The Timeline Contains Large Empty Areas

Problem: The chart includes several weeks before the project begins or after it ends.

Solution: Adjust the minimum and maximum values on the horizontal axis. Use a range that gives the project enough breathing room without hiding important timing relationships.

Challenge: Weekend Calculations Create Confusion

Problem: A task expected to take five workdays appears to last seven calendar days.

Solution: Decide whether the schedule uses calendar or working days. Use NETWORKDAYS for weekday planning and include holiday dates when necessary.

Challenge: The Chart Becomes Difficult to Maintain

Problem: A few tasks are easy to manage, but a busy schedule requires constant formula, range, and formatting changes.

Solution: Keep Excel for smaller planning needs or move to a project platform when collaboration, dependencies, reporting, and workflow control become central requirements.

FAQs About Gantt Charts in Excel

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

Yes. You can build one manually with a task list, start dates, end dates, duration formulas, and a stacked bar chart. The start-date series becomes invisible, while the duration series remains visible. This method gives you more control than a ready-made template, although it requires several formatting steps.

What formula calculates task duration in Excel?

For calendar days, use =EndDate-StartDate+1. For example, if the start date is in B2 and the end date is in C2, use =C2-B2+1. For weekdays, use =NETWORKDAYS(B2,C2). Add a holiday range when public holidays should not count.

How do I show progress on an Excel Gantt chart?

Add a completion percentage column, then calculate completed duration by multiplying total duration by completion percentage. You can use conditional formatting in the worksheet or add another chart series. Keep planned and completed work visually distinct so the timeline remains easy to interpret.

Can Excel automatically update dependent tasks?

Excel can calculate dates with formulas, but it does not provide full project dependency management by default. You can create predecessor columns and timing checks for simple schedules. If many tasks depend on one another, manual adjustments become increasingly fragile.

How many tasks can an Excel Gantt chart handle?

There is no single practical limit. A chart with 10 to 30 tasks is usually easy to read. With 50 or more tasks, labels, overlapping bars, and long date ranges can reduce clarity. Consider grouping work into phases or using a project platform for detailed schedules.

Conclusion

To create a Gantt chart in Excel, prepare task names and dates, calculate duration, insert a stacked bar chart, hide the start-date series, reverse the task order, and format the timeline for quick reading.

The chart becomes more useful when you apply consistent workday rules, identify milestones, track progress, and review dependencies. It works especially well for small projects with limited collaboration.

But here's the truth: the chart itself will not fix unclear ownership or changing priorities. If manual updates begin causing missed dates, duplicated work, or confusing status reviews, a structured project platform may be the better next step.

Excel gives you a practical starting point. ONES.com can support the next stage when your team needs project workflows, reporting, automation, controlled deployment, and connected knowledge in one environment.