How to Make a Gantt Chart in Google Sheets?

You can create Gantt charts with Google Sheets. The cloud-based app is more than suitable and advanced to create this timetable-type chart. It’s one way to make it easy to share the timetable of your project visually to the rest of your team.

They’ll have a better idea of the length of time it’ll take for each task or phase of your animation project for a 30-minute video with the assistance of such a chart.

How to Make a Gantt Chart in Google Sheets

Step 1: Let’s open a new spreadsheet (click this link to do so) and then put in relevant timetable info for your Gantt chart.

Gantt Chart Step 1 - Open new spreadshet and input Gantt type data

We’ll cover the timetable for making a 30-minute animation show, which roughly takes 6-7 months of work, from the conception of the storyboard to post-production work.

The rough breakdown of such an animation project is like so.

  • Storyboard: 4 weeks
  • Voice work: 2 weeks
  • Animatic/Timing: 1 week
  • Layout and backgrounds: 4 weeks
  • Animation (key frames): 4 weeks
  • Cleanup/In-Between: 4 weeks
  • Digital Ink and Paint: 6 weeks
  • Music: 4 weeks
  • Sound Effects/Post-Production: 4 weeks

To streamline the chart, I’ve changed the weeks to days (just multiply them by 7). This is because I’ll be using formulas to fill the chart.

Step 2: Choose a start date then enter an end date formula. We’ve entered “7/1/2022” then used the formula “= C2+B2-1” (Start Date + Days – 1) to get the end date (“7/28/2022”).

Gantt Chart Step 2 - Choose a start date then enter an end date formula

Step 3: On C3, simply enter the formula “=D2+1” (End Date + 1) in order to get the next immediate start date below the previous one. The new start date should be directly tied to the previous end date.

Gantt Chart Step 3A - Use formula of the prevous end date plus 1

Copy and paste D2 on D3. You can now copy and paste C3 and D3 together across both Column C and D to get a fairly accurate start and end dates.

Gantt Chart Step 3B - Copy and paste C3 and D3 across the columns and rows

Step 4: Insert the formula “=int(C2)-int($C$2)” (based on C2 or the very first start date) in order to calculate on what specific day number the start date will happen. It starts on Day 0.

Gantt Chart Step 4A - Enter formula for _Start on Day X_

This metric will be important for the stacked chart we’ll be making later. Now copy the formula across the rest of Column E. You’ll be starting on Day 0 (Day 1), Day 28, Day 42, and so forth all the way to Day 203.

Gantt Chart Step 4B - Copy the rest of the formula on the E column

Step 5: Now that you have enough data to work with, select the “Animation Phase” set of headers, the “Days” or duration header, and the “Start on Day” header.

Gantt Chart Step 5A - Select _Animation Phase_, _Days_, and _Start on Day_ headers

Now go to the “Insert” menu and click “chart” to get your Gantt chart based on the data provided.

Gantt Chart Step 5B - Click _Insert_ menu then _Chart_

Step 6: So we’ve inserted the chart but it looks funny. That’s not what a Gantt chart is supposed to look like! The red bars are supposed to be shorter than the blue bars.

In other words, “Start on Day” should be on long blue bars and “Days” should be on short red bars instead of the other way around.

Gantt Chart Step 6A - The Gannt chart looks a little funky

There are two ways to fix this. The easy way is to go to the “Chart editor” sidebar. Click the “Setup” bar, scroll down to “Series” and swap “Days” and “Start on Day” on their respective boxes.

Gantt Chart Step 6B - Go to _Chart editor_, _Setup_, and scroll to _Series_ to swap _Days_ and _Start on Day_

From there, we now have an almost proper Gannt bar that requires one more edit—the blue bars should be made “clear” or “white“.

Gantt Chart Step 6C - Swapping _Start on Day_ and _Days_ should result in a half-made Gantt chart

Step 7: Customize your Gantt chart. First off, go to the “Setup” tab and click the “Chart and axis titles” submenu. From there, change the “Title text” to something appropriate.

Gantt Chart Step 7A - Go to _Chart and axis titles_ and change the _Title text_

Change “Chart title” to “Horizontal axis title” on the dropdown menu on “Chart and axis titles“. Now put in “Days of the Month” on the “Title text“.

Gantt Chart Step 7B - Select _Horizontal axis title_ on _Chart and axis titles

Afterwards, go to the “Customize” tab, click on the “Legend” submenu, and then on the first dropdown menu for “Position“, select “None“.

Gantt Chart Step 7C - Go to _Customize_ tab, the _Legend_ submenu, and select _None_ for _Position_

Finally, change the fill color for the Start on Day bars. To be more specific, go to the “Series” submenu under the “Customize” tab, select the “Start on Day” element, and select “0%” for the opacity of the stacked bars there.

Gantt Chart Step 7D - Put opacity of Start of Day bars to zero percent

The final product should look a little something like this.

Gantt Chart Step 7E -The finished product

Step 8: An alternative to making the Gantt bar easier to make from the table level is to edit the table itself. Move the “Start on Day” before the “Days” column or move the “Days” column after the “Start on Day“.

It’s easy enough to fill in the rest of the info as long as you have a start date and the duration or days needed for each animation phase. The formulas can also auto-adjust accordingly.

For instance, I’ve right-clicked the “Start on Day” column and selected “Delete column” with the intention of moving the column before “Days“.

Gantt Chart Step 8A - Fix table by deleting Start on Day column

Afterwards, I right-clicked the “Days” and selected “Insert 1 column to the left“, which is where I’ll be putting my new “Start on Day” column.

Gantt Chart Step 8B - Now add column to the left of _Days_ to not disturb the other formulas

After putting in a new header, I then put in a new formula—”=int(D2)-int($D$2)“—to reflect the column designation changes on the table (the very first start date is now on D2 instead of C2).

Gantt Chart Step 8C - Fix the formula for Start of Day to reflect

It even prompted auto-fill so that Google Sheets can fill the column up for me instead of me having to do it myself! How considerate of Google Sheets.

Whatever you do or whichever path you take to fix the table, make sure to put in the necessary edits to the formulas you’ve used to fill the table.

Regardless, you now have chart placement that’s easy to select and easy to turn into a Gantt chart!

Gantt Chart Step 8D - It_s now easier to select the columns and make a Gantt chart out of your data

What You Ultimately Need to Find Out

A Gantt chart is a chart that uses a series of horizontal lines or bars to show the amount of work done or the duration of said work across a give timeline, thus giving you a better idea of your overall time table.

Digital Ink and Paint eats up the most time because it combines all the elements together, scans them into the computer and paints both animation “cels” layer and the background layer. It also ends up with basically the final product of the animation save for music and sound effects.


  1. Vertex42, “How to Create a Gantt Chart in Google Sheets“, YouTube, June 22, 2020
  2. WhizBusters, “How to create a GANTT Chart in Google Sheets“, YouTube, March 19, 2021
  3. Mr. Rozon, “How to make a Gantt Chart in Google Sheets – The Easy Way!“, YouTube, February 23, 2021
  4. How to Make a Gantt Chart in Google Sheets“, Wondershare EdrawMax, Retrieved July 13, 2022
  5. How to Make a Gantt Chart in Google Sheets: Free Template“,, Retrieved July 3, 2022

Google Sheet: Make a copy

Andy Avery

I really enjoy helping people with their tech problems to make life easier, ​and that’s what I’ve been doing professionally for the past decade.

Recent Posts