jaantusyada Gantt^(Gantt) waa hab caan ah oo lagula socdo mashaariicda, gaar ahaan kooxaha u baahan inay maskaxda ku hayaan muddada hawsha. Adigoo isticmaalaya jaantuska Gantt si wax ku ool ah, waxaad hubin kartaa in hawlo kala duwan aysan faragelin midba midka kale, oo xitaa go'aamin marka mid dhammeeyo si mid kale u bilaabo. 

Waxaa jira dhowr siyaabood oo loo sameeyo jaantusyada Gantt , laakiin maqaalkan waxaan ku tusi doonaa sida loo sameeyo mid ka mid ah barnaamijka laga yaabo inaad haysato: Microsoft Excel . In kasta oo ay u badan tahay in aanay dhaafin software-ka gaarka ah marka la maamulayo tiro badan oo hawlo ah, mashaariicda yar yar waa beddel fiican.

Sida loo abuuro Gantt Charts gudaha Microsoft Excel

Waxa ugu fiican ee ku saabsan samaynta jaantuska Gantt ee ^(Gantt)Excel waa in laga yaabo inaad hore u leedahay nuqul ka mid ah xaashida faafinta oo aad taqaan sida loo isticmaalo. Haddii kale, waxaan kugula talineynaa inaad hubiso waxbarashadayada Excel^{(Excel tutorial)} . Noocyadii ugu dambeeyay ee Microsoft Excel (waxaanu hagahan u isticmaaleynaa Office Online , inkasta oo aad sidoo kale ka heli karto ^{(Office Online)}Office 365 lacag la’aan^{(Office 365 for free)} ) waxaa ku jira qaab Gantt ah , haddaba aan si degdeg ah u eegno taas ka hor inta aynaan ku tusin sidaad adigu u samaysan lahayd .

Microsoft Excel Gantt Template

Kahor intaadan bilaabin inaad ka dhisto jaantus xoqan, fadlan ogow inuu jiro qaab-dhismeedka Gantt ee ^(Gantt)Excel . Haddii aad isticmaalayso Xafiiska Online^{(Office Online)} , waa mid ka mid ah Buugaagta Shaqada ee laga heli karo shaashadda^(Workbooks) guriga ee Excel

Qaabka jaantuska Gantt waa mid aad u fiican. ^(Gantt)Xogtaada waxaad geli kartaa shaxda, ka dibna si toos ah xogta ugu dhoofisa shaxda bar rogan. Waxaan kugula talineynaa in aan xoogaa ku khaldano si aan u aragno waxa suurtagal ah jaantusyada Excel Gantt . Si kastaba ha ahaatee, template waa xoogaa dabacsanaan ah, markaa haddii aysan kuu shaqeyn markaa waa inaad ka dhistaa jaantusyada Gantt -kaaga meel xoq ah.

Samaynta Shaxda Gantt adiga kuu gaar ah^{(Making Your Own Gantt Chart)}

1. Haddii aad rabto in arrimuhu noqdaan sidaad jeceshahay, waxaad u baahan doontaa inaad ku bilowdo buug-hawleed maran. Si taas loo sameeyo, ka dooro batoonka buug-shaqeedka cusub ee maran^{(new blank workbook)} barta ugu sarreysa - waa ilaa bidix - oo sug inta uu ku shubanayo. Marka taas la sameeyo, waxaa lagu soo bandhigi doonaa xaashida faaruqinta.

1. Kahor intaadan samayn jaantuska Gantt , waxaad u baahan tahay inaad isku keento xog. Ujeedooyinka sawirka, waxaan iska yeelyeeleynaa inaan hayno shan hawlood oo aan tireyno 1 ilaa 5. Kuwaas waxay gelayaan tiirka A. Tiirka B, ku dar taariikhaha bilowga ah ee khiyaaliga ah afar hawlaha - hubi in unugyadu ay dejisan yihiin inay aqbalaan taariikhaha. Ugu dambeyntii, tiirka C, samee muddada hawl kasta maalmo gudahood. 

Haddii aad rabto, waxaad sidoo kale ku dari kartaa taariikhda dhamaadka tiirka C, ka dibna si toos ah uga jar taariikhaha^{(subtract the dates automatically)} oo muddo natiijada ka soo baxdana lagu soo bandhigo tiirka D. Si kastaba ha ahaatee, kaliya ujeedooyinka dejinta jaantuska Gantt , taariikhda bilawga iyo muddada waa ku filan.

1. Iyada oo taariikhuhu diyaar yihiin, tallaabada xigta waa in la abuuro jaantus is dulsaaran^{(stacked chart)} oo ku salaysan taariikhda bilawga hawlahayaga. Taas awgeed, waxaad u baahan tahay inaad doorato dhammaan xogta shaxda, laga bilaabo A1 ilaa C6, ka dibna dooro gelida^(insert) sare ee bogga (akhri dhammaan wax ku saabsan samaynta jaantusyada Excel^{(making charts in Excel)} ). 

