Indlela yokwenza i-histogram kwi-Excel

I-histogram sisixhobo esibalulekileyo kuhlalutyo lwedatha. Ikuvumela ukuba ubone ngeso lengqondo ukuhanjiswa rhoqo kweseti yedatha kwaye uqonde ukuziphatha kwayo. Kweli nqaku, siza kuhlolisisa indlela yokwenza i-histogram kwi-Excel, enye yezona zicelo ezisetyenziswa kakhulu kwintsimi yezobugcisa. Nge Inyathelo nenyathelo iingcebiso ezineenkcukacha kunye nezisebenzayo, uya kufunda ukusebenzisa iimpawu ze-Excel ukudala iihistograms ezichanekileyo nezisebenzayo. Fumana indlela yokufumana okuninzi kwesi sixhobo sinamandla kwaye uphucule izakhono zakho zokuhlalutya idatha. Masiqalise!

1. Intshayelelo ekudaleni iihistograms kwi-Excel

I-histogram sisixhobo somzobo esisetyenziswa kakhulu kuhlalutyo lwedatha. Kubaluleke kakhulu ukumela usasazo rhoqo lweseti yedatha. Kwi-Excel, kuyenzeka ukwenza i-histograms ngokulula nangokukhawuleza usebenzisa imisebenzi eyakhelweyo kwinkqubo. Kweli candelo, siza kuphonononga amanyathelo okwenza i-histograms kwi-Excel kwaye sifunde ukutolika iziphumo ezifunyenweyo.

Ngaphambi kokuba uqale ukwenza i-histogram kwi-Excel, kubalulekile ukuqiniseka ukuba unayo idatha ehleliweyo kwi-spreadsheet. Idatha kufuneka ibe kwimiqolo kwaye ibe ngamanani. Nje ukuba idatha ilungile, sinokuqhubeka nokwenza i-histogram.

Ukwenza i-histogram kwi-Excel, silandela nje la manyathelo alandelayo: okokuqala, sikhetha idatha esifuna ukuyifaka kwi-histogram. Emva koko, sikhetha ithebhu ethi "Faka". ibar yesixhobo ye-Excel kwaye ucofe ku-"Histogram" kwiqela le-"Graphics". Emva koko, sikhetha uhlobo lwe-histogram esifuna ukuyenza, njenge-histogram yekholomu okanye i-histogram yomgca. Ekugqibeleni, sicofa u-"Kulungile" kwaye i-Excel iya kwenza ngokuzenzekelayo i-histogram ngokusekelwe kwidatha ekhethiweyo.

Kubalulekile ukukhumbula ukuba i-histogram ngumboniso obonakalayo wokusasazwa rhoqo kweseti yedatha. Ibha nganye kwi-histogram imele uluhlu lwamaxabiso, kwaye ukuphakama kwebar kubonisa ukuphindaphinda kokwenzeka kwezo xabiso kwiseti yedatha. Xa utolika i-histogram, kubalulekile ukunikela ingqalelo kwimilo yokusabalalisa, ukuthambekela okuphakathi, kunye nabangaphandle. I-Excel ibonelela ngezixhobo ezongezelelweyo ukwenza i-histogram kwaye yongeze ulwazi olongezelelweyo, olufana neelebhile ze-axis kunye nezihloko.

2. Ukulungiswa kwedatha yokwakha i-histogram kwi-Excel

Ngaphambi kokwakha i-histogram kwi-Excel, kuyimfuneko ukulungiselela idatha ngokufanelekileyo. Nanga amanye amanyathelo ofanele uwalandele:

1. Lungiselela idatha yakho: Qinisekisa ukuba unedatha yakho kwikholamu ye-Excel. Ukuba uqokelele idatha, yahlula ulwazi kwaye uyibeke kwiiseli ezahlukeneyo. Gcina ukhumbule ukuba idatha kufuneka ibe ngamanani kwaye iodolwe ukusuka kwencinci ukuya kweyona inkulu.

