Zama ngeempendulo ze-Excel kunye negrafu ukubonisa idatha yakho
Iikharati kunye negrafu zibonakalisa ukubonakala kweedatha yomsebenzi. Ngokuqhelekileyo ukwenza kube lula ukuqonda idatha kwiphepha lokusebenzela ngoba abasebenzisi banokukhetha iipatheni kunye nemikhwa enzima ukuba ibone idatha. Ngokuqhelekileyo, iigrafu zisetyenziselwa ukubonisa imizila phezu kwexesha, ngelixa iitshathi zibonisa iipateni okanye ziqulethe ulwazi malunga nobunzima. Khetha i-chart ye-Excel okanye ifomathi ebonisa ngokucacileyo inkcazelo yezidingo zakho.
Iiphathi zePie
Iitshathi zepeyi (okanye ujikeleze iigrafu) zisetyenziselwa ukutshintsha iinguqu enye kuphela ngexesha. Ngenxa yoko, zinokusetyenziswa kuphela ukubonisa ipesenteji.
Isangqa sama-pie amatshati afana neepesenti ezingama-100. Isangqa sihlulwe kwiingcezu ezimele amanani olwazi. Ubungakanani becandelo ngalinye lubonisa ukuba yiyiphi ingxenye yeepesenti ezingama-100 emele.
Iitshathi zeepe zingasetyenziswa xa ufuna ukubonisa ipesenti ethile into emele yechungechunge lwedatha. Njengokuba:
- Inzuzo yenkampani yenyanga nganye ingaboniswa ngetshathi yeepayi njengepesenti yenzuzo yonyaka.
- Umlinganiselo wokubetha umdlali webhola unokwenziwa kuboniswa ngetshathi yepayi ngoba ibonisa ipesenteji yeentsimbi xa kuthelekiswa nenani elipheleleyo le-batshi ngexesha.
- Ipesenti yemali yakho yekhalori yansuku zonke i-cheese enye ne-bacon hamburger imela.
Iikholethi zekholamu
Iikhotshi zekholomu , Kwakhona ziyaziwa njengeigrafu zebar, zisetyenziselwa ukubonisa ukuthelekiswa phakathi kwezinto zolwazi. Ziyinye yeendidi eziqhelekileyo zegrafu ezisetyenziselwa ukubonisa idatha. Iimali ziboniswa ngokusebenzisa ibha yomgca okanye ixande, kunye nekholam nganye kwitshathi imele ixabiso leenkcukacha ezahlukeneyo. Umzekelo:
- Kwinqanaba leklasi, ungasebenzisa igrafu yebhayibhile ukubonisa nokuthelekisa inani labafundi abanemibala eyahlukahlukeneyo yeenwele. Abafundi abaninzi abanombala othile weenwele, umde umdaka waloo mbala usegrafini.
- Ungasebenzisa iikholeji ezinemibala eyahlukeneyo ukubonisa iikhalori kwi-cheese kunye ne-hamburger ye-bacon xa kuthelekiswa neekhalori kwisitya se-beet.
Iigrafu zeBrazi zenza kube lula ukubona ukungafani kwedatha ekuthelekiswa.
Iimpawu zeBhara
Iitshathi zebhale zikhokhethi zekholomu eziwe phantsi. Imivalo okanye iikholomu zihamba ngokukhawuleza kunye nekhasi kunokuba zenzeke. I-axxes iyashintsha ngokunjalo-i-axis i-horizontal axis ngaphantsi kwetshathi, kunye ne-x-axis isebenza ngokubhekiselele kwicala lasekhohlo.
Uluhlu lweMida
Amashadi elayini , okanye iigrafu zomgca, zisetyenziselwa ukubonisa ukuhamba kwexesha. Umgca ngamnye kwigrafu ubonisa utshintsho kwixabiso leminye yedatha.
Ngokufanayo nezinye iigrafu, imagrafu yomgca ine-axis ecacileyo kunye ne-axis ene-horizontal axis. Ukuba uceba ukwenza utshintsho kwixesha elidlulileyo, ixesha lihlelwe ngaphaya kwe-axis okanye x-axis, kwaye enye idatha yakho, njengemali yokunwa kwemvula ihlelwe njengamaphuzu ngamanqaku angama-vertical or y-axis.
Xa iinkcukacha zedatha zixhunywa ngemigca, zibonisa utshintsho kwiedatha.
Ngokomzekelo, ungabonisa utshintsho ubunzima bakho kwiinyanga eziliqela ngenxa yokutya ishizi kunye ne-hamburger yonke imihla yokutya, okanye unokwenza ulungelelaniso lweentsuku zorhwebo kwimpahla. Zingasetyenziselwa ukucwangcisa idatha erekhodwa kwizilingo zesayensi, njengokuthi imichiza iyakwenza njani ukutshintsha kweqondo lokushisa okanye uxinzelelo lwangaphakathi.
Ukutshatyalaliswa kweGrafu
Ukutshatyalaliswa kwegrafu zesalathisi zisetyenziselwa ukubonisa ukuhamba kweedatha. Ziluncedo ngakumbi xa unenani elikhulu leenkcukacha. Njengemagrafu yomgca, angasetyenziselwa ukuqulunqa idatha erekhodwa kwizilingo zenzululwazi, njengendlela ikhemiksi echaphazela ngayo ukutshintsha kweqondo lokushisa okanye ukunyanzeleka kwemoya.
Nangona iigrafu zegrawu zidibanisa amachaphaza okanye amaphupha edatha ukubonisa zonke iinguqu, kunye nenjongo yokuhlakaza ubeka "umgca olungeleyo". Amanqaku edatha ahlakazekile malunga nomgca. Ukusondela kweengongoma zedata kuluhlu oluqinileyo ukulungelelanisa okanye ukususela kwintlobo enye.
Ukuba umgca olungeleyo ophezulu unyuselwa ukusuka kwesobunxele ukuya kwesokudla, isalathisi senkangala sibonisa ukulungelelaniswa okulungileyo kwidatha. Ukuba umgca wehla ukusuka kwesobunxele ukuya kwesokudla, kukho ukulungiswa okungalunganga kwedatha.
Iimpawu zeCombo
Iitshathi zeCombo zidibanisa iintlobo ezimbini ezahlukeneyo zetshathi kwisiboniso esisodwa. Ngokuqhelekileyo, iitshathi ezimbini ziyigrafu yomgca kunye nekhodi yekholomu. Ukufezekisa oku, i-Excel isebenzisa i-axis yesithathu ebizwa ngokuba yi-Y axis yesibili, eqhubela phezulu kwicala.
Iitshathi zokudibanisa zingabonakalisa ubushushu bemitha yenyanga kunye nedatha yenkcazelo kunye, ukuvelisa iinkcukacha ezifana neeyunithi eziveliswe kunye neendleko zemveliso, okanye umthamo wenyanga yokuthengisa kunye nexabiso eliqhelekileyo lokuthengiswa kwenyanga.
Pictographs
Iiptogragraphi okanye iipiktogram zikhokhethi zekholomu ezisebenzisa imifanekiso ukumela idatha endaweni yeekholamu eziqhelekileyo. Ipapotigraph ingasebenzisa imifanekiso yemigodi ye-hamburger ibanjwe enye phezulu kwesinye ukubonisa ukuba zininzi iikhalori enye ishizi kunye ne-bacon hamburger iqulethe i-stack encane yemifanekiso ye-beet imifino.
Iimpawu zeMatriki zeShishini
Iimpawu zeentengiso ze-Stock Market zibonisa ulwazi malunga namasheya okanye izabelo ezifana nezokuvula kunye nokuvala amaxabiso kunye nenani lamasheya athengiswa ngethuba elithile. Kukho iintlobo ezahlukeneyo zeesatifiketi zesitokethi ezikhoyo kwi-Excel. Ngamnye ubonisa ulwazi oluhlukileyo.
Iinguqulelo ezintsha ze-Excel nazo ziquka amashadi e- Surface , i- XY Bubble (okanye i- Scatter ) kunye namashadi e- Radar .
Ukongeza iThart kwi-Excel
Indlela efanelekileyo yokufunda malunga neentlobo ezahlukeneyo kwi-Excel kukuzama.
- Vula ifayile ye-Excel equle idatha.
- Khetha uluhlu ofunayo kwigrafu ngokuchofoza ukutshintshwa ukusuka kwiseli yokuqala ukuya ekugqibeleni.
- Cofa kwi- Insert ithebhu uze ukhethe Ishadi kwi menu ehlayo.
- Khetha enye yeentlobo zeeshati ezivela kwimenyu yangaphantsi. Xa uyenzayo, ithebhu yeTyrt Design ivula ukukhetha ukhetho oluthile lwetadi ozikhethile. Yenza okukhethiweyo kwaye ubone ishati ibonakale kumqulu.
Mhlawumbi kufuneka uhlolisise ukuba uluphi uhlobo lwetshati olusebenza kakuhle ngedatha yakho ekhethiweyo, kodwa unokwazi ukujonga iintlobo ezahlukeneyo zeetati ngokukhawuleza ukuba ubone okubaluleke kakhulu kuwe.