Qhov wikiHow qhia koj yuav ua li cas los ua tus sawv cev pom ntawm koj cov ntaub ntawv hauv Microsoft Excel siv kab ntawv kab.
Cov kauj ruam
Ntu 1 ntawm 2: Ntxiv Cov Ntaub Ntawv
Kauj Ruam 1. Qhib Microsoft Excel
Nws zoo li dawb "X" ntawm keeb kwm ntsuab.
Yog tias koj xav tsim daim duab los ntawm cov ntaub ntawv ua ntej, hloov ob npaug rau nyem rau Excel cov ntawv uas muaj cov ntaub ntawv qhib nws thiab mus rau ntu tom ntej
Kauj Ruam 2. Nyem Phau ntawv ua haujlwm dawb paug (PC) lub Phau Ntawv Excel (Mac).
Nws yog nyob rau sab saum toj-sab laug ntawm lub qhov rai qauv.
Kauj Ruam 3. Ntxiv cov ntawv lo rau kab duab X- thiab Y-axes
Txhawm rau ua qhov no, nyem lub pob A1 cell (X-axis) thiab ntaus rau hauv daim ntawv lo, tom qab ntawd ua tib yam rau B1 cell (Y-axis).
Piv txwv li, daim duab ntsuas ntsuas qhov kub ntau tshaj li ib lub lim tiam tus nqi ntawm cov hnub yuav muaj "Hnub" hauv A1 thiab "Kub" hauv B1.
Kauj Ruam 4. Sau cov ntaub ntawv rau kab X's thiab Y-axes
Txhawm rau ua qhov no, koj yuav ntaus tus lej lossis lo lus rau hauv A los yog B kem los siv nws rau X- lossis Y-axis, feem.
Piv txwv li, ntaus "Monday" rau hauv A2 cell thiab "70" rau hauv B2 thaj chaw yuav qhia tau tias nws yog 70 degrees rau hnub Monday.
Kauj Ruam 5. Ua kom tiav koj cov ntaub ntawv
Thaum koj cov ntaub ntawv nkag teb chaws tiav, koj tau npaj siv cov ntaub ntawv los tsim kab ntawv kab.
Ntu 2 ntawm 2: Tsim Kab Duab
Kauj Ruam 1. Xaiv tag nrho koj cov ntaub ntawv
Txhawm rau ua qhov no, nyem lub pob A1 ntawm tes, tuav ⇧ Ua haujlwm, thiab tom qab ntawd nyem rau tus nqi hauv qab hauv B kem Qhov no yuav xaiv tag nrho koj cov ntaub ntawv.
Yog tias koj kab ntawv siv kab ntawv sib txawv, cov lej, thiab lwm yam, tsuas yog nco ntsoov nyem rau sab laug-sab tes ntawm koj cov pab pawg cov ntaub ntawv thiab tom qab ntawd nyem rau hauv qab-sab xis thaum tuav ⇧ Ua haujlwm
Kauj ruam 2. Nyem rau Insert tab
Nws nyob rau sab saud ntawm Excel qhov rai, tsuas yog txoj cai ntawm Tsev tab.
Kauj Ruam 3. Nyem rau "Bar chart" icon
Lub cim no nyob hauv pab pawg "Charts" hauv qab no thiab mus rau sab xis ntawm Ntxig tab; nws zoo ib yam li peb kab ntsug kab.
Kauj Ruam 4. Nyem qhov kab ntawv kab lus xaiv
Cov qauv muaj rau koj yuav txawv nyob ntawm koj lub operating system thiab seb koj puas tau yuav Excel, tab sis qee qhov kev xaiv nrov suav nrog cov hauv qab no:
- 2-D Kab - Sawv cev koj cov ntaub ntawv nrog cov kab yooj yim, ntsug.
- Kab 3-D - Qhia peb-seem, kab ntsug.
- 2-D Pub - Qhia cov kab lus yooj yim nrog kab rov tav hloov chaw tsis yog ntsug.
- 3D Bar - Qhia peb-seem, kab rov tav.
Kauj Ruam 5. Kho kom haum koj lub teeb duab
Thaum koj txiav txim siab rau daim duab, koj tuaj yeem siv ntu "Tsim" nyob ze rau sab saum toj ntawm lub qhov rai Excel los xaiv tus qauv sib txawv, hloov cov xim siv, lossis hloov hom kab duab tag nrho.
- Qhov "Tsim" qhov rai tsuas tshwm thaum koj teeb duab raug xaiv. Txhawm rau xaiv koj daim duab, nyem rau nws.
- Koj tseem tuaj yeem nyem kab ntawv lub npe kom xaiv nws thiab tom qab ntawd ntaus lub npe tshiab. Lub npe feem ntau yog nyob rau sab saum toj ntawm kab kos lub qhov rais.
Qauv Bar Graphs
Qauv Kab Kab Kab Kab
Qauv Vertical Bar Graph
Qauv Sib Nqus Bar Teeb
Lub tswv yim
- Cov duab tuaj yeem luam tawm thiab tom qab ntawd muab tso rau lwm qhov Microsoft Office cov haujlwm xws li Lo Lus lossis PowerPoint.
- Yog tias koj daim duab hloov pauv x thiab y axes ntawm koj lub rooj, mus rau "Tsim" tab thiab xaiv "Hloov Kab/Kab" los kho nws.