How to Create an Excel Gantt Chart With Subtasks in 2026

Excel can build a useful Gantt chart, but subtasks make the process harder than placing bars on a timeline. Parent tasks, child tasks, dates, progress, and dependencies can quickly become confusing.

A poorly structured chart may hide delayed subtasks, misrepresent overall progress, or force you to rebuild the schedule whenever a date changes. That becomes frustrating when a project has several workstreams and dozens of activities.

But here's the truth: you can create a clear Excel Gantt chart with subtasks by organizing your schedule first, then using a stacked bar chart and consistent task formatting. This guide shows each step, including formulas, grouping methods, dependencies, and practical improvements for 2026.

How to Create an Excel Gantt Chart With Subtasks

An Excel Gantt chart with subtasks is a timeline that displays parent tasks and their smaller activities as horizontal bars. The start date controls each bar’s position, while the duration controls its length.

You can build one with a regular worksheet and a stacked bar chart. Excel does not offer a dedicated Gantt chart button, so you create the visual schedule by combining date calculations with chart formatting.

What You Need Before Building the Chart

Start with a simple schedule containing one row for every parent task and subtask. Avoid placing several activities in one cell because Excel needs separate rows to create separate bars.

Use these columns:

• Task ID: A short identifier such as 1, 1.1, or 1.2.
• Task name: The activity title people will recognize.
• Level: Parent task or subtask.
• Start date: The planned beginning date.
• End date: The planned finishing date.
• Duration: The number of calendar or working days.
• Progress: The completed percentage.
• Predecessor: An earlier activity that controls the start.

Step 1: Build a Hierarchical Task List

Enter parent tasks and subtasks in a logical order. For example, a website launch might use this structure:

Keep parent tasks visible above their children. This makes the chart easier to scan and preserves the relationship between a phase and its activities.

You can indent subtasks visually by selecting their task names and choosing Increase Indent from Excel’s alignment controls. Indentation improves readability, but the task ID should still show the hierarchy clearly.

Step 2: Enter Start and End Dates

Enter real dates rather than typing dates as plain text. Excel should recognize entries such as 3/2/2026 as dates.

Suppose the start date is in column D and the end date is in column E. In the Duration column, enter:

=E2-D2+1

The +1 includes both the first and last day. Without it, a task starting and ending on the same date would show zero days.

For a five-day workweek, use this formula instead:

=NETWORKDAYS(D2,E2)

To exclude holidays listed in cells J2:J15, use:

=NETWORKDAYS(D2,E2,$J$2:$J$15)

Choose one duration method for the entire chart. Mixing calendar days and working days can make bars appear longer or shorter than expected.

Step 3: Add Parent Task Dates

Parent task dates should usually cover the earliest subtask start through the latest subtask finish. You can calculate those dates automatically.

For a parent task whose subtasks appear in rows 3 through 5, use:

=MIN(D3:D5)

For the parent’s end date, use:

=MAX(E3:E5)

If your hierarchy changes often, use a task group column. For example, assign every activity under “Website research” the group name Research. Then use MINIFS and MAXIFS:

=MINIFS($D:$D,$C:$C,"Research")

=MAXIFS($E:$E,$C:$C,"Research")

These formulas help the parent bar update when a child activity moves. They also reduce manual corrections after schedule changes.

Step 4: Insert a Stacked Bar Chart

Excel needs two chart series to create the visual effect:

• Start series: Creates invisible space before each task bar.
• Duration series: Creates the visible task bar.

Select the Task Name, Start Date, and Duration columns. Then choose:

1. Open the Insert tab.
2. Select Bar Chart.
3. Choose 2-D Stacked Bar.
4. Confirm that task names appear on the vertical axis.

If Excel selects the wrong range, right-click the chart and choose Select Data. Add the Start Date and Duration columns as separate series.

Step 5: Hide the Start Date Series

Click the first series, which represents the start dates. Open Format Data Series, choose Fill, and select No Fill.

Remove the border as well. The remaining Duration series will appear to start on each task’s planned date.

This technique works because the invisible start series pushes every visible duration bar into the correct position along the horizontal date axis.

Step 6: Reverse the Task Order

Excel often places the first task at the bottom of a bar chart. To restore the natural top-to-bottom schedule order:

1. Right-click the vertical task axis.
2. Choose Format Axis.
3. Open Axis Options.
4. Select Categories in reverse order.
5. Set the horizontal axis to cross at the maximum category if needed.

Your first parent task should now appear at the top, followed by its subtasks and later phases.

Step 7: Format Parent Tasks and Subtasks

Use distinct colors to separate project phases from detailed activities. For example, use dark blue for parent tasks and light blue for subtasks.

