Uzenza njani iitshathi zobuNgcali kunye neSitayile kwi-Excel

Ukusetyenziswa kweenkqubo ezifana ne-Excel kuxhaphake, zombini kwinkalo yemfundo kunye nasemsebenzini. Kubafundi kunye neengcali, yenza iitshathi kwi-excel yindlela ebonwayo nesebenzayo yokunikezela ngedatha kunye neenkcukacha zakho ukwenza izigqibo okanye ukwenza izigqibo ngokusekelwe kuzo.

Kuboniswa ukuba nayiphi na ukufakwa okanye ukumelwa kwedatha yeenkcukacha-manani Isebenza ngakumbi ukuba yenziwe ngemizobo elungileyo. Okukhona ukubetha kwaye eciko, kokukhona kungcono. Ngesi sizathu, ukwazi ukuyila le mizobo kwaye uyibonise ngokufanelekileyo kunokwenza umahluko phakathi kwempumelelo okanye ukusilela kumboniso okanye umsebenzi.

Kodwa ngaphambi kokuphonononga ubuhle kunye nokubonakala okunokwenzeka kwezi grafu, kuyafuneka ukuba uzazi kakuhle iigrafu ezisinika zona. Excel kunye nendlela yokuphatha idatha ukuze iigrafu zitolike ngokuchanekileyo nangempumelelo:

Iintlobo zeetshathi ze-Excel

Injongo yegrafu ayikho enye ngaphandle kokubonisa ulwazi oluthile ngendlela ebonwayo neshwankathelweyo. Ngale ndlela kulula ukutolika oko kuboniswa yidatha kwaye wenze inkqubo yokuthatha isigqibo ibe lula. Ezi ziziphakamiso i-Excel isinika zona:

Igrafu yebar

Yenye yezona zisetyenziswa kakhulu, kuba ngazo umntu oyijongileyo ufumana ulwazi oluninzi ngendlela eshwankathelweyo ngokukrwaqula nje okukodwa. Ulwakha njani olu hlobo lweegrafu? Kufuneka ulandele la manyathelo:

1. Okokuqala, kuya kufuneka khetha kwiphepha lokugqwesa idatha ukuba sifuna ukubonakalisa kwitshathi yebha kwaye sizikhuphele kwibhodi eqhotyoshwayo.
2. Emva koko sicofa "faka" emva koko sikhethe "Iigraphics ezicetyiswayo", apho iinketho ezahlukeneyo ziyakuboniswa kwibar esecaleni ekhohlo. Kule meko sikhetha i imivalo.
3. I-Excel iya kubeka idatha ekhutshelwe kwibhodi eqhotyoshwayo kwiphepha lomsebenzi kwitshathi yebha.

Nje ukuba itshati yenziwe, sinokuyitshintsha ubungakanani bayo, siyise kwiindawo ezahlukeneyo ngaphakathi kwephepha, kwaye siyikhuphele kwiphepha lomsebenzi elahlukileyo. Ungatshintsha kwakhona isihloko setshathi ngokucofa kabini kuyo kwaye uchwetheze igama elitsha.

Kodwa kuba sifuna ukuba itshati ibe nesitayile kwaye ijonge ngobuchwephesha, kufuneka sisebenzise ezinye herramientas ukuphucula. Umzekelo, unokutshintsha umbala kunye nesimbo sebhari yebhari ngolu hlobo:

Sikhetha itshathi yethu yebha ye-Excel kwaye ucofe ithebhu ye "tshintsha imibala", edla ngokumelwa yi icon yebrashi ngasekunene kwegrafu xa sicofa kuyo. Imenyu evelayo iyasivumela khetha isitayile sezithambiso esahlukileyo somzobo. Hambisa nje phezu kwayo kwaye uhambise imouse yakho phezu kwesimbo ngasinye ukuyijonga.

Xa iikholomu zitshintsha i-orientation, ziba yimivalo. A igrafu yebar inokuboniswa kwifom edibeneyo okanye ipakishwe okanye idibanise i-100% yedatha emelwe. Olu khetho lunokuba yindlela esebenzayo kakhulu yokumela udidi oluthile lwedatha kuluntu.

