Abuuritaanka shaxda Google Docs Gantt waxay noqon kartaa qalab maarayn mashruuc oo faa'iido leh. Jaantusyada Gantt^(Gantt) waxay kaa caawin karaan inaad u dhisto macnaha guud ee wakhtiga iyo horumarka mashruucaaga. Waxaad isticmaali kartaa barnaamijyo kale si aad u abuurto jaantusyada Gantt sidoo kale, laakiin waxay noqon karaan kuwo adag, gaar ahaan shay sida dib u eegista macmiilka.

Waxa kale oo aad ku abuuri kartaa jaantuska Gantt gudaha ^(Gantt)Excel , laakiin shaxanka Google Docs Gantt si sahal ah ayaa looga heli karaa daruuraha. Waxaad u oggolaan kartaa xubnaha la oggolaaday inay wax ka beddelaan gelitaankooda si ay ugu wada-shaqeyn karaan Google Doc^{(collaborate on a Google Doc)} adoon xaashida dib iyo dib ugu soo diri email ahaan. 

Samee Google Docs Gantt Chart

Kahor intaadan bilaabin samaynta shaxda Google Docs Gantt , waxaad u baahan tahay inaad ku shubto xaashida shaqada ^{(Google Docs Gantt)}Google xog qaar ah. 

1. Ku diyaari^(Set) hawlahaaga xaashida Google -ka si aad u hesho jadwalka mashruucaaga qaab miiska. Liis garee hawlaha mashruuca oo u qoondee hawl kasta taariikhda bilawga iyo dhammaadka. 

1. Talaabadaada xigta waa inaad dejiso miis kale oo aad ku qori doonto maalinta ay hawl gaar ahi bilaabmi doonto iyo inta maalmood ee ay qaadan doonto in la dhamaystiro. Tusaale ahaan, hawsha ugu horreysa "Alaabada Ilaha" waxay bilaabmaysaa maalinta 0 waxayna socotaa 13 maalmood. 

Waa kan sida aad u diyaarin karto tiir kasta:

1. Hawlaha^(Tasks) : Kaliya ka guuri tiirkan shaxda hore.
2. Start Task on Day # : Halkan, waxaad u baahan doontaa maalinta naad ee wakhtiga mashruucaaga marka hawl gaar ahi ay tahay inay bilaabato. Marka, waxaad u baahan doontaa inaad xisaabiso:

[Taariikhda Hawsha Ay Bilaabaneyso –Taariikhda^{(Start Date)} Hawsha Ugu Horeyso Ee Ay Bilaabaneyso^{(Start Date)} ]

Tusaalahan, qaacidada soo socota waa in lagu geliyaa unugga khuseeya:

=int(D5)-int ($D$5)

Marka aad gasho qaacidada, waxaad ku dabaqi kartaa qaacidada unugyada haray adiga oo jiidaya xulashada xadka. Calaamadda dollarka ee qaaciidada waxay kaa caawinaysaa inaad ilaaliso tixraaca unugga^{(preserve a cell reference)} marka aad u adeegsato caanaha unugyada kale. 

Qaaciddu waxay xisaabisaa faraqa u dhexeeya labada taariikhood^{(difference between two dates)} sida iskudar ahaan (taasi waa waxa shaqada INT qabato). La'aanteed shaqada INT , waxaad heli kartaa wax soo saar leh qiime jajab tobanle.

Haddii aad aragto taariikh sannadihii 1900-meeyadii kadib gelitaanka qaaciidadan, iska hubi in aad u qaabaysay unugga lambar ahaan ee ma aha taariikh.

1. # of Days on Task : Halkan, waxaad ku xisaabin doontaa tirada maalmaha lagu kharash gareynayo hawl kasta sida ku cad jadwalkaaga mashruuca. Waxaad u xisaabin kartaa sidan:

[Taariikhda Dhammaadka Hawsha^(Date) – Taariikhda ^{(Start Date)}Bilawga^{(Start Date)} Hawsha Kowaad ] –^{(Start Date)}

Tusaalahan, qaacidada loo isticmaalo in lagu xisaabiyo inta maalmood ee hawsha lagu qaatay waa:

= (int(E5) -in ($D$5)) (int(D5) -int($D$5))

