Nthawi zina ndizothandiza kwambiri kuwona kudalira kwamitundu ingapo pamitundu ina yodziyimira payokha pa graph yomweyi. Njira yosavuta yochitira izi ndi tchati cha radar ku Excel, chomwe chimatchedwanso ukonde (cobweb) kapena nyenyezi (yooneka ngati nyenyezi).
Radar chart mu Excel ngati gudumu lokhala ndi speaker pakusintha kulikonse. Mizere yokhazikika imagwirizanitsa ma spokes ndikutanthauzira dongosolo logwirizanitsa.
Mfundo iliyonse yamtundu uliwonse imamangidwa pazitsulo zofananira, ndipo mfundozi zimagwirizanitsidwa ndi mizere. Njira yopangira tchati chotere mu Excel ikhoza kukhala yophweka ngati mutatsatira izi.
Gawo 1: Konzani deta
Deta iyenera kukonzedwa mwanjira yolondola ya Excel spreadsheet, apo ayi muyenera kusintha kwambiri kuti mupeze tchati chokonzedwa bwino. Zosintha zonse zodziyimira pawokha (zoyambitsa) ziyenera kuyikidwa m'mizere, ndi zosinthika (zotengera) m'mizere. Onetsetsani kuti mwalemba zosintha zanu.
Pa chithunzi pamwambapa Zotsatira - Support ndi mawonekedwe azinthu (zosintha zodziyimira pawokha), ndi Mankhwala A, B и C - data yoyeserera (zosintha zodalira).
Gawo 2: Pangani tchati
Chotsatira ndikusankha deta yonse yokonzekera. Kenako tsegulani tabu Ikani (Ikani), imbani bokosi la zokambirana Ikani tchati (Lowetsani tchati) ndikusankha Petal chart (Radarchart). Chithunzi cha tchati cha radar chikuwoneka ngati pentagon yokhala ndi masipoko akuda ndi mizere yolumikiza masipoko onse mozungulira.
Khwerero 3: Pangani Kukhala Kwapadera
Chinthu chomaliza chomwe chikufunika popanga chithunzi choterocho ndikuchipanga kukhala chapadera. Ma chart a Excel sakhala abwino mokwanira kunja kwa bokosi. Mutha kusintha mawonekedwe angapo podina kumanja pachithunzichi. Kapena dinani chithunzicho ndikupita ku tabu Kugwira ntchito ndi ma chart | Makhalidwe (Zida zama chart | Format) komwe mungasinthe mitundu, mawonekedwe, mawonekedwe azithunzi, zilembo za axis ndi kukula kwake. Onetsetsani kuti mwalemba nkhwangwazo ndipo nthawi zonse mupatseni tchati mutu.
Ma chart a radar mu Excel nthawi zina amakhala ovuta kumvetsetsa, koma amakhala othandiza mukafuna kuwonetsa kusinthasintha kwamitundu ingapo nthawi imodzi. Izi zikutanthauza kuti mtengo wa chimodzi mwazosinthika udzakulitsidwa mu Radar Chart view chifukwa idzakwera kwambiri kuposa zina zonse. Zonsezi zimapangitsa chithunzi cha radar kukhala chimodzi mwazowoneka bwino, ngakhale sichimagwiritsidwa ntchito kawirikawiri.
Yesani nokha ndikupeza chida china chachikulu chowonetsera zovuta zamakampani anu!