Guide · 2026-10-12

How to Create a Gantt Chart in Excel 2016: 7 Easy Steps

Creating a Gantt chart in Excel 2016 can feel harder than it should. You have task names, start dates, deadlines, and durations, yet the finished chart may look like an ordinary bar graph. That makes it difficult to track progress or explain a schedule clearly.

The frustration grows when dates appear in the wrong order, task labels disappear, or weekends make the timeline confusing. A small formatting mistake can force you to rebuild the chart from the beginning.

But here's the solution: Excel 2016 can create a practical Gantt chart with a stacked bar chart and a few formatting changes. Follow these seven steps, and you can turn a simple task list into a readable project timeline.

How to Create a Gantt Chart in Excel 2016

A Gantt chart in Excel 2016 uses a stacked bar chart. The first series creates invisible spacing before each task, while the second series shows the task duration across the timeline.

Here is the complete process:

  1. Build a Three-Column Project Schedule

    Open a blank workbook and create three columns with these headings:

    • Task
    • Start Date
    • Duration

    Enter each activity in its own row. Use real calendar dates in the Start Date column, then enter the number of days for each activity in Duration.

    For example:

    Task Start Date Duration
    Project planning January 6, 2025 3
    Design review January 9, 2025 5
    Development January 14, 2025 10
    Testing January 24, 2025 5

    Keep the task order consistent with the order you want to see on the chart. You can reverse the order later, but starting with a logical sequence saves time.

  2. Calculate Task Durations

    If you already know how many days each task takes, enter those numbers directly. If you have start and finish dates, calculate the duration with a formula.

    Add a Finish Date column, then enter a formula such as:

    =Finish Date-Start Date+1

    For example, if the start date is in cell B2 and the finish date is in cell C2, enter this in the Duration column:

    =C2-B2+1

    The +1 includes both the first and final day. Without it, a task beginning on January 6 and ending on January 6 would show zero days.

    Here's why: Excel stores dates as numbers. Subtracting one date from another returns the number of days between them, which makes date calculations useful for timeline charts.

    For weekday-only schedules, use a workday formula instead:

    =NETWORKDAYS(B2,C2)

    This excludes Saturdays and Sundays. You can also add a holiday range when your schedule needs to exclude company holidays.

  3. Insert a Stacked Bar Chart

    Select the Task, Start Date, and Duration columns, including their headings. Then follow this path:

    1. Choose the Insert tab.
    2. Select Bar Chart.
    3. Choose 2-D Stacked Bar.

    Excel will create a chart with two colored series. One series represents the start-date offset, and the other represents the task duration.

    You might be wondering: why use a stacked bar chart instead of a regular bar chart? A regular bar chart starts every task at the same position. The stacked version lets the duration begin after the correct amount of timeline spacing.

    At this stage, the chart may look wrong. That is normal. The start-date series still appears as a visible color, and the task order may run from bottom to top.

  4. Hide the Start-Date Series

    Click any part of the first colored series. This series usually represents Start Date. Then open the formatting options:

    1. Right-click the selected series.
    2. Choose Format Data Series.
    3. Open Fill & Line.
    4. Select No Fill.
    5. Set the line to No Line.

    The first series will become invisible. The duration bars will remain visible, creating the familiar Gantt chart appearance.

    Be careful when selecting the series. If you format the duration bars instead, your visible task bars may disappear. Use the chart legend or click the left portion of a bar to identify the start-date series.

    The best part? You do not need a special Gantt chart template. The stacked bar chart already provides the structure you need.

  5. Reverse the Task Order

    Excel often places the first task at the bottom of the chart. Most project schedules read more naturally from top to bottom, so reverse the category order.

    1. Right-click the vertical task axis.
    2. Choose Format Axis.
    3. Open Axis Options.
    4. Select Categories in reverse order.

    Your first task should now appear at the top. Excel may move the horizontal date axis to the top of the chart after this change.

    If the chart layout feels awkward, open the axis settings again and adjust the position of the horizontal axis. A small change can make task labels easier to read.

  6. Set the Date Axis

    The horizontal axis may display large serial numbers because Excel stores dates numerically. Format the axis as dates so the timeline is easier to understand.

    1. Right-click the horizontal axis.
    2. Choose Format Axis.
    3. Open the Number section.
    4. Choose a date format such as mmm d or mmm-yy.

    Next, adjust the minimum and maximum bounds. Set the minimum to the earliest start date in your schedule. Set the maximum to a date shortly after the final task ends.

    For example, a project running from January 6 through January 31 might use January 6 as the minimum and February 3 as the maximum.

    A narrow date range gives you more detail. A wider range provides more breathing room. Choose the scale that helps someone understand the schedule in a few seconds.

  7. Format the Chart for Readability

    Your Gantt chart now works. The final step is making it easy to scan during a project meeting.

    • Use one strong color for active task bars.
    • Increase the chart height when you have many tasks.
    • Remove the legend if the hidden start-date series creates confusion.
    • Add a clear chart title.
    • Reduce unnecessary gridlines.
    • Adjust the gap width to make task bars thicker.
    • Use a consistent date format across the timeline.

    To change the gap width, right-click a duration bar, choose Format Data Series, and adjust Gap Width. A lower percentage creates thicker bars.

    Let me explain the goal: the chart should show what starts when, how long it lasts, and where activities overlap. Decoration comes after those three answers.

How the Excel Gantt Chart Works

The chart uses two numerical series. The first series positions each task along the date axis. The second series represents the length of the task.

Suppose a task starts on January 14 and lasts ten days. Excel places the invisible start-date portion at January 14, then displays the visible duration portion for ten days.

Think of the hidden series as empty space before a colored block. That empty space moves the block to the correct location on the timeline.

When you change a start date or duration in the schedule, the chart updates automatically. This makes the chart useful for planning changes, provided your formulas and chart range include every relevant row.

How to Add Progress Tracking

A basic Gantt chart shows planned timing. You can extend it to show progress by adding a second duration series.

Create these additional columns:

If a task lasts ten days and four days are complete, enter 4 under Completed Duration and 6 under Remaining Duration.

Then create a stacked bar chart with three series:

Hide Start Date again. Use a darker color for completed work and a lighter color for remaining work.

For example, a development task might show four dark days followed by six light days. A project manager can immediately see which activities are advancing and which still need attention.

Keep progress numbers current. A chart that shows last month’s progress can create false confidence during a review.

How to Show Milestones and Dependencies

Excel 2016 can display task timing well, although milestones and dependencies require extra planning.

Adding milestones

A milestone has no duration, so it does not appear as a standard bar. You can create a milestone series with a one-day duration, then format it with a contrasting color.

Another approach is adding a shape or text box above the chart. This works for a few major dates, such as a product launch or approval meeting.

Showing dependencies

Dependencies describe relationships between activities. For example, testing may begin only after development is complete.

Excel does not automatically draw dependency arrows in a basic stacked bar chart. You can explain relationships in a separate Notes column or use connectors and shapes for a small schedule.

For a ten-task plan, manual connectors may work. For a 100-task plan, they become difficult to maintain. A dedicated project management platform can handle those relationships more efficiently.

Best Practices for a Useful Timeline

Here's a practical example. A marketing campaign may include research, copywriting, design, approval, scheduling, and launch. Showing only the launch date hides the work that makes the launch possible.

A readable chart also needs a clear audience. A team may need task-level detail, while an executive may need phases and milestones. Create the level of detail that supports the decision being made.

Common Problems and Quick Fixes

The chart shows serial numbers instead of dates

Excel is displaying its internal date values. Format the horizontal axis using a date format such as mmm d. The bars should remain in the same positions.

The bars begin at the same point

The Start Date series may not be included in the chart, or the chart type may be incorrect. Confirm that you selected both Start Date and Duration, then choose a stacked bar chart.

The task order looks upside down

Open the vertical axis settings and select Categories in reverse order. This places the first activity at the top.

The visible bars disappeared

You may have applied No Fill to the Duration series instead of the Start Date series. Undo the change, select the correct series, and hide only the start-date portion.

Weekends make the schedule inaccurate

Basic durations count calendar days. Use NETWORKDAYS when your project operates on weekdays, and adjust the chart values to match working time.

