Pareto Kev Txheeb Xyuas yog txheej txheem yooj yim rau kev saib xyuas qhov muaj peev xwm ua tau los ntawm kev txheeb xyuas cov teeb meem. Kab lus muab cov lus qhia yuav ua li cas los tsim Pareto daim ntawv siv MS Excel 2010.
Cov kauj ruam
Kauj Ruam 1. Txheeb Xyuas thiab Teev Npe Teeb Meem
Ua ib daim ntawv teev tag nrho cov ntaub ntawv ntsiab lus/cov khoom ua haujlwm uas koj xav tau ua ntej ua ntej siv txoj cai Pareto. Qhov no yuav tsum saib qee yam zoo li no.
Yog tias koj tsis muaj cov ntaub ntawv los xyaum, tom qab ntawd siv cov ntaub ntawv qhia hauv daim duab thiab pom tias koj tuaj yeem ua tib daim ntawv Pareto, uas tau qhia ntawm no
Kauj Ruam 2. Npaj pawg sib txawv hauv Kev Txiav Txim Dua, hauv peb qhov xwm txheej "Cov plaub hau poob vim li cas" raws li "Zaus"
Kauj Ruam 3. Ntxiv kab ntawv rau Zaus Zis
Siv cov qauv zoo ib yam li qhia hauv daim duab.
Tam sim no koj lub rooj yuav tsum zoo li no
Kauj Ruam 4. Xam tag nrho cov zauv uas qhia hauv Zaus thiab ntxiv ib kem rau Feem pua
- Ua kom ntseeg tau tias tag nrho yuav tsum zoo ib yam li tus nqi kawg hauv kab ntawv Zaus Zis.
- Tam sim no koj cov ntaub ntawv cov ntaub ntawv tiav thiab npaj txhij los tsim Pareto daim ntawv. Koj cov ntaub ntawv yuav tsum zoo li qhov no.
Kauj Ruam 5. Mus rau InsertColumn thiab xaiv 2-D Column chart
Kauj Ruam 6. Ib cheeb tsam Daim Npav ว่าง yuav tsum tam sim no tshwm ntawm daim ntawv Excel
Txoj Cai Nyem rau hauv thaj tsam Chart thiab Xaiv Cov Ntaub Ntawv.
Kauj Ruam 7. Xaiv Kab B1 txog C9
Tom qab ntawd muab tus cim (,) thiab xaiv kab E1 rau E9.
Nov yog ib qib tseem ceeb, yuav tsum tau saib xyuas ntxiv kom ntseeg tau tias cov ntaub ntawv ntau yam raug xaiv rau Pareto
Kauj Ruam 8. Tam sim no, koj daim Pareto Chart yuav tsum zoo li qhov no
Zaus tau qhia ua Blue tuav thiab Feem pua tau qhia ua Liab tuav.
Kauj Ruam 9. Xaiv ib qho ntawm Cov Feem Pua Feem thiab tuav txoj cai
Nyem rau ntawm "Hloov Series Chart Type" mus rau "Line with Markers".
Hauv qab no yuav tsum tshwm
Kauj Ruam 10. Tam sim no koj daim ntawv yuav tsum zoo li no
Cov kab ntawv feem pua tam sim no tau hloov pauv mus rau kab-kab ntawv
Kauj Ruam 11. Xaiv thiab nyem rau ntawm kab kab liab rau Cov Feem pua thiab Nyem rau ntawm Format data series
Tam sim no, Hom Cov Ntaub Ntawv Series pop-up yuav qhib, qhov uas koj xav tau xaiv "Secondary Axis"
Kauj Ruam 12. Qhov thib ob "Y" axis yuav tshwm sim
Qhov teeb meem nkaus xwb nrog Daim Pareto Chart no yog qhov tseeb tias Y-axis thib ob yog qhia 120%. Qhov no yuav tsum tau kho. Koj yuav lossis tsis tuaj yeem ntsib qhov teeb meem no
Kauj Ruam 13. Xaiv Secondary Y-axis
Txoj cai nyem thiab nyem rau ntawm "Format Axis" xaiv raws li koj tau nyem rau.
Mus rau Axis Options hauv "Format Data Series" dialog box thiab Hloov tus nqi rau "Maximum" rau 1.0
Kauj Ruam 14. Koj Pareto tiav thiab yuav tsum zoo li qhov no
-
Txawm li cas los xij, koj tseem tuaj yeem mus tom ntej thiab ntxiv qee qhov kov kawg rau koj li Pareto kom ua rau nws txaus nyiam dua.
Mus rau Chart Tools Layout. Koj tuaj yeem ntxiv Daim Ntawv Teev Npe, Axis Title, Dab Neeg thiab Cov Ntaub Ntawv, yog tias koj xav tau.