Ukuba ufuna ukwenza ishati kwi-Excel kunye / okanye i-Google AmaSpredishithi, kuyimfuneko ukuqonda intsingiselo yamanqaku eenkcukacha, amanqaku eenkcukacha, kunye neelebula zedatha.
Ukuqonda Ukusetyenziswa kweeNkcazo zeDatha kunye nezinye izinto zeTyrt Elements kwi-Excel
Ikhonkco leenkcukacha lixabiso elilodwa elisezantsi kweseli yeshidi ecebiswe kwitshathi okanye igrafu .
Ummakishi wedata yinkomfa, i-dot, i-pie slice, okanye enye isimboli kwitshati emele loo nto kwixabiso. Umzekelo, kumgca wegrafu, nganye ngongoma kumgca umatshini wedatha omele ixabiso lwedatha elilodwa kwiseli leshidi lomsebenzi .
Ileta yedata inikezela ngolwazi malunga namanqaku eempawu ngabanye, njengexabiso lokuba igraphed nokuba yinani okanye njengepesenti.
Iileyibhile zedatha eziqhelekileyo zibandakanya:
- Iimpawu zamanani - ezithathwe kumanqaku eedatha ngamnye kwiphepha lokusebenzela ;
- Amagama omxholo - qwalasela iikholomu okanye imigca yeedatha zeenkcukacha kwiphepha lokusebenzela. Ngokuqhelekileyo zisetyenziselwa iitshathi zekholomu, iibhartshi zebhayisi, kunye negrafu zendima;
- Amagama omhlathi - achaza iinkcukacha zedatha nganye kwichungechunge olulodwa lweedatha. Ngokuqhelekileyo zisetyenziselwa iiphathi zeepayi;
- Iibhile zeepesenti - zibalwe ngokwahlula amasimu ngamnye kwinqaku leenqwanqwa yixabiso elipheleleyo lechungechunge. Ngokuqhelekileyo zisetyenziselwa iiphathi zeepayi;
Uchungechunge lweedatha liqela leenkcukacha ezihambelana neenkcukacha okanye abamakishi abacwangcisiweyo kwiitshathi kunye negrafu. Imizekelo yechungechunge lwedatha yile:
- Imigca yedwa kumgca wegrafu
- Iikholamu zomntu ngamnye kwididi yekholomu
Xa uchungechunge oluninzi lweedatha lucebiswe kwitshathi enye, uchungechunge lweedatha nganye luchongwa ngumbala oyingqayizivele okanye umzekelo wecala.
Kwimeko yetshukumo yekholomu okanye ibar, ukuba iikholomu ezininzi okanye imivalo zifana nombala ofanayo, okanye unomfanekiso ofanayo kumfanekiso wesithombe, ziquka uchungechunge olulodwa lweedatha.
Iitshathi zepeyiti zivame ukukhawulelwa kwichungechunge olulodwa lweedatha ngetshathi. Iicandelo zomntu ngamnye we-pie ngamanqaku edatha kunokuba uluhlu lweedatha.
Ukuguqulwa kwamanqaku eDatha
Ukuba iinkcukacha zomntu ngamnye zibalulekile ngandlela-thile, ukufometha kumakishi wedatha omela loo ngotshi kwitshathi kunokuguqulwa ukwenza umakishi avele kwamanye amanqaku kwichungechunge.
Umzekelo, umbala wekholam enye kwinqanaba lekholomu okanye icandelo elilodwa kwigrafu yelayini lingatshintshwa ngaphandle kokuchaphazela amanye amanqaku kwinqaku ngokulandela amanyathelo angezantsi.
Ukutshintsha Umbala wekholamu enye
- Cofa kanye kwinqaku leedatha kwinqanaba lekholomu. Zonke iikholomu zombala ofanayo kwitshathi kufuneka zigqitywe. Ikholamu nganye ijikelezwe ngumda obandakanya amachashaza amancinci kumagumbi.
- Cofa okwesihlandlo sesibini kwikholam kwitshathi ekufuneka iguqulwe-kuphela loo kholomu ifanele icaciswe.
- Cofa kwi Fomati ithebhu yerbhoni, enye yimixholo yithebhu eyongeziweyo kwi- ribbon xa ityati ikhethiweyo.
- Cofa kwi- Shape Fill icon ukuze uvule imenyu yokugcwalisa imibala.
- Kwinqanaba le- Colours eliqhelekileyo lemenyu khetha iBlue.
Olu chungechunge olufanayo lwamanyathelo lungasetyenziselwa ukutshintsha enye inqaku kwigrafu yomgca. Vele ukhethe icwecwe elilodwa (umakishi) kumgca endaweni yekholam enye.
Exploding Pie
Ekubeni isahluko ngasinye seesayiti zepayi ziqhelekileyo imibala eyahlukileyo ukuqala, ukugxininisa isicatshulwa esisodwa okanye idilesi yedatha kufuna indlela eyahlukileyo ukusuka kwento esetyenziselwa iikholomu kunye neetati.
Ugxininiso luye longezelelwe kwiiphathi zokutshiza ngokutshabalalisa isitya esinye se-pie ukusuka kwenye iseshati.
Gxininisa ngeKhadi leCombo
Enye inketho yokugxininisa iintlobo ezahlukeneyo zolwazi kwitshathi kukubonisa iintlobo ezimbini okanye ezininzi zeeshati kwididi enye, njengetshathi yekholomu kunye negrafu yomgca.
Le ndlela idlalwa xa ixabiso elingu-graphed lihluka ngokubanzi, okanye xa iintlobo ezahlukeneyo zeedatha zi-graphed. Umzekelo oqhelekileyo yi- climatograph okanye igrafu yemozulu, edibanisa imvula kunye neqondo lokushisa kwindawo enye kwitshati enye.
Umxube okanye amashadi e- combo adalwe ngokucwangcisa uchungechunge olulodwa okanye ngaphezulu kwedatha kwi-axis yecala okanye ye-Y axis.