Excel 2003 Kab Cov Kab Xam Pom

01 ntawm 10

Txheej txheem cej luam Excel 2003 Chart Wizard

Cov ntawv nyeem no siv cov kauj ruam los tsim kom muaj kab ib kab hauv Excel 2003 siv lub Excel Daim Ntawv Qhia Suab.

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

02 ntawm 10

Nkag mus rau hauv Daim Ntawv Qhia Kab

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.

Cov Kauj Ruam Tutorial

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

03 ntawm 10

Xaiv Kab Kev Tshaj Xo

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 kab teeb.

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

Cov Kauj Ruam Tutorial

1. Tshav fais fab ntawm lub hlwb ntawm A2 mus rau C6, uas muaj cov npe hauv qab thiab cov kab ua haujlwm siv ib qho ntawm cov saum toj no.

04 ntawm 10

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

Cov Kauj Ruam Tutorial

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

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.

Cov Kauj Ruam Tutorial

1. Xaiv kab hom kab hauv kab laug sab.
2. Xaiv tus Kab nrog cov npiv tsuam npawb hauv qab ntawm txoj cai sab xis
3. Nyem tom ntej.

06 ntawm 10

Cov ntawv teev lus Wizard Excel Step 2

Saib ua ntej koj daim ntawv

• 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.

Cov Kauj Ruam Tutorial

1. Nyem tom ntej.

07 ntawm 10

Cov Ntawv Phom Sij Hawm Qis Tshaj 3

Daim Ntawv Qhia Xaiv

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.

Cov Kauj Ruam Tutorial

1. Nias rau ntawm Titles tab nyob rau sab saum toj ntawm Daim Ntawv Qhia Soj Ntsuam Chart Wizard.
2. Nyob rau hauv Chart lub thawv ntawv, ntaus lub npe: Nruab Nrab Precipitation rau Acapulco thiab Amsterdam .
3. Nyob hauv Kab (X) txoj kab xev, ntaus ntawv: Lub Hlis .
4. Hauv Kem (Y) axis lub thawv, hom: Lub caij nplooj ntoos zeeg (hli) (Nco: mm = millimeters).
5. Thaum cov ntawv qhia nyob rau hauv lub qhov rais saib ua ntej zoo, nyem dua.

Lus Cim: Thaum koj ntaus lub npe, 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

Graph Qhov Chaw

Tsuas muaj ob txoj kev xaiv rau qhov koj xav tso koj cov duab:

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)

Cov Kauj Ruam Tutorial

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

Cov kab ntawv yooj yim yog tsim thiab muab tso rau hauv koj daim ntawv ua haujlwm. Cov nplooj ntawv nram qab no muab cov duab no los ua kom haum rau cov kab qhia tau hauv kauj ruam 1 ntawm qhov kev qhia no.

09 ntawm 10

Teeb Meem Kab Kab

Muab lub npe lub npe tso rau ntawm ob kab

1. Nyem ib zaug nrog tus nas pointer nyob txhua qhov chaw ntawm lub npe hu ua highlight.
2. Nyem ib lub sij hawm thib ob nrog tus pointer tus cai nyob rau hauv pem hauv ntej ntawm lo lus Acapulco los nrhiav lub ntsiab lus ntxig rau.
3. Nias lub khawm ENTER rau hauv keyboard kom faib lub npe teeb npe rau ob kab.

Hloov xim tom qab ntawm daim duab

1. Txoj cai-nias ib zaug nrog tus nas pointer nyob qhov twg 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 lub teeb xim daj nyob hauv qab ntawm lub thawv txuas lus.
6. Nyem OK.

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

1. Txoj cai -click ib zaug nrog tus nas pointer qhov twg nyob rau tom qab ntawm daim duab cov lus dab neeg los qhib lub tshuab raj tawm.
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 lub teeb xim daj nyob hauv qab ntawm lub thawv txuas lus.
7. Nyem OK.

10 ntawm 10

Teeb Meem Rau Cov Kab Kab (Txuas Ntxiv)

Hloov xim / tshem tus ciam teb ntawm thaj chaw

1. Txoj cai -click ib zaug nrog tus nas pointer nyob qhov twg ntawm qhov cuab yeej grey yog ntawm lub teeb qhib qhov nco cia zaub mov.
2. Nyem nrog tus pointer pointer ntawm qhov kev xaiv thawj zaug hauv zaub mov: Format Plot Area kom qhib lub Thaj Chaw Tawm Tsam Xaiv qhov sib tham.
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 seem ntawm sab xis, nyem rau ntawm ib lub kob dawb lias los xaiv nws.
6. Rau qhov kev nyeem no, xaiv lub teeb xim daj nyob hauv qab ntawm lub thawv txuas lus.
7. Nyem OK.

Tshem cov Y axis

1. Txoj cai -click ib zaug nrog tus pointer ntawm Y axis (txoj kab ntsug ntawm qhov nyiaj nag lossis daus) ntawm lub teeb los qhib lub tshuab raj nqes.
2. Nyem nrog tus pointer pointer ntawm qhov kev xaiv thawj zaug hauv zaub mov: Format Axis qhib lub thawv Axial dialog box.
3. Nias rau ntawm Cov Qauv Xaiv los xaiv nws.
4. Hauv seem ntawm sab laug ntawm lub thawv sab nraud, nyem rau ntawm qhov tsis xaiv qhov tshem ntawm txoj kab xev.
5. Nyem OK.

Nyob rau ntawm qhov no, koj daim duab yuav tsum thooj rau kab kab ntawv tau qhia nyob rau Kauj Ruam 1 ntawm qhov kev qhia no.