2. Qinisekisa inani lezithuba: Inani lezithuba kwi-histogram lixhomekeke kubungakanani bedatha yakho kunye nesixa solwazi ofuna ukulubonisa. Umgaqo jikelele wobhontsi kukusebenzisa phakathi kwe-5 kunye ne-20 yezithuba. Ukumisela inani elifanelekileyo, ungasebenzisa ifomula kaSturge, eyi inani lezithuba = 1 + log₂(n)apho n linani ledatha.

3. Ukukhetha izithuba ezifanelekileyo ze-histogram

Ukukhetha uluhlu olufanelekileyo lwe-histogram yakho, kubalulekile ukuqwalasela izinto ezimbalwa eziphambili. Okokuqala, kufuneka sichaze uluhlu lwedatha esiza kuyisebenzisa. Oku kunokwenziwa ngokubala ubuncinci kunye nexabiso eliphezulu loluhlu lwedatha. Ngokomzekelo, ukuba sisebenza ngedatha emele ukuphakama kwabantu, sinokumisela uluhlu lokuphakama ukusuka kwi-150 cm ukuya kwi-200 cm.

Nje ukuba sinoluhlu lwedatha, kufuneka sithathe isigqibo ngenani lezithuba esifuna ukulisebenzisa kwihistogram yethu. Umgaqo jikelele wesithupha kukusebenzisa phakathi kwe-5 kunye ne-20 intervals, kuxhomekeke kubungakanani besampuli kunye nokusabalalisa idatha. Ukuba sinesampulu encinci, kuyacetyiswa ukuba sisebenzise amaxesha ambalwa ukuphepha ukugcwala kolwazi.

Enye indlela eqhelekileyo kukusebenzisa umgaqo wesilayidi ukumisela ububanzi bezithuba. Umgaqo odumileyo yifomula yeSturges, ecebisa ukubala inani lezithuba kusetyenziswa le fomula ilandelayo: Inani lezithuba = 1 + log₂N, apho i-N isayizi yesampulu. Le fomula inceda ukuseka amaxesha alinganayo nafanelekileyo okusasazwa kwedatha.

4. Ukwenza itheyibhile yefrikhwensi kwi-Excel

Itheyibhile yefrikhwensi kwi-Excel sisixhobo esiluncedo sokulungelelanisa kunye hlalutya idatha. Ngale tafile, sinokubona ukuhanjiswa kwedatha kwaye sifumane ulwazi olufanelekileyo malunga nokuphindaphinda kwexabiso ngalinye. Okulandelayo, siza kukubonisa indlela yokwenza itafile rhoqo kwi-Excel ngamanyathelo ambalwa.

1. Vula i-Excel kwaye uqinisekise ukuba unedatha ofuna ukuyihlalutya kwikholamu. Unokuba namakholomu amaninzi njengoko ufuna, kodwa kulo mzekelo, siya kugxininisa kwikholamu enye.

2. Khetha yonke ikholamu yedatha. Ungakwenza oku ngokunqakraza unobumba wekholamu okhokelwa ngumhlathi okanye ngokukhetha iseli kumhlathi kwaye ucinezele Ctrl + Shift + Utolo olusezantsi ukukhetha ngokuzenzekelayo ukuya esiphelweni soluhlu.

5. Ukusebenzisa umsebenzi wokubala ukufumana iifrikhwensi kwi-Excel

Ukufumana iifrikhwensi kwi-Excel, sinokusebenzisa umsebenzi wokubala, isixhobo esiluncedo ukubala inani lamaxesha ixabiso elithile livela uluhlu lweeseli. Amanyathelo ekufuneka uwalandele ukusebenzisa lo msebenzi aya kuchazwa ngezantsi. ngempumelelo.

1. Khetha uluhlu lweeseli apho sifuna ukubala iifrikhwensi. Qinisekisa ukuba uluhlu lugubungela zonke iiseli eziqulathe amaxabiso anokubalwa.

• Inyathelo elicetyiswayo: Ukuba idatha yokubala ikwikholamu, ungakhetha yonke ikholamu ngokunqakraza unobumba wekholamu phezulu kwi-spreadsheet.

2. Kwibha yefomula, bhala umsebenzi wokubala, onesintaksi ilandelayo: =COUNT(uluhlu). "Uluhlu" luluhlu lweeseli ezikhethiweyo kwinyathelo langaphambili.

