Xyaum ua ke nrog Excel cov kab kos thiab cov duab los tso saib koj cov ntaub ntawv
Cov kab kos thiab duab kos yog cov duab pom ntawm cov lus qhia ua haujlwm. Lawv feem ntau ua kom yooj yim rau kev nkag siab cov ntaub ntawv hauv daim ntawv ua haujlwm vim hais tias cov neeg siv tau tuaj yeem xaiv cov qauv thiab cov qauv uas tsis yoojyim pom hauv cov ntaub ntawv. Feem ntau, cov duab siv los qhia txog cov qauv ntawm lub sijhawm, thaum cov duab kos qhia cov qauv lossis muaj cov lus qhia txog cov zaus. Xaiv tus qauv Excel los yog daim qauv duab uas zoo tshaj plaws rau cov lus qhia rau koj xav tau.
Khoom noj qab zib
Khoom noj qab zib (lossis kos duab vajvoog) yog siv los qhia tsuas yog ib qho txawv hauv ib lub sijhawm. Yog li, lawv tsuas yog siv los qhia cov feem pua.
Lub voj voog ntawm cov khoom noj qab zib muaj pes tsawg 100 feem pua. Lub voj voos yog subdivided rau hauv cov nplaum qhia sawv cev cov ntaub ntawv tseem ceeb. Qhov luaj li cas ntawm txhua daim qhia tau hais tias feem pua ntawm 100 feem pua nws sawv cev.
Khoom noj qab zib muaj peev xwm yuav siv tau thaum koj xav pom qhov feem pua ntawm ib qho khoom nruab nrab ntawm ib cov ntawv qhia. Piv txwv li:
- Ib lub tuam txhab cov txiaj ntsig rau txhua lub hlis tuaj yeem pom nrog ib daim ntawv cog paj nrog cov feem pua ntawm cov nyiaj xyoo tag nrho.
- Tus ntaus pob sib tw ntaus pob nruab nrab tuaj yeem pom tshwm sim nrog daim ntawv cog paj nrig vim nws sawv cev qhov feem pua ntawm cov hits piv rau tagnrho cov npau suav hauv ib lub caij.
- Qhov feem pua ntawm koj cov hnub calorie txhua hnub suav tias yog ib qho cheese thiab nqaij npuas kib hamburger nruab nrab.
Kem Cheeb Tsa
Kem kab kos , kuj paub tias yog bar graphs, siv los sib piv ntawm cov khoom ntawm cov ntaub ntawv. Nws yog ib qho ntawm ntau hom kev kos siv los tso saib cov ntaub ntawv. Cov nqi pom tshwm uas siv ib lub voj voos lossis duab plaub, thiab txhua sab hauv daim phiaj qhia tau tias yog tus nqi sib txawv. Piv txwv li:
- Nyob hauv ib chav kawm ntawv, koj tuaj yeem siv lub voj voog mus qhia thiab sib piv tus naj npawb ntawm cov tub ntxhais kawm uas muaj cov plaub hau txawv xim. Cov menyuam kawm ntawv ntau dua nrog rau xim plaub hau, qhov siab tshaj qhov bar rau xim ntawd yog ntawm daim duab.
- Koj tuaj yeem siv cov xim sib txawv los qhia txog calorie ntau ntau rau hauv cov cheese thiab nqaij npuas kib hamburger piv rau cov calorie ntau ntau nyob rau hauv ib lub tais ntawm beet zaub.
Bar graphs ua kom yooj yim pom qhov sib txawv ntawm cov ntaub ntawv muab piv rau.
Bar Daim Ntawv Qhia
Bar cov kab kos yog cov kab kos duab uas tau poob ntawm lawv sab. Cov tuav los yog txhua kab khiav ntawm horizontally raws nplooj ntawv es tsis yog vertically. Txoj kab hloov zoo li-tus y-axis yog kab rov tav raws txoj kab hauv qab ntawm daim duab qhia, thiab x-axis khiav vov tuaj sab nraud.
Kab Kab Tsa
Kab kos kab , lossis kab kab, siv los qhia kev hloov sij hawm. Txhua kab hauv daim duab qhia cov kev hloov hauv cov nqi ntawm ib yam khoom ntawm cov ntaub ntawv.
Zoo ib yam li lwm cov duab, kab kab muaj ib txoj kab xaj thiab ib txoj kab ntawm txoj kab rov tav. Yog tias koj tab tom hloov cov ntaub ntawv nyob rau lub sij hawm, lub sij hawm yog npaj raws tus kab rov tav los yog x-axis, thiab koj cov ntaub ntawv, xws li dej nag ntau npaum li cas raws li tus kheej cov ntsiab lus raws ntsug lossis y-axis.
Thaum cov ntsiab lus ntawm tus kheej txuas nrog cov kab, lawv pom cov kev hloov hauv cov ntaub ntawv.
Piv txwv li, koj tuaj yeem pom cov kev hloov hauv koj qhov hnyav tshaj li ib lub hlis dhau los ntawm kev noj mov ib lub cheese thiab nqaij npuas qaib hamburger txhua hnub rau pluas su, los yog koj yuav tau hloov cov kev hloov txhua hnub hauv cov nqi lag luam. Lawv tuaj yeem siv cov ntaub ntawv khaws tseg los ntawm cov kev sim ua, xws li seb cov tshuaj ua rau muaj kev kub ntxhov hloov los yog qhov athospheric siab.
Scatter Daim Npav Cov Qauv
Scatter plot graphs yog siv los qhia cov qauv hauv cov ntaub ntawv. Lawv yog cov tshwj xeeb tshaj yog thaum koj muaj ntau cov ntsiab lus ntawm cov ntaub ntawv. Zoo li cov duab kab, lawv tuaj yeem raug siv los ua cov ntaub ntawv khaws tseg los ntawm kev sim ua ke, xws li ua li cas cov chemical reacts hloov qhov kub lossis qhov atmospheric siab.
Whereas kab teeb txuas qhov dots los yog cov ntsiab lus ntawm cov ntaub ntawv los qhia txhua qhov kev hloov, nrog ib lub laj thawj ntawm lub voj voos uas koj kos ib txoj kab "zoo tshaj plaws". Cov ntsiab lus ntawm cov ntaub ntawv tau tawg khiav txog txoj kab. Qhov ze ntawm cov ntsiab lus ntawm cov ntaub ntawv yog rau cov kab zog qhov sib txheeb los sis cov nyhuv ib qho txawv ntawm lwm qhov.
Yog hais tias qhov zoo tshaj plaws haum kab nce ntawm sab laug mus rau sab xis, lub ntsiab lus tawg yog pom qhov zoo sib xws hauv cov ntaub ntawv. Yog hais tias txoj kab txo ntawm sab laug mus rau sab xis, muaj qhov tsis zoo sib xws hauv cov ntaub ntawv.
Combo Charts
Combo charts ua ke ob hom kab kos rau hauv ib qho duab. Feem ntau, cov kab kos ob kab yog ib daim duab kab thiab daim ntawv qhia kab ntawv. Yuav ua kom tiav no, Excel ua rau siv txoj kab thib peb hu ua Y axis secondary, uas sau rau sab xis ntawm daim phiaj.
Cov kab kos duab sib txuas tau tuaj yeem pom nruab nrab hli ntuj kub thiab cov lus xaus los ua ke, tsim cov ntaub ntawv xws li cov khoom tsim tawm thiab cov nqi ntawm cov khoom muag, los sis txhua hli muag thiab qhov nruab nrab txhua hli muag.
Cov duab kos
Cov duab kos los yog cov duab kos yog cov kab kos duab uas siv cov duab los sawv cev cov ntaub ntawv es tsis txhob siv cov xim dawb. Ib lub thaij duab siv pua pua ntawm hamburger cov duab tau tso rau saum toj ntawm lwm qhov los qhia seb muaj pes tsawg calorie ntau ntau ib cheese thiab nqaij npuas qaib hamburger muaj piv rau ib pawg me me ntawm cov duab rau cov kab paj zoo nkauj.
Kev Tshawb Fawb Cov Tshuag Lag Luam
Kev Tshawb Fawb Kev Tshawb Fawb Cov Tshwm Sim qhia cov lus qhia txog cov khoom lag luam lossis cov khoom xws li lawv cov nqi qhib thiab kaw thiab cov nqi ntawm cov khoom pauv thaum lub sijhawm. Nws muaj ntau hom khoom seem muaj nyob hauv Excel. Txhua qhov qhia tawm cov lus sib txawv.
Cov ntawv tshiab ntawm Excel kuj muaj cov kab kos duab, XY Npuas (los yog Scatter ), thiab Radar kab kos.
Muab cov ntawv teev lus hauv Excel
Txoj kev zoo tshaj plaws los kawm txog cov kab kos ntau hauv Excel yog sim lawv tawm.
- Qhib ib qho Excel uas muaj cov ntaub ntawv.
- Xaiv lub qhov koj xav tau los ntawm kev ua haujlwm los ntawm kev ua haujlwm-txhaj los ntawm tus thawj ntawm tes mus rau lub xeem.
- Nias ntawm Insert tab thiab xaiv daim ntawv ntawm lub tshuab raj xa ntawv tuaj.
- Xaiv ib hom ntawm hom ntawv qhia los ntawm cov ntawv qhia zaub mov. Thaum koj ua, Daim Ntawv Chart Tsim tab opens tawm uas qhia cov kev xaiv rau hom kev xaiv uas koj tau xaiv. Ua rau koj xaiv thiab saib daim qauv hauv daim ntawv.
Tej zaum koj yuav tsum tau sim kom paub seb hom twg daim ntawv ua haujlwm zoo tshaj plaws nrog koj cov ntaub ntawv uas koj xaiv, tiam sis koj tuaj yeem saib cov ntawv ntau yam ceev nrooj los pom uas zoo tshaj plaws rau koj.