Okuqukethwe
Ku-Microsoft Office Excel, ungakha ngokushesha ishadi ohlwini lwethebula elihlanganisiwe ukuze ubonise izici zalo eziyinhloko. Kuyisiko ukwengeza inganekwane emdwebeni ukuze uveze imininingwane evezwe kuwo, ubanikeze amagama. Lesi sihloko sizoxoxa ngezindlela zokwengeza inganekwane eshadini ku-Excel 2010.
Ungalakha kanjani ishadi ku-Excel kusuka etafuleni
Okokuqala udinga ukuqonda ukuthi umdwebo wakhiwe kanjani ohlelweni okukhulunywa ngalo. Inqubo yokwakhiwa kwayo ihlukaniswe ngokwemibandela ibe yizigaba ezilandelayo:
- Kuthebula lomthombo, khetha ububanzi obufunekayo bamaseli, amakholomu ofuna ukubonisa ukuncika kuwo.
- Iya kuthebhu ethi “Faka” kukholamu ephezulu yamathuluzi emenyu enkulu yohlelo.
- Ebhulokhini elithi "Imidwebo", chofoza kokukodwa kokukhethwa kukho kokumelwa kwesithombe kwamalungu afanayo. Isibonelo, ungakhetha ishadi likaphayi noma ishadi lebha.
- Ngemva kokuqeda isinyathelo sangaphambilini, iwindi elineshadi elakhiwe kufanele livele eduze kwepuleti lokuqala ekhasini lokusebenzela le-Excel. Izobonisa ubudlelwano phakathi kwamanani akhethiwe ohlwini. Ngakho-ke umsebenzisi uzokwazi ukuhlola ngokubonakalayo umehluko wamanani, ahlaziye igrafu futhi afinyelele isiphetho kuwo.
Nakani! Ekuqaleni, ishadi "elingenalutho" lizokwakhiwa ngaphandle kwelejendi, ilebula yedatha, kanye nenganekwane. Lolu lwazi lungangezwa eshadini uma uthanda.
Indlela yokwengeza inganekwane eshadini ku-Excel 2010 ngendlela evamile
Lena indlela elula kakhulu yokwengeza inganekwane futhi ngeke kuthathe umsebenzisi isikhathi esiningi ukuze ayisebenzise. Ingqikithi yendlela ukwenza lezi zinyathelo ezilandelayo:
- Yakha umdwebo ngokulandela uhlelo olungenhla.
- Ngenkinobho yegundane engakwesokunxele, chofoza isithonjana esiphambanayo esiluhlaza kubha yamathuluzi kwesokudla seshadi.
- Efasiteleni lezinketho ezitholakalayo ezivulayo, eduze komugqa othi "Legend", khetha ibhokisi ukuze uvule umsebenzi.
- Hlaziya ishadi. Amalebula wezakhi asuka ohlwini lwangempela lwethebula kufanele engezwe kulo.
- Uma kunesidingo, ungashintsha indawo yegrafu. Ukuze wenze lokhu, chofoza kwesokunxele ku-legend bese ukhetha enye inketho yendawo yayo. Isibonelo, Kwesobunxele, Phansi, Phezulu, Kwesokudla, noma Phezulu Kwesobunxele.
Ungawushintsha kanjani umbhalo wenganekwane eshadini ku-Excel 2010
Amagama-ncazo enganekwane angashintshwa uma efunwa ngokusetha ifonti nosayizi ofanele. Ungakwenza lokhu ngokulandela imiyalelo engezansi:
- Yakha ishadi bese wengeza inganekwane kulo ngokuya nge-algorithm okuxoxwe ngayo ngenhla.
- Shintsha usayizi, ifonti yombhalo ohlwini lwangempela lwethebula, kumaseli okwakhiwe kuwo igrafu ngokwayo. Lapho ufometha umbhalo kumakholomu ethebula, umbhalo ku-legend yeshadi uzoshintsha ngokuzenzakalelayo.
- Hlola umphumela.
Kubalulekile! Ku-Microsoft Office Excel 2010, kuyinkinga ukufometha umbhalo wenganekwane eshadini ngokwalo. Kulula ukusebenzisa indlela ecatshangelwayo ngokushintsha idatha yohlu lwethebula okwakhiwe kulo igrafu.
Ligcwaliswa kanjani ishadi
Ngaphezu kwenganekwane, kukhona eminye imininingwane engaboniswa esakhiweni. Ngokwesibonelo, igama lakhe. Ukuqamba into eyakhiwe, kufanele uqhubeke kanje:
- Yakha umdwebo ngokwepuleti lokuqala bese uya kuthebhu ethi “Isakhiwo” phezulu kumenyu eyinhloko yohlelo.
- Ifasitelana Lamathuluzi Eshadi liyavuleka, kunezinketho ezimbalwa ezitholakalayo zokuhlela. Kulesi simo, umsebenzisi udinga ukuchofoza inkinobho ethi "Igama Leshadi".
- Ohlwini oluya phansi lwezinketho, khetha uhlobo lokubekwa kwesihloko. Ingafakwa phakathi nendawo ngokugqagqana, noma ngaphezu kweshadi.
- Ngemva kokwenza ukukhohlisa kwangaphambilini, ishadi elihleliwe lizobonisa umbhalo othi "Igama Leshadi". Umsebenzisi uzokwazi ukulishintsha ngokubhala mathupha noma iyiphi enye inhlanganisela yamagama asuka kukhibhodi yekhompuyutha afana nencazelo yohlu lwangempela lwethebula.
- Kubalulekile futhi ukulebula izimbazo eshadini. Asayinwa ngendlela efanayo. Kubhulokhi yokusebenza ngamashadi, umsebenzisi uzodinga ukuchofoza inkinobho ethi "Amagama e-eksisi". Kuhlu lokudonsela phansi, khetha i-eksisi eyodwa: imile noma ivundlile. Okulandelayo, yenza ushintsho olufanele lwenketho ekhethiwe.
Ulwazi Olwengeziwe! Ngokohlelo okukhulunywe ngalo ngenhla, ungakwazi ukuhlela ishadi kunoma iyiphi inguqulo ye-MS Excel. Nokho, kuye ngonyaka isofthiwe ekhishwe ngawo, izinyathelo zokusetha amashadi zingahluka kancane.
Enye Indlela Yokushintsha Ilejendi Yeshadi ku-Excel
Ungahlela umbhalo wamalebula eshadini usebenzisa amathuluzi akhelwe ohlelweni. Ukuze wenze lokhu, udinga ukulandela izinyathelo ezimbalwa ezilula ngokuya nge-algorithm:
- Ngenkinobho yegundane engakwesokudla, chofoza igama elidingekayo lenganekwane kumdwebo owakhiwe.
- Ewindini lohlobo lokuqukethwe, chofoza umugqa othi "Izihlungi". Lokhu kuzovula iwindi Lokuhlunga Ngokwezifiso.
- Chofoza inkinobho ethi Khetha Idatha ezansi kwefasitela.
- Kumenyu entsha ethi "Khetha Imithombo Yedatha", kufanele uchofoze inkinobho ethi "Hlela" ebhulokhini elithi "Legend Elements".
- Ewindini elilandelayo, esikhaleni esithi “Igama Lomugqa”, faka igama elehlukile lesici esikhethwe ngaphambilini bese uchofoza okuthi “KULUNGILE”.
- Hlola umphumela.
Isiphetho
Ngakho-ke, ukwakhiwa kwenganekwane ku-Microsoft Office Excel 2010 ihlukaniswe ngezigaba eziningana, ngayinye okufanele ifundwe ngokuningiliziwe. Futhi, uma uthanda, ulwazi oluseshadini lungahlelwa ngokushesha. Imithetho eyisisekelo yokusebenza ngamashadi ku-Excel ichazwe ngenhla.