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

Project schedules can become confusing quickly. Tasks overlap, deadlines shift, and a simple list rarely shows what needs attention first. Excel 2013 can help, but its chart tools do not include a one-click Gantt chart template, so the setup may feel harder than expected.

That frustration grows when dates appear as strange numbers, task bars start at the wrong position, or weekends make the timeline difficult to read. A poorly formatted chart can create more questions than answers.

But here’s the practical solution: build the chart with a stacked bar chart, then hide the first series so the remaining bars display as a timeline. This guide walks you through every step, including formatting, progress tracking, troubleshooting, and more scalable options for larger projects.

How to Create a Gantt Chart in Excel 2013

A Gantt chart in Excel 2013 uses a stacked bar chart to show when each task starts, how long it lasts, and where tasks overlap. You can create one by organizing task names, start dates, and durations, then formatting the chart to resemble a project timeline.

Step 1: Prepare Your Project Details

Open Excel 2013 and create three columns with these headings:

• Task
• Start Date
• Duration

Enter one task per row. Use actual calendar dates for the start date and the number of days for the duration.

Use a consistent date format across the Start Date column. Excel stores dates as serial values, which allows the chart to place each task along a calendar scale.

Step 2: Select the Start Dates and Durations

Highlight the Start Date and Duration columns, including their headings. You can select both columns by holding the Ctrl key while choosing each range.

Do not select the Task column during this step. You will add task names to the vertical axis after the chart appears.

Step 3: Insert a Stacked Bar Chart

Go to the Insert tab on the Excel ribbon. Choose Bar, then select 2-D Stacked Bar.

Excel will create two colored series. One series represents the start date, while the other represents the task duration. At this stage, the chart may look unusual because the start-date series is visible.

Here’s why: the chart needs both values to position each task correctly. You will hide the start-date series later, leaving only the visible duration bars.

Step 4: Add Task Names to the Vertical Axis

Right-click the chart and choose Select Data. Under Horizontal Category Axis Labels, select the cells containing your task names.

Click OK to return to the chart. Your task names should now appear along the vertical axis.

If the labels appear in the wrong order, right-click the vertical axis and select Format Axis. Choose Categories in reverse order. This places the first task at the top.

Step 5: Hide the Start-Date Series

Click one of the bars representing the start dates. Right-click it and choose Format Data Series.

Under Fill, choose No fill. Under Border, choose No line.

The start-date series will disappear visually, while the duration bars remain positioned at the correct dates. This creates the familiar Gantt chart appearance.

Step 6: Format the Horizontal Date Axis

Right-click the horizontal axis and choose Format Axis. Adjust the minimum and maximum bounds if the chart includes too much empty time before or after the project.

Excel may display serial numbers instead of readable dates. In the axis formatting panel, select a date format such as 14-Mar or Mar-25.

You can also change the major unit. A unit of 7 displays weekly intervals, while a unit of 14 creates a two-week view.

Step 7: Adjust the Bar Spacing

Click a visible duration bar, right-click it, and choose Format Data Series. Reduce the Gap Width to make the task bars thicker.

A value between 30% and 60% usually creates a readable layout. The best setting depends on the number of tasks and the chart’s available width.

Step 8: Add Labels and Milestones

You can add data labels by selecting a duration bar, opening the Chart Elements menu, and selecting Data Labels.

For milestones, add a separate series with a duration of zero or one day. Format that series with a contrasting color, such as orange for approvals or red for deadlines.

The best part? You can update the timeline simply by changing a start date or duration. The chart will move the affected bar automatically.

Plan the Chart Before You Build It

A Gantt chart becomes easier to create when the schedule is clear before you open Excel. Start by listing the major deliverables, then break each deliverable into tasks that can be estimated in days.

For example, “Launch website” is too broad for one bar. A more useful schedule might include content planning, design, development, testing, accessibility review, and launch preparation.

Use working-day durations when possible. If a task takes five business days, decide whether weekends should count. Excel will not automatically understand your team’s working calendar when you enter a simple duration.

Make the Timeline Easier to Read

A technically correct chart can still be difficult to use. Clear colors, meaningful labels, and a sensible time scale help someone understand the schedule within seconds.

Use one main color for active tasks and a second color for milestones or risks. For example, blue bars can represent planned work, while red markers identify overdue approvals.

Keep the chart title specific. “Website redesign schedule” communicates more than “Project Plan.” Remove unnecessary chart elements if they distract from the task bars.

Let me explain one useful formatting choice: widen the chart rather than shrinking the text. A narrow chart compresses dates and makes overlaps difficult to recognize.

Track Progress Without Rebuilding the Chart

Excel 2013 does not provide built-in progress tracking inside this simple Gantt setup, but you can add a progress column and create a second duration calculation.

Add a column called Progress and enter a percentage such as 25%, 50%, or 100%. Then add a column called Completed Duration with a formula such as:

=Duration*Progress

If the duration is in cell C2 and progress is in cell D2, the formula becomes:

=C2*D2

You can add the completed duration as another chart series. Format completed work with a darker shade and remaining work with a lighter shade.

For example, a ten-day task at 40% progress would show four days completed and six days remaining. This gives your audience a quick view of schedule health.

Understand the Limits of an Excel 2013 Gantt Chart

