Indlela yokudala ishadi le-Gantt ku-Excel?

Uma ucelwa ukuthi usho izingxenye ezintathu ezibaluleke kakhulu ze-Microsoft Excel, ungasho ziphi? Okungenzeka kakhulu, amashidi okufakwa kuwo idatha, amafomula asetshenziselwa ukwenza izibalo, namashadi lapho idatha yemvelo ehlukile ingamelwa khona ngezithombe.

Nginesiqiniseko sokuthi wonke umsebenzisi we-Excel uyazi ukuthi liyini ishadi nokuthi lenziwa kanjani. Nokho, kunohlobo lweshadi elimbozwe ukufiphala kwabaningi - Ishadi le-Gantt. Lo mhlahlandlela osheshayo uzochaza izici eziyinhloko zeshadi le-Gantt, ikutshele ukuthi ulenza kanjani ishadi le-Gantt elilula ku-Excel, ikutshele ukuthi ungalanda kuphi izifanekiso zeshadi elithuthukisiwe le-Gantt, nokuthi ungasebenzisa kanjani isevisi ye-inthanethi Yokuphathwa Kwephrojekthi ukuze udale amashadi e-Gantt.

• Kuyini Ishadi Gantt?
• Indlela yokudala ishadi le-Gantt ku-Excel?
• Izifanekiso zeshadi le-Gantt

Kuyini Ishadi Gantt?

Ishadi le-Gantt eqanjwe ngo-Henry Gantt, unjiniyela waseMelika kanye nomeluleki wabaphathi owaqhamuka nomdwebo ngo-1910. Ishadi le-Gantt ku-Excel limelela amaphrojekthi noma imisebenzi njengenqwaba yamashadi amabha avundlile. Ishadi le-Gantt libonisa isakhiwo esiphukile sephrojekthi (izinsuku zokuqala nezokuqeda, ubudlelwano obuhlukahlukene phakathi kwemisebenzi engaphakathi kwephrojekthi) futhi ngaleyo ndlela lisiza ukulawula ukwenziwa kwemisebenzi ngesikhathi futhi ngokuya ngezilinganiso ezihlosiwe.

Ungalenza kanjani Ishadi le-Gantt ku-Excel 2010, 2007 kanye no-2013

Ngeshwa, i-Microsoft Excel ayinikezi isifanekiso seshadi le-Gantt esakhelwe ngaphakathi. Nokho, ungakwazi ukuzenzela yona ngokushesha usebenzisa ishadi lebha kanye nokufometha okuncane.

Landela lezi zinyathelo ngokucophelela futhi ngeke kuthathe imizuzu engaphezu kwemi-3 ukwakha ishadi le-Gantt elilula. Ezibonelweni zethu, sakha ishadi le-Gantt ku-Excel 2010, kodwa okufanayo kungenziwa ku-Excel 2007 no-2013.

Isinyathelo 1. Dala ithebula lephrojekthi

Okokuqala, sizofaka idatha yephrojekthi eshidini le-Excel. Bhala umsebenzi ngamunye emugqeni ohlukile futhi wakhe uhlelo lokuhlukaniswa kwephrojekthi ngokucacisa usuku okuqalwa ngalo (Usuku okuqalwa ngalo), ukuphothula iziqu (usuku lokugcina) kanye isikhathi (Ubude besikhathi), okungukuthi, inani lezinsuku ezithathwayo ukuqeda umsebenzi.

Ithiphu: Kudingeka amakholomu kuphela ukuze udale ishadi le-Gantt Usuku okuqalwa ngalo и Ubude besikhathi. Nokho, uma futhi udala ikholomu Usuku lokugcina, khona-ke ungakwazi ukubala ubude besikhathi somsebenzi usebenzisa ifomula elula, njengoba kubonakala esithombeni esingezansi:

Isinyathelo sesi-2. Yakha ishadi lebha le-Excel elijwayelekile ngokusekelwe kusizindalwazi sekholomu “Yosuku lokuqala”

Qala ukwakha ishadi le-Gantt ku-Excel ngokwakha okulula ishadi lebha estakiwe:

