How to Make a Gantt Chart in Excel for Mac: 7 Steps (2026)

Building a Gantt chart in Excel for Mac can feel harder than planning the project itself. You may spend more time formatting bars than tracking deadlines, dependencies, and progress. A small mistake in dates can also make the timeline misleading.

That frustration grows when your project changes. Add one task, and the entire chart may need adjustment. Change a deadline, and the visual schedule can quickly become cluttered or inaccurate.

But here's the truth: you can create a practical Gantt chart in Excel for Mac with a stacked bar chart and a few formulas. This guide walks you through seven clear steps, including date calculations, formatting, milestone markers, and progress updates.

How to Make a Gantt Chart in Excel for Mac

The quickest method uses a task list, a start-date series, and a duration series. You then turn those values into a stacked bar chart and hide the first series so the remaining bars resemble a project timeline.

Step 1: Set Up Your Project Schedule

Open Excel on your Mac and create four columns for your basic schedule:

• Task: The activity your team needs to complete.
• Start Date: The day work begins.
• End Date: The planned completion day.
• Duration: The number of calendar days required.

Enter one task per row. Keep the schedule in project order, with the earliest activity near the top. This order will later control how tasks appear on the chart.

Use real Excel dates rather than typing dates as plain labels. Excel can then calculate durations and position each task correctly.

Step 2: Calculate Each Task Duration

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

=C2-B2+1

Here, column B contains the start date and column C contains the end date. The extra one counts both the beginning and ending date.

For example, January 7 through January 10 lasts four calendar days. Without +1, Excel would return three days.

Drag the formula down the Duration column. Check a few rows manually, especially tasks lasting one day. A same-day task should display a duration of one.

Step 3: Select the Chart Data

To build the chart, select the Task, Start Date, and Duration columns. You can select non-adjacent columns by holding the Command key while selecting each range.

Include the column headings. Excel uses them to label the chart series. Leave End Date out because it helps calculate the schedule but does not need to appear as a visible bar.

For the example above, you would select:

• A1:A5 for task names.
• B1:B5 for start dates.
• D1:D5 for durations.

You can also place the three needed columns beside each other in a separate chart area. That approach often makes selection easier when the schedule contains many planning columns.

Step 4: Insert a Stacked Bar Chart

With the required ranges selected, open the Insert tab in Excel for Mac. Choose Bar Chart, then select 2-D Stacked Bar.

Excel will create two horizontal series. The first represents the number of days from the beginning of Excel's date system. The second represents the task duration.

At this stage, the chart may look strange. You may see large empty spaces before the colored bars, and the tasks may appear in reverse order.

Here's why: Excel is treating the start date as a visible bar. You will hide that bar in the next step, leaving the duration portion positioned along the timeline.

Step 5: Hide the Start-Date Series

Click one of the bars representing the Start Date series. Open the formatting controls, choose Fill, and select No Fill. Then choose Border and select No Line.

The Start Date series will become invisible. The Duration series will remain visible and begin on the correct calendar date.

If you select the wrong series, the duration bars may disappear instead. Click the visible bars again and check the series name in the formatting panel before changing the fill.

The chart now has the basic appearance of a Gantt chart: each task has a horizontal bar whose position reflects its start date and whose length reflects its duration.

Step 6: Put Tasks in the Correct Order

Excel often places the first task at the bottom of a bar chart. To reverse the order, click the vertical task axis and open Format Axis.

Enable Categories in reverse order. The first task will move to the top, matching the order of your schedule.

You may also need to adjust the horizontal date axis. Set the minimum bound close to your earliest start date. This removes unnecessary empty space before the first task.

Use a major unit that fits the project length. Weekly intervals work well for a two-month project, while daily intervals may help with a short launch plan.

Step 7: Format and Update the Timeline

Remove the chart title if the surrounding page already explains the schedule. Add a clear title when the chart will be shared by itself.

Then adjust the following settings:

• Choose a readable color for task bars.
• Reduce the gap width to make bars easier to compare.
• Use a consistent date format on the horizontal axis.
• Remove unnecessary gridlines.
• Increase the chart height when task names feel crowded.

To show progress, add a second duration column for completed work. For example, calculate completed duration with a formula such as:

=MIN(TODAY(),C2)-B2+1

Use that value carefully. It assumes the task is active and may need additional logic for future or completed tasks. A safer approach uses a Status column and separate formulas for planned and completed work.

Save a backup copy before making major formatting changes. Then update start dates, end dates, and progress values as your project develops.

How the Excel Gantt Chart Works

A Gantt chart in Excel is a stacked bar chart that uses one invisible series to create spacing. The visible series shows the duration of each task.

Imagine placing a block of wood on a long ruler. The invisible Start Date series moves the block to the right position. The visible Duration series determines how long the block appears.

This method works because Excel stores dates as sequential numbers. A later date has a larger numeric value, so the start-date series naturally shifts a task farther along the horizontal axis.