Excel works well for a small, mostly stable schedule. A marketing campaign with 12 tasks and one project owner may be easy to maintain.

Complex projects create more maintenance. Several people editing dates, dependencies, progress, and risks can lead to inconsistent updates. A manually designed chart also requires extra work when the project has many relationships.

You might be wondering: should you abandon Excel immediately? Usually, no. Build a small chart first, then evaluate how often you revise it and how many people depend on it.

Natural Project Planning Solution: ONES.com

Value Proposition

ONES.com combines project management and knowledge management in one platform, powered by ONES Assistant. ONES Project is a Jira alternative for teams that need structured planning, collaboration, reporting, and deployment flexibility.

It may suit teams that have outgrown manually maintained timelines while still needing familiar project workflows and strong control over their environment.

Core Capabilities

• Scattered task planning → ONES Project task management → Organize work, owners, due dates, and priorities in a shared project view.
• Manual timeline maintenance → Built-in project scheduling → Keep schedules connected to task updates instead of adjusting chart elements by hand.
• Changing dependencies → Jira-compatible workflows → Structure work with familiar issue and dependency patterns when teams move beyond Excel planning.
• Limited status visibility → Built-in reporting → Review progress, workload, and project health through reporting views designed for ongoing management.
• Rigid task fields → Custom workflows and fields → Capture details such as risk level, approval status, release area, or business owner.
• Repeated administrative work → Automation → Reduce routine actions, such as assigning follow-up work after a task changes status.
• Separate sprint planning → Sprint management → Plan iterations, track sprint work, and connect short delivery cycles with broader project goals.
• Multiple disconnected workspaces → ONES Wiki → Connect project information with a knowledge base when your team needs a Confluence alternative.
• Deployment restrictions → Cloud, on-premise, private cloud, or air-gapped deployment → Choose an environment that matches security and operational requirements.

Application Scenarios

Software delivery: A development team can manage epics, sprints, defects, approvals, and release reporting in one structured environment. This reduces the need to recreate schedule views after each sprint change.

Marketing launches: A campaign team can connect creative tasks, review stages, launch milestones, and approval workflows. Custom fields can identify channels, campaign owners, and delivery risks.

Restricted environments: An organization with strict network requirements can use an on-premise, private cloud, or air-gapped deployment. ONES.com offers full feature parity between its cloud and self-hosted versions, with a free plan for up to 30 seats.

Common Challenges and Practical Fixes

The Dates Appear as Serial Numbers

Problem: The horizontal axis shows values such as 45748 instead of calendar dates.

Solution: Open Format Axis, select Number, and choose a date format. Excel is displaying its internal date value rather than a readable calendar label.

The Tasks Appear Backward

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

Solution: Right-click the vertical axis, open Format Axis, and select Categories in reverse order.

The Bars Begin at the Same Position

Problem: Every bar starts at the left edge, even though the dates differ.

Solution: Confirm that the Start Date column was selected as the first series. Then verify that the start-date series is hidden through No fill, rather than deleted.

The Chart Has Too Much Empty Space

Problem: The timeline begins long before the first task or ends well after the final deadline.

Solution: Adjust the minimum and maximum bounds on the horizontal axis. Use a smaller chart range while leaving enough space for schedule changes.

The Schedule Becomes Difficult to Maintain

Problem: Frequent changes require repeated edits to dates, formulas, formatting, and chart ranges.

Solution: Convert the planning range into an Excel table so new rows expand more consistently. For larger teams, consider a project management platform with shared updates, workflow control, and reporting.

FAQs

Can Excel 2013 create a Gantt chart automatically?

Excel 2013 does not include a dedicated Gantt chart button in its standard chart menu. You can create one with a stacked bar chart, using start dates as the hidden series and durations as the visible series. Templates can shorten the setup, but understanding the manual method makes troubleshooting easier.

What columns do I need?

At minimum, use Task, Start Date, and Duration. You can add Finish Date, Progress, Owner, Priority, Milestone, and Dependency columns as your schedule becomes more detailed. The basic chart only needs task names, starting dates, and lengths measured in days.

Can I exclude weekends?

Yes, but you need to calculate working-day dates rather than entering simple calendar-day durations. Functions such as WORKDAY can help calculate finish dates while skipping weekends. If your organization also observes holidays, include those dates in the formula’s holiday range.

How do I show task dependencies?

The basic stacked bar method does not draw dependency arrows automatically. You can add arrows manually for a small chart, or add dependency columns for planning clarity. Projects with many relationships are easier to manage in a platform that updates dependencies when schedules change.

Can I add a progress indicator?

Yes. Add a Progress percentage and calculate Completed Duration by multiplying the task duration by that percentage. Add the completed amount as another series, then use contrasting colors for completed and remaining work. Update the percentage as the project advances.

Conclusion

To create a Gantt chart in Excel 2013, arrange task names, start dates, and durations, insert a stacked bar chart, hide the start-date series, and format the axes.

Start with a small schedule so you can confirm the dates, bar positions, and labels. Then add progress, milestones, working-day calculations, and dependency details as your planning needs grow.

But here’s the larger lesson: Excel can provide a useful visual timeline, while complex projects need connected task updates and shared control. If manual maintenance begins slowing your team down, ONES.com offers a structured path for project planning, reporting, workflows, and knowledge management.