How to Create Gantt Chart in Google Sheets – Free Templates
How to Make a Gantt Chart in Google Sheets – Easy Steps
- Open Google Sheets >>Enter your Data
- Go to Insert >>Click on Chart
- Select Stacked Bar Chart
- Customize the Chart>>Format your Gantt Chart
- Label and Share your Gantt Chart
Managing project timelines can be tricky, but Google Sheets can help. With a Gantt chart, you can see your project schedule at a glance. In this guide, we’ll show you how to create a Gantt chart in Google Sheets, use a Google Sheets Gantt chart template, and make a Gantt chart from scratch. Let’s make project planning easy and keep everything on track with these simple steps.
Table of Content
- What is the Gantt Chart in Google Sheets?
- How to Make Gantt Chart in Google Sheets
- How to Customize Gantt Chart in Google Sheets
- Free Gantt Chart Template for Google Sheets
- How to Remove the Chart
- How to Use Google Sheets Gantt Charts with Dependencies
- Why use Gantt Chart in Google Sheets?
- Conclusion
- FAQs on Google Sheets Gantt Chart
What is the Gantt Chart in Google Sheets?
With a Gantt chart in Google Sheets, you can see your project’s progress in real-time, much like a personal project manager. Every job turns into a bar, with the start, duration, and finish dates shown along its length. Its real strength rests in the extra information it records, such as finished tasks, unfinished work, significant occurrences, anticipated results, deliverables, and stakeholder accountability. With the help of this thorough representation, you can keep an eye on developments, spot obstacles, and guide your project toward a successful conclusion.
How to Make Gantt Chart in Google Sheets
Step 1: Open Browser
Go to your preferred browser and visit the Google page
Step 2: Go on Google Sheets
After logging into Google, you will see nine dots at the top right corner. Click on it, and you will see the Google Sheets option while scrolling. Tap on it.
Step 3: Click on the Blank sheet
When entering Google Sheets, see the first option: Blank Sheet. Click on it.
Step 4: Input data into the Sheet
Enter your data in any cell of your choice.
For the first table, label the columns as follows:
- Column A: Task Name
- Column B: Start Date
- Column C: Duration
Then label the cells as follows:
- Cell A2: Task #1
- Cell A3: Task #2
Note:
Keep going until the Gantt chart has enough rows for every project job you wish to see. In addition to the header row, the table should include four rows if your project consists of four jobs, for instance.
Step 5: Add matching start and finish dates
Write starting and ending dates simultaneously, as shown in the image below.
Step 6: Make the second table
By creating it two or three rows below the first. In this instance, row 8 is where we begin the second table. Give the cells the following labels:
- Cell A8: Name of Task
- Cell B8: Begin on the Day
- Cell C8: Length
Step 7: Determine the Difference
Determine the difference between each task’s start date (column B) and your project’s initial task (probably in cell B2). This will indicate the days each job starts following the first one.
Step 8: Enter the Formula
In cell B9 (assuming your first task details start in row 2), type the following formula:
=int(B2)-int($B$2).
Note:
Explanation of the formulae
- The int() method ensures that the start day value is a whole number (days).
- B2: This refers to the cell (in our case) with the current task’s start date.
- Hit the Enter key. Press Enter on your keyboard to finish.
Step 9: Use the same formula for each job in the Start on Day column
=int(B2) -int($B$2) To access the final project job, click cell B9 and then move the little blue Box located in the cell’s bottom-right corner.
Step 10: Enter the following formula in the first cell
(C9) of the Duration column =(INT($B$4)-INT(C4))-(INT($B$4)-INT(B4) . On the keyboard, hit Enter. The value in the cell will automatically fill.
Note:
The cell numbers may change depending on where you put the project data in the sheet (for example, C4 may become C10), but the rest of the formula should stay the same.
Step 11: Use the following formula for each job in the Duration column:
=(INT($B$4)-INT(C4))-(INT($B$4)-INT(B4). After selecting cell C9, click and drag the little blue Box in the cell’s lower-right corner to bring you to the final project assignment.
Step 12: Create a Bar Graph
Highlight the second table.
Step 13: Click Insert on the menu
Click on the insert option on the upper side of the sheet. Then click Chart underneath it. As you select it, a stacked bar chart appears on the page.
Step 14: Turn Your Stacked Bar Chart into a Gantt Chart
Click on any Start on Day bar in the Chart. This should highlight all the Start on Day bars.
Configure the Chart.
Step 15: Click the customizable Tab
In the Chart editor panel on the right, click the Customize tab. Click Series, then click the dropdown menu and Start on Day. Click the Color button, then click None. The Chart should now resemble a Gantt chart.
How to Customize Gantt Chart in Google Sheets
Step 1: Rename the Gantt chart
Double-click the Chart’s title at the top. Enter a new project title here.
Step 2: Personalize the Gantt Chart Region
Make the bars stand out in three dimensions or change the border’s colour.
Step 3: Go on chart editor
Click the Chart to access the Chart Editor menu on the right. After selecting the Customize tab, select the first choice, Chart style.
Step 4: Adjust the hue
Click the dropdown menu next to the Background colour and select a different colour.
Step 5: Alter the the text
To alter any text in the Chart, click on it. Use the Font dropdown menu to alter the font style for labels, legends, or the title.
Note:
To make changes, you will need to click on the text type.
Step 6: Visit “Chart border colour.”
Click the dropdown menu labelled “Chart border colour.” To entirely remove a border or colour, click None.
Step 7: Go to 3D Box
To apply the effect to the bars, click the 3D Box.
Free Gantt Chart Template for Google Sheets
To Access Free Gantt Chart in Google Sheets Follow the Below steps:
To direct open the Gantt Chart free template Click here
Step 1: Open Google Sheets
Step 2: Go to the Template Gallery and Scroll Down
Step 3: Select your Gantt Chart Template
How to Remove the Chart
Step 1: Select Chart
On the Chart, click.
Step 2: Tap on the Customize Tab
Select the Customize tab in the Chart editor box and click Legend.
Step 3: Tap on None
Select None from the Position dropdown option.
How to Use Google Sheets Gantt Charts with Dependencies
Project activities that rely on one another, meaning you can’t begin specific duties until a prior job or set of tasks is finished, are likely to be found in more complicated projects. To make sure a dependent job begins when the preceding one is finished, follow these procedures.
Why use Gantt Chart in Google Sheets?
Beyond To-Do Lists: Gantt charts provide a chronological perspective to Google Sheets, which is already functional as a to-do list tool. This gives you an overview of what has to be done right now, what has previously been done and what is ahead. Customary to-do lists sometimes overlook acknowledging prior successes, and a Gantt chart makes your progress more straightforward to perceive!
Dashboards with images: Do you dislike date-filled spreadsheets? Tracking your progress visually is possible using a Gantt chart. It’s a quick and simple approach to seeing the current situation and understanding what has been done, what is occurring right now, and what will happen next.
Time Visualization: There’s Fun to Be Had with Spreadsheets! Consider tracking things like your go-to morning music with a Gantt chart as one individual did. Using this tool, you may express your creativity, see how events relate, and progress through time on a timeline.
Conclusion
With Google Sheets’ Gantt chart functionality, managing your project timetable is a breeze. Follow these instructions to turn your data into a visual masterpiece with start dates, durations, and task dependencies. This book will help you track developments, spot obstacles, and eventually direct your project toward a successful conclusion.
FAQs on Google Sheets Gantt Chart
Does Google Sheets have a template for a Gantt chart?
Regretfully, Google does not include a pre-made Gantt chart template. In Google Sheets, you must manually create a Gantt chart and save it as a template for use in other projects.
How can I create a Google Sheets Gantt chart template?
Any Google Sheets file you create may be kept as a template. To make your own Gantt chart in Google Sheets, follow these instructions. Next, select File > Save as template to generate a Google Sheets Gantt chart template you may utilize again for the project timeline schedule.
How should a weekly Gantt chart in Google Sheets be formatted?
Open the Gridlines button in Google Sheets to style your GanttGantt chart by week and tick the menu from the Chart Editor settings’ Customize Tab. Then, type 7 into the Major step box.
Contact Us