Igrafu yomgca

Olu hlobo lwetshati lusetyenziswa kakhulu. ukubona iintsingiselo xa usebenza ngexabiso elininzi. Kule meko, ibha okanye iitshathi zekholomu azanelanga, njengoko zingafundeki. Endaweni yoko, igrafu yomgca inika ulwazi oluqokelelweyo ngokufanelekileyo.

Nantsi indlela oyila ngayo igrafu yomgca nge-Excel:

1. Okokuqala, sifaka idatha esifuna ukuyimela kwigrafu kwitafile ye-Excel kwaye siyikhethe.
2. Emva koko siye kwibar yokukhetha, kwithebhu "Faka".
3. Apho sikhetha "Yenza igrafu yomgca" kwi Excel.
4. Iinketho ezahlukeneyo ziyaboniswa, zadityaniswa iindidi ezimbini: 2D kunye 3D. Zombini indawo kunye nomgca. Imalunga nokukhetha eyona inomdla kuthi kakhulu.

Los iitshathi zendawo ziyindlela engenye yokumela itshathi yomgca ngelixa idibanisa i-punch ebonakalayo yebar okanye iitshathi zekholomu.

Ipayi okanye itshathi yedonathi

Omnye weyona mizobo idumileyo, ngakumbi eboniswe ukumela unikezelo lwepesenti, umzekelo. I iitshathi zephayi bonisa ubungakanani beziqalelo zoluhlu lwedatha ngokomlinganiselo wezinto. Ngaloo ndlela, idatha engaphelelanga kwitshathi yephayi iboniswa njengepesenti yetshathi yephayi.

Kucetyiswa ukuba usebenzise ezi tshathi xa kungekho xabiso lingaphezulu kwesixhenxe kwaye akukho nalinye elinoziro okanye elibi. Njengakwezinye iinketho, zinokuveliswa kuzo zombini iifomati ze-2D kunye ne-3D.

Abanye abantu bakhetha (yinto yokungcamla) ukusebenzisa i itshathi yedonut njengolunye uhlobo okanye enye indlela kwitshathi yephayi. Njengale nto, isebenza ukubonisa ubudlelwane bamacandelo kunye ngokupheleleyo, nangona inokuthi iqulethe ngaphezu koluhlu lwedatha. Nangona kunjalo, azibonakali okanye kulula ukuzitolika njengezokuqala.

Ukusasaza itshati kunye namaqamza

Kwaziwa njenge XY Uhlobo lweTshati, i-dispersiones isinceda ukuba sibambe idatha ehlelwe kwiikholamu kunye nemigqa yespreadsheet. Beka amaxabiso X kumqolo okanye kwikholamu enye kunye namaxabiso ahambelanayo kaY kwimiqolo ekufutshane okanye kwikholamu.

Enkosi kumthombo weeasi ezimbini zexabiso (i-axis engu-X ethe tyaba kunye ne-Y ethe nkqo), kuyenzeka ukumela izithuba ezingaqhelekanga okanye amaqela, into engenakwenzeka ngezinye iigrafu kolu luhlu. Iindawo zokuchithachitha zisetyenziswa ngokubanzi kwiinkalo zenzululwazi kunye nezibalo. Zinokudibaniswa kunye nemigca eqondileyo okanye egobileyo edibanisa amanqaku ahlakazekileyo abonisa iindlela.

Kwelabo icala, iitshathi iqamza ziyindlela ebonwa ngakumbi yokuphuhlisa iploti yokuchithachitha. La maqamza anokumelwa kwi-2D okanye kwi-3D, ene-axis yobunzulu ebenza babukeke njengeengqukuva zokwenyani kwiscreen sethu.

Itshati yesitokhwe

Idume kakhulu kwihlabathi lezoqoqosho kunye nezezimali, apho ikwabizwa ngokuba yi itshathi yesibane. Njengoko igama layo libonisa, ezi tshathi zifanelekile ekuboniseni ukuguquguquka kwexabiso lempahla, yingakho zisetyenziselwa kwi-market market, nangona oku kungekuphela kokusetyenziswa kwazo.