Tsim ib daim duab / Pictogram hauv Excel

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

Yuav Paub

• Xaiv cov hlwb nrog cov ntaub ntawv. Xaiv Insert > Insert Column or Bar Chart in the Chart pab pawg. Xaiv 2-D Clustered Kem rau daim duab bar.
• ob-nias ib daim ntawv qhia. Xaiv Format Data Series > Fill Options > Duab lossis duab sau. Nrhiav cov duab thiab xaiv Insert.
• Xaiv Stack los hloov cov xim bar uas koj xaiv nrog cov duab. Rov ua cov txheej txheem rau cov kab sib txawv.

Kab lus no piav qhia yuav ua li cas siv daim duab rau daim duab qhia hauv Excel, suav nrog kev qhia nkag mus rau cov ntaub ntawv, ua cov duab kos yooj yim, thiab siv cov duab rau daim duab los ua cov duab. Cov kev qhia siv rau Microsoft Excel 2019, 2016, 2013, 2010, Excel 2019 rau Mac, Excel 2016 rau Mac, thiab Excel 2011 rau Mac.

Yuav Ua Li Cas Sau Daim Duab: Cov Ntaub Ntawv Qhia

Hauv Microsoft Excel, daim duab siv cov duab los sawv cev cov ntaub ntawv tus lej hauv daim duab lossis duab. Tsis zoo li cov duab kos duab, ib daim duab (qee zaum hu ua pictogram) suav nrog cov duab los hloov cov kab xim lossis cov kab uas feem ntau pom hauv kev nthuav qhia.

Txhawm rau ua raws li cov lus qhia no, qhib daim ntawv ua haujlwm tshiab hauv Excel thiab nkag mus rau cov ntaub ntawv hauv qab no rau hauv cov hlwb siv.

1. Enter Panut Butter into cell A3.
2. Enter Gingerbread rau hauv cell A4.
3. Enter Sugar into cell A5.
4. Enter 2005 rau hauv cell B2.
5. Enter 15, 500 rau hauv cell B3.
6. Enter 27,589 rau hauv cell B4.
7. Enter 24, 980 rau hauv cell B5.
8. Enter 2006 into cell C2.
9. Enter 16, 896 rau hauv cell C3.
10. Enter 26, 298 rau hauv cell C4.
11. Enter 25, 298 rau hauv cell C5.
12. Enter 2007 rau hauv cell D2.
13. Enter 14, 567 rau hauv cell D3.
14. Enter 24, 567 rau hauv cell D4.
15. Enter 21, 547 rau hauv cell D5.

Create a Bar Graph

Cov kauj ruam tom ntej yog los tsim cov qauv kab kos.

1. Nkag mus xaiv cov hlwb A2 rau D5.
2. Xaiv Insert.
3. Xaiv Insert Column or Bar Chart hauv Chart pab pawg.
4. Select 2-D Clustered Kem.
5. Daim ntawv qhia kab ke yooj yim yog tsim thiab muab tso rau hauv koj daim ntawv ua haujlwm.

Ntxiv ib daim duab rau daim duab

Tom ntej no, ntxiv ib daim duab rau hauv daim duab los ua ib daim duab.

1. Ob zaug-nias ntawm ib qho ntawm cov ntaub ntawv xiav xiav hauv daim duab thiab xaiv Format Data Series los ntawm cov ntawv qhia zaub mov. Lub Format Data Series dialog box qhib.
2. Xaiv Fill Options los yog Sau & Kab icon hauv Format Data Series dialog box.
3. Xaiv Daim duab lossis kev ntxhib los mos hauv Fill.
4. Xaiv File yog tias koj xav siv daim duab khaws tseg hauv koj lub computer.
5. Xaiv Online yog tias koj xav tshawb online rau daim duab siv.

6. Nrhiav thiab xaiv cov duab koj xav siv.

7. Xaiv Insert ntxiv rau daim duab.
8. Xaiv tus Stack khawm.

9. Kaw lub Format Data Series dialog box. Cov kab xiav-xim hauv daim duab tam sim no hloov nrog cov duab xaiv.

   

10. Rov ua dua cov kauj ruam saum toj no txhawm rau hloov lwm cov kab hauv daim duab rau cov duab.