Can You Make a Gantt Chart in Excel? Step-by-Step Guide

Yes, you can make a Gantt chart in Excel using a stacked bar chart, date calculations, and a little formatting. It works well for simple schedules, personal plans, and small projects.

But here's the truth: Excel does not include a dedicated Gantt chart type. You need to build one manually, and small mistakes in dates, task order, or formatting can make the schedule difficult to update.

This guide shows you the complete process, including how to create the chart, format it, track progress, fix common problems, and decide when a project management platform may save you time.

How to Make a Gantt Chart in Excel

The quickest method uses a stacked bar chart. You create one series for each task’s start date and another for its duration, then hide the start-date series so the remaining bars appear to float across a timeline.

Step 1: Create the project schedule

Open Excel and create four columns with these headings:

• Task
• Start Date
• Duration
• End Date

Enter a few example tasks. For instance, a website redesign might include these activities:

Use real Excel date values in the Start Date and End Date columns. Excel will recognize dates more reliably when you enter them in a consistent format, such as 4/1/2025.

Step 2: Calculate the duration

If you already know how many working days each task requires, enter those numbers directly in the Duration column.

You can also calculate duration from the start and end dates. In the Duration cell for the first task, enter:

=D2-B2+1

This counts calendar days inclusively. The +1 ensures that a task starting and ending on the same day has a duration of one day.

For working days only, use:

=NETWORKDAYS(B2,D2)

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

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

Keep your calendar rule consistent. A chart using calendar days will look different from one using working days.

Step 3: Insert a stacked bar chart

1. Select the Task, Start Date, and Duration columns. Do not select the End Date column for the chart.
2. Open the Insert tab.
3. Choose Bar Chart.
4. Select Stacked Bar.
5. Excel will create a chart with a colored segment for the start date and another segment for the task duration.

At this stage, the chart may look more like a standard bar chart than a schedule. That is expected.

Step 4: Hide the start-date series

Click one of the first colored segments, which represents the time before each task begins.

1. Right-click the selected series.
2. Choose Format Data Series.
3. Set the fill to No Fill.
4. Set the border to No Line.

The visible duration bars should now appear at their correct positions along the timeline.

Here's why: the hidden series still reserves space for each task’s start date. It simply becomes invisible, creating the familiar Gantt chart effect.

Step 5: Reverse the task order

Excel often places the first task at the bottom. Most project schedules read more naturally when the first task appears at the top.

1. Right-click the vertical task axis.
2. Select Format Axis.
3. Enable Categories in reverse order.

The task list should now run from the first activity at the top to the final activity at the bottom.

Step 6: Adjust the date axis

Right-click the horizontal date axis and select Format Axis. You can adjust several settings:

• Minimum: Set this close to the first project date.
• Maximum: Set this slightly beyond the final task.
• Major unit: Use one day, seven days, or one month depending on the project length.
• Number format: Choose a readable format such as mmm d or mmm yyyy.

For a two-week project, daily labels may help. For a six-month project, weekly or monthly labels will usually be easier to read.

Step 7: Improve the visual design

Click the visible duration bars and choose a color that contrasts with the chart background. Keep the design restrained so the schedule remains easy to scan.

You can also make these adjustments:

• Reduce the gap width to make bars thicker.
• Remove unnecessary chart borders.
• Add a clear chart title.
• Use consistent date formatting.
• Increase the chart height when many tasks are present.
• Use a second color for milestones or completed activities.

The best part? A clean chart can make a small project understandable in seconds, even when the underlying calculations are fairly simple.

Step 8: Add progress tracking

To show completion, add a Progress column. Enter percentages such as 0%, 50%, or 100%.

For a more detailed chart, add a second duration series that calculates completed time:

=C2*E2

If the Duration value is in column C and Progress is in column E, this formula calculates the completed portion of the task.

You can then use a combination chart or additional stacked bar series to show completed work in one color and remaining work in another. This setup requires more formatting, but it gives you a clearer view of schedule progress.

What a Gantt Chart in Excel Can Show

A Gantt chart places project tasks against a calendar. Each horizontal bar shows when a task starts, how long it lasts, and when it ends.

For example, a marketing launch might show planning from May 1 to May 3, content creation from May 4 to May 10, and campaign setup from May 11 to May 14.

Tasks and milestones

