Raws li cov histogram nyob rau hauv Excel

Qhov zoo tshaj plaws tshuaj mus kav cov ntaub ntawv nyob rau hauv rooj yuav undoubtedly histogram. Ntaus ib daim ntawv uas muaj peev xwm ntawm ib txwm neeg siv yuav dhau qhov yooj yim essence ntawm tag nrho cov tseem ceeb, txawm tsis nyeem lawv.

Cov tsab xov xwm yuav tsum rhuav histogram nyob rau hauv Excel. Yuav ua li cas yuav ua rau nws, koj yuav kawm tau nyob rau thaum xaus ntawm kev nyeem ntawv hauv tsab xov xwm. Nyob rau hauv tas li ntawd, nws yuav nyob tag nrho rau hauv lub nuances uas tshwm sim thaum lub sij hawm tsim kho. Tsis tas li ntawd, koj yuav kawm txog plaub hom kev xaiv muaj qhia yuav ua li cas rau tsim ib tug histogram nyob rau hauv Excel.

Kev xaiv rau tus tsim ntawm lub histogram nyob rau hauv lub "Excel"

Cov feem nrov rooj editor muab cov nram qab no kev xaiv rau histogram siv:

• ib tug yooj yim bar graph;
• histogram nrog txuam nrog;
• siv lub tsom pob;
• nrog zwj ceeb formatting hlwb.

Tam sim no nws yuav tsum tau muab sau tseg tias tag nrho cov saum toj no embodiments tej zaum yuav tsim nyob rau hauv ib tug nyias muaj nyias ib yam twj paj nruas lub rooj los yog ib feem ntawm nws. Thiab tam sim no cia tsiv mus rau ib qho kev soj ntsuam ntawm yuav ua li cas lub histogram nyob rau hauv Excel.

Txoj 1: Ib tug yooj yim histogram

Ib tug yooj yim bar graph nyob rau hauv Excel yog feem ntau siv. Nws siv tsis siv sij hawm ntau lub sij hawm, thiab cov txheej txheem tsis tau nyob rau hauv-tob kev paub ntawm cov kev pab cuam.

Chiv, qhov yuav tsum tau tso tseg los nyob rau hauv lub rooj ntaub ntawv uas yuav tsum tau siv nyob rau hauv lub sij hawm nyob rau hauv lub neej yav tom ntej. Ces koj yuav tau mus rau lub tab "Insert" thiab nias rau ntawm lub "kab kos". Qhov no yuav qhib ib tug submenu nrog tag nrho cov muaj nyob rau hom kab kos. Nyob rau hauv cov ntaub ntawv no, thov nyem rau ntawm qhov tab "Histogram" nyob rau hauv lub nco-down ntawv qhia zaub mov, xaiv lub hom. Nws yog ib nqi sau cia hais tias nyob rau hauv txhua kab yooj yim histogram tuaj ua ntej, tom qab lawv twb npaj nrog tsub zuj zuj histogram.

Yog li ntawd sai li sai tau raws li koj tau nyem rau ntawm koj nyiam cov daim ntawv rau ib daim ntawm qhov kev pab cuam zoo li ncaj qha rau daim ntawv uas muaj cov ntaub ntawv li yav tas los nyob rau hauv lub xaiv cheeb tsam.

Ntawm no yog ib tug histogram nyob rau hauv Excel. Yuav ua li cas yuav ua rau ib tug inscription nyob rau hauv nws, koj yuav kawm tau ib tug me ntsis rau yav tom ntej. Txawm hais tias yog hais tias kev kho me ntsis yuav tau ua siv cov cuab yeej uas yog nyob rau hauv cov pab pawg neeg ntawm tabs "Ua hauj lwm nrog kab kos".

Txoj 2: Histogram nrog txuam nrog

Leej twg nws yuav tau los sib tham txoj kev uas yuav qhia li cas rau tsim ib tug loj zus histogram nyob rau hauv Excel. Piv txwv li koj yuav saib tau nyob rau hauv no tsab xov xwm.

Nyob rau hauv qhov tseeb nws creation yog tsis sib txawv los ntawm ib tug yooj yim txoj kev, tab sis muaj ib tug caveat uas yuav tsum ci ntsa iab. Ua ntej ua hauj lwm nrog cov histogram koj yuav tsum tshem tawm lub npe ntawm tus thawj kiag, yog hais tias muaj yog ib tug, txwv tsis pub nws yuav tsis ua hauj lwm.

