How to Make a Gantt Chart in Excel With Dates: Step-by-Step

Building a Gantt chart in Excel can feel harder than it should. Dates, task lengths, overlapping work, and progress updates quickly turn a simple schedule into a confusing visual.

The frustrating part is that Excel does not include a one-click Gantt chart type. You need to combine a stacked bar chart with carefully arranged start dates and durations.

But here's the truth: once you understand that structure, you can create a clear project timeline in minutes. This guide shows you how to prepare your dates, build the chart, format the calendar, and keep the schedule useful as work changes.

How to Make a Gantt Chart in Excel With Dates

A Gantt chart in Excel uses a stacked bar chart to show task start dates, durations, and deadlines across a calendar timeline. The first bar positions each task on the timeline, while the second bar displays how long the task lasts.

You can create one with a task list containing four essential fields:

• Task name
• Start date
• End date
• Duration

Here is the complete process.

Step 1: Create the Project Schedule

Open Excel and create four columns. Use clear headings such as Task, Start Date, End Date, and Duration.

For example, a website launch schedule might look like this:

Enter actual Excel dates rather than typing dates as plain text. Excel should recognize a valid date and usually align it to the right automatically.

Step 2: Calculate Each Task Duration

Duration is the number of calendar days between the start date and the end date. In the Duration column, subtract the start date from the end date and add one.

If the start date is in cell B2 and the end date is in cell C2, enter:

=C2-B2+1

The +1 includes both the first and final days. For example, a task running from April 1 through April 2 lasts two calendar days.

Copy the formula down the column for every task. If you want to count only working days, use:

=NETWORKDAYS(B2,C2)

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

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

Choose one method before creating the chart. Mixing calendar-day durations with working-day dates can make the visual timeline misleading.

Step 3: Select the Start Date and Duration Columns

Highlight the Start Date and Duration columns, including their headings. Do not select the task names yet.

For example, if your headings are in columns A through D, select only the cells in columns B and D. Hold the Ctrl key on Windows or the Command key on Mac if the columns are not adjacent.

Here's why: Excel needs the start date series to create the invisible positioning portion of each bar. The duration series becomes the visible task bar.

Step 4: Insert a Stacked Bar Chart

1. Open the Insert tab.
2. Choose Bar Chart, rather than a column chart.
3. Select 2-D Stacked Bar.
4. Check that Excel created one series for start dates and another for durations.

You should now see horizontal bars. The chart may look unusual because the start date values are large serial numbers behind the scenes.

That is normal. The next step hides the positioning series and reveals the proper timeline.

Step 5: Add the Task Names to the Vertical Axis

Right-click the chart and choose Select Data. Under the category labels, select the cells containing your task names.

Excel should place the task names along the vertical axis. If the names appear in the wrong order, right-click the vertical axis and choose Format Axis.

Enable Categories in reverse order. This places the first task at the top, which matches the way most people read a project schedule.

Step 6: Hide the Start Date Series

Click one of the bars representing the start dates. Open Format Data Series, then set the fill to No Fill and the border to No Line.

The start dates remain part of the chart, but they become invisible. Their only job is to push each visible duration bar to the correct position.

The result should resemble a traditional Gantt chart: each colored bar begins on its task start date and extends for the correct duration.

Step 7: Format the Horizontal Date Axis

Right-click the horizontal axis and choose Format Axis. You will see minimum and maximum bounds represented as serial numbers.

Change the minimum bound to the earliest project start date. You can type the date directly, such as 4/1/2025, or enter Excel's underlying date value.

Set the maximum bound slightly after the final task ends. This gives the chart breathing room without creating a large empty area.

Next, adjust the major unit. A major unit of one day creates a detailed view. A unit of seven days creates weekly spacing, while a unit of 30 days creates monthly spacing.

Step 8: Improve the Chart Appearance

A technically correct chart can still be difficult to read. Make a few visual changes:

• Reduce the gap width to make task bars thicker.
• Use one strong color for standard tasks.
• Use a contrasting color for milestones or critical work.
• Remove unnecessary chart elements.
• Keep the date labels large enough to scan.
• Move the legend if it blocks useful information.

To change bar thickness, right-click a visible bar, choose Format Data Series, and lower the gap width percentage. A setting between 30% and 60% often works well.

Step 9: Add Milestones

A milestone usually represents a single date, such as approval, launch, or final testing. Excel's stacked bar method handles multi-day tasks more naturally than one-day milestones.

You can represent a milestone in several ways:

• Use a one-day duration and apply a different color.
• Add a diamond shape above the relevant date.
• Create a separate milestone series using a scatter chart.
• Label the milestone beside the task bar.

For a small project, a one-day bar with a contrasting color is usually sufficient. For a complex schedule, a separate milestone series gives you more control.

Step 10: Test the Timeline

Change one start date and confirm that the visible bar moves. Then change one end date and confirm that the bar becomes longer or shorter.

Check for common errors:

