Enza ngendlela oyifisayo amashadi ku-Excel: engeza isihloko, izimbazo, inganekwane, amalebula edatha nokunye

Iyiphi into yokuqala esiyicabangayo ngemva kokwenza ishadi ku-Excel? Mayelana nokuthi singawunikeza kanjani umdwebo ukubukeka ngendlela esasikucabange ngenkathi sifika ebhizinisini!

Ezinguqulweni zanamuhla ze-Excel 2013 no-2016, ukwenza amashadi ngendlela oyifisayo kulula futhi kulula. I-Microsoft ihambe ibanga elide ukwenza inqubo yokusetha ibe lula futhi izinketho ezidingekayo zifinyeleleke kalula. Kamuva kulesi sihloko, sizokubonisa izindlela ezilula zokwengeza nokwenza ngendlela oyifisayo zonke izici zeshadi eziyisisekelo ku-Excel.

• Yengeza isihloko seshadi
• Ukwenza ngokwezifiso izimbazo zeshadi
• Ukwengeza amalebula edatha
• Ukwengeza, Ukukhipha, Ukuhambisa, nokwenza Ngokwezifiso Ifomethi Yelejendi Yeshadi
• Bonisa noma fihla imigqa yegridi
• Shintsha noma fihla uchungechunge lwedatha eshadini
• Shintsha uhlobo nesitayela seshadi
• Shintsha imibala yeshadi ezenzakalelayo
• Ukushintshanisa izimbazo eziqondile nezivundlile
• Zungezisa ishadi ku-Excel ukusuka kwesobunxele kuye kwesokudla

Izindlela ezi-3 zokwenza Izinketho Zeshadi Ngokwezifiso ku-Excel

Uma ube nethuba lokufunda i-athikili yethu yangaphambilini yokuthi ungenza kanjani ishadi ku-Excel, lapho-ke usuvele uyazi ukuthi ungakwazi ukufinyelela amathuluzi ayisisekelo wokushadi ngendlela eyodwa yezindlela ezintathu:

1. Khetha ishadi futhi usebenzise amathebhu eqenjini Ukusebenza namashadi (Amathuluzi Eshadi) - umakhi (Umklamo) Framework (Ifomethi).
2. Chofoza kwesokudla entweni yeshadi ofuna ukuyenza ngokwezifiso bese ukhetha umyalo owufunayo kumenyu yokuqukethwe.
3. Sebenzisa izithonjana ezikhethekile ezivela eduze nekhona eliphezulu kwesokudla seshadi uma uchofoza kulo ngegundane.

Izinketho eziningi nakakhulu zikuphaneli Ifomethi Yendawo Yeshadi (Ishadi Lefomethi), elivela kwesokudla sephepha lokusebenzela uma uchofoza Izinketho eziningi (Okunye okukhethwa kukho) kumenyu yokuqukethwe yomdwebo noma kumathebhu eqembu Ukusebenza namashadi (Amathuluzi Eshadi).

Ithiphu: Ukuze uvule ngokushesha ingxenye oyifunayo yephaneli yokusetha imingcele yeshadi, chofoza kabili into ehambisanayo eshadini.

Sihlome ngalolu lwazi oluyisisekelo, ake sibheke ukuthi singazilungisa kanjani izici ezihlukahlukene zeshadi ku-Excel ukuze silinikeze ngendlela esifuna libukeke ngayo.

Usengeza kanjani isihloko eshadini le-Excel

Kulesi sigaba, sizokukhombisa ukuthi ungangeza kanjani isihloko eshadini ezinguqulweni ezihlukene ze-Excel futhi sikubonise ukuthi akuphi amathuluzi amakhulu okushadi. Kuzo zonke ezinye ze-athikili, sizocubungula izibonelo zomsebenzi kuphela ezinguqulweni ezintsha ze-Excel 2013 no-2016.

Ukwengeza Isihloko Eshadini ku-Excel 2013 naku-Excel 2016

Ku-Excel 2013 naku-Excel 2016, lapho wakha ishadi, umbhalo “Isihloko seshadi“. Ukushintsha lo mbhalo, vele uwukhethe bese ufaka igama lakho:

