txheem
Yog tias koj feem ntau tsim cov ntawv tshaj tawm nrog cov ntsuas nyiaj txiag (KPI) hauv Excel, ces koj yuav tsum nyiam hom kab txawv no - daim ntawv teev ntsuas lossis daim ntawv ntsuas kub (Bullet Chart):
- Kab rov tav kab liab qhia txog lub hom phiaj tus nqi peb tab tom tsom rau.
- Peb-xim tom qab sau ntawm qhov teev kom meej meej qhia qhov "tsis zoo- nruab nrab-zoo" thaj chaw uas peb tau txais.
- Lub kaum sab xis dub qhia txog tus nqi tam sim no ntawm qhov ntsuas.
Tau kawg, tsis muaj qhov tseem ceeb dhau los ntawm qhov ntsuas nyob rau hauv daim duab kos duab, piv txwv li Peb yuav tsis pom cov kev hloov pauv lossis kev hloov pauv, tab sis rau lub ntsiab lus pom ntawm qhov ua tiav cov txiaj ntsig vs cov hom phiaj tam sim no, nws yog qhov tsim nyog heev.
Video
Theem 1. Stacked histogram
Peb yuav tau pib los ntawm kev tsim cov qauv histogram raws li peb cov ntaub ntawv, uas peb yuav coj mus rau hauv daim ntawv peb xav tau ob peb kauj ruam. Xaiv cov ntaub ntawv qhov chaw, qhib lub tab Insert thiab xaiv stacked histogram:
Tam sim no peb ntxiv:
- Txhawm rau ua kom cov kab ntawv tsis nyob hauv kab, tab sis nyob rau sab saum toj ntawm ib leeg, sib pauv kab thiab kab siv lub pob Kab/Kab (Law/Kab) tab Tus tsim (Design).
- Peb tshem cov lus dab neeg thiab lub npe (yog tias muaj) - peb muaj minimalism ntawm no.
- Kho cov xim sau ntawm txhua kab raws li lawv lub ntsiab lus (xaiv lawv ib qho los ntawm ib qho, nyem rau ntawm qhov xaiv thiab xaiv Cov ntaub ntawv point format).
- Narrowing daim duab nyob rau hauv dav
Cov zis yuav tsum saib tej yam zoo li no:
Theem 2. Qhov thib ob axis
Xaiv ib kab Tus nqi (dub duab plaub), qhib nws cov khoom nrog kev sib xyaw ua ke Ctrl + 1 los yog txoj cai nyem rau ntawm nws - Kab Format (Format Data Point) thiab nyob rau hauv parameter qhov rais hloov kab rau Pab axis (Secondary Axis).
Cov kab dub yuav mus raws tus thib ob axis thiab pib npog tag nrho lwm cov duab plaub xim - tsis txhob ntshai, txhua yam yog raws li txoj kev npaj 😉 Pom qhov ntsuas, nce rau nws. Sab clearance (Gap) mus rau qhov siab tshaj plaws kom tau txais daim duab zoo sib xws:
Nws twb sov lawm, puas yog?
Theem 3. Teem lub hom phiaj
Xaiv ib kab Lub hom phiaj (liab duab plaub), txoj nyem rau ntawm nws, xaiv cov lus txib Hloov hom kab kos rau ib series thiab hloov hom rau Dotted (Sib ntaus sib tua). Cov duab plaub liab yuav tsum tig mus rau hauv ib qho cim (piv txwv li los yog L-shaped), piv txwv li:
Yog tsis tshem qhov kev xaiv los ntawm qhov no, tig rau nws Yuam Kev Yuam Kev tab Layout. los yog ntawm lub tab constructor (hauv Excel 2013). Qhov tseeb versions ntawm Excel muaj ntau txoj kev xaiv rau cov kab no - sim nrog lawv yog tias koj xav tau:
Los ntawm peb lub ntsiab lus, "whiskers" yuav tsum sib txawv nyob rau hauv tag nrho plaub cov lus qhia - lawv feem ntau yog siv los ua kom pom tseeb qhov tseeb kam rau ua los yog tawg (dispersion) ntawm qhov tseem ceeb, piv txwv li, hauv kev txheeb cais, tab sis tam sim no peb siv lawv rau ntau lub hom phiaj. Rho tawm cov kab ntsug (xaiv thiab nias tus yuam sij Rho tawm), thiab kho cov kab rov tav los ntawm txoj cai-nias ntawm lawv thiab xaiv cov lus txib Format yuam kev Bars:
Hauv cov khoom qhov rais ntawm kab rov tav tuav ntawm qhov yuam kev hauv ntu Yuam nqi xaiv tus nqi ruaj khov or Custom (Kev cai) thiab teeb tsa tus nqi zoo thiab qhov tsis zoo ntawm qhov yuam kev los ntawm cov keyboard sib npaug rau 0,2 - 0,5 (xaiv los ntawm qhov muag). Ntawm no koj tuaj yeem ua kom lub thickness ntawm lub bar thiab hloov nws cov xim rau liab. Tus cim tuaj yeem raug kaw. Yog li ntawd, nws yuav tsum tig tawm zoo li no:
Theem 4. Kev kov tiav
Tam sim no yuav muaj khawv koob. Saib koj ob txhais tes: xaiv txoj cai ntxiv axis thiab nias Rho tawm ntawm keyboard. Tag nrho peb cov kab ke tsim, lub hom phiaj yuam kev bar thiab cov duab plaub dub loj ntawm tus nqi tam sim no raug txo qis rau ib qho kev sib koom tes thiab pib ua raws li ib qho axis:
Qhov ntawd yog nws, daim duab yog npaj txhij. Zoo nkauj, puas yog? 🙂
Feem ntau koj yuav muaj ob peb yam uas koj xav tso saib siv cov kab kos. Txhawm rau kom tsis txhob rov ua dua tag nrho cov dab neeg nrog kev tsim kho, koj tuaj yeem luam daim ntawv qhia, thiab tom qab ntawd (xaiv nws) rub lub duab plaub xiav ntawm thaj chaw cov ntaub ntawv mus rau qhov tseem ceeb tshiab:
- Yuav ua li cas los tsim ib daim ntawv Pareto hauv Excel
- Yuav ua li cas los tsim ib daim ntawv qhia dej tsaws tsag ntawm kev sib txawv ("waterfall" lossis "bridge") hauv Excel
- Dab tsi tshiab hauv kab kos hauv Excel 2013