Excel may apply one color to the entire Duration series. To format individual bars, click the series once, then click a specific bar again. Apply a different fill color to that single data point.

For larger schedules, add a helper column that categorizes rows as Parent or Subtask. You can create separate chart series for each category, which makes consistent formatting easier.

For example, create these helper columns:

Add both helper columns to the chart. Format the parent series with a stronger color and the subtask series with a lighter color.

Step 8: Add Progress Information

A basic Gantt chart shows planned timing, but progress adds an execution view. Add a Progress column using values such as 0%, 25%, 50%, 75%, or 100%.

You can calculate completed duration with:

=F2*G2

Here, column F contains total duration and column G contains progress. You can display completed work with a darker overlay, though this requires additional chart series and careful formatting.

Another practical option is conditional formatting. Apply green to completed rows, amber to active rows, and red to overdue rows.

For an overdue formula, assuming the end date is in E2 and progress is in G2, use:

=AND(E2<TODAY(),G2<100%)

Step 9: Add Milestones

Milestones have no meaningful duration, so they need a separate marker. Add a milestone column with the milestone date, then use a scatter series on a secondary axis.

For a simpler approach, create a one-day duration bar. Give it a contrasting color and label it with a diamond symbol in the task name.

Examples include:

• ◆ Research approved
• ◆ Design signed off
• ◆ Product released

Use milestones sparingly. If every activity has a marker, important decision points become harder to spot.

Step 10: Add Dependencies

A Gantt chart displays timing, but dependencies explain why one activity starts after another. Add a Predecessor column with references such as 1.1 or 2.1.

For a simple finish-to-start relationship, set the next start date equal to the predecessor’s end date plus one day:

=E5+1

If you want the next activity to begin on the same day, use:

=E5

For more complex projects, keep dependency logic separate from the chart. The chart should remain easy to read, while the task list holds the details.

Step 11: Add a Timeline and Today Marker

Format the horizontal axis with a date format such as mmm d or mmm-yy. Choose a major unit that matches the project length.

• Use daily labels for short projects.
• Use weekly labels for projects lasting one to three months.
• Use monthly labels for annual schedules.

A today marker helps you compare the plan with current progress. Add a vertical line using a small helper series positioned at TODAY(). Alternatively, apply a vertical border to the current date column in a calendar-style worksheet beneath the chart.

Step 12: Test the Chart Before Sharing It

Change one subtask’s start date and confirm that its bar moves. Extend its end date and check whether the parent task updates.

Then test these situations:

• A subtask is completed early.
• A subtask has no end date.
• A parent task has several children.
• A milestone occurs between two activities.
• A task crosses a month or year boundary.
• A holiday affects working-day duration.

If the chart remains readable after these tests, your structure is strong enough for routine planning.

How Parent Tasks and Subtasks Work Together

Parent tasks represent major phases, while subtasks represent the work required to complete each phase. The parent gives you a summary view, and the children provide execution detail.

For example, “Launch mobile app” might contain “Complete testing,” “Prepare store listing,” and “Approve release notes.” The parent covers the whole phase, while each subtask shows ownership and timing.

Here's why: a parent task should summarize its subtasks rather than compete with them. If the parent has separate dates that do not match its children, the chart can suggest progress that does not exist.

Use parent bars for phase-level communication. Use subtask bars for daily coordination, handoffs, and deadline tracking.

When to Use Summary Bars

Use a summary bar when several subtasks belong to one outcome. A product launch, hiring round, or marketing campaign usually benefits from this structure.

A summary bar should cover the complete range of its children. If the first subtask begins on April 3 and the final subtask ends on April 18, the parent should span April 3 through April 18.

Do not create a summary bar merely to make the chart look fuller. Each parent should answer a real planning question, such as, “When will research finish?”

How Much Detail to Include

Include enough detail for someone to assign, track, or review the work. A subtask should usually produce a clear result within a reasonable period.

“Build website” is too broad for a subtask. “Create checkout page layout” gives the team a more useful target.

If a task takes several weeks, consider dividing it into smaller activities. If it takes only a few minutes, keep it in a checklist rather than adding another chart row.

Useful Excel Formulas for Gantt Schedules

Formulas reduce manual updates. They also help the chart respond when dates, workdays, or progress change.

Working Days Versus Calendar Days

Calendar duration counts every date, including weekends. Working-day duration usually excludes Saturday and Sunday.

Suppose a task starts on Friday and ends on Monday. Calendar duration equals four days. Standard working-day duration equals two days.

Choose calendar days for construction, events, or support coverage. Choose working days for office activities with predictable weekday schedules.

Handling Blank Dates

Blank dates can create misleading bars or formula errors. Use an error-handling formula when dates may be missing:

=IF(OR(D2="",E2=""),"",E2-D2+1)

This keeps the Duration cell empty until both dates exist. It also prevents unfinished planning rows from appearing as completed schedule items.

Calculating Progress by Date

You can estimate time-based progress with:

=IF(TODAY()<D2,0,IF(TODAY()>E2,1,(TODAY()-D2+1)/(E2-D2+1)))

This calculates expected progress from the calendar. It does not prove that work is complete, so compare the result with a manually reported percentage.

Ways to Make the Chart Easier to Read

A technically correct Gantt chart can still fail if the timeline is crowded. Good design helps someone understand the schedule without studying every row.

Use a restrained color system. One color for parents, one for subtasks, one for milestones, and one warning color are usually enough.

The best part? Small formatting choices often deliver more value than complicated chart features.

Group Rows by Phase

Use Excel’s Outline feature to collapse and expand subtasks. Select the child rows, open the Data tab, and choose Group.

This lets you switch between a summary view and a detailed view. A manager can review major phases, while a project coordinator can expand the rows for daily work.

Freeze Important Columns

Freeze the task name and start date columns when the schedule extends across many months. You can still scroll through the timeline while keeping task labels visible.

Without frozen columns, you may see a colored bar but forget which activity it represents.

Use a Reporting Cutoff

Choose a regular update point, such as every Friday at 3 p.m. Update progress and dates around that time.

Consistent updates make comparisons meaningful. A chart updated randomly can show visual movement without revealing whether the project is improving.

Limit Visible Time Range

Show the active planning horizon rather than every possible date. A two-year timeline can make a three-month project look tiny.

Keep the full schedule available, but adjust the axis minimum and maximum for meetings. A focused view improves attention during reviews.

Common Mistakes When Building a Subtask Gantt Chart

Most problems come from inconsistent structure rather than difficult formulas. Catching them early saves significant rework.

Putting Several Subtasks in One Row

If “Write copy, design graphics, and approve layout” appears in one row, Excel cannot show separate timing or ownership.

Create three rows instead. Each activity can then have its own start date, duration, progress, and dependency.

Using Text Instead of Real Dates

Dates copied as text may look correct but fail in formulas. Test a date with:

=ISNUMBER(D2)

If the result is FALSE, convert the entry using Excel’s date conversion tools or re-enter it in a recognized format.

Showing Parent and Child Bars With Equal Weight

Equal colors and thickness can make the hierarchy disappear. Give parent tasks stronger visual weight and subtasks a lighter treatment.

You can also add a blank row between major phases. This creates visual separation without changing the schedule.

Ignoring Schedule Changes

A chart becomes unreliable when dates change but parent bars remain static. Use formulas for summary dates wherever practical.

After moving a child task, check the parent range immediately. A delayed subtask should be visible in the phase summary.

Overloading the Chart With Details

Owners, budgets, notes, risks, and dependencies may all matter, but placing every detail beside the timeline creates clutter.

Keep the chart focused on timing. Place extra information in adjacent planning columns or a separate worksheet view.

Excel Gantt Chart Alternative: ONES.com

Value Proposition

ONES.com combines project management and knowledge management in one platform, powered by ONES Assistant. ONES Project is its project management product and can serve as a Jira alternative.

ONES Project and ONES Wiki are sold separately, so you can choose the product that matches your planning and knowledge needs.

Core Capabilities

Manual chart maintenance

Pain: An Excel Gantt chart can require repeated date edits when subtasks move.

ONES capability: ONES Project supports structured tasks, subtasks, dependencies, sprint management, and custom workflows.

Result: Schedule relationships remain connected as work changes, reducing repetitive updates.

Limited workflow structure

Pain: A worksheet can show task timing but may not enforce review, approval, or release stages.

ONES capability: Custom workflows and fields let you define states, ownership, and required project details.

Result: Teams can follow a repeatable process instead of relying on colored cells and reminders.

Scattered progress reporting

Pain: Excel charts often need manual summaries for workload, status, and delivery trends.

ONES capability: ONES Project includes built-in reporting for project progress and operational review.

Result: You can review delivery information without rebuilding charts for every meeting.

Too many add-ons

Pain: Extra Excel templates, plug-ins, and connected services can increase maintenance work.

ONES capability: ONES Project includes native project functions such as automation, custom workflows, sprint management, and reporting.

Result: Common planning needs can stay within one project environment with fewer plug-in dependencies.

Compatibility concerns

Pain: Teams moving away from Jira may worry about changing familiar working methods.

ONES capability: ONES Project supports Jira-compatible workflows and is designed as a Jira alternative.

Result: Teams can preserve familiar process concepts while evaluating another project platform.

Self-hosting requirements