Ungakwazi futhi ukuxhuma isihloko seshadi kuseli eshidini usebenzisa isixhumanisi ukuze isihloko sibuyekezwe ngokuzenzakalelayo noma nini lapho okuqukethwe kweseli elixhunyiwe kushintsha. Indlela yokwenza lokhu ichazwe ngezansi.

Uma ngesizathu esithile isihloko singazange sengezwe ngokuzenzakalelayo, bese uchofoza noma yikuphi kumdwebo ukuze uveze iqembu lamathebhu Ukusebenza namashadi (Amathuluzi e-Chart). Vula ithebhu umakhi (Design) bese ucindezela Engeza isici Seshadi (Engeza isici Seshadi) > Isihloko seshadi (Isihloko Seshadi) > Ishadi elingenhla (Ngenhla Ishadi) noma Maphakathi (imbondela) (Imbondela Emaphakathi).

Noma chofoza isithonjana Izakhi zeshadi (Izinto Zeshadi) eduze nekhona eliphezulu kwesokudla seshadi bese uthikha ibhokisi Isihloko seshadi (Isihloko Seshadi).

eduze kwenketho Isihloko seshadi (Isihloko Seshadi), ungachofoza umcibisholo obheke kwesokudla (bona isithombe esingenhla) bese ukhetha enye yezinketho:

• Ishadi elingenhla (Ishadi Elingenhla) - igama libekwe ngaphezu kwendawo yokwakha ishadi, kuyilapho usayizi weshadi uncishisiwe; le nketho isetshenziswa ngokuzenzakalelayo.
• Maphakathi (imbondela) (Imbondela Emaphakathi) - isihloko esimaphakathi sibekwe phezulu phezu kwendawo yokuhlela, kuyilapho usayizi weshadi ungashintshi.

Ukuze uthole izinketho ezengeziwe, chofoza ithebhu umakhi (Design) bese ucindezela Engeza isici Seshadi (Engeza isici Seshadi) > Isihloko seshadi (Isihloko Seshadi) > Izinketho ezengeziwe zeheda (Okunye ongakhetha kukho). Noma chofoza isithonjana Izakhi zeshadi (Izici Zeshadi), bese Isihloko seshadi (Isihloko Seshadi) > Izinketho eziningi (Izinketho Eziningi).

Cindezela inkinobho Izinketho eziningi (Izinketho Eziningi), kuzo zombili izimo, ivula iphaneli Ifomethi Yesihloko Seshadi (Isihloko Seshadi Lefomethi) ohlangothini lwesokudla lwekhasi lokusebenzela, lapho ungathola khona izinketho ozifunayo.

Ukwengeza Isihloko Eshadini ku-Excel 2010 naku-Excel 2007

Ukwengeza isihloko eshadini ku-Excel 2010 nangaphambilini, landela lezi zinyathelo:

1. Chofoza noma yikuphi eshadini le-Excel ukuze uveze iqembu lamathebhu kuRibhoni Yemenyu Ukusebenza namashadi (Amathuluzi Eshadi).
2. Kuthebhu ethuthukisiwe Isakhiwo (Isakhiwo) chofoza Isihloko seshadi (Isihloko Seshadi) > Ishadi elingenhla (Ngenhla Ishadi) noma Maphakathi (imbondela) (Imbondela Emaphakathi).

Ukuhlobanisa isihloko seshadi neseli yeshidi lokusebenzela

Amashadi ezinhlobo ezahlukahlukene ku-Excel avamise ukudalwa anombhalo ohlukile esikhundleni sesihloko. Ukusetha igama lakho leshadi, ungakhetha inkambu yeshadi bese ufaka umbhalo mathupha, noma uwuxhume kunoma iyiphi iseli ekhasini lokusebenza eliqukethe, isibonelo, igama lethebula. Kulokhu, isihloko seshadi le-Excel sizobuyekezwa ngokuzenzakalelayo njalo lapho okuqukethwe kweseli elixhunyiwe kushintsha.

Ukuxhuma isihloko seshadi kuseli leshidi lokusebenzela:

