How to Make a Gantt Chart in Excel 2013: 7 Simple Steps

Building a Gantt chart in Excel 2013 can feel harder than it should. You have task names, dates, durations, and dependencies scattered across a project plan. Then Excel gives you a regular bar chart that looks nothing like a schedule.

That frustration grows when the chart shows the wrong task order, hides start dates poorly, or becomes difficult to update. A small mistake in date formatting can shift every bar.

But here's the truth: Excel 2013 can create a clear Gantt chart with a stacked bar chart and a few formatting changes. I’ll walk you through seven practical steps, explain common problems, and show when dedicated project software may save time.

How to Create a Gantt Chart in Excel 2013

A Gantt chart in Excel 2013 uses a stacked bar chart. One series positions each task along the timeline, while a second series shows how long the task lasts.

Step 1: Prepare Your Project Schedule

Start by creating three columns in a blank Excel worksheet:

• Task
• Start Date
• Duration

Enter one task on each row. Use real Excel dates in the Start Date column, such as 3/4/2013. Enter each task’s length as a number of days.

Keep task names short enough to read beside the chart. If a task lasts one day, enter 1 in the Duration column.

Here's why: Excel uses the start date to position each bar. It uses the duration value to determine the bar’s visible length.

Step 2: Select the Schedule Range

Highlight the task names, start dates, and durations. Include the column headings, but avoid blank rows or unrelated columns.

For the example above, select the range containing Task, Start Date, and Duration. Selecting the headings helps Excel identify the series names later.

You might be wondering: should you include a separate finish-date column? You can, but you do not need one for a basic Gantt chart. Duration is enough.

Step 3: Insert a Stacked Bar Chart

1. Open the Insert tab on the Excel ribbon.
2. Choose Bar in the Charts group.
3. Select 2-D Stacked Bar.

Excel will create a chart with two colored sections for every task. The first section represents the waiting period before the task begins. The second section represents the task duration.

At this stage, the chart may look confusing. The tasks might appear in reverse order, and the first colored section may dominate the chart.

That is normal. You will format the chart so the first series becomes invisible.

Step 4: Hide the Start-Date Series

Click one of the bars representing the Start Date series. Then use the following menu path:

1. Right-click the selected series.
2. Choose Format Data Series.
3. Open the Fill section.
4. Select No fill.
5. Open the Border Color section.
6. Select No line.

The start-date series will disappear visually. The duration bars will remain in their correct positions along the timeline.

The hidden series still performs an important job. It pushes each duration bar to the correct starting date.

Let me explain: the invisible section is a positioning layer. The visible section is the work period your audience needs to see.

Step 5: Reverse the Task Order

Excel usually places the first task at the bottom of a bar chart. Most project schedules read from the first task at the top to the final task at the bottom.

To reverse the order:

1. Click the vertical task axis on the left side of the chart.
2. Right-click and choose Format Axis.
3. Find the Categories in reverse order checkbox.
4. Select the checkbox.

The task order should now match your schedule. Excel may move the horizontal date axis to the top, which is usually appropriate for a Gantt chart.

If the axis appears in an awkward position, open the axis formatting panel and adjust the setting for where the horizontal axis crosses the category axis.

Step 6: Adjust the Date Axis

The horizontal axis may show serial numbers instead of calendar dates. Excel stores dates as numbers, so the axis needs proper formatting.

1. Click the horizontal date axis.
2. Right-click and choose Format Axis.
3. Open the Number section.
4. Choose a date format such as 3/14 or Mar-13.

You can also adjust the axis minimum and maximum values. Set the minimum close to your project’s first start date. Set the maximum slightly beyond the final task.

For example, a project running from March 4 through March 28 should not display several empty months. A tighter range makes the schedule easier to read.

Step 7: Improve the Chart’s Appearance

Finish the chart by making a few visual improvements:

• Reduce the gap width to make the task bars thicker.
• Choose a clear color for the duration series.
• Remove the legend if it adds little value.
• Add a descriptive chart title.
• Resize the chart so task names remain readable.
• Use consistent date formatting on the horizontal axis.

To reduce empty space between bars, right-click a visible duration bar and open Format Data Series. Lower the Gap Width percentage.

A clean chart might use blue bars, a light grid, and a title such as Website Launch Schedule. Keep decoration limited. The schedule should remain the focus.

What a Gantt Chart Shows

A Gantt chart places project activities on a timeline. Each horizontal bar shows when a task begins, how long it lasts, and when it should finish.

For example, a bar beginning on March 7 and lasting five days gives you a quick view of the activity’s planned window. Several bars can overlap when tasks happen at the same time.

The chart can also reveal scheduling pressure. If testing starts only one day before launch, the limited gap becomes visible immediately.

The Three Pieces You Need

