How to Make a Gantt Chart in Excel (and When to Stop)

Here is how to make a Gantt chart in Excel: list each task with a start date and a duration in days, insert a stacked bar chart, hide the first bar series so only the durations show, and reverse the task order so the plan reads top to bottom. Excel has no built-in Gantt chart type, so you build one from a stacked bar chart that shows start and finish dates.^[1] It takes about fifteen minutes. The spreadsheet holds up for one planner and a short task list.

Set up the Gantt chart template in three columns

Every Excel Gantt chart starts as a plain table. Put Task in column A, Start date in column B and Duration in column C, one task per row. Duration is the number of days the task lasts. If you would rather type end dates, add an End date column and compute duration with a formula: =D2-B2+1, where D holds the end date. The +1 counts the start day itself, so a task that starts and ends on the same day still gets a one-day bar.

Keep the start dates as real dates, not text. Excel stores dates as sequential serial numbers so they can be used in calculations; January 1, 1900 is serial number 1.^[2] That is the whole trick behind the chart. Your start date is just a large number, and the stacked bar adds the duration on top of it. If a date came in as text from another system, =DATEVALUE(B2) turns it back into a usable serial number.

A five-task example for a small website launch:

How to make a Gantt chart in Excel, step by step

These are the menu steps from Microsoft's own help page, plus the one axis fix most guides skip.

1. Select the data. Click any cell inside the table, or select A1:C6 including the headers. A continuous range is picked up whole.
2. Insert the chart. Go to Insert > Recommended Charts > Stacked Bar. Use the plain stacked bar, not the 100% stacked version, which turns every row into a percentage and loses the dates.
3. Hide the start series. Click the first data series (the Start part of each bar), then on the Format tab choose Shape Fill > No Fill. The bars now float at their start dates.
4. Reverse the task order. Select the vertical axis, choose Format Axis, and under Axis position check Categories in reverse order. Task 1 now sits at the top.
5. Trim the empty left side. Select the horizontal date axis, open Format Axis, and set Bounds > Minimum to the serial number of your first start date (type the date in a spare cell, format it as Number, and copy the value).
6. Tidy it. Delete the legend if you don't need it, add gridlines or data labels through Chart Design > Add Chart Element, and pick colors with Change Colors.

To reuse the layout, right-click the chart and choose Save as Template. Microsoft also offers ready-made Gantt chart templates, so you can start from one of those instead of a blank sheet.^[1] A template saves the formatting, not the logic. You still type every date.

The formula version: a Gantt grid with conditional formatting

Some people prefer a grid over a chart. It's easier to print and easier to edit in place. Put your task table in columns A to C as before, with end dates in column D. Then fill row 1 from column F to the right with consecutive dates, one day per column. Narrow those columns so they look like a calendar strip.

Select the grid area under the dates, say F2:AK6, and open Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Enter =AND(INDEX(F:F,1)>=$B2,INDEX(F:F,1)<=$D2) and choose a fill color. Every cell whose date falls inside a task's window now lights up. The references matter. The dollar signs lock the task columns, and INDEX(F:F,1) always reads the date at the top of the current column, so the rule copies correctly across the whole grid.

Add a second rule with =INDEX(F:F,1)=TODAY() and a border to draw a today line down the grid. Add a % Complete column if you want. It stays a number you type. The grid never calculates it.

Google Sheets Gantt chart: two routes

The stacked-bar method works in Google Sheets almost unchanged. Insert > Chart, set the chart type to Stacked bar chart, then in the Customize tab open Series, pick the Start series and set its fill opacity to zero. The conditional formatting grid also carries over, using Format > Conditional formatting > Custom formula is, with the same formula. Nothing else changes.

The faster route is timeline view, if your account has it. Google describes it as an interactive visual layer in Sheets. You need at least one date column, and a complete timeline uses a card title, a start date and an end date (or a duration) per task. Click Insert > Timeline, select the data range, and click OK.^[3] Each row becomes a card on its own tab, and Card group lets you put one owner's tasks on the same row. Timeline view is limited to certain Google Workspace editions, which Google's help page lists, so a personal Gmail account may not see the option. If yours doesn't, fall back to the stacked bar or the grid.

Where an Excel Gantt chart stops working

The spreadsheet Gantt chart is a picture of a plan. It is not a schedule that reacts. That gap shows up in specific, predictable places.

Dependencies don't move

If design slips by three days, the build task that waits on it does not shift. You can write =B3+C3 so a start date follows the previous task's end, and that handles a straight chain. It breaks as soon as one task waits on two others, or a dependency changes. Then you are editing formulas, not managing a project.

Several people edit the same file

A shared workbook works for two people. With five, someone overwrites a date, someone sorts only one column, and the chart quietly plots the wrong bars. Nobody gets told.

Status lives in someone's head

Progress in Excel is a number a person types. Nobody is reminded when a task is due, and nobody is notified when one is late. The project manager becomes the update system, chasing people for percentages every Friday.

The plan outgrows one screen

Past roughly thirty to forty rows, or several projects at once, the chart gets hard to read and slow to maintain. Resource questions like who is overbooked next week have no answer in the sheet.

The threshold is simple to spot. Once you have dependencies that should move together, more than two people updating dates, or a weekly status ritual you run by hand, the spreadsheet is costing more time than it saves. That is the point to move the same plan into a project tool where the Gantt chart is a view of the task list.

Tools that draw the Gantt chart for you

These three keep the bars tied to real tasks, so changing a task's dates changes the chart. Each one starts from the same three columns you just built.

For the full set of options, including Notion, Airtable, ClickUp and Wrike, and how to combine a spreadsheet with a project tool, see our guide to Gantt chart tools. If you are new to the format itself, start with what a Gantt chart is and how to read one.

The bottom line

An Excel Gantt chart is a stacked bar chart with the first series hidden. Three columns, six menu steps, and you have a timeline you can share with a client or print for a kickoff. It is the right tool for a first plan, a solo planner and a short list. It stops being right when tasks depend on each other, when several people change dates, or when you spend Fridays collecting updates. At that point, keep the method and move the plan.