1. Gqamisa isihloko seshadi.
2. Kubha yefomula, thayipha uphawu olulinganayo (=), chofoza iseli eliqukethe umbhalo owufunayo, bese ucindezela Faka.

Kulesi sibonelo, sixhuma isihloko seshadi le-Excel neseli A1. Ungakhetha amaseli amabili noma ngaphezulu (isibonelo, izihloko zamakholomu amaningi) futhi isihloko seshadi esiwumphumela sizobonisa okuqukethwe kwawo wonke amaseli akhethiwe.

Ukuhambisa isihloko eshadini

Uma ufuna ukuhambisa isihloko seshadi kwenye indawo, sikhethe bese usihudula ngegundane lakho:

Ukukhipha isihloko seshadi

Uma ishadi le-Excel lingasidingi isihloko, lingasuswa ngezindlela ezimbili:

• Kuthebhu ethuthukisiwe umakhi (Design) chofoza Engeza Izinto Zeshadi (Engeza isici Seshadi) > Isihloko seshadi (Isihloko Seshadi) > Cha (Lutho).
• Chofoza kwesokudla egameni leshadi bese uchofoza kumenyu yokuqukethwe Susa (Susa).

Shintsha ifonti nomklamo wesihloko seshadi

Ukushintsha ifonti yesihloko seshadi ku-Excel, chofoza kwesokudla kuso bese uchofoza Ifonti (Ifonti) kumenyu yokuqukethwe. Ibhokisi lengxoxo legama elifanayo lizovuleka, lapho ungalungisa khona izilungiselelo ezihlukahlukene zefonti.

Uma udinga izilungiselelo ezinemininingwane eyengeziwe, khetha igama lomdwebo, vula ithebhu Framework (Fometha) futhi udlale ngezinketho ezahlukahlukene. Nansi indlela, isibonelo, ongasiguqula ngayo isihloko seshadi usebenzisa Iribhoni Yemenyu:

Ngendlela efanayo, ungakwazi ukushintsha ukubukeka kwezinye izici zeshadi, njengezihloko ze-eksisi, amalebula e-eksisi, nelejendi yeshadi.

Ukuze uthole ulwazi olwengeziwe ngalokhu, bheka isihloko esithi Ungasengeza kanjani isihloko eshadini ku-Excel.

Ukusetha izimbazo zeshadi ku-Excel

Ezinhlotsheni eziningi zamashadi ku-Excel i-eksisi emile (iphinde ibe yi-axis yenani noma i-eksisi ka-Y) kanye i-eksisi evundlile (kuphinde kube yi-axis yesigaba noma i-X eksisi) zengezwa ngokuzenzakalelayo lapho kwakhiwa ishadi.

Ukuze ufihle noma ubonise izimbazo zeshadi, chofoza isithonjana Izakhi zeshadi (Izinto Zeshadi), bese uchofoza umcibisholo osemugqeni Izimbazo (Izimbazo) bese ubeka uphawu izimbazo ofuna ukuzibonisa, noma ususe ukumaka amabhokisi aseduze kwalawo ofuna ukuwafihla.

Kwezinye izinhlobo zeshadi, njengamashadi enhlanganisela, i-eksisi yesibili ingase iboniswe.

Lapho udala amashadi e-XNUMXD, ungabonisa i-eksisi ejulile:

Engxenyeni ngayinye yezimbazo zeshadi ku-Excel, ungamisa amapharamitha ahlukahlukene (sizokhuluma ngalokhu ngokuningiliziwe kamuva):

Ukwengeza Izihloko Ze-eksisi Eshadini

Lapho udala ishadi ku-Excel, ungakwazi ukwengeza izihloko zezimbazo eziqondile nezivundlile ukuze kube lula kubasebenzisi ukuqonda ukuthi iyiphi idatha eboniswa eshadini. Ukwengeza izihloko ze-eksisi, udinga ukwenza okulandelayo:

1. Chofoza noma yikuphi eshadini le-Excel, bese uchofoza isithonjana Izakhi zeshadi (Izici Zeshadi) bese uqoka ibhokisi Amagama e-eksisi (Izihloko ze-eksisi). Uma ufuna kuphela ukukhombisa isihloko sembazo eyodwa (iqondile noma evundlile), chofoza umcibisholo ongakwesokudla bese ususa ukumaka kwelinye lamabhokisi.
2. Chofoza ishadi elisendaweni yombhalo wesihloko se-eksisi bese ufaka umbhalo.

Ukuze wenze ngendlela oyifisayo ukubukeka kwesihloko se-eksisi, chofoza kwesokudla kuso bese uchofoza kumenyu yokuqukethwe Ifomethi yegama le-eksisi (Fometha Isihloko se-eksisi). Lokhu kuzovula iphaneli yegama elifanayo ngokukhethwa okukhulu kwezinketho zokuklama ngokwezifiso. Ungasebenzisa futhi izinketho ezinikezwa kuthebhu Framework (Ifomethi) Amaribhoni emenyu, njengoba senza lapho sisetha izinketho zesihloko seshadi.

Ukuhlobanisa izihloko ze-eksisi namaseli eshidi lokusebenzela anikeziwe

Njengesihloko seshadi, isihloko se-eksisi singaxhunywa kuseli leshidi lokusebenzela elithile kusetshenziswa isixhumanisi ukuze isihloko sibuyekezwe ngokuzenzakalelayo lapho idatha ekuseli elixhunyiwe ishintsha.

Ukwakha isixhumanisi esinjalo, khetha igama le-eksisi bese kubha yefomula ufake uphawu olulinganayo (=), bese uchofoza kuseli ofuna ukuxhumanisa kulo igama le-eksisi, bese uchofoza Faka.

Shintsha isikali se-eksisi yeshadi

I-Microsoft Excel inquma ngokuzenzakalelayo ubuncane namanani aphezulu, kanye namayunithi e-eksisi eqondile, ngokusekelwe kulokho idatha esetshenziswayo ukwakha ishadi. Uma kudingekile, ungasetha amapharamitha akho afaneleka kakhulu e-eksisi eqondile.

1. Khetha i-eksisi emile yeshadi bese uchofoza isithonjana Izakhi zeshadi (Izici Zeshadi).
2. Chofoza umcibisholo kumugqa Izimbazo (I-eksisi) nakumenyu evelayo, khetha Izinketho eziningi (Okunye ongakhetha kukho). Iphaneli izovuleka Ifomethi ye-eksisi (Fometha i-eksisi).
3. Esigabeni Imingcele ye-eksisi (Izinketho ze-Axis) yenza okukodwa kokulandelayo:
   • Ukusetha amanani okuqala nawokugcina e-eksisi eqondile, faka amanani afanele ezinkambini Minimum (Okungenani) noma Isikhulu (Ubuningi).
   • Ukushintsha isikali se-eksisi, faka amanani ezinkambu Izigaba ezinkulu (Okukhulu) kanye Ukuhlukana okuphakathi (Encane).
   • Ukuze uhlehlise amanani e-eksisi, maka ibhokisi Hlehlisa ukuhleleka kwamanani (Amanani alandelana ngokuhlehla).

   

I-eksisi evundlile, ngokungafani neyama mpo, ngokuvamile inamalebula edatha yombhalo kunezinombolo, ngakho le eksisi inezilungiselelo zezikali ezimbalwa. Nokho, ungashintsha inombolo yezigaba ezizoboniswa phakathi kwamalebula, ukuhleleka kwezigaba, nendawo lapho izimbazo ezimbili zihlangana khona:

Ukushintsha ifomethi yenombolo yamalebula e-eksisi

Uma ufuna izinombolo ezikumalebula e-eksisi ziboniswe njengezinhlobo zemali, amaphesenti, izikhathi, noma ngenye indlela, chofoza kwesokudla kumalebula futhi kumenyu yokuqukethwe uchofoze. Ifomethi ye-eksisi (Fometha i-eksisi). Kuphaneli elivulayo, hamba esigabeni Inombolo (Inombolo) bese ukhetha ifomethi eyodwa yezinombolo ezitholakalayo:

Ithiphu: Ukusetha ifomethi yomthombo wedatha yezinombolo (leyo esemaseli ephepha lokusebenzela), maka ibhokisi Xhuma emthonjeni (Kuxhunywe kumthombo). Uma ungasitholi isigaba Inombolo (Inombolo) kumaphaneli Ifomethi ye-eksisi (Fometha i-eksisi), hlola ukuthi i-axis yenani ikhethiwe eshadini (lokhu ngokuvamile kuyi-eksisi eqondile).

Ukwengeza Amalebula Edatha Eshadini le-Excel

Ukuze wenze ishadi liqondeke kalula ku-Excel, engeza amalebula edatha abonisa ulwazi oluningiliziwe mayelana nochungechunge lwedatha. Kuya ngokuthi ufuna abasebenzisi banake ini, ungakwazi ukwengeza amalebula ochungechungeni lwedatha olulodwa, kulo lonke uchungechunge, noma kumaphoyinti ngamanye.

1. Chofoza uchungechunge lwedatha ofuna ukwengeza amalebula walo. Ukwengeza ilebula endaweni eyodwa kuphela yedatha, chofoza futhi kulelo phuzu ledatha.
2. Chofoza isithonjana Izakhi zeshadi (Izici Zeshadi) bese uqoka ibhokisi Amasiginesha Wedatha (Amalebula Wedatha).

Isibonelo, le yindlela ishadi lethu le-Excel elibukeka ngayo elinamalebula ochungechunge lwedatha.

Kwezinye izimo, ungakhetha ukuthi amalebula azobekwa kanjani. Ukuze wenze lokhu, chofoza umcibisholo osemugqeni Amasiginesha Wedatha (Amalebula Wedatha) bese ukhetha inketho efanelekile. Ukuze ubonise amalebula ngaphakathi kwezinkambu zombhalo ezintantayo, khetha Idatha ye-Callout (Ukubizwa kwedatha).

Uyishintsha kanjani idatha eboniswa kumalebula

Ukuze uguqule okuqukethwe kwamalebula edatha eshadini, chofoza isithonjana Izakhi zeshadi (Izici Zeshadi) > Amasiginesha Wedatha (Amalebula Wedatha) > Izinketho eziningi (Okunye ongakhetha kukho). Iphaneli izovuleka Ifomethi Yelebula Yedatha (Fometha Amalebula Edatha) ngakwesokudla sekhasi lokusebenzela. Kuthebhu Izinketho Zesiginesha (Izinketho Zelebula) esigabeni Faka kuSiginesha (Ilebula Iqukethe) khetha ezinkethweni ezinikeziwe.

Uma ufuna ukwengeza umbhalo wangokwezifiso kwelinye lamaphoyinti edatha, chofoza kulebula yalelo phuzu, bese uchofoza futhi ukuze ugcine leyo lebula kuphela ekhethiwe, futhi futhi embhalweni welebula ukuze uyikhethe. Okulandelayo, faka owakho umbhalo.

Uma kuvela ukuthi amalebula amaningi kakhulu alayisha ngokweqile ishadi le-Excel, ungasusa noma yimaphi kuwo. Chofoza isiginesha ngenkinobho yegundane engakwesokudla bese uchofoza kumenyu yokuqukethwe Susa (Susa).

Amathiphu okusebenza ngamalebula edatha:

• Ukuze ushintshe indawo yesiginesha eyodwa, vele uyihudule ngegundane uye endaweni oyifunayo.
• Ukuze ushintshe umbala wefonti futhi ugcwalise amalebula edatha, wakhethe, bese uchofoza ithebhu Framework (Fometha) bese ulungisa izinketho zokufometha ozifunayo.

Ukwengeza, Ukukhipha, Ukuhambisa, nokwenza Ngokwezifiso Ifomethi Yelejendi Yeshadi

Uma udala ishadi ku-Excel 2013 naku-Excel 2016, inganekwane yengezwa ezansi kwendawo yeshadi ngokuzenzakalelayo. Ku-Excel 2010 nangaphambili, kwesokudla sendawo yokwakha.

Ukuze ususe ilejendi, chofoza isithonjana Izakhi zeshadi (Izici Zeshadi) eduze nekhona eliphezulu kwesokudla seshadi bese ususa ukumaka ibhokisi Legend (Inganekwane).

