Enye yezinto ezikhangayo kakhulu kwiprogram ye-spreadsheet Microsoft 365 kukukwazi ukwenza iigrafu kwidatha. Oku kusinika indlela esebenzayo nebonakalayo yokutolika ulwazi kunye nokwenza izigqibo kulo. Kule post siza kuchaza indlela yokwenza iitshathi kwi-Excel kwitafile kwaye usebenzise zonke ezi nzuzo.
I-Excel ibonelela ngeentlobo ezilishumi ezahlukeneyo zeetshathi, ukwenzela ukugubungela abona mathuba aphezulu kunye namatyala okusebenzisa. Okulandelayo, siza kuqala sihlalutye nganye kuzo kwaye emva koko siya kuchaza indlela yokuvelisa.
Iintlobo zeetshathi ze-Excel
Kukho uluhlu olubanzi lweetshathi esinokuzisebenzisa kwi-Excel. Kukho uhlobo lwetshati olufanelekileyo kudidi ngalunye lwetheyibhile kunye nomxholo ngamnye:
- Ikholamu kunye neetshathi zebha, i-classic typology. Ziyakwazi zombini nkqo kunye tye.
- Histograms. Ngokufana neegrafu zebar, kunye nomahluko wokuba, endaweni yokuphatha amaxabiso e-X-axis, amele ukuhanjiswa kwamaxesha amaninzi.
- Iitshathi zomgca. Bazoba umgca wokujoyina amaxabiso ahamba ecaleni kwe-X (ethe tye) i-axis, kunye neencopho ezimele ukwanda kunye neentlambo ezimele ukuncipha.
- Iitshathi zendawo. Ngokufana nemigca, kuphela inxalenye engezantsi ye-stroke izaliswe ngumbala.
- Iitshati zolawulo lwemigangatho, ekwabizwa ngokuba yi "rectangle graphs." Basebenza ukuthelekisa umthamo, ubungakanani okanye ubuninzi bezinto eziguquguqukayo ngokubhekiselele kwabanye.
- Iitshathi zeengxangxasi. Zisetyenziselwa ukubonisa utshintsho kumanani ngokudibanisa kunye nokuthabatha ezinye izixa ngokulandelelanayo, mhlawumbi ngokuhamba kwexesha okanye kwiindidi ezahlukeneyo.
- Ipayi okanye iitshati zedonathi. Zifaneleke kakhulu ukumela iipesenti kunye nemilinganiselo.
- ukusasaza iindawo, ekwabizwa ngokuba "amaqamza." Amanqaku amaninzi aphawulwe kuzo ecaleni kwee-axes zika-X no-Y.
- Imizobo engaphezulu okanye iigrafu zeradial. Zintsonkothe ngakumbi. Zisetyenziselwa ukubonisa iimpawu ezahlukeneyo kunye neempawu zamaxabiso ahlukeneyo kumelo olufanayo.
- Imizobo edibeneyo. Njengoko igama layo libonisa, kubandakanya ukudibanisa iintlobo ezimbini okanye ngaphezulu zeegrafu ukuseka ubudlelwane phakathi kwezinto ezahlukeneyo.
Yenza iitshathi kwi-Excel kwitheyibhile
Ngoku makhe sibone ukuba unokwenza njani na iigrafu kwi-Excel esekwe kwidatha ekwitafile, inyathelo ngenyathelo:
Inyathelo 1: Lungisa itafile
Into yokuqala ekufuneka siyenze ukuze igrafu esifuna ukuyenza ichanekile kukuqinisekisa ukuba idatha equlethwe kwitafile icwangciswe kakuhle: Iikholamu kufuneka zibe nezihloko kwaye idatha kufuneka ibonakale icwangcisiwe ukwenzela ukuba ukumelwa kwayo okulandelayo kwigrafu kube nengqiqo.
Emva koko sinako khetha idatha esifuna ukuyifaka kwigrafu, kunye nokwenza isigqibo sokuba sifuna iiheader zetafile zivele. Ukuba ufuna ukwenza igrafu ngenxalenye kuphela yedatha yetafile, kuya kufuneka ukhethe iiseli eziqulethe idatha okanye ucofe kwaye uzitsalele kwimigca efanelekileyo kunye neekholamu.
Inyathelo lesi-2: Veza igrafu
Emva kokulungiselela itafile kunye nokukhetha idatha, lixesha lokudala itshathi. Ukwenza oku kufuneka siye kwiribhoni ye-Excel kwaye ucofe ithebhu "Faka". Xa usenza oku, ibhokisi ibonakala inazo zonke iintlobo zetshathi ezikhoyo: iikholamu, iipayi, ibha, njl.
Ukukhetha esiyifunayo, sicofa kudidi lwegrafu olulungele iimfuno zethu. Ngale nto, i-Excel iya kufaka ngokuzenzekelayo itshati kwi-spreadsheet.
Inyathelo lesi-3: Lungiselela itshathi
Ngegrafu esele yenziwe, sinokuyinika imilo esithanda kakhulu okanye enomdla kuthi kakhulu kwi "Uyilo lweTshati" ithebhu. Ukhetho lwahluke kakhulu: tshintsha isihloko, guqula imibala okanye izimbo, yongeza iilebhile zedatha kwaye utshintshe nohlobo lwegrafu, ukuba sitshintshe ingqondo yethu.
Ngokufanayo, siya kukwazi ukuhlela ii-axes ukulungisa isikali okanye ifomathi yamanani, kunye nokuhambisa, ukuhlela okanye ukucima i-legend yegrafu. Ukongeza, zonke iinguqu esizenzayo kwitafile ziya kuhlaziywa ngokuzenzekelayo.
Un iqhinga Kuyathakazelisa xa udala iigrafu kwi-Excel ukuthatha iingcebiso kwinkqubo ngokwayo. Oko kuthetha ukusebenzisa ukhetho "Iigraphics ezicetyiswayo" ukuba isicelo sicebisa kuthi ngokusekelwe kwisakhiwo sedatha esiyifake kwitheyibhile.
Isiphelo
Akukho ngxoxo malunga nokukwazi kweegrafu ukumela idatha ngendlela esebenzayo kwaye kulula ukuba ingqondo yomntu iqonde. Njengokulunga okongeziweyo, kufuneka kukhankanywe ukuba sisixhobo esihle sokwabelana ngezimvo nabanye abantu, ukuqonda ngcono ulwazi kunye nokwenza izigqibo ezisekelwe kulwazi olugqithisiweyo.
Ubume bedatha kunye nobungakanani bayo, kunye nezinto esizikhethayo, ziya kuba yimiba ebonisa ukuba loluphi uhlobo lwetshathi ye-Excel ekufuneka siyisebenzise.