Yuav ua li cas Tsim Histogram hauv Excel rau Windows lossis Mac

2024 Tus sau: Abigail Brown | [email protected]. Kawg hloov kho: 2024-01-07 19:03

Yuav Paub

• 2016: Sau cov ntaub ntawv > hauv Insert tab, xaiv Daim Ntawv Pom Zoo. Hauv All Charts tab, xaiv Histogram > hom.
• 2013, 2010, 2007: File > Options > Add-ins > Excel Add-ins > Go > Tswv txiaj ntsigPak > OK.
• Mac: Tools > Excel Add-ins > Analysis ToolPak. Tawm thiab rov pib Excel. Hauv Data tab, tsim histogram.

Kab lus no piav qhia yuav ua li cas los tsim cov histogram hauv Excel. Histograms tau txais kev txhawb nqa los ntawm Excel 2019, 2016, 2013, 2010, 2007 thiab Excel rau Mac, tab sis cov kauj ruam koj ua nyob ntawm seb Excel version twg koj siv.

Yuav ua li cas thiaj ua Histogram hauv Excel 2016

Excel 2016 muaj tus tsim histogram uas yooj yim tshwj xeeb rau kev siv, vim nws yog ib qho ntawm cov kab kos uas muaj.

Cov cuab yeej tsom xamPak ntxiv-hauv yuav tsum siv cov cuab yeej histogram. Qhov no add-in tsis txaus siab hauv Excel Online (Microsoft 365). Txawm li cas los xij, koj tuaj yeem saib histogram tsim hauv desktop version ntawm Excel siv Excel Online.

1. Pib, nkag mus rau cov ntaub ntawv koj xav siv hauv koj li histogram rau hauv daim ntawv ua haujlwm. Piv txwv li, sau cov npe ntawm cov tub ntxhais kawm hauv chav kawm hauv ib kab thiab lawv cov qhab nia xeem hauv lwm qhov.
2. Xaiv tag nrho cov ntaub ntawv.
3. mus rau Insert tab thiab xaiv Daim Ntawv Pom Zoo hauv pawg kab kos.

4. Mus rau Txhua Daim Ntawv tab thiab xaiv Histogram.

   

5. Xaiv qhov Histogram kev xaiv, ces xaiv OK.

6. Right-click the vertical axis (cov lej hauv qab daim duab) thiab xaiv Format Axis txhawm rau qhib Format Axis pane thiab kho cov histogram.
7. Xaiv Qeb yog tias koj xav tso saib pawg ntawv.
8. Xaiv Bin Dav txhawm rau kho qhov loj ntawm txhua qhov. Piv txwv li, yog tias qib qis tshaj hauv koj cov ntaub ntawv yog 50 thiab koj nkag mus rau 10 hauv Bin Width box, cov bins yuav tso tawm li 50-60, 60-70, 70-80, thiab lwm yam.
9. Xaiv Number of Bins txhawm rau tsim kom muaj tus lej tshwj xeeb ntawm cov thawv tso tawm.
10. Xaiv Overflow Bin los yog Underflow Bin rau pawg saum toj lossis hauv qab tus lej tshwj xeeb.
11. Kaw lub Format Axis pane thaum koj ua tiav customizing histogram.

Yuav ua li cas Tsim Histogram hauv Excel 2013, 2010, lossis 2007

Excel 2013 lossis ntxov dua yuav tsum muaj Kev Tshawb Fawb ToolPak ntxiv rau siv cov cuab yeej histogram. Xyuas kom tseeb tias nws tau teeb tsa ua ntej koj tsim cov histogram hauv Excel.

1. Mus rau File tab, tom qab ntawd xaiv Options.
2. Xaiv Add-ins hauv lub pane navigation.
3. Choose Excel Add-ins hauv Manage poob qis, ces xaiv Go.

4. Select Analysis ToolPak, ces xaiv OK.

   

5. Cov cuab yeej tsom xamPak yuav tsum tau nruab.

Thaum koj tau ntxiv qhov Kev Tshawb Fawb ToolPak, koj tuaj yeem nkag mus rau hauv Analysis pawg hauv qab Data tab.

