How to make a Gantt chart in Excel (step-by-step)
A Gantt chart turns a list of tasks into a timeline you can actually read: who does what, when it starts, and when it ends. Excel is the tool most people reach for first, and you can build a working Gantt chart there in a few steps. This guide shows you exactly how to do it, from the task table to the finished chart. It also covers where the Excel method runs out of road, how an Excel schedule imports straight into FlexiProject, and how you export a finished schedule back out to Excel, PDF, or Microsoft Project. Grab the free template below and follow along.
Key takeaways:
- What you need before building a Gantt chart in Excel
- How to make a Gantt chart in Excel in five steps
- The limitations of a Gantt chart in Excel
- A better alternative: the Gantt chart in FlexiProject
- How to import an Excel schedule and export it back out
What you need to build a Gantt chart in Excel
The task table behind every Excel Gantt chart
Every Gantt chart starts with structured data, not with the chart itself. Before you create anything visual, lay out a clean task table, because the chart is only as good as the data behind it. The backbone of that table is your work breakdown structure (WBS): break the project into summary tasks, then split each summary task into the smaller tasks that deliver it. A simple example: a summary task “1. Design” might contain “1.1 Draft layout”, “1.2 Internal review”, and “1.3 Final approval”. This hierarchy is what makes a schedule readable later, whether it lives in Excel or anywhere else.
Start the table with a WBS column that numbers this structure (1, 1.1, 1.2, 2, 2.1 and so on), so the order and the parent-child relationship are obvious at a glance. Then add the four columns that do the heavy lifting: task name, start date, end date, and owner. The chart itself needs one more value, duration, which is simply the number of days between the start and end date. Keep dates in real date format, not text, because Excel needs to treat them as numbers to position the bars correctly on the timeline.
One rule matters for summary tasks: their dates are not typed in, they are derived. A summary task starts on the earliest start date of its subtasks and ends on the latest end date of its subtasks. If a subtask slips, the summary task should stretch to match. In Excel you maintain this by hand, with MIN and MAX formulas across the subtask rows, and it is one more thing to keep in sync. That same structure, WBS, name, start, end, owner, is exactly what tools like FlexiProject expect when you later import the file, so it pays to get it right from the start.
Free Excel Gantt chart template (download)
You do not have to build the table from a blank sheet. The free template above already has the right columns set up, WBS, task name, start date, end date, owner, and duration, plus a working stacked bar chart wired to the data. Replace the sample rows with your own tasks and the chart updates itself.
The template uses the column layout that maps cleanly onto project software, so the same file you plan in can later be imported into FlexiProject without rework. Download it, fill it in, and use the steps below if you want to understand how it was built or recreate it from scratch.
How to make a Gantt chart in Excel: 5 steps
Step 1: build the task table (WBS, dates, owner)
Open a blank sheet and create six columns: WBS, Task, Start date, End date, Owner, and Duration. In the WBS column, number your structure (1, 1.1, 1.2, 2 and so on) and enter tasks in that order, summary tasks first with their subtasks listed underneath. In the Duration column, subtract the start date from the end date so Excel returns the number of days. For summary-task rows, use MIN of the subtask start dates and MAX of the subtask end dates instead of typing the dates by hand. Make sure the date cells are formatted as dates, not text, or the chart will not plot correctly.
Step 2: insert a stacked bar chart
Select the Task and Start date columns, then open the Insert tab and choose a 2-D stacked bar chart. Excel does not have a dedicated Gantt chart type, so this stacked bar is the foundation you will shape into one. Next, add the Duration column as a second data series, so each row now shows two stacked segments: the start offset and the task length.
Step 3: hide the start-date series
This is the trick that turns a plain bar chart into a Gantt chart. Click on the first series, the one based on the start date, open the fill options, and set it to No fill. The start-date segment becomes invisible, and what remains is a duration bar that appears to float and begin on the correct date. Repeat for the border if any line still shows.
Step 4: reverse the task order and fix the date axis
By default Excel plots the first task at the bottom. Open the vertical axis options and tick “Categories in reverse order” so your tasks read top to bottom, the way a Gantt chart should. Then adjust the horizontal date axis: set the minimum and maximum bounds to your project start and end dates so the bars fill the chart instead of squeezing into a corner. Excel stores dates as serial numbers, so you may need to enter those bounds as numbers.
Step 5: format the Gantt chart
Tidy up the result. Narrow the gap width so the bars look like a proper timeline, color the duration bars, add data labels or task names if they help, and clean up the gridlines. If you want to show progress, some people add a third, darker series sized to the percent complete, though this adds yet more manual maintenance. At this point you have a readable Gantt chart in Excel.
Stay on schedule! Test the Gantt chart in FlexiProject with 30 days free access.
Limitations of a Gantt chart in Excel
No task dependencies or critical path in Excel
An Excel Gantt chart is a picture, not a schedule. The bars do not know about each other. If task B can only start after task A finishes, Excel will not enforce that, and it will not move task B when task A slips. There is also no critical path: Excel cannot calculate which chain of tasks actually determines your end date, which is the single most useful thing a real schedule tells you.
Manual updates that break at scale
The first chart is satisfying. The tenth update is not. Every time a date changes, you edit the table, re-check the duration formula, and often re-touch the axis bounds and formatting. For a five-task plan this is fine. For a fifty-task project that shifts weekly, it becomes a part-time job, and every manual edit is a chance to introduce an error that no one catches until it matters.
No milestones, attachments, or comments
A serious schedule carries more than bars. It has milestones to mark key decision points, attachments so the spec or drawing sits on the task it belongs to, and comments so the team can discuss a task in context. Excel gives you a cell and a chart. There is nowhere natural to pin a milestone, attach a file to a specific task, or hold a conversation about why a date moved.
No notifications and no cross-project view
Excel will never tell anyone that a task is due tomorrow or already overdue; the file just sits there until someone opens it. And because each project lives in its own spreadsheet, there is no single place to see tasks across several projects at once. The moment you run more than one project, or work with a team that needs reminders, the spreadsheet stops keeping up.
A better alternative to a Gantt chart in Excel: FlexiProject
An intuitive Gantt chart, no formatting tricks
FlexiProject comes with a Gantt chart, so there is no stacked bar workaround and no invisible series to maintain. You drag a task to move it on the timeline, drag its edge to change the duration, and drag a handle to set progress, and the dates update on the spot. Dependencies are not a formula; you draw a line from one task to another with the mouse, and the schedule respects it. A single switch overlays the critical path, the line of today, milestones, and resource load, and bulk edit lets you change owners or dates across many tasks at once. In other words, everything the Excel method cannot do is the default here.
Visualize your tasks with FlexiProject Gantt chart, get a full 30-day free access.
Move your schedule in and out of FlexiProject
Import your Excel Gantt chart into FlexiProject
You do not lose the work you put into Excel. FlexiProject imports your spreadsheet directly: go to the Projects tab, click New Project, and choose “From Microsoft Excel”. Attach your file, then map each column to the matching field, task name, start, end, owner, and skip anything you do not need. Set the date format if Excel used a regional one, pick the functionalities you want, and the system builds a live project from your data and opens it on the schedule. The clean task table from Step 1 is exactly what makes this mapping painless.
Already living in Microsoft Project? The same flow handles .mpp files through the “From Microsoft Project” option, mapping Name, Start, Finish, and Predecessors so your dependencies come across too.
Export from FlexiProject to Excel, PDF, PNG, and Microsoft Project
Working in FlexiProject does not lock your data in. From the schedule list you can export the whole schedule to an Excel file or to an XML file that opens in Microsoft Project. From the Gantt chart view you can export the timeline as a PDF for reports and archiving, as a PNG to drop into a presentation, or as XML for Microsoft Project. The export keeps your current view, including filters and zoom, so what you send is what you see.
Gantt chart in Excel: FAQ
Does Excel have a built-in Gantt chart?
No. Excel has no dedicated Gantt chart type. You create one by building a stacked bar chart and making the start-date series invisible, as described in the steps above. It works, but it is a workaround rather than a purpose-built feature.
Can you show task dependencies in an Excel Gantt chart?
Not automatically. You can draw arrows manually, but Excel will not link tasks or move a dependent task when its predecessor changes. For real dependencies and a calculated critical path, you need scheduling software built for it.
How do I import an Excel schedule into project software?
In FlexiProject, go to Projects, click New Project, and choose “From Microsoft Excel”. Upload the file, map each column (task name, start, end, owner) to the matching field, and the system creates a live project from your spreadsheet.
Can I export a Gantt chart from FlexiProject to Excel or PDF?
Yes. The schedule list exports to Excel or to Microsoft Project XML, and the Gantt chart view exports to PDF, PNG, or XML. The exported file keeps your current filters and zoom level.
Is Excel good enough for project scheduling?
For a small, stable plan, it can be. Once you have dependencies, milestones, a team that needs notifications, or several projects to track at once, a manual spreadsheet stops keeping up and a dedicated tool saves more time than it costs.
From a quick chart to a living schedule
Building a Gantt chart in Excel is a useful skill, and for a quick, one-off view it does the job. The method is simple once you know the stacked-bar trick: structure your tasks with a WBS, fill in names, dates, and owners, and shape the chart from there. What Excel cannot do is keep that schedule alive. Dependencies, critical path, milestones, attachments, notifications, and a view across projects all sit outside its reach. That is the line where a dedicated tool earns its place. With FlexiProject you draw the same schedule once, the chart maintains itself, and you can move data in from Excel or out to Excel, PDF, and Microsoft Project whenever you need to. If you already have a spreadsheet, import it and see the difference on your own project.
