How to Make a Gantt Chart in Google Sheets with AI

Building a Gantt chart to track your project timeline shouldn't feel like a project in itself. While Google Sheets is incredibly versatile, manually creating a visual timeline can be a tedious process of wrestling with stacked bar charts and cryptic formulas. This guide will walk you through creating a dynamic Gantt chart in Google Sheets, starting with the classic method and then showing you how AI can do the heavy lifting for you.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly is a Gantt Chart, and Why Bother?

A Gantt chart is a simple but powerful way to visualize a project's schedule. In essence, it's a bar chart that illustrates what needs to be done and when. At a glance, you and your team can see the entire project timeline, including:

• All the tasks involved in the project.
• When each task starts and ends.
• How long each task is expected to take (its duration).
• How tasks overlap or depend on each other.
• The overall project progress.

Instead of a static to-do list, a Gantt chart gives you a living, visual map of your project. It's perfect for tracking marketing campaigns, product launches, content calendars, or any project with a clear start and end date. It quickly answers the question, "Are we on track?" for everyone involved.

Step 1: Setting Up Your Project Data in Google Sheets

Before you build the chart, you need to structure your data properly. A clean setup is the foundation for an accurate Gantt chart. Open a new Google Sheet and create the following columns:

• Task Name (Column A): A brief description of the task.
• Start Date (Column B): The date the task is scheduled to begin.
• End Date (Column C): The date the task is scheduled to be completed.

Optionally, you can add these helpful columns as well:

• Duration (Column D): The number of days the task will take.
• Progress (Column E): A percentage (e.g., 50%) to track how complete a task is.

Important Tip: Make sure your 'Start Date' and 'End Date' columns are formatted as dates. To do this, highlight the columns, go to Format > Number > Date. This ensures Google Sheets understands the data correctly for calculations. Your initial setup should look something like this:

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 1: Building a Gantt Chart with a Stacked Bar Chart (The Classic Way)

This is the most common manual method for creating a Gantt chart in Google Sheets. It works by creating a stacked bar chart and then making the first part of the bar invisible, which creates the "floating" effect of a Gantt chart timeline. It requires a couple of helper columns to get the math right.

Add Two "Helper" Columns

Insert two new columns in an empty area of your sheet. Let's call them "Start Day" and "Duration."

1. Start Day: This column calculates how many days have passed from the project's start date to the beginning of each task. In the first cell of this column, enter this formula. (Assuming your first task's start date is in B2 and you want to use that same date as the project's overall start date):

=INT(B2)-INT($B$2)

Click and drag the small blue square in the bottom-right corner of the cell to apply this formula down the entire column. The $ symbols lock the reference to B2, ensuring every task is calculated against the same project start date.

1. Duration: This column simply calculates the length of each task in days. In the first cell of this column, enter this formula (assuming your start date is still B2, and your end date is in C2):

=INT(C2)-INT(B2)

Drag this formula down the column as well.

Your sheet now has all the data pieces needed for the chart.

Create and Format the Stacked Bar Chart

Now it's time to build the visual component.

1. Select Your Data: Hold down the CTRL key (or CMD on Mac) and click to highlight your "Task Name" column, your new "Start Day" column, and your new "Duration" column.
2. Insert the Chart: Go to Insert > Chart. Google Sheets will likely suggest a chart type, but you want to select Stacked bar chart from the 'Chart type' dropdown in the Chart editor on the right.

You'll see a chart that's starting to look like a Gantt chart, but it needs a few adjustments.

Make it Look Like a Gantt Chart

The trick is to make the "Start Day" series (likely blue) invisible.

1. Hide the "Start Day" Bars: In the Chart editor, go to the Customize tab. Click on the Series dropdown. Select your 'Start Day' series. Then, change its Fill color to None. Suddenly, your 'Duration' bars will appear to be floating in the correct timeline position.
2. Reverse the Task Order: You'll notice your tasks are in reverse order. To fix this, in the Chart editor go back to the Customize tab, click on Vertical axis, and check the box for Reverse axis order. This will list the tasks from top-to-bottom as they appear in your sheet.