A basic Excel Gantt chart depends on three values:

• Task name: the activity being planned.
• Start date: the calendar date when work begins.
• Duration: the number of days assigned to the activity.

Excel calculates the visible finish position by adding duration to the start date. If a task starts on March 4 and lasts three days, its bar extends across the planned work period.

What the Chart Does Not Track Automatically

A basic chart does not automatically understand task relationships, holidays, progress, or resource availability.

Suppose design finishes late. Excel will not automatically move development unless you update the dates yourself. You also need extra formulas for working-day calculations.

This makes the chart useful for a simple schedule. Larger projects may require stronger planning controls.

How to Add Progress and Milestones

You can make an Excel Gantt chart more informative by adding milestone and progress information. These additions help you compare planned work with actual progress.

Adding Milestones

A milestone usually has no duration. Examples include “Contract signed,” “Prototype approved,” or “Launch day.”

One practical method is adding a milestone series with a one-day duration. Use a different color so the milestone stands apart from regular tasks.

For example, add a row for Prototype approved, use its target date as the start date, and enter a duration of 1. Format that bar with a contrasting color.

Showing Completion Percentage

Add a Complete column with values such as 25%, 60%, or 100%. Then create a second duration series representing completed work.

This approach requires additional chart formatting. You can place the completed portion over the planned bar and use a darker shade for completed work.

For a simple chart, labels may be easier. Add completion percentages beside task names or in a nearby column.

Using Working Days

Calendar days and working days produce different schedules. A five-day duration can include a weekend unless you calculate business days separately.

Excel 2013 includes functions such as WORKDAY and NETWORKDAYS. These functions help calculate dates around weekends and listed holidays.

For example, a task beginning Friday with a five-working-day duration should finish the following Thursday. A simple calendar-day calculation may show Tuesday instead.

Common Formatting Problems and Fixes

Most Excel Gantt chart problems come from date formatting, chart selection, or incorrect series settings. Each issue has a practical fix.

The Chart Shows Numbers Instead of Dates

Excel stores calendar dates as serial numbers. If the horizontal axis displays values such as 41337, format the axis as a date.

Right-click the axis, choose Format Axis, open Number, and select a date format.

The Bars Begin at the Same Point

This usually means the Start Date series was removed instead of hidden. The series must remain in the chart for positioning to work.

Add the Start Date series again if necessary. Then set its fill and border to transparent or absent.

The Tasks Appear Backward

Use Categories in reverse order on the vertical axis. This places the first listed task at the top.

Check the horizontal axis afterward. Excel may shift it to the top, which often improves the schedule’s appearance.

The Date Range Has Too Much Empty Space

Open the horizontal axis settings and adjust the minimum and maximum bounds. Use values close to the project’s actual start and finish dates.

For a two-week plan, displaying an entire year makes the bars appear tiny. A focused range makes differences easier to spot.

The Bars Are Too Thin

Reduce the Gap Width setting in the Format Data Series panel. A lower percentage creates thicker bars.

Keep enough space between rows to distinguish nearby tasks. Extremely thick bars can make the schedule look crowded.

When an Excel Gantt Chart Works Well

Excel is a practical choice for a small project with a stable schedule. A marketing campaign with eight tasks may need only a simple chart and a few status updates.

It also works well for a presentation. You can create a visual schedule, adjust colors, and place the chart inside a project update.

Another useful case involves personal planning. A product launch, home renovation, or training plan can fit comfortably into a compact worksheet.

Here's the trade-off: the chart is easy to start, yet manual maintenance grows quickly. Every date change may require several edits.

When Manual Gantt Chart Maintenance Becomes Difficult

A larger project can contain hundreds of tasks, multiple owners, dependencies, approvals, and frequent changes. Updating each row manually increases the chance of conflicting dates.

Imagine a release plan where development slips three days. If testing, review, training, and launch dates all depend on development, several chart elements need revision.

Dedicated project management software can connect tasks, owners, status updates, workflows, and reports. That reduces repeated editing and gives the team a shared view.

The right choice depends on project complexity. Excel remains useful for a quick visual plan, while structured project management becomes more valuable as coordination increases.

Excel Gantt Chart Solution: ONES.com

Value Proposition

ONES.com combines project management and knowledge management in one platform, with AI support through ONES Assistant. ONES Project is a Jira alternative for teams that need structured planning beyond manual charts.

You can use Excel 2013 for a simple timeline, then move to a connected workflow when task changes, reporting, and collaboration require more control.

Core Capabilities

