Ungayenza kanjani ishadi lekholomu ku-Excel

Ukukhetha nokukhetha kweshadi lekholomu eshidini

Kuze kube manje, alukho uhlobo oluhlukile lwemidwebo e-Excel, ngakho-ke kufanele ukhethe inketho efanelekile ohlwini olujwayelekile, unaka izinto ezifanayo. Ukuze wenze lokhu, kuzodingeka ukuvula uhlu lwawo wonke amashadi bese uzijwayeza ngesethulo sabo.

1. Uma kunesidingo, qokomisa itafula lapho kwakhiwa khona uhlelo, futhi uma kungedwa ephepheni, iya kuthebhu "Insert".



2. Chofoza inkinobho ethi "Izincomo Ezinconyiwe" ukubonisa uhlu olufunayo.



3. Ngokushesha vula ithebhu ethi "All All Chart", ngoba uhlu olunconyiwe alukhombisi zonke izifanekiso ezikhona. Okokuqala, bhekisisa uhlobo lwe- "Histogram" yohlobo, okuyinto ebaluleke kakhulu.



4. Nquma uhlobo lokwakha futhi unqume ukuthi kuzoba yisibalo esikhulu noma imigqa elula.



5. Hambisa isikhombisi ngaphezulu kwelinye lamashadi ukubuka ukusebenza kwalo bese unquma ukuthi kufanelekile yini etafuleni.



6. Qhafaza kabili inkinobho yegundane kwesobunxele ngokuya ngenketho, ngemuva kwalokho izongezwa ngokuzenzakalelayo eshidini, futhi ungaqhubeka nokuhlela umdwebo.

Lapho ukhetha umdwebo, unake futhi nokuthi amanani etafula azoboniswa kanjani ukuze ufunde into, okuqukethwe kuyo kuyaqondakala ngokushesha futhi kubukwa. Kuze kube manje, kungahle kudingekile ukukhetha olunye uhlobo lweshadi, ngokwesibonelo, "ukushintshana", okuzokhombisa izifundo zokunyusa noma zezimali.

Lokhu kufaka nohlobo "oluhlanganisiwe" - uma kungazelelwe umdwebo akufanele kube yikholimu kuphela, kepha bonisa amanye amagrafu, njengamaphuzu noma imigqa evundlile.

Ukuhlela okuqukethwe komdwebo

Ngamafuphi, sizokwazi ukuhlaziya izilungiselelo ezijwayelekile zomdwebo ngemuva kokuthi ingezwe eshidini, ngokubheka ukuhlela okuqukethwe. Imvamisa kwakha ama-axes asizayo noma amanani edikithi ngandlela thile akudingekile, kepha uma kunesidingo, uzovele wazi zonke izenzo ezidingekayo zokubulawa.

1. Yicacise ngegama elihambisanayo elichaza inhloso ejwayelekile yomdwebo. Gqamisa ibhlokhi nombhalo, susa umbhalo wamanje bese ufaka uphikisayo.



2. Uma udinga ukuhlela enye yama-axes, chofoza kuyo kabili ukubonisa imenyu ehambisanayo. Lapho, ungashintsha usayizi wemingcele kanye nokwahlukana, engeza i-axis ezayo noma wenze ngokwezifiso inani lentengo lokuboniswa okubukwayo kwamanani.



3. Lapho uchofoza kabili esikhaleni esiphambili seshadi, ukucushwa kokugcwalisa kuzovela, lapho ungabeka khona noma yimuphi umbala, i-gradient njengesengezo, noma ulande isithombe.

Uma ngokuzayo uzodinga ukwenza ezinye izilungiselelo zemidwebo, sebenzisa lezi zinto kumenyu yokuqukethwe kanye nemenyu echazwe ngamapharamitha. Kwanele nje ukuzijwayeza imisebenzi eyethule ukuqonda ukuthi iyiphi efanelekile endaweni ethile.

Ukushintsha ifomethi yesibalo esinezintathu

Ekugcineni, sibona ukuhlelwa kwefomethi yesibalo esinezici ezintathu yemidwebo ye-columnar yalolu hlobo, ukwengeza esivele sikhulume ngenhla. Ngokuzenzakalelayo, isibalo esinjalo siyisikwele esivumelana nabo bonke abasebenzisi. Ukushintsha ukwakheka, yenza ukuchofoza okumbalwa:

1. Okokuqala ukugqamisa umugqa wokuhlela ukuze ubonakale amaphuzu eduze nekholomu ngayinye eshadini.



2. Chofoza omunye wabo ngenkinobho yegundane elifanele nakumenyu yokuqukethwe, chofoza ku- "Ifomethi Yedatha".



3. Uhlu lwezibalo ezitholakalayo luzovela, lapho luhlala lumaka kuphela inketho oyifunayo.



4. Buyela etafuleni futhi uqiniseke ukuthi izinguquko ezifakiwe zisebenze.

Kwezinye izindatshana esizeni sethu uzothola imininingwane eminingi engaba wusizo lapho usebenza ngamashadi e-columnar. Chofoza enye yezihloko ukuze ufunde imiyalo enemininingwane enemininingwane.

Funda kabanzi:

Ukwakha umdwebo eshadini le-Microsoft Excel

Ukwakha ishadi etafuleni kuMicrosoft Excel

Izindlela zokususa amashadi ku-Microsoft Excel