Zama ngamashadi we-Excel namagrafu ukubonisa idatha yakho
Amashadi namagrafu yizethulo ezibukwayo zedatha lokusebenzela. Bavame ukwenza kube lula ukuqonda idatha kushidi lokusebenzela ngoba abasebenzisi bangakhetha amaphethini nezitayela ezingafani nakakhulu ukubona idatha. Ngokuvamile, amagrafu asetshenziselwa ukubonisa izitayela ngokuhamba kwesikhathi, kanti amashadi abonisa amaphethini noma aqukethe ulwazi mayelana nemvamisa. Khetha i-Excel ishadi noma ifomethi yefrifu ebonisa kahle imininingwane yezidingo zakho.
Amashadi we-Pie
Amashadi wephayi (noma ujikeleze amagrafu) isetshenziselwa ukushayela okuguquguqukayo okukodwa ngesikhathi esisodwa. Ngenxa yalokho, zingasetshenziswa kuphela ukubonisa amaphesenti.
Umbuthano wamashadi we-pie umele amaphesenti angu-100. Umbuthano uhlukaniswe ngeziqephu ezimele amanani wedatha. Ubukhulu besigaba ngasinye sibonisa ukuthi iyiphi ingxenye yamaphesenti angu-100 emele.
Amashadi we-pie angasetshenziswa uma ufuna ukukhombisa ukuthi yiziphi amaphesenti into ethile emele uchungechunge lwedatha. Ngokwesibonelo:
- Inzuzo yenkampani yenyanga ngayinye ingaboniswa ngeshadi lephayi njengephesenti yenzuzo yonyaka.
- Isilinganiso sokushaya kwesidlali se-baseball singaboniswa ngeshadi lepayipi ngoba limelela iphesenti lamahits uma kuqhathaniswa nenani eliphelele lama-at-batshi ngenkathi.
- Iphesenti yokubala kwakho kwansuku zonke yekhalori ukuthi i-cheese kanye ne-bacon hamburger imelela.
Amashadi wekholomu
Amashadi wekholomu , eyaziwa nangokuthi ibrafu yamabha, isetshenziselwa ukukhombisa ukufaniswa phakathi kwezinto zedatha. Ziyodwa yezinhlobo ezivame kakhulu zegrafu ezisetshenziselwa ukubonisa idatha. Amanani ayaboniswa esebenzisa ibha yokuma noma umugqa, futhi ikholomu ngayinye eshadini imelela inani lemininingwane ehlukile. Ngokwesibonelo:
- Esiklasini lesikole, ungasebenzisa igrafu yebha ukuze ubonise futhi uqhathanise nenani labafundi abanezinhlobonhlobo zezinwele ezahlukene. Lapho abafundi abaningi abanombala othile wezinwele, ubude obuningi bwalabo mbala kusegrafu.
- Ungasebenzisa amakholomu anemibala ehlukene ukuze ubonise amakholori e-hamburger eshizi kanye ne-bacon uma kuqhathaniswa nama-calories esitsheni se-beet imifino.
Amabrafu e-bar enza kube lula ukubona umehluko embonweni oqhathaniswayo.
Amashadi webha
Amashadi webha yimiqulu yamakholomu ewile phansi. Imigoqo noma amakholomu asebenza ngokuzungezile eceleni kwekhasi kunokuba avele. Izinhlayiya ziyashintsha futhi-i-axis y yindawo ehambisana nendawo esezansi kweshadi, futhi i-x-axis iqhubekela phezulu ngakwesokunxele.
Amashadi womugqa
Amashadi womugqa , noma amagrafu emigqa, asetshenziselwa ukubonisa izitayela ngokuhamba kwesikhathi. Umugqa ngamunye kugrafu ubonisa izinguquko ekubalukeni kwento eyodwa yedatha.
Njengamanye amagrafu amaningi, amagrafu emigqa ane-axis eqondile kanye ne-axis enezingqimba. Uma uhlela izinguquko kudatha ngokuhamba kwesikhathi, isikhathi sihlelwe eceleni kwe-axis noma x-axis, futhi enye idatha yakho, njengemali yokunwa kwemvula ihlelwe njengamaphuzu ngamanye amaphuzu eceleni noma y-axis.
Uma amaphuzu wedatha ngamanye axhunyiwe ngemigqa, abonisa izinguquko kudatha.
Isibonelo, ungabonisa izinguquko esisisindo sakho esikhathini esiyizinyanga ngenxa yokudla i-hamburger ushizi nosuku nsuku zonke, noma ungahlela ukushintsha kwansuku zonke emanani emakethe. Zingasetshenziselwa ukuhlela idatha eqoshiwe kusuka ekuhlolweni kwesayensi, njengokuthi ikhambi liyakuthinta kanjani izinga lokushisa lokushisa noma ingcindezi yomoya.
Ukuhlakaza amaGrafu
Amagrafu wendawo yokuhlakaza asetshenziselwa ukukhombisa izitayela zedatha. Zisiza kakhulu uma unenombolo enkulu yamaphuzu wedatha. Njengamagrafu elayini, angasetshenziselwa ukuhlela idatha eqoshiwe kusukela ekuhlolweni kwesayensi, njengokuthi ikhambi lithinta kanjani izinga lokushisa lokushisa noma ingcindezi yasemkhathini.
Njengoba amagrafu emigqa axhuma amachashazi noma amaphuzu wedatha ukukhombisa zonke izinguquko, ngenhloso yokuhlakaza udweba umugqa "olungele kakhulu". Amaphuzu wedatha ahlakazekile mayelana nomugqa. Ukusondelana kwamaphuzu wedatha kunomugqa kunamandla okubambisana noma okwenza ushintsho olulodwa lube nolunye.
Uma umugqa olungele ukwedlula ukwanda ukusuka kwesobunxele kuya kwesokudla, isakhiwo sokusabalalisa sibonisa ukulungiswa okuhle kule data. Uma umugqa wehla ukusuka kwesobunxele kuya kwesokudla, kukhona ukulungiswa okungalungile kwedatha.
Amashadi we-Combo
Amashadi we-Combo ahlanganisa izinhlobo ezimbili zamashadi ekuboniseni okukodwa. Ngokujwayelekile, amashadi amabili ayigrafu yomugqa kanye neshadi lekholomu. Ukuze ufeze lokhu, i-Excel isebenzisa i-axe yesithathu ebizwa nge-Y axis yesibili, egijima ngakwesokudla kweshadi.
Amashadi ehlanganiswa angabonisa izinga lokushisa lokushisa kwenyanga nenyanga kanye nedatha yokutshala ndawonye, idatha yokukhiqiza njengamayunithi akhiqizwayo kanye nezindleko zokukhiqiza, noma ivolumu yokuthengisa yanyanga zonke kanye nentengo yokuthengisa yenyanga yonke.
Ama-Pictographs
Ama-Pictographs noma ama-pictograms amashadi ekholomu asebenzisa izithombe ukumela idatha esikhundleni samakholomu ajwayelekile. I-pictograph ingasebenzisa izithombe eziningi ze-hamburger ezibekwe eyodwa ngaphezu kwesinye ukukhombisa ukuthi zingaki amakhilogrekhi eyodwa ushizi kanye ne-bacon hamburger iqukethe uma kuqhathaniswa nesitoreji esincane semifanekiso ye-beet imifino.
Amashadi e-Stock Market
Amashadi e-Stock Market abonisa ulwazi mayelana namasheya noma amasheya afana namanani abo okuvulwa nokuvala kanye nevolumu yamasheya athengiswa ngesikhathi esithile. Kunezinhlobo ezahlukene zamashadi wesitoko atholakalayo ku-Excel. Ngamunye ubonisa ulwazi oluhlukile.
Izinguqulo ezintsha ze-Excel nazo zifaka amashadi we- Surface , amashadi we- XY Bubble (noma ahlakazayo ), namashadi e- Radar .
Ukungeza ishadi ku-Excel
Indlela engcono kakhulu yokufunda ngamashadi ahlukahlukene ku-Excel ukuwazama.
- Vula ifayela le-Excel equkethe idatha.
- Khetha ibanga ofuna igrafu ngokuchofoza ngokuchofoza kusuka kuseli lokuqala kuya kokugcina.
- Chofoza ku- Faka ithebhu bese ukhetha Ishadi kusuka kwimenyu ehlayo.
- Khetha enye yezinhlobo zeshadi kusuka kwimenyu engaphansi. Uma wenza, ithebhu ye- Chart Design ivula ukukhetha okukhethwa kukho uhlobo oluthile lweshadi olikhethile. Yenza okukhethiwe kwakho ubone ishadi livele kudokhumenti.
Cishe kudingeka uzame ukunquma ukuthi yiluhlobo luni leshadi olusebenza kahle ngemininingwane yakho ekhethiwe, kodwa ungabheka izinhlobo ezahlukene zeshadi ngokushesha ukuze ubone ukuthi yini ehamba kahle kuwe.