Zamkatimu
Nthawi zina zimakhala zovuta kufananiza mwachangu komanso moyenera nthawi yama projekiti. Chiwonetsero cha nthawi yomaliza ya polojekiti ndi zochitika zazikuluzikulu zithandizira kuzindikira zovuta zilizonse panthawi yokonzekera.
Inde, ndi bwino kulingalira za kugwiritsa ntchito machitidwe oyendetsera polojekiti. Dongosolo loterolo lidzawonetsa nthawi yoyambira ndi yomaliza ya ntchito za polojekiti motsutsana ndi maziko onse. Koma machitidwe otere ndi okwera mtengo kwambiri! Yankho lina ndikuyesa kugwiritsa ntchito tchati chanthawi ya Excel pokonzekera kuwona mikangano yonse yomwe ili mu polojekitiyi. Kugwirizana ndi gulu komanso akatswiri a chipani chachitatu kudzakhala kosavuta ngati zochita za aliyense zitha kuwoneka patsamba lomwelo!
Tsoka ilo, kupanga nthawi mu Microsoft Excel si ntchito yophweka. Sindingapangire kupanga tchati chovuta cha Gantt ku Excel, koma nthawi yosavuta ikhoza kupangidwa potsatira malangizo athu pang'onopang'ono:
Gawo 1: Konzani deta
Poyamba, tikufuna tebulo la data, lomwe lili kumanzere kwake (gawo А) ili ndi mayina onse a ntchito, ndipo mizati iwiri kumanja yasungidwa tsiku loyambira ndi nthawi ya ntchitoyo (mizere В и С).
Gawo 2: Pangani tchati
Onetsani tebulo la deta lokonzekera, ndiye pa tabu Ikani (Ikani) mu gawo Zithunzi (Matchati) dinani Ruled Stacked (Zosanjikiza Bar).
Khwerero 3: Kuyika Zambiri pa Tchati Molondola
Njirayi nthawi zonse imakhala yovuta kwambiri, chifukwa tchaticho chimakonzedwa poyamba ndi deta yolondola m'malo olakwika, ngati detayo idawonekerapo pa tchati!
Dinani batani Sankhani deta (Sankhani Data) tabu Constructor (Kupanga). Onani zomwe zili m'deralo Zinthu za nthano (mizere) (Zolemba za Nthano (Zotsatira)) zinthu ziwiri zalembedwa - nthawi (Nthawi) ndi tsiku loyambira (Tsiku Loyambira). Payenera kukhala zinthu ziwiri izi.
Ndiloleni ndiganizire. Kodi zonse zasuntha kapena zasunthira kumbali? Tiyeni tikonze.
Kuti mukonze deta yanu, dinani kuwonjezera (Onjezani) kapena Change (Sinthani) m'deralo Zinthu za nthano (mizere) (Zolemba za Nthano (Series)). Kuti muwonjezere Tsiku Loyambira, tchulani selo B1 m'munda Dzina la mzere (Dzina la Mndandanda), komanso m'munda Makhalidwe (Series Values) - osiyanasiyana B2:b13. Momwemonso, mutha kuwonjezera kapena kusintha nthawi ya ntchito (Kutalika) - m'munda Dzina la mzere (Series Name) tchulani selo C1, ndi m’munda Makhalidwe (Series Values) - osiyanasiyana c2: c13.
Kuti mukonze magawo, dinani batani Change (Sinthani) m'deralo Zolemba zopingasa (magulu) (Zopingasa (Gawo) Zolemba za Axis). Munda wa data uyenera kufotokozedwa apa:
=Лист3!$A$2:$A$13
=Sheet3!$A$2:$A$13
Pakadali pano, tchaticho chikuyenera kuoneka ngati tchati chokhazikika chokhala ndi mitu yantchito pamizere yopingasa ndi madeti opingasa.
Khwerero 4: Kusintha Zotsatira kukhala Tchati cha Gantt
Zomwe zikuyenera kuchitika ndikusintha mtundu wodzaza wa mbali zakumanzere za ma graph onse omwe atuluka kuti akhale oyera kapena owonekera.
★ Werengani zambiri za kupanga tchati cha Gantt m'nkhaniyi: → Momwe mungapangire tchati cha Gantt mu Excel - malangizo a sitepe ndi sitepe
Khwerero 5: Kusintha Mawonekedwe a Tchati
Chomaliza ndikupangitsa chithunzicho kukhala chokongola kuti chitumizidwe kwa manejala. Yang'anani njira yopingasa: mipiringidzo yokha ya nthawi ya polojekiti iyenera kuwoneka, mwachitsanzo, tifunika kuchotsa malo opanda kanthu omwe adawonekera mu sitepe yapitayi. Dinani kumanja pamzere wopingasa wa tchati. Gulu lidzawoneka Magawo a axis (Zosankha za Axis), momwe mungasinthire mtengo wocheperako wa axis. Sinthani makonda amitundu yama chart a Gantt, ikani china chosangalatsa kwambiri. Pomaliza, musaiwale mutuwo.
Nthawi mu Excel (Gantt chart) itha kugwiritsidwa ntchito pazifukwa zosiyanasiyana. Otsogolera adzayamikiradi kuti mutha kupanga ndondomeko yotere popanda ndalama zowonjezera kugula mapulogalamu okwera mtengo oyendetsera polojekiti!