Tse ka Hare
Ka linako tse ling ho ka ba thata ho bapisa ka potlako le ka nepo linako tsa merero. Setšoantšo se hlakileng sa linako tsa projeke le liketsahalo tsa bohlokoa li tla thusa ho tseba mathata leha e le afe nakong ea moralo.
Ha e le hantle, ho bohlokoa ho nahana ka tšebeliso ea mekhoa ea tsamaiso ea merero. Sistimi e joalo e tla bonts'a nako ea ho qala le ea ho qetela ea mesebetsi ea projeke khahlano le semelo se akaretsang. Empa litsamaiso tse joalo li turu haholo! Tharollo e 'ngoe ke ho leka ho sebelisa chate ea tatellano ea nako ea Excel ha u rera ho bona likhohlano tsohle tse teng morerong. Ho sebelisana le sehlopha le litsebi tsa mokha oa boraro ho tla ba bonolo haholo haeba liketso tsa motho e mong le e mong li ka bonoa letlapeng le le leng!
Ka bomalimabe, ho theha kemiso ea nako ho Microsoft Excel ha se mosebetsi o bonolo. Ke ne nke ke ka khothaletsa ho aha chate e rarahaneng ea Gantt ho Excel, empa kemiso e bonolo ea nako e ka etsoa ka ho latela litaelo tsa rona tsa mohato ka mohato:
Mohato oa 1: Lokisetsa data
Ho qala, re hloka tafole ea data, ka har'a kholomo e ka letsohong le letšehali (kholomo А) e na le mabitso ohle a mosebetsi, 'me likholomo tse peli tse ka ho le letona li boloketsoe letsatsi la ho qala le nako ea mosebetsi (likholomo В и С).
Mohato oa 2: Etsa chate
Totobatsa tafole ea data e lokisitsoeng, ebe ho tab kenya (Kenya) karolong Litšoantšo (Lichate) tobetsa Ruled Stacked (Bara e Stacked).
Mohato oa 3: Ho Rala Lintlha ka Chate ka Nepo
Mohato ona o lula o le thata ka ho fetisisa, kaha chate e qalile ho lokisoa ka lintlha tse nepahetseng libakeng tse fosahetseng, haeba data eo e kile ea hlaha chate!
Tobetsa konopo Kgetha data (Khetha Data) tab Constructor (Moqapi). Sheba se sebakeng seo Lintho tsa khale (mela) (Likenyo tsa Litšōmo (Letoto)) ho ngotsoe likarolo tse peli - nako (Nako) le letsatsi la ho qala (Letsatsi la ho Qala). Ho lokela ho ba le lintlha tsena tse peli feela.
E re ke nahane. Na litaba tsohle li tsamaile kapa li suthele ka thoko? Ha re e lokise.
Ho lokisa lintlha tsa hau, tobetsa Add (Eketsa) kapa Change (Edita) sebakeng seo Lintho tsa khale (mela) (Likenyo tsa Legend (Letoto)). Ho eketsa Letsatsi la ho Qala, bolela sele B1 naheng Lebitso la mola (Series Name), le tšimong Litekanyetso (Series Values) - range B2:B13. Ka mokhoa o ts'oanang, o ka eketsa kapa oa fetola nako ea mesebetsi (Nako) - tšimong Lebitso la mola (Series Name) hlakisa sele C1, le tšimong Litekanyetso (Series Values) - range C2:C13.
Ho hlophisa lihlopha, tobetsa konopo Change (Edita) sebakeng seo Lileibole tsa axis tse otlolohileng (mekhahlelo) (Ho Horizontal (Sehlopha) Li-Labels tsa Axis). Lethathamo la data le tlameha ho hlalosoa mona:
=Лист3!$A$2:$A$13
=Sheet3!$A$2:$A$13
Mothating ona, chate e lokela ho shebahala joalo ka chate e phuthetsoeng e nang le lihlooho tsa mesebetsi ho axis e otlolohileng le matsatsi a axis e otlolohileng.
Mohato oa 4: Fetola Sephetho ho Chate ea Gantt
Seo se setseng se lokela ho etsoa ke ho fetola 'mala o tlatsitsoeng oa likarolo tse ka ho le letšehali tsa mekoallo eohle ea li-graph hore e be tšoeu kapa e pepenene.
★ Bala haholoanyane ka ho theha chate ea Gantt sengolong: → Mokhoa oa ho aha chate ea Gantt ho Excel - litaelo tsa mohato ka mohato
Mohato oa 5: Ho Ntlafatsa Ponahalo ea Chate
Mohato oa ho qetela ke ho etsa hore setšoantšo se be setle haholoanyane e le hore se ka romeloa ho mookameli. Sheba li-axis tse otlolohileng: ke mekoallo ea nako ea morero feela e lokelang ho bonahala, ke hore, re hloka ho tlosa sebaka se se nang letho se hlahileng mohatong o fetileng. Tobetsa ka ho le letona lehlakoreng le tšekaletseng la chate. Ho tla hlaha phanele Axis parameters (Likhetho tsa Axis), moo u ka fetolang boleng ba bonyane ba axis. Iketsetse mebala ea lichate tsa Gantt, beha ntho e khahlisang le ho feta. Qetellong, u se ke ua lebala sehlooho.
Lenane la nako ho Excel (Chate ea Gantt) e ka sebelisoa mererong e fapaneng. Ka sebele batsamaisi ba tla ananela hore u ka etsa kemiso e joalo ntle le litšenyehelo tse eketsehileng tsa ho reka software e theko e boima ea tsamaiso ea morero!