Momwe mungapangire tchati cha Gantt mu Excel?

Zamkatimu

Tchati cha Gantt ndi chiyani?
Momwe Mungapangire Chati cha Gantt mu Excel 2010, 2007 ndi 2013
Chithunzi cha Gantt mu Excel

Ngati mutafunsidwa kutchula zigawo zitatu zofunika kwambiri za Microsoft Excel, mungatchule ziti? Mwachiwonekere, mapepala omwe deta imalowetsedwerapo, mafomu omwe amagwiritsidwa ntchito powerengera, ndi ma chart omwe deta yamtundu wina ingawonetsedwe bwino.

Ndili wotsimikiza kuti wogwiritsa ntchito aliyense wa Excel amadziwa tchati ndi momwe angapangire. Komabe, pali mtundu wa tchati womwe uli wobisika kwa ambiri - Tchati cha Gantt. Kalozera wachanguyu afotokoza mbali zazikulu za tchati cha Gantt, ndikuuzeni momwe mungapangire tchati chosavuta cha Gantt mu Excel, ndikuuzeni komwe mungatsitse ma template apamwamba a Gantt chart, ndi momwe mungagwiritsire ntchito ntchito yapaintaneti ya Project Management kuti mupange ma chart a Gantt.

Tchati cha Gantt ndi chiyani?

Tchati cha Gantt adatchedwa Henry Gantt, katswiri wa injiniya wa ku America ndi woyang'anira yemwe anabwera ndi chithunzichi mu 1910. Tchati ya Gantt mu Excel imayimira mapulojekiti kapena ntchito monga kutsatizana kwa ma chart a bar opingasa. Tchati cha Gantt chimasonyeza dongosolo losweka la pulojekiti (masiku oyambira ndi omaliza, maubwenzi osiyanasiyana pakati pa ntchito mkati mwa polojekiti) ndipo motero zimathandiza kulamulira kachitidwe ka ntchito panthawi yake komanso molingana ndi zizindikiro zomwe akufuna.

Momwe Mungapangire Chati cha Gantt mu Excel 2010, 2007 ndi 2013

Tsoka ilo, Microsoft Excel sipereka template yomangidwa mu Gantt chart. Komabe, mutha kudzipanga nokha mwachangu pogwiritsa ntchito tchati cha bar ndi mawonekedwe pang'ono.

Tsatirani izi mosamala ndipo sizitenga mphindi zosapitirira 3 kuti mupange tchati chosavuta cha Gantt. M'zitsanzo zathu, tikupanga tchati cha Gantt mu Excel 2010, koma zomwezo zitha kuchitika mu Excel 2007 ndi 2013.

Gawo 1. Pangani tebulo la polojekiti

Choyamba, tidzalowetsa deta ya polojekiti mu pepala la Excel. Lembani ntchito iliyonse pamzere wosiyana ndi kupanga ndondomeko yowonongera polojekiti pofotokoza tsiku loyambira (Tsiku loyambira), kumaliza maphunziro (tsiku lomaliza) ndi nthawi (Kutenga nthawi), ndiko kuti, kuchuluka kwa masiku omwe amatenga kuti ntchitoyo ithe.

Tip: Mizati yokha ndiyo yomwe ikufunika kuti mupange tchati cha Gantt Tsiku loyambira и Kutalika. Komabe, ngati mupanganso gawo Tsiku lomaliza, ndiye mutha kuwerengera nthawi yantchitoyo pogwiritsa ntchito njira yosavuta, monga momwe tawonera pachithunzi pansipa:

Khwerero 2. Pangani tchati chokhazikika cha Excel kutengera "deti loyambira" nkhokwe

Yambani kupanga tchati cha Gantt mu Excel popanga chosavuta tchati cha bar:

Onetsani mtundu Yambani Nthawi pamodzi ndi mutu wa mzati, mu chitsanzo chathu ndi B1:b11. Ndikofunikira kusankha ma cell okha omwe ali ndi data, osati gawo lonse la pepala.
Pa Advanced tabu Ikani (Ikani) pansi pa Ma chart, dinani Ikani tchati cha bar (Bara).
Mu menyu omwe amatsegula, mu gulu Wolipidwa (2-D Bar) dinani Ruled Stacked (Zosanjikiza Bar).

Chifukwa chake, tchati chotsatirachi chiyenera kuwonekera papepala:

Zindikirani: Malangizo ena opangira ma chart a Gantt akuwonetsa kuti muyambe kupanga tchati chopanda kanthu ndikudzaza ndi deta, monga momwe tidzachitire mu sitepe yotsatira. Koma ndikuganiza kuti njira yomwe ikuwonetsedwa ndiyabwinoko chifukwa Microsoft Excel idzangowonjezera mzere umodzi wa data ndipo mwanjira iyi tidzasunga nthawi.

Khwerero 3: Onjezani Zanthawi Yanthawi Pachati

Kenako, tifunika kuwonjezera mndandanda wina wa data ku tchati chathu chamtsogolo cha Gantt.

Dinani kumanja kulikonse pachithunzichi ndikudina menyu yankhaniyo Sankhani deta (Sankhani Data).Bokosi la zokambirana lidzatsegulidwa Kusankha gwero la data (Sankhani Gwero la Data). Monga mukuwonera pachithunzichi pansipa, data yazazambiri Tsiku loyambira zawonjezeredwa kale kumunda Zinthu za nthano (mizere) (Zolemba za Nthano (Zotsatizana). Tsopano mukufunika kuwonjezera zomwe zili pamndandanda apa Kutalika.
atolankhani kuwonjezera (Onjezani) kuti musankhe zina zowonjezera (Kutalika) kuti ziwonetsedwe pa tchati cha Gantt.
Pa zenera lotseguka Kusintha kwa mizere (Sinthani mndandanda) chitani izi:
- Mu Dzina la mzere (Dzina la mndandanda) lowetsani "Nthawi Yanthawi" kapena dzina lina lililonse lomwe mukufuna. Kapena mutha kuyika cholozera m'munda uno ndikudina mutu wagawo lofananira patebulo - mutu womwe wadindidwa udzawonjezedwa ngati dzina la mndandanda wa tchati cha Gantt.
- Dinani chizindikiro cha kusankha siyana pafupi ndi gawolo Makhalidwe (Makhalidwe a mndandanda).
Zenera la dialog Kusintha kwa mizere (Sinthani mndandanda) ichepa. Onetsani zambiri muzambiri Kutalikapodina pa cell yoyamba (kwa ife ndi D2) ndikukokera ku cell yomaliza ya data (D11). Onetsetsani kuti simunasankhe mwangozi mutu kapena foni yopanda kanthu.
Dinaninso chizindikiro chosankha siyana. Zenera la dialog Kusintha kwa mizere (Sinthani mndandanda) adzakulitsidwanso ndipo magawo adzawonekera Dzina la mzere (dzina la mndandanda) ndi Makhalidwe (Makhalidwe a mndandanda). Dinani Chabwino.
Tibwereranso pawindo Kusankha gwero la data (Sankhani Gwero la Data). Tsopano m'munda Zinthu za nthano (mizere) (Nthano Zolemba (Series) tikuwona mndandanda Tsiku loyambira ndi angapo Kutalika. Ingodinani OK, ndipo deta idzawonjezedwa ku tchati.

Chithunzicho chiyenera kuoneka motere:

Khwerero 4: Onjezani Mafotokozedwe a Ntchito ku Tchati cha Gantt

Tsopano muyenera kusonyeza mndandanda wa ntchito kumanzere kwa chithunzicho m'malo mwa manambala.

Dinani kumanja kulikonse komwe mukukonzekera (malo okhala ndi mikwingwirima yabuluu ndi lalanje) ndi menyu omwe akuwoneka, dinani Sankhani deta (Sankhani Deta) kuti mubwerenso bokosi la zokambirana Kusankha gwero la data (Sankhani Gwero la Data).
Kumanzere kwa bokosi la zokambirana, sankhani Tsiku loyambira Ndipo dinani Change (Sinthani) kumanja kwa zenera lotchedwa Zolemba zopingasa (magulu) (Zopingasa (Gawo) Zolemba za Axis).
Bokosi laling'ono la zokambirana lidzatsegulidwa Zolemba za axis (Zolemba za axis). Tsopano muyenera kusankha ntchito mofanana ndi momwe tinachitira m'mbuyomu tidasankha deta pa nthawi ya ntchito (Mzere wa Durations) - dinani chizindikiro cha kusankha mitundu, kenako dinani ntchito yoyamba patebulo ndikukoka kusankha ndi mbewa. mpaka ku ntchito yomaliza. Kumbukirani kuti mutu wagawo suyenera kuunikira. Mukamaliza kuchita izi, dinani chizindikiro cha kusankha kwamitundu kachiwiri kuti mubweretse bokosi la zokambirana.
Dinani kawiri OKkuti mutseke mabokosi onse a dialog.
Chotsani nthano ya tchati - dinani kumanja kwake ndikudina menyu yankhaniyo Chotsani (Chotsani).

Pakadali pano, tchati cha Gantt chiyenera kukhala ndi mafotokozedwe a ntchito kumanzere ndikuwoneka motere:

Khwerero 5: Kusintha Tchati cha Bar kukhala Tchati cha Gantt

Pakadali pano, tchati chathu chikadali tchati chomangika. Kuti iwoneke ngati tchati cha Gantt, muyenera kuyipanga moyenera. Ntchito yathu ndikuchotsa mizere ya buluu kuti zigawo za lalanje za ma grafu, zomwe zimayimira ntchito za polojekitiyi, zikhalebe zowonekera. Mwaukadaulo, sitichotsa mizere ya buluu, tingowapangitsa kuti awonekere komanso osawoneka.

Dinani pamzere uliwonse wabuluu pa tchati cha Gantt, ndipo onsewo adzasankhidwa. Dinani kumanja pazosankha ndikudina pazosankha Mawonekedwe a mndandanda wa data (Format Data Series).
M'bokosi la dialog lomwe likuwoneka, chitani izi:
- Mu gawo Lembani (Dzazani) sankhani Palibe kudzaza (Palibe Kudzaza).
- Mu gawo Border (Mtundu wa Border) sankhani palibe mizere (Palibe Line).

Zindikirani: Osatseka bokosi la zokambirana, mudzafunikanso mu sitepe yotsatira.

Ntchito zomwe zili pa tchati cha Gantt zomwe tidapanga mu Excel zili motsatana. Tikonza izo mu kamphindi. Dinani pamndandanda wa ntchito kumanzere kwa tchati cha Gantt kuti muwonetse gulu la axis. Bokosi la zokambirana lidzatsegulidwa Mtundu wa Axis (Fomati axis). Mu mutu Magawo a axis (Zosankha za Axis) fufuzani bokosi Sinthani dongosolo la magulu (Magawo mobwerera m'mbuyo), kenako tsekani zenera kuti musunge zosintha zanu. Chifukwa cha zosintha zomwe tangopanga kumene:
- Ntchito zomwe zili pa tchati cha Gantt zili mu dongosolo lolondola.
- Madeti omwe ali pamzere wopingasa asuntha kuchokera pansi kupita pamwamba pa tchati.

Tchaticho chimakhala chofanana ndi tchati chokhazikika cha Gantt, sichoncho? Mwachitsanzo, tchati changa cha Gantt tsopano chikuwoneka motere:

Gawo 6. Kusintha Mapangidwe a Gantt Chart mu Excel

Tchati cha Gantt chayamba kale, koma mutha kuwonjezera zina zomaliza kuti zikhale zokongola.

1. Chotsani malo opanda kanthu kumanzere kwa tchati cha Gantt

Popanga tchati cha Gantt, tidayika mipiringidzo yabuluu kumayambiriro kwa tchati kuti tiwonetse tsiku loyambira. Tsopano chopanda chomwe chatsalira m'malo mwawo chikhoza kuchotsedwa ndipo zingwe zogwirira ntchito zitha kusunthidwa kumanzere, kufupi ndi mzere wowongoka.

Dinani kumanja pamtengo woyamba Tsiku loyambira patebulo lomwe lili ndi deta yochokera, mumenyu yankhaniyo sankhani Mawonekedwe a cell > Number > General (Maselo Amtundu> Nambala> Zambiri). Lowezani nambala yomwe mukuwona m'munda Zitsanzo (Chitsanzo) ndi nambala yoyimira tsikulo. Kwa ine nambala iyi 41730. Monga mukudziwa, Excel imasunga masiku ngati manambala ofanana ndi masiku ya January 1, 1900 tsikuli lisanafike (komwe Januwale 1, 1900 = 1). Simufunikanso kusintha apa, ingodinani kufuta (Kuletsa).
Pa tchati cha Gantt, dinani tsiku lililonse lomwe lili pamwamba pa tchati. Kudina kumodzi kudzasankha masiku onse, pambuyo pake dinani pomwepa ndikudina menyu yankhaniyo Mtundu wa Axis (Fomati axis).
Pa menyu magawo mzere (Zosankha za Axis) sinthani kusankha osachepera (Zochepa) pa Number (Zokhazikika) ndikulowetsa nambala yomwe mwakumbukira mu gawo lapitalo.

2. Sinthani chiwerengero cha masiku pa tchati cha Gantt

Apa, mu bokosi la zokambirana Mtundu wa Axis (Format Axis) yomwe idatsegulidwa mu gawo lapitalo, sinthani magawo Magawano aakulu (Major united) ndi Magawano apakatikati (Minor unit) ya Number (Zokhazikika) ndikulowetsa zomwe mukufuna pamipata pa axis. Nthawi zambiri, kufupikitsa kwa nthawi ya ntchito mu polojekitiyi, gawo laling'ono logawikana limafunikira pa axis ya nthawi. Mwachitsanzo, ngati mukufuna kusonyeza tsiku lililonse lachiwiri, ndiye kulowa 2 kwa parameter Magawano aakulu (Chigawo chachikulu). Zomwe ndidapanga - mutha kuziwona pachithunzichi pansipa:

Tip: Sewerani mozungulira ndi zoikamo mpaka mutapeza zotsatira zomwe mukufuna. Osawopa kuchita cholakwika, mutha kubwereranso ku zosintha zosasinthika pokhazikitsa zosankha Mwadzidzidzi (Auto) mu Excel 2010 ndi 2007 kapena podina Bwezerani (Bwezerani) mu Excel 2013.

3. Chotsani malo opanda kanthu pakati pa mikwingwirima

Konzani mipiringidzo pa tchati molumikizana bwino, ndipo tchati cha Gantt chidzawoneka bwinoko.

Sankhani mipiringidzo ya lalanje ya ma graph podina imodzi mwazo ndi batani lakumanzere la mbewa, kenako dinani pomwepa ndipo pamenyu yomwe ikuwonekera, dinani. Mawonekedwe a mndandanda wa data (Format Data Series).
Mu dialog box Mawonekedwe a mndandanda wa data (Format Data Series) khazikitsani parameter kuti mizere yodutsana (Series Overlap) mtengo 100% (slider idasuntha kupita kumanja), ndi parameter Mbali chilolezo (Gap Width) mtengo 0% kapena pafupifupi 0% (slider njira yonse kapena pafupifupi kumanzere).

Ndipo nazi zotsatira za zoyesayesa zathu - tchati chosavuta koma cholondola cha Gantt mu Excel:

Kumbukirani kuti tchati cha Excel chomwe chidapangidwa motere chili pafupi kwambiri ndi tchati chenicheni cha Gantt, ndikusunga ma chart onse a Excel:

Tchati cha Gantt mu Excel chidzasintha kukula ntchito zikawonjezeredwa kapena kuchotsedwa.
Sinthani tsiku loyambira ntchitoyo (Tsiku loyambira) kapena nthawi yake (Nthawi Yanthawi), ndipo ndandanda imangowonetsa zosintha zomwe zachitika.
Tchati ya Gantt yopangidwa mu Excel imatha kusungidwa ngati chithunzi kapena kusinthidwa kukhala mtundu wa HTML ndikufalitsidwa pa intaneti.

PANGANO:

Sinthani mawonekedwe a tchati chanu cha Gantt posintha njira zodzaza, malire, mithunzi, komanso kugwiritsa ntchito zotsatira za 3D. Zosankha zonsezi zilipo mu bokosi la zokambirana. Mawonekedwe a mndandanda wa data (Format Data Series). Kuti muyimbe zenerali, dinani kumanja pa tchati cha tchati m'gawo lokonzera ma chart ndikudina menyu yankhaniyo Mawonekedwe a mndandanda wa data (Format Data Series).
Ngati kalembedwe kapangidwe kameneka kakukondweretsa maso, ndiye kuti tchati cha Gantt choterechi chikhoza kupulumutsidwa ku Excel monga template ndikugwiritsidwa ntchito m'tsogolomu. Kuti muchite izi, dinani pazithunzi, tsegulani tabu Constructor (Design) ndikusindikiza Sungani ngati template (Sungani monga template).

Tsitsani chitsanzo cha tchati cha Gantt

Chithunzi cha Gantt mu Excel

Monga mukuwonera, kupanga tchati chosavuta cha Gantt mu Excel sikovuta konse. Koma bwanji ngati tchati cha Gantt chovuta kwambiri chikufunika, momwe shading ntchito imadalira kuchuluka kwa kutsirizidwa kwake, ndipo zochitika zazikuluzikulu zimasonyezedwa ndi mizere yowongoka? Zachidziwikire, ngati ndinu m'modzi mwa zolengedwa zosowa komanso zachinsinsi zomwe timazitcha mwaulemu Excel Guru, ndiye kuti mutha kuyesa kupanga chithunzichi nokha.

Komabe, zidzakhala zachangu komanso zosavuta kugwiritsa ntchito ma template a Gantt opangidwa kale mu Excel. Pansipa pali chidule cha kasamalidwe ka ma projekiti angapo a Gantt chart amitundu yosiyanasiyana ya Microsoft Excel.

Microsoft Excel 2013 Gantt Chart Template

template iyi ya Gantt chart ya Excel imatchedwa Wopanga Mapulani (Gantt Project Planner). Zapangidwa kuti zizitsata momwe polojekiti ikuyendera motsutsana ndi ma metric osiyanasiyana monga Chiyambi chokonzekera (Plan Start) ndi chiyambi chenicheni (Zoyambira Zenizeni), Nthawi yokonzekera (Pulani Nthawi) ndi Nthawi Yeniyeni (Nthawi Yeniyeni), komanso Peresenti yathunthu (Percent Full).

Mu Excel 2013, template iyi ikupezeka pa tabu file (Fayilo) pawindo Pangani (Chatsopano). Ngati palibe template mu gawoli, mutha kuyitsitsa patsamba la Microsoft. Palibe chidziwitso chowonjezera chomwe chimafunika kugwiritsa ntchito template iyi - dinani ndikuyamba.

Tchati Chachiwonetsero Chapaintaneti Ganta

Smartsheet.com imapereka njira yolumikizirana pa intaneti ya Gantt Chart Builder. Templeti iyi ya Gantt chart ndiyosavuta komanso yokonzeka kugwiritsidwa ntchito ngati yam'mbuyomu. Ntchitoyi imapereka kuyesa kwaulere kwa masiku 30, kotero khalani omasuka kulowa ndi akaunti yanu ya Google ndikuyamba kupanga tchati chanu choyamba cha Gantt nthawi yomweyo.

Njirayi ndi yosavuta: patebulo kumanzere, lowetsani zambiri za polojekiti yanu, ndipo pamene tebulo likudzaza, tchati cha Gantt chimapangidwa kumanja.

Zithunzi za Gantt Chart za Excel, Google Sheets ndi OpenOffice Calc

Pa vertex42.com mutha kupeza ma template aulere a Gantt a Excel 2003, 2007, 2010 ndi 2013 omwe angagwirenso ntchito ndi OpenOffice Calc ndi Google Sheets. Mutha kugwira ntchito ndi ma tempuletiwa monga momwe mungachitire ndi spreadsheet iliyonse ya Excel. Ingolowetsani tsiku loyambira ndi nthawi ya ntchito iliyonse ndikulowetsa % kumaliza mgawo % yomaliza. Kuti musinthe mtundu wa deti womwe wawonetsedwa m'dera la tchati cha Gantt, sunthani slider pa bar scroll.

Ndipo pomaliza, template ina ya Gantt chart mu Excel kuti muganizire.

Project Manager Gantt Chart template

template ina yaulere ya Gantt chart imaperekedwa ku professionalexcel.com ndipo imatchedwa "Project Manager Gantt Chart". Mu template iyi, ndizotheka kusankha mawonedwe (tsiku ndi tsiku kapena mlungu uliwonse), malingana ndi nthawi ya ntchito zomwe zatsatiridwa.

Ndikukhulupirira kuti imodzi mwazolemba za Gantt chart ikugwirizana ndi zosowa zanu. Ngati sichoncho, mutha kupeza mitundu yosiyanasiyana yama tchati a Gantt pa intaneti.

Tsopano popeza mukudziwa mbali zazikulu za tchati cha Gantt, mutha kupitiliza kuphunzira ndikuphunzira kupanga ma chart anu ovuta a Gantt ku Excel kuti mudabwe abwana anu ndi anzanu onse 🙂