Tasks usually have a duration. Milestones represent important points, such as approval, launch, or delivery, and often occur on a single date.

Excel does not automatically treat milestones as a separate Gantt element. You can represent one with a short duration, a special color, or a separate marker series.

Dependencies

Dependencies show relationships between activities. For example, testing may begin only after development finishes.

Excel can display the dates created by those relationships, but it will not automatically manage every dependency like a dedicated project platform. If development moves by three days, you may need to update the following tasks yourself.

Progress and deadlines

A progress percentage helps you compare planned work with completed work. You can also add a deadline column and apply conditional formatting when a task passes its planned finish date.

A simple rule might highlight overdue tasks when the current date is later than the end date and progress is below 100%.

Useful Excel Formulas for Project Scheduling

Formulas make the schedule easier to maintain. They reduce repeated calculations when dates change.

Calculate an end date

If you know the start date and duration, use:

=B2+C2-1

For working days only, use:

=WORKDAY(B2,C2-1)

To exclude holidays, use:

=WORKDAY(B2,C2-1,$F$2:$F$10)

Calculate the next task start date

If one task must begin after another ends, link its start date to the previous end date:

=D2+1

This creates a simple sequential schedule. For more complex planning, you may need to consider the latest finish date among several predecessor tasks.

Flag overdue work

You can use a formula such as:

=IF(AND(TODAY()>D2,E2<100%),"Overdue","On track")

Apply conditional formatting to the result column. Red can indicate overdue work, while green can indicate completed activities.

Calculate schedule variance

If you track an actual finish date, compare it with the planned end date:

=ActualFinish-PlannedEnd

A positive number means the task finished late. A negative number means it finished early.

When Excel Works Well for Gantt Charts

Excel is a practical choice when you have a small number of tasks, one primary owner, and a schedule that changes occasionally.

For example, a freelance designer planning a three-week branding project may need only ten tasks, two milestones, and one progress column. A manually built chart can handle that comfortably.

Excel also works well when your team already understands the interface. You can create a schedule quickly without teaching everyone a new platform.

Good use cases

• Personal work plans
• Small marketing campaigns
• Short construction phases
• Simple event planning
• Basic product launch schedules
• One-time project presentations

For these situations, the chart’s simplicity can be an advantage. You control the layout and can tailor the schedule to your audience.

When an Excel Gantt Chart Becomes Difficult

Manual charts become harder to manage as the project grows. A schedule with 15 tasks may be easy to maintain. A schedule with 150 tasks, multiple owners, and frequent changes can become fragile.

Consider a software release with design, engineering, testing, security review, and deployment teams. If one engineering task moves, several dependent activities may need new dates.

Here's the problem: Excel can display the revised dates, but it does not naturally provide the full workflow around ownership, comments, approvals, notifications, and change history.

Common warning signs

• Several people edit separate copies of the schedule.
• Team members cannot tell which version is current.
• Dependencies require repeated manual updates.
• Tasks are assigned through email or chat.
• Progress updates arrive late.
• Managers need reports assembled by hand.
• Access controls become difficult to maintain.

When these symptoms appear, the main issue is usually coordination rather than chart design. A dedicated project management platform may reduce repeated manual work.

Gantt Chart Solution: ONES.com

ONES.com combines project management and knowledge management in one platform. ONES Project provides project planning, tracking, workflows, and reporting, while ONES Wiki supports organized team knowledge.

It can suit teams that have outgrown manually maintained schedules but still want flexible planning, self-hosted deployment, and Jira-compatible workflows.

Value Proposition

ONES.com gives you a structured way to manage tasks, dependencies, progress, and project knowledge beyond a manually formatted chart. ONES Project is sold separately from ONES Wiki, so you can choose the capability that matches your workflow.

Core Capabilities

