Kanjani ukwakha histogram Excel neZwi

Akekho owayengalwa sokuphikisa iqiniso lokuthi i-histogram - ithuluzi kuhle zibukeke ukubonisa idatha. ngifuna nje at eshadini, kungenzeka ngesikhathi esifushane ukuhlola isimo ngaphandle asebenzise ukuhlaziya amanani ezinombolo ethebuleni. Yingakho nezwe odumile isihleli se-spreadsheet "Excel" wathatha izingalo ithuluzi.

Kulesi sihloko sizofunda ngokuthi singakugwema kanjani ukwakha igrafu ibha Excel. Kunezindlela ezine wokwakha zezikhali, ngamunye okuyinto ngokwanele ezahlukene phakathi kwabo kukhona. Ngakho-ke kubalulekile ukuba uqede ukufunda isihloko esithi kuze kube sekupheleni, ukuze ukhethe indlela ngokwabo. Ekupheleni kwe-athikili futhi kuyoba isibonelo histogram e "uLizwi."

histogram

Ku-Excel, kungenzeka ukuba kwakhiwe histogram izindlela ezintathu:

• usebenzisa ithuluzi ekhethekile;
• Ukusebenzisa -kho
• nge-add-on.

Manje sibheka zonke izindlela ukwakha histogram Excel. By endleleni, it zingenziwa ngezindlela ezahlukene - ukuba ingxenye yeseli othize noma njengendlela into ehlukile.

Indlela yokuqala: ukwakhiwa histogram ezivamile

Ukwakhiwa iqala ukwabiwa etafuleni endaweni, ukubaluleka okuzokwenziwa siboniswa histogram esizayo. Uma ukukhethwa iye yenziwa, kufanele uye kuthebhu "Faka". Kuyadingeka ukuba chofoza inkinobho "Histogram", okuyinto etholakala "Imidwebo".

Ekugcineni, phambi kwakho kuyinto uhlu oluningiliziwe lapho udinga ukukhetha omunye amashadi. By endleleni, le-histogram evamile livela kuqala ohlwini.

Ngemva kokukhetha Excel kuyoba inketho oyifunayo, futhi kulesi sakhiwo kungenziwa kubhekwe njengento igcwaliswe. Nokho, ungahlela histogram, usebenzisa amathuluzi ezisesandleni iqembu amathebhu onesihloko esithi "Ukusebenza Amashadi".

Indlela yesibili: ukwakhiwa ekuqongeleleni

Njengoba indlela yokuqala, kudingeka itafula ozinikele. I-histogram kulokhu yakhiwe ngendlela ehlukile kancane. Into yokuqala kufanele sinake - leli kuyigama enhlokweni: akufanele kube. Kungenjalo, akwenzeki lutho.

Ngemva Ukukhetha kumelwe uye kuthebhu "Faka", chofoza "Amashadi" ekudonseleni phansi imenyu "Histogram" ukukhetha ozithandayo. Kuyaphawuleka ukuthi ukuqongelela histogram kukhona engxenyeni kwesokudla uhlu.

Ngokukhetha yezinto, ubone isimiso uyibhala ephepheni. I-histogram, njengoba enqubeni odlule zingaguqulwa ngokubona kwakho, lokhu usebenzisa amathuluzi, okuyinto zitholakala eqenjini amathebhu "Ukusebenza Amashadi".

Indlela yesithathu: ukwakhiwa usebenzisa add-on

Manje thina uqhubekela indlela yesithathu kanjani ukwakha histogram. Siqukethe e ukusetshenziswa ekhethekile ukuhlaziywa iphakethe.

Isinyathelo sokuqala ukuba uthole ukuthi kusebenze iphakethe. Ukuze wenze lokhu, kudingeka uhlelo ekuqaleni chofoza inkinobho "Ifayela". Okulandelayo ibha eseceleni iya ku "Izilungiselelo" sigaba. Manje, thola into "Engeza-Ins" kwimenyu olukumabhekezansi "Control" khetha "Excel Engeza-ins." Bese uchofoza "Hamba" inkinobho.

