Yuav ua li cas thiaj ua daim duab hauv exile

Microsoft Excel cia tsis yog tsuas yog ua haujlwm nrog cov ntaub ntawv lej, tab sis tseem muab cov cuab yeej siv rau cov qauv tsim tsev raws li cov tsis nkag. Lawv cov zaub pom kev tuaj yeem sib txawv kiag li thiab nyob ntawm cov kev daws teeb meem. Qhia kom paub yuav ua li cas kos duab sib txawv hom kev kos duab uas siv cov program no.

Daim duab daim qauv hauv Excel

Vim tias dhau los ntawm kev tshaj tawm koj tuaj yeem hloov cov ntaub ntawv suav nrog thiab lwm cov ntaub ntawv, cov cuab yeej siv rau kev tsim cov duab kos ntawm no tseem ua haujlwm hauv cov lus qhia sib txawv. Hauv cov editor no, muaj ob hom kev sib xws raws cov qauv ntaub ntawv thiab lub peev xwm los tsim ib qho qauv rau kev ua qauv qhia txog kev sib piv ntawm kev cai lij choj. Tom ntej no, peb yuav tham txog cov qauv sib txawv ntawm kev tsim cov khoom no.

Kev xaiv 1: Tsim Daim Ntawv Qhia Txog Lub Rooj

Kev tsim kho ntawm ntau hom kev kos duab yog xyaum tsis sib txawv, tsuas yog nyob rau theem uas koj xav tau xaiv hom kev pom tseeb.

1. Ua ntej koj pib tsim ib daim duab kos, nws yog qhov tsim nyog los tsim lub rooj nrog cov ntaub ntawv raws li qhov uas nws yuav tau ua. Tom qab ntawd mus rau "ntxig" tab thiab faib cheeb tsam ntawm lub rooj, uas yuav qhia nyob rau hauv daim duab.



2. Ntawm daim kab xev ntawm cov ntxig rau deptope, peb xaiv ib ntawm rau hom tseem ceeb:
   • Bar graph;
   • Teem sijhawm;
   • Ncig ncig.
   • Linear;
   • Nrog thaj chaw;
   • Taw tes.



3. Ib qho ntxiv, los ntawm txhaj rau "lwm" khawm, koj tuaj yeem nres ntawm ib qho ntawm cov khoom tsis muaj tsawg: Tshuag, ntiv nplhaib, nplaim paj.



4. Tom qab ntawd, nyem rau ntawm txhua yam ntawm cov kab kos, muaj peev xwm xaiv cov subspec tshwj xeeb. Piv txwv li, rau cov txheej txheem histogram lossis daim duab ua ke yuav yog cov ntsiab lus hauv qab no: cov li ib txwm histogram, loj cylindrical, conical, pyramidal.



5. Tom qab xaiv cov subspec tshwj xeeb, daim duab kos tau tsim. Piv txwv li, cov ntawv li ib txwm yuav zoo li qhia hauv cov screenshot hauv qab no:



6. Daim duab qhia hauv daim ntawv ntawm daim duab yuav yog raws li hauv qab no:



7. Kev xaiv nrog thaj chaw yuav siv hom no:

Ua haujlwm nrog daim duab

Tom qab cov khoom tau tsim, cov twj paj nruag ntxiv rau kev hloov kho thiab hloov pauv ua hauv lub tshiab tab "ua haujlwm nrog cov duab kos".

1. Muaj yam hloov pauv, style thiab ntau lwm yam tsis muaj.



2. Qhov "ua haujlwm nrog cov duab kos" tab muaj peb qho kev tsim qauv ntxiv: "Tus tsim qauv", "Tsim" thiab "uas, koj tuaj yeem kho nws cov phiaj xwm raws li nws yuav tsim nyog. Piv txwv li, kom npe daim duab kos, qhib lub tab "txheej" thiab xaiv ib lub npe ntawm lub npe: hauv nruab nrab lossis los ntawm saud.



3. Tom qab nws tau ua tiav, cov ntawv sau "duab kos npe" tshwm. Peb hloov nws ntawm cov tshuaj uas haum rau hauv cov ntsiab lus ntawm cov lus no.