Hubi inaad ku xidho labada hawlood ee kala-goynta qaws. Haddii kale, waxaad heli kartaa wax soo saar khaldan.

Marka la sameeyo, jiid xulashada xuduudka si aad ugu dabaqdo qaacidooyinka unugyada intiisa kale, sida aad ku samaysay safkii hore. Sidoo kale, hubi in unugyadu ay qaabaysan yihiin si ay u muujiyaan lambar oo aanay ahayn taariikh.

1. Ka dooro dhammaan shaxda aad hadda samaysay oo ka dooro Geli^(Insert) > Shaxda^(Chart) ribbon sare. 

1. Hadda waxaad ku arki doontaa jaantus shaashaddaada iyo tafatiraha^(Chart) jaantuska oo ku yaal midigta shaashaddaada. Dooro nooca^{(Chart type)} jaantuska ee hoos yimaada tab^{(Setup )} dejinta ee tafatiraha jaantuska.

1. Liiska noocyada shaxda ayaa ka muuqan doona tafatiraha shaxda . ^(Chart)Gudbi^(Scroll) oo raadi qaybta Bar . Qaybtan, ka dooro Shaxda Bar^{(Stacked Bar Chart)} -taxan . 

1. Marka xigta, u gudub tab Customize . Balaadhi qaybta Taxanaha^(Series) oo dooro Start Task on Day # taxanaha. Deji Buuxinta Daahfurnaanta^{(Fill Opacity)} iyo Daahfurnaanta Khadka^{(Line Opacity)} ilaa 0% si aad uga qariso jaantuska.

Taasi waa waxa kaliya ee aad u baahan tahay si aad u abuurto shaxda Google Docs Gantt . Haddii aad rabto, waad sii habayn kartaa. Waxaad dib u magacaabi kartaa jaantuska, waxaad magacaabi kartaa dhidibka jiifka iyo toosan, oo waxaad sahamin kartaa xulashooyinka kale ee habeynta ee tab Customize .

Samee Google Docs Gantt Chart oo leh wax-ku-dar

Haddii aadan rabin inaad waqti ku qaadato gacanta si aad u abuurto jaantuska Google Docs Gantt , waxaad had iyo jeer isticmaali kartaa mid ka mid ah dhowrka garaafyada Gantt ee ^(Gantt)laga heli karo Google Docs^{(add-ons available for Google Docs)} . 

Si aad u soo dejiso wax-ku-darka, ka dooro Add-ons- ka ribbon-ka sare, oo dooro hel add-ons^{(Get add-ons)} . Raadi jaantuska Gantt ^{(Gantt chart)}Dooro Slick Gantt > Ku rakib^(Install) . Waxaad sidoo kale dooran kartaa mid kale, laakiin Slick Gantt waa mid aan buuq lahayn, oo sahlan in la isticmaalo.

Markaad rakibto ku-darka, ku noqo xaashida Google -ka ^(Google)Waxaa jira laba digniinood oo aad u baahan tahay inaad daryeesho ka hor intaadan isticmaalin Slick Gantt . 

Marka hore waxaad u baahan doontaa inaad dib u dhigto xogtaada. Haddii aanad horeba u haysan, dhig xogta si ay uga bilaabato unugga A1, haddii kale Slick Gantt waxay dhibaato kala kulmi doontaa helitaanka xogta xaashidaada.

Waxaa dheer, waxaad sidoo kale u baahan doontaa inaad ku darto tiir Aqoonsiga Hawsha^{(Task ID)} xogtaada maadaama ku darku uu u baahan yahay ugu yaraan afar goobood ( Aqoonsiga^{(Task ID)} Hawsha , Magaca Hawsha^{(Task Name)} , Taariikhda Bilawga^{(Start Date)} , iyo Taariikhda Dhamaadka^{(End Date)} ).

Markaad si habboon u dhigtay xogta oo aad ku darto tiirka Aqoonsiga Hawsha :^{(Task ID)}

1. Ka dooro Add-ons ribbon sare oo dooro Slick Gantt > Gantt chart . 

1. Ku-darka ayaa hadda kuu soo rari doona shaxda  Gantt .

