Ka linako tse ling ho molemo haholo ho bona ho itšetleha ha mefuta e 'maloa ho lihlopha tse ling tse ikemetseng holim'a graph e le 'ngoe. Tsela e bonolo ka ho fetisisa ea ho etsa sena ke ka chate ea radar ho Excel, eo hape e bitsoang web (cobweb) kapa naleli (e bōpehileng joaloka naleli).
Chate ea radar ho Excel joalo ka lebili le nang le speaker bakeng sa phetoho ka 'ngoe. Mela e bohareng e kopanya li-spokes le ho hlalosa mokhoa oa ho hokahanya.
Ntlha e 'ngoe le e' ngoe bakeng sa phapang e 'ngoe le e' ngoe e hahiloe holim'a li-spokes tse lumellanang, 'me lintlha tsena li kopantsoe ka mela. Mokhoa oa ho theha chate e joalo ho Excel e ka ba bonolo haholo haeba u latela mehato ena.
Mohato oa 1: Lokisetsa data
Lintlha li tlameha ho lokisoa ka mokhoa o nepahetseng oa Excel spreadsheet, ho seng joalo u tla tlameha ho etsa liphetoho tse kholo ho fumana chate e hlophisitsoeng hantle. Liphetoho tsohle tse ikemetseng (lisosa) li lokela ho behoa ka mela, le mefuta e itšetlehileng ka (litšusumetso) ka mela. Etsa bonnete ba hore u ngola li-variables tsa hau.
Setšoantšong se ka holimo Tlhahiso - Support ke litšoaneleho tsa sehlahisoa (liphetoho tse ikemetseng), le Sehlahisoa A, B и C - data ea liteko (lintho tse itšetlehileng ka tsona).
Mohato oa 2: Etsa chate
Mohato o latelang ke ho khetha data eohle e lokiselitsoeng. Ebe u bula tab kenya (Kenya), letsetsa lebokose la puisano Kenya chate (Kenya chate) ebe u khetha Petal chate (Radarchart). Letšoao la chate ea radar le shebahala joaloka pentagon e nang le li-spokes tse lefifi le mela e kopanyang li-spokes tsohle ho e mong ka selikalikoe.
Mohato oa 3: Etsa hore e Ikhetha
Ntho ea ho qetela e hlokahalang ha ho etsoa setšoantšo se joalo ke ho etsa hore e be e ikhethang. Lichate tsa Excel ha se hangata li lekaneng hantle ka ntle ho lebokose. O ka fetola litšobotsi tse 'maloa ka ho tobetsa ka ho le letona setšoantšong. Kapa tobetsa setšoantšong ebe u ea ho tab Ho sebetsa ka lichate | Mookameli (Lisebelisoa tsa Chate | Fomete) moo o ka fetolang mebala, fonte, litlamorao tsa moriti, lileibole tsa axis le boholo. Etsa bonnete ba hore u ngola lilepe 'me kamehla u fane ka chate sehlooho.
Ka linako tse ling ho thata ho utloisisa lichate tsa radar ho Excel, empa li na le thuso ha u hloka ho bonts'a ho feto-fetoha ha mefuta-futa ka litsela tse 'maloa hang-hang. Sena se bolela hore boleng ba e 'ngoe ea mefuta-futa bo tla matlafatsoa ponong ea Radar Chart hobane e tla phahama haholo ho feta mefuta e meng kaofela. Sena sohle se etsa hore setšoantšo sa radar e be e 'ngoe ea tse bonoang ka ho fetesisa, leha e sa sebelisoe hangata.
E leke 'me u fumane sesebelisoa se seng se setle sa ho bonts'a lintlha tse rarahaneng tsa k'hamphani ea hau!