Gantt chart mu Excel: momwe mungapangire

Excel sikuti imangogwira ntchito ndi data yama tabular. Pulogalamuyi imakupatsaninso mwayi wopanga ma chart osiyanasiyana, omwe tchati cha Gantt, mwina, chikuyenera kuyang'aniridwa mwapadera. Ichi ndi tchati chodziwika bwino komanso chodziwika bwino chomwe chimawoneka ngati tchati chokhala ndi nthawi yopingasa. Zimakuthandizani kuti musanthule bwino zomwe zili patebulo ndi masiku ndi nthawi. Mwinamwake mwawonapo zithunzi zotere nthawi zambiri, chifukwa zimagwiritsidwa ntchito pafupifupi kulikonse. M'nkhaniyi, tifotokoza mwatsatanetsatane ndi sitepe ndi sitepe mmene kumanga.

Kupanga ma chart

Pofuna kusonyeza ndi kufotokoza mwa njira yofikira momwe tchati cha Gantt chimapangidwira, tidzagwiritsa ntchito chitsanzo chomveka. Tengani chikwangwani chokhala ndi mndandanda wazinthu zamasewera, pomwe masiku omwe amatumizidwa ndi nthawi yobweretsera amalembedwa.

Samalani mfundo imodzi yofunika! Mzere wokhala ndi dzina la katundu uyenera kukhala wopanda dzina - ichi ndi chofunikira, apo ayi njirayo siigwira ntchito. Ngati ndime ili ndi mutu, iyenera kuchotsedwa.

Chifukwa chake, tiyeni tiyambe kupanga tchati cha Gantt.

1. Choyamba, tiyeni tipange chithunzi chosavuta. Kuti muchite izi, muyenera kuwunikira gawo lomwe mukufuna patebulo ndi cholozera ndikudina "Ikani". Apa, mu chipika cha "Histogram", sankhani mtundu wa "Stacked Bar". Pazolinga zathu, mwa zina, "XNUMXD mzere wokhazikika" ndiwoyeneranso.
2. Talandira chithunzi chathu ndipo titha kupita ku sitepe yotsatira.
3. Tsopano ntchito yathu ndikuchotsa mzere wabuluu, kuti ukhale wosawoneka. Zotsatira zake, mizere yokhayo yokhala ndi nthawi yobereka iyenera kuwonetsedwa. Dinani kumanja kulikonse pagawo lililonse labuluu ndikudina "Format Data Series ...".
4. Pazenera lomwe limatsegulidwa, pitani ku chinthu cha "Dzazani", ikani chizindikiro ichi ngati "Palibe kudzaza" ndikutseka zenera la zoikamo.
5. Monga tikuonera, zolemba zomwe zili pachithunzichi sizipezeka mosavuta (kuyambira pansi mpaka pamwamba), zomwe zingasokoneze kusanthula kwawo. Koma izi zikhoza kusinthidwa.
6. M'munda wokhala ndi mayina azinthu, dinani mbewa (batani lakumanja) ndikusankha chinthucho "Format Axis ...".
7. Apa tikufunika gawo la "Axis Parameters", mwachisawawa timangolowamo nthawi yomweyo. Tikuyang'ana chizindikiro "Reverse order of categories" ndikuyika chizindikiro patsogolo pake. Tsopano mutha kutseka bokosi la zokambirana.
8. Sitikufuna nthano pachithunzichi. Tiyeni tichotse mwa kusankha ndi mbewa ndi kukanikiza "Chotsani" kiyi pa kiyibodi.
9. Samalani mwatsatanetsatane. Ngati, tinene kuti, mukufuna kusonyeza nyengo yokha ya chaka cha kalendala, kapena nyengo ina, dinani kumanja pa malo amene madetiwo ali. Menyu idzawoneka yomwe tili ndi chidwi ndi chinthucho "Format Axis ...", dinani pamenepo.
10. Zenera lokhala ndi zoikamo lidzatsegulidwa. Apa, mu magawo a axis, ngati pangafunike, mutha kukhazikitsa masiku ofunikira (ocheperako komanso opambana). Mukakonza zosintha, tsekani bokosi la zokambirana.
11. Tchati chathu cha Gantt chatsala pang'ono kukonzeka, chomwe chatsala ndikuchipatsa mutu.
12. Kuti muchite izi, dinani kumanzere pa dzinalo, kenako sankhani ndikukonza zomwe tikufuna. Komanso, pokhala mu "Home" tabu, mukhoza, mwachitsanzo, kukhazikitsa kukula kwa font ndikuipanga molimba mtima.
13. Ndizo zonse, tchati chathu cha Gantt chakonzeka kwathunthu.

Zachidziwikire, mutha kupitiliza kusintha chithunzicho, chifukwa kuthekera kwa Excel kumakupatsani mwayi wosintha momwe mukufunira mawonekedwe ndi zosowa zanu, pogwiritsa ntchito zida zomwe zili pagawo la "Designer". Koma, kawirikawiri, tsopano ndi kotheka kugwira ntchito ndi izo.

Kutsiliza

Poyamba, zikuwoneka kuti kupanga tchati cha Gantt mu Excel ndi ntchito yovuta kwambiri yomwe imafuna nthawi yambiri komanso khama. Komabe, pochita izi zimachitika kuti ntchitoyi ndi yotheka, komanso, imatenga nthawi yochepa kwambiri. Chithunzi chomwe tawonetsa pamwambapa ndi chitsanzo chabe. Momwemonso, mutha kupanga chithunzi china chilichonse kuti muthetse mavuto anu.