How to Create a Gantt Chart in Excel From Scratch [2026]

Building a project timeline in Excel can feel harder than it should. You may have tasks, dates, owners, and milestones, yet still struggle to turn them into a clear visual schedule.

That frustration grows when task names disappear, bars show the wrong length, or one date change forces hours of manual editing. A poorly structured chart can hide delays instead of helping you spot them early.

But you can create a useful Gantt chart from scratch with a regular Excel worksheet. You only need a task list, start dates, durations, and a stacked bar chart. This guide walks you through each step, explains the formulas, and shows how to keep the timeline readable during project changes.

How to Create a Gantt Chart in Excel From Scratch

A Gantt chart in Excel uses a stacked bar chart with two series: one invisible series positions each task on the timeline, while the visible series represents task duration.

Follow these steps to build one from a blank worksheet.

1. Create the project schedule table

Open Excel and create four columns with these headings:

• Task
• Start Date
• End Date
• Duration

Enter each project activity on its own row. For example, a website redesign might begin like this:

Keep task names short enough to display beside the chart. You can add owners, status, priority, or milestone columns later without changing the basic method.

2. Calculate the duration of every task

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

=C2-B2+1

Here, column B contains the start date and column C contains the end date. The extra one includes both the first and last calendar days.

For example, January 6 through January 9 equals four calendar days. Without +1, Excel returns three.

Copy the formula down the Duration column. If your schedule measures working days, use this formula instead:

=NETWORKDAYS(B2,C2)

This version excludes Saturdays and Sundays. You can also exclude holidays by adding a holiday range:

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

Use calendar days when elapsed time matters. Use working days when the schedule reflects team availability.

3. Select the start dates and durations

Highlight the Start Date and Duration columns together. Include the headings, but leave out the Task column for now.

For example, select B1:B5, then hold Control or Command while selecting D1:D5. You can also place the two columns beside each other in a helper area if selecting separate ranges feels inconvenient.

Here's why: Excel needs both numerical series to create the chart. The start-date series controls horizontal placement, while duration controls bar length.

4. Insert a stacked bar chart

With the two ranges selected, follow this menu path:

1. Open the Insert tab.
2. Choose Bar Chart.
3. Select 2-D Stacked Bar.

Excel creates a chart with two colored sections for each task. The first section represents the start date, and the second represents the task duration.

At this stage, the chart may look confusing. That is normal. You still need to hide the positioning series and connect the task labels.

5. Add task names to the vertical axis

Right-click the chart and choose Select Data. In the dialog box, find the category labels area and select the task-name range.

If the task names are in A2:A5, use that range for the vertical axis labels. Click OK until Excel returns to the chart.

Your task names should now appear along the vertical axis. Excel may show the first task at the bottom, which is common for bar charts.

6. Reverse the task order

Right-click the vertical axis and choose Format Axis. Under axis options, select Categories in reverse order.

This places the first task at the top and the final task at the bottom. The chart will then read in the same order as your schedule.

Let me explain: Excel draws horizontal bar categories from the bottom upward by default. Reversing the order makes the visual sequence feel natural.

7. Hide the start-date series

Click the first colored series in the chart. This series represents the start date and only positions the visible task bars.

Open the formatting options and set:

• Fill to No fill
• Border to No line

The start-date series disappears visually, leaving each duration bar in the correct position. It still performs its positioning role behind the scenes.

8. Format the horizontal date axis

Right-click the horizontal axis and choose Format Axis. Set the minimum bound to the first project start date.

Excel stores dates as serial numbers. If your first start date is January 6, 2026, Excel may show a number such as 46028. You can enter the date directly, or use the matching serial value displayed by Excel.

Adjust these settings for readability:

• Set the maximum bound close to the final project date.
• Use a major unit such as seven days for weekly planning.
• Set the number format to display short dates or month names.
• Reduce the chart gap width to make task bars thicker.

A weekly major unit works well for a one-to-three-month project. A monthly unit works better for a long program with many activities.

9. Add milestones and dependencies

Excel does not create dependency lines automatically in a basic Gantt chart. You can still show milestones with a small duration and a distinct color.

For a milestone, set the start and end dates to the same day. Then apply a contrasting fill color to its duration bar.

For example, “Client approval” could use February 6 as both dates. A one-day bar can represent the approval point without adding another chart type.

To show dependencies, add a predecessor column beside the task list. Enter the related task number or name, then review the schedule whenever a predecessor moves.

10. Add a chart title and legend

Click the chart title and rename it with a clear project name, such as Website Redesign Timeline.

Remove the legend if the invisible start-date series makes it confusing. You can also rename the visible series from “Duration” to “Task duration.”

Keep the design restrained. One color for regular tasks, one for milestones, and one for delayed work usually provides enough visual distinction.

Prepare the Schedule Before Building the Chart

A Gantt chart can only be as reliable as the schedule behind it. Before inserting the visual, clarify what each task means and when work can realistically begin.

Break large activities into visible work packages

“Launch marketing campaign” is too broad for a useful timeline. Break it into activities such as write campaign brief, design assets, configure landing page, review content, and launch campaign.

