Qhov wikiHow no qhia koj li cas kom pom kev sawv cev rau cov ntaub ntawv hauv Microsoft Excel siv kab kos kab.
Kauj ruam
Ntu 1 ntawm 1: Ntxiv Cov Ntaub Ntawv
Kauj Ruam 1. Qhib Microsoft Excel
Qhov kev zov me nyuam tau cim nrog lub cim zoo ib yam li tsab ntawv "E" dawb nyob rau tom qab ntsuab.
Yog tias koj xav tsim daim duab los ntawm cov ntaub ntawv uas twb muaj lawm, ob npaug nias rau daim ntawv Excel uas muaj cov ntaub ntawv xav tau los qhib nws thiab ua raws txoj hauv kev tom ntej
Kauj Ruam 2. Nyem Blank workbook (PC) lossis Excel Workbook (Mac)
Nws yog nyob rau sab saud sab laug ntawm lub qhov rai qauv.
Kauj Ruam 3. Ntxiv cov ntawv lo rau X thiab Y axis
Txhawm rau ntxiv nws, nyem lub npov A1 (X-axis) thiab ntaus hauv daim ntawv xav tau. Ua tib yam rau lub npov B1 (Y axis).
Piv txwv li, rau daim duab ntsuas ntsuas kub ib lub lim tiam, koj tuaj yeem sau kab ntawv A1 nrog "Hnub" thiab kab B1 nrog "Kub"
Kauj ruam 4.
Sau cov ntaub ntawv ntawm X thiab Y axis.
Txhawm rau nkag mus, ntaus tus lej lossis lo lus hauv kab "A" thiab "B" kom pom nws ntawm X thiab Y txoj kab.
Piv txwv li, ntaus "Monday" rau hauv lub thawv A2 thiab "31" hauv lub thawv B2 los sawv cev kub ntawm 31 degrees Celsius rau hnub Monday.
Ua kom tiav koj cov ntaub ntawv nkag. Thaum cov ntaub ntawv nkag teb tiav, cov ntaub ntawv tau npaj los siv ua kab duab kab.
Tsim Cov Duab
-
Xaiv tag nrho cov ntaub ntawv. Txhawm rau ua li ntawd, nyem lub npov A1 thiab tuav tus Shift qhov tseem ceeb, tom qab ntawd nyem lub npov kawg uas muaj cov ntaub ntawv hauv kab ntawv B.
Ua Bar Bar hauv Excel Kauj Ruam 6 Yog tias koj daim ntawv siv ntau kab ntawv ntawm cov tsiaj ntawv, tus lej, thiab ntxiv rau, tsuas yog nyem rau thawj lub npov (nyob rau sab saud sab laug ntawm daim ntawv) hauv pab pawg cov ntaub ntawv thiab nyem rau lub npov kawg uas muaj cov ntaub ntawv nyob hauv kaum sab xis ntawm daim ntawv thaum tuav Shift
-
Nyem rau Insert tab. Nws nyob rau sab saud ntawm Excel qhov rai, nyob ib sab ntawm "Tsev" tab.
Ua Bar Bar hauv Excel Kauj Ruam 7 -
Nyem rau "Bar chart" icon. Lub cim no tshwm nyob rau hauv “Charts” menu group, hauv qab no thiab rau sab xis ntawm “Insert” tab. Tsis tas li, lub cim zoo li peb kab ntsug.
Ua Bar Graph hauv Excel Kauj Ruam 8 -
Nyem qhov kab duab xaiv. Cov qauv muaj yuav txawv nyob ntawm qhov kev ua haujlwm thiab Excel kev yuav khoom. Txawm li cas los xij, muaj qee qhov kev xaiv uas nrov heev, xws li:
Ua Bar Graph hauv Excel Kauj Ruam 9 - 2-D Kab-Cov ntaub ntawv tau tshwm sim hauv kab ntsug yooj yim/kab.
- 3-D Column-Cov ntaub ntawv tau tshwm nyob rau hauv kab rov tav peb-seem.
- 2-D Bar-Cov ntaub ntawv raug nthuav tawm hauv kab kab rov tav yooj yim tsis yog kab ntsug.
- 3-D Bar-Cov ntaub ntawv raug nthuav tawm hauv kab peb kab rov tav.
-
Kho cov duab nraaj. Thaum koj tau xaiv cov hom ntawv, koj tuaj yeem ua kom zoo dua ntawm "Tsim" teeb tsa (pom nyob rau sab saud ntawm lub qhov rai Excel) los xaiv tus qauv sib txawv, hloov xim, lossis hloov daim duab txhua yam.
Ua Bar Graph hauv Excel Kauj Ruam 10 - Qhov "Tsim" qhov rai tsuas tshwm thaum koj xaiv cov duab. Txhawm rau xaiv nws, koj tsuas yog yuav tsum nyem rau nws.
- Koj tseem tuaj yeem nyem lub npe kab ntawv kom xaiv nws thiab ntaus lub npe tshiab. Cov npe kab ntawv feem ntau tso tawm rau sab saum toj ntawm daim duab kab ntawv.
Lub tswv yim
Cov duab tsim tau tuaj yeem theej thiab muab tshuaj txhuam (luam - muab tshuaj txhuam) tso rau hauv lwm qhov Microsoft Office programs, xws li Microsoft Word lossis Microsoft PowerPoint