• Gqamisa ububanzi Qala Izinsuku kanye nesihloko sekholomu, esibonelweni sethu sinjalo B1:B11. Kuyadingeka ukukhetha amaseli anedatha kuphela, hhayi ikholomu yonke yeshidi.
• Kuthebhu ethuthukisiwe Faka (Faka) ngaphansi kokuthi Amashadi, chofoza Faka ibha ishadi (Ibha).
• Kumenyu evulayo, eqenjini Ukhubekile (Ibha ye-2-D) chofoza I-Ruled Stacked (Ibha Estakiwe).

Ngenxa yalokho, ishadi elilandelayo kufanele livele eshidini:

Qaphela: Eminye yeminye imiyalelo yokudala amashadi e-Gantt iphakamisa ukuthi uqale udale ishadi lebha elingenalutho bese uligcwalisa ngedatha, njengoba sizokwenza esinyathelweni esilandelayo. Kodwa ngicabanga ukuthi indlela ebonisiwe ingcono ngoba iMicrosoft Excel izongeza ngokuzenzakalelayo umugqa owodwa wedatha futhi ngale ndlela sizogcina isikhathi esithile.

Isinyathelo sesi-3: Engeza Idatha Yesikhathi Eshadini

Okulandelayo, sidinga ukwengeza olunye uchungechunge lwedatha eshadini lethu le-Gantt lesikhathi esizayo.

