Kupanga tchati cha Gantt mu Microsoft Excel

Pin
Send
Share
Send

Mwa mitundu yambiri ya zithunzi zomwe zitha kumangidwa pogwiritsa ntchito Microsoft Excel, tchati cha Gantt chikuyenera kufotokozedwa. Ndi tchati chakumaso, kumanzere komwe kumakhala nthawi. Kugwiritsa ntchito, ndikosavuta kuwerengera ndikuwona nthawi. Tiyeni tiwone momwe mungapangire tchati cha Gantt mu Microsoft Excel.

Kupanga kwa tchati

Ndikwabwino kuwonetsa mfundo zopanga tchati cha Gantt pogwiritsa ntchito chitsanzo. Chifukwa cha izi, timatenga tebulo la olemba ntchito, omwe akuwonetsa tsiku lomwe amamasulidwa kutchuthi, ndi kuchuluka kwa masiku omwe akupumula koyenera. Kuti njirayi igwire ntchito, ndikofunikira kuti pambali pomwe mayina a ogwira ntchito alibe. Ngati ili ndi ufulu, ndiye kuti mutuwo uyenera kuchotsedwa.

Choyamba, tikupanga tchati. Kuti muchite izi, sankhani dera la tebulo, lomwe limatengedwa ngati maziko a zomangirazo. Pitani pa tabu ya "Insert". Dinani pa batani la "Ruled" lomwe lili pa riboni. Pamndandanda wamitundu yamtundu wa bar womwe umawonekera, sankhani mtundu uliwonse wa tchati ndi kudziunjikira. Tiyerekeze kuti kwa ife ikhale tchati cha volumetric bar ndi kudzikundikira.

Pambuyo pake, Microsoft Excel ipanga tchatichi.

Tsopano tikuyenera kupanga mzere woyamba wa utoto wabuluu kuti usaonekere kuti mzere wokhawo womwe ukuonetsa nthawi tchuthi ukatsalira pa tchati. Dinani kumanja pa gawo lililonse lazithunzi zajambulachi. Pazosankha zomwe mwasankha, sankhani chinthu "Ma fomati a data ...".

Pitani ku gawo la "Dzazani", ndikukhazikitsa kusinthana "Osadzaza". Pambuyo pake, dinani batani "Tsekani".

Zambiri zomwe zili pa tchati zimapezeka kuchokera pansi kupita pamwamba, zomwe sizoyenera kuzipenda. Yesani kukonza. Timaliza pomwe pamasamba pomwe mayina a ogwira ntchito ali. Pazosankha, pitani ku "Axis mtundu".

Mwakusintha, timafika ku gawo la "Axis Zosintha". Timangofunika. Timayika Mafunso Chidule pamaso pa mtengo "Reverse Category Order". Dinani pa batani la "Close".

Nthano mu tchati cha Gantt sichofunikira. Chifukwa chake, kuti muchotse, sankhani batani la mbewa ndi mbewa, ndikudina batani la Delete pa kiyibodi.

Monga mukuwonera, nthawi yomwe tchati chimakwirira imapitirira malire a chaka cha kalendala. Kuti muphatikize nthawi yokha pachaka, kapena nthawi ina iliyonse, dinani ku nkhwangwa komwe madeti amapezeka. Pazosankha zomwe zimawonekera, sankhani "Axis mtundu" njira.

Mu "Axis Parameter" tabu, pafupi ndi "Minimum Value" ndi "Maximum Value", timasintha kusintha kuchokera ku "auto" mumalowedwe "okhazikika". Tikhazikitsa masiku omwe timafunikira pama windows ofanana. Apa, ngati mukufuna, mutha kukhazikitsa mtengo wa magawo apakati komanso apakati. Dinani pa batani la "Close".

Kuti mumalize kumaliza kusintha tchati cha Gantt, muyenera kupeza dzina lake. Pitani ku tabu "Masanjidwe". Dinani pa batani la "Chart Name". Pamndandanda womwe umawonekera, sankhani mtengo "Pamwamba pa tchati."

M'munda momwe dzinalo lidawonekera, timalowetsa dzina lililonse lomwe limakupangitsani, lomwe limakwaniritsa tanthauzo.

Zachidziwikire, mutha kusintha kusintha kwazotsatira, kusintha momwe mungafunire ndi zomwe mumakonda, pafupifupi mpaka infinity, koma, mwatsatanetsatane, tchati cha Gantt chakonzeka.

Chifukwa chake, monga momwe mukuwonera, kupanga tchati cha Gantt sichinthu chovuta monga momwe chikuwonekera poyamba. Algorithm yomanga, yomwe inafotokozedwa pamwambapa, singagwiritsidwe ntchito osati kungowerengera ndalama komanso kuwongolera maholide, komanso kuthana ndi mavuto ena ambiri.

Pin
Send
Share
Send