Pain: Some teams cannot place project information in a public cloud environment.

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

Result: Organizations can select an environment that fits security, network, and operational requirements.

Feature differences between deployment models

Pain: Self-hosted tools sometimes provide fewer capabilities than hosted editions.

ONES capability: ONES.com provides full feature parity between its cloud and self-hosted versions.

Result: Deployment choice does not require giving up core project functionality.

Small-team cost concerns

Pain: A team may need a structured project system without a large initial rollout.

ONES capability: The free plan supports up to 30 seats.

Result: A small team can evaluate structured project management before making a broader commitment.

Application Scenarios

Software release planning: A development team can organize epics, stories, testing activities, approvals, and release work in connected workflows. Sprint planning and reporting provide more structure than a manually updated timeline.

Restricted-network projects: An organization with strict network controls can evaluate an air-gapped or on-premise deployment. This supports project coordination where public cloud access is restricted.

Cross-functional launches: Marketing, product, design, and engineering teams can coordinate related work through subtasks, custom fields, and workflow stages. ONES Wiki can be added separately when the team needs a connected knowledge base.

Common Challenges and Practical Solutions

The parent bar does not match the subtasks

Problem: A parent task ends before one of its children, creating a misleading summary.

Solution: Calculate the parent start with MIN and the parent finish with MAX. Recheck the referenced child range after adding rows.

The chart becomes too crowded

Problem: Long task names, daily labels, and dozens of rows make the timeline difficult to scan.

Solution: Shorten task labels, group subtasks, freeze key columns, and change the axis to weekly or monthly labels.

Weekend work creates confusion

Problem: A task appears to take five days, but the team expects weekends to be excluded.

Solution: Use NETWORKDAYS and maintain a holiday range. Explain the duration rule near the schedule so everyone interprets it consistently.

Progress percentages seem unreliable

Problem: A task marked 80% complete may still block the project because its final approval is unfinished.

Solution: Track progress alongside acceptance criteria. A percentage should reflect meaningful completion, not only elapsed time.

Several people maintain different versions

Problem: Updates become inconsistent when different copies circulate among team members.

Solution: Keep one controlled workbook location and define who updates dates, progress, and dependencies. For frequent collaboration, consider a project platform with shared workflows.

FAQs

Can Excel create subtasks inside a Gantt chart?

Yes. Excel can display subtasks when each child activity has its own row, dates, duration, and chart series. Use task IDs such as 1.1 and 1.2, indent the names, and place them beneath the related parent task. A stacked bar chart can then show each subtask as an individual timeline bar.

How do I show parent tasks and subtasks with different colors?

Create separate helper columns for parent duration and subtask duration. Use formulas such as =IF(C2="Parent",F2,NA()) and =IF(C2="Subtask",F2,NA()). Add both columns as chart series, then apply a stronger color to parent tasks and a lighter color to subtasks.

Should a parent task include its subtasks’ weekends?

That depends on your planning method. If the project tracks calendar time, include weekends in the parent range. If the team works only on weekdays, calculate child durations with NETWORKDAYS. Use the same rule for parent and child activities to avoid inconsistent totals.

How can I make an Excel Gantt chart update automatically?

Use formulas for duration, parent start dates, parent end dates, progress checks, and overdue status. Convert the schedule range into an Excel table so new rows can inherit formulas. After adding a subtask, confirm that the chart range and parent formulas include the new row.

Can I add dependencies to an Excel Gantt chart?

Yes. Add a Predecessor column and use formulas that connect one activity’s start date to another activity’s finish date. For example, a follow-up task can start with =E5+1. Excel can display these relationships through dates, although dedicated project tools usually handle complex dependency networks more easily.

When should I use a project management platform instead?

Excel works well for small schedules, one-time planning, and teams comfortable with manual maintenance. Consider a project platform when you need shared updates, automation, workflow approvals, dependency tracking, reporting, or multiple deployment options. The deciding factor is usually how often the plan changes and how many people must coordinate it.

Conclusion

You can create an Excel Gantt chart with subtasks by building a structured task list, calculating durations, and using a stacked bar chart with an invisible start-date series.

• Give every parent task and subtask its own row.
• Use real Excel dates and consistent duration rules.
• Calculate parent dates from child activities.
• Format parents, subtasks, milestones, and warnings distinctly.
• Test the schedule after changing dates or adding work.

But here's the truth: a chart only helps when its structure reflects the real project. If subtasks are hidden, dates are stale, or progress is vague, the visual timeline can create false confidence.

Start with a small schedule, test the formulas, and expand only when each added row improves coordination. For projects requiring shared workflows, reporting, automation, or restricted deployment, ONES.com offers a structured alternative to maintaining the entire plan manually in Excel.