Qhov wikiHow no qhia koj li cas los tsim qhov pom kev sawv cev ntawm koj cov ntaub ntawv hauv Microsoft Excel siv daim ntawv qhia ncuav qab zib.
Cov kauj ruam
Ntu 1 ntawm 2: Ntxiv Cov Ntaub Ntawv
Kauj Ruam 1. Qhib Microsoft Excel
Nws zoo li tus dawb "E" ntawm keeb kwm ntsuab.
Yog tias koj xav ua daim ntawv qhia los ntawm cov ntaub ntawv koj twb muaj, ob npaug nias rau daim ntawv Excel 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 nyob rau sab saum toj-sab laug ntawm "Template" qhov rai.
Kauj Ruam 3. Ntxiv lub npe rau daim duab
Txhawm rau ua qhov no, nyem lub pob B1 cell thiab tom qab ntawd ntaus lub npe kab ntawv.
- Piv txwv li, yog tias koj tab tom ua daim ntawv qhia txog koj cov peev nyiaj, cov B1 xov tooj yuav tsum hais qee yam xws li "2017 Pob Nyiaj".
- Koj kuj tseem tuaj yeem sau daim ntawv qhia meej-piv txwv li, "Kev faib nyiaj txiag"-hauv A1 ntawm tes.
Kauj Ruam 4. Ntxiv koj cov ntaub ntawv rau hauv kab ntawv
Koj yuav tso cov phiaj xwm txheej ncuav qab zib 'cov ntawv lo rau hauv A kem thiab cov ntu ntu qhov tseem ceeb hauv B kem
- Txog qhov piv txwv pob nyiaj siv saum toj no, koj yuav sau "Cov Nqi Tsheb" hauv A2 thiab tom qab ntawd muab "$ 1000" tso rau hauv B2.
- Daim ntawv qhia ncuav qab zib daim ntawv yuav txiav txim siab feem pua rau koj.
Kauj Ruam 5. Ua kom tiav koj cov ntaub ntawv
Thaum koj tau ua tiav cov txheej txheem no, koj tau npaj los tsim daim ntawv qhia ncuav qab zib siv koj cov ntaub ntawv.
Ntu 2 ntawm 2: Tsim Daim 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 daim ntawv siv kab ntawv sib txawv, cov lej, thiab ntxiv rau, tsuas yog nco ntsoov nyem rau sab laug-sab laug 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 "Pie Chart" icon
Nov yog lub voj khawm nyob hauv pab pawg "Charts" ntawm cov kev xaiv, uas yog hauv qab no thiab mus rau sab xis ntawm Ntxig tab. Koj yuav pom ntau qhov kev xaiv tshwm sim hauv cov ntawv qhia zaub mov nco-down:
- 2-D Peb - Tsim daim ntawv qhia ncuav qab zib yooj yim uas qhia txog xim-coded ntu ntawm koj cov ntaub ntawv.
- 3-D Peb -Siv daim duab peb sab daim duab uas qhia cov xim-coded cov ntaub ntawv.
Kauj Ruam 4. Nyem qhov kev xaiv
Ua li ntawd yuav tsim daim ntawv qhia ncuav qab zib nrog koj cov ntaub ntawv siv rau nws; koj yuav tsum pom cov xim-cim tabs hauv qab ntawm kab ntawv uas sib raug rau cov xim ntu ntawm daim duab nws tus kheej.
Koj tuaj yeem saib ua ntej cov kev xaiv ntawm no los ntawm koj tus nas hla cov qauv sib txawv
Kauj Ruam 5. Kho koj daim duab kom pom
Txhawm rau ua qhov no, nyem lub pob Tsim tab nyob ze rau sab saum toj ntawm "Excel" qhov rai, tom qab ntawv nyem rau ntawm qhov kev xaiv hauv pab pawg "Chart Styles". Qhov no yuav hloov txoj hauv kev uas koj daim duab zoo li, suav nrog cov xim uas siv, faib cov ntawv, thiab seb puas yog lossis tsis yog feem pua tau tshwm sim.
Mus saib cov Tsim tab, koj daim ntawv yuav tsum raug xaiv. Koj tuaj yeem xaiv kab ntawv los ntawm txhaj rau nws.
Cov Qauv Ncuav Qab Zib
Qauv Ncuav Qab Zib Daim Ntawv Txog Lub Sijhawm
Txhawb wikiHow thiab qhib tag nrho cov qauv.
Qauv Daim Qauv Ncauj Lus Txog Khoom Noj
Txhawb wikiHow thiab qhib tag nrho cov qauv.
Qauv Daim Qauv Ncauj Lus Txog Kev Ua Si
Txhawb wikiHow thiab qhib tag nrho cov qauv.
Lub tswv yim
- Koj tuaj yeem luam koj daim ntawv thiab muab tso rau lwm yam khoom siv hauv Microsoft Office (piv txwv li, Lo Lus lossis PowerPoint).
- Yog tias koj xav tsim cov kab kos rau ntau cov ntaub ntawv, rov ua cov txheej txheem no rau txhua txheej. Thaum daim duab tshwm, nyem thiab rub nws kom deb ntawm qhov chaw nruab nrab ntawm daim ntawv Excel txhawm rau tiv thaiv nws los ntawm npog koj thawj daim duab.