Ukuze uhambise ilejendi yeshadi endaweni ehlukile, khetha ishadi, vula ithebhu umakhi (Design), chofoza Engeza isici Seshadi (Engeza isici Seshadi) > Legend (Inganekwane) bese ukhetha indawo entsha yenganekwane. Ukuze ususe inganekwane, chofoza Cha (Lutho).

Enye indlela yokuhambisa inganekwane ukuchofoza kabili kuyo bese ukhetha indawo oyifunayo esigabeni. Izinketho zelejendi (Izinketho Zomlando) amaphaneli Ifomethi yeLegend (Ilejendi Yefomethi).

Ukuze wenze ngendlela oyifisayo ukufometha kwe-legend, kunezinketho eziningi kumathebhu Ukufiphaza kanye Nemingcele (Gcwalisa & Umugqa) kanye Effects (Imiphumela) amaphaneli Ifomethi yeLegend (Ilejendi Yefomethi).

Bonisa futhi ufihle igridi eshadini le-Excel

Ku-Excel 2013 no-2016, ukubonisa noma ukufihla igridi kuyindaba yemizuzwana. Vele uchofoze isithonjana Izakhi zeshadi (Izinto Zeshadi) bese uthikha noma ususe ukumaka ibhokisi Igridi (Olayini begridi).

I-Microsoft Excel inquma ngokuzenzakalelayo ukuthi iyiphi imigqa yegridi engcono kakhulu ohlotsheni lweshadi olunikeziwe. Isibonelo, ishadi lebha lizobonisa imigqa emikhulu eqondile, kuyilapho ishadi lekholomu lizobonisa imigqa yegridi emikhulu evundlile.

Ukuze wenze ngendlela oyifisayo uhlobo lwemigqa yegridi ebonisiwe, chofoza umcibisholo ongakwesokudla kumugqa Igridi (Olayini begridi) bese ukhetha efanele ezinkethweni ezihlongozwayo, noma chofoza Izinketho eziningi (Izinketho Eziningi) ukuze uvule iphaneli Ifomethi Yomugqa Wegridi Eyinhloko (Olayini begridi abakhulu).

Ukufihla nokuhlela uchungechunge lwedatha eshadini le-Excel

Uma ishadi le-Excel libonisa idatha eningi, kwesinye isikhathi kuyadingeka ukuthi ufihle okwesikhashana ingxenye yochungechunge ukuze ugxile kuleyo oyidingayo njengamanje.

Ukuze wenze lokhu, chofoza isithonjana esingakwesokudla segrafu. Izihlungi Zeshadi (Izihlungi Zeshadi) futhi ususe ukumaka leyo migqa kanye/noma izigaba ofuna ukuzifihla.

Ukuze uhlele uchungechunge lwedatha, cindezela inkinobho Shintsha irowu (Hlela uchungechunge) kwesokudla segama layo. Inkinobho ivela uma uhambisa igundane phezu kwegama lalo mugqa. Lokhu kuzogqamisa umugqa ohambisanayo kugrafu, ukuze ukwazi ukubona kalula ukuthi iyiphi ingxenye ezohlelwa.

Shintsha uhlobo lweshadi nesitayela

Uma ishadi olidalile linganele kahle idatha oyibonisayo, ungakwazi ukushintsha kalula uhlobo lweshadi. Ukuze wenze lokhu, khetha umdwebo, vula ithebhu Faka (Faka) futhi esigabeni Imidwebo (Amashadi) khetha uhlobo lweshadi oluhlukile.

Enye indlela ukuchofoza kwesokudla noma yikuphi eshadini futhi kusukela kumenyu yokuqukethwe uchofoze Shintsha uhlobo lweshadi (Shintsha Uhlobo Lweshadi).

Ukuze uguqule ngokushesha isitayela seshadi elidaliwe, chofoza isithonjana Izitayela zeshadi (Izitayela Zeshadi) kwesokudla sendawo yokwakha bese ukhetha efanelekile kuzitayela ezihlongozwayo.