1. Chofoza kwesokudla noma yikuphi kumdwebo futhi uchofoze kumenyu yokuqukethwe Khetha idatha (Khetha Idatha).Ibhokisi lengxoxo lizovuleka Ukukhetha umthombo wedatha (Khetha Umthombo Wedatha). Njengoba ungabona esithombeni esingezansi, idatha yekholomu Usuku okuqalwa ngalo vele yengezwe enkanjini Izinto zelejendi (imigqa) (Okufakiwe Kwenganekwane (Uchungechunge). Manje udinga ukwengeza idatha yekholomu lapha Ubude besikhathi.
2. Chofoza inkinobho Engeza (Engeza) ukuze ukhethe idatha eyengeziwe (Ubude besikhathi) ozoboniswa eshadini le-Gantt.
3. Efasiteleni elivuliwe Ukushintsha umugqa (Hlela uchungechunge) yenza lokhu:
   • In the Igama lomugqa (Igama lochungechunge) faka "Ubude besikhathi" nanoma yiliphi elinye igama olifisayo. Noma ungabeka ikhesa kulo mkhakha bese uchofoza isihloko sekholomu ehambisanayo kuthebula - isihloko esichofozwayo sizokwengezwa njengegama lochungechunge lweshadi le-Gantt.
   • Chofoza isithonjana sokukhetha ububanzi eduze kwenkambu Amanani (Amanani ochungechunge).
4. Iwindi lengxoxo Ukushintsha umugqa (Hlela uchungechunge) luzokwehla. Gqamisa idatha kukholomu Ubude besikhathingokuchofoza iseli lokuqala (kithina kunjalo D2) bese uhudulela phansi kuseli yedatha yokugcina (D11). Qiniseka ukuthi awukhethi ngephutha isihloko noma iseli elingenalutho.
5. Cindezela isithonjana sokukhetha ububanzi futhi. Iwindi lengxoxo Ukushintsha umugqa (Hlela uchungechunge) luzonwetshwa futhi futhi izinkambu zizovela Igama lomugqa (Igama lochungechunge) kanye Amanani (Amanani ochungechunge). Chofoza KULUNGILE.
6. Sizobuyela efasiteleni futhi Ukukhetha umthombo wedatha (Khetha Umthombo Wedatha). Manje ensimini Izinto zelejendi (imigqa) (I-Legend Entries (Uchungechunge) sibona uchungechunge Usuku okuqalwa ngalo kanye nenombolo Ubude besikhathi. Vele uchofoze OK, futhi idatha izokwengezwa eshadini.

Umdwebo kufanele ubukeke kanje:

Isinyathelo sesi-4: Engeza Izincazelo Zomsebenzi Eshadini le-Gantt

Manje udinga ukukhombisa uhlu lwemisebenzi ohlangothini lwesobunxele lomdwebo esikhundleni sezinombolo.

1. Chofoza kwesokudla noma yikuphi endaweni yokuhlela (indawo enemigqa eluhlaza okwesibhakabhaka nowolintshi) nakumenyu evelayo, chofoza Khetha idatha (Khetha Idatha) ukuze uvele futhi ibhokisi lengxoxo Ukukhetha umthombo wedatha (Khetha Umthombo Wedatha).
2. Endaweni engakwesokunxele yebhokisi lengxoxo, khetha Usuku okuqalwa ngalo Bese uqhafaza Guqula (Hlela) endaweni engakwesokudla yewindi enesihloko Amalebula e-eksisi avundlile (izigaba) (Okuvundlile (Isigaba) Amalebula e-eksisi).
3. Ibhokisi lengxoxo elincane lizovuleka Amalebula e-eksisi (Amalebula e-eksisi). Manje udinga ukukhetha imisebenzi ngendlela efanayo naleyo esinyathelweni sangaphambilini esikhethe idatha ngesikhathi semisebenzi (ikholomu yezikhathi) - chofoza isithonjana sokukhetha uhla, bese uchofoza umsebenzi wokuqala kuthebula bese uhudula okukhethiwe ngegundane. kuze kufike emsebenzini wokugcina. Khumbula ukuthi isihloko sekholomu akufanele sigqanyiswe. Uma usukwenzile lokho, chofoza isithonjana sokukhetha ububanzi futhi ukuze uveze ibhokisi lengxoxo.
4. Thepha kabili OKukuvala wonke amabhokisi ezingxoxo.
5. Susa inganekwane yeshadi - chofoza kwesokudla kuyo bese uchofoza kumenyu yokuqukethwe Susa (Susa).

Kuleli qophelo, ishadi le-Gantt kufanele libe nezincazelo zomsebenzi ohlangothini lwesobunxele futhi libukeke kanje:

Isinyathelo sesi-5: Ukuguqula Ishadi Lebha libe Ishadi le-Gantt

Kulesi sigaba, ishadi lethu liseyishadi lebha estakiwe. Ukuze ulenze libukeke njengeshadi le-Gantt, udinga ukulifometha ngendlela efanele. Umsebenzi wethu ukususa imigqa eluhlaza okwesibhakabhaka ukuze izingxenye eziwolintshi kuphela zamagrafu, ezimele imisebenzi yephrojekthi, zihlale zibonakala. Ngobuchwepheshe, ngeke sisuse imigqa eluhlaza okwesibhakabhaka, sizovele siyenze ibe sobala futhi ngenxa yalokho ingabonakali.

1. Chofoza kunoma yimuphi umugqa oluhlaza okwesibhakabhaka eshadini le-Gantt, futhi wonke azokhethwa. Chofoza kwesokudla kokukhethiwe bese uchofoza kumenyu yokuqukethwe Ifomethi yochungechunge lwedatha (Uchungechunge Lwedatha Yefomethi).
2. Ebhokisini lengxoxo elivelayo, yenza okulandelayo:
   • Esigabeni Gcwalisa (Gcwalisa) khetha Akukho ukugcwaliswa (Akukho Gcwalisa).
   • Esigabeni Border (Umbala Womngcele) khetha ayikho imigqa (Awukho Umugqa).

Qaphela: Ungalivali leli bhokisi lengxoxo, uzolidinga futhi esinyathelweni esilandelayo.

3. Imisebenzi eseshadini le-Gantt esilakhe ku-Excel ihlehla ngokulandelana. Sizokulungisa lokho maduzane. Chofoza kuhlu lwemisebenzi ohlangothini lwesobunxele lweshadi le-Gantt ukuze ugqamise i-eksisi yesigaba. Ibhokisi lengxoxo lizovuleka Ifomethi ye-eksisi (Fometha i-eksisi). Esahlukweni Imingcele ye-eksisi (Izinketho ze-eksisi) maka ibhokisi Ukuhlehlisa ukuhleleka kwezigaba (Izigaba ngokulandelana kwazo), bese uvala iwindi ukuze ulondoloze izinguquko zakho.Ngenxa yezinguquko esisanda kuzenza:
   • Imisebenzi eseshadini le-Gantt ilandelana ngendlela efanele.
   • Amadethi aku-eksisi evundlile asuke phansi aya phezulu eshadini.

Ishadi lifana neshadi elivamile le-Gantt, akunjalo? Isibonelo, ishadi lami le-Gantt manje selibukeka kanje:

Isinyathelo sesi-6. Ukwenza ngendlela oyifisayo Idizayini Yeshadi le-Gantt ku-Excel

Ishadi le-Gantt selivele liyamila, kodwa ungakwazi ukwengeza ukuthinta okumbalwa kokuqeda ukuze ulenze libe yisitayela ngempela.

1. Susa isikhala esingenalutho ohlangothini lwesobunxele lweshadi le-Gantt

Lapho sakha ishadi le-Gantt, sifake amabha aluhlaza okwesibhakabhaka ekuqaleni kweshadi ukuze sibonise idethi yokuqala. Manje isikhala esisele endaweni yabo singasuswa futhi imicu yomsebenzi ingahanjiswa kwesokunxele, eduze ne-eksisi eqondile.

• Chofoza kwesokudla kunani lekholomu yokuqala Usuku okuqalwa ngalo kuthebula elinedatha yomthombo, kumenyu yokuqukethwe khetha Ifomethi yeseli > Inombolo > General (Fometha Amaseli > Inombolo > Okuvamile). Ngekhanda inombolo oyibona ensimini Sample (Isampula) ukumelwa kwezinombolo kosuku. Endabeni yami le nombolo 41730. Njengoba wazi, i-Excel igcina izinsuku njengezinombolo ezilingana nenani lezinsuku yangoJanuwari 1, 1900 ngaphambi kwalolu suku (lapho uJanuwari 1, 1900 = 1). Awudingi ukwenza izinguquko lapha, vele uchofoze ukukhansela (Khansela).
• Eshadini le-Gantt, chofoza kunoma iyiphi idethi engenhla kweshadi. Ukuchofoza okukodwa kuzokhetha zonke izinsuku, ngemva kwalokho uchofoze kwesokudla kuzo bese uchofoza kumenyu yokuqukethwe Ifomethi ye-eksisi (Fometha i-eksisi).
• Kumenyu Amapharamitha i-axis (Izinketho ze-eksisi) shintsha inketho Minimum (Okungenani) kuvuliwe Inombolo (Kulungisiwe) bese ufaka inombolo oyikhumbule esinyathelweni esedlule.

2. Lungisa inani lamadethi ku-eksisi yeshadi le-Gantt

Lapha, ebhokisini lengxoxo Ifomethi ye-eksisi (Fometha i-eksisi) evulwe esinyathelweni sangaphambilini, shintsha amapharamitha Izigaba ezinkulu (i-Major united) njll Ukuhlukana okuphakathi (Iyunithi encane) ye Inombolo (Kulungisiwe) bese ufaka amanani afiselekayo ezikhawu ku-eksisi. Ngokuvamile, lapho amafreyimu esikhathi emisebenzi ephrojekthi eba mfishane, kudingeka isinyathelo sokuhlukanisa sibe sincane ku-eksisi yesikhathi. Isibonelo, uma ufuna ukukhombisa zonke izinsuku zesibili, bese ufaka 2 okwepharamitha Izigaba ezinkulu (Iyunithi enkulu). Yiziphi izilungiselelo engizenzile - ungazibona esithombeni esingezansi:

Ithiphu: Dlala ngezilungiselelo uze uthole umphumela oyifunayo. Ungesabi ukwenza okuthile okungalungile, ungakwazi njalo ukubuyela kuzilungiselelo ezizenzakalelayo ngokusetha izinketho ukuthi Ngokuzenzekelayo (Okuzenzakalelayo) ku-Excel 2010 no-2007 noma ngokuchofoza Hlela (Setha kabusha) ku-Excel 2013.

3. Khipha isikhala esingenalutho phakathi kwemigqa

Hlela amabha omsebenzi eshadini ahlangane kakhudlwana, futhi ishadi le-Gantt lizobukeka lingcono nakakhulu.

• Khetha amabha awolintshi emagrafu ngokuchofoza eyodwa yawo ngenkinobho yegundane engakwesokunxele, bese uchofoza kwesokudla kuyo futhi kumenyu evelayo, uchofoze. Ifomethi yochungechunge lwedatha (Uchungechunge Lwedatha Yefomethi).
• Ebhokisini lengxoxo Ifomethi yochungechunge lwedatha (Fometha Uchungechunge Lwedatha) setha ipharamitha ukuze imigqa eyeqanayo (Ukugqagqana Kochungechunge) inani 100% (isilayidi sihanjiswe kwesokudla), kanye nepharamitha Ukususwa kohlangothi (I-Gap Width) inani elingu-0% noma cishe u-0% (isilayidi yonke indlela noma cishe yonke indlela ukuya kwesokunxele).

Futhi nawu umphumela wemizamo yethu - ishadi le-Gantt elilula kodwa elinembile ku-Excel:

Khumbula ukuthi ishadi le-Excel elakhiwe ngale ndlela liseduze kakhulu neshadi langempela le-Gantt, kuyilapho ligcina konke ukusebenziseka kwamashadi e-Excel:

• Ishadi le-Gantt ku-Excel lizoshintsha usayizi lapho imisebenzi yengezwa noma isuswa.
• Shintsha idethi yokuqala komsebenzi (Usuku lokuqala) noma ubude besikhathi sawo (Ubude besikhathi), futhi isimiso sizobonisa ngokuzenzakalelayo izinguquko ezenziwe.
• Ishadi le-Gantt elidalwe ku-Excel lingalondolozwa njengesithombe noma liguqulelwe kufomethi ye-HTML futhi lishicilelwe ku-inthanethi.

I-ADVICE:

• Enza ngendlela oyifisayo ukubukeka kweshadi lakho le-Gantt ngokushintsha izinketho zokugcwalisa, imingcele, izithunzi, ngisho nokusebenzisa imiphumela ye-3D. Zonke lezi zinketho ziyatholakala ebhokisini lengxoxo. Ifomethi yochungechunge lwedatha (Uchungechunge Lwedatha Yefomethi). Ukuze ushayele leli windi, chofoza kwesokudla kubha yeshadi endaweni yokuhlela ishadi bese uchofoza kumenyu yokuqukethwe Ifomethi yochungechunge lwedatha (Uchungechunge Lwedatha Yefomethi).
• Uma isitayela sokuklama esidaliwe sijabulisa iso, khona-ke ishadi elinjalo le-Gantt lingagcinwa ku-Excel njengesifanekiso futhi lisetshenziswe esikhathini esizayo. Ukuze wenze lokhu, chofoza umdwebo, vula ithebhu umakhi (Design) bese ucindezela Londoloza njengesifanekiso (Londoloza Njengesifanekiso).

Landa ishadi lesampula le-Gantt

Isifanekiso seshadi le-Gantt ku-Excel

Njengoba ubona, ukwakha ishadi le-Gantt elilula ku-Excel akunzima nhlobo. Kodwa kuthiwani uma kudingeka ishadi le-Gantt eliyinkimbinkimbi, lapho ukufiphazwa komsebenzi kuncike kumaphesenti wokuqedwa kwawo, kanye nezinyathelo ezibalulekile zephrojekthi ziboniswa ngemigqa eqondile? Kunjalo, uma ungomunye walezo zidalwa eziyivelakancane nezingaqondakali esizibiza ngenhlonipho nge-Excel Guru, ungazama ukuzenzela wena umdwebo onjalo.

Nokho, kuzoshesha futhi kube lula ukusebenzisa izifanekiso zeshadi le-Gantt ezenziwe ngaphambilini ku-Excel. Ngezansi ukubuka okufushane kwezifanekiso ezimbalwa zeshadi le-Gantt lokuphatha iphrojekthi yezinguqulo ezihlukahlukene ze-Microsoft Excel.

Isifanekiso Seshadi se-Microsoft Excel 2013 Gantt

Lesi sifanekiso seshadi le-Gantt se-Excel sibizwa Umhleli weProjekthi (Gantt Project Planner). Idizayinelwe ukulandelela inqubekelaphambili yephrojekthi ngokumelene namamethrikhi ahlukahlukene njenge Isiqalo esihleliwe (Hlela Qala) kanye isiqalo sangempela (Isiqalo Sangempela), Ubude besikhathi obuhleliwe (Isikhathi Sohlelo) kanye Ubude Bangempela (Isikhathi Sangempela), kanjalo Amaphesenti aqediwe (Amaphesenti Aphelele).

Ku-Excel 2013, lesi sifanekiso sitholakala kuthebhu Ifayela (Ifayela) efasiteleni Dala (Okusha). Uma singekho isifanekiso kulesi sigaba, ungasilanda kuwebhusayithi ye-Microsoft. Alukho ulwazi olwengeziwe oludingekayo ukuze usebenzise lesi sifanekiso - chofoza kuso bese uqalisa.

Ishadi lesifanekiso se-inthanethi Ganta

I-Smartsheet.com inikeza i-Gantt Chart Builder esebenzisanayo eku-inthanethi. Lesi sifanekiso seshadi le-Gantt silula futhi silungele ukusetshenziswa njengesangaphambilini. Isevisi inikeza isivivinyo samahhala sezinsuku ezingu-30, ngakho-ke zizwe ukhululekile ukubhalisa nge-akhawunti yakho ye-Google bese uqala ukudala ishadi lakho lokuqala le-Gantt ngokushesha.

Inqubo ilula kakhulu: kuthebula elingakwesokunxele, faka imininingwane yephrojekthi yakho, futhi njengoba ithebula ligcwalisa, ishadi le-Gantt liyakhiwa kwesokudla.

Izifanekiso zeshadi le-Gantt le-Excel, i-Google AmaSpredishithi ne-OpenOffice Calc

Ku-vertex42.com ungathola izifanekiso zeshadi le-Gantt zamahhala ze-Excel 2003, 2007, 2010 kanye no-2013 ezizosebenza ne-OpenOffice Calc kanye ne-Google AmaSpredishithi. Ungakwazi ukusebenza ngalezi zifanekiso njengoba ubungenza nganoma yisiphi isipredishithi esivamile se-Excel. Vele ufake idethi yokuqala nobude besikhathi somsebenzi ngamunye bese ufaka u-% ophelele kukholamu % kuqediwe. Ukuze ushintshe ibanga ledethi eliboniswe endaweni yeshadi le-Gantt, hambisa isilayidi kubha yokuskrola.

Futhi ekugcineni, esinye isifanekiso seshadi le-Gantt ku-Excel ukuze usicabangele.

Isifanekiso Seshadi Somphathi Wephrojekthi ye-Gantt

Esinye isifanekiso samahhala seshadi le-Gantt sinikezwa ku-professionalexcel.com futhi sibizwa ngokuthi “Ishadi Le-Gantt Lomphathi Wephrojekthi”. Kulesi sifanekiso, kungenzeka ukukhetha ukubuka (nsuku zonke noma okujwayelekile masonto onke), kuye ngokuthi ubude bemisebenzi elandelwayo.

Ngethemba ukuthi okungenani isifanekiso esisodwa seshadi le-Gantt esihlongozwayo sizohambisana nezidingo zakho. Uma kungenjalo, ungathola izinhlobonhlobo eziningi zezifanekiso zamashadi e-Gantt ku-inthanethi.

Manje njengoba usuzazi izici eziyinhloko zeshadi le-Gantt, ungaqhubeka ulifunda futhi ufunde ukuthi ungawakha kanjani amashadi akho ayinkimbinkimbi e-Gantt ku-Excel ukuze umangaze umphathi wakho nabo bonke ozakwenu 🙂