• A task ending before it starts.
• A duration showing a negative number.
• Dates stored as text instead of real Excel dates.
• Weekend calculations mixed with calendar-day calculations.
• Task labels displayed in reverse order.

The best part? Once the formulas and chart are connected, you can update the schedule by changing dates rather than drawing bars manually.

How the Excel Gantt Chart Works

An Excel Gantt chart is built from two stacked bar segments. The hidden segment represents the time before a task begins. The visible segment represents the task duration.

Imagine the project begins on April 1. A task that begins on April 8 needs seven days of invisible space before its colored bar appears. Excel creates that space using the start date value.

The Three Important Values

Every task bar depends on three values:

• Start date: The calendar position where the task begins.
• End date: The calendar position where the task finishes.
• Duration: The length of the task bar.

Excel stores dates as sequential numbers. The chart uses those numbers to position bars from left to right.

For example, if one task starts on April 3 and another starts on April 10, the second task receives a larger invisible offset. Its visible bar appears later on the timeline.

Calendar Days Versus Working Days

Decide whether your project follows calendar days or working days. A three-day task can mean Monday through Wednesday, or three consecutive dates that include a weekend.

Use ordinary subtraction when weekends count:

=End Date-Start Date+1

Use NETWORKDAYS when only weekdays count. You should also list holidays if the project schedule excludes them.

For example, a task running from Friday to Monday lasts four calendar days but two working days. The chart should match the planning method your team actually uses.

Why Some Bars Appear Misaligned

Misalignment usually comes from inconsistent date formats, incorrect duration formulas, or a chart axis that starts too early or ends too late.

It can also happen when Excel treats a date as text. A reliable test is to change the cell format to General. A real Excel date changes into a number, while text remains visibly formatted as text.

How to Show Progress in an Excel Gantt Chart

You can add progress by creating a second visible series for completed work. This lets you compare planned duration with the portion already finished.

Create a Progress Column

Add two columns called Progress % and Completed Days. Enter a percentage such as 25%, 50%, or 100% for each task.

Then calculate completed days with:

=Duration*Progress %

If the duration is in D2 and progress is in E2, use:

=D2*E2

A ten-day task at 40% completion would show four completed days.

Build a Progress Series

Add the completed-days values to the chart as another stacked series. Format the completed portion with a darker shade and the remaining planned duration with a lighter shade.

You may need to subtract completed days from the planned duration:

=Duration-Completed Days

This creates two sections inside the task period:

• A completed section showing finished work.
• A remaining section showing planned work.

This approach works well for status meetings. For example, a design task may span ten days, with four days shown in dark blue and six days shown in light blue.

How to Add Dependencies and Deadlines

A basic Excel Gantt chart shows timing, but it does not automatically manage task relationships. You need to reflect dependencies through dates, formulas, or visual markers.

Use Formulas for Simple Dependencies

Suppose testing begins one day after development ends. If development ends in C5, set the testing start date to:

=C5+1

If a task requires three working days after approval, use:

=WORKDAY(C5,1)

For more complex schedules, add a predecessor column. Enter the task that must finish before the next task begins.

Highlight Late Tasks

Add a planned end date and an actual end date. Then compare them with a formula:

=IF(Actual End Date>Planned End Date,"Late","On track")

Use conditional formatting to color late tasks red. This makes schedule risk visible without inspecting every date.

You can also highlight tasks that are due within five days:

=AND(End Date-TODAY()<=5,End Date>=TODAY())

That rule draws attention to work that needs immediate follow-up.

Mark Key Deadlines

Deadlines deserve visual emphasis. Add a vertical line, a contrasting milestone, or a callout label for events such as:

• Customer approval
• Regulatory review
• Product release
• Contract renewal
• Final presentation

Keep the number of visual markers limited. If every task receives a special color, important deadlines lose their impact.

When an Excel Gantt Chart Is a Good Choice

Excel works well for small projects, personal planning, and one-time schedules. You can build a useful timeline without learning specialized project software.

For example, a six-week marketing campaign with twelve tasks is easy to maintain in Excel. One person can update dates, adjust formulas, and share a polished view with a few colleagues.

Excel is also useful when your team needs a quick visual for a meeting. You can copy the chart into a presentation and explain the schedule in seconds.

When Excel Starts to Become Difficult

Complexity increases when several people edit the schedule, tasks have many dependencies, or progress changes every day.

Consider a product launch with 150 tasks, six teams, and multiple approval stages. Manual formulas may become difficult to audit. A date change in one area can create errors elsewhere.

You may also need permissions, activity history, workload planning, automated reminders, and reports. Those requirements extend beyond a basic chart.

A Practical Comparison

The right choice depends on how often the schedule changes and how many people need to coordinate around it.

Excel Gantt Chart Solution: ONES.com

ONES.com gives teams a unified platform for project management and knowledge management when a manually maintained Excel timeline becomes difficult to control. ONES Project is the project management product and a Jira alternative. ONES Wiki supports knowledge management and is a Confluence alternative. They are sold separately.

