Okuqukethwe
I-Excel akuyona nje eyokusebenza ngedatha yethebula. Uhlelo futhi ikuvumela ukuba wakhe anhlobonhlobo amashadi, phakathi lapho ishadi Gantt, mhlawumbe, lifanelwe ukunakwa okukhethekile. Lolu uhlobo lweshadi oluvamile noludumile olubukeka njengeshadi lebha elinomugqa wesikhathi ovundlile. Ikuvumela ukuthi uhlaziye kahle idatha yethebula ngamadethi nezikhawu zesikhathi. Cishe uye wayibona imidwebo enjalo kaningi, njengoba isetshenziswa cishe yonke indawo. Kulesi sihloko, sizochaza ngokuningiliziwe futhi isinyathelo ngesinyathelo indlela yokwakha.
Okuqukethwe: "Ungalakha kanjani ishadi le-Gantt ku-Excel"
Ukwakhiwa kweshadi
Ukuze ubonise futhi uchaze ngendlela efinyelelekayo ukuthi ishadi le-Gantt lakhiwe kanjani, sizosebenzisa isibonelo esicacile. Thatha uphawu olunohlu lwezimpahla zezemidlalo, lapho izinsuku zokuthunyelwa kwazo kanye nesikhathi sokulethwa kumakwa.
Naka imininingwane eyodwa ebalulekile! Ikholomu enegama lempahla kufanele ibe ngaphandle kwegama - lokhu kuyisidingo, ngaphandle kwalokho indlela ngeke isebenze. Uma ikholomu inesihloko, kufanele isuswe.
Ngakho-ke, ake siqale ukwakha ishadi le-Gantt.
- Okokuqala, ake sakhe umdwebo olula. Ukuze wenze lokhu, udinga ukugqamisa ingxenye oyifunayo yetafula ngekhesa bese uchofoza "Faka". Lapha, kubhulokhi ethi “Histogram”, khetha uhlobo “lwebha Estakiwe". Ngezinjongo zethu, phakathi kwezinye izinto, "umugqa oyisitaki we-XNUMXD" nawo ufanelekile.
- Siwutholile umdwebo wethu futhi singadlulela esinyathelweni esilandelayo.
- Manje umsebenzi wethu ukususa umugqa oluhlaza okwesibhakabhaka, siwenze ungabonakali. Ngenxa yalokho, kufanele kuboniswe imicu kuphela enesikhathi sokulethwa. Chofoza kwesokudla noma yikuphi kunoma iyiphi ikholomu eluhlaza okwesibhakabhaka bese uchofoza kokuthi “Fometha Uchungechunge Lwedatha…”.
- Ewindini elivulayo, hamba entweni ethi "Gcwalisa", setha le pharamitha ngokuthi "Akukho ukugcwalisa" bese uvala iwindi lezilungiselelo.
- Njengoba sibona, amalebula edatha kumdwebo owumphumela awekho kahle kakhulu (kusuka phansi kuye phezulu), okungase kube nzima kakhulu ukuhlaziya kwawo. Kodwa lokhu kungashintshwa.
- Esigabeni esinamagama omkhiqizo, chofoza igundane (inkinobho yesokudla) bese ukhetha into ethi “Fometha i-eksisi ..”.
- Lapha sidinga isigaba esithi “Axis Parameters”, ngokuzenzakalelayo sivele singene kuso ngaso leso sikhathi. Sibheka ipharamitha "Ukuhlehla kwezigaba" bese sibeka umaka phambi kwayo. Manje usungakwazi ukuvala ibhokisi lengxoxo.
- Asiyidingi inganekwane kulo mdwebo. Masiyisuse ngokuyikhetha ngegundane bese sicindezela inkinobho ethi “Susa” kukhibhodi.
- Naka imininingwane eyodwa. Uma, uthi, ufuna ukukhombisa kuphela isikhathi sonyaka wekhalenda, noma esinye isikhathi, chofoza kwesokudla endaweni lapho amadethi atholakala khona. Kuzovela imenyu esinentshisekelo kuyo entweni ethi “Format Axis …”, chofoza kuyo.
- Iwindi elinezilungiselelo lizovuleka. Lapha, kumapharamitha e-eksisi, uma kudingeka, ungabeka amanani osuku adingekayo (ubuncane nobuningi). Ngemva kokwenza izinguquko, vala ibhokisi lengxoxo.
- Ishadi lethu le-Gantt selicishe lilungile, okusele nje ukulinikeza isihloko.
- Ukuze wenze lokhu, chofoza kwesokunxele egameni, bese ulikhetha futhi ulilungise kulokho esikudingayo. Futhi, ngokuba kuthebhu "Ekhaya", ungakwazi, isibonelo, ukusetha usayizi wefonti futhi uwenze isibindi.
- Yilokho kuphela, ishadi lethu le-Gantt selilungile ngokuphelele.
Yebo, ungaqhubeka nokuhlela umdwebo, ngoba amandla e-Excel akuvumela ukuthi uwenze ngendlela ofisa ngayo ukubukeka nezidingo ozifunayo, usebenzisa amathuluzi kuthebhu ethi “Umklami”. Kodwa, ngokuvamile, manje kungenzeka ukusebenza ngokugcwele nayo.
Isiphetho
Uma uthi nhlá, kubonakala sengathi ukwakha ishadi le-Gantt ku-Excel kuwumsebenzi onzima kakhulu odinga isikhathi esiningi nomzamo. Kodwa-ke, ekusebenzeni kuvela ukuthi lo msebenzi uyenzeka futhi, ngaphezu kwalokho, uthatha isikhathi esincane kakhulu. Umdwebo esiwubonise ngenhla uyisibonelo nje. Ngokufanayo, ungakha noma yimuphi omunye umdwebo ukuze uxazulule izinkinga zakho.