Excel 2003 Pie Chart Tutorial

01 ntawm 10

Excel 2003 Pie Chart Tutorial

Cov ntawv nyeem no siv cov kauj ruam los tsim cov khoom noj qab zib hauv Excel 2003 siv lub Excel Daim Ntawv Qhia Wizard.

Ua kom tiav cov kauj ruam hauv cov ncauj lus hauv qab no yuav tsim tau ib qho khoom qab zib zoo ib yam li cov duab saum toj no.

Version txawv

Cov kauj ruam hauv phau ntawv no siv cov kev teeb tsa thiab kev xaiv qhov muaj nyob rau hauv Excel 203. Cov no txawv ntawm cov neeg muaj nyob hauv cov ntawv ntxov ntawm qhov kev zov me nyuam. Siv cov kev txuas mus ntxiv nram qab no rau cov kab hauv cov qauv kev nyeem ntawv rau lwm cov qauv ntawm Excel.

02 ntawm 10

Nkag Mus Rau Hauv Daim Ntawv Qhia Txog Cov Khoom Noj

Lus cim: Rau kev pabcuam ntawm cov lus qhia no, saib daim duab saum toj no.

Tsis muaj teeb meem dab tsi ntawm daim phiaj los yog daim qauv uas koj tsim, thawj kauj ruam hauv kev tsim ib daim duab qhia ntawv Excel yog ib txwm los nkag rau 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.

• Thaum tso tawm koj daim ntawv khom nqi , sau cov npe uas teev cov ntaub ntawv hauv ib kem thiab, ntawm txoj cai ntawd, cov ntaub ntawv xwb.
• 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.

Rau qhov kev nyeem no

1. Sau cov ntaub ntawv raws li pom hauv daim duab saum toj no rau hauv hlwb A3 rau B6.

03 ntawm 10

Xaiv Cov Khoom Noj Qab Nyob Zoo

Lus cim: Rau kev pabcuam ntawm cov lus qhia no, saib daim duab saum toj no.

Siv tus nas

1. Luag xaiv nrog nas khawm kom highlight lub hlwb uas muaj cov ntaub ntawv muab tso rau hauv daim duab.

Siv cov keyboard

1. Nias rau sab laug sab ntawm cov ntaub ntawv teeb.
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 ntawv pov thawj khoom noj.

Ceeb Toom: Nco ntsoov xaiv ib lub npe thiab kab ntawv ua ke uas koj xav kom muab tso rau hauv daim duab.

Rau qhov kev nyeem no

1. Ua kom pom tseeb ntawm lub hlwb ntawm A3 rau B6 siv ib qho ntawm cov saum toj no.

04 ntawm 10

Pib ntawm Chart Wizard

Lus cim: Rau kev pabcuam ntawm cov lus qhia no, saib daim duab saum toj no.

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. Nyem ntawm Insert> Chart ... nyob rau hauv menus.

Rau qhov kev nyeem no

1. Pib Chart Wizard siv qhov koj nyiam.

05 ntawm 10

Cov ntawv teev lus Excel Wizard Kauj Ruam 1

Xaiv Daim Ntawv Qhia ntawm Cov Txheem Tab

Lus cim: Rau kev pabcuam ntawm cov lus qhia no, saib daim duab saum toj no.

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.

Rau qhov kev nyeem no

1. Xaiv qhov Pie chart type nyob rau sab laug tes.
2. Xaiv lub ncuav qab zib nrog 3-D nrig pom kev tshwm sim sub hom nyob rau sab xis
3. Nyem tom ntej.

06 ntawm 10

Cov ntawv teev lus Wizard Excel Step 2

Saib ua ntej koj daim ntawv

Lus cim: Rau kev pabcuam ntawm cov lus qhia no, saib daim duab saum toj no.

• Thaum xaiv koj cov ntaub ntawv ua ntej pib ua daim Excel Chart Wizard, koj yuav tsum pom ib qho piv txwv ntawm koj cov ntawv qhia nyob rau sab nrauv ntawm lub thawv ntawv sib tham.
• Ntawm koj cov ntaub ntawv khom nqi , cov ntaub ntawv uas tau muab tso rau hauv daim ntawv qhia yog nyob ntawm cov kab ntsig txog kev caij nplooj ntoos hlav - animated dub ciam teb ncig ntawm koj cov ntaub ntawv.
• Hauv qab no saib ua ntej lub thawv yog ib lub thawv uas muaj cov ntsiab lus ntawm xov tooj ntawm cov ntaub ntawv muaj nyob rau hauv daim phiaj. Yog tias koj daim ntawv qhia tsis zoo, koj yuav tsum xyuas kom paub tseeb tias koj xaiv cov ntaub ntawv muaj ntau nyob hauv daim ntawv tshaj tawm.

Rau qhov kev nyeem no

1. Nyem tom ntej.

07 ntawm 10

Cov Ntawv Phom Sij Hawm Qis Tshaj 3

Daim Ntawv Qhia Xaiv

Lus cim: Rau kev pabcuam ntawm cov lus qhia no, saib daim duab saum toj no.

Txawm hais tias muaj ntau txoj kev xaiv nyob rau hauv lub tabs tab tom hloov cov tsos ntawm koj daim duab , hauv cov kauj ruam no, peb tsuas yuav ntxiv cov npe.

Txhua qhov ntawm daim Excel daim ntawv qhia tau muab kho tom qab koj tau ua tiav daim ntawv Chart Wizard, yog li nws tsis tas yuav tsum ua kom tag nrho koj cov kev xaiv formatting tam sim no.

Rau qhov kev nyeem no

