Yuav Tsim Lub Histogram Hauv Excel Li Cas

Cov txheej txheem:

Yuav Tsim Lub Histogram Hauv Excel Li Cas
Yuav Tsim Lub Histogram Hauv Excel Li Cas

Video: Yuav Tsim Lub Histogram Hauv Excel Li Cas

Video: Yuav Tsim Lub Histogram Hauv Excel Li Cas
Video: How To Create A Histogram in MS Excel (u0026 change the bin size) on Urdu || Hindi 2024, Hlis ntuj nqeg
Anonim

Daim histogram yog lub graph uas qhia txog cov ntaub ntawv hauv kev tuav. Qhov siab ntawm kem nyob ntawm tus nqi ntawm cov ntaub ntawv, thiab lub sijhawm nruab nrab ntawm lawv nyob ntawm lub sijhawm ntawm lub sijhawm thaum cov ntaub ntawv no tau khaws.

Yuav tsim lub histogram hauv Excel li cas
Yuav tsim lub histogram hauv Excel li cas

Cov Lus Qhia

Kauj ruam 1

Tsim cov rooj thiab sau cov ntaub ntawv ntawm lub hauv paus uas koj yuav tsim cov histogram.

Kauj ruam 2

Xaiv cov xaim xaiv uas raug xaiv los ntawm lub rooj no. Hauv kab ntawv "Ntxig", xaiv "Daim Ntawv" xaiv los yog nyem rau ntawm "Daim Ntawv Qhia Siv Cov Khoom Siv" ntawm lub vev xaib ntsuas. Txhawm rau tsim cov histogram nrog lub chaw pib, tom qab xaiv lub xov tooj ntawm tes, nias F11. Daim histogram yuav raug tsim rau ntawm daim ntawv sib txawv.

Kauj ruam 3

Xaiv hom "Histogram" los ntawm daim ntawv. Hauv seem "Saib", qhia meej nws lub subtype. Qhov hauv qab hauv qab no qhia cov hint-lus qhia los pab koj ua koj xaiv. Nyem rau ntawm Result khawm kom pom seb cov histogram yuav zoo li cas raws koj cov ntaub ntawv. Nyem rau Custom tab yog tias koj xav tsim ib qho kev cai histogram - piv txwv li, nrog kev teeb ntsuas lossis nrog thaj chaw. Nyem "Tom ntej" mus txuas lub tsev.

Kauj ruam 4

Hauv lub qhov rais tom ntej, koj yuav tsum qhia cov ntaub ntawv thaj tsam rau cov phiaj xwm cov histogram. Tag nrho cov lus yog siv los ntawm kev ua tsis tau. Xaiv cov kab mob ntawd, cov ncauj lus uas yuav tsum tau muab tso rau hauv cov histogram. Hauv kab ntawv "Khwv" ntawm lub thawv ntawv sib tham, nkag mus rau qhov xav tau. Kev siv "Rows hauv" hloov, txhais qhov twg yuav tsum qhia rau ntawm abscissa - kem lossis kab. Nyem Next mus txuas ntxiv.

Kauj ruam 5

Hauv kab "Xaiv ntawm Cov Ntawv Xaiv" nyob rau ntawm "Daim Ntawv Qhia" tab, sau lub npe ntawm koj cov histogram thiab axes, yog tias koj pom zoo. Tsiv mus rau ntawm cov tab, koj tuaj yeem ua tus duab kos raws li kev ua haujlwm nws yuav tsum ua piv txwv. Cov saib ua ntej ntawm lub qhov rai qhia tag nrho cov kev hloov uas koj ua. Nyem Next mus txuas ntxiv.

Kauj Ruam 6

Nyob rau theem kawg, qhia rau Excel tus neeg sau ntawv uas koj npaj siab yuav muab cov histogram - kos rau hauv kab ntawv lossis tso nws rau lwm daim ntawv. Teem lub xov tooj cua khawm mus rau qhov xav tau thiab nyem "Ua kom tiav" kom tiav kev ua haujlwm.

Pom zoo: