Njengoba i-histogram Excel

Ikhambi ekahle ukuze nginikeze idatha kuthebula nakanjani Histogram. Thayipha ishadi uyakwazi umsebenzisi evamile ukuba kudlule okushiwo eziyisisekelo wonke amanani, ngisho ngaphandle kokuyifunda.

Isihloko uzobe histogram adiliza Excel. Indlela ukukwenza, uzofunda ekupheleni kokufunda lesi sihloko. Ngaphezu kwalokho, uyoxazulula zonke umehluko wemisindo nemiqondo yamagama eziba khona phakathi nenkathi ukwakhiwa. Futhi, uzofunda ezine izinketho ezahlukene iyatholakala ezibonisa indlela yokwakha histogram Excel.

Izinketho ukuklanywa histogram ku "Excel"

Ethandwa kakhulu etafuleni umhleli inikeza kukho okulandelayo ukuze kwakhiwe i-histogram:

• ibha grafu elula;
• Histogram nge yokuzuza;
• besebenzisa ukuhlaziywa iphakethe;
• nge wokufomatha okunombandela amaseli.

Manje-ke, kufanele kuqashelwe ukuthi zonke embodiments ezingenhla zingase zimiswe kuthebula ahlukene into noma ingxenye yayo. Futhi manje ake udlulela ekuhlaziyweni indlela histogram Excel.

Indlela 1: A histogram elula

A elula kubhagrafu Excel is more ajwayele ukusetshenziswa. ukwakhiwa kwalo akuthathi isikhathi esiningi, futhi inqubo akudingi ngokujulile ulwazi uhlelo.

Ekuqaleni, isidingo ubeke eceleni e idatha ithebula ukuthi sizosetshenziswa isheduli esikhathini esizayo. Khona-ke udinga ukuya ithebhu "Faka" bese uchofoza "Amashadi". Lokhu kuvula menyu engaphansi nazo zonke izinhlobo etholakalayo yamashadi. Kulokhu, sicela uchofoze ithebhu "Histogram" kwimenyu eyehlayo, ukhethe uhlobo. Kuyaphawuleka ukuthi emgqeni ngamunye histogram elula ukufika kuqala, emva kokuba sele enze amalungiselelo ne-histogram ekuqongeleleni.

Ngakho ngokushesha nje uchofoza uthande ishadi ucezu uhlelo livela ngqo ishadi ngedatha ngaphambili endaweni ekhethiwe.

Nasi-histogram Excel. Indlela yokwenza umbhalo oqoshwe kulo, uyofunda kancane kamuva. Nakuba okungukuthi ukuthi izinguquko zingenziwa ngokusebenzisa amathuluzi ecenjini amathebhu "Ukusebenza Amashadi".

Indlela 2: Histogram nge ekuqongeleleni

Ubani kuzoxoxwa indlela ezibonisa indlela yokwakha histogram ezuziwe Excel. Isibonelo ungabona kulesi sihloko.

Eqinisweni indalo yayo akuhlukile indlela elula, kodwa kukhona caveat ukuthi kufanele azenze zikhanye. Ngaphambi isebenzisana histogram udinga ukususa igama kukholamu yekucala, uma ikhona, kungenjalo ngeke zisebenze.

Manje ungakha. Njengasekugumbuqelweni indlela odlule, kubalulekile ukwaba ingxenye etafuleni nge idatha izosetshenziselwa ukwakhiwa. Bese uya ithebhu "Faka" yamathuluzi olukumabhekezansi imenyu "Amashadi" iphuzu ukuze ukhombe "Histogram" bese ukhetha uhlobo USB. Kuwufanele ukukhumbula ukuthi emgqeni ngamunye, itholakala ohlangothini lwesokudla.

Ngemva ngokuchofoza omunye izinto ozibhalile ngeke ube esihambelanayo histogram ezuziwe Excel.

Njengezinye okokugcina, isimiso, ungenza izinguquko ezithile usebenzisa amathuluzi eqenjini ithebhu "Ukusebenza Amashadi". By endleleni, kuzo zombili izimo, ukushintsha ilebula eshadini, wena kuphela kudingeka ucindezele chofoza kabili kuso bese ukhetha igama elisha.

Indlela 3: Ukusebenzisa ukuhlaziywa iphakethe

Kusukela indlela eziwubala ukushintshela yokuthi inkimbinkimbi. Bambalwa abantu bazi ukuthi ngosizo uhlelo izengezo ungenza histogram, kodwa kungenziwa.

Isinyathelo sokuqala siwukuba ukungena ngokwabo superstructure. Ukuze wenze lokhu, chofoza ithebhu "Ifayela" bese ukhetha eseceleni nto "Izilungiselelo". Okulandelayo, iya ku esigabeni 'Izengezo ".

Phawula uhlu olwehlayo ka "Management". Kuyo Udinga ukukhetha "Excel Izengezo" bese uchofoza "Hamba" inkinobho. Izengezo izovela iwindi. Yibeke umkhaza eduze "Ukuhlaziywa ToolPak" bese uchofoza "OK".

Manje phindela emuva, etafuleni lakho, ukhethe indawo idatha, bese ukhetha ithebhu "Idatha". Kule thebhu udinga chofoza "Idatha Analysis ', okuyinto etholakala" Ukuhlaziywa ".

Ku-window evelayo, khetha kusukela uhlu "Histogram" bese ucindezela "OK" - ewindini izovela ofuna ukusetha nemingcele. Esikhathini "wokufaka umncele" kufanele inikwe endaweni idatha kwethebula. Uma pre-labelwe ke, inani okuyokwenziwa ngokuzenzakalelayo. Ngokulandelayo, khetha ibhokisi eliseduze ku- "Bonisa ingcaca" nangaphezulu nje ethi vele useyazi ukuthi iyona lwesikhathi ukudamba. Ngokusho imiphumela, chofoza inkinobho "OK".

Indlela 4: okunemibandela ukufomatha amaseli

Ukudala histogram ngale ndlela, udinga ukukhetha indawo idatha kanye "Ekhaya" ithebhu, chofoza "okunemibandela Ukufometha". Esikhathini uhlu olwehlayo, hambisa isikhombisi "Histogram" kwimenyu, khetha eyodwa yama-intandokazi izinhlobo igrafu.

Ngemva kwalokho, ingqamuzana ihlelwe kuyinto isikali ngokugcwele - lena histogram. Njengoba ungase ukuqagela, esikalini ubonisa isisindo idatha ambalwa yawo.

isiphetho

Lawa kwakungamadodana ngezindlela ezine ungakha igrafu ibha Excel. bangabaphingi bonke ezinhle ngendlela yabo futhi Site izidingo ezahlukene, ngakho-ke hlola yonke imininingwane bese ukhetha wayefisa.