Yes—Microsoft Excel for Microsoft 365 includes online project-planning templates you can search from File > New, and you can also build a Gantt chart from a task list using a stacked bar chart. A template is the quickest start; building one yourself gives you more control over dates, task labels, and formatting.
What an Excel Gantt chart shows
A Gantt chart displays project tasks as horizontal bars positioned along a calendar timeline. Each bar’s location indicates when a task starts, and its length represents how long the task is scheduled to take. Rows commonly represent individual tasks, while the horizontal axis represents dates.
Excel does not have a dedicated Gantt chart type in the standard chart gallery. Most Excel Gantt charts are made with a stacked bar chart: one series represents the space between the timeline’s beginning and each task’s start date, and another represents the task duration. Formatting the first series so it is invisible makes the duration bars appear to start on the correct dates.
This is a visual schedule, not a full project-management system. A basic chart will not automatically manage task dependencies, allocate people, or reschedule work when a deadline changes. Those functions need additional formulas, careful maintenance, or dedicated project-planning software.
Find and choose a template
In Excel for Microsoft 365 on Windows, choose File > New and search for terms such as Gantt or project planner. The available templates can change, and results may include templates from Microsoft’s online collection. Open a result to review its layout before using it; templates differ in how they represent weeks, task status, and project dates.
Choose a template that fits how you will maintain the schedule, rather than judging it only by its appearance. Check whether it has separate columns for task name, start date, end date, and duration, and whether the timeline is daily, weekly, or monthly. A compact weekly view may suit a short project, while a monthly view is easier to read for a longer plan.
- For a quick overview: Pick a template with a simple task list and a clearly labeled timeline.
- For ongoing updates: Look for a layout that makes start dates and durations easy to edit without changing chart formatting.
- For sharing: Check that the sheet prints or exports legibly and that the date scale is understandable without additional explanation.
Before entering project information, read any instructions included in the workbook. Some templates use formulas or named ranges, so inserting rows or changing column locations may affect the chart. Save a working copy with a recognizable project name, and avoid replacing formula cells with typed values unless you understand what those cells control.
Build a basic Gantt chart from a task list
To make a chart yourself, create a small table with one task per row. For example, use columns A through C for Task, Start Date, and Duration. Enter actual Excel dates in column B and the number of calendar days in column C. If you have start and finish dates instead, you can calculate an inclusive duration.
With the start date in B2 and the finish date in C2, enter =C2-B2+1 in D2 to calculate the duration in calendar days. For a task starting June 1, 2026 and ending June 5, 2026, the result is 5 days because both the start and finish dates count. Copy the formula down for other rows. If your plan counts working days instead of calendar days, this simple calculation does not exclude weekends or holidays; use a workday-based method or a template designed for that convention.
- Arrange the task names, start dates, and durations in adjacent columns, with clear headers. Make sure every date is a real Excel date, not text that only looks like a date.
- Select the task, start-date, and duration data, including headers. On the ribbon, choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar.
- If Excel assigns the series or task labels incorrectly, use Chart Design > Select Data to correct the chart data range and category labels.
- Select the start-date series in the chart, open Format Data Series, and set its fill to No fill. The visible duration series should now appear offset according to each task’s start date.
- Format the date axis and task labels so the chart is readable. Adjust the axis bounds or date display if necessary, and reverse the category order if you want the first task at the top.
The precise controls in the Format Data Series and Format Axis panes can vary with the selected chart element. Click a bar or axis first, then use the formatting pane for that element. In Excel for Mac, the same stacked-bar approach is available, although ribbon placement and pane appearance can differ. Excel for the web can create and edit charts, but some detailed formatting controls may be more limited than in the Windows desktop app.
Prepare dates and durations carefully
Date consistency matters because the chart’s horizontal axis is a date scale. Use one date convention throughout the workbook, such as month/day/year or day/month/year, and verify that Excel recognizes the entries as dates. If a date is stored as text, it may not plot where expected. Changing a cell’s number format changes how a recognized date looks; it does not convert text into a date.
Decide whether task duration means calendar days or working days before building the chart. A task planned from Monday through Friday is five calendar days and five typical workdays, but a Friday-to-Monday task spans four calendar days and only two weekdays. Holidays, part-time schedules, and local workweeks can make the difference more significant.
It also helps to distinguish a task’s planned dates from its actual progress. A basic Gantt chart shows a scheduled interval, not necessarily how much work is complete. If progress matters, add a separate percentage-complete column and display it in the task table, or design a second visual layer. Do not assume that changing a completion percentage will automatically shorten or recolor a standard duration bar.
Format the chart for readers
Once the bars are positioned, focus on clarity rather than decoration. Give the chart a descriptive title, show a useful date range, and use a consistent date scale. If the schedule covers several months, weekly tick marks may be more useful than daily labels. Keep task names concise; long labels can make a chart difficult to scan.
- Use a distinct, readable color for task bars and reserve special colors for meaningful categories, such as milestones or phases.
- Sort tasks in a sequence readers recognize, such as project phase or planned start date. Avoid sorting the worksheet in a way that separates task names from their dates.
- Check that the earliest task is visible and that the axis extends far enough to show the last planned finish.
- Use a legend only when the chart has multiple visible series that readers need to distinguish.
Milestones are often single dates rather than multi-day tasks. A duration of zero may not produce a visible bar, so a milestone may need a separate marker, a one-day duration for display, or a dedicated milestone column. If you use a one-day bar, label it clearly so readers do not mistake the display choice for a longer task.
Common problems and how to fix them
Bars begin at the same point. The start-date series may still be visible, the chart may be a clustered bar chart instead of a stacked bar chart, or Excel may have interpreted the data layout incorrectly. Confirm that the chart type is Stacked Bar and set the start-date series to No fill.
Tasks appear in the wrong order. Bar charts can display the first category at the bottom. Select the vertical category axis and use Format Axis to change the category order. Because this can also affect where the date axis crosses the chart, check the finished layout after changing the setting.
The timeline shows numbers instead of dates. Excel stores dates as serial numbers. Select the horizontal axis and change its number format to a date format. Also verify that the source start dates are actual dates rather than text.
New tasks do not appear. The chart may reference a fixed range that stops above the new rows. Update its data range in Chart Design > Select Data, or turn the source list into an Excel table so its data can expand more conveniently. Check the chart after adding rows; a table does not guarantee every template or chart setup will expand exactly as intended.
The schedule looks wrong after changing dates. Review the axis minimum and maximum bounds. Fixed bounds can hide tasks moved outside the original range. Automatic bounds are convenient for a changing schedule, while fixed bounds can be useful for a report that must keep the same time scale.
Templates versus building your own
A downloaded or built-in template saves setup time and may already include formatting, formulas, and a timeline. It is a good choice when its assumptions match the project. However, a template can contain more columns and rules than you need, and unfamiliar formulas can make later edits harder.
A custom chart takes longer initially but makes the data structure easier to understand. It works well for a small schedule with straightforward start dates and durations. For a team that needs dependencies, resource allocation, automatic conflict detection, or frequent baseline comparisons, a spreadsheet chart can become fragile. In that case, dedicated project-management software may be a better fit.
Excel itself is part of Microsoft 365 for subscribers who have an eligible plan, and standalone Excel licensing options may also be available depending on the market. A template found through Excel’s New screen generally does not require a separate template purchase, but check the source and any terms shown before downloading files from elsewhere. Avoid enabling macros in an unfamiliar workbook unless you have a specific, trusted reason to use them.
Frequently Asked Questions
Does Excel have a built-in Gantt chart?
Excel does not list Gantt as a standard chart type. You can search for a project or Gantt template under File > New, or make a Gantt-style chart from a stacked bar chart by hiding the start-date series.
Where can I download a free Excel Gantt chart template?
Start with File > New in Excel and search for Gantt or project planner. Availability can change. If you use another download source, check who provides the workbook and review it before entering important project data.
Can Excel update a Gantt chart automatically?
The chart can reflect changes to dates or durations when its source data and chart range are set up correctly. It will not automatically resolve task dependencies or decide how a changed task should move other work unless you build that logic separately.
Can I make a Gantt chart in Excel for Mac or the web?
Yes. The basic stacked-bar method works in Excel for Mac, and charts can also be created in Excel for the web. Some ribbon locations differ on Mac, and the web version may not offer every detailed formatting control available in desktop Excel.
Should I count weekends in task duration?
That depends on how your project defines a day. A simple end-date minus start-date calculation counts calendar days when you add one for an inclusive range. If the schedule uses working days, account for weekends and any relevant holidays rather than relying on that basic calculation.
Related
- Excel Yellow Color Code: RGB, Hex, and Theme Values
- Excel Wrap Text Shortcut: Keys, Ribbon, and Fixes
- Excel Worksheet vs CSV: Key Differences and When to Use Each
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Build an Org Chart from Excel Data in Microsoft 365To build an org chart from Excel data, first organize each employee on one row with a unique…
- Excel Bar and Whisker Chart: How to Create and Read OneAn Excel bar and whisker chart, more commonly called a box-and-whisker chart or box plot, summarizes the distribution…
- Excel Graph Paper: Create a Grid in a WorksheetYes. You can make graph paper in Excel by setting worksheet columns and rows to small, consistent sizes,…
- Excel Pivot Tables: Analyze Data with Examples and InsightsYes—an Excel PivotTable analyzes a list by summarizing its values and letting you rearrange, filter, group, and compare…
- Add a Data Table to an Excel Chart: Steps and TipsTo add a data table beneath a chart in Excel for Microsoft 365 on Windows, select the chart,…
- Other Levels Excel Dashboard: A Guide to Multi-Level ViewsYes—Excel can show a dashboard at different levels of detail, from a high-level summary to team, product, or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.