1. Haddii aad rabto inaad iimayl u dirto shaxda Gantt kooxdaada, waxaad sidoo kale u soo dejisan kartaa sawir ahaan adigoo gujinaya astaanta sawirka ee sare.

Waxaa jira dhowr waxyaalood oo kale oo aad isticmaali karto bedelkii Slick Gantt :

1. Gantt Chart ee AddonForge^{(Gantt Chart by AddonForge)} waa qalab aad u fiican haddii aad u baahan tahay wax-ku-kordhin leh dhammaan gambaleelka iyo foorida. Si kastaba ha ahaatee, sifooyin badan ayaa ku xaddidan nooca lacagta ah.
2. Gantt Chart Generator ee uu qoray Takuya Tokiwa^{(Gantt Chart Generator by Takuya Tokiwa )} waa wax-ku-dar kale oo nadiif ah oo fudud, wuxuuna ku siinayaa sifada ugu badan ee aad karabto aaladda jaantuska Gantt .
3. Shaxda Cajiibka ah ee Awesome Gapps^{(Awesome Table by Awesome Gapps)} waxay samayn kartaa dhowr waxyaalood, abuurista jaantusyada Gantt waa mid ka mid ah. ^(Gantt)Haddii aad u baahan tahay qalab wax badan ka badan samaynta jaantusyada, tani waa qalab weyn. 

Shaxda Google Docs Gantt^{(Google Docs Gantt Chart)} waa diyaar

Markaad dejiso jaantuska, waxaad u cusbooneysiin kartaa waqtiga dhabta ah adiga oo cusboonaysiinaya xogta xaashida. Sida fudud tani waxay ahayd? Waxa kale oo aad isku dayi kartaa samaynta goob kala firdhisan xaashida Google^{(making a scatter plot in Google Sheets)} , haddii taasi aad ugu habboon tahay shaqadaada.

How to Add a Gantt Chart in Google Docs

Creating a Google Docs Gantt chart can be a useful project management tool. Gantt chartѕ can help yоu establish visual context for your project’s timeline and progress. You can use other programs for creating Gantt сharts as well, but they can be complex, especially for something like a сlient review.

You can also create a Gantt chart in Excel, but a Google Docs Gantt chart is readily accessible over the cloud. You can allow authorized members edit access so they can collaborate on a Google Doc without having to send the spreadsheet back and forth via email. 

Create a Google Docs Gantt Chart

Before you get started with creating a Google Docs Gantt chart, you need to populate the Google worksheet with some data. 

1. Set up your tasks in a Google sheet so you have your project’s schedule in table form. List out the tasks of the project and assign a start and end date to each task. 

1. Your next step is to set up another table where you’ll list the day on which a certain task will begin and the number of days it will take to complete. For instance, the first task “Source Materials” starts on day 0 and goes on for 13 days. 

Here’s how you can prepare each column:

1. Tasks: Just copy this column from the previous table.
2. Start Task on Day #: Here, you’ll want the nth day in your project’s timeline when a particular task is supposed to begin. So, you’ll essentially need to compute:

[A Task’s Start Date – The First Task’s Start Date]

In this example, the following formula should be entered in the relevant cell:

=int(D5)-int($D$5)

Once you’ve entered the formula, you can apply the formula to the remaining cells by dragging the border selection. The dollar sign in the formula helps you preserve a cell reference when you apply the formula to other cells. 

The formula calculates the difference between two dates as an integer (that’s what the INT function does). Without the INT function, you may receive an output with a decimal value.

If you see a date in the 1900s after entering this formula, make sure that you’ve formatted the cell as a number and not a date.

1. # of Days on Task: Here, you’ll calculate the number of days to be spent on each task as per your project timeline. You can compute this as:

[A Task’s End Date – The First Task’s Start Date] – [The Task’s Start Date – The First Task’s Start Date]

In this example, the formula use to compute the number of days spent on a task is:

=(int(E5)-int($D$5))-(int(D5)-int($D$5))

Be sure to enclose the two subtracting operations in parentheses. Otherwise, you could receive an incorrect output.

When done, drag the border selection to apply formulas to the rest of the cells, just like you did for the previous column. Also, make sure the cells are formatted to display a number and not a date.