1. Nias rau ntawm Titles tab nyob rau sab saum toj ntawm Daim Ntawv Qhia Soj Ntsuam Chart Wizard.
2. Nyob hauv Chart lub thawv ntawv, ntaus lub npe: Cov Khw Muag Khoom Muag Hauv Khiab 2007 .
3. Nias rau ntawm Daim Ntawv Qhia Cov Ntsiab Lus rau saum toj kawg nkaus ntawm Chart Wizard dialog box.
4. Nyob rau hauv daim ntawv lo (Label Contains ), nias ntawm feem pua xaiv los xaiv nws.
5. Thaum cov ntawv qhia nyob rau hauv lub qhov rais saib ua ntej zoo, nyem dua.

Lus Cim: Thaum koj ntxiv lub npe thiab cov ntaub ntawv cov ntawv lawv yuav tsum muab ntxiv rau lub qhov rais saib ua ntej rau sab xis.

08 ntawm 10

Cov Ntawv Phom Sij Zauv Tus Kauj Ruam 4

Chart Qhov chaw

Lus cim: Rau kev pabcuam ntawm cov lus qhia no, saib daim duab saum toj no.

Tsuas muaj ob txoj kev xaiv rau qhov koj xav tso koj daim ntawv qhia:

1. Ua ib daim ntawv tshiab (muab cov ntawv qhia rau ib daim ntawv txawv ntawm koj phau ntawv ua haujlwm)
   
2. Ua ib qho khoom nyob rau hauv daim ntawv 1 (muab cov ntawv qhia nyob rau tib daim ntawv raws li koj cov ntaub ntawv hauv phau ntawv ua haujlwm)

Rau qhov kev nyeem no

1. Tshum lub vev-xaij khawm kom tso cov ntawv qhia ua ib qho khoom hauv daim ntawv 1.
2. Tshawb Xaus.

Daim ntawv pov thawj yooj yim sau tau tsim thiab muab tso rau ntawm koj daim ntawv ua haujlwm. Cov nplooj ntawv nram qab no muab cov ntawv qhia no los sib piv kom pom cov khoom noj qab zib qhia nyob hauv Kauj Ruam 1 ntawm cov ntawv qhia no.

09 ntawm 10

Ntxiv Colour rau daim ntawv ncuav qab zib

Lus cim: Rau kev pabcuam ntawm cov lus qhia no, saib daim duab saum toj no.

Hloov xim tom qab ntawm daim duab

1. Txoj cai nias ib zaug nrog tus nas pointer nyob txhua qhov ntawm cov tom qab dawb ntawm lub teeb los qhib lub tshuab raj nqes.
2. Nyem nrog tus pointer pointer ntawm qhov kev xaiv thawj zaug hauv tshuab raj: Hom Chart Cheeb Tsam Area qhib Chart Area dialog box.
3. Nias rau ntawm Cov Qauv Xaiv los xaiv nws.
4. Hauv cheeb tsam , nyem rau ntawm ib lub kob dawb lias los xaiv nws.
5. Rau qhov kev nyeem no, xaiv xim liab xim rau hauv qab ntawm txoj cai hauv lub thawv ntawv.
6. Nyem OK.

Hloov xim tom qab / tshem tus ciam teb los ntawm cov lus dab neeg

1. Txoj nyem ib zaug nrog tus nas pointer nyob txhua qhov chaw nyob tom qab ntawm daim duab cov lus dab neeg los qhib cov ntawv sau cia.
2. Nyem nrog tus pointer nas ntawm qhov kev xaiv thawj zaug hauv tshuab raj: Hom lus Legend qhib lub hom lus sib tham lus.
3. Nias rau ntawm Cov Qauv Xaiv los xaiv nws.
4. Hauv seem Cuam nyob rau sab laug ntawm lub thawv sab nraud, nyem rau ntawm qhov tsis xaiv qhov tshem tawm tus ciam teb.
5. Hauv cheeb tsam , nyem rau ntawm ib lub kob dawb lias los xaiv nws.
6. Rau qhov kev nyeem no, xaiv xim liab xim rau hauv qab ntawm txoj cai hauv lub thawv ntawv.
7. Nyem OK.

10 ntawm 10

Tshawb ib daig ntawm lub ncuav qab zib

Lus cim: Rau kev pabcuam ntawm cov lus qhia no, saib daim duab saum toj no.

Mus ntxiv rau ib qho ntawm cov khoom noj qab zib uas koj txav tau los yog "tawg" no daim tawm ntawm qhov seem ntawm daim npav.

1. Nyem nrog tus pointer pointer ntawm daim qauv qhia rau nws. Cov txheej txheem me me yuav tsum pom ntawm sab nraud ntug ntawm lub khoom noj qab zib.
2. Nyem ib lub sij hawm thib ob nrog tus nas pointer ntawm daj (oatmeal raisin) hlais ntawm lub ncuav. Cov blocks tsaus nti yuav tsum tam sim no puag ncig ntawm daim npog nkaus xwb.
3. Nyem thiab luag mus rau sab laug nrog tus nas pointer ntawm daim tawv daj ntawm lub ncuav qab zib. Daim ntawv yuav tsum txav deb ntawm qhov seem ntawm daim ntawv qhia.
4. Tshem tawm lub pob tawg lawm rov mus rau nws qhov chaw qub rov qab ua cov kauj ruam 1 thiab 2 saum toj no thiab mam li rub tus hlais rov qab rau lub ncuav. Nws yuav cia li rov mus rau qhov chaw qub.

Nrog daim ntawv daj daj ntos daim duab qhia yuav tsum thaij lub ncuav daim duab qhia nyob rau hauv Kauj Ruam 1 ntawm cov ntawv nyeem no.