Uyoba add-ins ibhokisi lapho udinga ukubeka umkhaza eduze "Ukuhlaziywa ToolPak" bese uchofoza inkinobho "OK".

Ngakho, ukuhlaziya iphakethe icushiwe. Manje histogram wenziwa "Idatha" - yiya lapho.

On the yamathuluzi, udinga cindezela "Idatha Ukuhlaziywa", itholakala ohlangothini okulungile "Ukuhlaziywa". Iwindi livela ofuna ukugqamisa "Histogram" bese ucindezela inkinobho "OK".

Lokhu kuzovula kwelinye iwindi lapho udinga ukusetha kwemigomo Ngokuzayo yombonisomdwebo. Esikhathini "wokufaka ububanzi" udinga ukucacisa indawo etafuleni, yilapho kungena khona idatha izosetshenziselwa ukwakhiwa. Ngemva kwalokho, khetha ibhokisi eliseduze ku- "Bonisa izithombe". Manje ungakwazi kuphela ucacise lapho ishadi kuzovezwa. ibhuku lokusebenza elisha, lokusebenza elisha noma eshidini - Kukhona ezintathu ongakhetha kukhona. Ngemva izilungiselelo asethwe, cindezela inkinobho "OK".

Ngokusho imiphumela esibekiwe indawo histogram igrafu yakho ibonakala.

Indlela yesine: ukwakha kanye ukuhlela okunombandela

Indlela yesine ukwakha histogram, ngokuyisisekelo sihluke konke okungenhla wethulwa. Ekupheleni ukuhlaziya yakhe, uzobona wena kule.

Ekuqaleni, njengasezikhathini zasendulo, kudingeka ukhethe indawo etafuleni, yilapho kungena khona idatha izosetshenziselwa ukwakhiwa. Lapho esekwenzile lokhu, iya ku "Ekhaya" yamathuluzi, vula okuya phansi uhlu "okunemibandela Ukufometha". Kuyo udinga ukuthola into "histograms" futhi ewindini ewumphumela, khetha uhlobo histogram. Kukhona izinketho ezimbili yilezi: ukugcwalisa umyela futhi okuqinile. Umehluko okukukho cishe akukho akukho, ukuze ukwazi ukugxila ukunambitheka yakho siqu lapho ukhetha.

Uma ukhetha uhlobo histogram, sizovela kumaseli ethize ngesimo umugqa ukugcwaliswa.

Histogram e "uLizwi"

Manje ake sibone ukuthi ukwenza i-histogram e "uLizwi." Enkabeni yalo, inqubo indalo yayo akuyona okuningi ezahlukene kusukela "Excel", kodwa izinto zokuqala kuqala.

Ekuqaleni, khetha ngokucindezela inkinobho yesinxele, endaweni lapho ufuna ukufaka i-histogram. Ngemva kwalokho, yana kwi-tab "Faka" futhi ku "Isithombe", chofoza inkinobho "Faka Ishadi" - izovela iwindi elihambisana.

Ebhokisini eseceleni, khetha isigaba "Histogram," futhi ohlangothini lwesokudla, ucacise uhlobo histogram. Njengoba ubona, kukhona kokubili abavamile futhi ukonga - ukukhetha kwesokudla bese ucindezela inkinobho "OK".

Uyibhala "Lesigceme" histogram lakho livela. Qaphela ukuthi ngaphansi kuyoba encane "ekselevskaya" etafuleni ngoba kufakwa. Setha eziguquguqukayo edingekayo, futhi ujabulele umphumela.

Manje ngoba sewuyazi ukuthi kanjani ukwenza histogram e "uLizwi." Kufanele kuqashelwe, akusona nzima kunokuphila "Eksele".