Nyob hauv Microsoft Excel, ib lub thawv ntawv siv cov duab los tso saib pawg ntawm cov ntaub ntawv tus lej los ntawm tsib qhov tseem ceeb, hu ua quartiles. Cov kab kos kab kos tuaj yeem hnav nrog cov hlua khi, uas yog cov kab ntsug txuas ntxiv los ntawm cov thawv ntawv. Cov hneev taw qhia qhov sib txawv sab nraud ntawm sab sauv thiab sab qis.
Box thiab whisker plots feem ntau yog siv los piav qhia txog cov ntaub ntawv los ntawm cov ntaub ntawv muaj feem ntau dua li muaj qhov chaw ywj pheej, xws li cov qhab nia ntawm cov tsev kawm ntawv sib txawv lossis cov ntaub ntawv los ntawm ua ntej thiab tom qab kev hloov pauv hauv cov txheej txheem lossis txheej txheem.
Nyob rau hauv cov ntawv Excel tsis ntev los no, koj tuaj yeem tsim ib lub thawv thiab daim ntawv whisker siv Insert Chart tool. Txawm hais tias cov laus versions ntawm Excel tsis muaj lub thawv thiab tus kws tsim lub tshuab nplawm, koj tuaj yeem tsim ib qho los ntawm kev hloov cov kab ntawv kab ke rau hauv lub thawv ntawv thiab tom qab ntawd ntxiv cov whiskers.
Cov lus qhia no siv rau Excel 2019, Excel 2016, Excel rau Microsoft 365, Excel 2013, thiab Excel 2010.
Siv Excel's Box thiab Whisker Plot Maker
Rau Excel 2019, Excel 2016, lossis Excel rau Microsoft 365, ua ib lub thawv thiab daim ntawv qhia whisker siv Insert Chart tool.
-
Nkag mus rau cov ntaub ntawv koj xav siv los tsim ib lub thawv thiab daim ntawv whisker rau hauv kab thiab kab ntawm daim ntawv ua haujlwm. Qhov no tuaj yeem yog cov ntaub ntawv ib zaug lossis ntau cov ntaub ntawv series.
Image -
Xaiv cov ntaub ntawv koj xav siv los ua daim ntawv qhia.
Image -
Xaiv lub Insert tab.
Image -
Xaiv Daim Ntawv Pom Zoo hauv kab kos pab pawg (los yog xaiv lub dialog box launcher nyob rau sab xis sab xis ntawm pawg kab kos) qhib lub Insert Chart dialog box.
Image -
Xaiv lub Tag nrho kab ntawv tab hauv Insert Chart dialog box.
Image -
Xaiv Box thiab Whisker thiab xaiv OK. Ib lub npov yooj yim thiab daim ntawv qhia daim ntawv whisker tshwm rau ntawm daim ntawv ua haujlwm.
Image
Hloov ib lub thawv phiaj xwm rau hauv lub thawv thiab Whisker Plot
Rau Excel 2013 lossis Excel 2010, pib nrog ib kab ntawv sib dhos thiab hloov nws mus rau hauv ib lub thawv thiab daim ntawv qhia whisker.
Tsim ib daim ntawv qhia lub thawv ntawv hauv Excel thiab tom qab ntawd ntxiv cov whiskers.
Cov nplawm rau ntawm lub thawv thiab lub thawv ntawv lub thawv ntawv qhia txog qhov sib txawv ntawm sab sauv thiab sab qis. Txhua cov ntaub ntawv taw qhia uas ntog sab nraud sab saum toj lossis hauv qab kab nplawm yuav raug suav hais tias yog ib qho outlier thaum txheeb xyuas cov ntaub ntawv.
-
Xaiv lub npov sab saum toj ntawm daim duab thiab tom qab ntawd xaiv Ntxiv Daim Ntawv Qhia ntawm Daim Ntawv Tsimtab.
Image -
Xaiv Error Bars thiab xaiv Ntau qhov yuam kev Bar Options txhawm rau qhib Format yuam kev Bars menu.
Image -
Xaiv Plus hauv qab Direction hauv Kev xaiv yuam kev.
Image -
Xaiv Custom thiab xaiv Specify tus nqi hauv Yam Nqi Nqe txhawm rau qhib Kev cai yuam kev Bars dialog box.
Image
Ntxiv rau hauv qab Whisker
Thaum koj tau ntxiv cov nplawm sab saum toj, ces koj tuaj yeem ntxiv cov nplawm hauv qab kom zoo ib yam.
- Xaiv lub npov hauv qab ntawm daim duab thiab xaiv Ntxiv Daim Ntawv Qhia ntawm Daim Ntawv Tsimtab.
-
Xaiv Error Bars thiab xaiv Ntau qhov yuam kev Bar Options txhawm rau qhib Format yuam kev Bars menu.
Image -
Xaiv Minus hauv qab Kev taw qhia hauv Kev xaiv yuam kev.
Image -
Xaiv Custom thiab xaiv Specify tus nqi hauv Yam Nqi Nqe. Lub Custom yuam kev Bars dialog box yuav qhib.
Image - Delete cov ntsiab lus ntawm Tus nqi yuam kev zoo lub thawv. Xaiv cov txiaj ntsig hauv qab ntawm daim ntawv ua haujlwm thiab xaiv OK txhawm rau kaw Kev Cai yuam kev qhov rais.
Format a Box and Whisker Plot Chart in Excel
Thaum koj tau tsim daim ntawv qhia, siv Excel's chart formatting tools.
-
Xaiv Daim Ntawv Teev Npe thiab sau lub npe koj xav kom tshwm rau daim duab.
Image -
Right-click ib lub thawv ntawm daim duab thiab xaiv Format Data Series los qhib lub Format Data Series pane.
Image -
Txhim lossis txo qhov Gap Davtxhawm rau tswj qhov sib txawv ntawm qhov sib txawv ntawm lub thawv.
Image -
Xaiv Show Inner Points los tso saib cov ntaub ntawv cov ntsiab lus ntawm ob kab nplawm.
Image - Kuj nyob rau hauv hom Cov Ntaub Ntawv Cov kab ke, xaiv Qhia Cov Ntsiab Lus Tshaj Tawm txhawm rau tso tawm cov ntawv tawm hauv qab lossis siab dua cov kab ntxau.
- Xaiv Show Mean Markers los tso saib tus cim cim ntawm cov ntaub ntawv series.
- Xaiv Show Mean Line los tso saib cov kab txuas cov lus ntawm cov thawv hauv cov ntaub ntawv series.
-
Xaiv ib txoj hauv kev rau Quartile suav:
- Inclusive Median suav nrog hauv kev suav yog tias tus lej ntawm qhov tseem ceeb hauv cov ntaub ntawv yog khib.
- Exclusive median yog cais tawm ntawm kev suav yog tias muaj tus lej khib ntawm qhov tseem ceeb hauv cov ntaub ntawv.
Image - Xaiv lub thawv tom ntej hauv koj daim phiaj xwm los kho nws hauv Format Data Series pane thiab rov ua dua rau txhua lub thawv ntxiv.
Kho lossis hloov qhov tshwm sim ntawm lub npov thiab ntxhi lus
Txhawm rau hloov pauv qhov tshwm sim ntawm lub npov thiab daim ntawv qhia lub ntsej muag, xaiv ib cheeb tsam ntawm daim duab thiab tom qab ntawd xaiv Daim Ntawv Tsim lossis Tsim cov cuab yeej ntawm Cov Cuab Yeej tab, nyob ntawm seb koj siv Excel version twg.
Hloov kho yam xws li daim duab layout, style, lossis xim siv tib txoj kev tau piav qhia saum toj no.
