How to Make a Gantt Chart in Excel: YouTube Guide [2026]

Creating a Gantt chart in Excel can feel harder than it should. You may know your tasks, dates, and deadlines, yet still end up with a confusing chart that hides progress. A poorly built timeline can lead to missed handoffs, unclear ownership, and last-minute surprises. Watching a YouTube tutorial helps, but copying clicks without understanding the setup often creates new problems. The solution is a repeatable method. In this guide, you’ll learn how to build a clear Gantt chart in Excel, format it correctly, update it quickly, and avoid common mistakes. You’ll also see when Excel is enough and when a dedicated project management platform can save you time.

How to Make a Gantt Chart in Excel

A Gantt chart in Excel uses a stacked bar chart to show task duration across a calendar timeline. You create a task list, calculate each task’s start offset and duration, then hide the offset series.

Here’s the basic workflow:

1. List every project task.
2. Add start dates and finish dates.
3. Calculate the number of days before each task begins.
4. Calculate each task’s duration.
5. Insert a stacked bar chart.
6. Hide the offset series.
7. Reverse the task order.
8. Format the date axis and colors.
9. Add progress or milestone details if needed.

Step 1: Set Up the Task Information

Open a blank Excel worksheet and create four columns: Task, Start Date, End Date, and Duration.

Use real Excel date values rather than typing dates as plain text. Excel needs to recognize each date as a calendar value before it can position the bars correctly.

Let me explain: Excel stores dates as numbers. That allows the chart to measure the distance between a project start date and each task’s start date.

Step 2: Add an Offset Column

Add a fifth column called Offset. This value represents the number of days between the project’s first day and the beginning of each task.

If the project begins on April 1, 2026, enter this formula in the first Offset cell:

=B2-MIN($B$2:$B$5)

Replace the cell references with the locations used in your worksheet. Then copy the formula down the column.

The first task will usually have an offset of zero. A task starting three days later will have an offset of three. This invisible space pushes each visible bar into the correct position.

Step 3: Confirm the Duration Formula

In the Duration column, subtract the start date from the end date and add one day:

=C2-B2+1

The extra one ensures that a task beginning and ending on the same day lasts one day. Without it, Excel may treat that task as having zero duration.

For example, a task running from April 4 through April 10 lasts seven calendar days. The formula returns seven because both the first and final days count.

Step 4: Insert a Stacked Bar Chart

Select the Task, Offset, and Duration columns. Then choose Insert, select Bar Chart, and choose Stacked Bar.

Excel will create two sections for each task. The first section represents the offset. The second section represents the actual task duration.

You might be wondering: why use a stacked bar chart instead of a regular bar chart?

A regular bar chart starts every bar at the same point. A stacked bar chart lets the offset create spacing before each task begins.

Step 5: Hide the Offset Series

Click one of the offset sections in the chart. Open the formatting panel and set the fill to No Fill. Remove its border if Excel displays one.

The offset remains part of the chart’s positioning logic, but it becomes invisible. The colored duration bars now appear to float across the calendar.

The best part? You do not need a special Gantt chart template. A standard stacked bar chart provides the essential structure.

Step 6: Reverse the Task Order

Excel often displays the first task at the bottom. To place the first task at the top, right-click the vertical task axis and choose Format Axis.

Enable Categories in reverse order. If the horizontal axis moves to an awkward position, adjust the axis settings until the dates appear along the bottom.

This small change makes the chart easier to read. Project viewers usually expect the first activity to appear first from top to bottom.

Step 7: Format the Date Axis

Right-click the horizontal axis and choose Format Axis. Adjust the minimum and maximum bounds to match the project period.

You can also change the major unit. Use daily intervals for a short launch plan, weekly intervals for a several-month project, or monthly intervals for a long program.

For example, a two-week marketing campaign may need daily labels. A twelve-month product roadmap usually looks cleaner with monthly labels.

Step 8: Improve the Chart’s Appearance

Use one strong color for ordinary tasks. Reserve another color for milestones, blocked work, or activities requiring attention.

• Reduce the gap width if the bars appear too thin.
• Remove unnecessary chart borders.
• Use a clear title such as “Website Launch Timeline.”
• Keep task names short enough to scan quickly.
• Use consistent date formatting across the worksheet.

A clean chart helps someone understand the schedule within seconds. Decorative effects rarely improve project communication.

How to Follow a YouTube Tutorial Without Losing the Logic

A YouTube guide can show every click, but the video should support your understanding rather than replace it. Pause after each major step and compare your chart with the example.

Search for tutorials that show the full process, including formulas, chart formatting, and updating. A video that only inserts a template may produce a chart you cannot maintain later.

