txheem
Cov neeg ua haujlwm hauv kev muag khoom, kev lag luam, lossis lwm yam kev lag luam uas siv lossis tau txais cov ntawv ceeb toom los ntawm kev lag luam software yog tej zaum paub txog kev muag khoom funnel. Sim tsim koj tus kheej daim ntawv qhia funnel thiab koj yuav pom tias nws yuav siv qee yam txuj ci. Excel muab cov cuab yeej los tsim cov pyramid inverted, tab sis nws yuav siv qee qhov kev siv zog.
Cov hauv qab no qhia yuav ua li cas los tsim ib daim ntawv qhia funnel hauv Excel 2007-2010 thiab Excel 2013.
Yuav Ua Li Cas Tsim Funnel Chart hauv Excel 2007-2010
Cov duab hauv ntu no tau coj los ntawm Excel 2010 rau Windows.
- Qhia meej cov ntaub ntawv koj xav kom suav nrog hauv daim duab. Piv txwv li, cia peb coj tus naj npawb ntawm cov neeg siv khoom txuas nrog lub raj xa dej (kem Tus naj npawb ntawm cov nyiaj hauv cov kav dej hauv cov lus hauv qab no).
- Hauv Advanced tab Insert (Ntxig) nyem lub pob bar daim qauv qhia (Kem) xaiv Normalized stacked pyramid (100% stacked pyramid).
- Xaiv cov ntaub ntawv series los ntawm txhaj rau txhua qhov chaw cov ntaub ntawv.
- Hauv Advanced tab constructor (Tsim) hauv ib pab pawg Cov ntaub ntawv (Cov ntaub ntawv) nyem lub pob Kab kab (Hloov kab / kab).
- Txoj nyem rau ntawm lub pyramid thiab xaiv XNUMXD Kev sib hloov (3-D Rotation) hauv cov ntawv qhia zaub mov uas tshwm.
- Hloov lub kaum sab xis ntawm kev sib hloov raws cov axes X и Y ntawm 0 °.
- Txoj cai-nias rau ntawm txoj kab ntsug thiab los ntawm cov ntawv qhia zaub mov uas zoo li xaiv Axis Format (Format Axis).
- Zuam Rov qab txiav txim ntawm qhov muaj nuj nqis (Tus nqi nyob rau hauv qhov kev txiav txim rov qab) - daim ntawv funnel yog npaj txhij!
★ Nyeem ntxiv hauv tsab xov xwm: → Yuav ua li cas los tsim ib daim ntawv qhia kev muag khoom hauv Excel
Yuav Ua Li Cas Tsim Funnel Chart hauv Excel 2013
Cov duab hauv ntu no tau muab los ntawm Excel 2013 rau Windows7.
- Qhia meej cov ntaub ntawv koj xav kom suav nrog hauv daim duab.
- Hauv Advanced tab Insert (Ntxig) xaiv Volumetric stacked histogram (3-D Stacked Kem chart).
- Txoj cai-nias ntawm txhua kab thiab los ntawm cov ntawv qhia zaub mov uas zoo li xaiv Cov ntaub ntawv series (Format Data Series). Lub vaj huam sib luag ntawm tib lub npe yuav qhib.
- Los ntawm cov kev xaiv daim ntawv thov, xaiv ua kom tiav pyramid (Pyramid puv).
- Xaiv cov ntaub ntawv series los ntawm txhaj rau txhua qhov chaw cov ntaub ntawv.
- Hauv Advanced tab constructor (Tsim) hauv ntu Cov ntaub ntawv (Cov ntaub ntawv) nyem lub pob Kab kab (Hloov kab / kab).
- Txoj cai-nias ntawm lub pyramid thiab los ntawm cov ntawv qhia zaub mov uas zoo li xaiv XNUMXD Kev sib hloov (3-D tig).
- Nyob rau hauv lub vaj huam sib luag uas tshwm Daim duab Area Format (Format Chart Area) ntu XNUMXD Kev sib hloov (3-D Rotation) hloov lub kaum sab xis ntawm kev sib hloov raws cov axes X и Y ntawm 0 °.
- Txoj cai-nias rau ntawm txoj kab ntsug thiab los ntawm cov ntawv qhia zaub mov uas zoo li xaiv Axis Format (Format Axis).
- Zuam Rov qab txiav txim ntawm qhov muaj nuj nqis (Tus nqi nyob rau hauv qhov kev txiav txim rov qab) - daim ntawv funnel yog npaj txhij!
Thaum koj daim ntawv qhia funnel npaj txhij thiab ntsib txoj hauv kev koj xav tau, koj tuaj yeem tshem tawm cov ntaub ntawv sau npe thiab daim ntawv teev npe, thiab kho tus qauv tsim raws li koj nyiam.
Ceev faj! Yog tias koj daim ntawv qhia tsis yog raws li cov ntaub ntawv tshwj xeeb, lossis yog tias koj tsuas yog xav qhia lub tswv yim thiab tsis yog cov lej tshwj xeeb, nws yooj yim dua los siv lub pyramid los ntawm SmartArt duab teeb.