Each task should have a clear finish point. If you cannot tell whether an activity is complete, the task probably needs a narrower scope.

For example, “Build checkout” might become “Create checkout layout,” “Connect payment service,” “Test failed payments,” and “Approve release.” Each activity can then receive its own duration and owner.

Choose calendar days or working days

Decide whether durations include weekends before writing formulas. A construction schedule may use calendar days, while an office project often uses working days.

Mixing both approaches creates misleading bars. A task that takes five working days could appear as seven calendar days when the chart spans a weekend.

You might be wondering: which approach should you choose? Match the calculation to the question your team asks. If the question is “When will this finish?” working days may be useful. If it is “How long will the phase occupy the calendar?” calendar days may fit better.

Check dates for gaps and overlaps

Review consecutive tasks before creating the chart. A gap may represent planned waiting time, or it may indicate a missing activity.

Overlapping work can be efficient when two teams work independently. It can also create a bottleneck when both tasks require the same specialist.

For example, design and content writing may overlap. Final approval should probably wait until both activities finish.

Make the Excel Gantt Chart Easier to Read

A technically correct chart can still be difficult to use. The strongest improvements usually involve spacing, labels, colors, and a clear time scale.

Use color to communicate status

Apply one color to planned work, another to active work, and a third to delayed work. Avoid giving every task a different color because the chart becomes harder to scan.

Conditional formatting can help in the schedule area. For example, you can highlight an end date that falls before today while its task remains incomplete.

Here's why: a color rule draws attention to exceptions. Your team can focus on the few items needing action instead of inspecting every bar.

Display today’s date

Add a vertical reference line to show the current date. One practical method uses an extra series with today’s date and a large duration value.

Another method uses an XY scatter series placed over the bar chart. This requires more formatting, yet it gives you a precise “today” marker.

For a simpler chart, add a text box labeled “Today” near the correct position. Update it whenever the chart is reviewed.

Keep labels readable

Widen the chart area when task names are long. Increase the chart height when rows feel crowded.

Use a consistent date format, such as 6 Jan or Jan 6. Avoid showing full timestamps unless your schedule requires hourly planning.

For a chart with dozens of tasks, group activities by phase. Add summary rows for discovery, design, delivery, and launch, then place detailed activities below each phase.

Freeze the planning area

When your schedule grows, freeze the top row and the first task column. This keeps headings and task names visible while you review later dates.

You can also place the chart beside the schedule instead of below it. That arrangement lets you compare a task’s dates and its visual bar without constant scrolling.

Update and Maintain the Timeline

A Gantt chart becomes valuable during weekly planning, when you compare the intended schedule with actual progress. Treat maintenance as part of the planning routine.

Use an actual start and actual finish area

Add columns for Actual Start, Actual Finish, and Percent Complete. Keep planned dates unchanged so you can compare the original expectation with current performance.

For example, a task planned for January 12 through January 16 may actually begin January 14 and finish January 20. The difference reveals a delay without rewriting the original plan.

Show progress inside task bars

You can create a second duration series for completed work:

Completed Duration = Duration * Percent Complete

For a 10-day task that is 40 percent complete, the completed duration equals four days. Add this series to the chart and give it a darker color.

The remaining duration can use a lighter color. This creates a progress bar effect within the timeline.

Set a review rhythm

Review short projects once or twice each week. Longer programs may need a weekly review for active phases and a monthly review for distant work.

During each review, check three questions:

• Which tasks moved since the previous review?
• Which upcoming task depends on a delayed activity?
• Does the planned finish still match the project goal?

The chart should support a decision. If nobody acts after reviewing it, simplify the view or connect it to a specific planning meeting.

Excel Gantt Chart Limitations to Consider

Excel works well for a small project with a stable schedule. It becomes less convenient when many people update the timeline or when dependencies change frequently.

Manual dependency management

A basic chart does not automatically move connected tasks when one activity slips. You need formulas, macros, or manual adjustments to reflect those relationships.

For example, if testing must begin two days after development ends, changing the development finish date will not automatically reposition testing unless you build that logic.

Limited collaboration controls

When several people edit the same planning workbook, conflicting changes can be difficult to resolve. You may also lose track of why a date changed.

A shared planning platform can provide activity history, permissions, comments, and clearer ownership when the schedule becomes a team asset.

Large timelines become difficult to scan

A six-month chart with 100 tasks can become visually dense. Too many colors, labels, and summary rows reduce clarity.

Use separate views for executives, project leads, and contributors. An executive view might show phases and milestones, while a delivery view shows individual activities.

Project Timeline Solution: ONES.com

ONES.com is a unified platform for project management and knowledge management, powered by ONES Assistant. ONES Project is the project management product and can serve as a Jira alternative when a team needs structured planning beyond a manually maintained Excel chart. ONES Wiki is a separate knowledge management product and a Confluence alternative.

Value Proposition

ONES.com helps you move from a manually formatted timeline to a connected project workspace. You can manage tasks, workflows, reporting, and project knowledge in a controlled environment.

It may suit teams that need Jira-compatible workflows, on-premise deployment, or fewer separate plugins around their project process.

Core Capabilities

