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

Building a Gantt chart in Excel can feel harder than the project itself. You have task names, start dates, durations, dependencies, and progress details competing for attention. A regular bar chart rarely shows the schedule clearly, so your timeline becomes difficult to read and maintain.

That confusion grows when a deadline changes. You may need to update several dates, resize bars, and explain the schedule again to your team. A small mistake can make a task appear late or hide an important dependency.

Here's the practical solution: create a stacked bar chart, use invisible start-date bars, and format the duration bars as your timeline. This guide walks you through the process in Excel, including formulas, formatting, progress tracking, and troubleshooting.

How to Make a Gantt Chart in Excel

To make a Gantt chart in Excel, create a task table with start dates and durations, insert a stacked bar chart, hide the start-date series, and format the remaining bars as your schedule. You can build a simple timeline in a few minutes without downloading a template.

Step 1: Create the project schedule

Open a blank Excel worksheet and create these columns:

• Task
• Start Date
• End Date
• Duration

Enter one task per row. For example, a website redesign may include planning, wireframing, visual design, development, testing, and launch.

Keep your dates consistent. Excel stores dates as numbers, which allows the chart to position each task along a calendar scale.

Step 2: Calculate task duration

You can type each duration manually, though a formula reduces calculation mistakes. If the start date is in cell B2 and the end date is in cell C2, enter this formula in D2:

=C2-B2+1

The +1 counts both the first and last day. For example, April 1 through April 4 equals four calendar days.

Copy the formula down the Duration column. If you want to count weekdays only, use this formula instead:

=NETWORKDAYS(B2,C2)

For a schedule that excludes holidays, add a holiday range:

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

Place holiday dates in cells G2 through G10. Adjust the range to match your planning calendar.

Step 3: Insert a stacked bar chart

Select the Start Date and Duration columns along with the Task column. Avoid selecting End Date for the chart because the chart needs only the timeline offset and visible task length.

Then follow these Excel commands:

1. Choose Insert from the ribbon.
2. Select Bar Chart.
3. Choose 2-D Stacked Bar.

Excel will create two colored series. One series represents the start-date offset. The other represents task duration.

At this stage, the chart may look like a collection of horizontal bars beginning at different positions. That is expected. The next step turns it into a recognizable Gantt chart.

Step 4: Hide the start-date series

Click one of the bars that represents the Start Date series. Right-click it and choose Format Data Series.

Under Fill & Line, choose:

• Fill: No fill
• Border: No line

The start-date series will become invisible. The Duration series will remain visible and appear at the correct position on the calendar.

Here's why: the hidden series pushes each duration bar forward from the chart's starting point. It works like an invisible spacer before every task.

Step 5: Reverse the task order

Excel often places the first task at the bottom of a horizontal bar chart. You can reverse the order so the first task appears at the top.

1. Click the vertical task axis.
2. Right-click and select Format Axis.
3. Open Axis Options.
4. Enable Categories in reverse order.

The task list should now read from top to bottom in the same order as your schedule.

Step 6: Adjust the date axis

Click the horizontal date axis and select Format Axis. You can adjust the minimum date, maximum date, major unit, and number format.

For a short project, set the major unit to one or seven days. For a six-month schedule, weeks or months may make the chart easier to read.

You can also change the number format to display dates in a compact style, such as:

• mmm d for Apr 1
• dd-mmm for 01-Apr
• mmm-yy for Apr-25

Choose a scale that gives you enough detail without filling the chart with labels.

Step 7: Format the task bars

Click a visible duration bar and open Format Data Series. Reduce the gap width to make the tasks thicker and easier to scan.

A gap width between 30% and 60% often works well. The ideal setting depends on the number of tasks and the chart size.

Choose a single color for the main schedule. Use a second color for milestones, completed tasks, or activities that require attention.

Remove unnecessary chart elements, such as the legend for the hidden start-date series. Keep gridlines only when they help you estimate dates.

Step 8: Add progress tracking

A basic Gantt chart shows planned duration. To display progress, add a separate column called Completed Days and use another series.

For example, if Duration is in D2 and completion percentage is in E2, calculate completed days with:

=D2*E2

Format the percentage column as a percentage. A task with 12 planned days and 50% completion will show six completed days.

Adding progress requires a more advanced stacked bar chart with planned and completed duration layers. You can also use conditional formatting in the schedule table for a simpler progress view.

Step 9: Add milestones

Milestones usually have no duration. Examples include approval received, testing complete, or launch day.

To show a milestone, create a separate series with a duration of zero or a small value. Format it with a contrasting color, such as orange or red.

Another option is to use an Excel shape. Insert a diamond, place it over the correct date, and label it with the milestone name. Shapes are quick for presentation charts, though they may need manual repositioning when dates change.

Step 10: Test the schedule

