Skip to content
SayScreen

Google Sheets tutorial

How to make a Gantt chart in Google Sheets

SayScreen

This whole video was made by AI.

Make your own at sayscreen.com

Start for $1

$1 for 7 days, then $49/month

  • 4:02 video
  • 11 steps
  • Last verified November 6, 2026

Build a simple project timeline without a chart template or add-on. This tutorial turns a five-task Website Launch Plan into a Gantt-style grid: task names in column A, start and end dates in B and C, and daily dates across E1:AH1. One conditional formatting rule fills the days between each task's start and end. You will also resize the columns, freeze the headers and task names, and shorten Build's deadline to see its bar update. This is a cell-based timeline, not Google Sheets' separate Timeline view; it does not set up dependencies or calculate progress.

Steps

  1. 1Name the spreadsheet Website Launch PlanOpen a blank spreadsheet at sheets.new, then click its name at the top and rename it.0:10
  2. 2Enter the task list and start and end datesUse A1:C1 for Task, Start and End. In rows 2-6, enter Research (Nov 9-Nov 13), Design (Nov 12-Nov 20), Build (Nov 18-Dec 2), Test (Dec 1-Dec 5) and Launch (Dec 8-Dec 8). Use real date values, all in the same project year, rather than plain text.0:17
  3. 3Start the daily timeline in E1 and F1Leave D empty as a spacer. Type Nov 9 in E1 and Nov 10 in F1, then drag across the two cells to select both dates.0:52
  4. 4Narrow the timeline columns and widen A through CClick the top-left corner box to select the sheet, then drag a column boundary left. Select column headers A:C and drag the boundary of C right so task names and dates remain readable.1:11
  5. 5Extend the date series through Dec 8Select E1:F1 again. Drag the small blue fill handle right to AH1. Check that the series advances one day at a time and ends on Dec 8.1:40
  6. 6Select E2:AH6 and open conditional formattingDrag across the grid below the date headers, then choose Format > Conditional formatting. Confirm the Apply to range field is E2:AH6.1:56
  7. 7Add the custom formula for the barsUnder Format cells if, scroll to Custom formula is. Enter =AND(E$1>=$B2,E$1<=$C2). E$1 locks the date-header row while the column changes; $B2 and $C2 lock the start and end columns while the task row changes. Both boundary dates are included.2:14
  8. 8Choose a blue fill and save the ruleOpen Fill color, pick blue and click Done. Close the panel and click an empty cell to see each task bar span its start and end dates.2:53
  9. 9Freeze the date-header rowChoose View > Freeze > 1 row so the date headers stay visible as you scroll down.3:15
  10. 10Freeze the task-name columnChoose View > Freeze > 1 column to keep column A visible when you scroll across the timeline.3:27
  11. 11Change Build's end date to test the chartChange the End date for Build in C4 from Dec 2 to Nov 28. Its bar becomes shorter automatically because the formatting rule reads the dates in columns B and C.3:37

Transcript

0:00Let's build a simple Gantt chart in Google Sheets. With just a task list, a row of dates, and one conditional formatting rule, your project timeline will draw itself.

0:10First, give the spreadsheet a name: Website Launch Plan.

0:17Column A holds the header Task, followed by the five steps: Research, Design, Build, Test, and Launch. Pressing Enter moves down a row.

0:28Column B gets the Start header and each task's start date: Nov 9, Nov 12, Nov 18, Dec 1, and Dec 8.

0:38And column C gets End, with the finish dates: Nov 13, Nov 20, Dec 2, Dec 5, and Dec 8. Sheets recognizes these as real dates, so it aligns them to the right.

0:52Next comes the timeline. Leave column D empty as a spacer, and in E1 type the first day, Nov 9.

1:01In F1, type Nov 10. Two dates are enough for Sheets to spot the pattern.

1:07Drag across both dates to select them together.

1:11Thirty days won't fit at this column width, so let's narrow the columns first. Click the corner box to select the whole sheet.

1:20Now drag any column edge to the left. Every selected column shrinks together, giving each day a slim slot.

1:27The task and date columns need more room, so drag across the headers for columns A through C.

1:34Then drag the edge of column C to the right, widening all three at once.

1:40Back to the timeline: drag across Nov 9 and Nov 10 to select them again.

1:46Grab the small blue fill handle at the corner and drag it right to column AH. Sheets continues the pattern, one day per column, all the way to Dec 8.

1:56Now select the area where the bars will go: drag from E2 down and across to the last date column in row 6.

2:04With the grid selected, open the Format menu.

2:08Choose Conditional formatting, which colors cells automatically based on a rule.

2:14The range already shows E2 to AH6. Open the condition dropdown under Format cells if.

2:21Scroll to the bottom of the list.

2:24Pick Custom formula is, so we can write our own rule.

2:28Type the formula. It says: color a cell when its date in row one falls on or after the task's start, and on or before its end. Notice the dollar signs. In E$1, the dollar locks row one, so every row checks the date header. In $B2 and $C2, it locks the columns, so each cell compares against its own task's start and end.

2:53The preview is already drawing bars. To make them blue, open Fill color.

2:59Choose a blue for the bars.

3:02Click Done to save the rule.

3:04Close the panel to see the whole chart.

3:07Click any empty cell, and there's your Gantt chart: each task's bar spans exactly from its start date to its end date.

3:15To keep the headers and task names visible while you scroll, open the View menu.

3:20Point to Freeze.

3:23Choose 1 row to lock the date headers in place.

3:27Back in View, we'll freeze the task column too.

3:30Open Freeze again.

3:33And pick 1 column, so the task names stay put.

3:37Finally, watch the chart stay in sync. Change Build's end date to Nov 28. The Build bar shrinks right away. Because the rule reads the start and end dates, the chart redraws whenever your schedule changes. And that's a working Gantt chart: a task list, a row of dates, and one custom formula rule with the dollar signs in the right places.

Google Sheets is a trademark of its owner. SayScreen isn't affiliated with, sponsored or endorsed by Google Sheets; this video shows the public app as it looked when it was recorded, and we last checked the steps on November 6, 2026. If Google Sheets has changed since, tell us at hey@sayscreen.com.

All Google Sheets videos