The Three Values Behind Every Bar

Each task needs three useful values:

• Start date: Controls where the bar begins.
• End date: Defines when the task should finish.
• Duration: Controls the visible bar length.

For example, a task beginning on March 2 and ending on March 6 has a five-day duration when both dates count.

If you use business days rather than calendar days, use the NETWORKDAYS function. A simple formula looks like this:

=NETWORKDAYS(B2,C2)

You can include a holiday range when your project excludes public holidays:

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

This distinction matters for office projects. A nine-day calendar duration may represent only seven working days when a weekend falls inside the task period.

How to Add Milestones and Dependencies

Excel's basic Gantt chart shows timing clearly, but it does not automatically understand every project relationship. You need to represent milestones and dependencies deliberately.

Adding Milestones

A milestone usually has zero working duration, such as a sign-off, launch, or approval. Since a zero-length bar may be invisible, give the milestone a duration of one day.

Then format its bar with a different color. You can also place a diamond shape over the relevant date.

For example, add “Design approved” as a one-day row on January 14. Use a dark marker so it stands apart from multi-day design work.

Showing Dependencies

Dependencies explain why one task cannot start before another finishes. Excel does not automatically draw dependency arrows in a standard stacked bar chart.

You can record relationships in a separate column:

For a simple plan, the dependency column may be enough. For a complex plan, use formulas that calculate a task's start date from the prior task's end date.

For example:

=C2+1

This starts the next task one day after the previous task ends. Add a lag period when the next task must wait several days.

How to Track Progress in the Chart

A planning chart becomes more useful when it shows what has already been completed. You can create this view by layering planned duration and completed duration.

Create a Progress Column

Add columns for Status, Percent Complete, and Completed Duration. If a task lasts ten days and is 40 percent complete, its completed duration equals four days.

A simple formula is:

=D2*E2

Here, D2 contains the planned duration and E2 contains the completion percentage written as a decimal.

For 40 percent, enter 40% rather than 40. Excel will then calculate the correct portion.

Use a Separate Progress Chart

A separate progress chart is usually easier to manage than adding too many series to one visual. Keep the original plan in one chart, then create a second chart for current progress.

Use a muted color for planned work and a stronger color for completed work. For example, pale blue can represent the full schedule, while dark blue shows completed effort.

This creates an immediate comparison. A bar with a short dark section and a long pale section needs attention.

Update the Schedule Regularly

Choose a review rhythm that matches the project. A weekly update works for a marketing campaign, while a daily update may suit a product launch.

During each review, check whether:

• Tasks started when expected.
• End dates still reflect the current plan.
• Dependencies have created delays.
• Milestones remain achievable.
• Completed percentages reflect actual progress.

A chart becomes misleading when the dates stay unchanged while the project moves forward. Treat updates as part of the planning routine.

Common Excel Gantt Chart Mistakes

Most problems come from date handling, chart selection, or inconsistent updates. The mistakes below are easy to spot once you know what to inspect.

Using Text Instead of Real Dates

If Excel treats “March 2, 2026” as text, the chart cannot position it correctly. Select the date cells and check whether Excel aligns them like numbers.

Use the date format controls to display dates consistently. Re-enter a value when Excel refuses to recognize it.

Choosing a Clustered Bar Chart

A clustered bar chart places series side by side. A Gantt chart needs the Start Date and Duration series stacked together.

If the bars appear beside each other, change the chart type to 2-D Stacked Bar.

Forgetting the Extra Day

The formula =C2-B2 counts the gap between dates. It does not count both endpoints.

Use =C2-B2+1 for calendar-day durations when January 6 through January 6 should equal one day.

Leaving Tasks in Reverse Order

A reversed task axis makes the schedule harder to scan. Turn on Categories in reverse order so the earliest task appears at the top.

Adding Too Many Visual Elements

Colors, labels, arrows, icons, and extra series can make a small chart difficult to read. Keep the main chart focused on dates, duration, progress, and key milestones.

Natural Project Timeline Solution: ONES.com

Value Proposition

ONES.com combines project management and knowledge management in one platform. ONES Project can support structured schedules, while ONES Wiki can keep planning guidance and team knowledge connected.

It may suit teams that have outgrown manually maintained Excel timelines and need stronger workflow control, reporting, or collaboration.

Core Capabilities

Manual timeline updates

Pain: Changing dates in Excel can require several manual adjustments.

ONES capability: ONES Project supports custom workflows, fields, sprint management, and automation.

Result: Teams can move work through defined stages with fewer repetitive updates.

Limited project visibility

Pain: A single chart may hide ownership, status, risks, and related work.

ONES capability: Built-in reporting provides broader views of project progress and team activity.

Result: Managers can review schedule health without relying on one visual timeline.

Complex Jira migration concerns

Pain: Teams often worry that changing platforms will disrupt familiar planning habits.