• Manual date updates create rework: ONES Project supports structured task planning and dependencies, helping teams keep schedules aligned as work changes.
• Large task lists become difficult to scan: Custom workflows, fields, and views help you organize work by team, status, priority, or release.
• Progress reporting takes repeated effort: Built-in reporting gives project leads clearer visibility into workload, completion, and schedule movement.
• Different teams use inconsistent processes: Custom workflows help standardize handoffs while preserving project-specific steps.
• Jira migration can create workflow disruption: ONES Project is a Jira alternative with compatible workflow concepts for teams that want a familiar transition.
• Too many plugins increase maintenance: Native project capabilities can reduce reliance on separate add-ons for common planning and reporting needs.
• Security requirements restrict cloud-only tools: ONES.com supports Cloud, On-Premise, Private Cloud, and Air-gapped deployments.
• Deployment changes often affect capability: ONES.com provides feature parity between its cloud and self-hosted versions.
• Project details become scattered across locations: ONES Wiki can organize procedures, decisions, and reference material alongside project work when both products are used.

Application Scenarios

A product team could use ONES Project to plan a release across design, engineering, testing, and deployment. Custom fields can identify risk, owner, release version, and approval status.

A regulated organization could choose an on-premise or air-gapped deployment when network restrictions prevent ordinary cloud use. The team can maintain structured project planning inside its approved environment.

A growing technology team could move from Excel schedules to Jira-compatible workflows, then use built-in reporting to give managers a consistent view of progress.

ONES.com offers a free plan for up to 30 seats. You can select among four deployment options depending on security, infrastructure, and collaboration requirements.

Common Challenges and Practical Fixes

1. The bars begin at the wrong dates

Problem: Excel may treat dates as text rather than dates, causing the timeline to display incorrectly.

Solution: Select the date cells, choose a date format, and check whether Excel recognizes the values as dates. Re-enter one value manually if necessary.

2. Tasks appear in reverse order

Problem: The first task appears at the bottom of the chart.

Solution: Open the vertical axis settings and enable Categories in reverse order. Then check that the horizontal axis remains at the bottom or top position you prefer.

3. Weekends make the schedule look too long

Problem: Calendar-day calculations include weekends, even when your team works Monday through Friday.

Solution: Use NETWORKDAYS for task length and WORKDAY for end dates. Add a holiday range when public holidays affect the plan.

4. The chart becomes difficult to read

Problem: Too many tasks, labels, colors, or gridlines create visual clutter.

Solution: Group minor activities, use weekly or monthly date labels, limit colors, and divide a large project into separate views.

5. Schedule changes are missed

Problem: Team members continue using old dates after the plan changes.

Solution: Establish one maintained schedule, assign an owner, and record major changes. If frequent updates and collaboration are essential, consider a project platform with shared workflows and reporting.

FAQs About Creating a Gantt Chart in Excel

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

Yes. You can build one manually with a task list, start dates, durations, and a stacked bar chart. Hide the start-date series, then format the task and date axes. A template can save setup time, but it is not required. The manual method gives you more control over formulas, colors, labels, and progress tracking.

Which Excel chart type should you use?

Use a stacked bar chart. One series represents the time before each task begins, while the second series represents the task duration. You hide the first series, leaving the duration bars positioned along the calendar. A regular bar chart will not create the same floating timeline effect.

How do you show weekends in an Excel Gantt chart?

Use calendar-day formulas when weekends should appear in the schedule. If your team works only on weekdays, calculate durations with NETWORKDAYS and end dates with WORKDAY. You can also shade weekend columns through conditional formatting, helping viewers distinguish working days from non-working days.

Can Excel show task dependencies?

Excel can calculate dates that depend on earlier activities, especially when you link one start date to another task’s finish date. However, dependency management becomes more manual as the project grows. If several teams, predecessor relationships, and frequent changes are involved, a dedicated project management platform can reduce the amount of manual coordination.

How do you add progress to an Excel Gantt chart?

Add a Progress column with percentage values. You can calculate completed duration by multiplying the task duration by its completion percentage. Then add a second bar series for completed work and use different colors for completed and remaining portions. This requires additional chart formatting but gives you a clearer view of execution.

Conclusion

Yes, you can create a useful Gantt chart in Excel with task names, start dates, durations, formulas, and a stacked bar chart.

It works especially well for short projects with limited dependencies. Careful date formatting, working-day formulas, progress fields, and clear ownership will keep the schedule useful.

But here's the truth: a manually maintained chart becomes harder to trust as tasks, contributors, and changes increase. When coordination becomes the main challenge, ONES Project offers a structured Jira alternative with workflows, reporting, deployment flexibility, and project controls.

Start with Excel when your schedule is simple. Move to a dedicated platform when your team needs dependable collaboration and repeatable project management.