Box plots yog ib txoj hauv kev zoo los qhia cov ntaub ntawv faib hauv Microsoft Excel. Txawm li cas los xij, Excel tsis muaj lub thawv ntawv kos duab qauv. Qhov ntawd tsis txhais hais tias nws tsis yooj yim sua los yog nyuaj los tsim ib qho. Nyeem ntawv kom kawm paub yuav ua li cas ua ib lub thawv hauv Excel siv cov kab ntawv sib dhos thiab ob peb kauj ruam ntxiv.
Cov lus qhia no siv rau Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel rau Microsoft 365, thiab Excel Online.
Tsim cov ntaub ntawv rau lub thawv ntawv
Excel qhia txog kev faib cov lej thaum koj tsim daim phiaj xwm. Thawj qhov uas yuav tsum tau ua yog teeb tsa cov ntaub ntawv koj xav kom tso rau hauv koj lub npov daim phiaj. Qhov piv txwv no yuav siv ob kab ntawm cov ntaub ntawv, tab sis koj tuaj yeem siv ntau dua yog tias tsim nyog.
-
Sau ib nqe lus rau txhua kab. Txhawm rau siv cov ntaub ntawv piv txwv, sau 2017 hauv D3 thiab 2018 hauv E3.
Txawm tias cov kab tau sau rau hauv qhov piv txwv, cov ntawv no tsis siv rau hauv kev tsim daim ntawv, yog li nkag mus rau lawv yog tias koj xaiv lossis hla cov kauj ruam no.
Image -
Sau cov ntaub ntawv hauv cov hlwb hauv txhua kab.
Image - Txuag daim ntawv ua haujlwm nrog cov ntaub ntawv koj tsim.
Enter Plot Chart Formulas
Xaiv cov nuj nqis quartile yuav tsum tau txhawm rau txhawm rau ua daim ntawv qhia lub thawv. Ua lwm lub rooj uas muaj cov qauv los xam qhov tsawg kawg nkaus, qhov siab tshaj plaws, thiab qhov nruab nrab, los ntawm lub rooj nrog rau thawj thiab thib peb quartiles.
-
Xaiv qhov koj xav nkag mus rau cov qauv los xam cov nqi quartile. Rau qhov piv txwv lub npov daim ntawv qhia, cov qauv yuav nkag mus rau hauv hlwb H4 txog H8. Cov kab hauv cov lus no yuav muaj cov ntaub ntawv hauv qab no:
- Tus nqi qis kawg
- thawj quartile
- Median value
- thib peb quartile
- Tus nqi siab tshaj
-
Enter the formula =MIN(cell range) rau hauv thawj lub xovtooj. Ua raws li qhov piv txwv, sau =MIN(D4:D15) rau hauv xovtooj H4.
Image -
Enter the formula =QUARTILE. INC(cell range, 1) rau hauv lub cell tom ntej. Ua raws li qhov piv txwv, sau =QUARTILE. INC(D4:D15, 1) rau hauv xovtooj H5.
Image -
Enter the formula =QUARTILE. INC(cell range, 2) rau hauv lub cell tom ntej. Ua raws li qhov piv txwv, sau =QUARTILE. INC(D4:D15, 2) rau hauv xovtooj H6.
Image -
Enter the formula =QUARTILE. INC(cell range, 3) rau hauv lub cell tom ntej. Ua raws li qhov piv txwv, sau =QUARTILE. INC(D4:D15, 3) rau hauv xovtooj H7.
Image -
Enter the formula =MAX(cell range) rau hauv cell tom ntej. Ua raws li qhov piv txwv, sau =MAX(D4:D15) rau hauv xovtooj H8.
Image - Luam cov qauv rau hauv kab tom ntej. Yog tias koj lub rooj ntaub ntawv muaj ntau tshaj ob kab, luam cov qauv rau hauv ntau kab raws li koj lub rooj muaj. Cov qauv yuav cia li cuam tshuam nrog cov kab hauv lub rooj.
Xaiv Quartile Differences
Qhov sib txawv ntawm txhua theem yuav tsum raug xam ua ntej tsim daim ntawv. Tsim ib lub rooj thib peb los xam qhov sib txawv ntawm cov hauv qab no.
- thawj quartile thiab tus nqi qis kawg
- Median thiab thawj quartile
- thib peb quartile thiab nruab nrab
- Tus nqi siab tshaj plaws thiab qhov thib peb quartile
- Xaiv qhov koj xav nkag mus rau cov qauv los xam cov nqi quartile. Rau qhov piv txwv lub npov daim ntawv qhia, cov qauv yuav pib hauv cell L4.
-
Nyob rau hauv thawj lub xovtooj, sau tus nqi yam tsawg kawg nkaus rau thawj kab. Txhawm rau ua raws li qhov piv txwv, sau =H4 hauv cell L4.
Image -
Nyob rau hauv lub xovtooj tom ntej, nrhiav qhov sib txawv ntawm thawj quartile thiab tus nqi tsawg kawg nkaus. Ua raws li qhov piv txwv, nkag mus =IMSUB(H5, H4) hauv xovtooj L5.
Image - Luam cov qauv mus rau lwm lub hlwb hauv kab. Cov qauv yuav cia li cuam tshuam nrog cov hlwb xav tau.
-
Luam cov qauv ntawm cov hlwb hauv thawj kab mus rau kab rau sab xis los xam cov nqi quartile rau cov ntaub ntawv nyob rau hauv kab thib ob ntawm cov qauv lus.
Image - Txuag cov kev hloov pauv rau koj daim ntawv ua haujlwm.
Create a Stacked Kem Chart
Siv cov ntaub ntawv nyob rau hauv lub rooj thib peb, tsim ib kab ke kab ke, uas tuaj yeem hloov kho los ua ib lub thawv ntawv.
-
Xaiv tag nrho cov ntaub ntawv los ntawm lub rooj thib peb. Xaiv lub Insert tab, taw tes rau Insert kab kab ntawv thiab xaiv Stacked Column.
Vim Excel siv cov ntaub ntawv kab rov tav los tsim cov kab sib dhos, daim ntawv yuav tsis zoo li lub thawv ntawv pib.
Image -
Right-click the chart and select Select Data. Lub Xaiv cov ntaub ntawv dialog box yuav qhib.
Image -
Xaiv tus Hloov Kab / Kab khawm nyob hauv nruab nrab ntawm qhov kev sib tham. Xaiv OK. Daim ntawv qhia yuav hloov mus rau lub thawv txheem txheej txheem.
Image
Koj tuaj yeem tsim daim ntawv raws li qhov xav tau los ntawm kev hloov daim ntawv teev npe, zais cov ntaub ntawv hauv qab, xaiv cov kab ntawv sib txawv lossis xim, thiab ntau dua.
Xwb, koj tuaj yeem hloov kho ntxiv thiab hloov daim ntawv mus rau hauv lub thawv thiab daim ntawv qhia whisker.
