I-Excel yeMicrosoft ivumela hhayi nje kuphela ukusebenza nedatha yezinombolo, kepha futhi ihlinzeka ngamathuluzi wokwakha imidwebo esuselwa kumapharamitha afakiwe. Isibonisi sabo sokubuka singahluka ngokuphelele futhi sincike kwizisombululo zomsebenzisi. Ake sibheke ukuthi ukudweba izinhlobo ezahlukene zemidwebo usebenzisa lolu hlelo.
Ishadi Lokwakha I-Excel
Ngoba nge-Excel ungacubungula kalula idatha yezinombolo kanye neminye imininingwane, ithuluzi lokwakha imidwebo lapha futhi lisebenza ngezindlela ezihlukile. Kulesi sihleli, kunezinhlobo ezijwayelekile zemidwebo esuselwa kwimininingwane ejwayelekile kanye nekhono lokwenza into yombukiso wezilinganiso zenzalo noma ngisho nomthetho obonisa umthetho we-pareto. Okulandelayo, sizokhuluma ngezindlela ezahlukahlukene zokwenza lezi zinto.Inketho 1: Yakha ishadi etafuleni
Ukwakhiwa kwezinhlobo ezahlukahlukene zemidwebo akwehlukile, kuphela esigabeni esithile osidingayo ukukhetha uhlobo olufanele lokubuka ngamehlo.
- Ngaphambi kokuthi uqale ukudala noma yiliphi ishadi, kuyadingeka ukwakha itafula elinedatha ngesisekelo lapho ezokwakhiwa khona. Bese uye kuthebhu ethi "Faka" bese wabela indawo yetafula, ezovezwa kumdwebo.
- Ethepheni ethekeni lokufakwa kwe-Insert Deposte, sikhetha enye yezinhlobo eziyisithupha eziphambili:
- Igrafu yebha;
- Isheduli;
- Isiyingi;
- Umugqa;
- Nezifunda;
- Iphuzu.
- Ngaphezu kwalokho, ngokuchofoza inkinobho ethi "Kweminye", ungamisa kwenye yezinhlobo ezijwayelekile: isitoko, ingaphezulu, indandatho, bubble, petal.
- Ngemuva kwalokho, ngokuchofoza kunoma yiziphi izinhlobo zamashadi, amandla okukhetha ama-subspecies athile. Isibonelo, nge-histogram noma umdwebo webha, ama-subspecies anjalo kuzoba izinto ezilandelayo: i-histogram ejwayelekile, inqwaba, cylindrical, conecal, i-pyramidal.
- Ngemuva kokukhetha ama-subspecies athile, umdwebo wenziwa ngokuzenzakalelayo. Isibonelo, i-histogram ejwayelekile izobukeka sengathi ikhonjisiwe esikrinini esingezansi:
- Ishadi elisesimweni segrafu lizoba ngale ndlela elandelayo:
- Inketho enezifunda izothatha lolu hlobo:
Ukusebenza ngemidwebo
Ngemuva kokuthi le nto idalwe, amathuluzi angeziwe wokuhlela noshintsho atholakala kuthebhu entsha "esebenza namashadi".
- Uhlobo lokushintsha olutholakalayo, isitayela namanye amapharamitha amaningi.
- I- "Work With Charts" I-Tab inamathebhu amathathu angezelwe: "Umklami", "ukwakheka" kanye "nefomethi", usebenzisa ukuthi kudingekile. Isibonelo, ukubiza umdwebo, vula ithebhu "Izakhiwo" bese ukhetha elinye lamagama egama: enkabeni noma ngaphezulu.
- Ngemuva kokuthi yenziwe, umbhalo ojwayelekile wokubhala "umdwebo" uyavela. Siyayishintsha kunoma yimuphi umbhalo ofanele umongo waleli thebula.
- Igama le-axges ye-diagram lisayiniwe ngokufana ngokomgomo, kepha kulokhu udinga ukucindezela inkinobho ethi "Axis Amagama".
Inketho 2: Khombisa ishadi ngamaphesenti
Ukubonisa isilinganiso samaphesenti wezinkomba ezahlukahlukene, kungcono ukwakha umdwebo oyindilinga.
- Ngokufanayo, indlela esatshelwa ngayo, sakha itafula, bese ukhetha ibanga ledatha. Okulandelayo, iya kuthebhu ethi "Insert", chaza umdwebo oyindilinga ethepheni nangohlu lokuchofoza oluvela kunoma yiluphi uhlobo.
- Uhlelo ngokuzimela luhumushela komunye wamathebhu ukuthi asebenze nale nto - "umklami". Khetha phakathi kwezakhiwo eziku-RIBBon yanoma yikuphi, lapho kukhona uphawu lwamaphesenti.
- Umdwebo wendilinga onokuboniswa kwedatha ngamaphesenti usukulungele.
Inketho 3: Yakha ishadi pareto
Ngokusho kweWilfredo Pareto theory, ama-20% ezenzo aphumelela kakhulu aletha ama-80% womphumela ojwayelekile. Ngokuvumelana nalokhu, okusele kwama-80% wezenzo eziphelele zezenzo ezingasebenzi, kuphela ama-20% omphumela alethwa. Ishadi le-Building Chart Izenzelwe ukubala ngezenzo ezisebenzayo kakhulu ezinikeza ukubuya okuphezulu. Kwenze ukusebenzisa iMicrosoft Excel.
- Kulula kakhulu ukwakha le nto ngesimo se-histogram, esivele sikhulume ngenhla.
- Ake sinikeze isibonelo: Ithebula liqukethe uhlu lokudla. Kwikholamu eyodwa, inani lokuthengwa kwempahla yalo lonke ivolumu yohlobo oluthile lwemikhiqizo kwi-Wholesale Warehouse yabhalwa, kanti okwesibili - inzuzo ngokusetshenziswa kwayo. Kufanele sinqume ukuthi yiziphi izimpahla ezinikeza "ukubuya" okukhulu kakhulu lapho zithengisa.
Okokuqala, sakha i-histogram ejwayelekile: siya kuthebhu ethi "Faka", sabela yonke indawo yamanani etafula, chofoza inkinobho ethi "Histogram" bese ukhetha uhlobo olufunayo.
- Njengoba ubona, ishadi elinezinhlobo ezimbili zamakholomu zakhiwa njengomphumela: luhlaza okwesibhakabhaka nokubomvu. Manje kufanele siguqule amakholomu abomvu kuHlelo - Khetha lawa makholomu ngesikhombisi nakuthebhu "Designer" ngokuchofoza ku- "Shintsha Uhlobo lweshadi".
- Kuvulwa iwindi lokushintsha iwindi. Iya esigabeni esithi "Sheduli" bese ucacisa uhlobo olufanele izinhloso zethu.
- Ngakho-ke, kwakhiwa umdwebo wePareto. Manje usungakwazi ukuhlela izakhi zayo (igama lento kanye nama-axes, izitayela, njll.) Njengoba kuchazwe esibonelweni seshadi lekholomu.
Njengoba ukwazi ukubona, i-Excel iveza imisebenzi eminingi yokwakha nokuhlela izinhlobo ezahlukahlukene zemidwebo - umsebenzisi uhlala enquma ukuthi uluphi uhlobo nefomethi edingekayo ukuze uthole umbono obonakalayo.