A Gantt chart shows a project as a set of horizontal bars on a timeline. Each bar starts on the date a task begins and has a length equal to the task duration, so you can see at a glance what happens when, what overlaps and what is late. Excel has no ready-made Gantt chart type, but you can build one in a few minutes with a stacked bar chart. This guide shows the data layout, the chart steps, how to hide the first series, how to put the tasks in the right order, how to add a line for today, and how to update the chart when the plan changes. A five-task example with numbers you can check is used throughout.
Updated November 2026
In this guide
- What you need
- Example data
- Step 1: insert a stacked bar chart
- Step 2: hide the start series
- Step 3: put the tasks in the right order
- Step 4: fix the date axis
- Step 5: polish the chart
- Step 6: add a today line
- A faster grid Gantt with conditional formatting
- Update the plan
- Add dependencies and progress
- Share and print the chart
- Practice problems
- Quick recap
What you need
A Gantt chart needs three columns: the task name, the start date and the duration in days. The end date is optional, because it can be calculated. Excel stores dates as numbers, which is why a bar chart can place a bar at a start date and give it a length in days. Before you start, make sure the start dates are real dates and not text, and that the duration is a plain number.
Example data
Use five tasks. Plan starts on 1 March 2027 and lasts 5 days. Design starts on 8 March and lasts 10 days. Build starts on 22 March and lasts 15 days. Test starts on 12 April and lasts 7 days. Launch starts on 21 April and lasts 3 days. Put the headers Task, Start and Days in A1:C1 and the five rows below. In D2 add the end date with =B2+C2-1, so Plan ends on 5 March, which is 1 March plus 5 days minus 1.
Step 1: insert a stacked bar chart
Select A1:C6, which holds the task names, the start dates and the durations. Go to Insert, choose the Bar chart icon and pick Stacked Bar. Excel draws two series for each task: the first is the start date, shown as a long bar from zero, and the second is the duration. The start bars are very long because dates are large numbers, around 46,000 for 2027. The next step hides them, so that only the duration bars are visible.
Step 2: hide the start series
Click one of the start bars so that the whole series is selected. Right-click and choose Format Data Series, then set Fill to No fill and Border to No line. The invisible bars still push the duration bars to the correct place on the timeline. If you do not see the Fill option, open the paint bucket icon in the format pane. After this step the chart shows only the duration bars, floating at their start dates, which is the Gantt look.
Step 3: put the tasks in the right order
By default, Excel lists the first task at the bottom of the chart. Click the task names on the vertical axis, open Format Axis and tick Categories in reverse order. Plan now appears at the top and Launch at the bottom, in the same order as your list. The date axis moves to the top of the chart after this change. To move it back to the bottom, set Horizontal axis crosses to At maximum category in the same pane.
Step 4: fix the date axis
The date axis starts at zero or at a strange number. Click the date axis, open Format Axis and set the Minimum to the first start date, 1 March 2027, which is the number 46447. To find the number, type the date in a cell and format it as General. Set the Maximum to the last end date, which is 23 April 2027. Set the major unit to 7 for weekly gridlines. If you prefer, format the axis labels as d mmm. The bars now fit the plan neatly in the chart area.
Step 5: polish the chart
Reduce the Gap width to about 40 percent to make the bars thicker. Pick a color that matches your brand and remove the legend, since only one visible series remains. Delete the chart title or replace it with the project name. Light gridlines help the reader trace the dates. Do not add data labels to the bars unless they are needed, because they can clutter a small chart. A clean chart is easier to read in a meeting or in a printed report.
Step 6: add a today line
A line for today shows how the project stands. One simple way is to add a column with the formula =TODAY() and plot it as a scatter series with error bars. A quicker way for beginners is to use conditional formatting in a grid-style Gantt, with a date row across the top and a rule such as =AND(F$1>=$B2,F$1<=$D2) that fills the cells between the start and end dates. Add a second rule for the column where the date equals TODAY and give it a red border.
A faster grid Gantt with conditional formatting
For small plans, a grid is often easier than a chart. Put the dates across row 1 from F1 onward, and select F2:AZ6. Add a conditional formatting rule with the formula =AND(F$1>=$B2,F$1<=$D2) and choose a fill color. Every cell that falls between the start and end of a task is colored, so the bars appear automatically. When you change a start date or a duration, the colored bar moves with it. This method needs no chart and prints well, and our project tracker guide shows how to combine it with status columns.
Update the plan
The chart is linked to the cells, so it changes when you edit them. Move Build to start on 29 March and the bar slides to the right. Change its duration from 15 to 20 days and the bar grows. If you add a task at the bottom, right-click the chart, choose Select Data and extend the ranges, or convert the data to a table with Ctrl+T so that the chart grows with it. Our named range guide explains how names can also keep the ranges flexible.
Add dependencies and progress
For simple dependencies, set the start date of a task to the end date of the previous one plus one day. For example, Design could start with =D2+1, which is 6 March, but we set it to 8 March because 6 and 7 March fall on a weekend. Use =WORKDAY(D2,1) to skip weekends automatically. For progress, add a column with the percentage complete and a second visible series of the completed days. A task of 10 days that is 40 percent done has 4 completed days, which you can show in a darker color.
Share and print the chart
Before you share the chart, check how it looks on paper. Go to Page Layout, set the orientation to Landscape and use Fit to 1 page wide, so the whole timeline appears on one sheet. Copy the chart into PowerPoint or Word with Paste as Picture if the reader should not edit it, or keep it linked if it should update. Add the project owner and the date of the last update in a cell above the chart. For a long project, build one chart per phase, since a chart with more than about 20 tasks becomes hard to read. Keep the task names short so they fit beside the bars.
Practice problems
Try these. Problem 1: a task starts on 1 March and lasts 5 days, so its end date is 5 March. Problem 2: a task starts on 22 March and lasts 15 days, so it ends on 5 April. Problem 3: with Test starting on 12 April and lasting 7 days, the end date is 18 April. Problem 4: the whole plan runs from 1 March to 23 April, which is 54 days in total. Problem 5: build the chart and move one task to see how the bar changes. Problem 6: build the grid version with conditional formatting and compare it with the chart.
Quick recap
Set up Task, Start and Days columns, select them and insert a stacked bar chart. Hide the start series with No fill, reverse the category order so the first task is at the top, and set the date axis minimum and maximum. Narrow the gap width and remove the legend. For a quick plan, use a conditional formatting grid with the formula that compares each date with the start and end dates. Update the dates in the table and the chart follows. This works in all modern versions of Excel without add-ins.
Frequently asked questions
How do I make a Gantt chart in Excel?
Use a stacked bar chart with start dates and durations, then hide the start series.
Does Excel have a Gantt chart template?
Yes, Excel offers Gantt chart templates under File, New, but a stacked bar chart gives you full control.
How do I put the first task at the top?
Format the vertical axis and tick Categories in reverse order.
How do I show today on a Gantt chart?
Use TODAY in a helper column or a conditional formatting rule.
Can I make a Gantt chart without a chart?
Yes, use conditional formatting on a grid of dates.