1. Sau cov ntaub ntawv koj xav siv hauv koj li histogram rau hauv daim ntawv ua haujlwm. Piv txwv li, sau cov npe ntawm cov tub ntxhais kawm hauv chav kawm hauv ib kab thiab lawv cov qhab nia xeem hauv lwm qhov.

2. Nkag mus rau hauv tus lej uas koj xav siv rau hauv kab thib peb. Piv txwv li, yog tias koj xav tso cov qhab nia xeem los ntawm qib ntawv, koj tuaj yeem nkag mus rau 40, 50, 60, 70, 80, 90, thiab 100 rau hauv cov hlwb ntawm kab thib peb.

3. mus rau Data tab. Hauv pawg Analysis, xaiv Data Analysis.
4. Xaiv Histogram hauv cov ntaub ntawv txheeb xyuas lub thawv, tom qab ntawd xaiv OK. Histogram dialog box yuav qhib.
5. Xaiv qhov Input Range (uas yuav yog cov qhab nia xeem hauv qhov piv txwv no) thiab Bin Range (uas yog cov hlwb uas muaj cov lej hauv cov lej).
6. Xaiv qhov Tso Tawm Ntau yog tias koj xav kom cov histogram tshwm rau tib daim ntawv ua haujlwm. Txwv tsis pub, xaiv Daim Ntawv Qhia Tshiablossis Phau Ntawv Tshiab.
7. Xaiv tus Daim Ntawv Qhia Tawm checkbox, ces xaiv OK. Excel yuav ntxig cov histogram zoo li qub rau ntawm daim ntawv koj xaiv.

Create a Histogram hauv Excel 2016 rau Mac

Koj tuaj yeem yooj yim tsim cov histogram hauv Excel 2016 rau Mac tom qab txhim kho Cov Kev Ntsuas Ntsuas.

Cov add-in tsis muaj nyob hauv Excel 2011 rau Mac.

1. Mus rau Tools ntawv qhia thiab nyem Excel Add-ins.
2. Choose Analysis ToolPak nyob rau hauv Add-ins Available thiab nias OK.
3. Click Yes txhawm rau nruab qhov ntxiv yog tias tau hais kom ua.
4. Tawm Excel thiab rov pib qhov program. Qhov Data Analysis kev xaiv yuav tshwm sim ntawm Data tab.

Thaum koj tau teeb tsa qhov txuas ntxiv, koj tuaj yeem tsim cov histogram:

1. Sau cov ntaub ntawv koj xav siv hauv koj li histogram rau hauv daim ntawv ua haujlwm. Piv txwv li: sau cov npe ntawm cov tub ntxhais kawm hauv chav kawm hauv ib kab thiab lawv cov qhab nia xeem hauv lwm qhov.
2. Nkag mus rau hauv tus lej uas koj xav siv rau hauv kab thib peb. Piv txwv li, yog tias koj xav tso cov qhab nia xeem los ntawm qib ntawv, koj tuaj yeem nkag mus rau 40, 50, 60, 70, 80, 90, thiab 100 rau hauv cov hlwb ntawm kab thib peb.
3. Mus rau Data tab thiab nyem Data Analysis.
4. Select Histogram thiab nias OK.
5. Xaiv qhov Input Range (uas yuav yog cov qhab nia xeem hauv qhov piv txwv no) thiab Bin Range (uas yog cov hlwb uas muaj cov nab npawb ntawm bin).
6. Xaiv qhov Cov Khoom Muag yog tias koj xav kom cov histogram tshwm rau tib daim ntawv ua haujlwm. Txwv tsis pub, xaiv Daim Ntawv Qhia Tshiablossis Phau Ntawv Tshiab.

7. Click the Chart Output check box, ces nias OK. Excel yuav ntxig cov histogram zoo li qub rau ntawm daim ntawv koj xaiv.

   

8. Koj ua tiav!

Histogram yog dab tsi?

Histograms zoo ib yam li lwm cov kab kos duab, tab sis lawv pab pawg cov lej rau hauv ntau yam raws li koj qhov kev txiav txim siab. Piv rau lwm hom duab, histograms ua kom yooj yim dua los txheeb xyuas cov ntaub ntawv sib txawv nrog rau pawg thiab zaus ntawm qhov tshwm sim.