Ukwakha i-histogram kuMicrosoft Excel

I-histogram iyithuluzi elihle lokubona idatha. Lo ngumdwebo obonakalayo ongasivivinya ngokushesha leso simo sonke, ngokusibuka nje, ngaphandle kokufunda idatha yamanani etafuleni. Kunamathuluzi amaningi eMicrosoft Excel eklanyelwe ukwakha izinhlobo ezahlukahlukene zama-histogram. Ake sibheke izindlela ezahlukahlukene zokwakha.

Isifundo: Ungayakha kanjani i-histogram kuMicrosoft Word

I-Histogram

Ungakha i-histogram ku-Excel ngezindlela ezintathu:

• Kusetshenziswa ithuluzi eliyingxenye yeqembu Amashadi;
• Kusetshenziswa ukufomatha okunemibandela;
• Kusetshenziswa iphakheji yokuhlaziya yokungezelela.

Ingasenziwa njengento ehlukile, noma uma kusetshenziswa ukufomatha okunemibandela, njengengxenye yeseli.

Indlela yoku-1: dala i-histogram elula ebhodini eshadini

I-histogram elula kunazo zonke yenziwa kalula usebenzisa umsebenzi kubhulashi lamathuluzi Amashadi.

1. Sakha itafula eliqukethe idatha eboniswe eshadini elizayo. Khetha ngegundane lawo makholomu etafula azoboniswa kuma-axes e-histogram.



2. Ukuba kuthebhu Faka chofoza inkinobho I-Histogrametholakala kubambo kubhokisi lamathuluzi Amashadi.
3. Kuluhlu oluvulayo, khetha eyodwa yezinhlobo ezinhlanu zemidwebo elula:
   • i-histogram;
   • volumetric;
   • i-cylindrical;
   • i-conical;
   • i-pyramidal.

   Yonke imidwebo elula itholakala ohlangothini lwesobunxele lohlu.

   Ngemuva kokuthi ukhetho lwenziwe, kwakhiwa i-histogram kwiphepha le-Excel.



Kusetshenziswa amathuluzi atholakala eqenjini lethebhu "Ukusebenza namashadi" Ungahlela into elandelayo:

• Shintsha izitayela zekholomu;
• Sayina igama leshadi lilonke, nezimbazo zalo ngazinye;
• Shintsha igama bese ususa lean, njll.

Isifundo: Ungayenza kanjani ishadi ku-Excel

Indlela 2: ukwakha i-histogram ngokuqongelela

I-histogram ehlanganisiwe iqukethe amakholomu afaka amanani ambalwa ngasikhathi sinye.

1. Ngaphambi kokuqhubeka nokwakhiwa kweshadi elinokuqongelela, kufanele uqiniseke ukuthi igama alikho kunhlokweni kukholamu kwesokunxele. Uma kukhona igama, khona-ke kufanele lisuswe, ngaphandle kwalokho ukwakhiwa komdwebo ngeke kusebenze.



2. Khetha itafula ngesisekelo okuzokwakhiwa ngalo i-histogram. Kuthebhu Faka chofoza inkinobho I-Histogram. Kuluhlu lwamashadi avelayo, khetha uhlobo lwe-histogram ngokuqongelela esikudingayo. Zonke zitholakala ohlangothini lwesokunene lohlu.



3. Ngemuva kwalezi zenzo, i-histogram ivela ephepheni. Ingahlelwa kusetshenziswa amathuluzi afanayo axoxwa ngencazelo yendlela yokuqala yokwakha.

Indlela 3: yakha usebenzisa “Iphakheji Yokuhlaziya”

Ukuze usebenzise indlela yokwenza i-histogram usebenzisa iphakheji lokuhlaziywa, udinga ukwenza kusebenze le phakeji.

1. Iya kuthebhu Ifayela.



2. Chofoza igama lesigaba "Izinketho".



3. Iya esigatshaneni "Okengezwayo".



4. Ebhlokini "Abaphathi" hambisa switch uye esikhundleni I-Excel-Ins-Ins.



5. Ewindini elivula, eduze kwento Iphakheji Yokuhlaziya setha uphawu lokuchofoza bese uchofoza inkinobho "Kulungile".



6. Hambisa kuthebhu "Idatha". Chofoza inkinobho etholakala kubambo "Ukuhlaziywa kwedatha".



7. Ewindini elincane elivulayo, khetha Ama-histogram. Chofoza inkinobho "Kulungile".



8. Iwindi lezilungiselelo ze-histogram liyavula. Ensimini Isikhawu sokufaka faka ikheli lebanga lamaseli ama-histogram esifuna ukuwabonisa. Qiniseka ukuthi ubheka ibhokisi elingezansi "Ukukhipha igrafu". Kumapharamitha wokufaka, ungacacisa ukuthi i-histogram izokhonjiswa kuphi. Ngokuzenzakalelayo - eshidini elisha. Ungacacisa ukuthi okukhishwayo kuzoba kuleli shidi kumaseli athile noma encwadini entsha. Ngemuva kokuthi wonke amasethingi afakiwe, cindezela inkinobho "Kulungile".

Njengoba ukwazi ukubona, i-histogram yakheka endaweni oyichazile.

Indlela 4: Amashadi weBha enezimo ezinemibandela

Ama-histogram nawo angaboniswa ngamaseli wokufometha anombandela.

1. Khetha amaseli anemininingwane esifuna ukuyifomatha njenge-histogram.
2. Kuthebhu "Ikhaya" kuthebhu chofoza inkinobho Ukufomatha okunemibandela. Kumenyu eyehlayo, chofoza entweni I-Histogram. Ohlelweni lwama-histogram ngokugcwaliseka okuqinile nokunobungako okuvela, sikhetha eyodwa esicabanga ukuthi ilungile kakhulu esimweni ngasinye.

Manje, njengoba ubona, iseli ngalinye elifomathiwe linenkomba, okuyinto nge-histogram elibonisa isisindo semininingwane ekilo.

Isifundo: Ukufomatha okunemibandela ku-Excel

Sikwazile ukwenza isiqiniseko sokuthi iprosesa yetafula le-Excel linikeza amandla okusebenzisa ithuluzi elilula njengama-histogram ngendlela ehluke ngokuphelele. Ukusetshenziswa kwalomsebenzi othokozisayo kwenza ukuhlaziya idatha kubonakale kakhulu.