The chart becomes difficult to maintain

Large schedules are challenging when every change requires manual formatting. Consider moving the schedule into a project management platform once you need dependencies, ownership, approvals, progress history, or automated reminders.

Excel Gantt Chart Solution: ONES.com

Excel 2016 works well for a small, mostly static schedule. When your plan includes changing priorities, multiple owners, dependencies, and progress updates, ONES.com provides a more structured project management workspace.

ONES.com product screenshot

ONES Project is a project management platform and a Jira alternative. ONES Wiki is a knowledge management platform and a Confluence alternative. They are sold separately, while ONES.com brings project and knowledge management into one broader platform.

Value Proposition

ONES.com helps you move from a manually maintained timeline to a connected project workflow. You can manage schedules, responsibilities, reporting, and project knowledge in one environment.

Core Capabilities

Application Scenarios

For a software team, you could organize a release through sprints, assign work to owners, track defects, and connect progress reports to the broader delivery plan. That gives the team more context than a bar chart alone.

For an operations team, you could create a workflow for equipment installation. Planning, procurement, installation, inspection, and handoff can each have owners, statuses, and approval points.

For a company with restricted network requirements, an On-Premise or Air-gapped deployment can support project coordination inside the required environment. The choice depends on your security, infrastructure, and collaboration needs.

ONES.com also offers a free plan for up to 30 seats. You can begin with a smaller team, then choose the deployment and project structure that fit your operating model.

Common Challenges

Challenge: The schedule uses inconsistent durations

Solution: Decide whether each number represents calendar days or working days. Use ordinary subtraction for calendar schedules and NETWORKDAYS for weekday-based plans.

Challenge: The chart becomes crowded

Solution: Group activities into phases, shorten task labels, increase chart height, and remove visual elements that do not support a decision.

Challenge: Progress updates are unreliable

Solution: Set a regular update point. For example, ask each owner to update completion every Friday before the weekly review.

Challenge: Dependencies are hidden

Solution: Add predecessor information or move the schedule to a platform that supports relationships between tasks. A timeline shows timing, while dependencies explain cause and effect.

Challenge: Several people edit different versions

Solution: Keep one controlled working copy and define who updates it. For larger teams, use a shared project workspace with permissions, history, and current status information.

FAQs

Can I create a Gantt chart in Excel 2016 without a template?

Yes. You can create one manually with a three-column schedule and a stacked bar chart. The Start Date series creates the spacing, and the Duration series creates the visible task bars. You then hide the Start Date series and format the axes. This method gives you control over colors, labels, date ranges, and progress tracking.

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

A stacked bar chart can place each task at a different point along the horizontal timeline. The invisible Start Date series creates the offset, while the visible Duration series shows how long the task lasts. A regular bar chart cannot create that same date-based positioning as easily.

How do I exclude weekends from the schedule?

Use the NETWORKDAYS function to calculate weekday durations. For example, =NETWORKDAYS(B2,C2) counts Monday through Friday between the two dates. You can also provide a holiday range so company holidays do not count toward the duration.

Can an Excel Gantt chart show task progress?

Yes. Add Completed Duration and Remaining Duration as two separate series. Stack both after the hidden Start Date series, then use different colors for completed and remaining work. This creates a progress view while preserving the planned task position.

When should I use a project management platform instead?

Excel works well for a short schedule with limited collaboration. Consider a project management platform when you need dependencies, automated notifications, ownership, sprint planning, permissions, reporting, or frequent status changes. Those needs create maintenance work that becomes harder to manage as the project grows.

Conclusion

To create a Gantt chart in Excel 2016, build a schedule with task names, start dates, and durations. Insert a stacked bar chart, hide the Start Date series, reverse the task order, format the date axis, and improve the visual design.

Keep your duration calculations consistent, especially when weekends or holidays matter. Add progress series when you need to compare completed and remaining work.

But here's the truth: a manually built chart works best when the schedule is small and changes are limited. As ownership, dependencies, reporting, and collaboration grow, a structured platform such as ONES.com can provide a more maintainable project workflow.

Start with the seven Excel steps for a simple timeline. Then choose the planning approach that helps you see work clearly and act before delays become expensive.