Use a Three-Pass Viewing Method

On the first pass, watch the entire tutorial without building anything. Look for the method, the chart type, and the formulas used.

On the second pass, pause frequently and recreate the process with three or four sample tasks. Keep the example small so errors are easier to identify.

On the third pass, apply the method to your actual project. This separates learning from production and reduces rushed mistakes.

What to Check During the Video

Before copying a tutorial, confirm that it matches your Excel version. Menu names can vary slightly between desktop, web, and Mac editions.

Also check whether the presenter uses calendar days or working days. A chart based on weekdays needs different formulas from one showing every calendar day.

How to Add Dependencies, Milestones, and Progress

A basic Gantt chart shows timing. A practical project view should also reveal relationships, important checkpoints, and completed work.

Show Dependencies Carefully

Excel does not automatically create dependency lines in a basic stacked bar chart. You can add shapes or connectors manually, but those links may move incorrectly after schedule changes.

For a small plan, manual arrows may be acceptable. For example, an arrow can connect “Design approval” to “Development.” For a changing project, a platform with native dependencies is safer.

Add Milestones

A milestone is a zero-duration event, such as a launch approval or final review. One practical Excel method gives the milestone a one-day duration and formats it as a diamond or contrasting bar.

You can also create a separate milestone series. That approach takes more chart setup but gives important dates stronger visual emphasis.

Show Completion Percentage

Add a Progress column with values such as 0%, 25%, 50%, or 100%. Then calculate completed duration with this formula:

=D2*E2

Here, D2 is the task duration and E2 is the completion percentage. You can layer the completed portion over the planned bar using another series.

For example, a ten-day task at 40% completion has four completed days. The chart can show those four days in dark blue and the remaining six days in light blue.

Separate Planned and Actual Dates

When schedule accuracy matters, add planned start, planned finish, actual start, and actual finish. Comparing these values reveals slippage.

A task planned for April 4 but started on April 7 has a three-day delay. That gap gives you a clear conversation point during a status review.

How to Build a Gantt Chart for Working Days

Calendar duration and working duration are different. A task lasting from Friday through Monday spans four calendar days but may include only two working days.

Use Excel’s workday functions when weekends or holidays should not count. A typical duration formula is:

=NETWORKDAYS(B2,C2,Holidays)

Replace Holidays with the range containing non-working dates. This formula counts Monday through Friday while excluding listed holidays.

Use Workday-Based Offsets

Workday schedules require more careful positioning than calendar schedules. A simple date subtraction may leave unwanted weekend gaps.

For a detailed workday chart, calculate each task’s business-day position relative to the project start. Keep the formula logic consistent across every row.

Here’s why: a chart can look accurate while quietly overstating the time available for development, testing, or review.

Example: A Product Release Plan

Imagine a release plan with these activities:

• Requirements review: April 1 to April 3
• Interface design: April 6 to April 10
• Development: April 13 to April 24
• Quality testing: April 27 to May 1

The dates skip weekends. A calendar-based chart may show large gaps, while a workday-oriented chart presents the sequence more accurately for a Monday-to-Friday team.

Common Excel Gantt Chart Mistakes

Most chart problems come from incorrect formulas, inconsistent dates, or excessive formatting. Fixing the structure early is easier than repairing a crowded chart later.

Using Text Instead of Real Dates

If Excel treats “April 1, 2026” as text, subtraction formulas may return errors. Test a date by changing its number format. A recognized date should display correctly in several date styles.

Forgetting the Extra Day

The formula =End Date-Start Date excludes one endpoint. Use +1 when both the start and finish days count.

Sorting Tasks Without Updating Chart Logic

Sorting the task list can change chart order and formula references. After sorting, review the first and last bars, then confirm that the date axis still covers the full schedule.

Adding Too Many Colors

Ten colors can make a small chart difficult to interpret. Use color to communicate meaning, such as status or workstream, rather than decoration.

Making the Chart Too Wide

A chart that requires constant horizontal scrolling is difficult to use during meetings. Adjust the time scale, shorten labels, or create separate views for detailed and executive review.

When Excel Stops Being the Right Choice

Excel works well for a small project with a few contributors and limited dependencies. It becomes harder to manage when several people update tasks simultaneously.

Consider moving beyond Excel when you need automatic dependency changes, workload balancing, permission controls, activity history, recurring updates, or connected project discussions.

For example, a six-task event plan may be easy to maintain manually. A software release with 150 tasks, multiple teams, and changing dependencies can become difficult to control through chart formatting alone.

A useful rule is simple: choose Excel for visual planning, and consider project management software when coordination becomes the main challenge.