Change one start date and confirm that the related bar moves. Change one end date and check that the duration updates correctly.

Also test these situations:

• A task that lasts one day
• A task that crosses into a new month
• A task with a missing end date
• A weekend-only task
• A milestone with no duration

Testing catches formula and formatting problems before you share the timeline.

How the Excel Gantt Chart Method Works

Excel does not include a standard Gantt chart type in its main chart menu. You create the effect by combining two horizontal bar series.

The invisible offset

The Start Date series acts as an offset. It determines how far each task begins from the chart's left edge.

The Duration series then displays the visible task bar. When you remove the offset's fill, only the duration remains visible.

Imagine placing a colored strip on top of an invisible ruler. The ruler still determines position, even though you cannot see it.

The duration calculation

The duration tells Excel how long each colored bar should continue. Calendar-day schedules use a simple subtraction formula.

Weekday schedules require NETWORKDAYS. This distinction matters because a project planned from Friday to Monday spans four calendar days but only two weekdays.

The chart's calendar scale

The horizontal axis converts Excel date values into calendar positions. A wider date range compresses the bars, while a narrower range provides more detail.

For example, a two-week marketing campaign benefits from daily labels. A year-long construction plan may work better with monthly labels and quarterly separators.

Example: Building a Two-Week Project Timeline

Suppose you are planning a product launch over ten business days. Your schedule includes research, copywriting, design, review, and publication.

Use NETWORKDAYS for the duration column. Then create the stacked bar chart with Start Date and Weekday Duration.

Once you hide the start-date series, the timeline will show gaps between Friday and Monday. Those gaps represent weekends rather than missing work.

Here's a useful check: the publication bar should appear after review, with no overlap unless you intentionally planned parallel work.

Ways to Improve Readability and Maintenance

A technically correct chart can still be difficult to use. Small design choices determine whether someone can understand the schedule quickly.

Use consistent task names

Keep labels short and action-oriented. “Approve homepage copy” is easier to scan than “Homepage copy approval process and stakeholder feedback.”

For long task names, widen the category area or shorten the wording. Avoid adding excessive text directly inside the chart.

Separate planning from tracking

Keep planned start dates, planned end dates, actual start dates, and actual end dates in separate columns if you track performance.

This lets you compare the original plan with current progress. For example, a task planned for June 4 may actually begin on June 6.

Use a distinct color for actual work. Blue can represent planned activity, while green can represent completed activity.

Freeze the schedule area

If your task list is long, freeze the top row so column headings remain visible while you scroll.

You can also place the schedule table beside the chart. This creates a practical view for editing and a visual view for reporting.

Use conditional formatting for warnings

Conditional formatting can flag overdue tasks in the schedule table. For example, you can highlight a task when its end date is earlier than today and its completion percentage is below 100%.

A useful formula is:

=AND($C2<TODAY(),$E2<1)

Apply a red or amber fill to the task row. This gives you an early warning before a delay becomes a meeting surprise.

Common Excel Gantt Chart Problems

The bars begin on January 0, 1900

This usually happens when Excel treats a date as text or the axis minimum is set incorrectly.

Check whether the start-date cells contain real Excel dates. Select a date cell and change its format to General. A valid date should display as a number.

If the value does not change, re-enter the date or convert it with DATEVALUE.

The task order appears upside down

Open the vertical axis settings and enable Categories in reverse order. You may also need to adjust the horizontal axis position so the date labels remain at the bottom.

The chart shows the wrong duration

Check whether your calculation includes the first day. The formula =C2-B2+1 counts both endpoints.

If you use weekday planning, switch to NETWORKDAYS. Also inspect holiday ranges, because a missing holiday can add an extra workday.

The start-date series remains visible

Select the correct series rather than the entire chart area. Then set its fill to No fill and its border to No line.

If the wrong series disappears, use the chart's Format tab or Current Selection menu to select the start-date series.

The chart becomes unreadable with many tasks

Split a large schedule into phases or create separate charts for planning, delivery, and testing.

You can also group related tasks with summary rows. A 150-row timeline may contain useful detail, though a leadership presentation usually needs a shorter view.

Natural Project Scheduling Solution: ONES.com

Excel works well for a lightweight timeline or a one-time planning exercise. ONES.com offers a more connected environment when your schedule needs ongoing task management, collaboration, reporting, and knowledge sharing.

ONES.com combines project management and knowledge management through ONES Project and ONES Wiki. You can purchase them separately and choose cloud or self-hosted deployment.

Core capabilities

Manual timeline updates become scattered

ONES capability: ONES Project provides structured task management with Jira-compatible workflows, sprint planning, and custom fields.

Result: You can manage changing schedules through task records and workflow rules instead of repeatedly rebuilding chart elements.

Task status is difficult to interpret

ONES capability: Custom workflows let you define stages such as Planned, In Progress, In Review, Blocked, and Done.