Manual chart updates create rework — ONES Project supports structured project planning — changes are easier to manage across active work.

When a date shifts in Excel, you may need to adjust formulas, bars, labels, and related activities. ONES Project keeps project work inside a purpose-built planning environment.

Complex approval paths are difficult to show — custom workflows represent review stages — teams can see where work is waiting.

For example, a release can move through development, quality review, security approval, and deployment without relying on color conventions alone.

Different work types need different fields — custom fields capture the details each team needs — project records become easier to filter and report.

A product team may track release risk, while an operations team tracks service impact. Custom fields let each group use relevant information.

Plugin-heavy setups increase administration — built-in reporting and workflow features reduce separate add-ons — teams can maintain a more consistent workspace.

This matters when several connected features are needed for planning, tracking, and reporting.

Sprint planning can feel disconnected from the broader timeline — sprint management links short delivery cycles with ongoing project work — teams gain a clearer view of near-term commitments.

You can plan sprint activities while keeping larger milestones visible to stakeholders.

Repeated actions consume time — automation handles routine transitions and notifications — team members spend less time on administrative updates.

For example, a completed review can trigger the next workflow stage or notify the responsible owner.

Restricted environments limit cloud choices — ONES.com supports cloud, on-premise, private cloud, and air-gapped deployments — organizations can select an environment that matches their security requirements.

The self-hosted versions provide full feature parity with the cloud version, which supports consistent workflows across deployment preferences.

Large teams may need a low-risk starting point — the free plan supports up to 30 seats — smaller groups can evaluate core project workflows before expanding.

This can be useful for a department moving away from manually maintained project schedules.

Application Scenarios

Software release planning: A development team can combine sprint management, custom workflows, automation, and reporting. Instead of manually checking whether each release task is ready, the team can follow defined workflow stages.

Regulated operations: An organization with restricted network requirements can use an on-premise or air-gapped deployment. Approval steps, ownership, and status remain within the chosen environment.

Cross-functional launch: Marketing, design, engineering, and support can track shared milestones while maintaining team-specific fields. Project leaders can review progress without asking each group to update a separate chart.

Common Challenges When Building a Gantt Chart in Excel

The bars begin at the wrong point

Problem: The task bars appear to start near the chart origin instead of matching their calendar dates.

Solution: Confirm that the start-date series remains in the chart and that its fill is transparent. Then set the horizontal axis minimum close to the earliest start date.

The first task appears at the bottom

Problem: The chart order looks opposite to your schedule.

Solution: Open the vertical axis settings and select Categories in reverse order. Review the result after applying the change because the axis may move across the opposite side.

Weekend calculations create unexpected finish dates

Problem: A five-day activity stretches across seven calendar days.

Solution: Decide whether the project uses calendar days or working days. Use NETWORKDAYS for working-day calculations and include a holiday range when necessary.

The chart becomes crowded

Problem: Long task names, narrow bars, and excessive colors make the timeline hard to read.

Solution: Group activities by phase, shorten labels, increase chart height, and reserve strong colors for milestones or exceptions.

Updates are easy to miss

Problem: The chart looks polished, yet nobody notices delayed tasks.

Solution: Add a review cadence, show a current-date marker, and use a status field. Connect the chart to a weekly decision rather than treating it as a static illustration.

FAQs About Excel Gantt Charts

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

Yes. You can create one from a blank worksheet using task names, start dates, end dates, and durations. Insert a stacked bar chart, use start dates as the positioning series, and use duration as the visible series. After hiding the positioning series, format the axes and labels. This approach gives you more control than a prebuilt template.

What formula calculates task duration in Excel?

For calendar days, use =End Date-Start Date+1. For example, if the start date is in B2 and the end date is in C2, use =C2-B2+1. For working days, use =NETWORKDAYS(B2,C2). Add a holiday range when public holidays should be excluded.

Why does Excel show numbers instead of dates?

Excel stores dates as serial numbers so it can calculate with them. If an axis displays numbers such as 46028, change the axis number format to a date format. You can use a short format like 6 Jan or a month format such as Jan 2026, depending on the timeline length.

Can an Excel Gantt chart show task dependencies?

It can show the schedule created by dependencies, but a basic chart does not draw or update dependency links automatically. Add a predecessor column and use formulas to calculate related start dates. For complex relationships, a project management platform may reduce manual maintenance.

How do I show progress on an Excel timeline?

Add a Percent Complete column and calculate completed duration with =Duration*Percent Complete. Add the completed duration as another chart series, then use a darker color for finished work and a lighter color for remaining work. Keep the original planned dates available for comparison.

Conclusion

Creating a Gantt chart in Excel from scratch requires four essentials: task names, start dates, durations, and a stacked bar chart. The invisible start-date series positions each task, while the duration series creates the visible timeline.

But here's the truth: the chart only helps when the schedule is clear and maintained. Break broad activities into measurable tasks, choose consistent day calculations, highlight exceptions, and review progress regularly.

For a small project, Excel can provide a practical visual plan. When dependencies, approvals, collaboration, or deployment controls become more important, a structured platform such as ONES.com can support the workflow beyond manual chart formatting.