Yuav ua li cas los tsim kom muaj Bar Daim duab / Kem Chart hauv Excel

01 ntawm 09

Tsim Daim Npav Piav Qhia / Kem Daim Ntawv nrog Daim Ntawv Qhia Sia Nyob Hauv Excel 2003

Qhov kev qhia nyeem no siv cov Chart Wizard hauv Excel 2003 los tsim tau ib qho graph. Nws coj koj los ntawm kev siv cov nquag pom tshaj plaws nyob hauv plaub cov ntxaij vab tshaus ntawm Daim Ntawv Qhia Sia (Wizard).

Chart Wizard yog tsim los ntawm ntau lub rooj sib tham uas muab rau koj txhua txoj hauv kev rau tsim ib daim duab.

Lub Thawv Plaub Hlis Plaub Hlis lossis Cov Kauj Ruam ntawm Daim Ntawv Qhia Ua Ntej

1. Xaiv hom ntawv qhia xws li khoom noj qab zib, daim qauv kab ntawv, los yog daim qauv qhia kab kos.
2. Xaiv los yog xyuas cov ntaub ntawv uas yuav siv los tsim daim phiaj.
3. Ntxiv cov npe rau daim ntawv thiab xaiv ntau hom kev xaiv xws li ntxiv cov ntawv thiab cov lus dab neeg.
4. Txiav txim siab seb puas yuav muab cov ntawv qhia rau tib nplooj ntawv raws li cov ntaub ntawv los yog ntawm ib daim ntawv ntxiv.

Lus Cim: Peb cov neeg coob hu rau daim duab bar yog raug xa mus, hauv Excel, ua daim ntawv qhia kab lus , los yog ib qho qauv qhia ntawv .

Cov Chart Wizard Yog Tsis Muaj Ntxiv

Daim ntawv sau lub npe tau raug tshem tawm ntawm Excel pib nrog version 2007. Nws tau raug hloov nrog cov ntawv qhia xaiv nyob hauv qab ntawm daim ntawv ntawm kab ntawv .

Yog hais tias koj muaj ib tug version ntawm qhov kev pab cuam tom qab tshaj 2003 2003, siv cov kev txuas mus txuas ntxiv rau lwm cov ntawv qhia / daim duab hauv Excel:

• Excel 2013 Bar Graph / Column Chart Tutorial
• Excel 2010/2007 Bar Graph / Column Chart Tutorial

02 ntawm 09

Nkag mus rau hauv Cov Ntaub Ntawv Ntaus Bar

Thawj kauj ruam hauv kev tsim ib qho teeb meem yog sau cov ntaub ntawv rau hauv daim ntawv ua haujlwm .

Thaum nkag mus rau cov ntaub ntawv, khaws cov cai tswj no:

1. Tsis txhob tseg cov kab sau los yog kab nrib thaum nkag hauv koj cov ntaub ntawv.
2. Sau koj cov ntaub ntawv hauv txhua kab.
   

Lus Cim: Thaum tso tawm koj daim ntawv khom nqi, sau cov npe uas teev cov ntsiab lus hauv ib kem thiab rau sab xis ntawd, cov ntaub ntawv nws tus kheej. Yog tias muaj ntau tshaj ib cov lus qhia, sau lawv ib qho tom qab ntawm txhua kab ntawv nrog rau lub npe rau txhua cov ntaub ntawv series rau saum toj.

Ua raws li cov kev qhia no, nkag mus rau cov ntaub ntawv nyob hauv kauj ruam 9 ntawm qhov kev qhia no.

03 ntawm 09

Xaiv qhov Bar Cov Ntaub Ntawv Ntaus - Ob Xaiv

Siv tus nas

1. Luag xaiv nrog nas khawm kom highlight lub hlwb uas muaj cov ntaub ntawv yuav tsum muaj nyob hauv lub teeb duab.

Siv cov Keyboard

1. Nias rau sab laug sab laug ntawm daim phiaj bar cov ntaub ntawv.
2. Hold down tus yuam sij SHIFT rau cov keyboard.
3. Siv cov xub tuav ntawm cov keyboard los xaiv cov ntaub ntawv kom muab tso rau hauv daim phiaj bar.

Nco ntsoov: Nco ntsoov xaiv ib lub npe thiab kab ntawv uas koj xav tau tso rau hauv daim duab.

Rau Txoj Kev Nyeem

1. Tshav fais fab ntawm lub hlwb ntawm A2 mus rau D5, uas muaj cov npe hauv qab thiab cov kab ntawv uake

04 ntawm 09

Yuav pib lub Chart Wizard

Koj muaj ob txoj kev xaiv pib ntawm Excel Daim Ntawv Qhia Suab.

1. Nias rau ntawm daim ntawv Chart Wizard icon ntawm tus qauv txheem (saib daim duab saum toj no)
2. Xaiv Insert> Chart ... ntawm cov zaub mov.

Rau Txoj Kev Nyeem

1. Pib Chart Wizard siv qhov koj nyiam.

Cov nplooj ntawv hauv qab no ua haujlwm dhau los ntawm plaub yam ntawm Daim Ntawv Qhia Rau Chart.

05 ntawm 09

Kauj Ruam 1 - Xaiv Tus Qauv Hom

Nco ntsoov: Peb feem ntau hu rau daim duab bar yog raug xa mus, hauv Excel, ua daim ntawv qhia kab lus , los yog ib qho qauv qhia ntawv .