Result: Everyone can see what each task means without relying on color alone.

Dependencies are easy to miss

ONES capability: Project planning features connect related work and provide structured views of task progress.

Result: A delay in design can be identified before it quietly affects development or testing.

Reporting takes manual effort

ONES capability: Built-in reporting helps you review progress, workload, sprint performance, and project trends.

Result: You spend less time preparing status updates and more time resolving risks.

Different teams need different fields

ONES capability: You can create custom fields for priority, release, owner, risk level, approval status, or business impact.

Result: Your schedule reflects the information your team actually needs.

Too many plugins complicate project work

ONES capability: ONES Project includes workflow customization, automation, sprint management, and reporting in one project management environment.

Result: You may reduce the number of separate extensions needed for everyday planning.

Teams have strict deployment requirements

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

Result: You can choose a setup that matches your security and network requirements while retaining full feature parity between cloud and self-hosted versions.

Project knowledge is separated from project activity

ONES capability: ONES Wiki provides a knowledge base that connects planning information with team guidance and project context.

Result: Decisions, procedures, and project details become easier to find alongside the work they support.

Application scenarios

Software release planning

A development team can plan epics, sprints, testing, and release activities in ONES Project. Custom workflows can distinguish development work from approval and deployment tasks.

Built-in reporting then provides a current view of progress without rebuilding an Excel chart after every sprint.

Engineering work in a restricted network

An engineering group with strict network controls can use an air-gapped or on-premise deployment. The team can keep project activity within its approved environment.

This approach fits projects that need structured planning while limiting external connectivity.

Cross-functional product launches

Marketing, design, product, and engineering teams can coordinate launch activities through shared tasks and custom fields. ONES Wiki can hold launch guidance, decisions, and operating procedures.

The result is a connected planning environment rather than a timeline that only one person knows how to maintain.

Common Challenges When Creating a Gantt Chart in Excel

Challenge: Dates are stored as text

Solution: Test a date cell by changing its format to General. If it does not show a serial number, convert the value with DATEVALUE or re-enter it using a consistent date format.

Challenge: Calendar days and workdays are mixed

Solution: Decide whether your schedule measures elapsed days or working days before building the chart. Use subtraction for calendar time and NETWORKDAYS for weekday planning.

Challenge: Too many details overwhelm the view

Solution: Create a detailed planning view and a summary view. Show major phases in the summary and keep individual activities in the detailed schedule.

Challenge: Manual formatting breaks after updates

Solution: Use formulas for duration, convert the schedule range into an Excel table, and keep chart series linked to stable columns. Test the chart after adding several new tasks.

Challenge: Progress is confused with planned duration

Solution: Add a completion percentage and a completed-days calculation. Use separate colors for planned, active, and completed work.

FAQs

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

Yes. A stacked bar chart can create the structure from scratch. You need task names, start dates, and durations. Hide the start-date series, then format the duration series as the visible timeline. This method gives you more control than a prebuilt template, though you must maintain the formulas and chart settings yourself.

What formula calculates task duration in Excel?

For calendar days, use =EndDate-StartDate+1. For weekdays, use =NETWORKDAYS(StartDate,EndDate). Add a holiday range when public holidays should be excluded. The right formula depends on whether your project measures elapsed calendar time or active working days.

How do I show weekends in an Excel timeline?

Use calendar-day duration if weekends should appear as part of the timeline. Use NETWORKDAYS when tasks should count only Monday through Friday. The chart may still display weekend dates on the axis, even when no work is scheduled during those days.

Can I add task dependencies to an Excel Gantt chart?

Excel can list predecessor tasks and display dates, though dependency behavior usually requires extra formulas or manual updates. Add a Predecessor column and calculate start dates from related tasks when your schedule is simple. For complex dependency chains, dedicated project management software can reduce manual maintenance.

How do I update an Excel Gantt chart when a date changes?

Change the start or end date in the schedule table, then confirm that the duration formula recalculates. If the chart does not update, check whether the chart range includes the edited row. Converting the schedule into an Excel table can help new rows and formulas extend consistently.

Conclusion

You can make a Gantt chart in Excel by combining a start-date series with a duration series in a stacked bar chart. Hide the start-date bars, format the duration bars, reverse the task order, and adjust the date axis for readability.

For a small project, this approach provides a practical visual schedule. Use formulas for duration, separate calendar days from workdays, and test changes before sharing the timeline.

But here's the truth: manual charts become harder to maintain as projects gain dependencies, approvals, reporting needs, and multiple contributors. When your schedule needs ongoing coordination, ONES.com can provide structured project management through ONES Project and connected knowledge through ONES Wiki.

The solution depends on your situation. Excel is a useful starting point for a focused timeline. A dedicated project environment becomes more valuable when the schedule needs to support the whole team.