1. Qalabku waxa uu isu beddeli doonaa dhawr ikhtiyaar oo garaaf ah, waxaad u baahan tahay inaad aado xulashooyinka garaafyada oo guji falaarta hoose. Liis dheer oo ikhtiyaari ah ayaa ka soo muuqan doona, baararka^(bars) hoostooda ka dooro bar is dulsaaran^{(stacked bar)} . Hubi inaadan dooran midka loo yaqaan 100% bar la dulsaaray maadaama taasi shaqayn mayso.

1. Microsoft Excel wuu shaqayn doonaa oo shax cusub ayaa ka soo bixi doona badhtanka shaashadda. Tani waa bilawga jaantuskaaga Gantt , in kasta oo aanad weli halkaas joogin.

1. Mid ka mid ah, waxaad u baahan doontaa inaad dib u cabbirto daaqadda (mar hore ayaanu taas ku samaynay tusaalaha kore), ka dib magaca beddelka jaantuska adigoo gujinaya sanduuqa cinwaanka shaxda^{(chart title)} . Inta aad ku jirto,. Sidoo kale ka saar halyeyga gunta hoose ee jaantuska - halkaas oo ay ku qoran tahay taariikhda bilawga^{(start date)} iyo muddada^{(duration )} - adiga oo dooranaya oo garaacaya furaha Delete ee kumbuyuutarkaaga.

1. Marka xigta, waxaad u baahan tahay inaad dib u habayso jaantuska. Hadda, hawsha 5 ayaa meesha ugu sarreysa ku taal, hawsha 1-aadna waa xagga hoose, waxayna u baahan tahay in ay si kale u noqoto. Si taas loo hagaajiyo, midig-guji meel kasta oo shaxda ah oo dooro Qaabka^(Format) sanduuqa wada hadalka ee soo muuqda.

1. Bar hawleed cusub ayaa ka furmi doonta dhanka midig ee shaashaddaada, oo loo yaqaan “ Chart. "Dhammaan fursadaha, dooro dhidibka taagan^{(Vertical Axis)} .

1. Menu-ka soo baxa, calaamee sanduuqa ku xiga goobta oo sheegaya in qaybaha ay u kala horreeyaan^{(categories in reverse order)} . Taasi waa inay hawsha 1 dusheeda gelisaa shaxda.

1. Marka tan la sameeyo, waxaa haray hal tillaabo, oo ah ka saarida qaybta buluuga ah - taas oo ka dhigan taariikhda bilawga - ee bar ka shaxanka. Ka dib oo dhan, shaxda Gantt waxaad danaynaysaa oo kaliya muddada hawlaha; Baarkii buluuga ahaa uun baa jidka soo gelaya.

1. Si aad uga takhalusto, ku dhufo midig mid ka mid ah baararka buluugga ah. Sanduuqa qaab kale ayaa soo bixi doona; ku dhufo Mar labaad, waxa aad heli doontaa shayga gacanta midig oo furan. Markan, in kastoo, waxaan u baahannahay inaan gujino galitaanka Taxanaha "Taariikhda Bilawga."^{(Series “Start Date.”)}

1. Liiskan, dhagsii shayga odhanaya Buuxi^(Fill) , ka bacdi menu-ka midabka weyn ee soo baxay u gudub dhanka hoose oo dooro Ma buuxin^{(No fill)} .

Taas, shaxdaada Gantt^(Gantt) waa la sameeyay. Sanduuqyada liimiga ah (waad dib u midabayn kartaa adigoo isticmaalaya amarka buuxinta haddii aad rabto) waxay muujinayaan marka hawl gaar ah laga shaqeynayo. 

Gantt Charts ee Excel

Taasi waa inay kugu filan tahay inaad ku bilowdo samaynta jaantusyadaada Gantt . In kasta oo qaababka ay Excel bixiso - aan lagu xusin software-ka maaraynta mashruuca-dawaarlaha ah - waxay u badan tahay inay tahay ikhtiyaarka ugu wanaagsan haddii aad qorsheyneyso inaad maareyso hawlo badan, adoo isticmaalaya ikhtiyaarka homebrew sida kor ku xusan ayaa laga yaabaa inay fiicnaato haddii aad la socoto tiro yar oo ah hawlaha ama aad rabto in aad ku darto xoogaa dhadhan fudud bandhigyada.

How to Create Gantt Charts in Microsoft Excel

Gantt charts are a popular way to keеp track of projects, especially for teams that nеed to keep the durаtion of a taѕk in mind. Βy using a Gantt chart effectively, you can make sure different tasks don’t interfere with each other, and even determine when one shоuld finish so another can start. 

There are several ways to make Gantt charts, but in this article we’ll show you how to make one in a program that you probably have available: Microsoft Excel. Though it probably won’t outdo custom-made software when managing a large number of tasks, for small projects it’s a perfectly good alternative.

How to Create Gantt Charts in Microsoft Excel

The nice thing about creating a Gantt chart in Excel is that you probably already own a copy of the spreadsheet and know how to use it. If not, we recommend you check out our Excel tutorial. Most recent versions of Microsoft Excel (we’re using Office Online for this guide, though you can also get Office 365 for free) have a Gantt template included, so let’s take a quick look at that before we show you how to make your own.

Microsoft Excel Gantt Template