Tam sim no koj muaj peev xwm tsim. Ib yam li nyob rau hauv lub yav dhau los txoj kev, nws yog tsim nyog los faib ib feem ntawm cov lus nrog rau cov ntaub ntawv uas yuav siv tau rau kev tsim kho. Ces mus rau lub tab "Insert" nyob rau toolbar nco-down ntawv qhia zaub mov "kab kos" taw tes rau taw tes "Histogram" thiab mam li xaiv qhov cia yam. Nws yog ib nqi recalling tias nyob rau hauv txhua kab, nws yog nyob rau ntawm sab xis.

Tom qab txhaj rau ib tug ntawm cov khoom nyob rau daim ntawv yuav tsum muaj ib tug coj cumulative histogram nyob rau hauv Excel.

Zoo li lub sij hawm dhau, lub sij hawm, koj muaj peev xwm ua ib co kev hloov kev siv cov cuab yeej nyob rau hauv lub tab pab pawg neeg "Ua hauj lwm nrog kab kos". Los ntawm txoj kev, nyob rau hauv ob leeg, mus hloov daim ntawv lo nyob rau hauv daim ntawv, koj tsuas yuav tsum nias lub ob-click rau nws thiab xaiv ib lub npe tshiab.

Txoj 3: Siv tsom xam pob

Los ntawm ib tug tsis tseem ceeb txoj kev hloov mus rau qhov tseeb hais tias nyuab. Ob peb cov neeg paub hais tias nrog kev pab los ntawm qhov kev pab cuam ntxiv-ons yuav ua tau ib histogram, tab sis nws yuav ua tau.

Thawj kauj ruam yog yuav nkag mus rau lawv tus kheej nyob rau hauv lub superstructure. Ua li no, nyem rau ntawm qhov tab "Cov ntaub ntawv" thiab xaiv ib tug sidebar yam khoom "tej chaw". Tom ntej no, mus rau hauv cov qeb ntawm "Ntxiv-ons".

Nco ntsoov lub nco-down daim ntawv teev cov "Management". Nyob rau hauv nws koj yuav tau xaiv "Excel ntxiv-ons" thiab nias rau "Mus" khawm. Ntxiv-ons qhov rai yuav tshwm sim. Muab nws nyob rau hauv ib tug zuam tom ntej no mus rau "Analysis ToolPak" thiab nias "OK".

Tam sim no mus rov qab mus rau koj lub rooj, xaiv cov ntaub ntawv cheeb tsam, thiab xaiv cov tab "Cov ntaub ntawv". Nyob rau hauv no tab koj xav tau nyem rau ntawm cov "Cov ntaub ntawv Analysis", uas yog nyob rau hauv lub "Analysis".

Nyob rau hauv lub qhov rais uas zoo nkaus li, xaiv los ntawm daim ntawv teev cov "Histogram" thiab ces nias "OK" - ib lub qhov rais yuav tshwm sim nyob rau hauv uas koj xav kom koj muab tsis. Nyob rau hauv lub "tawm tswv yim ntau yam" yuav tsum tau muab rau cov ntaub ntawv cheeb tsam ntawm lub rooj. Yog hais tias koj yog pre-faib nws, ces tus nqi yuav tsum nkag mus hauv yeej. Tom ntej no, kos lub box tom ntej no mus rau "zaub nraaj" thiab cia li saum toj no tus taw tes qhov twg qhov no yog qhov timetable rau tus ntsoos ntsoos. Raws li kev soj ntsuam, nias qhov "OK" khawm.

Txoj 4: Conditional formatting hlwb

Yuav kom tsim tau ib histogram nyob rau hauv no yav tas, koj yuav tsum xaiv ib cheeb tsam ntawm cov ntaub ntawv thiab cov "Tsev" tab, nyem rau ntawm qhov "Conditional Formatting". Nyob rau hauv lub nco-down daim ntawv teev, tsiv mus nyob rau cursor rau "Histogram" nyob rau hauv cov zaub mov, xaiv ib tug ntawm cov nyiam teeb hom.

Tom qab hais tias, cov formatted cell yog teev daim ntawv qhia - qhov no yog ib tug histogram. Raws li koj tau twv, lub scale qhia tus luj ntawm lub ntau cov ntaub ntawv uas nyob rau hauv nws.

xaus

Cov plaub txoj kev nyob rau hauv uas koj muaj peev xwm tsim ib tug bar graph nyob rau hauv Excel. lawv yog tag nrho cov zoo nyob rau hauv lawv tus kheej txoj kev thiab yog haum rau txawv xav tau kev pab, yog li kos txhua yam thiab xaiv cov kev kawm.