Mukati
Dzimwe nguva zvinogona kunetsa kukurumidza uye kunyatsoenderana nenguva yemapurojekiti. Iyo graphical inomiririra yemazuva ekupedzisira epurojekiti uye zviitiko zvakakosha zvichabatsira kuona chero zvipingamupinyi panguva yekuronga.
Zvechokwadi, zvakakosha kufunga nezvekushandiswa kwehurongwa hwekugadzirisa zvirongwa. Sistimu yakadaro icharatidza kutanga uye nguva dzekupedzisira dzemabasa eprojekiti achipesana neyakajairwa kumashure. Asi masisitimu akadaro anodhura zvakanyanya! Imwe mhinduro ndeyekuyedza kushandisa iyo Excel timeline bar chart paunenge uchironga kuona kusawirirana kwese mupurojekiti. Kudyidzana nechikwata uye nevechitatu-bato nyanzvi zvichave nyore kana zviito zvemunhu wese zvichionekwa papepa rimwe chete!
Nehurombo, kugadzira nguva muMicrosoft Excel harisi basa riri nyore. Ini handingakurudzire kuvaka yakaomesesa Gantt chati muExcel, asi iri nyore nguva inogona kugadzirwa nekutevera yedu nhanho-nhanho mirairo:
Danho 1: Gadzirira data
Kutanga, tinoda tafura yedata, mune yekuruboshwe iyo (column А) ine ese mazita ebasa, uye makoramu maviri ari kurudyi akachengeterwa zuva rekutanga uye nguva yebasa (makoramu В и С).
Danho rechipiri: Gadzira chati
Simbisa iyo yakagadzirirwa data tafura, ipapo pane iyo tab Insert (Isa) muchikamu Mifananidzo (Machati) tinya Ruled Stacked (Akaturikidzana Bar).
Nhanho 3: Kuronga Dhata paChati nemazvo
Iyi nhanho inogara yakanyanya kuoma, sezvo chati inotanga kurongwa ne data chaiyo munzvimbo dzisina kunaka, kana iyo data yakamboonekwa pane chati!
Dzvanya bhatani Sarudza data (Sarudza Data) tab Constructor (Design). Tarisa zviri munzvimbo Legend zvinhu (mitsara) (Legend Entries (Series)) zvinhu zviviri zvakanyorwa - nguva (Duration) uye zuva rekutanga (Zuva Rokutanga). Panofanira kuva nezvinhu zviviri izvi chete.
Rega ndifembere. Ruzivo rwese rwafamba here kana kuti rwaenda kudivi? Ngatigadzirise.
Kuti ugadzirise data rako, tinya wedzera (Wedzera) kana chinja (Gadzirisa) munzvimbo Legend zvinhu (mitsara) (Legend Entries (Series)). Kuti uwedzere Zuva Rokutanga, tsanangura sero B1 mumunda Zita remusara (Series Zita), uye mumunda Zvinokosha (Series Values) - siyana B2:B13. Nenzira imwecheteyo, iwe unogona kuwedzera kana kushandura nguva yebasa (Duration) - mumunda Zita remusara (Series Name) tsanangura sero C1, uye kumunda Zvinokosha (Series Values) - siyana C2:C13.
Kurongedza zvikamu, tinya bhatani chinja (Gadzirisa) munzvimbo Horizontal axis labels (mapoka) (Horizontal (Chikamu) Axis Labels). Rudzi rwe data runofanira kutsanangurwa pano:
=Лист3!$A$2:$A$13
=Sheet3!$A$2:$A$13
Panguva ino, chati inofanira kutaridzika sechati yakaturikidzana ine mazita ebasa pane yakatwasuka axis uye misi pane yakachinjika axis.
Nhanho 4: Kushandura Mhedzisiro kuita Gantt Chati
Chinosara kuti chiitwe kushandura ruvara rwekuzadza rweruboshwe rwezvikamu zvese zvinobuda girafu mabhawa kuita chena kana pachena.
★ Verenga zvakawanda nezvekugadzira Gantt chati mune chinyorwa: → Maitiro ekugadzira Gantt chati muExcel - nhanho nhanho mirairo
Nhanho 5: Kuvandudza Kutaridzika kweChati
Nhanho yekupedzisira ndeyekuita kuti dhayagiramu inake kuitira kuti itumirwe kuna maneja. Tarisa axis yakachinjika: chete mabhawa enguva yeprojekiti anofanirwa kuoneka, kureva kuti isu tinofanirwa kubvisa nzvimbo isina chinhu yakabuda munhanho yapfuura. Tinya-kurudyi pane yakachinjika axis yechati. Pane pachaonekwa Axis parameters (Axis Sarudzo), maunogona kushandura hushoma kukosha kweaxis. Gadzirisa mavara eGantt chati mabara, isa chimwe chinhu chinonakidza. Chekupedzisira, usakanganwa zita racho.
Nguva muExcel (Gantt chati) inogona kushandiswa kune zvakasiyana siyana. Ma manejimendi anozotenda kuti iwe unogona kugadzira hurongwa hwakadaro pasina imwe mari yekutenga inodhura purojekiti manejimendi software!