Before starting to build a chart from scratch, please note that there’s a Gantt template included in Excel. If you’re using Office Online, it’s one of the available Workbooks in Excel’s home screen

The Gantt chart template is pretty good. You can enter your data in a table, which then automatically exports the data into an inverted bar chart. We recommend messing with it a bit to see what’s possible with Excel Gantt charts. However, the template is a bit inflexible, so if it doesn’t work for you then you’ll have to build your Gantt charts from scratch.

Making Your Own Gantt Chart

1. If you want things to be exactly the way you like, you’ll need to start with a blank workbook. To do so, select the button new blank workbook from the topmost bar — it’s all the way to the left — and wait for it to load. Once that’s done, you’ll be presented with a blank spreadsheet.

1. Before you can make the Gantt chart, you need to put together some data. For illustration purposes, we’ll pretend we have five tasks and number them 1 through 5. Those go into column A. In column B, add some fictitious start dates four the tasks — make sure the cells are set to accept dates. Finally, in column C, set the duration of each task in days. 

If you want, you could also add an end date in column C, then subtract the dates automatically and have the resulting duration be displayed in column D. However, just for purposes of setting up the Gantt chart, the start date and the duration is enough.

1. With the dates ready, the next step is to create a stacked chart based on the start date of our tasks. For that, you need to select all the data in the table, from A1 to C6, and then select insert at the top of the page (read all about making charts in Excel). 

1. The toolbar will change to a number of graph options, you need to go to the graphical options and click the down arrow. A long list of options will appear, under bars pick stacked bar. Make sure not to pick the one called 100% stacked bar as that won’t work.

1. Microsoft Excel will get to work and a new chart will pop up in the middle of the screen. This is the beginnings of your Gantt chart, though you’re not there yet.

1. For one, you’ll probably need to resize the window (we already did that in the above example), then rename the chart by clicking on the chart title box. While you’re at it,. Also remove the legend at the bottom of the chart — where it says start date and duration — by selecting it and hitting the Delete key on your keyboard.

1. Next, you need to reorder the chart. Right now, task 5 is at the top and task 1 is at the bottom, and it needs to be exactly the other way around. To fix that, right-click anywhere on the chart and select Format in the dialog box that appears.

1. A new task bar will open up on the right side of your screen, called “Chart.” From all the options, choose Vertical Axis.

1. In the menu that folds out, check the box next to the setting that says categories in reverse order. That should put task 1 on top in the chart.

1. With this done, there’s only one step remaining, namely removing the blue part — which represents the start date — of the bar from the chart. After all, in a Gantt chart you only care about the duration of tasks; the blue bar is just getting in the way.

1. To get rid of it, right-click any of the blue bars. Another format box will pop up; click it. Once again, you’ll have the right hand pane open up. This time, though, we need to click on the entry for Series “Start Date.”

1. In this menu, click on the item that says Fill, then on the large color menu that pops up go all the way to the bottom and select No fill.

With that, your Gantt chart is all done. The orange boxes (you can recolor them using the fill command if you want) show when a certain task is being worked on. 

Gantt Charts in Excel

That should be enough to get you started with making your own Gantt charts. Though the templates that Excel offers — not to mention tailor-made project management software — are probably a better option if you plan to manage many tasks, using a homebrew option like above might be better if you’re keeping track of a small number of tasks or want to add some easy flavor to presentations.

Related posts

• Sida Loo Fahmo Maxaa-Haddii Falanqaynta Microsoft Excel

• Casharrada Aasaasiga ah ee Microsoft Excel - Barashada Sida loo Isticmaalo Excel

• 40 ka ugu wanaagsan ee Keyboard-ka Microsoft Excel

• Sida Loo Bedelo Taariikhda Kooxda Microsoft

• Kudar Khadka Dib-u-Celinta Toosan ee Qorshaha Kala firdhisan ee Excel

• Sida loo duubo Macro gudaha Excel

• Isticmaal Hawlaha Kooban si aad u soo koobto Xogta ku jirta Excel

• Sida loo sameeyo Histogram gudaha Excel

• Sida loo xisaabiyo kala duwanaanshaha Excel

• Sida loo isticmaalo Excel AutoRecover iyo AutoBackup Features

• Sida loogu daro faallooyinka unugga Xaashida shaqada ee Excel

• Sida Loogu Helo Microsoft Word Lacag La'aan

• 4 Siyaabood Oo Loo Sameeyo Codbixinta Kooxaha Microsoft Inta lagu jiro Kulamada

• Sida loo barto Master-ka Slide ee Microsoft PowerPoint

• Sida loo sameeyo garaafka fudud ama jaantuska gudaha Excel

• Balacaha Saarka AutoFit iyo Dhismayaasha Saf ee Excel

• Sida loo qariyo xaashiyaha, unugyada, tiirarka, iyo qaaciidooyinka gudaha Excel

• Sida loo isticmaalo VLOOKUP gudaha Excel

• Adeegso Excel Mobile's cusub ee shaqada "Ka Geli Xogta Sawirka".

• Hagaaji Microsoft Outlook waxay la kulantay Cilad Dhibaato ah