Ubuchopho bomuntu buhlelelwe ukufunda nokuhumusha amamephu kangcono kakhulu kunokuhlaziya uchungechunge lwedatha ehlelwe ngemigqa namakholomu. Kungakho amagrafu nezinye izindlela zokumela ulwazi zisebenza kahle. Kule post sizobona ulenza kanjani ishadi lemephu ku-excel futhi sizuze lowo mthelela obonakalayo esiwufunayo.
Le ndlela yokwethula ulwazi ingaba usizo kakhulu ngezindlela eziningi. Ngaphezu kwakho konke, ngoba ukunikeza ukumelwa kwendawo, okubonakala kakhudlwana, okukhanyiselayo futhi okuthengekayo, ongaphelezela ngakho isifundo noma umsebenzi wezemfundo, noma futhi endaweni yethu yobungcweti, lapho senza izethulo kubaphathi bethu, amakhasimende ethu, njll.
Kunini lapho kufaneleka khona ukusebenzisa lesi sisetshenziswa? Ziningi izimo ezingaba khona, kodwa ngokujwayelekile ukudala igrafu yemephu kuyo Excel Ifaneleka kakhulu ukuqhathanisa amanani kanye nokubonisa izigaba ekusabalaliseni ezindaweni ezihlukene zendawo. Ingasetshenziswa, isibonelo, uma idatha esifuna ukuyethula ihlobene nezindawo ezahlukene (amazwe, izifunda, izifundazwe, izifunda, amakhodi eposi, njll.).
Ngaphambi kokuqhubeka nencazelo, kufanele kuqashelwe ukuthi ithuba lokudala le mifanekiso yemephu liyatholakala kusukela ngenguqulo 2019 ye-Microsoft Excel.
Bonisa amanani noma izigaba
Amashadi emephu e-Excel asetshenziselwa ukubonisa kokubili amanani (idatha yobuningi) nezigaba (idatha okungezona izinombolo), anamamodeli ahlukene atholakalayo. Ngenjwayelo, uhlelo lusebenzisa imibala emibili noma emithathu, yethula ukuhluka kokuqina kuzo ukuze kutholwe amadigri noma ukuhlukaniswa phakathi kobubanzi bedatha. Ake sibone izibonelo ezimbili ezithombeni ezilandelayo: inani negrafu yemephu yesigaba:
- Isibonelo 1: Ishadi Lamazwe ngemali engenayo yentela (amanani, imephu engakwesokunxele). Lapha, imali yentela yezwe ngalinye imelelwa i-spectrum yemibala emibili. Imibala emnyama imele amanani aphezulu futhi imibala ekhanyayo imele amanani aphansi.
- Isibonelo sesi-2: Ishadi Lamazwe ngezigaba (izigaba, imephu kwesokudla). Kulesi simo, izigaba ziboniswa nge-legend ejwayelekile ukukhomba iqembu ngalinye. Izwe ngalinye limelwe ngombala ohlukile.
Indlela yokudala ishadi lemephu ku-Excel isinyathelo ngesinyathelo
Ngokwethulwa kwe- Idatha yeJografi ku-Excel, ikhono lokudala ihluzo zemephu lenziwe laba lula kakhulu. Manje isilula kakhulu, njengoba sichaza ngezansi. Ukuze sichaze inqubo, sizosebenzisa njengesibonelo ikholomu yedatha lapho sizofaka khona amanani ezindawo, okungaba, isibonelo, izwe, isifunda, idolobha, njll.
Idatha yeJografi ku-Excel
Ukwenza lesi sigaba sedatha sisebenze kufanele kuphela sikhethe uhlu noma ikholomu yedatha futhi, kuribhoni phezulu ekhasini, uchofoze Ithebhu yedatha. Kumenyu yokudonsela phansi elandelayo, siyakhetha "Uhlobo lwedatha" bese sikhetha "Geography".
Ngalokhu, i-Excel izoguqula ngokuzenzakalelayo le datha ibe uhlobo oluklanyelwe ngokukhethekile ukumelwa kumephu.
Ukudala imephu kusuka kudatha
Kwengezwe kukholomu yedatha ikholomu yesibili lapho kufakwa khona idatha noma izigaba, njengoba kungaba njalo. Ngalokhu, manje sesinakho konke okudingekayo ukuze sakhe igrafu yemephu futhi sithole ukumelwa okungokomfanekiso kwedatha.
Ukwenza lokhu, singakhetha noma iyiphi iseli ngaphakathi kwebanga ledatha. Bese siya kuthebhu "Faka", lapho siqala ukukhetha khona "Imidwebo", khona-ke «Amamephu» futhi ekugcineni inketho "Imephu egcwele".
Bese sizokwazi ukubuyekeza ukubukeka kwemephu ezokhiqizwa futhi, uma siyithanda, siqinisekise ngokuchofoza "Yamukela". Uma sifuna ukwengeza inani elisha lendawo etafuleni noma sisuse elilodwa kuthebula, i-Excel izobuyekeza ishadi lemephu elixhunyiwe ngokuzenzakalelayo.
Ukwenza ngokwezifiso ukubukeka kwemephu
Ngemuva kokudala ishadi lethu lemephu ku-Excel, sisenezinketho ezithokozisayo zokulungisa ukwakheka kwalo kuzinto esizithandayo nezithandwayo. Vele uchofoze kumephu bese usebenzisa izinketho zethebhu "Umklami we-graphic" (noma “Fometha” kuribhoni).
Enye indlela yokwenza ngokwezifiso ishadi lemephu ukuchofoza kabili eshadini ukuze uvule ibhokisi elithi "Fometha". phikisa". Kuyo, kukholamu engakwesokudla, kuvela uchungechunge lwezinketho:
- Uhlobo lokuqagela kwemephu. Ngokuzenzakalelayo, i-Excel izokhetha leyo eyibona iphumelela kakhulu.
- Indawo yemephu (okuzenzakalelayo, umhlaba jikelele, izifunda ezinedatha kuphela).
- Amalebula emephu (akekho, bonisa konke, ukulingana okuhle kuphela).
- Color (flat noma ngokulandelana ngemibala emi-2 noma emi-3).
Eminye imininingwane ngamagrafu emephu ku-Excel
Uma indlela ejwayelekile yokudala la mashadi ku-Excel isichaziwe, kufanele sisho ezinye izimo esingase sihlangabezane nazo nokuthi singazixazulula kanjani:
- Uma sisebenzisana idatha engase ibe nendawo engaphezu kweyodwa yendawoa, kuzodingeka sengeze ikholomu yemininingwane yezinga eliphezulu kudatha.
- Kuzodingeka sibe noxhumano lwe-inthanethi uma sifuna ukudala amamephu amasha noma engeza idatha kumamephu akhona.
- Imifanekiso yemephu ivumela kuphela isibonisi sohlangothi olulodwa. Ukuze uthole okuthile okuyinkimbinkimbi kufanele usebenzise umsebenzi Imephu ye-3D ye-Excel.