Xa usenza naluphi na uhlobo lwegrafu (ngokusekwe kwidatha eguquguqukayo), ubalo olunokwenzeka, uphicotho, ukukhangela phakathi kwamaphepha ahlukeneyo, ukukhangela amaxabiso aphakathi ... okanye ngokulula itafile apho sichaza khona idatha esifuna ukuyilungisa, IMicrosoft Excel sesona sisombululo sisiso kwintengiso namhlanje. Kwaye okwangoku, kuya kuqhubeka kunjalo iminyaka emininzi.
Nangona kuyinyani ukuba kwintengiso sinokufumana ngeendlela ezahlukeneyo zasimahla ngokupheleleyo, njengeOfisi yeLibre okanye iiNombolo zeApple, inani lemisebenzi entsonkothileyo alisondelanga kuleyo sinikwa yi-Excel. Ukwenza iitafile kwi-Excel ukuziguqula zibe yigrafu yinkqubo elula kakhulu. Kuthekani ukuba asizithandi iziphumo zegrafu? Olona khetho lufanelekileyo kwezi meko kukutshintsha imiqolo yeekholamu.
Nangona kunokubonakala ngathi kusisiyatha, ukuba sitshintsha ulwazi lwemiqolo yeekholamu, igrafu enesiphumo kunokuba lula ukuyiqonda, ayenzeli thina kuphela, kodwa ikwanabo bafanele ukulufunda olu xwebhu kuthethwa ngalo. Izinto zinokuba nzima xa inani lemiqolo kunye neekholamu liphezulu kakhulu, kuba kungasithatha ixesha elininzi, ngaphandle kokuba sisebenzisa umsebenzi osinikwa yi-Excel ukuba siyenze ngokuzenzekelayo.
- Okokuqala, kufuneka Khetha itafile apho sifuna ukuguqula imiqolo ngokweekholamu. Ukwenza oku, kuya kufuneka ucofe imouse kwiseli yokuqala apho izihloko zedatha yekholamu kunye nomqolo esifuna ukutshintshiselana kuwo siwuse kwixabiso lokugqibela letafile.
- Emva koko, siya ngaphezulu kukhetho kunye nemouse kwaye ucofe ekunene ukuya Khuphela umxholo kwibhodi eqhotyoshwayo.
- Emva koko, siya kwiseli apho sifuna ukwenza itafile entsha enemigca kunye neekholamu eziguqulweyo kwaye sibeka imouse apho sifuna ukuba itafile iqale khona. Ngeli xesha, kufuneka siye phezulu kwimenyu ye-Excel kwaye ucofe kwi unxantathu ongeneyo oboniswe kwi Cola iqhosha. Olu khetho lusinika ukhetho olukhethekileyo lwegluing esisinikwa sisicelo.
- Ukuze sikwazi ukuncamathisela umxholo, kodwa sitshintsha imiqolo ngokweentsika, kufuneka sicofe Ukutshintsha.
Ukuba ukhe wazibuza ukuba loluphi ukhetho lweTranspose, sele unayo impendulo. Njengoko sinakho kumfanekiso ophambili kweli nqaku, lo msebenzi uya kuba kukulawula ukuhambisa amaxabiso ekholamu kunye nemiqolo ukuze zilungelelanise nolwabiwo lwethu esele silwenzile.