After a bit of tidying up the title and gridlines, you'll have a functional, if manually intensive, Gantt chart.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 2: Using AI to Generate Gantt Chart Formulas

The stacked bar chart method works, but it’s a lot of steps and prone to error. A smarter, more streamlined approach is to use a single formula within your sheet. And you don’t need to be a formula wizard to do it — you can ask AI to build the formula for you.

Instead of manually creating helper columns and chart settings, you can add a new column like "Timeline" and use the SPARKLINE function to draw the chart directly in a cell. While powerful, the SPARKLINE syntax for a Gantt chart is complex and not very intuitive. This is where AI shines.

How to Use an AI Assistant to Write Your Formula

You can use any leading AI chat tool (like ChatGPT, Gemini, or Claude) to act as your personal spreadsheet expert. The key is to provide a clear, specific prompt describing your sheet's layout and what you want to achieve.

For example, you could give it this prompt:

"I am making a Gantt chart in Google Sheets. My sheet has 'Task Name' in Column A, 'Start Date' in Column B, and 'End Date' in Column C. The project's very first start date is in cell B2. Please give me a SPARKLINE formula that will create a visual Gantt chart bar for the task in row 2."

The AI will likely return a formula like this:

=SPARKLINE({(B2-$B$2),C2-B2},{"charttype","bar","max",($C$8-$B$2),"color1","white","color2","#4285F4"})

Let's quickly break down what this does:

• {(B2-$B$2),C2-B2}: This is the data part. It calculates the initial "gap" (the invisible bar) and the actual duration, just like our manual helper columns did.
• "charttype","bar": Tells Sheets to create a stacked bar chart.
• "max",($C$8-$B$2): This sets the total width of the sparkline based on the project’s full duration (from the first start date in B2 to the last end date, which in this example is C8). You'd adjust the end date cell reference accordingly, perhaps a cell called 'ProjectEndDate' once you know the true end of the project. This will keep the progress on this line, proportional.
• "color1","white": This makes the first part of the bar white (or invisible against the background).
• "color2","#4285F4": This sets the color for the visible taskbar (a nice Google blue in this case).

All you have to do is copy that formula from the AI tool, paste it into your "Timeline" column for the first task, and then drag it down. Each row will instantly display a perfectly scaled Gantt bar. No chart editing, no helper columns, no fuss.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Taking it Further with Conditional Logic

What if you want the taskbar to change colors based on its status? For instance, green for 'Complete' and blue for 'In Progress.' Trying to figure out this formula on your own can be a headache. Just ask the AI to modify the formula:

"That's great. Now, can you modify that formula? I have a 'Status' column in Column E. If the status is 'Complete', I want the bar to be green. Otherwise, it should be blue."

The AI will likely give you a formula using an IF statement:

=IF(E2="Complete",SPARKLINE({(B2-$B$2),C2-B2},{"charttype","bar","max",($C$8-$B$2),"color1","white","color2","green"}),SPARKLINE({(B2-$B$2),C2-B2},{"charttype","bar","max",($C$8-$B$2),"color1","white","color2","#4285F4"}))

By using AI, you leapfrog the steep learning curve of advanced functions. You get straight to the powerful results, transforming your static project list into a dynamic, color-coded visual timeline in a matter of minutes.

Final Thoughts

Creating a Gantt chart in Google Sheets can range from a multi-step manual process to a quick copy-and-paste action. While the traditional stacked bar chart method is effective, using an AI assistant to generate complex formulas lets you build more powerful, dynamic, and clean project timelines with almost no technical effort.

Frankly, this is where data analysis is headed. While generating a project timeline in a spreadsheet is one piece of the puzzle, the real challenge is pulling together performance data from different marketing and sales platforms to see the full picture. For that, we built Graphed. Instead of wrestling with spreadsheet layouts or figuring out APIs, you can connect your data sources — like Google Analytics, HubSpot, or Shopify — and simply ask for what you need in plain English. Want to see "a comparison of Facebook ad spend vs. Shopify revenue this month"? Graphed builds a live, interactive dashboard for you in seconds, saving you hours of manual reporting work.