Noma khetha esinye sezitayela esigabeni Izitayela zeshadi (Izitayela Zamashadi) ithebhu umakhi (Idizayini):

Ukushintsha imibala yeshadi

Ukuze uguqule itimu yombala weshadi ku-Excel, chofoza isithonjana Izitayela zeshadi (Izitayela Zeshadi), vula ithebhu Color (Umbala) bese ukhetha enye yetimu yombala ephakanyisiwe. Imibala ekhethiwe izosetshenziswa ngokushesha kumdwebo, futhi ungakwazi ukuhlola ngokushesha ukuthi ibukeka kahle yini kumbala omusha.

Ukuze ukhethe umbala wochungechunge ngalunye ngawodwana, khetha uchungechunge lwedatha eshadini, vula ithebhu Framework (Ifomethi) futhi esigabeni Izitayela zomumo (Izitayela Zomumo) chofoza Gcwalisa umumo (Gcwalisa umumo).

Ungashintsha kanjani izimbazo zika-x kanye no-y zeshadi

Lapho udala ishadi ku-Excel, umumo wochungechunge lwedatha unqunywa ngokuzenzakalelayo ngokusekelwe enanini lemigqa namakholomu wedatha yomthombo lapho ishadi lakhelwe khona. Ngamanye amazwi, i-Microsoft Excel inquma ngokuzimela indlela engcono kakhulu yokudweba igrafu yemigqa namakholomu akhethiwe.

Uma uhlelo oluzenzakalelayo lwemigqa namakholomu eshadini lungakufanelanga, ungashintsha kalula izimbazo ezivundlile nezime mpo. Ukuze wenze lokhu, khetha umdwebo nakuthebhu umakhi (Design) chofoza Ikholomu yomugqa (Shintsha Umugqa/Ikholomu).

Ungazungezisa kanjani ishadi ku-Excel ukusuka kwesobunxele kuye kwesokudla

Wake wadala ishadi ku-Excel futhi ekugcineni waqaphela ukuthi amaphuzu edatha alandelana ngendlela ephambene nalokho obufuna ukukuthola? Ukuze ulungise lesi simo, udinga ukuguqula indlela izigaba ezakhiwe ngayo emdwebeni, njengoba kuboniswe ngezansi.

Chofoza kwesokudla ku-eksisi evundlile yeshadi bese uchofoza Ifomethi ye-eksisi (Fometha i-eksisi) kumenyu yokuqukethwe.

Uma ukujwayele kakhulu ukusebenza nge-Ribbon, vula ithebhu umakhi (Design) bese ucindezela Engeza isici Seshadi (Engeza isici Seshadi) > Izimbazo (Izimbazo) > Izinketho ezengeziwe ze-eksisi (Izinketho eziningi ze-Axis).

Kunoma ikuphi, iphaneli izovela. Ifomethi ye-eksisi (Fometha i-eksisi) lapho kuthebhu Imingcele ye-eksisi (Izinketho ze-eksisi) udinga ukumaka inketho Ukuhlehlisa ukuhleleka kwezigaba (Izigaba ngokulandelana okuphambene).

Ngokungeziwe ekuphenyeni ishadi ku-Excel ukusuka kwesobunxele kuye kwesokudla, ungashintsha ukuhleleka kwezigaba, amanani, noma uchungechunge lwedatha eshadini, uhlehlise uhlelo lokuhlela lwamaphoyinti edatha, uzungezise ishadi likaphayi kunoma iyiphi i-engeli, nokuningi. I-athikili ehlukile inikezelwe esihlokweni samashadi ajikelezayo ku-Excel.

Namuhla ufunde ukuthi ungawenza kanjani ngokwezifiso amashadi ku-Excel. Yiqiniso, lesi sihloko sikuvumela kuphela ukuthi udwebe ingaphezulu lesihloko sezilungiselelo namashadi okufometha ku-Excel, nakuba kungashiwo okuningi ngalokhu. Esihlokweni esilandelayo, sizokwakha ishadi elisuka kudatha esemashidini okusebenzela ahlukahlukene. Okwamanje, ngincoma ukuthi uzilolonge ukuze uhlanganise ulwazi oluzuzwe namuhla.