Tsim lub teeb duab nyob hauv Excel

Ib lub pictograph siv cov duab los sawv cev cov ntaub ntawv zauv nyob hauv daim duab lossis daim duab. Tsis zoo li cov qauv kos duab, ib lub duab kos kos duab nrog cov duab los hloov cov kab xim los yog cov kab tuav cov kab ntau tshaj plaws, pom koj cov neeg nyiam mloog los ntawm kev siv xim thiab cov duab.

Ua rau koj qhov kev nthuav qhia tom qab nthuav ntau thiab yooj yim rau kev nkag siab los ntawm kev teeb tsa ib lub pictograph hauv Excel.

ntawm http://www.inbox.com/article/how-do-create-pictograph-in-excel-2010.html

Hauv duab kos duab, cov duab yuav hloov cov kab xim los yog cov pas tuav hauv daim duab los yog daim duab sab nraud. Cov ntawv nyeem no qhia txog yuav ua li cas hloov ib qho yooj yim bar graph rau lub pictograph hauv Microsoft Excel.

Related tutorial: Tsim kom muaj lub cim duab hauv Excel 2003

Cov kauj ruam ntawm kev nyeem ntawv yog:

• Kauj Ruam 1: Tsim ib qho graph hauv bar hauv Excel
  
• Kauj Ruam 2: Xaiv ib cov ntaub ntawv sau cia rau hauv daim duab
  
• Kauj Ruam 3: Muab Daim Duab mus rau Pictograph
  
• Kauj Ruam 4: Cov Ntaub Ntawv Nyeem

01 ntawm 04

Lus piv txwv Kauj ruam 1: Tsim kom muaj Bar Graph

1. Yuav ua kom tiav cov kauj ruam no yog kauj ruam, ntxiv cov ntaub ntawv muaj nyob hauv kauj ruam 4 mus rau Excel 2007 spreadsheet.
   
2. Xaiv lub hlwb A2 rau D5.
   
3. Rau ntawm daim qauv, xaiv Insert> Kem> 2-d Clustered Kem .

Daim ntawv sau qhia kab ntawv yooj yim yog tsim thiab muab tso rau hauv koj daim ntawv ua haujlwm.

02 ntawm 04

Lus piv txwv Kauj ruam 2: Xaiv ib Daim Ntawv Xaj Xwb

Yog xav tau kev pab nrog cov kauj ruam no, saib daim duab saum toj no.

Los ua ib lub pictograph koj yuav tsum hloov tus duab cov ntaub ntawv rau xim tam sim no ntawm txhua tus ntawv tuav hauv daim duab.

1. Txoj cai-nias ntawm ib qho ntawm cov xiav cov ntaub ntawv tuav hauv daim duab thiab xaiv Hom Ntawv Cov Ntawv Xam ntawm lub ntsiab lus teb ntawv qhia zaub mov.
   
2. Cov kauj ruam saum toj no qhib lub Hom Lus Tshaj Tawm Lus sib tham.

03 ntawm 04

Lus piv txwv Kauj Ruam 3: Muab Daim Duab mus rau Pictograph

Yog xav tau kev pab nrog cov kauj ruam no, saib daim duab saum toj no.

Nyob rau hauv hom qauv hu ua dialog box qhib hauv kauj ruam 2:

1. Nias ntawm qhov xaiv cov kev xaiv nyob hauv qhov kev txiav txim sab laug rau sab nraud kom nkag tau cov kev xaiv.
   
2. Nyob rau sab xis ntawm lub qhov rais, nyem rau ntawm daim duab los yog daim ntawv sau xaiv.
   
3. Nias ntawm Clip Art Clip los qhib lub Xaiv Pej Xeem .
   
4. Ntaus "kua nplaum uas" hauv phau ntawv xaiv lub thawv thiab nias lub khawm mus saib tau cov duab kos duab.
   
5. Nias ntawm ib daim duab los ntawm cov neeg muaj thiab nias lub khawm TSIS tau xaiv nws.
   
6. Ndliv qhov Tshooj Tshooj hauv qab kos duab khawm khawm.
   
7. Nias lub khawm Close nyob rau hauv qab ntawm lub thawv txuas lus rov qab rau koj daim duab.
   
8. Cov kob xiav kob xiav rau hauv daim phiaj yuav tsum tau hloov nrog cov khoom qab zib xaiv.
   
9. Rov ua raws li cov kauj ruam saum toj saud kom hloov tau lwm cov pas tuav hauv daim graph mus rau duab.
   
10. Thaum ua tiav, koj cov duab kos yuav tsum zoo li tus qauv hauv nplooj 1 hauv phau ntawv no.

04 ntawm 04

Cov Ntaub Ntawv Xov Xwm

Ua raws li cov kev qhia no, ntxiv cov ntaub ntawv saum toj no mus rau ib qho Excel spreadsheet pib hauv cell A3.