Ɗaya daga cikin mahimman fa'idodin ginshiƙi a cikin Excel shine ikon kwatanta jerin bayanai tare da taimakonsu. Amma kafin ƙirƙirar ginshiƙi, yana da daraja kashe ɗan lokaci don tunanin menene bayanai da yadda za a nuna su don bayyana hoton a sarari yadda zai yiwu.
Bari mu kalli hanyoyin da Excel zai iya nuna jerin bayanai da yawa don ƙirƙirar fayyace mai sauƙin karantawa ba tare da neman PivotCharts ba. Hanyar da aka bayyana tana aiki a cikin Excel 2007-2013. Hotuna daga Excel 2013 ne don Windows 7.
ginshiƙi da sigogin mashaya tare da jerin bayanai masu yawa
Don ƙirƙirar ginshiƙi mai kyau, da farko bincika cewa ginshiƙan bayanan suna da kanun labarai kuma an tsara bayanan ta hanya mafi kyau don fahimtar ta. Tabbatar cewa duk bayanan an daidaita su kuma girmansu iri ɗaya ne, in ba haka ba zai iya samun rudani, misali, idan shafi ɗaya yana da bayanan tallace-tallace a cikin daloli kuma ɗayan yana da miliyoyin daloli.
Zaɓi bayanan da kuke son nunawa a cikin ginshiƙi. A cikin wannan misali, muna so mu kwatanta manyan jihohi 5 ta hanyar tallace-tallace. A kan shafin Saka (Saka) zaɓi nau'in ginshiƙi don sakawa. Zai yi kama da wani abu kamar haka:
Kamar yadda kuke gani, zai ɗauki ɗan gyara zane kafin gabatar da shi ga masu sauraro:
- Ƙara lakabi da lakabin jerin bayanai. Danna kan ginshiƙi don buɗe rukunin rukunin Aiki tare da ginshiƙi (Kayan aikin Chart), sannan a gyara taken taswira ta danna filin rubutu Taken jadawalin (Chat Take). Don canza lakabin jerin bayanai, bi waɗannan matakan:
- latsa Zaɓi bayanai (Zaɓi Bayanai) tab Constructor (Zane) don buɗe maganganun Zaɓi tushen bayanai (Zaɓi Tushen Bayanai).
- Zaɓi jerin bayanan da kuke son canzawa kuma danna maɓallin Change (Edit) don buɗe maganganun Canjin layi (Edit Series).
- Buga sabon lakabin jerin bayanai a filin rubutu Sunan layi (Series name) kuma latsa OK.
- Musanya layuka da ginshiƙai. Wani lokaci salon ginshiƙi na daban yana buƙatar tsari daban na bayanai. Madaidaicin ginshiƙi na mu yana da wahala a ga yadda sakamakon kowace jiha ya canza akan lokaci. Danna maɓallin Rukunin layi (Canja Layi/Shafi) akan shafin Constructor (Kira) kuma ƙara madaidaicin takalmi don jerin bayanai.
Ƙirƙiri taswirar haduwa
Wani lokaci kuna buƙatar kwatanta saitin bayanai iri ɗaya guda biyu, kuma an fi yin wannan ta amfani da sigogi daban-daban. Taswirar haduwa ta Excel tana ba ku damar nuna jerin bayanai da salo daban-daban a cikin ginshiƙi ɗaya. Misali, bari mu ce muna son kwatanta jimlar Shekara-shekara da tallace-tallace na manyan jihohi 5 don ganin waɗanne jihohi ne ke bin yanayin gabaɗaya.
Don ƙirƙirar ginshiƙi, zaɓi bayanan da kuke son nunawa akansa, sannan danna maballin akwatin maganganu Saka ginshiƙi (Saka Chart) a kusurwar rukunin umarni Diagrams (Charts) tab Saka (Saka). A cikin babi Duk zane-zane (Duk Charts) danna Hade (Combo).
Zaɓi nau'in ginshiƙi mai dacewa don kowane jerin bayanai daga jerin abubuwan da aka saukar. A cikin misalinmu, don jerin bayanai Jimlar Shekara-shekara mun zabi ginshiƙi tare da yankunan (Area) da kuma haɗa shi tare da tarihin tarihi don nuna yadda kowace jiha ke ba da gudummawa ga jimillar da yadda yanayin su ya dace.
Bugu da kari, sashen Hade Za'a iya buɗe (Combo) ta latsa maɓallin Canja nau'in ginshiƙi (Canja Nau'in Chart) tab Constructor (Zane).
tip: Idan daya daga cikin jerin bayanan yana da ma'auni daban-daban daga sauran kuma bayanan ya zama da wahala a rarrabe, to duba akwatin Sakandare axle (Secondary Axis) a gaban jere wanda bai dace da sikelin gabaɗaya ba.
