Yes. You can make a Gantt chart in Microsoft Excel by arranging tasks, start dates, and durations, then inserting a stacked bar chart and hiding the start-date series. Excel does not provide a dedicated Gantt chart type, but this method creates a familiar timeline that you can update as a schedule changes.
What a Gantt chart shows
A Gantt chart places project tasks in rows and time along a horizontal axis. Each task appears as a bar: its position shows when the task starts, and its length shows how long it lasts. A chart can make sequencing, overlaps, and the overall project window easier to grasp than a list of dates.
Gantt charts are useful for plans such as launching a website, organizing an event, or coordinating a renovation. For example, a website schedule might include writing, design, development, testing, and launch. If development begins before all the writing is finished, overlapping bars show that parallel work clearly.
An Excel chart is a visual schedule, not a project-management system. It will not automatically know that one task depends on another, assign work, or alert you to a delay. Those details need to be represented in your data or managed with a separate tool.
Prepare the task data
For a straightforward chart, create four columns in this order: Task, Start, Duration, and Finish. Put the headings in row 1 and one task per row below them. Enter actual Excel dates in the Start and Finish columns, rather than dates stored as text. Format those cells as dates with Home > Number Format if Excel displays serial numbers.
For example, a small project might have tasks named Plan, Draft, Review, and Publish. Give each a start date and finish date. Include a duration column because the stacked bar chart needs a numeric length for each task. This example counts both the starting and ending date as project days.
With task names in A2:A5, start dates in B2:B5, duration in C2:C5, and finish dates in D2:D5, enter this in C2:
=D2-B2+1
If a task starts on January 6, 2026 and finishes on January 10, 2026, the formula returns 5 calendar days. Copy it down the duration column using the fill handle. If you intend to count elapsed days instead of counting both endpoints, use a different duration convention consistently; mixing conventions can make bars look a day too long or too short.
For a live schedule, consider formatting the range as a table with Home > Format as Table. A table makes headings easier to work with and can extend formatting when you add tasks. Keep task names concise, since long labels can crowd the chart.
Build the stacked bar chart
- Arrange the columns so Task, Start, and Duration are next to one another, as in the example, and select that range including its headings.
- On Excel for Microsoft 365 on Windows, choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Choose Stacked Bar, not 100% Stacked Bar.
- If Excel places the task names in the legend or uses the wrong categories, select the chart and use Chart Design > Switch Row/Column. You can also use Chart Design > Select Data to check the category labels and series.
- Click the first series, which represents the Start dates, and open Format Data Series. Set Fill to No fill and Border to No line. This makes the series invisible while leaving its values to position the visible Duration bars along the timeline.
- Click the vertical task axis and, in Format Axis, select Categories in reverse order if you want the first task at the top. Adjust the horizontal date axis and chart size as needed.
Excel stores dates as serial numbers, so the Start series can position bars by date and the duration values extend them by days. The horizontal axis may initially display an unsuitable number format or a very broad date range. Select the horizontal axis, open Format Axis, and set its number format to a date format. Under Axis Options, adjust the minimum and maximum bounds to the project period if Excel has included unnecessary space. The available controls can vary slightly by Excel build.
On Excel for Mac, the same basic stacked-bar approach applies: select the data and use the Insert tab’s bar-chart options, then format the series and axes. Ribbon labels or the placement of Format controls can differ between Mac and Windows. Excel for the web can create charts, though some detailed formatting controls may be more limited than in the desktop application.
Format the timeline for readability
A useful chart makes timing clear without turning every task into a different color or adding decorative clutter. Give the chart a descriptive title, such as Website launch schedule, and make it wide enough that dates and task names are legible. If the date axis has too many labels, reduce the number of major intervals or use a shorter date format.
Use one bar color for ordinary tasks, then reserve an accent color for a meaningful category such as milestones or work that needs attention. A milestone has no duration, so it may not appear as a visible bar in this setup. You can represent it with a separate marker series or add a clearly labeled milestone row and format it deliberately; do not give it an arbitrary one-day duration without noting what that means.
To improve the visual order, use the category-axis setting that reverses task order, remove a legend that merely repeats the column names, and keep gridlines light. A chart title and axis labels can be added through Chart Design > Add Chart Element. For a printed schedule, check the page layout and print preview so the full timeline is not split across pages.
Calendar days, workdays, and dependencies
The basic duration formula counts calendar days, so weekends appear on the timeline. That can be appropriate for continuous work, such as curing concrete or waiting for a delivery, but it may misrepresent a team that works Monday through Friday. A normal date-based axis also includes weekends even when no one is scheduled to work.
If the schedule must reflect business days, decide first whether the visual timeline should still show calendar dates with weekend gaps or instead use a compressed working-day scale. Excel date-based chart axes naturally show calendar time; removing weekends requires a different construction, such as a day-by-day grid with conditional formatting or a transformed workday scale. Make the choice explicit so a bar does not imply that work is happening on a weekend.
Dependencies need similar care. A bar chart does not automatically move a successor task when its predecessor slips. You can record a predecessor column and adjust dates manually, or use formulas and more structured scheduling logic, but the simple chart described here is not a dependency engine. For a changing project with many linked activities, specialized project software may be safer and easier to maintain.
Make a Gantt-style grid instead
A chart is not the only way to show a schedule. A calendar grid can put dates across columns and tasks down rows, then color the cells that fall between each task’s start and finish. This style is useful when readers need to see individual days or weeks, and it can be easier to print in a compact layout.
Set up task names and start and finish dates at the left, with a sequence of dates across the top. Use Home > Conditional Formatting > New Rule to create a rule that highlights grid cells when their column date falls within the task’s date range. The exact rule formula depends on the cell layout, so anchor the start and finish columns and the date-header row correctly. Unlike the stacked bar chart, a grid can show weekends as separate columns and shade them differently, but a long project can make the sheet very wide.
Common problems and fixes
- The bars all begin at zero. The Start series may still be visible, or the chart may not be stacked. Confirm that the chart type is Stacked Bar and set the Start series fill and border to No fill and No line.
- The tasks run in the wrong order. Format the vertical category axis and choose Categories in reverse order. Excel may also move the horizontal axis to the top; adjust the axis crossing option if needed.
- The timeline shows large numbers. Those are often Excel date serials. Format the horizontal axis as dates rather than changing the underlying date entries.
- Bars appear too long or too short. Check whether duration counts the finish date. The example uses finish minus start plus one, which counts both dates.
- New tasks do not appear. Check whether the chart’s source range includes the added rows. Using an Excel table can help keep the source data expandable, but verify the chart after adding rows.
- Dates are not recognized. Text that looks like a date may not be a real date value. Re-enter it using a recognizable date format and confirm the cell’s number format.
When Excel is enough—and when it is not
Excel is a practical choice for a small or moderately sized schedule that one person or a small team updates periodically. It is familiar, easy to customize, and useful when the chart needs to sit beside budgets, task notes, or other spreadsheet data. It is also convenient for a static report or a simple plan with few dependencies.
Consider a dedicated project-planning application when several people need to update tasks at once, dependencies must recalculate automatically, resource workloads matter, or you need notifications and progress tracking. Microsoft Project and other planning tools are designed for more formal scheduling. A spreadsheet can still be useful for exporting a summary, but it may become fragile if complex formulas, manual date changes, and multiple chart ranges must all stay synchronized.
Frequently Asked Questions
Does Excel have a built-in Gantt chart?
No dedicated Gantt chart type is included in Excel’s chart gallery. A common workaround is a stacked bar chart with the start-date series hidden, or a date grid colored with conditional formatting.
Can I make a Gantt chart in Excel for free?
If you already have access to Excel, the chart can be built with its standard chart and formatting features; no separate Gantt add-in is required for the basic method. Whether Excel itself is free depends on the license or access plan available to you.
How do I show task progress?
Add a progress percentage to the task data and decide how it should be displayed. A common visual approach is to use an additional series for completed work and another for remaining work, but the chart’s data ranges and stacking must be set up carefully. For a small plan, a separate progress column may be clearer.
Can Excel update task dates automatically when one task is delayed?
Not with the basic chart alone. The chart reflects its source dates, but it does not understand task dependencies. You must update affected dates yourself or build explicit scheduling logic, or use software that manages dependencies.
Can I use working days instead of calendar days?
You can calculate durations or dates around workdays, but the basic date-axis chart still displays calendar time, including weekends. For a compressed workday-only display, use a purpose-built grid or a more specialized schedule design.
Related
- Excel Template for a Social Media Calendar
- How to Freeze Rows and Columns in Excel
- Freeze in Excel: Keep Rows and Columns Visible on Screen
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pie Chart: Exclude Zero Values and Empty SlicesExcel pie charts automatically omit zero values as slices, so you usually do not need to change a…
- Grouped Stacked Column Chart in Excel: How to Make OneExcel does not offer a chart type named grouped stacked column chart, but you can build one with…
- Google Sheets Chart Not Showing All Data? How to Fix ItIf a Google Sheets chart is missing data, first check its source range in the Chart editor, then…
- Does Google Sheets Have Pivot Tables? How to Use ThemYes. Google Sheets has pivot tables, which let you summarize and reorganize rows of data without changing the…
- Excel Pivot Table Repeat Row Labels: How to Do It EasilyTo repeat row labels in an Excel PivotTable, select the PivotTable, choose PivotTable Design > Report Layout >…
- Excel Pivot Tables With Multiple Data Sources: How-ToYes. In Excel for Microsoft 365 on Windows, you can build one PivotTable from multiple tables by adding…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.