Contents
Excel ba kawai don aiki tare da bayanan tabular ba. Har ila yau, shirin yana ba ku damar gina nau'i-nau'i iri-iri, daga cikinsu akwai Gantt ginshiƙi, watakila, ya cancanci kulawa ta musamman. Wannan sanannen nau'in ginshiƙi ne na gama-gari kuma sanannen nau'in ginshiƙi wanda a gani yana kama da ginshiƙi mai tsayin lokaci. Yana ba ku damar tantance bayanan tebur da kyau tare da kwanan wata da tazarar lokaci. Wataƙila kun taɓa ganin irin waɗannan zane-zane sau da yawa, saboda ana amfani da su kusan ko'ina. A cikin wannan labarin, za mu bayyana dalla-dalla da kuma mataki-mataki yadda za a gina shi.
Abun ciki: "Yadda ake gina taswirar Gantt a cikin Excel"
Gina ginshiƙi
Domin nunawa da kuma bayyana a hanya mai sauƙi yadda aka gina taswirar Gantt, za mu yi amfani da misali bayyananne. Ɗauki alamar tare da jerin kayan wasanni, inda aka yi alamar kwanakin jigilar su da tsawon lokacin bayarwa.
Kula da mahimman bayanai guda ɗaya! Rukunin da sunan kaya dole ne ya kasance ba tare da suna ba - wannan abu ne mai mahimmanci, in ba haka ba hanyar ba za ta yi aiki ba. Idan ginshiƙi yana da taken, yakamata a cire shi.
Don haka, bari mu fara gina taswirar Gantt.
- Da farko, bari mu gina zane mai sauƙi. Don yin wannan, kuna buƙatar haskaka sashin da ake so na tebur tare da siginan kwamfuta kuma danna "Saka". Anan, a cikin toshe "Histogram", zaɓi nau'in "Stacked Bar". Don dalilanmu, a tsakanin sauran abubuwa, "layin da aka haɗe na XNUMXD" kuma ya dace.
- Mun karbi zanenmu kuma za mu iya ci gaba zuwa mataki na gaba.
- Yanzu aikinmu shine cire layin shuɗi, yana mai da shi ganuwa. A sakamakon haka, kawai tube tare da tsawon lokacin bayarwa ya kamata a nuna. Danna-dama a ko'ina a kowane shafi mai shuɗi kuma danna kan "Format Data Series...".
- A cikin taga da yake buɗewa, je zuwa abin "cika", saita wannan siga azaman "Ba cika" sannan ku rufe taga saitunan.
- Kamar yadda muke iya gani, alamun bayanan akan zanen da aka samu ba su da kyau sosai (daga ƙasa zuwa sama), wanda zai iya rikitar da binciken su sosai. Amma ana iya canza wannan.
- A cikin filin tare da sunayen samfur, danna linzamin kwamfuta (maɓallin dama) kuma zaɓi abu "Format Axis ...".
- Anan muna buƙatar sashin "Axis Parameters", ta tsohuwa kawai mu shiga cikinsa nan da nan. Muna neman ma'aunin "Reverse order of Categories" kuma sanya alama a gabansa. Yanzu zaku iya rufe akwatin maganganu.
- Ba ma buƙatar almara a cikin wannan zane. Bari mu cire shi ta hanyar zaɓar shi da linzamin kwamfuta kuma danna maɓallin "Share" akan maballin.
- Kula da daya daki-daki. Idan, ka ce, kana so ka nuna lokaci kawai na shekara ta kalanda, ko wani lokaci, danna-dama akan yankin da kwanakin suke. Menu zai bayyana a cikin abin da muke sha'awar abu "Format Axis ...", danna kan shi.
- Taga mai saiti zai buɗe. Anan, a cikin sigogin axis, idan an buƙata, zaku iya saita ƙimar kwanan wata da ake buƙata (mafi ƙarancin ƙima). Bayan yin gyare-gyare, rufe akwatin maganganu.
- Jadawalin mu na Gantt ya kusan shirya, abin da ya rage shi ne a ba shi take.
- Don yin wannan, danna-hagu akan sunan, sannan zaɓi shi kuma gyara shi akan abin da muke buƙata. Hakanan, kasancewa a cikin shafin "Gida", zaku iya, alal misali, saita girman font kuma sanya shi ƙarfin hali.
- Wannan ke nan, ginshiƙin Gantt ɗinmu yana shirye gabaɗaya.
Tabbas, zaku iya ci gaba da shirya zane, saboda iyawar Excel yana ba ku damar tsara shi gwargwadon yadda kuke so ga kamannin da ake so, ta amfani da kayan aikin da ke cikin shafin “Designer”. Amma, a gaba ɗaya, yanzu yana yiwuwa a yi cikakken aiki tare da shi.
Kammalawa
A kallo na farko, da alama gina taswirar Gantt a cikin Excel babban aiki ne mai wahala wanda ke buƙatar lokaci da ƙoƙari mai yawa. Koyaya, a aikace yana nuna cewa wannan aikin yana da yuwuwa sosai kuma, ƙari, yana ɗaukar ɗan lokaci kaɗan. Hoton da muka nuna a sama misali ne kawai. Hakazalika, zaku iya gina kowane zane don magance matsalolinku.