Value Proposition

For a simple schedule, Excel may be enough. For active projects with changing work, approvals, and reporting needs, ONES.com keeps planning and execution connected in one workspace.

Core Capabilities

• Scattered task tracking → ONES Project project spaces → Keep tasks, owners, dates, and status in a structured project environment.
• Manual timeline calculations → Gantt-style planning and sprint management → Connect planned work with active delivery instead of rebuilding charts after every change.
• Rigid Excel layouts → Custom workflows and fields → Adapt stages, task details, approvals, and ownership to your team’s process.
• Limited visibility into progress → Built-in reporting → Turn project activity into reports that help you identify delays and workload concerns.
• Repeated status updates → Automation → Reduce routine work through rules for assignments, transitions, notifications, and related actions.
• Jira migration concerns → Jira-compatible workflows → Support familiar issue and delivery patterns while evaluating a Jira alternative.
• Plugin-heavy project setups → Native feature parity → Use core planning, workflow, reporting, and collaboration capabilities with fewer add-ons.
• Security restrictions → On-premise, private cloud, and air-gapped deployments → Choose a deployment model that matches operational and compliance requirements.
• Unclear adoption risk → Free plan for up to 30 seats → Try the platform with a small team before expanding usage.

Application Scenarios

Software delivery: A development team can connect backlog items, sprints, dependencies, and release planning. Instead of updating a separate chart after each sprint, the project view reflects current work more directly.

Marketing campaigns: A marketing team can coordinate planning, content production, design reviews, approvals, and launch activities. Custom fields can capture channel, campaign owner, and review status.

Restricted environments: An organization with strict network requirements can choose cloud, on-premise, private cloud, or air-gapped deployment. ONES.com provides full feature parity between its cloud and self-hosted versions.

Common Challenges

Dates Are Displayed as Numbers

Problem: The horizontal axis shows large numbers rather than readable dates.

Solution: Open the axis formatting options and choose a date number format. Set the axis bounds and major unit after applying the format.

The Tasks Appear Backward

Problem: The final task appears at the top while the first task appears at the bottom.

Solution: Format the vertical axis and enable Categories in reverse order. This reverses the display without changing your schedule rows.

The Bars Begin on the Wrong Day

Problem: A visible bar begins before or after its listed start date.

Solution: Check that the start date is a real Excel date, that the hidden series is based on start dates, and that the duration formula includes the correct number of days.

Weekends Create Confusing Gaps

Problem: The chart includes weekend space even though the team works only Monday through Friday.

Solution: Decide whether the schedule should show calendar time or working time. Use NETWORKDAYS and WORKDAY for weekday planning, then explain the convention to everyone reading the chart.

The Chart Becomes Difficult to Maintain

Problem: Frequent changes require repeated formula edits and formatting work.

Solution: Convert your range into an Excel table, keep formulas consistent, and assign one owner for schedule maintenance. If the project needs shared workflows, automation, and detailed reporting, evaluate a project management platform such as ONES Project.

FAQs

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

Yes. You can create one by preparing task names, start dates, end dates, and durations, then inserting a stacked bar chart. Hide the start-date series and format the horizontal axis as dates. Templates can save time, but understanding the structure makes troubleshooting much easier.

What formula calculates task duration in Excel?

For calendar days, subtract the start date from the end date and add one: =End Date-Start Date+1. For weekdays, use =NETWORKDAYS(Start Date,End Date). Add a holiday range when public holidays should not count toward the schedule.

Why should the start-date bars be hidden?

The start-date series creates the empty space before each task begins. It is a positioning mechanism rather than task work. Hiding it leaves the duration series visible while preserving each bar’s correct location on the timeline.

Can an Excel Gantt chart show task progress?

Yes. Add a progress percentage, calculate completed days, and display completed and remaining time as separate stacked series. Use darker and lighter shades of the same color so the relationship remains clear.

How can I show weekends differently?

You can add shaded shapes behind weekend columns, use conditional formatting in a supporting calendar range, or calculate working-day durations. The simplest method is often a light background shade that separates weekends from business days.

When should I move from Excel to project management software?

Consider a dedicated platform when several people update the schedule, dependencies change often, permissions matter, or you need automated workflows and reporting. A small personal project may remain easy in Excel, while a multi-team project can become difficult to audit manually.

Conclusion

You can make a dated Gantt chart in Excel by combining task names, start dates, end dates, and durations in a stacked bar chart. The start-date series positions each task, while the duration series creates the visible timeline.

Use real Excel dates, choose calendar or working-day calculations, reverse the task order when needed, and test the chart after changing dates. Add progress, milestones, dependencies, and deadline indicators as the schedule becomes more useful.

But here's the truth: a manual chart works best when the project is small and changes are limited. When coordination, reporting, automation, and shared ownership become central, a platform such as ONES.com can provide a more connected way to manage project work.