3. Cofa iqhosha elithi «Faka» ukufumana isiphumo somsebenzi wokubala. Inani elibuyisiweyo kukuphindaphindwa kwexabiso elikhethiweyo kuluhlu oluchaziweyo lweeseli.

• Ingcebiso: Ukuba ufuna ukubala ukuphindaphindwa kwamaxabiso ahlukeneyo ahlukeneyo, ungaphinda inyathelo lesi-2 ngexabiso ngalinye okanye usebenzise umsebenzi wokubala ngoluhlu olwahlulwe ngokwekoma lwamaxabiso.

Ukusebenzisa umsebenzi wokubala kwi-Excel yindlela elula nesebenzayo yokufumana ama-frequencies amaxabiso kuluhlu lweeseli. Ngala manyathelo, uya kukwazi ukubala ngokuchanekileyo ukuphindaphinda kwalo naliphi na ixabiso kwi-spreadsheet sakho, okukuvumela ukuba wenze uhlalutyo lwamanani kwaye ukhuphe ulwazi oluphambili idatha yakho.

6. Ukwakhiwa kweTshati ye-Histogram kwi-Excel

Ukwakha itshati ye-histogram kwi-Excel, landela la manyathelo:

1. Vula incwadi entsha ye-Excel kwaye wenze ikholamu kunye nedatha ofuna ukuyimela kwi-histogram.
2. Khetha idatha kwaye ucofe ithebhu ethi "Faka" kwiribhoni.
3. Kwiqela elithi "Iitshathi", cofa iqhosha elithi "Kholamu" kwaye ukhethe uhlobo lwekholamu ethi "Histogram" kwimenyu eyehlayo.
4. Ngoku, i-Excel iyakwenza ngokuzenzekelayo itshathi ye-histogram esisiseko isebenzisa idatha ekhethiweyo.
5. Ukwenza ngokwezifiso inkangeleko ye-histogram, cofa ekunene kwitshathi kwaye ukhethe "Ukhetho Lwetshati."
6. Kwimenyu eyehlayo, ungahlengahlengisa iilebhile ze-axis, ifomathi yetshathi, kunye nolunye ukhetho.
7. Unokongeza izihloko kwitshathi kwaye utshintshe imibala ukugqamisa iindawo ezahlukeneyo zedatha.

Igrafu ye-histogram sisixhobo esihle sokujonga ukuhanjiswa kwedatha. Ngokulandela la manyathelo, uya kuba nakho ukwenza itshati ye-histogram yesiko kwi-Excel ehambelana neemfuno zakho ezithile.

Khumbula ukuba ukuchaneka kwe-histogram yakho kuya kuxhomekeka kumgangatho kunye nobuninzi bedatha enikeziweyo. Ukuba ufuna ukufunda ngakumbi malunga nokuphucula iitshathi zakho ze-histogram kwi-Excel, zininzi izifundo ezifumanekayo kwi-intanethi ezinokukunika iingcebiso ezongezelelweyo kunye namaqhinga aphambili.

7. Ukwenza ngokwezifiso i-Histogram kwi-Excel: Ukulungelelanisa ii-Axes kunye neeLabels

Kwi-Excel, kunokwenzeka ukwenza i-histogram ngokulungisa ii-axes kunye neelebhile ukuphucula ukucaca kunye nokunikezelwa kwedatha. Olu phawu luluncedo ngakumbi xa usebenza ngeeseti zedatha ezinkulu okanye ezinzima. Ngezantsi ngamanyathelo okwenza i-histogram kwi-Excel:

1. Qinisekisa ukuba idatha yakho ye-histogram ihlelwe ngokufanelekileyo kwiikholamu okanye kwimiqolo kwi-spreadsheet ye-Excel.
2. Khetha idatha ye-histogram kwaye ucofe ithebhu ethi "Faka" kwi-toolbar ye-Excel.
3. Kwiqela elithi "Iitshathi", cofa iqhosha elithi "Histogram" kwaye ukhethe uhlobo lwe-histogram ofuna ukuyenza.
4. Emva kokudala i-histogram, nqakraza ngakwesokudla naphi na kwitshathi kwaye ukhethe "Iinketho ze-Axis" kwimenyu yokuhla. Oku kuya kuvula ifestile ngeendlela ezininzi zokhetho.
5. Kwithebhu ethi "Axes", unokuhlengahlengisa isithuba se-axes kwaye utshintshe iiyunithi zokulinganisa. Ungakhankanya nokuba uyafuna ukuba izembe zibengumgca okanye isikali selogarithmic.
6. Kwi-"Labels" ithebhu, unokutshintsha ifomathi ye-X-axis kunye ne-Y-axis iilebula, kunye nokongeza okanye ukususa iilebula zesibini.
7. Zama ngezicwangciso ezahlukeneyo de ube wonwabile ngokujonga kunye nokufundeka kwe-histogram.

Ngala manyathelo alula, unokwenza ngokulula i-histogram kwi-Excel ngokuhlengahlengisa ii-axes kunye neelebhile ngokweemfuno zakho. Khumbula ukuba ingcaciso ecacileyo yedatha ibalulekile ukuze ukwazi ukuyitolika ngokuchanekileyo, ngoko ke kubalulekile ukuchitha ixesha ulungisa i-histogram. Ukongeza, unokujonga ezinye iinketho zokwenza ngokwezifiso ezikhoyo kwi-Excel ukuze ufumane iitshathi ezinomtsalane kunye nezobuchwephesha.

8. Ukongeza izihloko kunye neentsomi kwi-histogram kwi-Excel

Ukongeza izihloko kunye neentsomi kwi-histogram yakho kwi-Excel, kufuneka uqale uqinisekise ukuba unayo idatha efanelekileyo kunye ne-histogram esele yenziwe kwi-spreadsheet yakho. Emva koko, landela la manyathelo:

1. Cofa kwi-histogram ukuze uyikhethe. Ithebhu ethi "Izixhobo zeTshati" iya kuvela kwiribhoni ye-Excel.

2. Kwi-Design thebhu, kwiqela leeLebhile, cofa Yongeza iNqaku yeTshati uze ukhethe isihloko seTshati. Ibhokisi yokubhaliweyo iya kuvela kwihistogram.

3. Kwibhokisi yombhalo, chwetheza isihloko esifunwayo se-histogram yakho kwaye ucinezele u-"Enter." Isihloko siya kongezwa ngentla kwe-histogram.

Ukuba ufuna ukongeza iintsomi kwihistogram yakho, landela la manyathelo ongezelelweyo:

1. Cofa ekunene kwi-histogram kwaye ukhethe "Khetha iDatha" kwimenyu yemeko.

2. Kwifestile evelayo ethi "Khetha uMthombo weDatha", cofa iqhosha elithi "Yongeza" kwicandelo elithi "Chart Series".

3. Kwibhokisi yencoko ethi "Hlela uthotho lweDatha", ungafaka igama lelegend kwibala elithi "Series Name" kwaye ukhethe uluhlu lwedatha yelegend kwibala elithi "Series Values". Cofa "Kulungile" xa ugqibile.

Ulungile! Ngoku i-histogram yakho kwi-Excel iya kuba nesihloko esiko kunye neentsomi eziya kukunceda ukuba ubone kakuhle kwaye uqonde idatha yakho. Khumbula ukuba unokuzama ngeendlela ezahlukeneyo kunye nezinto zoyilo ukuze wenze ngokwezifiso i-histogram yakho kwiimfuno zakho.

9. Ukusetyenziswa kweefomathi ezibonakalayo kunye nezitayela kwi-histogram kwi-Excel

Le yi ngempumelelo ukuphucula unikezelo kunye nokutolikwa kwedatha. Ngokusebenzisa iindlela ezahlukeneyo zokufomatha, kuyenzeka ukuqaqambisa amanqaku aphambili kunye nokuququzelela ukuqonda kolwazi lomzobo. Kweli candelo, siza kuphonononga ezinye izicwangciso zokusebenzisa ukufomatha okubonakalayo kunye nezimbo kwi-histogram kwi-Excel.