4. Lub npe ntawm daim duab voos tau kos npe los ntawm raws nraim li qub, tab sis rau qhov no koj yuav tsum nias lub "Axis npe" khawm.

Qhov Xaiv 2: Muab daim duab hauv feem pua

Txhawm rau tso cov feem pua ​​piv ntawm ntau qhov ntsuas, nws yog qhov zoo tshaj plaws los tsim ib lub voj voog ncig.

1. Ib yam li ntawd, peb tau hais li cas, peb tsim lub rooj, thiab tom qab ntawd xaiv cov ntaub ntawv ntau. Tom ntej no, mus rau "ntxig" tab, hais kom meej ib daim duab ncig ntawm daim kab xev thiab hauv cov ntawv nyem uas tshwm rau txhua yam.



2. Txoj haujlwm ntawm nws tus kheej mus rau ib qho ntawm cov tabs los ua haujlwm nrog cov khoom no - "tus tsim qauv". Xaiv ntawm cov legouts nyob rau hauv ribbon ntawm ib qho, nyob rau hauv uas muaj ib lub cim feem pua.



3. Daim duab ncig nrog cov ntaub ntawv qhia hauv feem pua ​​yog npaj txhij.

Qhov Xaiv 3: Tsim Daim Ntawv Qhia Txog Kev Ua Liab

Raws li Wilfredo Pareto lub tswv yim, 20% ntawm cov kev nqis tes ua tau zoo tshaj plaws coj 80% ntawm cov txiaj ntsig dav. Raws li, seem seem 80% ntawm tag nrho cov kev ua txhaum cai uas tsis muaj txiaj ntsig, tsuas yog 20% ​​ntawm cov txiaj ntsig tau coj. Daim duab daim qauv pareto tsuas yog tsim los suav cov kev ua tau zoo tshaj plaws uas muab qhov nyiaj siab tshaj. Ua nws siv Microsoft Excel.

1. Nws yog qhov yooj yim tshaj plaws los tsim cov khoom no hauv daim ntawv ntawm cov histogram, uas peb twb tau hais los saum no.
2. Cia peb muab ib qho piv txwv: Lub rooj muaj cov npe khoom noj. Hauv ib sab, tus nqi ua tiav ntawm tag nrho cov khoom ntim ntawm cov khoom lag luam tshwj xeeb ntawm cov khoom lag luam warecribed, thiab hauv ob - nyiaj tau los ntawm nws txoj kev siv. Peb yuav tsum txiav txim siab seb cov khoom twg muab qhov loj tshaj plaws "rov qab" thaum muag.

   Ua ntej tshaj plaws, peb tsim cov histogram raug: Peb faib tag nrho thaj chaw ntawm lub rooj qhov tseem ceeb, nyem "Histogram" khawm thiab xaiv hom xav tau.



3. Raws li koj tuaj yeem pom, ib hom ntawm ob hom tau tsim tsa raws li qhov tshwm sim: xiav thiab liab. Tam sim no peb yuav tsum hloov cov kab ntawv liab rau lub sijhawm - Xaiv cov kab ntawv no nrog tus qauv ntawm "Hloov Hom ntawm daim duab" khawm.



4. Lub qhov rai hloov pauv qhib. Mus rau "Sijhawm" thiab sau cov hom haum rau peb lub hom phiaj.



5. Yog li, cov duab kos duab Pareto tau ua. Tam sim no koj tuaj yeem hloov kho nws cov ntsiab lus (lub npe ntawm cov khoom thiab cov xim, thiab lwm yam) tsuas yog tau piav qhia txog cov piv txwv ntawm cov kab lus ntawm kem.

Raws li koj tuaj yeem pom, Excel nthuav tawm ntau lub zog rau kev tsim kho ntau hom kev ua yeeb yaj kiab - tus neeg siv tseem yuav tsum tau txiav txim siab rau hom twg thiab hom ntawv yog qhov tsim nyog rau kev pom zoo.