Wani lokaci yana da fa'ida sosai don ganin dogaro da masu canji da yawa akan saitin wasu masu canji masu zaman kansu akan jadawali ɗaya. Hanya mafi sauƙi don yin haka ita ce ta hanyar radar a cikin Excel, wanda kuma ake kira yanar gizo (cobweb) ko tauraro (mai siffar tauraro).
Taswirar Radar a cikin Excel kamar wata dabaran da ke da magana ga kowane mai canzawa. Layukan da ke da alaƙa suna haɗa masu magana da ma'anar tsarin daidaitawa.
Kowane batu na kowane maɗaukaki an gina shi akan madaidaicin magana, kuma waɗannan maki an haɗa su ta hanyar layi. Tsarin ƙirƙirar irin wannan ginshiƙi a cikin Excel na iya zama mai sauƙi idan kun bi waɗannan matakan.
Mataki 1: Shirya bayanai
Dole ne a shirya bayanan a cikin madaidaicin ma'auni na Excel, in ba haka ba za ku yi manyan canje-canje don samun ginshiƙi mai kyau. Ya kamata a sanya duk masu canji masu zaman kansu (dalili) a cikin layuka, da kuma masu dogaro (tasiri) a cikin ginshiƙai. Tabbatar yin lakabin masu canjin ku.
A cikin hoton da ke sama Fitarwa - Support halaye ne na samfur (masu canji masu zaman kansu), da Samfurin A, B и C - bayanan gwaji (masu-masu-kai masu dogaro).
Mataki 2: Ƙirƙiri ginshiƙi
Mataki na gaba shine zaɓar duk bayanan da aka shirya. Sannan bude shafin Saka (Saka), kira akwatin maganganu Saka ginshiƙi (Saka ginshiƙi) kuma zaɓi Tsarin furanni (Radarchart). Tambarin taswirar radar yayi kama da pentagon mai duhun magana da layukan da ke haɗa duk mai magana da juna a cikin da'irar.
Mataki na 3: Sanya shi Na Musamman
Abu na ƙarshe da ake buƙata lokacin ƙirƙirar irin wannan zane shine sanya shi na musamman. Taswirar Excel ba su da kyau sosai a cikin akwatin. Kuna iya canza halaye da yawa ta danna dama akan zane. Ko danna kan zane kuma je zuwa shafin Aiki tare da ginshiƙi | tsarin (Kayan aiki Chart | Tsarin) inda zaku iya canza launuka, font, tasirin inuwa, alamun axis da girma. Tabbatar yin lakabin gatari kuma koyaushe ba da ginshiƙi taken.
Taswirar Radar a cikin Excel wani lokaci suna da wuyar fahimta, amma suna da amfani lokacin da kuke buƙatar nuna bambance-bambancen masu canji a wurare da yawa a lokaci ɗaya. Wannan yana nufin cewa darajar ɗaya daga cikin masu canji za a haɓaka a cikin ra'ayi na Radar Chart saboda zai fi girma fiye da sauran masu canji. Duk wannan ya sa zanen radar ya zama mafi kyawun gani, kodayake ba a cika amfani da shi ba.
Gwada shi da kanku kuma sami wani babban kayan aiki don nuna hadaddun bayanan kamfanin ku!