Ukuqala ukwenza i-histogram, Ingenziwa Cofa ekunene kwitshathi kwaye ukhethe "iFomathi yeDatha yeTshati" kwimenyu eyehlayo. Kolu khetho, indawo yolawulo iya kuvula ngeethebhu ezahlukeneyo ezikuvumela ukuba uhlele imibala, iifonti, imigca kunye nezinye izinto zetshathi. Kubalulekile ukukhumbula ukuba utshintsho luyasebenza ngexesha langempela, okwenza kube lula ukubona utshintsho.

Phakathi kwezona ndlela ziluncedo zokufomatha kukhetha imibala yesiko kwiibha ze-histogram, ukutshintsha uhlobo lwefonti kunye nobukhulu bezihloko kunye neelebhile, kunye nokongeza isithunzi okanye iziphumo zokubethelela ukuqaqambisa izinto ezithile. Ukongeza, i-Excel ibonelela ngeetemplates ezahlukeneyo ezichazwe kwangaphambili kunye nezitayile ezinokuthi zilungelelanise inkqubo yokwenza ngokwezifiso kwaye ziqinisekise uyilo lobuchwephesha kunye nobuhle obukholisayo.

10. Uhlalutyo kunye nokutolikwa kweziphumo ze-histogram kwi-Excel

Emva kokuba senze i-histogram kwi-Excel, kubalulekile ukuhlalutya kunye nokutolika iziphumo ezifunyenweyo. Oku kuya kusivumela ukuba siqonde ngcono ukuhanjiswa kwedatha kwaye senze izigqibo ezifanelekileyo kuhlalutyo lwethu. Ngezantsi, siza kukubonelela ngezikhokelo ezithile ukuze wenze lo msebenzi ngempumelelo.

Okokuqala, kufuneka sihlolisise imilo yonikezelo olumelwe kwi-histogram. Ngaba i-symmetrical, igobe ekunene okanye ekhohlo? Olu hlalutyo lunokusixelela ukuba idatha ibonisa ugxininiso kuluhlu oluthile okanye ukuba, ngokuchaseneyo, zihlakazekile ngakumbi. Ukongezelela, kubalulekile ukunikela ingqalelo kwizinto ezinokuthi ziphume ngaphandle okanye i-anomalies enokuthi ichaphazele ukutolikwa kweziphumo.

Enye inkalo ephambili kuhlalutyo lobude beebha ze-histogram. Oku kubonisa ukuphindaphinda okanye ipesenti yokwenzeka kodidi oluthile okanye ikhefu. Ungasebenzisa izixhobo ze-Excel ukufumana izibalo ezichazayo ezifana nentsingiselo, i-median, kunye nemowudi, eya kukunceda uqonde ngcono ukusabalalisa kunye nokuthambekela okuphakathi kwedatha yakho. Khumbula ukuba, kuxhomekeke kumxholo kunye neenjongo zohlalutyo lwakho, uya kukwazi ukwenza izigqibo ngokusekelwe kwezi ziphumo.

11. Ukusebenzisa izixhobo zokuhlalutya ezongezelelweyo ze-histogram kwi-Excel

Ukuncedisa i-histogram feature kwi-Excel, kukho izixhobo zokuhlalutya ezongezelelweyo ezinokubonelela ngobunzulu obukhulu ekutolikeni kwedatha. Esinye sezi zixhobo luhlalutyo lwentsingiselo, ekuvumela ukuba uchonge iipateni kunye notshintsho kwidatha ekuhambeni kwexesha. Lo msebenzi uluncedo ngakumbi ekuchongeni iintsingiselo zexeshana kunye nexesha lonyaka, ukunceda ukwenza izigqibo ezinolwazi ngakumbi.

Esinye isixhobo esiluncedo sokuncedisa i-histogram luhlalutyo lokubuyisela. Obu buchule buvumela ukuba siqonde ubudlelwane phakathi kwezinto ezimbini eziguquguqukayo kwaye siqikelele amaxabiso exesha elizayo asekwe kobo budlelwane. Ngokusebenzisa uhlalutyo lokuhlehla kwidatha ye-histogram, kuyenzeka ukuba ufumane uqikelelo lwamaxabiso anokuthi kwenzeke kwixesha elizayo, oluluncedo kucwangciso lwemeko kunye noqikelelo.

