Uma ufuna ukwenza ishadi ku-Excel kanye / noma amaSpredishithi e-Google, kubalulekile ukuqonda incazelo yamaphuzu wedatha, amalebula wedatha, namalebula wedatha.
Ukuqonda Ukusetshenziswa Kwezingqikithi Zedatha kanye Nezinye Izinketho Ze-Chart ku-Excel
Iphuzu lwedatha lingenani elilodwa elisekhompyutheni lokusebenzela elahlelwe eshadini noma egrafu .
Umaka wedatha uyikholomu , ichashazi, isigaja, noma enye uphawu eshadini elimelela lelo xabiso eshadini. Isibonelo, kumagrafu wesigcawu, iphuzu ngalinye emgqeni umaka wedatha omele inani lwedatha elilodwa eliselifeshini lokusebenzela .
Ilebuli yedatha inikeza ulwazi mayelana nabamaki bezinkampani ngabanye, njengokubaluleka kokuba i-graphed noma inombolo noma iphesenti.
Amalebula wedatha asetshenziswe ngokuvamile ahlanganisa:
- Amanani we-Numeri - athathwa ngamaphuzu wedatha ngamanye amaphasiwedi ;
- Amagama angqamuleli - khetha amakholomu noma imigqa yedatha yeshadi ekhasini lokusebenzela. Ngokuvamile zisetshenziselwa amashadi ekholomu, amashadi e-bar, namagrafu emigqa;
- Amagama wesigaba - ahlonza amaphuzu wedatha ngamanye uchungechunge olulodwa lwemininingwane. Zivame ukusetshenziselwa amashadi wephayi;
- Amalebula wephesenti - kubalwa ngokuhlukanisa amasimu ngabanye ochungechungeni ngenani eliphelele lochungechunge. Zivame ukusetshenziselwa amashadi wephayi;
Uchungechunge lwemininingwane yiqembu lamaphuzu wedatha ahlobene noma amamaki ahlelwe ngamashadi namagrafu. Izibonelo zochungechunge lwedatha ziyi:
- Imigqa yomuntu ngamunye egrafu yomugqa
- Amakholomu ngabanye eshadini lesikholomu
Uma uchungechunge oluningi lwemininingwane luhlelwe eshadini elilodwa, uchungechunge lwedatha ngayinye luboniswa ngombala oyingqayizivele noma iphethini ye-shading.
Endabeni yamashadi ekholomu noma amabha, uma amakholomu amaningi noma imigoqo efana nombala ofanayo, noma abe nesithombe esifanayo kumfanekiso we- pictograph , ahlanganisa uchungechunge olulodwa lwedatha.
Amashadi we-pie ngokuvamile avunyelwe uchungechunge olulodwa lwedatha ngeshadi ngalinye. Izinhlamvu zomuntu ngamunye we-pie yizimpawu zedatha kunokuba uchungechunge lwemininingwane.
Ukuguqula Amaklayenti Emininingwane Yedatha
Uma amaphuzu wedatha ngabanye ephawulekayo ngandlela-thile, ukufometha komaka wedatha okumelela lelo phuzu eshadini kungashintshwa ukwenza umaki avele kwamanye amaphuzu ochungechungeni.
Isibonelo, umbala wekholomu elilodwa eshadini lesikholomu noma iphuzu elilodwa egrafu lendiza lingashintshwa ngaphandle kokuphazamisa amanye amaphuzu ochungechungeni ngokulandela izinyathelo ezingezansi.
Ukushintsha Umbala Wekholomu Elilodwa
- Chofoza kanye uchungechunge lwedatha kwishadi lamakholomu. Wonke amakholomu wombala ofanayo eshadini kufanele agcizelelwe. Ikholomu ngalinye lizungezwe umngcele ohlanganisa amachashazi amancane emagumbini.
- Chofoza okwesibili kukholomu eshadini ukuze uguqule-kuphela lelo kholomu kufanele liqokonyiswe.
- Chofoza kuthebhu Yokwakheka kwebhebhoni, elinye lamathebhu womongo afakwe kwibhoni lapho ishadi likhethiwe.
- Chofoza ku-Isithonjana Sokugcwalisa Uhlobo ukuze uvule imenyu yokugcwalisa imibala.
- Esigabeni Esijwayelekile se-Colors semenyu khetha i- Blue.
Lolu chungechunge olufanayo lwezinyathelo lungasetshenziselwa ukushintsha iphuzu elilodwa kumagrafu wesigcawu. Vele ukhethe ichashazi elilodwa (umaka) emgqeni endaweni yekholomu eyodwa.
I-Exploding Pie
Njengoba izingcezu ezilodwa zeshadi lepayipi zivame ukuqala imibala ehlukene, ukugcizelela uhlangothi olulodwa noma iphuzu lwedatha kudinga indlela ehlukile kulokho esetshenziselwa amashadi ekholomu namathadi.
Ukugcizelela kuvame ukungezwa ukushayela amashadi ngokuxosha uhlangothi olulodwa lwe-pie kusuka kulo lonke ishadi.
Engeza Ukugcizelelwa NgeShadi Lama-Combo
Enye indlela yokugcizelela izinhlobo ezahlukene zolwazi eshadini ukukhombisa izinhlobo ezimbili noma ngaphezulu zeshadi eshadini elilodwa, njengeshadi lamakholomu kanye negrafu yesigcawu.
Le ndlela ivame ukuthathwa uma amanani abe yi-graphed ehlukahluka kakhulu, noma uma izinhlobo ezahlukene zedatha ziba graphed. Isibonelo esivamile yi- climatograph noma igrafu lesimo sezulu, okuhlanganisa ukuchithwa kanye nedatha lokushisa endaweni eyodwa eshadini elilodwa.
Amashadi ahlanganiswe noma ama- combo adalwe ngokuhlelwa uchungechunge olulodwa noma ngaphezulu kwedatha yesibili noma ye-Y.