Ubuchopho bomntu bucwangciselwe ukufunda nokutolika iimephu bhetele kunokuhlalutya uthotho lwedatha elungelelaniswe ngokwemiqolo nemiqolo. Yiyo loo nto iigrafu kunye nezinye iindlela zokumela ulwazi zisebenza kakuhle. Kule post siza kubona uyenza njani itshathi yemephu kwi-excel kwaye sifezekise loo mpembelelo ibonwayo esiyifunayo.
Le ndlela yokubonisa ulwazi inokuba luncedo kakhulu ngeendlela ezininzi. Ngaphezu kwakho konke, kuba ukunika umelo ngokwejografi, ebonakalayo ngakumbi, ekhanyisayo kwaye efikelelekayo, apho unokukhapha isifundo okanye umsebenzi wezifundo, okanye nakwindawo yethu yobungcali, xa sisenza intetho kubaphathi bethu, abathengi bethu, njl.
Kunini na xa kufanelekile ukusebenzisa esi sixhobo? Zininzi iimeko ezinokwenzeka, kodwa ngokubanzi ukwenza igrafu yemephu Excel Ilungele kakhulu ukuthelekisa amaxabiso kunye nokubonisa iindidi kunikezelo kwiindawo ezahlukeneyo zejografi. Ingasetyenziswa, umzekelo, xa idatha esifuna ukuyibonisa ihambelana neendawo ezahlukeneyo (amazwe, imimandla, amaphondo, izithili, iikhowudi zeposi, njl.).
Ngaphambi kokuqhubeka nengcaciso, kufuneka kuqatshelwe ukuba kungenzeka ukwenza le mizobo yemephu iyafumaneka ukuqala ngenguqulo ka-2019 yeMicrosoft Excel.
Bonisa amaxabiso okanye iindidi
Iitshathi zemephu ye-Excel zisetyenziselwa ukubonisa amaxabiso omabini (idatha yobungakanani) kunye neendidi (iidatha ezingezizo amanani), ezinemifuziselo eyahlukeneyo ekhoyo. Nje, inkqubo isebenzisa imibala emibini okanye emithathu, ukwazisa ukuguquguquka okukhulu kuzo ukuseka idigri okanye ukwahlula phakathi koluhlu lwedatha. Makhe sibone imizekelo emibini kule mifanekiso ilandelayo: ixabiso kunye negrafu yemephu yodidi:
- Umzekelo 1: Itshathi yamazwe ngokwengeniso yerhafu (ixabiso, imephu yasekhohlo). Apha, ingeniso yerhafu yelizwe ngalinye imelwe yimibala emibini yegradient spectrum. Imibala emnyama imele amaxabiso aphezulu kwaye imibala ekhaphukhaphu imele amaxabiso aphantsi.
- Umzekelo 2: Itshathi yaMazwe ngokweendidi (iindidi, imephu ekunene). Kule meko, iindidi ziboniswa ngentsomi eqhelekileyo ukuchonga iqela ngalinye. Ilizwe ngalinye limelwe ngombala owahlukileyo.
Uyenza njani itshathi yemephu kwi-Excel inyathelo ngenyathelo
Ngokusungulwa kwe Idatha yeJografi kwi-Excel, ukukwazi ukwenza imizobo yemephu yenziwe lula kakhulu. Ngoku kulula ngakumbi, njengoko sichaza ngezantsi. Ukuchaza inkqubo, siya kusebenzisa njengomzekelo ikholomu yedatha apho siza kungena khona amaxabiso eendawo, ezinokuthi zibe, umzekelo, ilizwe, ilizwe, isixeko, njl.
Idatha yeJografi kwi-Excel
Ukuvula olu didi lwedatha kufuneka sikhethe kuphela uluhlu okanye ikholamu yedatha kwaye, kwiribhoni engaphezulu kwephepha, cofa kwi Ithebhu yedatha. Kwimenyu eyehlayo elandelayo, sikhetha "Uhlobo lwedatha" kwaye sikhetha "Ijografi".
Ngale nto, i-Excel iya kuyiguqula ngokuzenzekelayo le datha ibe luhlobo oluyilwe ngokukodwa ukuba lumelwe kamva kwimephu.
Ukwenza imaphu kwidatha
Yongezwe kwikholamu yedatha ikholamu yesibini apho idatha okanye iindidi zifakwe khona, njengoko kunokwenzeka. Ngale nto, ngoku sinayo yonke into eyimfuneko ukwenza igrafu yemephu kwaye sifumane ukumelwa komzobo wedatha.
Ukwenza oku, sinokukhetha nayiphi na iseli ngaphakathi koluhlu lwedatha. Emva koko siya kwithebhu "Faka", apho siqala ukukhetha "Imizobo", ngoko «Iimephu» kwaye ekugqibeleni ukhetho "Imaphu ezaliswe".
Emva koko siya kukwazi ukuphonononga ukubonakala kwemephu eya kuveliswa kwaye, ukuba siyayithanda, qinisekisa ngokuchofoza "Yamkela". Ukuba sifuna ukongeza ixabiso elitsha lejografi kwitheyibhile okanye sicime elinye kwitheyibhile, i-Excel iya kuhlaziya itshathi yemephu edibeneyo ngokuzenzekelayo.
Ukulungelelanisa inkangeleko yemephu
Emva kokudala itshathi yethu yemephu kwi-Excel, sisenokhetho olunomdla lokuhlengahlengisa uyilo lwayo kwizinto esizithandayo kunye nezinto esizikhethayo. Cofa ngokulula kwimephu kwaye usebenzise iinketho zethebhu "Ukwenziwa kwemizobo" (okanye “UkuFomatha” kwiribhoni).
Enye indlela yokwenza itshati yemephu kukucofa kabini kwitshathi ukuze uvule ibhokisi ethi "Format". phikisa". Kuyo, kwikholamu ekunene, uthotho lweenketho luvela:
- Uhlobo lwentelekelelo yemephu. Ngokungagqibekanga, i-Excel iya kukhetha leyo icinga ukuba yeyona isebenzayo.
- Indawo yemephu (ozenzekelayo, jikelele, imimandla enedatha kuphela).
- Iileyibhile zemephu (akukho nanye, bonisa zonke, kuphela eyona ifanelekileyo).
- umbala (i-flat okanye ngokulandelelana ngemibala emi-2 okanye emi-3).
Ezinye iinkcukacha malunga neegrafu zemephu kwi-Excel
Nje ukuba indlela esemgangathweni yokwenza ezi tshathi kwi-Excel icacisiwe, kufuneka sikhankanye iimeko ezithile esinokudibana nazo kunye nendlela yokuzisombulula:
- Ukuba sisebenza kunye idatha enokuba nendawo engaphezu kwendawo enyea, kuya kufuneka songeze uluhlu oluphezulu lweenkcukacha kwidatha.
- Kuya kufuneka sibe noqhagamshelo lwe-intanethi ukuba sifuna ukwenza iimephu ezintsha okanye Fakela idatha kwiimephu ezikhoyo.
- Imizobo yemephu ivumela kuphela umboniso onedimensional enye. Ukufumana into ephucukileyo kufuneka usebenzise umsebenzi Excel 3D Map.