Maitiro ekugadzira Gantt chati muExcel?

Kana ukakumbirwa kudoma zvinhu zvitatu zvakakosha zveMicrosoft Excel, ndezvipi zvaungadoma? Zvingangodaro, mapepa anopinzwa data, mafomula anoshandiswa kuita masvomhu, uye machati ayo data yemhando yakasiyana inogona kumiririrwa nemifananidzo.

Ndine chokwadi chekuti mushandisi wese weExcel anoziva kuti chati chii uye magadzirirwo ayo. Nekudaro, kune mhando yechati yakafukidzwa nekusajeka kune vazhinji - Gantt chati. Iri gwaro rinokurumidza rinotsanangura maficha makuru eGantt chati, kukuudza nzira yekugadzira iri nyore Gantt chati muExcel, kukuudza kwaunotora yepamusoro Gantt matemplate matemplate, uye mashandisiro eiyo Project Management online service kugadzira Gantt machati.

• Chii chinonzi Gantt Chart?
• Maitiro ekugadzira Gantt chati muExcel?
• Gantt chati matemplate

Chii chinonzi Gantt Chart?

Gantt chati yakatumidzwa zita raHenry Gantt, injiniya wekuAmerica uye chipangamazano wemaneja uyo akauya nedhiyagiramu iyi muna 1910. Chati yeGantt muExcel inomiririra mapurojekiti kana mabasa seanoyerera emabhawa machati. Iyo Gantt chati inoratidza yakaputsika chimiro chepurojekiti (mazuva ekutanga uye ekupedzisira, hukama hwakasiyana pakati pemabasa mukati meprojekiti) uye nekudaro inobatsira kudzora kuitwa kwemabasa nenguva uye zvinoenderana nemabhenji akatarisirwa.

Maitiro ekugadzira Gantt Chati muExcel 2010, 2007 uye 2013

Nehurombo, Microsoft Excel haipe yakavakirwa-mukati Gantt chati template. Nekudaro, iwe unogona kukurumidza kugadzira imwe iwe pachako uchishandisa iyo bar chart mashandiro uye zvishoma zvekufometa.

Tevedza aya matanho nekungwarira uye hazvitore anopfuura maminetsi matatu kugadzira iri nyore Gantt chati. Mumienzaniso yedu, tiri kugadzira Gantt chati muExcel 3, asi zvakafanana zvinogona kuitwa muExcel 2010 uye 2007.

Danho 1. Gadzira tafura yeprojekti

Chekutanga pane zvese, isu tichaisa iyo data yeprojekiti muExcel sheet. Nyora basa rega rega pamutsara wakasiyana uye gadzira chirongwa chekuputsa chirongwa nekutsanangura kutanga zuva (Zuva rekutanga), girajuwesheni (zuva rekupedzisira) uye chinguva (Kutora nguva), ndiko kuti, nhamba yemazuva anotora kuti basa racho ripere.

Tip: Makoramu chete anodiwa kugadzira Gantt chati Start date и chinguva. Nekudaro, kana iwe ukagadzirawo column Zuva rekupedzisira, ipapo unogona kuverenga nguva yebasa uchishandisa fomula iri nyore, sezvinoonekwa pamufananidzo uri pazasi:

Danho 2. Vaka chenguva dzose Excel bar chart zvichibva pane "Start date" column database

Tanga kuvaka Gantt chati muExcel nekugadzira iri nyore akaturikidzana bar chart:

• Simbisa huwandu Tanga Mazuva pamwe chete nemusoro wembiru, mumuenzaniso wedu ndizvo B1:B11. Izvo zvinodikanwa kusarudza maseru chete ane data, uye kwete iyo column yese yepepa.
• Pa Advanced tabo Insert (Isa) pasi peChati, tinya Isa bar chart (Bar).
• Mumenu inovhura, muboka Kutongwa (2-D Bar) tinya Ruled Stacked (Akaturikidzana Bar).

Nekuda kweizvozvo, iyo inotevera chati inofanira kuoneka pane pepa:

Cherechedza: Mimwe yemamwe mirairo yekugadzira maGantt machati anoratidza kuti iwe unotanga wagadzira isina chinhu bar chati uye woizadza nedata, sezvatichaita munhanho inotevera. Asi ini ndinofunga kuti nzira yakaratidzwa iri nani nekuti Microsoft Excel inongowedzera imwe mutsara wedata uye nenzira iyi tichachengetedza imwe nguva.

Nhanho 3: Wedzera Nguva Yenguva Dhata kuChati

Tevere, isu tinofanirwa kuwedzera imwe data data kune yedu ramangwana Gantt chati.

1. Tinya-kurudyi pese padhayagiramu uye mumenu yemukati tinya Sarudza data (Sarudza Data).A dialog box ichavhura Kusarudza nzvimbo yedata (Sarudza Data Source). Sezvauri kuona mumufananidzo pazasi, iyo column data Tanga Date yatowedzerwa kumunda Legend zvinhu (mitsara) (Legend Entries (Series). Zvino unofanira kuwedzera column data pano chinguva.
2. dzvanya wedzera (Wedzera) kusarudza imwe dhata (Nguva) yekuratidzira paGantt chati.
3. Mufafitera rakavhurwa Row shanduko (Gadzirisa nhevedzano) ita izvi:
   • Mu Zita remusara (Series zita) isa "Duration" kana chero rimwe zita raunoda. Kana kuti iwe unogona kuisa chitubu mundima iyi wobva wadzvanya pane zita rekoramu inoenderana patafura - iro zita rakadzvanywa richawedzerwa sezita rakateedzana reGantt chati.
   • Dzvanya chiratidzo chekusarudza renji padivi pemunda Zvinokosha (Series values).
4. Dialog window Row shanduko (Gadzirisa nhevedzano) ichaderera. Simbisa data muchikamu chinguvanekudzvanya pane yekutanga sero (munyaya yedu iri D2) uye kukwevera pasi kune yekupedzisira data cell (D11) Ita shuwa kuti hausarudze musoro netsaona kana imwe sero isina chinhu.
5. Dzvanya chiratidzo chekusarudza renji zvakare. Dialog window Row shanduko (Hora nhevedzano) ichawedzerwa zvakare uye minda ichaonekwa Zita remusara (Zita reSeries) uye Zvinokosha (Series values). Dzvanya OK.
6. Tichadzokera kuhwindo zvakare Kusarudza nzvimbo yedata (Sarudza Data Source). Zvino mumunda Legend zvinhu (mitsara) (Legend Entries (Series) tinoona dzakatevedzana Tanga Date uye chiverengero chinguva. Ingotinya OK, uye iyo data ichawedzerwa kune chati.

Mufananidzo unofanirwa kutaridzika seizvi:

Nhanho 4: Wedzera Tsanangudzo Yebasa kuGantt Chati

Iye zvino unoda kuratidza runyoro rwemabasa kuruboshwe rwemufananidzo pane nhamba.

1. Tinya-kurudyi kwese kwese munzvimbo yekuronga (nzvimbo ine mitsetse yebhuruu neorenji) uye mumenyu inoonekwa, tinya. Sarudza data (Sarudza Dhata) kuti udzoke bhokisi rebhokisi Kusarudza nzvimbo yedata (Sarudza Data Source).
2. Munzvimbo yekuruboshwe yebhokisi rebhokisi, sarudza Tanga Date Uye chengetedza chinja (Gadzirisa) munzvimbo yekurudyi yehwindo ine zita Horizontal axis labels (mapoka) (Horizontal (Chikamu) Axis Labels).
3. Kabhokisi kebhokisi kadiki kanovhura Axis mavara (Axis labels). Iye zvino iwe unofanirwa kusarudza mabasa nenzira imwechete sepanhanho yapfuura isu takasarudza dhata pahurefu hwemabasa (Durations column) - tinya chiratidzo chesarudzo, wobva wadzvanya pane yekutanga basa patafura uye dhonza sarudzo negonzo. kusvika pabasa rekupedzisira. Rangarira kuti musoro wekoramu haufanirwe kuratidzwa. Paunenge wapedza izvozvo, tinya iyo renji yekusarudza icon zvakare kuunza iyo dialog box.
4. Tora kaviri OKkuvhara mabhokisi ese enhaurirano.
5. Bvisa ngano yechati - tinya-kurudyi pairi uye mumenu yemukati tinya Bvisa (Delete).

Panguva ino, iyo Gantt chati inofanirwa kuve netsananguro yebasa kuruboshwe uye tarisa chimwe chinhu seizvi:

Nhanho yechishanu: Shandura Bhara Chati kuita Gantt Chati

Panguva ino, chati yedu ichiri yakarongedzerwa bar chart. Kuti iite sechati yeGantt, unofanirwa kuifomatidza nemazvo. Basa redu nderokubvisa mitsara yebhuruu kuitira kuti zvikamu zveorenji chete zvemagirafu, izvo zvinomiririra mabasa epurojekiti, zvirambe zvichionekwa. Nehunyanzvi, isu hatisi kuzobvisa mitsetse yebhuruu, isu tinongoita kuti ibude pachena uye saka isingaonekwe.

1. Dzvanya pane chero mutsara webhuruu paGantt chati, uye ese achasarudzwa. Tinya-kurudyi pane zvakasarudzwa uye mumenu yezvinyorwa tinya Data series format (Format Data Series).
2. Mubhokisi rebhokisi rinoonekwa, ita zvinotevera:
   • Muchikamu Zadza (Zadza) sarudza Kwete zadza (Hapana Kuzadza).
   • Muchikamu mupendero (Border Color) sarudza hapana mitsetse (Hapana Mutsetse).

Cherechedza: Usavhare iyi dialog box, unozoida zvakare munhanho inotevera.

3. Mabasa ari paGantt chati yatakavaka muExcel ari munhevedzano kurongeka. Tichagadzirisa izvozvo munguva pfupi. Dzvanya pane rondedzero yemabasa kuruboshwe rweGantt chati kuratidza chikamu axis. A dialog box richavhura Axis Format (Format Axis). Muchitsauko Axis parameters (Axis Options) tarisa bhokisi Reverse order yezvikamu (Categories in reverse order), wobva wavhara hwindo kuti uchengetedze shanduko dzako.Nekuda kweshanduko dzatichangobva kuita:
   • Mabasa ari paGantt chati ari muhurongwa chaihwo.
   • Mazuva ari paakiso yakachinjika atama kubva pasi kuenda kumusoro kwechati.

Iyo chati inova yakafanana neyakajairika Gantt chati, handiti? Semuenzaniso, yangu Gantt chati ikozvino inoita seizvi:

Danho 6. Kugadzirisa Gantt Chati Dhizaini muExcel

Iyo Gantt chati yave kutotora chimiro, asi iwe unogona kuwedzera mamwe mashoma ekupedzisa kubata kuti iite yakanakisa.

1. Bvisa nzvimbo isina chinhu kune rumwe rutivi rworuboshwe rweGantt chati

Kana tichivaka chati yeGantt, takaisa mabhara ebhuruu pakutanga kwechati kuratidza zuva rekutanga. Iye zvino chivharo chinoramba chiri munzvimbo yavo chinogona kubviswa uye mitsetse yebasa inogona kutamirwa kuruboshwe, padyo neiyo vertical axis.

• Kurudyi tinya pane yekutanga kukosha kukosha Tanga Date mutafura ine sosi data, mune yemukati menyu sarudza Sero format > nhamba > General (Format Cells> Number> General). Bata nemusoro nhamba yaunoona mumunda chiratidza zvizhinji (Sample) ndiyo nhamba inomiririra zuva racho. Munyaya yangu iyi nhamba 41730. Sezvaunoziva, Excel inochengeta misi senhamba dzakaenzana nenhamba yemazuva yaJanuary 1, 1900 zuva risati rasvika (apo Ndira 1, 1900 = 1). Iwe haufanirwe kuita chero shanduko pano, ingobaya cancellation (Kanzura).
• PaGantt chati, tinya chero zuva riri pamusoro pechati. Kudzvanya kumwe chete kuchasarudza misi yese, wobva wadzvanya-kurudyi paari uye mumenu yemukati tinya Axis Format (Format Axis).
• Pamenu Parameters axis (Axis Options) shandura sarudzo pasipasi (Minimum) on nhamba (Yakagadziriswa) uye isa nhamba yawakarangarira munhanho yapfuura.

2. Gadzirisa nhamba yemazuva paaxis yeGantt chati

Pano, mubhokisi rebhokisi Axis Format (Format Axis) iyo yakavhurwa munhanho yapfuura, shandura maparameter Zvikamu zvikuru (Major united) uye Zvikamu zvepakati (Minor unit) ye nhamba (Yakagadziriswa) uye isa iyo yaunoda kukosha yenguva dzenguva pane axis. Kazhinji, iyo ipfupi nguva dzemafuremu emabasa mupurojekiti, idiki nhanho yekuparadzanisa inodiwa pane axis yenguva. Semuenzaniso, kana iwe uchida kuratidza zuva rechipiri rega rega, pinda 2 kune parameter Zvikamu zvikuru (Chikwata chikuru). Ndeapi marongero andakaita - unogona kuona pamufananidzo uri pazasi:

Tip: Tamba uchitenderedza nemaseting kusvika wawana mhedzisiro yaunoda. Usatya kuita chimwe chinhu chakaipa, iwe unogona kugara uchidzokera kune zvigadziriso zvimiro nekuisa sarudzo Automatically (Auto) muExcel 2010 uye 2007 kana nekudzvanya itangezve (Reset) muExcel 2013.

3. Bvisa imwe nzvimbo isina chinhu pakati pemitsetse

Ronga mabhawa ebasa pachati zvakanyanya kusimba, uye iyo Gantt chati inotaridzika zvirinani.

• Sarudza mbariro dzeorenji dzemagirafu nekudzvanya pane imwe yacho nebhatani rekuruboshwe, wobva wadzvanya pairi uye mumenyu inoonekwa, tinya. Data series format (Format Data Series).
• Mubhokisi rehurukuro Data series format (Format Data Series) isa parameter ku mitsara inopindirana (Series Overlap) kukosha 100% (slider yakafamba kuenda kurudyi), uye yeparameter. Side clearance (Gap Width) kukosha 0% kana inenge 0% (slider nzira yose kana inenge nzira yose kuruboshwe).

Uye heino mhedzisiro yekuedza kwedu - yakapusa asi yakanyatsojeka Gantt chati muExcel:

Rangarira kuti iyo Excel chati yakagadzirwa nenzira iyi iri padyo neiyo chaiyo Gantt chati, uchichengeta zvese zviri nyore zveExcel machati:

• Iyo Gantt chati muExcel ichakura kana mabasa awedzerwa kana kubviswa.
• Chinja zuva rekutanga rebasa (Zuva rekutanga) kana nguva yaro (Nguva), uye hurongwa huchabva hwaratidza otomatiki shanduko dzakaitwa.
• Iyo Gantt chati yakagadzirwa muExcel inogona kuchengetwa semufananidzo kana kushandurwa kuita HTML fomati uye kuburitswa paInternet.

BASA:

• Gadzirisa kutaridzika kwechati yako yeGantt nekushandura sarudzo dzekuzadza, miganhu, mimvuri, uye kunyange kushandisa 3D mhedzisiro. Ese aya sarudzo anowanikwa mubhokisi rekutaura. Data series format (Format Data Series). Kuti ufonere hwindo iri, tinya-kurudyi pane bhaa yechati munzvimbo yekuronga chati uye mumenu yemukati tinya Data series format (Format Data Series).
• Kana chimiro chekugadzira chakasikwa chichifadza ziso, saka Gantt yakadaro inogona kuchengetwa muExcel se template uye inoshandiswa mune ramangwana. Kuti uite izvi, tinya padhiyagiramu, vhura iyo tab Constructor (Design) uye tinya Sevha se template (Sevha seTemplate).

Dhawunirodha muenzaniso weGantt chati

Gantt chati template muExcel

Sezvauri kuona, kuvaka yakapusa Gantt chati muExcel haina kuoma zvachose. Asi zvakadini kana yakawedzera kuoma Gantt chati ichidiwa, umo shading yebasa inoenderana nehuwandu hwekupedzwa kwayo, uye zviitiko zvepurojekiti zvinoratidzwa nemitsetse yakatwasuka? Ehe, kana iwe uri mumwe weaya asingawanzo uye asinganzwisisike zvisikwa zvatinodaidza neruremekedzo iyo Excel Guru, saka unogona kuedza kugadzira dhizaini rakadaro iwe pachako.

Nekudaro, zvichave nekukurumidza uye nyore kushandisa pre-yakagadzirwa Gantt chati matemplate muExcel. Pazasi pane pfupiso pfupi ye akati wandei manejimendi manejimendi Gantt chati matemplate emhando dzakasiyana dzeMicrosoft Excel.

Microsoft Excel 2013 Gantt Chart Template

Iyi Gantt chati template yeExcel inonzi Project Planner (Gantt Project Planner). Yakagadzirirwa kuteedzera kufambira mberi kweprojekiti ichipokana neakasiyana metrics akadai Yakarongwa kutanga (Kuronga Kutanga) uye kutanga chaiko (Kutanga chaiko), Nguva yakarongwa (Hurongwa Hwenguva) uye Actual Duration (Chaiyo Duration), uyewo Percent yakakwana (Percent Yakakwana).

MuExcel 2013, iyi template inowanikwa pane iyo tab faira (Faira) pahwindo sika (Zvitsva). Kana pasina template muchikamu chino, unogona kuidhawunirodha kubva kuMicrosoft webhusaiti. Hapana ruzivo rwekuwedzera runodiwa kushandisa iyi template - tinya pairi uye tanga.

Online Template Chart Ganta

Smartsheet.com inopa inodyidzana online Gantt Chart Builder. Iyi Gantt chati template yakangopusa uye yakagadzirira kushandisa seyakapfuura. Iyo sevhisi inopa yemazuva makumi matatu yemahara muyedzo, saka inzwa wakasununguka kusaina neGoogle account yako uye wotanga kugadzira yako yekutanga Gantt chati ipapo.

Maitiro acho ari nyore kwazvo: mutafura kuruboshwe, isa iwo mameseji epurojekiti yako, uye tafura painozadza, Gantt chati inogadzirwa kurudyi.

Gantt Chart Matemplate eExcel, Google Sheets uye OpenOffice Calc

Pa vertex42.com unogona kuwana emahara Gantt matemplate eExcel 2003, 2007, 2010 uye 2013 ayo anoshandawo neOpenOffice Calc neGoogle Sheets. Iwe unogona kushanda neaya matemplate sezvaungaita chero yakajairwa Excel spreadsheet. Ingoisa zuva rekutanga uye nguva yebasa rega rega uye isa iyo % yakazara mukoramu % yakakwana. Kuti uchinje dheti rinoratidzwa munzvimbo yeGantt chart, fambisa siraidhi pabhara rekurodha.

Uye pakupedzisira, imwe Gantt chati template muExcel yekufunga kwako.

Project Manager Gantt Chart template

Imwe yemahara Gantt chati template inopihwa ku professionalexcel.com uye inonzi "Project Manager Gantt Chart". Mune iyi template, zvinokwanisika kusarudza maonero (zuva nezuva kana akajairwa vhiki nevhiki), zvichienderana nenguva yemabasa akatevedzwa.

Ndinovimba kuti imwe yeakatsanangurwa Gantt chati matemplate anoenderana nezvido zvako. Kana zvisiri, iwe unogona kuwana akasiyana makuru akasiyana eGantt chati matemplate paInternet.

Iye zvino zvawaziva iwo makuru maficha eiyo Gantt chati, unogona kuenderera mberi uchiidzidza uye kudzidza kugadzira yako yakaoma Gantt machati muExcel kushamisa mukuru wako nevamwe vako vese 🙂