Yadda ake ƙirƙirar ginshiƙi Gantt a cikin Excel?

Contents

Menene Gantt Chart?
Yadda ake ƙirƙirar Gantt Chart a cikin Excel 2010, 2007 da 2013
Tsarin Gantt Chart a cikin Excel

Idan aka tambaye ka sunayen abubuwa uku mafi muhimmanci na Microsoft Excel, wanne za ka ambata? Mafi mahimmanci, zanen gadon da aka shigar da bayanai akan su, da dabarun da ake amfani da su don yin lissafi, da ginshiƙai waɗanda za a iya wakilta bayanan wani yanayi daban da su ta hanyar zane.

Na tabbata cewa kowane mai amfani da Excel ya san menene ginshiƙi da yadda ake ƙirƙira shi. Duk da haka, akwai nau'in ginshiƙi wanda aka lulluɓe ga mutane da yawa - Ginshiƙi na ban mamaki. Wannan jagorar mai sauri za ta bayyana manyan fasalulluka na ginshiƙi na Gantt, gaya muku yadda ake yin taswirar Gantt mai sauƙi a cikin Excel, gaya muku inda zaku zazzage samfuran taswirar Gantt na ci gaba, da kuma yadda ake amfani da sabis na kan layi na Gudanar da Ayyukan don ƙirƙirar taswirar Gantt.

Menene Gantt Chart?

Ginshiƙi na ban mamaki mai suna Henry Gantt, injiniyan Amurka kuma mai ba da shawara kan gudanarwa wanda ya fito da zane a cikin 1910. Taswirar Gantt a cikin Excel na wakiltar ayyuka ko ayyuka a matsayin faifan zane-zane na kwance. Taswirar Gantt yana nuna rugujewar tsarin aikin (kwanakin farawa da ƙarewa, alaƙa daban-daban tsakanin ayyuka a cikin aikin) don haka yana taimakawa wajen sarrafa aiwatar da ayyuka a cikin lokaci kuma bisa ga maƙasudin da aka yi niyya.

Yadda ake ƙirƙirar Gantt Chart a cikin Excel 2010, 2007 da 2013

Abin takaici, Microsoft Excel ba ya bayar da ginanniyar samfuri na Gantt. Koyaya, zaku iya ƙirƙira da sauri da kanku ta amfani da aikin ginshiƙi da ɗan tsari.

Bi waɗannan matakan a hankali kuma ba zai ɗauki fiye da mintuna 3 don ƙirƙirar taswirar Gantt mai sauƙi ba. A cikin misalan mu, muna ƙirƙirar taswirar Gantt a cikin Excel 2010, amma ana iya yin haka a cikin Excel 2007 da 2013.

Mataki 1. Ƙirƙiri teburin aikin

Da farko, za mu shigar da bayanan aikin a cikin takardar Excel. Rubuta kowane ɗawainiya akan layi daban kuma gina tsarin rushewar aikin ta ƙididdigewa ranar farawa (Kwanan farawa), digiri (karshen kwanan wata) da duration (Lokaci), wato adadin kwanakin da ake ɗauka don kammala aikin.

tip: Ana buƙatar ginshiƙai kawai don ƙirƙirar ginshiƙi na Gantt Fara kwanan wata и duration. Koyaya, idan kuma kun ƙirƙiri shafi Ƙarshen kwanan wata, sannan zaku iya lissafin tsawon lokacin aikin ta amfani da tsari mai sauƙi, kamar yadda aka gani a cikin adadi na ƙasa:

Mataki 2. Gina taswirar mashaya na Excel na yau da kullun bisa tushen bayanan shafi na "Start date".

Fara gina taswirar Gantt a cikin Excel ta ƙirƙirar mai sauƙi ginshiƙi marufi:

Hana kewayo Fara Dates tare da taken shafi, a cikin misalinmu shine B1: b11. Wajibi ne don zaɓar sel kawai tare da bayanai, kuma ba duka shafi na takardar ba.
A kan Babba shafin Saka (Saka) ƙarƙashin Charts, danna Saka ginshiƙi mashaya (Bar).
A cikin menu wanda ya buɗe, a cikin rukuni Doka (2-D Bar) danna Hukunci Stacked (Stacked Bar).