1. Select the entire table that you just created and select Insert > Chart from the top ribbon. 

1. You’ll now see a chart on your screen and a Chart editor at the right of your screen. Select Chart type under the Setup tab in Chart editor.

1. A list of chart types will appear in the Chart editor. Scroll through and look for the Bar section. From this section, select a Stacked Bar Chart. 

1. Next, switch to the Customize tab. Expand the Series section and select the Start Task on Day # series. Set Fill Opacity and Line Opacity to 0% to hide it from the chart.

That’s all you need to create a Google Docs Gantt chart. If you want, you can customize it further. You can rename the chart, name the horizontal and vertical axis, and explore other customization options in the Customize tab.

Create a Google Docs Gantt Chart with an Add-On

If you don’t want to spend time manually creating a Google Docs Gantt chart, you can always use one of the several Gantt chart add-ons available for Google Docs. 

To download an add-on, select Add-ons from the top ribbon, and select Get add-ons. Search for Gantt chart. Select Slick Gantt > Install. You could just as well select another one, but Slick Gantt is a no-fuss, easy to use tool.

Once you’ve installed the add-on, go back to your Google sheet. There are two caveats you need to take care of before using Slick Gantt. 

You’ll first need to reposition your data. If you haven’t already, place the data such that it starts from cell A1, otherwise Slick Gantt will have trouble finding the data in your sheet.

Plus, you’ll also need to add a Task ID column to your data since the add-on requires at least four fields (Task ID, Task Name, Start Date, and End Date).

Once you’ve placed the data appropriately and added a Task ID column:

1. Select Add-ons from the top ribbon and select Slick Gantt > Gantt chart. 

1. The add-on will now load a Gantt chart for you. 

1. If you want to email the Gantt chart to your team, you can also download it as a picture by clicking on the picture icon at the top.

There are several other add-ons you can use instead of Slick Gantt:

1. Gantt Chart by AddonForge is a great tool if you need an add-on with all the bells and whistles. However, a lot of features are restricted to the paid version.
2. Gantt Chart Generator by Takuya Tokiwa is another clean and simple add-on, and offers most features you’d want in a Gantt chart tool.
3. Awesome Table by Awesome Gapps can do a number of things, and creating Gantt charts is one of them. If you need a tool that does a lot more than just create charts, this is a great tool. 

Your Google Docs Gantt Chart Is Ready

Once you’ve set up the chart, you can update it in real-time by updating the data in the sheet. Like how easy this was? You can also try making a scatter plot in Google Sheets, if that’s more relevant to your work.

Related posts

• Sida loo sameeyo Gantt Chart gudaha Google Sheets

• Sida loo beddelo midabka asalka ah ee Google Docs

• Sida loo Gelida Nambarada Bogga Word iyo Google Docs

• U kala qaybso dukumeenti ku jira Google Docs

• Sida loo beddelo Margins gudaha Google Docs

• Qaababka qaan-sheegga ugu fiican ee Google Docs ee Freelancers, Ganacsiga Yaryar

• Xaashiyaha Google ee ugu Fiican iyo Hababka Jadwalka Kalandarka ee Excel Online

• Sida Documents loogu badalo PDF iyadoo Google Docs la isticmaalayo browser ah

• Sida qoraalka loogu beddelo abka shabakadda Google Sheets

• Sida loogu daro Google Keep Notes Google Docs

• Sida loo abuuro Indent Hang ee Microsoft Word iyo Google Docs

• Sida Shaxda Qoraalka Google Docs u Shaqeeyo

• Khariidadaha Kiiboodhka Google Docs ee Windows 11/10 PC

• Hagaaji Superscript-ka oo aan ka shaqayn Google Docs

• U beddelo Word, PowerPoint, Excel Documents PDF adoo isticmaalaya Google Docs

• Sida loogu xidho Google Sheets iyo Excel

• Sida Loo Sameeyo Foomka Dukumentiga Google-ka La Buuxin Karo

• Sida loo sameeyo tiirar Google Docs ah

• Sida had iyo jeer loogu muujiyo tirinta kelmadda Google Docs

• Sida loo abuuro oo wax looga beddelo liiska hoos-u-dhaca ee Google Sheets