Enye yezinzuzo ezibaluleke kakhulu zamashadi ku-Excel yikhono lokuqhathanisa uchungechunge lwedatha ngosizo lwabo. Kodwa ngaphambi kokudala ishadi, kufanelekile ukuchitha isikhathi esincane ucabanga ukuthi iyiphi idatha nokuthi ungayibonisa kanjani ukuze wenze isithombe sicace ngangokunokwenzeka.
Ake sibheke izindlela i-Excel engabonisa ngazo uchungechunge lwedatha eminingi ukuze yakhe ishadi elicacile nelifundeka kalula ngaphandle kokuphendukela ku-PivotCharts. Indlela echazwe isebenza ku-Excel 2007-2013. Izithombe zivela ku-Excel 2013 yeWindows 7.
Ikholomu namashadi ebha anochungechunge lwedatha eminingi
Ukuze udale ishadi elihle, qala uhlole ukuthi amakholomu edatha anezihloko nokuthi idatha ihlelwe ngendlela engcono kakhulu yokuyiqonda. Qiniseka ukuthi yonke idatha inesikali futhi inosayizi ofanayo, ngaphandle kwalokho ingase idideke, isibonelo, uma ikholomu eyodwa inedatha yokuthengisa ngamadola kanti enye ikholomu inezigidi zamaRandi.
Khetha idatha ofuna ukuyibonisa eshadini. Kulesi sibonelo, sifuna ukuqhathanisa izifunda ezi-5 eziphezulu ngokuthengisa. Kuthebhu Faka (Faka) khetha ukuthi yiluphi uhlobo lweshadi ozolufaka. Kuzobukeka kanjena:
Njengoba ubona, kuzodinga ukuqoqa kancane umdwebo ngaphambi kokuwuletha ezithamelini:
- Engeza izihloko namalebula ochungechunge lwedatha. Chofoza ishadi ukuze uvule iqembu lethebhu Ukusebenza namashadi (Amathuluzi Eshadi), bese uhlela isihloko seshadi ngokuchofoza indawo yombhalo Isihloko seshadi (Isihloko Seshadi). Ukuze ushintshe amalebula ochungechunge lwedatha, landela lezi zinyathelo:
- Chofoza inkinobho Khetha idatha (Khetha Idatha) ithebhu umakhi (Dizayina) ukuze uvule ibhokisi Ukukhetha umthombo wedatha (Khetha Umthombo Wedatha).
- Khetha uchungechunge lwedatha ofuna ukulushintsha bese uchofoza inkinobho Guqula (Hlela) ukuze uvule ibhokisi Ukushintsha umugqa (Hlela uchungechunge).
- Thayipha ilebula yochungechunge lwedatha entsha endaweni yombhalo Igama lomugqa (Igama lochungechunge) bese ucindezela OK.
- Shintshanisa imigqa namakholomu. Kwesinye isikhathi isitayela seshadi esihlukile sidinga ukuhlelwa okuhlukile kolwazi. Ishadi lethu lebha elijwayelekile lenza kube nzima ukubona ukuthi imiphumela yesifunda ngasinye ishintshe kanjani ngokuhamba kwesikhathi. Chofoza inkinobho Ikholomu yomugqa (Shintsha Umugqa/Ikholomu) kuthebhu umakhi (Dizayina) bese wengeza amalebula alungile ochungechunge lwedatha.
Dala ishadi lenhlanganisela
Kwesinye isikhathi udinga ukuqhathanisa amasethi edatha amabili angafani, futhi lokhu kwenziwa kangcono kakhulu kusetshenziswa izinhlobo ezahlukene zamashadi. Ishadi lenhlanganisela ye-Excel likuvumela ukuthi ubonise uchungechunge lwedatha oluhlukile nezitayela eshadini elilodwa. Isibonelo, ake sithi sifuna ukuqhathanisa Ingqikithi Yonyaka ngokuqhathaniswa nokuthengiswa kwezifunda ezi-5 eziphezulu ukuze sibone ukuthi yiziphi izifundazwe ezilandela amathrendi esewonke.
Ukuze udale ishadi lenhlanganisela, khetha idatha ofuna ukuyibonisa kulo, bese uchofoza isiqalisi sebhokisi lengxoxo Ifaka ishadi (Faka Ishadi) ekhoneni leqembu lomyalo Imidwebo (Amashadi) ithebhu Faka (Faka). Esahlukweni Yonke imidwebo (Wonke Amashadi) chofoza Kuhlanganisiwe (Inhlanganisela).
Khetha uhlobo lweshadi olufanele lochungechunge lwedatha ngayinye ohlwini oluya phansi. Esibonelweni sethu, ngochungechunge lwedatha Isamba Sonyaka sikhethe ishadi ngezindawo (Indawo) futhi yahlanganiswa ne-histogram ukuze ibonise ukuthi isifunda ngasinye sinengxenye engakanani enambeni kanye nokuthi amathrendi akhona ahambisana kanjani.
Ngaphezu kwalokho, isigaba Kuhlanganisiwe (I-Combo) ingavulwa ngokucindezela inkinobho Shintsha uhlobo lweshadi (Shintsha Uhlobo Lweshadi) ithebhu umakhi (Umklamo).
Ithiphu: Uma uchungechunge lwedatha olulodwa lunesikali esihlukile kunezinye futhi idatha iba nzima ukuyihlukanisa, bese uthikha ibhokisi I-ekseli yesibili (I-Secondary Axis) phambi komugqa ongangeni esikalini sisonke.