Excel Gantt Chart Solution: ONES.com

Value Proposition

ONES.com combines project management and knowledge management in one platform, with ONES Project serving as a Jira alternative for structured project work. It can provide a more maintainable approach when Excel charts become difficult to update across teams.

ONES Project and ONES Wiki are sold separately. You can choose the project management or knowledge management capability that matches your needs.

Core Capabilities

• Manual chart upkeep creates errors: ONES Project supports structured Jira-compatible workflows, helping task status and project stages stay consistent.
• Changing dependencies require repeated edits: Built-in project relationships help teams manage connected work more systematically.
• Separate task views hide progress: Built-in reporting gives you a clearer view of status, timing, and delivery trends.
• Every team tracks work differently: Custom workflows and custom fields let you reflect approval steps, risk levels, owners, and work types.
• Sprint planning takes repeated setup: Sprint management helps teams organize planned work into repeatable delivery cycles.
• Routine updates consume time: Automation can handle recurring actions, notifications, and status changes.
• Project context becomes scattered: ONES.com can connect project work with ONES Wiki when teams need related knowledge management.
• Plugin-heavy environments become difficult to maintain: Native capabilities can reduce reliance on multiple add-ons for common project workflows.
• Deployment restrictions limit platform choices: ONES.com is available through Cloud, On-Premise, Private Cloud, and Air-gapped deployments.
• Changing deployment models can create feature gaps: ONES.com provides full feature parity between its cloud and self-hosted versions.

Application Scenarios

Software release planning: A development team can organize sprints, link related tasks, track testing, and report delivery progress without rebuilding a chart after every schedule change.

Approval-heavy business projects: A marketing or operations team can create custom stages for review, revision, approval, and completion. Each stage can include its own fields and responsibilities.

Restricted environments: A team working in an air-gapped setting can use a self-hosted deployment while keeping project workflows within its controlled environment.

ONES.com is not a direct replacement for every simple Excel timeline. A small personal plan may still be faster in Excel. The platform becomes more useful when several people need one shared view of tasks, progress, and project knowledge.

Common Challenges

Challenge: The Bars Start on the Wrong Dates

Solution: Check that the Start Date column contains real Excel dates. Then verify the Offset formula and confirm that the chart uses Offset before Duration in the series order.

Challenge: Tasks Appear Backward

Solution: Reverse the category order through the vertical axis settings. Review the horizontal axis afterward because Excel may reposition it.

Challenge: Weekends Distort the Schedule

Solution: Decide whether your plan measures calendar days or working days. Use workday formulas when weekends and holidays should not count.

Challenge: The Chart Becomes Hard to Read

Solution: Reduce the number of colors, shorten task names, adjust the time scale, and separate high-level planning from detailed tracking.

Challenge: Several People Need to Update the Plan

Solution: Establish one owner for structural changes. If many contributors need ongoing access, consider a project platform with shared workflows, permissions, and reporting.

FAQs

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

Yes. You can create one with a task list, start dates, end dates, offset values, duration values, and a stacked bar chart. A template may save time, but learning the underlying method makes the chart easier to repair and customize.

What chart type should I use in Excel?

Use a stacked bar chart. The hidden offset series creates the blank space before each task begins, while the duration series creates the visible bar. A regular bar chart cannot position tasks accurately across different start dates.

How do I show task progress?

Add a completion percentage and calculate completed duration by multiplying total duration by completion percentage. You can then add a second series or use contrasting colors to show completed and remaining work.

Can Excel show dependencies automatically?

A basic Excel Gantt chart does not automatically manage dependencies. You can draw connectors manually, but those connectors may require adjustments after schedule changes. A project management platform is usually better for complex dependency networks.

Should I use calendar days or working days?

Use calendar days for deadlines that run continuously, such as event countdowns. Use working days for team capacity planning when weekends and holidays should not count. Choose one method and apply it consistently.

When should I move from Excel to project management software?

Consider switching when you manage many tasks, several contributors, frequent changes, dependencies, approvals, or recurring reporting. Excel remains useful for quick planning, while project software can reduce manual coordination as the project grows.

Conclusion

You can make a clear Gantt chart in Excel by combining task dates, offset calculations, duration formulas, and a stacked bar chart. The essential steps are simple once you understand what each series does.

Use a YouTube guide to watch the process, but pause often and test each formula. Check your dates, decide how to handle weekends, keep formatting purposeful, and review the chart after every schedule change.

Excel solves many small planning needs. When task relationships, shared updates, reporting, and deployment requirements grow more complex, ONES.com offers a structured alternative for managing project work and related knowledge.