Contents
Wani lokaci yana iya zama da wahala a yi sauri da inganci daidai da lokutan ayyukan. Hoton hoto na ƙayyadaddun ayyukan aiki da abubuwan da suka faru zai taimaka gano duk wani cikas yayin tsarawa.
Tabbas, yana da daraja la'akari da amfani da tsarin gudanar da ayyukan. Irin wannan tsarin zai nuna farkon da ƙarshen lokutan ayyukan aikin a kan tushen gaba ɗaya. Amma irin waɗannan tsarin suna da tsada sosai! Wani bayani shine gwada amfani da ginshiƙi na lokaci na Excel lokacin da ake shirin ganin duk rikice-rikice a cikin aikin. Haɗin kai tare da ƙungiyar kuma tare da ƙwararrun ɓangare na uku zai zama mafi sauƙi idan ana iya ganin ayyukan kowa da kowa akan takarda ɗaya!
Abin takaici, ƙirƙirar tsarin lokaci a cikin Microsoft Excel ba abu ne mai sauƙi ba. Ba zan ba da shawarar gina hadadden ginshiƙi na Gantt a cikin Excel ba, amma ana iya ƙirƙira lokaci mai sauƙi ta bin umarnin mataki-mataki:
Mataki 1: Shirya bayanai
Don farawa, muna buƙatar tebur bayanai, a cikin ginshiƙi na hagu wanda (column А) ya ƙunshi duk sunaye na ɗawainiya, kuma ginshiƙai biyu na hannun dama an tanada su don ranar farawa da tsawon lokacin aikin (ginshiƙai). В и С).
Mataki 2: Ƙirƙiri ginshiƙi
Hana teburin bayanan da aka shirya, sannan akan shafin Saka (Saka) a cikin sashe Diagrams (Charts) danna Hukunci Stacked (Stacked Bar).
Mataki 3: Ƙirƙirar bayanai akan Chart Daidai
Wannan mataki koyaushe shine mafi wahala, saboda an fara tsara ginshiƙi tare da ingantattun bayanai a wuraren da ba daidai ba, idan bayanan sun taɓa bayyana akan ginshiƙi!
Latsa maɓallin Zaɓi bayanai (Zaɓi Bayanai) tab Constructor (Zane). Duba abin da ke cikin yankin Abubuwan almara ( layuka) (Legend Entries (Series)) an rubuta abubuwa guda biyu - Tsawon lokaci (Lokaci) da kwanan watan farawa (Date farawa). Ya kamata a sami waɗannan abubuwa guda biyu kawai.
Bari in yi tsammani. Shin duk bayanan sun motsa ko sun koma gefe? Mu gyara.
Don gyara bayananku, danna Add (Ƙara) ko Change (Edit) a cikin yankin Abubuwan almara ( layuka) (Shigarwar Legend (Series)). Don ƙara kwanan watan farawa, saka tantanin halitta B1 a cikin filin Sunan layi (Series Name), kuma a cikin filin Da dabi'u (Series Values) - kewayon B2: b13. Hakazalika, zaka iya ƙara ko canza tsawon lokaci na ayyuka (Lokaci) - a cikin filin Sunan layi (Series Name) saka tantanin halitta C1, kuma a cikin filin Da dabi'u (Series Values) - kewayon ku: ku2.
Don daidaita nau'ikan, danna maɓallin Change (Edit) a cikin yankin Alamun axis na kwance (kasuwa) (A kwance (Kashi) Alamomin Axis). Ya kamata a bayyana kewayon bayanan anan:
=Лист3!$A$2:$A$13
=Sheet3!$A$2:$A$13
A wannan lokaci, ginshiƙi ya kamata ya yi kama da ginshiƙi mai ɗorewa tare da taken ɗawainiya a kan kusurwoyi na tsaye da kwanakin akan axis a kwance.
Mataki 4: Juya Sakamakon zuwa Tsarin Gantt
Duk abin da ya rage a yi shi ne canza launin cika mafi girman sassan dukkan sandunan jadawali da aka samu zuwa ko dai fari ko bayyane.
★ Kara karantawa game da ƙirƙirar taswirar Gantt a cikin labarin: → Yadda ake gina taswirar Gantt a cikin Excel - umarnin mataki-mataki
Mataki 5: Inganta Kallon Chart
Mataki na ƙarshe shine a sanya zane mai kyau don a aika shi ga manajan. Duba axis a kwance: kawai sanduna tsawon lokacin aikin ya kamata a bayyane, watau muna buƙatar cire sarari mara amfani wanda ya bayyana a matakin da ya gabata. Danna dama akan madaidaicin ginshiƙi na ginshiƙi. Wani panel zai bayyana sigogi na axis (Zaɓuɓɓukan Axis), wanda a ciki zaku iya canza ƙaramar ƙimar axis. Keɓance launukan sandunan ginshiƙi na Gantt, saita wani abu mafi ban sha'awa. A ƙarshe, kar a manta da take.
Tsarin lokaci a cikin Excel (Gantt ginshiƙi) ana iya amfani da shi don dalilai daban-daban. Tabbas Gudanarwa zai yaba da cewa zaku iya ƙirƙirar irin wannan jadawalin ba tare da ƙarin kashe kuɗi na siyan software mai sarrafa kayan aiki masu tsada ba!