• Manual chart updates are repetitive: ONES Project connects tasks, schedules, and status changes, reducing repeated timeline edits.
• Task relationships are difficult to maintain: Jira-compatible workflows help teams organize work through structured stages.
• Different projects need different processes: Custom workflows and fields let teams reflect approval, development, testing, or launch steps.
• Iteration planning is scattered: Sprint management gives agile teams a dedicated way to plan and review work.
• Routine actions consume time: Automation can trigger practical workflow actions after defined events.
• Project progress is difficult to summarize: Built-in reporting gives teams a clearer view of status and delivery patterns.
• Plugins create maintenance overhead: Native capabilities reduce the need to assemble many separate extensions.
• Some teams require local deployment: ONES.com supports cloud, on-premise, private cloud, and air-gapped deployments.
• Teams need a low-risk starting point: The free plan supports up to 30 seats for eligible teams.

ONES.com maintains feature parity between its cloud and self-hosted versions. That gives teams more flexibility when security or infrastructure requirements influence deployment decisions.

Application Scenarios

Software release planning: A product team can manage discovery, development, testing, approval, and release stages in ONES Project. Reports show progress without rebuilding a chart after every change.

Hardware development: An engineering team can connect design reviews, prototype work, compliance checks, and manufacturing preparation. Custom fields can capture part numbers, review states, or approval details.

Restricted-network projects: A team with strict network requirements can choose an on-premise, private cloud, or air-gapped deployment. That supports local project coordination while preserving the platform’s core capabilities.

Common Challenges When Building a Gantt Chart

Challenge: Dates Are Entered as Text

Problem: Excel cannot position a bar correctly when a date looks like a date but is stored as text.

Solution: Re-enter the date using a recognized format such as 3/4/2013. You can also use Excel’s date conversion tools, then confirm the cell format is set to Date.

Challenge: Weekends Distort the Schedule

Problem: A duration of five may represent five calendar days, even when your team works Monday through Friday.

Solution: Decide whether the chart uses calendar days or working days. Use WORKDAY for finish-date calculations when weekends and holidays should be excluded.

Challenge: The Chart Is Hard to Read

Problem: Long task names, thin bars, and excessive empty space make the schedule difficult to scan.

Solution: Shorten labels, reduce Gap Width, adjust the date bounds, and enlarge the chart. Use color sparingly to distinguish status or milestones.

Challenge: Changes Create Conflicting Dates

Problem: Manual updates can leave dependent tasks unchanged after an earlier activity moves.

Solution: Review every affected date after a schedule change. For complex projects, use connected task relationships in project management software.

Challenge: Progress Is Updated Inconsistently

Problem: Different team members may use different definitions for “started,” “in progress,” and “complete.”

Solution: Define status rules before updating the chart. Use consistent percentages, colors, or workflow states across the project.

FAQs About Making a Gantt Chart in Excel 2013

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

Yes. You can create one manually with a stacked bar chart. Enter task names, start dates, and durations, then hide the Start Date series. This method gives you control over the chart’s colors, labels, date range, and layout. Templates can save initial setup time, but the underlying chart technique remains the same.

Why does Excel use a stacked bar chart for a Gantt chart?

A stacked bar chart can separate the waiting period before a task begins from the task’s actual duration. You hide the first section, leaving the duration bar positioned along the timeline. A regular bar chart cannot create that same offset as easily because every bar begins from the same starting point.

Can Excel 2013 show task dependencies?

Excel 2013 can display dates that reflect dependencies, but it does not manage those relationships automatically in a basic chart. If one task moves, you must review and adjust related tasks yourself. You can add formulas or use project management software when dependency tracking becomes central to the schedule.

How do I show weekends on an Excel Gantt chart?

A standard chart includes every calendar day between the start and finish dates. To exclude weekends, calculate dates with functions such as WORKDAY and NETWORKDAYS. You can also shade weekend columns visually, helping readers distinguish working time from non-working time.

Can I add a “today” line to the chart?

Yes. Add a separate series with the current date and format it as a narrow contrasting bar or line. You may need to adjust the chart type for that series. A today marker helps compare planned timing with the current date, especially during weekly reviews.

When should I use project management software instead?

Consider dedicated software when your plan includes many owners, frequent changes, dependencies, approvals, or recurring reporting. Excel remains useful for quick schedules and presentations. A project platform becomes more practical when maintaining the chart takes longer than reviewing the work itself.

Conclusion

You can create a Gantt chart in Excel 2013 with seven steps: prepare task details, select the range, insert a stacked bar chart, hide the start-date series, reverse the task order, format the date axis, and polish the design.

Keep the schedule simple, use real Excel dates, and decide whether your durations represent calendar days or working days. Check the chart after every major schedule change.

Excel solves the immediate need for a visual timeline. When manual updates, dependencies, reporting, and team coordination become difficult, ONES.com offers a more connected way to manage project work.

The problem starts with scattered schedule details. The pressure comes from constant manual corrections. The practical solution is to use Excel for straightforward plans and move to structured project management when the work demands it.