Umdwebo welayini ku-Excel

Umgomo wokudala ishadi lebha

Umdwebo welayini ku-Excel usetshenziselwa ukubonisa idatha ehluke ngokuphelele ephathelene nethebula elikhethiwe. Ngenxa yalokhu, kuvela isidingo hhayi nje ukudala, kodwa futhi nokumisa ngaphansi kwemisebenzi yabo. Ekuqaleni, kufanele kuhlungwe ngokukhethwa kweshadi eliqondile, bese kuqhubeka ekushintsheni kwamapharamitha alo.

1. Qokomisa ingxenye efiselekayo yetafula noma ngokuphelele, ephethe inkinobho yegundane kwesobunxele.



2. Chofoza Faka ithebhu.



3. Ebhlokini ngamashadi, wandise imenyu ye- "Histogram" Drop-Down, lapho kunamagrafu amathathu aqondile aqondile futhi kukhona inkinobho yokuya kumenyu namanye ama-histogram.



4. Uma ucindezela iwindi lokugcina, iwindi elisha elithi "Insert Chart" lizovulwa, lapho, kusuka kuhlu olutholwe, khetha "Ilonyeke".



5. Cabanga wonke amashadi akhona ukuze ukhethe eyodwa efanelekile ukubonisa idatha yokusebenza. Uhlobo neqembu liphumelele lapho udinga ukuqhathanisa amanani ezigabeni ezihlukile.



6. Uhlobo lwesibili umugqa olunokuqongelela, likuvumela ukuthi ubonise ngokubuka izilinganiso zento ngayinye kweyonke.



7. Uhlobo olufanayo lweshadi, kepha kuphela ngesiqalo esithi "esijwayelekile" seluhluke kwimininingwane edlule kwiyunithi yokuhambisa idatha. Lapha aboniswa ku-Percenta RATIO, hhayi ngokulinganayo.



8. Lezi zinhlobo ezintathu ezilandelayo zemidwebo ye-bar zinobukhulu obuthathu. Owokuqala udala ukuhlela okufanayo okuxoxwe ngakho ngenhla.



9. Umdwebo ozungezayo osondelene wenza ukuthi kungenzeka ukubuka isilinganiso esilinganayo ngasinye.



10. Ivolumu ejwayelekile kanye nokwenziwa kabili, ikhombisa imininingwane ngamaphesenti.



11. Khetha elinye lamashadi e-Bar ahlongozwayo, bheka ukubuka bese uqhafaza ku-ENTER ukuze ungeze etafuleni. Bamba igrafu ngenkinobho yegundane kwesobunxele ukuwuhambisa esikhundleni esilula.

Ukushintsha isithombe seshadi lomugqa onezici ezintathu

Amashadi e-Bar anezici ezintathu ayathandwa futhi ngoba abukeka emuhle futhi akuvumele ukukhombisa kahle ukuqhathanisa kwedatha lapho isethulo sephrojekthi. Imisebenzi ejwayelekile ye-Excel iyakwazi ukuguqula uhlobo lwesimo sochungechunge olunedatha, lushiye inketho ye-classic. Ngemuva kwalokho ungaguqula isimo sesibalo, usinikeze ukwakheka komuntu ngamunye.

1. Ungashintsha isibalo soMdwebo Welayini lapho ekuqaleni sadalwa ngefomethi enezici ezintathu, ngakho-ke yenza manje uma uhlelo lungakangezwa etafuleni.



2. Cindezela i-LKM emigqeni yedatha yomdwebo bese uchitha ufike ukugqamisa wonke amanani.



3. Yenza inkinobho efanele ngenkinobho yegundane efanele futhi ngemenyu yomongo, iya engxenyeni ethi "Idatha yebanga".



4. Ngakwesokudla kuzovula iwindi elincane elibhekele ukusetha amapharamitha womugqa onezici ezintathu. Evikini le- "SAME", phawula isibalo esifanele sokufaka esikhundleni semvelo bese ubheka umphumela etafuleni.



5. Masinyane ke, vula isigaba esisemaphakathi esibhekele ukuhlela ifomethi yesibalo se-bulk. Mbuze impumuzo, i-contour bese inika ukuthungwa lapho kunesidingo. Ungakhohlwa ukuqapha izinguquko eshadini bese ulikhansela uma ungathandi okuthile.

Shintsha ibanga phakathi kwemigqa yomdwebo

Kumenyu efanayo, ukusebenza noMdwebo Wochungechunge Kukhona isilungiselelo esihlukile esivula ngokusebenzisa "amapharamitha weRow" Row ". Inesibopho sokwanda noma ukwehla kwegebe phakathi kwemigqa yohlangothi lwangaphambili nohlangothi. Khetha ibanga elifanele ngokuhambisa lezi zilayidi. Uma kungazelelwe ukusetha kungakufaneli, buyisela amanani azenzakalelayo (150%).

Ukushintsha indawo ye-axes

Isimo sokugcina esizoba wusizo lapho sisebenza nomdwebo wesikhathi - shintsha indawo ye-axes. Ijika i-axis yama-degree angama-90, okwenza ukuboniswa kwegrafu mpo. Imvamisa, lapho udinga ukuhlela uhlobo olufanayo, abasebenzisi bakhetha olunye uhlobo lwezincwadi, kepha kwesinye isikhathi ungashintsha nje ukusethwa kwendawo yamanje.

1. Chofoza inkinobho yegundane kwesokudla kwesokudla.



2. Imenyu yomongo ivela lapho uvula khona iwindi lefomethi ye-Axis.



3. Kuyo, iya kuthebhu yokugcina ngamapharamitha.



4. Nweba isigaba se- "Signatures".



5. Ngokusebenzisa i- "Signature Posis" Imenyu eyehlayo, khetha indawo oyifunayo, isibonelo, ezansi noma ngaphezulu, bese ubheka umphumela.