Yuav Paub
- Qhib cov ntaub ntawv Excel uas muaj cov ntaub ntawv. Xaiv ib thaj tsam rau daim duab.
- Mus rau Insert tab thiab xaiv Daim Ntawv Qhialossis xaiv Daim Ntawv Pom Zoo thiab txav mus hla cov kev xaiv los saib ua ntej.
- Xaiv daim duab qhia ntxiv rau koj daim ntawv ua haujlwm. Siv Cov cuab yeej kab kos los hloov pauv rau daim duab.
Kab lus no piav qhia yuav ua li cas ntxiv ib daim ntawv qhia hauv Excel thiab suav nrog cov ntaub ntawv ntawm hom kab kos muaj thiab yuav siv li cas. Cov lus qhia siv rau Excel 2019, 2016, 2013, 2010; Excel rau Microsoft 365, thiab Excel Online.
Ntxiv ib daim ntawv hauv Excel
Kab kos thiab kab kos yog qhov pom kev sawv cev ntawm cov ntaub ntawv ua haujlwm. Cov duab no pab koj nkag siab cov ntaub ntawv hauv daim ntawv ua haujlwm los ntawm kev nthuav tawm cov qauv thiab cov qauv uas nyuaj rau pom hauv cov ntaub ntawv.
Txoj hauv kev zoo tshaj los kawm txog ntau cov kab kos hauv Excel yog sim lawv.
- Qhib cov ntaub ntawv Excel uas muaj cov ntaub ntawv.
-
Xaiv qhov ntau yam koj xav tau teeb tsa. Txhawm rau xaiv qhov ntau, rub los ntawm thawj lub xov tooj mus rau lub xov tooj kawg.
Image -
Ntawm daim kab xev, mus rau Insert thiab xaiv qhov xav tau Daim Ntawv Qhiakom pom cov ntawv qhia zaub mov muaj cov kab ntawv ntawm hom ntawd.
Image Yog tias koj tsis paub tias hom kab ntawv twg yuav ua haujlwm zoo tshaj plaws nrog koj cov ntaub ntawv, xaiv Daim Ntawv Pom Zoo txhawm rau pom koj cov ntaub ntawv formatted hauv cov kab kos thiab cov duab sib txawv.
-
Hover ib daim duab hauv daim ntawv kom pom qhov saib ua ntej ntawm daim duab hauv daim ntawv ua haujlwm.
Image -
Xaiv kab ntawv hom koj xav siv. Daim duab qhia ntxiv rau daim ntawv ua haujlwm.
Image - Txhawm rau hloov pauv rau daim ntawv, siv Daim Ntawv Qhia(nyob rau sab xis ntawm daim ntawv xaiv) lossis nyem rau ntawm daim duab xaiv cov ntaub ntawv, xaiv qhov sib txawv chart format, los yog format lub gridlines thiab axis.
Daim duab yog siv los piav qhia txog cov xwm txheej dhau sijhawm, thiab cov kab kos qhia cov qauv lossis muaj cov ntaub ntawv hais txog zaus. Xaiv daim ntawv Excel lossis daim duab uas haum koj xav tau. Excel muaj ntau hom xaiv los ntawm.
Sib piv Cov Nqi Nrog Daim Ntawv Pie
Pie kab kos (lossis daim duab voj voog) sib piv cov txiaj ntsig thiab pom cov txiaj ntsig hauv feem pua. Tag nrho lub voj voog ntawm daim ntawv ncuav qab zib sawv cev 100 feem pua. Lub voj voog yog subdivided rau hauv slices sawv cev cov ntaub ntawv muaj nuj nqis. Qhov loj ntawm txhua daim ua ib feem ntawm 100 feem pua nws sawv cev.
Nov yog ob peb yam piv txwv:
- Ib lub tuam txhab cov nyiaj tau los rau txhua lub hlis tuaj yeem pom hauv daim ntawv qhia ncuav qab zib nrog txhua daim ntawm lub ncuav sawv cev rau ib hlis raws li feem pua ntawm cov nyiaj tau los ntawm lub xyoo.
- Tus ntaus pob ntaus pob qhov nruab nrab tuaj yeem pom nrog daim ntawv qhia ncuav qab zib vim nws sawv cev rau feem pua ntawm cov hits piv rau tag nrho cov naj npawb ntawm cov puav rau ib lub caij.
- feem pua ntawm koj cov calorie txhua hnub suav tias ib lub cheese thiab nqaij npuas kib sawv cev.
Qhia kev sib piv nrog cov kab kos
Kem kab kos, tseem hu ua bar graphs, qhia kev sib piv ntawm cov ntaub ntawv. Cov kab kos no qhia qhov sib txawv ntawm pawg ntawm cov ntaub ntawv.
Cov txiaj ntsig tau tshwm sim siv lub kab ntsug lossis duab plaub, thiab txhua kab hauv kab ntawv sawv cev rau pawg ntaub ntawv sib txawv. Piv txwv li:
- Nyob hauv ib lub tsev kawm ntawv chav kawm, ib daim duab qhia thiab piv cov tub ntxhais kawm ntawv uas muaj qib sib txawv. Cov tub ntxhais kawm ntau dua nrog ib qib tshwj xeeb, qhov siab dua qhov bar rau qib ntawd nyob ntawm daim duab.
- Siv cov xim sib txawv los piav qhia cov calories hauv cheese thiab nqaij npuas kib hamburger piv rau cov calories hauv ib lub tais ntawm beet zaub thiab cov calories hauv ib lub tais ntawm mac thiab cheese.
Piv Cov Ntaub Ntawv Nrog Daim Ntawv Qhia Bar
Cov kab kos kab kos yog kab kab kos uas tau poob rau ib sab. Cov kab lossis kab khiav kab rov tav raws nplooj ntawv es tsis yog ntsug.
Lub axes hloov ib yam. Y axis yog kab rov tav raws hauv qab ntawm daim ntawv, thiab X axis khiav vertically raws sab laug.
Txoj Kev Hloov Sijhawm Nrog Kab Kab
kab kab kos, lossis kab duab kab, qhia cov kev hloov pauv raws sijhawm. Txhua kab hauv daim duab qhia qhov kev hloov pauv ntawm tus nqi ntawm ib yam khoom ntawm cov ntaub ntawv.
Zoo ib yam li lwm cov duab, kab graphs muaj ib txoj kab ntsug thiab kab rov tav. Thaum plotting hloov cov ntaub ntawv nyob rau hauv lub sij hawm, lub sij hawm yog plotted raws kab rov tav los yog X axis, thiab lwm yam ntaub ntawv yog plotted raws li ib tug neeg cov ntsiab lus raws li ntsug los yog Y axis. Thaum ib tus neeg cov ntaub ntawv cov ntsiab lus txuas nrog cov kab, lawv qhia qhov hloov pauv hauv cov ntaub ntawv.
Piv txwv li, siv kab ntawv qhia kev hloov pauv hauv koj qhov hnyav dhau ib lub hlis vim yog noj zaub xwb txhua hnub rau pluas su. Lossis, siv cov kab kos los npaj cov kev hloov pauv txhua hnub hauv cov nqi tshwj xeeb.
kab kab kos kuj tau siv los ua cov ntaub ntawv sau tseg los ntawm kev sim tshawb fawb, xws li yuav ua li cas cov tshuaj reacts hloov kub lossis atmospheric siab.
Show Trends With Scatter Plot Graphs
Scatter daim duab qhia cov qauv hauv cov ntaub ntawv. Cov duab no muaj txiaj ntsig zoo thaum muaj ntau cov ntaub ntawv cov ntsiab lus. Ib yam li kab graphs, scatter plots tuaj yeem siv los ua cov ntaub ntawv sau tseg los ntawm kev sim kev tshawb fawb, xws li yuav ua li cas cov tshuaj reacts hloov kub lossis atmospheric siab.
kab graphs txuas cov dots lossis cov ntsiab lus ntawm cov ntaub ntawv los qhia kev hloov pauv ntawm cov ntaub ntawv dhau sijhawm, thaum lub phiaj xwm tawg yog qhov "zoo tshaj plaws" kab. Cov ntaub ntawv cov ntsiab lus tau tawg mus rau ntawm kab. Qhov ze dua cov ntsiab lus ntawm cov ntaub ntawv yog rau kab, qhov muaj zog dua qhov kev sib raug zoo lossis cuam tshuam ib qho kev sib txawv ntawm lwm tus.
Yog tias cov ntaub ntawv cov ntsiab lus sib txuas ze dua rau txoj kab zoo tshaj plaws, cov phiaj xwm tawg qhia pom qhov sib raug zoo hauv cov ntaub ntawv. Yog tias cov ntsiab lus ntawm cov ntaub ntawv txuas ntxiv los ntawm kab, muaj qhov cuam tshuam tsis zoo hauv cov ntaub ntawv.
Display ob kab ntawv hauv ib qho nrog cov kab kos ua ke
Cov kab kos duab sib xyaw ua ke ob hom kab kos sib txawv rau hauv ib qho zaub. Feem ntau, ob daim kab kos yog kab kab thiab kab ntawv kab. Yuav kom ua tiav qhov no, Excel ua rau siv peb lub axis hu ua qhov thib ob Y axis, uas khiav raws sab xis ntawm daim ntawv.
Cov kab kos sib txuas qhia qhov nruab nrab txhua hli kub thiab nag lossis daus cov ntaub ntawv ua ke, cov ntaub ntawv tsim khoom xws li cov khoom tsim thiab cov nqi tsim khoom, lossis cov khoom muag txhua hli thiab cov nqi muag txhua hli.
kab hauv qab
Cov duab lossis cov duab kos yog kab kab kos uas siv cov duab los sawv cev cov ntaub ntawv tsis yog kab. Piv txwv li, ib daim duab uas muaj ntau pua cov duab hamburger tau muab tso rau ib qho ntawm lwm qhov qhia tias muaj pes tsawg calories ib cheese thiab nqaij npuas kib hamburger muaj piv rau ib pawg me me rau cov zaub ntsuab.
Saib cov ntaub ntawv nyiaj txiag hauv Tshuag lag luam kab kos
Cov kab ntawv Tshuag Lag Luam qhia cov ntaub ntawv hais txog cov khoom lag luam lossis cov khoom lag luam xws li lawv cov nqi qhib thiab kaw thiab qhov ntim ntawm cov khoom lag luam hauv ib lub sijhawm. Muaj ntau hom ntawv qhia zaub mov muaj nyob hauv Excel. Txhua tus qhia cov ntaub ntawv sib txawv.
Cov qauv tshiab ntawm Excel kuj suav nrog cov kab kos duab, XY npuas (lossis Scatter) kab kos, thiab kab kos Radar.