Ukongezelela, uhlalutyo lokulungelelanisa sesinye isixhobo esincedisayo esinokusetyenziswa ngokubambisana ne-histogram kwi-Excel. Unxulumano lusivumela ukuba siqonde ukuba kukho ubudlelwane phakathi kwezinto ezimbini eziguquguqukayo kunye nokuba lomelele kangakanani olu budlelwane. Ngokusebenzisa esi sixhobo kunye ne-histogram, kunokwenzeka ukuba ufumane iipateni ezifihliweyo kwidatha kwaye uqonde ngcono ubudlelwane phakathi kwezinto ezihlalutywayo.

12. Yabelana kwaye uthumele i-histogram kwi-Excel

Ukuze wenze oku, landela la manyathelo:

1. Vula ifayile ye-Excel equlethe i-histogram ofuna ukwabelana ngayo kunye nokuthumela ngaphandle.

2. Khetha uluhlu lweeseli eziqulethe i-histogram.

3. Cofa ekunene uluhlu olukhethiweyo kwaye ukhethe "Kopisha" kwimenyu ehlayo.

4. Vula i-Excel sheet entsha okanye ifayile entsha ye-Excel engenanto.

5. Cofa ekunene kwiseli engenanto kwaye ukhethe u-"Cola" kwimenyu ehlayo. Ihistogram iya kuncanyathiselwa kwiphepha le-Excel.

6. Unokwenza uhlengahlengiso olongezelelweyo kunye nokwenza ngokwezifiso kwi-histogram kwi-Excel, njengokutshintsha imibala, iilebhile ze-axis, okanye ubungakanani befonti. Oku kuya kukuvumela ukuba ulungelelanise i-histogram kwiimfuno zakho ezithile.

7. Nje ukuba wenze zonke izilungiso eziyimfuneko, unokugcina ifayile ye-Excel kwaye wabelane ngayo nabanye. Unako kwakhona ukuthumela ngaphandle ifayile kwiifomathi ezahlukeneyo, njengePDF okanye ifomathi yomfanekiso, ukuze ijongwe ngokulula kwaye isetyenziswe kuyo ezinye iinkqubo.

Ngokulandela la manyathelo, uya kukwazi ukwabelana ngokulula kunye nokuthumela i-histogram kwi-Excel, ikuvumela ukuba ubonise kwaye uhlalutye idatha ngendlela esebenzayo nebonakalayo. Ungalibali ukugcina umsebenzi wakho kwaye uhlale ujonge uhlaziyo kunye nezixhasi ezibonelela nge-Excel ukuphucula unikezelo lweehistograms zakho!

13. Ukusombulula iingxaki eziqhelekileyo xa udala i-histogram kwi-Excel

Ukuba ufumana ubunzima bokwenza i-histogram kwi-Excel, ungakhathazeki, nazi izisombululo eziqhelekileyo zokusombulula ezi ngxaki:

1. Qinisekisa idatha: Qinisekisa ukuba idatha oza kuyisebenzisa ukwenza i-histogram ihlelwe ngokuchanekileyo kwimiqolo okanye kwimiqolo. Kwakhona kubalulekile ukuqinisekisa ukuba akukho ziseli ezingenanto okanye idatha engachanekanga enokuchaphazela ukudalwa kwe-histogram.

2. Sebenzisa isixhobo sokuHlalutya iDatha: Ukuba awukwazi ukufumana ukhetho lokudala i-histogram kwi-Excel, unokufuna ukwenza isixhobo sokuHlalutya idatha. Ukwenza oku, yiya kwithebhu ethi "Ifayile", khetha u- "Options" kwaye emva koko "Izongezo." Qinisekisa ukuba ibhokisi yoHlolo lweDatha ikhangelwe kwaye ucofe "Kulungile." Ngoku, kufuneka ukwazi ukufikelela kwisixhobo sokuHlalutya iDatha kwaye uyisebenzise ukwenza i-histogram yakho.

3. Landela isifundo senyathelo ngenyathelo: Ukuba usatsala nzima, unokukhangela izifundo zokufundisa kwi-intanethi ezikukhokelayo kwinkqubo yokwenza i-histogram kwi-Excel. Ezi tutorials zihlala zibonelela ngemiyalelo eneenkcukacha kunye nescreenshots ukukunceda uqonde ngcono inyathelo ngalinye lenkqubo. Ukongeza, unokufumana imizekelo kunye neetemplates eziza kukuvumela ukuba ugcine ixesha kunye nomzamo xa udala i-histogram yakho.

