Ukwakha ishadi le-Gantt eMicrosoft Excel

Pin
Send
Share
Send

Phakathi kwezinhlobo eziningi zemidwebo ezingakhiwa kusetshenziswa iMicrosoft Excel, ishadi likaGantt kufanele liqokonyiswe. Iy Ishadi lebha elivundlile, ku-eksisi enezingqimba etholakala umugqa wesikhathi. Ukuyisebenzisa, kulula kakhulu ukubala futhi ubone isikhathi sezikhathi. Ake sibheke ukuthi bangakha kanjani ishadi le-Gantt ku-Microsoft Excel.

Ukudalwa kweshadi

Kungcono ukukhombisa imigomo yokwakha ishadi le-Gantt usebenzisa isibonelo esithile. Kulokhu, sithatha itafula labasebenzi bebhizinisi, elibonisa usuku lokukhululwa kwabo eholidini, kanye nenani lezinsuku zokuphumula okufanele. Ukuze indlela isebenze, kubalulekile ukuthi ikholamu lapho amagama abasebenzi angabinawo amagama. Uma inelungelo, khona-ke isihloko kufanele sisuswe.

Okokuqala, sakha ishadi. Ukuze wenze lokhu, khetha indawo yetafula, ethathwa njengesisekelo sokwakhiwa. Iya kuthebhu ethi "Faka". Chofoza inkinobho ethi "Ruled" etholakala ku-ribbon. Kuluhlu lwezinhlobo zeshadi le-bar elivelayo, khetha noma yiluphi uhlobo lweshadi ngokuqongelela. Ake sithi esimeni sethu kuzoba yishadi lomthamo omningi ngokuqongelela.

Ngemuva kwalokho, iMicrosoft Excel yakha leli shadi.

Manje sidinga ukwenza umugqa wokuqala wombala oluhlaza okwesibhakabhaka ungabonakali ukuze umugqa okhombisa isikhathi samaholide usasele eshadini. Qhafaza kwesokudla kunoma yisiphi isigaba esiluhlaza kulo mdwebo. Kumenyu yokuqukethwe, khetha into ethi "Idatha yechungechunge ledatha ...".

Iya kusigaba esithi "Gcwalisa", bese usetha ukushintshela ku- "Akukho ukugcwaliswa". Ngemuva kwalokho chofoza inkinobho ethi "Vala".

Imininingwane eseshadini itholakala ukusuka phansi kuya phezulu, okungekulungele kakhulu ukuhlaziya. Zama ukukulungisa. Sichofoza kwesokudla ku-eksisi lapho amagama abantu abasebenza khona. Kumenyu yokuqukethwe, iya entweni "yefomethi ye-Axis".

Ngokuzenzakalelayo, sifika engxenyeni ethi "Izilungiselelo ze-Axis". Siyayidinga nje. Sibeka umkhaza phambi kwenani "Reverse Category Order". Chofoza inkinobho ethi "Vala".

Inganekwane eshadini likaGantt ayidingeki. Ngakho-ke, ukuze uyisuse, khetha inkinobho yegundane negundane, bese uchofoza inkinobho ethi Delete kukhibhodi.

Njengoba ukwazi ukubona, isikhathi isembozo esidingida ishadi sidlula kwemingcele yonyaka wekhalenda. Ukuze ufake kuphela isikhathi sonyaka, noma esinye isikhathi sesikhathi, chofoza ku-axis lapho izinsuku zitholakala khona. Kumenyu evelayo, khetha inketho "yefomathi ye-Axis".

Kuthebhu ethi "Axis Parameter", eduzane nezilungiselelo ze- "Minimum Value" ne- "Maximum Value", sishintsha ukushintshwa kusuka kumodi ye- "auto" iye kumodi "ehleliwe". Sibeka izinsuku esizidingayo kumawindows ahambisanayo. Lapha, uma kufiswa, ungabeka inani lentengo lokwehlukaniswa okukhulu nokuphakathi. Chofoza inkinobho ethi "Vala".

Ukuze uqede ukuhlela ishadi le-Gantt, udinga ukuza negama ngalo. Iya kuthebhu "Isakhiwo". Chofoza inkinobho ethi "Igama Leshadi". Kuluhlu olubonakala, khetha inani "Ngaphezulu kweshadi."

Emkhakheni lapho kwavela khona igama, sifaka noma yiliphi igama elikufanele, elihambisana nencazelo.

Vele, ungafeza ukuhlela okwengeziwe komphumela, ukwenze kube ngokwezidingo zakho kanye nokunambitheka, cishe ukungafiki, kepha, ngokuvamile, ishadi le-Gantt lilungile.

Ngakho-ke, njengoba ubona, ukwakha ishadi le-Gantt akunzima njengoba kubonakala ekuqaleni. I-algorithm yokwakha, echazwe ngenhla, angeke isetshenziselwe hhayi kuphela ukubalwa kwezimali nokulawula amaholide, kepha futhi nokusombulula ezinye izinkinga eziningi.

Pin
Send
Share
Send