ONES capability: ONES Project supports Jira-compatible workflows and can serve as a Jira alternative.

Result: Teams can preserve familiar process patterns while evaluating another platform.

Too many plugins

Pain: A growing collection of add-ons can create maintenance work and inconsistent experiences.

ONES capability: Core project planning, reporting, custom workflows, fields, and automation are available within the platform.

Result: Teams may reduce reliance on separate extensions for everyday project control.

Restricted network requirements

Pain: Some organizations cannot place project information in a public cloud environment.

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

Result: Teams can evaluate a deployment model that matches their security and network requirements.

Different features across deployment models

Pain: Self-hosted systems sometimes lack capabilities available in hosted products.

ONES capability: ONES.com provides full feature parity between its cloud and self-hosted versions.

Result: Deployment decisions can focus on infrastructure needs rather than losing core functionality.

Separate planning and team knowledge

Pain: Project decisions can become difficult to find when planning and guidance live in disconnected places.

ONES capability: ONES Wiki provides a knowledge management area alongside ONES Project.

Result: Teams can connect project work with procedures, decisions, and shared guidance.

Small-team budget pressure

Pain: A small team may need structured project management without paying for a large rollout immediately.

ONES capability: The free plan supports up to 30 seats.

Result: A smaller team can test a structured workflow before committing to broader adoption.

Application Scenarios

Software release planning: A development team can organize sprints, connect requirements with delivery work, and use reporting to review progress. A Gantt-style view can complement sprint planning when several releases overlap.

Marketing campaign coordination: A campaign team can track creative work, approvals, launch activities, and post-launch analysis. Custom fields can identify channels, owners, and campaign phases.

Restricted-network project management: An organization with strict network controls can evaluate an On-Premise, Private Cloud, or Air-gapped deployment. This approach may provide more control than a locally maintained Excel timeline.

Common Challenges and Practical Solutions

The chart becomes too wide

Problem: A long project creates a timeline with tiny bars and unreadable labels.

Solution: Change the horizontal axis to weekly or monthly intervals. Create separate views for detailed planning and executive review.

Weekends distort the schedule

Problem: Calendar-day durations make tasks appear longer than the available working time.

Solution: Use NETWORKDAYS for workday calculations. Add a holiday range when your team observes non-working dates.

Tasks overlap unexpectedly

Problem: Two activities appear to run at the same time even though one should wait for the other.

Solution: Add a dependency column and calculate the later start date from the earlier end date. Review the relationship during every schedule update.

Progress percentages feel unreliable

Problem: A task marked 80 percent complete may still contain a difficult final step.

Solution: Pair percentage estimates with clear completion criteria. For example, define “testing complete” as all priority scenarios passing review.

The chart does not print clearly

Problem: Small labels and light colors disappear on a printed page or PDF export.

Solution: Increase contrast, enlarge task labels, and set a print area that includes the entire timeline. Preview the result before sharing it.

FAQs

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

Yes. You can build one with a task list, start dates, end dates, duration formulas, and a stacked bar chart. Excel templates can save time, but the manual method gives you more control over formulas, colors, milestones, and progress tracking. The seven-step process above works in current desktop versions of Excel for Mac.

Why do my Excel Gantt bars start on the wrong date?

The Start Date series may still be visible, or Excel may be reading your dates as text. Check that each date is recognized as an Excel date. Then format the Start Date series with no fill and no border. Finally, adjust the horizontal axis minimum bound so the timeline begins near your earliest planned activity.

How can I show weekends in an Excel Gantt chart?

Use calendar-day durations when weekends should appear as part of the schedule. Calculate duration with the end date minus the start date plus one. If your team works only on weekdays, use NETWORKDAYS instead. The correct choice depends on whether the timeline represents elapsed time or available working time.

Can I add dependencies and milestones to an Excel timeline?

Yes. Add a dependency column to record which activity must finish first. Use one-day rows for milestones, then apply a distinct color or marker. Excel does not automatically manage every dependency in a basic stacked bar chart, so review relationships manually or use formulas that calculate later start dates.

When should I use project management software instead of Excel?

Excel works well for small, stable plans with limited contributors. Consider project management software when many people edit the plan, tasks change frequently, approvals matter, or you need automated reporting and permissions. A platform can also connect schedules with discussions, workflows, and shared knowledge.

Conclusion

You can create a useful Gantt chart in Excel for Mac by combining start dates and durations in a stacked bar chart. Hide the Start Date series, reverse the task order, adjust the date axis, and format the visible bars for clarity.

Keep the chart accurate by using real dates, choosing calendar or working-day formulas carefully, recording dependencies, and updating progress on a regular rhythm.

But here's the practical takeaway: Excel is a solid choice for a straightforward project timeline. When schedules become collaborative, approval-heavy, or difficult to maintain manually, a structured platform such as ONES.com may provide a more scalable workflow.