14. Iingcebiso kunye nezenzo ezilungileyo zokwenza ngokufanelekileyo i-histogram kwi-Excel

Ukwenza i-histogram kwi-Excel kunokuba ngumsebenzi olula ukuba ulandela iingcebiso kunye nezenzo ezilungileyo. Okulandelayo, siza kukubonisa amanyathelo ayimfuneko ukuyiphumeza ngokufanelekileyo:

1. Hlela idatha yakho

Ngaphambi kokuba uqale ukudala i-histogram kwi-Excel, kubalulekile ukulungelelanisa idatha yakho ngokufanelekileyo. Qinisekisa ukuba unekholamu enamaxabiso ofuna ukuwamela kwi-axis ethe tye yehistogram, kunye nenye ene-frequency okanye ubalo lwexabiso ngalinye. Khumbula ukuba idatha kufuneka ihlelwe ngokunyuka okanye ukwehla ukuze ufumane i-histogram echanekileyo.

2. Sebenzisa umsebenzi we-histogram

I-Excel inomsebenzi othile wokudala iihistograms ngokukhawuleza nangokufanelekileyo. Ukusebenzisa eli nqaku, yiya kwithebhu ethi "Idatha" kwaye ukhethe "Uhlalutyo lwedatha" kwiqela lezixhobo zokuhlalutya. Emva koko, khetha i "Histogram" ukhetho kwaye ucofe "Kulungile." Kwifestile eya kuvula, khetha uluhlu lwedatha kunye noluhlu lwemveliso ye-histogram. I-Excel iyakwenza ngokuzenzekelayo i-histogram kwi-spreadsheet esitsha.

3. Lungiselela ihistogram yakho

Nje ukuba ube ne-histogram eyenziwe kwi-Excel, ungayenza ngokweemfuno zakho. Ungatshintsha isihloko se-histogram, ukongeza iileyibhile kwii-axes, uguqule izithuba zeklasi, kwaye ulungelelanise ubuncinci kunye namaxabiso aphezulu. Ukwenza oku, khetha i-histogram kwaye uye kwithebhu ethi "Izixhobo zeTshati". Sebenzisa iinketho ezikhoyo kwi "Design" kunye neqela elithi "Format" ukwenza uhlengahlengiso olufunekayo. Kwakhona khumbula ukusebenzisa imibala efanelekileyo kunye nezimbo zokuqaqambisa ulwazi ngokucacileyo nangempumelelo.

Ukuqukumbela, kucacile ukuba i-Excel ibonelela ngesixhobo esilula nesisebenzayo sokwenza iihistograms. Ngokulandela amanyathelo achazwe kweli nqaku, nawuphi na umsebenzisi unokuvelisa i-histogram kwi-Excel kwaye athathe inzuzo yolu melo lwegraphical ukuhlalutya kunye nokubona idatha ngendlela emfutshane.

Ngokusebenzisa i-Excel-specific function and features, ezifana ne-CountIf function, i-Data Analysis tool, kunye nokukwazi ukwenza ngokwezifiso iinkcukacha ze-histogram, unokufumana iziphumo ezichanekileyo kunye nezomntu.

Ukongezelela, ukubaluleka kokukhetha ngokuchanekileyo uluhlu lwedatha kunye nenani lezithuba zagxininiswa, ekubeni zichaphazela ukutolikwa kweziphumo kwaye ziququzelele ukuqonda ukuhanjiswa kwedatha.

Isishwankathelo, ukwenza i-histogram kwi-Excel yinkqubo elula, kodwa iluncedo kakhulu kuhlalutyo lwedatha. Ngokuziqhelanisa okuncinci kunye nokulawula imisebenzi esisiseko ye-Excel, nawuphi na umsebenzisi unokusebenzisa esi sixhobo ukubonisa idatha ngendlela ekhangayo kwaye uqonde ngcono iintsingiselo kunye neepatheni emva kwamanani.