Daga cikin nau'ikan zane-zane da za a iya gina ta amfani da Microsoft Excel, ya kamata a fifita ginshiƙi Gantt. Yana da kwance matattakala mai shinge, a kan tsattsauran ra'ayi wanda ya ke kasancewa cikin tsarin lokaci. Amfani da shi, ya dace sosai don lissafawa da hangen nesa na hangen nesa. Bari mu ga yadda za a gina ginshiƙi Gantt a Microsoft Excel.
Yarjejeniya
Zai fi kyau a nuna ka'idodin ƙirƙirar ginshiƙi na Gantt ta amfani da takamaiman misali. Don wannan, muna ɗaukar tebur na ma'aikatan kamfanin, wanda ke nuna ranar da aka sake su akan hutu, da kuma adadin ranakun da suka cancanci a huta. Domin hanyar ta yi aiki, to ya zama tilas a sanya shafin inda ba a bayyana sunayen ma’aikatan. Idan ya cancanta, to yakamata a cire taken.
Da farko dai, muna gina ginshiƙi. Don yin wannan, zaɓi yankin na tebur, wanda aka ɗauka a matsayin tushen ginin. Je zuwa shafin "Saka". Danna maɓallin "Ruled" wanda ke kan kintinkiri. A cikin jerin nau'ikan ginshiƙi ginshiƙi wanda ya bayyana, zaɓi kowane nau'in ginshiƙi tare da tara kaya. A ce a cikin yanayinmu zai zama ginshiƙi mai ma'ana tare da tara kaya.
Bayan wannan, Microsoft Excel yana ƙirƙirar wannan jadawalin.
Yanzu muna buƙatar yin layin farko na launin shuɗi marar ganuwa don haka layi kawai wanda ke nuna lokacin hutu ya saura akan ginshiƙi. Kaɗa hannun dama akan kowane shudi na wannan hoton. A cikin menu na mahallin, zaɓi abu "Tsarin jerin bayanai ...".
Jeka bangaren "Cika", sannan saita canza zuwa "Babu cika". Bayan haka, danna maɓallin "rufe".
Bayanai a kan ginshiƙi suna daga tushe zuwa sama, wanda ba shi da madaidaici don bincike. Ka yi kokarin gyara shi. Mun danna dama-dama kan shinge inda sunayen ma'aikatan suke. A cikin menu na mahallin, je zuwa abun "Tsarin Axis".
Ta hanyar tsoho, muna isa ga "Saiti na Axis". Muna bukatar shi kawai. Mun sanya kaska a gaban ƙimar "Tsarin Categoryabi'a Na Kashe". Latsa maɓallin "rufe".
Ba a buƙatar almara a cikin ginshiƙi Gantt ba. Saboda haka, don cire shi, zaɓi maɓallin linzamin kwamfuta tare da linzamin kwamfuta, kuma danna maɓallin Sharewa akan maballin.
Kamar yadda kake gani, lokacin da ginshiƙi ya rufe ya wuce iyakokin shekarar kalandar. Don haɗawa kawai lokacin shekara-shekara, ko kowane lokaci, danna kan ma'aunin inda kwanakin suke. A cikin menu wanda ya bayyana, zaɓi zaɓi "Tsarin Axis".
A cikin shafin "Sigogin Axis", kusa da saitunan "imumarancin "imar" da "Matsakaicin ueimar", za mu sauya sauya daga yanayin "auto" zuwa yanayin "gyarawa". Mun sanya kwanakin da muke buƙata a cikin windows masu dacewa. Anan, idan ana so, zaku iya saita farashin manyan da matsakaitan rarrabuwa. Latsa maɓallin "rufe".
Domin a ƙarshe gama gyaran Gantt ginshiƙi, kuna buƙatar fito da suna don shi. Je zuwa shafin "Layout". Danna maɓallin "Chart Name". A lissafin da ya bayyana, zaɓi ƙimar "Sama da ginshiƙi."
A filin da sunan ya bayyana, mun shigar da kowane suna wanda ya dace da kai, wanda ya dace da ma'anar.
Tabbas, zaku iya aiwatar da ƙarin gyara na sakamakon, kuna tsara shi don buƙatunku da dandani, kusan zuwa iyaka, amma, gabaɗaya, ginshiƙi ɗin Gantt yana shirye.
Don haka, kamar yadda kake gani, gina jadawalin Gantt ba shi da wahala kamar yadda ake gani da farko. Algorithm na gini, wanda aka bayyana a sama, ana iya amfani dashi ba kawai don lissafin kuɗi da sarrafa hutu ba, har ma don magance sauran matsalolin da yawa.
