Microsoft Excel cov ntawv nthuav qhia ua haujlwm tau zoo, tsim cov kab kos thiab kab kos los ntawm cov ntaub ntawv xaiv. Koj tuaj yeem ua daim duab hauv Excel 2010 txhawm rau ua kom muaj txiaj ntsig zoo ntawm koj cov ntawv tshaj tawm.
Cov kauj ruam
Qauv Qauv
Qauv Daim Qauv Ncauj Lus Txog Khoom Noj
Txhawb wikiHow thiab qhib tag nrho cov qauv.
Qauv Khau Loj Histogram
Txhawb wikiHow thiab qhib tag nrho cov qauv.
Qauv Gantt Chart
Txhawb wikiHow thiab qhib tag nrho cov qauv.
Ntu 1 ntawm 3: Sau Cov Ntaub Ntawv
Kauj Ruam 1. Qhib koj li Excel 2010 program
Kauj Ruam 2. Nyem rau ntawm File menu kom qhib daim ntawv teev npe uas twb muaj lawm lossis pib daim ntawv tshiab
Kauj Ruam 3. Sau cov ntaub ntawv
Kev ntaus hauv cov ntawv xov xwm xav kom koj npaj koj cov ntaub ntawv. Rau cov neeg feem coob, koj yuav nkag mus rau cov khoom hauv thawj kab, Kab A, thiab nkag mus rau qhov hloov pauv rau txhua tus neeg cov khoom hauv kab hauv qab no.
- Piv txwv li, yog tias koj tab tom sib piv cov txiaj ntsig kev muag khoom ntawm qee tus neeg, cov neeg yuav raug teev nyob rau hauv Kab A, thaum lawv cov txiaj ntsig kev muag khoom txhua lub hlis, peb lub hlis twg thiab txhua xyoo tuaj yeem teev nyob hauv kab hauv qab no.
- Nco ntsoov tias nyob rau feem ntau kab kos lossis kab duab, cov ntaub ntawv hauv Kab A yuav raug teev nyob rau ntawm x axis, lossis kab rov tav. Txawm li cas los xij, nyob rau hauv cov ntaub ntawv ntawm kab kab, cov ntaub ntawv tus kheej tau sib xws rau y axis, lossis ntsug axis.
Kauj Ruam 4. Siv cov qauv
Xav txog tag nrho koj cov ntaub ntawv hauv kab kawg thiab/lossis kab kawg. Qhov no yog qhov tseem ceeb yog tias koj siv daim ntawv qhia ncuav qab zib uas xav tau feem pua.
Txhawm rau nkag mus rau tus lej hauv Excel, koj qhia cov ntaub ntawv hauv kab lossis kab. Tom qab ntawd, koj nyem rau ntawm Function, fx, khawm thiab xaiv hom mis, xws li cov lej
Kauj Ruam 5. Ntaus lub npe rau daim ntawv nthuav qhia/kab ntawv siv thawj kab
Siv cov npe hauv kab thib ob thiab kab lus piav qhia koj cov ntaub ntawv.
- Cov npe yuav raug xa mus rau kab ntawv thaum koj tsim nws.
- Koj tuaj yeem nkag koj cov ntaub ntawv thiab cov npe hauv txhua ntu ntawm daim ntawv nthuav tawm. Yog tias koj tab tom ua daim duab thawj zaug, koj yuav tsum mob siab khaws cov ntaub ntawv hauv thaj chaw me me yog li nws yooj yim los ua haujlwm nrog.
Kauj Ruam 6. Khaws koj daim ntawv nthuav tawm ua ntej txuas ntxiv
Ntu 2 ntawm 3: Ntxig Koj Daim Duab
Kauj Ruam 1. Qhia cov ntaub ntawv uas koj nyuam qhuav nkag mus
Luag koj tus cursor los ntawm sab saud sab laug mus rau hauv qab txoj cai kaum ntawm cov ntaub ntawv.
- Yog tias koj xav tau kab lus yooj yim piav qhia tsuas yog 1 cov ntaub ntawv, koj yuav tsum tsuas yog hais qhia cov ntaub ntawv hauv thawj kab ntawv thiab kab lus thib ob.
- Yog tias koj xav ua daim duab nrog ntau qhov sib txawv los qhia txog kev hloov pauv, qhia txog ntau yam sib txawv.
- Nco ntsoov tias koj hais qhia lub ntsiab lus hauv Excel 2010 daim ntawv nthuav qhia.
Kauj Ruam 2. Xaiv Insert tab nyob rau sab saum toj ntawm nplooj ntawv
Hauv Excel 2010, Insert tab yog nyob nruab nrab ntawm Tsev thiab Nplooj Ntawv Txheej Txheem tab.
Kauj Ruam 3. Nyem rau “Charts
” Cov duab thiab kab kos ob qho tib si muaj nyob hauv ntu no thiab tau siv me ntsis sib pauv raws li pom kev sawv cev ntawm cov ntaub ntawv nthuav tawm.
Kauj Ruam 4. Xaiv hom kab kos lossis kab kos
Txhua hom muaj lub cim me me nyob ib sab ntawm nws piav qhia tias nws yuav zoo li cas.
Koj tuaj yeem rov qab mus rau daim ntawv qhia zaub mov no kom xaiv qhov kev xaiv sib txawv ntev li ntev tau hais txog kab teeb
Kauj Ruam 5. Hover koj tus nas hla kab ntawv
Right -click nrog koj tus nas thiab xaiv "Format Plot Area."
- Scroll los ntawm kev xaiv hauv kab sab laug, xws li ciam teb, sau, 3-D, ci thiab duab ntxoov ntxoo.
- Hloov kho qhov zoo ntawm daim duab los ntawm kev xaiv xim thiab ntxoov ntxoo raws li koj nyiam.
Ntu 3 ntawm 3: Xaiv Koj Hom Duab
Kauj Ruam 1. Ntxig kab duab kab, yog tias koj tab tom sib piv ntau yam khoom sib cuam tshuam nrog ob peb yam sib txawv
Cov kab rau txhua qhov khoom tuaj yeem ua pawg los yog pawg nyob ntawm seb koj xav sib piv qhov sib txawv li cas.
- Txhua yam ntawm daim ntawv nthuav tawm tau teev tseg cais hauv ib kab nkaus xwb. Tsis muaj kab txuas lawv.
- Yog tias koj siv peb tus piv txwv yav dhau los nrog kev muag khoom txhua lub hlis, peb lub hlis thiab ib xyoos, koj tuaj yeem tsim kab sib txawv hauv cov xim sib txawv rau txhua tus neeg. Koj tuaj yeem xaiv seb puas muaj cov tuav tuav ib sab lossis muab tso rau hauv ib qho bar.
Kauj Ruam 2. Xaiv kab kab
Yog tias koj xav npaj cov ntaub ntawv dhau sijhawm, qhov no yog txoj hauv kev zoo tshaj plaws los qhia seb cov ntaub ntawv hloov pauv li cas, xws li hauv hnub, lub lis piam lossis xyoo.
Txhua daim ntawv ntawm koj cov ntawv yuav yog tus lej ntawm koj kab kab. Cov kab yuav txuas cov dots no los qhia kev hloov pauv
Kauj Ruam 3. Xaiv daim duab uas tawg
Hom kab ntawv no zoo ib yam li kab duab kab vim nws npaj cov ntaub ntawv ntawm x/y axis. Koj tuaj yeem xaiv tawm ntawm cov ntsiab lus cov ntaub ntawv tsis txuas nrog hauv cov cim ua kom tawg lossis txuas lawv nrog txoj kab ncaj lossis ncaj.
Cov kab ntawv tawg yog qhov zoo tshaj plaws rau kev npaj ntau yam sib txawv ntawm tib daim duab, tso cai rau txoj kab ncaj lossis ncaj kom sib tshuam. Koj tuaj yeem yooj yim qhia kev hloov pauv hauv cov ntaub ntawv
Kauj Ruam 4. Xaiv rau daim duab
Cov kab ntawv saum npoo yog qhov zoo rau kev sib piv 2 pawg ntawm cov ntaub ntawv, cov duab kab hauv cheeb tsam qhia kev hloov pauv hauv qhov ntau thiab cov duab ncuav qab zib qhia feem pua ntawm cov ntaub ntawv.