A sakamakon haka, ginshiƙi mai zuwa ya kamata ya bayyana akan takardar:

lura: Wasu daga cikin sauran umarnin don ƙirƙirar taswirar Gantt suna ba da shawarar cewa ka fara ƙirƙirar taswirar mashaya mara komai sannan ka cika shi da bayanai, kamar yadda za mu yi a mataki na gaba. Amma ina tsammanin hanyar da aka nuna ita ce mafi kyau saboda Microsoft Excel za ta ƙara jerin bayanai ta atomatik kuma ta wannan hanyar za mu adana ɗan lokaci.

Mataki 3: Ƙara Bayanan Tsawon Lokaci zuwa Chart

Na gaba, muna buƙatar ƙara ƙarin jerin bayanai guda ɗaya zuwa ginshiƙi na Gantt na gaba.

Danna-dama a ko'ina a cikin zane kuma a cikin mahallin menu danna Zaɓi bayanai (Zaɓi Bayanai). Akwatin maganganu zai buɗe Zaɓi tushen bayanai (Zaɓi Tushen Bayanai). Kamar yadda kake gani a cikin hoton da ke ƙasa, bayanan shafi fara Date an riga an ƙara zuwa filin Abubuwan almara ( layuka) (Tsarin labari (Series)) Yanzu kuna buƙatar ƙara bayanan shafi anan duration.
latsa Add (Ƙara) don zaɓar ƙarin bayanai (Lokaci) don nunawa akan taswirar Gantt.
A cikin taga bude Canjin layi (Edit series) yi haka:
- a cikin Sunan layi (Series name) shigar da “Lokaci” ko kowane suna da kuke so. Ko kuma za ku iya sanya siginan kwamfuta a cikin wannan filin sannan ku danna kan taken ginshiƙi mai dacewa a cikin tebur - za a ƙara taken da aka danna a matsayin jerin sunayen Gantt ginshiƙi.
- Danna gunkin zaɓin kewayo kusa da filin Da dabi'u (Jerin dabi'u).
Tagan maganganu Canjin layi (Edit jerin) zai ragu. Hana bayanai a cikin shafi durationta danna kan tantanin halitta na farko (a cikin yanayinmu shine D2) da kuma jan ƙasa zuwa tantanin bayanai na ƙarshe (D11). Tabbatar cewa ba za a yi kuskure ba da gangan ko wani tantanin halitta mara komai.
Latsa gunkin zaɓin kewayon sake. Tagan maganganu Canjin layi (Edit jerin) za a sake fadada kuma filayen za su bayyana Sunan layi (Series name) и Da dabi'u (Jerin dabi'u). Danna Ok.
Zamu sake komawa taga Zaɓi tushen bayanai (Zaɓi Tushen Bayanai). Yanzu a cikin filin Abubuwan almara ( layuka) (Legend Entries (Series) muna ganin jerin abubuwa fara Date da lamba duration. Kawai danna OK, kuma za a ƙara bayanan zuwa ginshiƙi.

Jadawalin ya kamata yayi kama da haka:

Mataki 4: Ƙara Bayanin Aiki zuwa Gantt Chart

Yanzu kuna buƙatar nuna jerin ayyuka a gefen hagu na zane maimakon lambobi.

Danna-dama a ko'ina a cikin yankin da aka tsara (yankin da ratsan shuɗi da orange) kuma a cikin menu da ya bayyana, danna. Zaɓi bayanai (Zaɓi Bayanai) don sake bayyana akwatin maganganu Zaɓi tushen bayanai (Zaɓi Tushen Bayanai).
A gefen hagu na akwatin maganganu, zaɓi fara Date Kuma danna Change (Edit) a cikin dama yankin na taga mai take Alamun axis na kwance (kasuwa) (A kwance (Kashi) Alamomin Axis).
Za a buɗe ƙaramin akwatin maganganu Alamun axis (Tambarin axis). Yanzu kuna buƙatar zaɓar ɗawainiya kamar yadda a mataki na baya muka zaɓi bayanai kan tsawon ayyuka (Shafin Tsawon Lokaci) - danna gunkin zaɓin kewayon, sannan danna aikin farko a cikin tebur kuma ja zaɓin tare da linzamin kwamfuta. har zuwa aiki na ƙarshe. Ka tuna cewa ba za a haskaka taken shafi ba. Da zarar kun yi haka, sake danna gunkin zaɓin kewayo don kawo akwatin maganganu.
Matsa sau biyu OKdon rufe duk akwatunan maganganu.
Share almara taswira - danna-dama akan shi kuma a cikin mahallin menu danna cire (Share).

A wannan gaba, ginshiƙi Gantt yakamata ya sami kwatancen aiki a gefen hagu kuma yayi kama da wani abu kamar haka:

Mataki na 5: Canza Taswirar Bar zuwa Tsarin Gantt

A wannan mataki, ginshiƙi namu har yanzu ginshiƙi ne. Don sanya shi yayi kama da ginshiƙi na Gantt, kuna buƙatar tsara shi daidai. Ayyukanmu shine cire shuɗin layukan don kawai sassan orange na jadawali, waɗanda ke wakiltar ayyukan aikin, su kasance a bayyane. A zahiri, ba za mu cire layukan shuɗi ba, za mu sanya su a bayyane kuma don haka ba a iya gani.

Danna kan kowane layin shuɗi akan taswirar Gantt, kuma za a zaɓi dukkan su. Danna-dama akan zaɓi kuma a cikin mahallin menu danna Tsarin bayanai (Format Data Series).
A cikin akwatin maganganu da ya bayyana, yi abubuwa masu zuwa:
- A cikin sashe Cika (Cika) zaɓi Babu cika (Ba Cika ba).
- A cikin sashe Border (Launi Border) zaɓi babu layi (Ba Layi).

lura: Kar a rufe wannan akwatin maganganu, za ku sake buƙatarsa a mataki na gaba.

Ayyukan da ke kan ginshiƙi na Gantt da muka gina a cikin Excel suna cikin jujjuyawar tsari. Za mu gyara hakan nan da wani lokaci. Danna kan jerin ayyuka a gefen hagu na ginshiƙi Gantt don haskaka axis na rukuni. Akwatin maganganu zai buɗe Tsarin Axis (Format Axis). A cikin babi sigogi na axis (Zaɓuɓɓukan Axis) duba akwatin Juya tsari na rukunoni (Kategorien a juzu'i), sannan rufe taga don adana canje-canjen ku. Sakamakon canje-canjen da muka yi yanzu:
- Ayyukan da ke kan ginshiƙi Gantt suna cikin tsari daidai.
- Kwanakin da ke kan axis a kwance sun ƙaura daga ƙasa zuwa saman ginshiƙi.

Taswirar ta zama kama da taswirar Gantt na yau da kullun, daidai? Misali, ginshiƙi na Gantt yanzu yayi kama da wannan:

Mataki 6. Daidaita Tsarin Gantt Chart a cikin Excel

Taswirar Gantt ya riga ya fara yin tsari, amma kuna iya ƙara wasu ƙayyadaddun abubuwan gamawa don sa ya zama mai salo sosai.

1. Cire sarari mara komai a gefen hagu na taswirar Gantt

Lokacin gina taswirar Gantt, mun saka sanduna shuɗi a farkon ginshiƙi don nuna ranar farawa. Yanzu za a iya cire ɓoyayyen da ya rage a wurinsu kuma ana iya matsar da sassan aikin zuwa hagu, kusa da axis na tsaye.

Danna dama akan ƙimar shafi na farko fara Date a cikin tebur tare da bayanan tushe, a cikin mahallin menu zaɓi Tsarin salula > Number > Janar (Format Sel> Lamba> Gaba ɗaya). Ka haddace lambar da kuke gani a filin sample (Sample) shine wakilcin lambobi na kwanan wata. A wurina wannan lambar 41730. Kamar yadda kuka sani, Excel yana adana kwanakin a matsayin lambobi daidai da adadin kwanakin ranar 1 ga Janairu, 1900 kafin wannan kwanan wata (inda Janairu 1, 1900 = 1). Ba kwa buƙatar yin wasu canje-canje a nan, danna kawai sokewa (Soke).
A kan taswirar Gantt, danna kowane kwanan wata da ke sama da ginshiƙi. Dannawa ɗaya zai zaɓi duk kwanakin, bayan wannan danna-dama akan su kuma a cikin mahallin menu danna Tsarin Axis (Format Axis).
A kan menu Siga axis (Zaɓuɓɓukan Axis) canza zaɓi mafi qarancin (Mafi ƙarancin) akan Number (Kafaffen) kuma shigar da lambar da kuka tuna a mataki na baya.

2. Daidaita adadin kwanakin akan axis na Gantt ginshiƙi

Anan, a cikin akwatin maganganu Tsarin Axis (Format Axis) wanda aka buɗe a mataki na baya, canza sigogi Manyan sassa (Major united) и Rarraba tsaka-tsaki (Ƙananan raka'a) na Number (Kafaffen) kuma shigar da ƙimar da ake so don tazara akan axis. Yawancin lokaci, guntuwar lokutan ayyukan da ke cikin aikin, ƙaramin matakin rabo ana buƙatar akan kullin lokaci. Misali, idan kuna son nuna kowane kwanan wata na biyu, sannan shigar 2 don siga Manyan sassa (Babban naúrar). Wane saitin da na yi - kuna iya gani a hoton da ke ƙasa:

tip: Yi wasa tare da saitunan har sai kun sami sakamakon da ake so. Kada ku ji tsoron yin wani abu ba daidai ba, koyaushe kuna iya komawa zuwa saitunan tsoho ta hanyar saita zaɓuɓɓuka zuwa Ta atomatik (Auto) a cikin Excel 2010 da 2007 ko ta dannawa Sake saita (Sake saita) a cikin Excel 2013.

3. Cire ƙarin sarari mara komai tsakanin ratsi

Shirya sandunan ɗawainiya akan ginshiƙi mafi ƙanƙanta, kuma ginshiƙi na Gantt zai fi kyau.

Zaɓi sandunan lemu na jadawali ta danna ɗaya daga cikinsu tare da maɓallin linzamin kwamfuta na hagu, sannan danna dama akan shi kuma a cikin menu da ya bayyana, danna maɓallin. Tsarin bayanai (Format Data Series).
A cikin akwatin maganganu Tsarin bayanai (Format Data Series) saita siga zuwa layuka masu haɗaka (Series Zoba) ƙimar 100% (slider ya matsa zuwa dama), kuma ga siga Tsare gefe (Nisa Nisa) ƙimar 0% ko kusan 0% (mai zamewa gaba ɗaya ko kusan duk hanyar zuwa hagu).

Kuma ga sakamakon ƙoƙarinmu - ginshiƙi mai sauƙi amma daidaitaccen Gantt a cikin Excel:

Ka tuna cewa ginshiƙi na Excel da aka ƙirƙira ta wannan hanyar yana kusa da ainihin Gantt ginshiƙi, yayin da yake riƙe duk dacewa na sigogin Excel:

Taswirar Gantt a cikin Excel zai yi girma lokacin da aka ƙara ko cire ayyuka.
Canja kwanan watan farawa na aikin (kwanakin farawa) ko tsawon sa (Lokacin), kuma jadawalin zai nuna canje-canjen da aka yi ta atomatik.
Za a iya adana ginshiƙi na Gantt da aka ƙirƙira a cikin Excel azaman hoto ko canza shi zuwa tsarin HTML kuma a buga shi akan Intanet.

GASKIYA:

Keɓance bayyanar ginshiƙi na Gantt ta hanyar canza zaɓuɓɓukan cikewa, iyakoki, inuwa, har ma da amfani da tasirin 3D. Duk waɗannan zaɓuɓɓuka suna samuwa a cikin akwatin maganganu. Tsarin bayanai (Format Data Series). Don kiran wannan taga, danna-dama akan ma'aunin ginshiƙi a cikin yanki mai ƙira kuma a cikin mahallin menu danna Tsarin bayanai (Format Data Series).
Idan tsarin ƙirar da aka ƙirƙira yana jin daɗin ido, to ana iya ajiye irin wannan taswirar Gantt a cikin Excel azaman samfuri kuma ana amfani dashi a nan gaba. Don yin wannan, danna kan zane, buɗe shafin Constructor (Design) kuma latsa Ajiye azaman samfuri (Ajiye azaman Samfura).

Zazzage samfurin Gantt ginshiƙi

Tsarin Gantt Chart a cikin Excel

Kamar yadda kuke gani, gina taswirar Gantt mai sauƙi a cikin Excel ba shi da wahala ko kaɗan. Amma menene idan ana buƙatar ƙarin hadaddun ginshiƙi Gantt, a cikin wane shading ɗin aiki ya dogara da adadin ƙarshensa, kuma ana nuna matakan aikin ta hanyar layi na tsaye? Tabbas, idan kun kasance ɗaya daga cikin waɗannan halittu masu ban mamaki da ban mamaki waɗanda muke kiran Excel Guru cikin girmamawa, to zaku iya ƙoƙarin yin irin wannan zane da kanku.

Koyaya, zai yi sauri da sauƙi don amfani da samfuran Gantt da aka riga aka yi a cikin Excel. A ƙasa ɗan taƙaitaccen bayani ne na samfuran tsarin sarrafa ayyukan Gantt don nau'ikan Microsoft Excel daban-daban.

Microsoft Excel 2013 Gantt Chart Samfura

Ana kiran wannan samfurin Gantt chart don Excel Mai tsara Shirin (Gantt Project Planner). An tsara shi don bin diddigin ci gaban aikin akan ma'auni daban-daban kamar Shirin farawa (Shirin Fara) и ainihin farawa (Farkon Gaskiya), Tsawon lokacin da aka tsara (Tsarin Tsara) и Tsawon Gaskiya (Ainihin Duration), haka kuma Kashi dari cikakke (Kashi Kashi cikakke).

A cikin Excel 2013, ana samun wannan samfuri akan shafin fayil (Fayil) a cikin taga Create (Sabo). Idan babu samfuri a wannan sashe, zaku iya zazzage shi daga gidan yanar gizon Microsoft. Ba a buƙatar ƙarin ilimi don amfani da wannan samfuri - danna shi kuma fara.

Jadawalin Samfuran Kan layi Ganta

Smartsheet.com yana ba da Gantt Chart Builder na kan layi. Wannan samfurin ginshiƙi na Gantt yana da sauƙi kuma a shirye don amfani da shi kamar na baya. Sabis ɗin yana ba da gwaji kyauta na kwanaki 30, don haka jin daɗin yin rajista tare da asusun Google kuma fara ƙirƙirar taswirar Gantt ɗin ku na farko nan da nan.

Tsarin yana da sauƙi: a cikin tebur a gefen hagu, shigar da cikakkun bayanai na aikin ku, kuma yayin da tebur ya cika, an ƙirƙiri taswirar Gantt a hannun dama.

Samfuran Gantt Chart don Excel, Google Sheets da OpenOffice Calc

A vertex42.com zaku iya samun samfuran taswirar Gantt kyauta don Excel 2003, 2007, 2010 da 2013 waɗanda kuma zasuyi aiki tare da OpenOffice Calc da Google Sheets. Kuna iya aiki tare da waɗannan samfuran kamar yadda kuke yi tare da kowane maƙunsar rubutu na Excel na yau da kullun. Kawai shigar da kwanan wata da lokacin farawa don kowane ɗawainiya kuma shigar da % cikakke a cikin ginshiƙi % cikakke. Don canza kewayon kwanan wata da aka nuna a yankin Gantt ginshiƙi, matsar da darjewa akan sandar gungura.

Kuma a ƙarshe, wani samfurin Gantt ginshiƙi a cikin Excel don la'akari da ku.

Manajan Ayyukan Gantt Chart Samfura

Ana ba da wani samfuri na taswirar Gantt kyauta a professionalexcel.com kuma ana kiranta "Project Manager Gantt Chart". A cikin wannan samfuri, yana yiwuwa a zaɓi ra'ayi (kullum ko daidaitaccen mako-mako), dangane da tsawon ayyukan da aka sa ido.

Ina fatan cewa aƙalla ɗaya daga cikin samfuran ginshiƙi na Gantt zai dace da bukatunku. Idan ba haka ba, zaku iya samun nau'ikan samfuran Gantt ginshiƙi daban-daban akan Intanet.

Yanzu da kuka san manyan fasalulluka na ginshiƙi na Gantt, zaku iya ci gaba da koyo shi kuma ku koyi yadda ake ƙirƙirar naku hadadden ginshiƙi na Gantt a cikin Excel don mamakin maigidan ku da duk abokan aikin ku 🙂