Xaiv Daim Ntawv Qhia ntawm Cov Txheem Tab

1. Xaiv ib daim ntawv ntawm daim qauv ntawm sab laug lub vaj huam sib luag.
2. Xaiv cov ntawv qhia khoom tawm ntawm lub vaj huam sib luag.

Lus Cim: Yog tias koj xav tsim teeb duab ntau me ntsis ntxiv, xaiv Cov Hom Hauj Lwm tab rau saum Chart Hom dialog box.

Rau Txoj Kev Nyeem
(ntawm Daim Ntawv Qhia Cov Qauv Hom Ntawv Tab)

1. Xaiv lub Column daim ntawv qhia nyob rau sab laug tes pane.
2. Xaiv Clustered Column chart sub hom nyob rau sab xis sab xis.
3. Nyem tom ntej.

06 ntawm 09

Kauj Ruam 2 - Ua Ntej Saib Koj Daim Npav Bar

• Yog tias koj xaiv koj cov ntaub ntawv ua ntej pib ua daim Excel Chart Wizard, koj yuav pom ib qho piv txwv ntawm koj qhov teeb meem sab nraud ntawm sab nrauv ntawm lub thawv ntawv.
• Ntawm koj cov ntaub ntawv khom nqi, cov ntaub ntawv uas tau muab tso rau hauv daim phiaj yog ncig los ntawm cov kab ntsig txoj kab-cov kab dub animated dub nyob ntawm koj cov ntaub ntawv.
• Hauv qab no qhov saib ua ntej lub thawv yog ib lub thawv uas muaj cov xov tooj ntawm tes ntawm cov ntaub ntawv muaj nyob rau hauv daim duab.
• Yog tias koj qhov teeb meem sab nraud tsis zoo, koj yuav tsum xyuas kom paub tseeb tias koj tau xaiv cov ntaub ntawv zoo nyob hauv daim ntawv tshaj tawm.

Rau Txoj Kev Nyeem

1. Yog tias koj lub teeb tshwm muaj nyob hauv qhov kev saib ua ntej, nias Next .

07 ntawm 09

Kauj Ruam 3 - Tshaj Tawm Qauv Lawm

Txawm hais tias muaj ntau txoj kev xaiv nyob rau hauv lub tabs rau kev hloov kho qhov pom ntawm koj daim duab hauv lub kauj ruam no, peb tsuas yuav ntxiv ib lub npe rau peb lub teeb duab.

Tag nrho cov seem ntawm daim duab tau muab hloov kho tom qab koj tau ua tiav Daim Ntawv Qhia Sia (Wizard).

Nws tsis tsim nyog los ua kom tag nrho koj cov kev xaiv formatting tam sim no.

Rau Txoj Kev Nyeem

1. Nias rau ntawm lub npe tab rau saum lub thawv ntawv.
2. Nyob rau hauv Chart lub thawv ntawv, ntaus lub npe Cov Khw Muag Khoom Kav 2003 - 2005 Nyiaj Tau Los .

Lus Cim: Thaum koj ntaus lub npe, lawv yuav tsum muab ntxiv rau lub qhov rais saib ua ntej rau sab xis.

08 ntawm 09

Kauj Ruam 4 - Qhov Chaw Nyob

Tsuas muaj ob txoj kev xaiv rau qhov chaw koj xav tso koj daim npav bar:

1. Ua ib daim ntawv tshiab (muab cov duab ntawm lwm daim ntawv los ntawm koj cov ntaub ntawv hauv phau ntawv ua haujlwm)
2. Ua ib qho khoom nyob rau hauv ib daim ntawv 1 (muab cov duab hauv daim ntawv tib yam li koj cov ntaub ntawv hauv phau ntawv ua haujlwm)

Rau Txoj Kev Nyeem

1. Tshawb lub vev-xaij khawm kom muab lub teeb tso rau hauv daim ntawv 1.
2. Tshawb Xaus

Formatting Bar Graph

Thaum twg tus thawj xib fwb tiav lawm, koj daim duab bar yuav tso rau hauv daim ntawv ua haujlwm. Daim duab tseem yuav tsum tau muab teev kom meej ua ntej nws tuaj yeem raug ua tiav.

09 ntawm 09

Bar Cov Ntaub Ntawv Kawm Duab

Sau cov ntaub ntawv hauv qab no rau hauv lub hlwb uas tau tsim los ua qhov teeb meem sab hauv cov ntawv qhia no. Yog tsis muaj daim ntawv sau ua haujlwm nyob rau hauv phau ntawv no, tiam sis qhov ntawd yuav tsis cuam tshuam rau koj qhov teeb meem sab nraud.

Cell - Cov ntaub ntawv
A1 - Cov Nyiaj Khwv Tau Los - Cov Khw Muag Khoom Noj
A3 - Tag Nrho Cov Nyiaj Tau Los:
A4 - Tag Nrho Cov Nqi:
A5 - Nyiaj / Nyiaj Tau Los:
B2 - 2003
B3 - 82837
B4 - 57190
B5 - 25674
C2 - 2004
C3 - 83291
C4 - 59276
C5 - 26101
D2 - 2005
D3 - 75682
D4 - 68645
D5 - 18492

Rov qab mus rau kauj ruam 2 ntawm qhov kev qhia no.