Uhlelo lweMicrosoft Excel olunikeza ithuba hhayi nje lokusebenza nedatha yamanani, kepha futhi lunikezela ngamathuluzi wokwakha imidwebo ngokususelwa kunhlaka yokufaka. Ngasikhathi sinye, ukubonisa kwabo okubukwayo kungahluka ngokuphelele. Ake sibheke ukudweba izinhlobo ezahlukahlukene zamashadi kusetshenziswa iMicrosoft Excel.
Ishadi itafula
Ukwakhiwa kwezinhlobo ezahlukahlukene zemidwebo akukho okuhlukile. Esigabeni esithile kuphela lapho kufanele ukhethe uhlobo olufanele lokubonwa.
Ngaphambi kokuthi uqale ukudala noma yiliphi ishadi, udinga ukwakha itafula nedatha ezokwakhelwa kulo. Ngemuva kwalokho, iya kuthebhu ethi "Faka", bese ukhetha indawo yetafula, ezovezwa kumdwebo.
Kubambo olubekwe kuthebhu ethi "Faka", khetha eyodwa yezinhlobo eziyisithupha zemidwebo eyisisekelo:
- I-histogram;
- Isheduli;
- Isiyingi;
- Ukhubekile;
- Nezindawo;
- Khomba.
Ngaphezu kwalokho, ngokuchofoza inkinobho "Okunye", ungakhetha izinhlobo ezijwayelekile zemidwebo: isitoko, umphezulu, indandatho, i-bubble, i-petal.
Ngemuva kwalokho, ngokuchofoza kunoma yiziphi izinhlobo zamadayagramu, kuhlongozwa ukukhetha uhlobo oluthile lokubhaliselwe. Isibonelo, nge-histogram, noma ishadi le-bar, izakhi ezilandelayo zizoba izindlela ezinjengalezi: i-histogram ejwayelekile, i-volumetric, cylindrical, conical, pyramidal.
Ngemuva kokukhetha i-subspecies ethile, umdwebo wenziwa ngokuzenzakalelayo. Isibonelo, i-histogram ejwayelekile izobukeka njengaleyo eboniswe esithombeni esingezansi.
Ishadi legrafu lizobukeka kanjena.
Ishadi lendawo lizobukeka kanjena.
Sebenza ngamashadi
Ngemuva kokuthi ishadi lenziwe, kuthebhu entsha "Work with Charts" amathuluzi angeziwe wokuhlela nokuguqula atholakale. Ungashintsha uhlobo lweshadi, isitayela salo, namanye amapharamitha amaningi.
Ithebhu ethi "Work With Charts" inamathebhu amathathu ongezekile: "Design", "Layout" ne "Fomathi".
Ukuze usho ishadi, iya kuthebhu ethi "Ukuhlelwa", bese ukhetha okukodwa kokukhethwa kwendawo yegama: enkabeni noma ngaphezulu kweshadi.
Ngemuva kokuba lokhu sekwenziwe, kuvela igama elijwayelekile elithi "Ishadi Igama". Yiguqulele kunoma yikuphi okubhaliwe okulungele umongo waleli thebula.
Amagama we-axis wemidwebo asayiniwe ngendlela efanayo, kepha ukuze uthole lokhu kufanele uchofoze inkinobho ethi "Axis Names".
Iphesenti Leshadi Lokubonisa
Ukuze ubonise iphesenti yezinkomba ezahlukahlukene, kungcono ukwakha ishadi likaphayi.
Ngendlela efanayo njengoba senzile ngenhla, sakha itafula, bese sikhetha isigaba esifunayo. Okulandelayo, iya kuthebhu ethi "Faka", khetha ishadi likaphayi kubambo, bese kuthi, ohlwini oluvelayo, chofoza kunoma yiluphi uhlobo lweshadi likaphayi.
Ngaphezu kwalokho, lolu hlelo ngokuzimela lusiyisa kwelinye lamathebhu wokusebenza namashadi - "Designer". Phakathi kokuhlelwa kweshadi kubambo, khetha noma isiphi esinezimpawu zamaphesenti.
Ishadi likaphayi elibonisa idatha yamaphesenti ilungile.
Ukushaywa kwe-Pareto
Ngokomqondo weWilfredo Pareto, u-20% wezenzo ezisebenza kahle uletha ama-80% wemiphumela isiyonke. Ngokuvumelana nalokho, ama-80% asele weqoqo lezenzo ezingasebenzi, aletha ama-20% kuphelaomphumela. Ukwakhiwa komdwebo we-Pareto kumane nje kwenzelwe ukubala okusebenzayo kakhulu okunikeza ukubuyisa okuphezulu. Sizokwenza lokhu sisebenzisa iMicrosoft Excel.
Kulula kakhulu ukwakha umdwebo we-Pareto ngesimo se-histogram, esivele sidingida ngenhla.
Isibonelo sokwakha. Ithebula linikezela ngohlu lwemikhiqizo yokudla. Kwikholamu eyodwa, intengo yokuthenga yalo lonke ivolumu yohlobo oluthile lomkhiqizo esitolo sokuthenga esithengiswayo ifakiwe, kuthi okwesibili, inzuzo ngokuthengiswa kwayo. Kufanele sinqume ukuthi yimiphi imikhiqizo enikeza "ukubuya" okukhulu kakhulu okuthengisiwe.
Okokuqala, sakha i-histogram ejwayelekile. Iya kuthebhu ethi "Faka", khetha lonke uhla lwamanani etafula, cindezela inkinobho ethi "Histogram", bese ukhetha uhlobo olufunayo lwe-histogram.
Njengoba ubona, ngenxa yalezi zenzo, kwenziwa umdwebo ngezinhlobo ezimbili zamakholomu: luhlaza okwesibhakabhaka nokubomvu.
Manje, sidinga ukuguqula amakholomu abomvu abe igrafu. Ukuze wenze lokhu, khetha la makholomu ngesikhombisi, futhi kuthebhu "Design", chofoza inkinobho "Shintsha uhlobo lweshadi".
Kuvulwa iwindi lokushintshwa kweshadi. Iya engxenyeni ethi "Ishadi", bese ukhetha uhlobo lweshadi elifanele izinhloso zethu.
Ngakho-ke, umdwebo we-Pareto uyakhiwa. Manje, ungahlela izinto zalo (igama leshadi nama-axes, izitayela, njll.), Njengoba nje kuchazwe kusetshenziswa isibonelo sebha eshadi.
Njengoba ukwazi ukubona, iMicrosoft Excel inikezela ngamathuluzi ahlukahlukene okwakha nokuhlela izinhlobo ezahlukahlukene zemidwebo. Ngokuvamile, umsebenzi onalezi zixhobo wenziwa lula ngabathuthukisi ukuze abasebenzisi abanamazinga ahlukene wokuqeqeshwa bakwazi ukubhekana nawo.
