Okuqukethwe
Kwesinye isikhathi kusiza kakhulu ukubona ukuncika kokuguquguquka okuningana kusethi yezinye ezihlukile ezizimele kugrafu efanayo. Indlela elula yokwenza lokhu ngeshadi le-radar ku-Excel, elibizwa nangokuthi iwebhu (cobweb) noma inkanyezi (emise okwenkanyezi).
Ishadi lerada ku-Excel njengesondo elinesipikha esiguquguqukayo ngasinye. Imigqa eqondile ixhuma izikhulumi futhi ichaze uhlelo lokuxhumanisa.
Iphuzu ngalinye lokuguquguquka ngakunye lakhiwe kuma-spokes ahambisanayo, futhi la maphuzu axhunywe ngemigqa. Inqubo yokudala ishadi elinjalo ku-Excel ingaba lula kakhulu uma ulandela lezi zinyathelo.
Isinyathelo 1: Lungiselela idatha
Idatha kufanele ilungiswe ngefomethi yespredishithi ye-Excel efanele, ngaphandle kwalokho kuzodingeka wenze izinguquko ezinkulu ukuze uthole ishadi elishuthwe kahle. Konke okuguquguqukayo okuzimele (izimbangela) kufanele kubekwe emigqeni, neziguquguqukayo ezincikile (imithelela) kumakholomu. Qiniseka ukuthi ulebula okuguquguqukayo kwakho.
Esithombeni esingenhla Okukhiphayo - Amaprosesa asekelwe izici zomkhiqizo (okuguquguqukayo okuzimele), kanye Umkhiqizo A, B и C – idatha yokuhlola (okuguquguqukayo okuncike).
Isinyathelo sesi-2: Dala ishadi
Isinyathelo esilandelayo ukukhetha yonke idatha elungisiwe. Bese uvula ithebhu Faka (Faka), shayela ibhokisi lengxoxo Faka ishadi (Faka ishadi) bese ukhetha Ishadi elincane (I-Radarchart). Isithonjana seshadi le-radar sibukeka njenge-pentagon enezikhulumi ezimnyama nemigqa exhumanisa zonke izikhulumi komunye nomunye embuthanweni.
Isinyathelo sesi-3: Yenze Ihluke
Into yokugcina edingekayo lapho udala umdwebo onjalo ukwenza kube okuyingqayizivele. Amashadi e-Excel awavamile ukuthi abe mahle ngokwanele ngaphandle kwebhokisi. Ungashintsha izici ezimbalwa ngokuchofoza kwesokudla kumdwebo. Noma chofoza kumdwebo bese uya kuthebhu Ukusebenza namashadi | Framework (Amathuluzi Eshadi | Ifomethi) lapho ungashintsha khona imibala, ifonti, imiphumela yethunzi, amalebula e-eksisi nosayizi. Qiniseka ukuthi ulebula izimbazo futhi uhlale unikeza ishadi isihloko.
Amashadi e-radar ku-Excel ngezinye izikhathi anzima ukuwaqonda, kodwa awusizo uma udinga ukukhombisa ukuhlukahluka kokuguquguqukayo ezindaweni eziningana ngesikhathi esisodwa. Lokhu kusho ukuthi inani lokukodwa kokuguquguqukayo lizothuthukiswa ekubukweni kweshadi le-Radar ngoba lizophakama kakhulu kunezinye eziguquguqukayo. Konke lokhu kwenza umdwebo we-radar ube omunye obukeka kakhulu, nakuba ungavamile ukusetshenziswa.
Zizame wena futhi uthole elinye ithuluzi elihle kakhulu lokubonisa idatha eyinkimbinkimbi yenkampani yakho!
