Excel muaj ob peb txoj kev xaiv ntxiv rau kev hais txog kev khej lossis daim nplaum ntawm daim ntawv pov thawj uas tsis sib hloov lossis hloov cov ntaub ntawv. Cov no suav nrog:
- ntuag lossis rub tawm cov ntawv xaiv los ntawm tus so ntawm lub pas dej;
- tsom ib lossis ntau dua qhov uas siv lub ncuav pov thawj ntawm lub ncuav qab zib ;
- tsom ib los sis ntau dua siv lub Bar Pie chart.
Tshawb tawm ib daim ntawv pov thawj ntawm lub ncuav
Ntxiv rau qhov tseem ceeb ntawm ib daim ntawv qhia khoom noj qab zib koj tuaj yeem txav los yog "tawg" no daim ntawv tawm ntawm tag nrho daim ntawv qhia raws li pom hauv sab laug ntawm daim duab saum toj no.
Ua li no:
- Nyem ib zaug nrog tus nas pointer ntawm thaj tsam thaj av ntawm daim ntawv ncuav qab zib kom pom tseeb nws - lub voj voog me me los yog cov dots yuav tsum pom ib ncig ntawm sab ntug ntawm lub pas dej;
- Nyem thib ob zaug ntawm daim hlais kom tawg;
- Cov pob zeb yuav tsum tam sim no nyob ib puag ncig ntawm ib qho ncuav nkaus xwb ntawm lub ncuav qab zib - nrog rau ib qho chaw nyob nruab nrab hauv daim phiaj xwm;
- Nyem thiab luag nrog tus nas pointer ntawm cov lus xaiv ntawm lub ncuav, rub tawm los yog tawg tawm ntawm qhov seem ntawm daim ntawv qhia;
- Tshem tawm lub pob tawg tuaj rau nws qhov chaw qub, siv Excel lub undo feature yog tias ua tau;
- Yog tsis yog, rov ua dua cov kauj ruam 1 thiab 2 saum toj no thiab mam li rub tus nplais rov qab rau lub ncuav. Nws yuav cia li rov mus rau qhov chaw qub.
Piav tas nrho lub ncuav qab zib
Yog hais tias tag nrho cov ntawv nyob hauv daim nplaim ces nws txhais tau hais tias koj tsis tau xaiv ib zaug xwb. Txhawm rau kho qhov no, rub lub slices rov qab ua ke thiab sim cov kauj ruam 2 thiab 3 dua.
Khoom noj qab zib ntawm lub ncuav thiab Bar Cov Ncuav Qab Zib Cuav
Ib qho ntxiv rau kev ntxiv kev txhawb zog rau qee qhov chaw ntawm daim ntawv qhia khoom noj qab zib yog siv lub ncuav pov tseg ntawm lub ncuav los yog lub ncuav ntawm lub ncuav qab zib es tsis txhob muaj daim ntawv pov thawj li niaj zaus.
Yog tias koj muaj ib los yog ob lub pob loj dua uas muaj cov khoom qab zib muaj peev xwm pom, ua kom pom cov ntsiab lus me me, hloov mus rau ib qho ntawm ob hom kev sau ntawv, uas hais txog cov ntawv me me nyob rau hauv ib daim ntawv qhia theem ob - los yog daim ntawv teev qhia teeb meem, qhov xaiv yog koj li.
Tshwj tsis yog hloov lawm, Excel yuav cia nrog peb cov lus tshaj tawm me me ( cov ntsiab lus ntawm cov ntaub ntawv ) hauv lub thawv ntim khoom nruab nrab los yog cov ntawv teeb tseg.
Los tsim ib lub ncuav qab zib ntawm lub ncuav los yog lub ncuav ntawm lub ncuav qab zib:
- Tshawb taw qhov ntau ntawm cov ntaub ntawv muab siv rau hauv daim ntawv qhia;
- Nias rau ntawm Insert tab ntawm txoj kab ;
- Hauv daim npav kab ntawv ntawm txoj kab, nyem rau ntawm Daim Pie Che diav los qhib lub tshuab raj ntawm cov ntawv muaj;
- Hover koj tus pointer nas hla ib hom ntawv coj los nyeem cov lus piav qhia ntawm daim phiaj xwm;
- Nias ntawm lub ncuav qab zib ntawm lub ncuav los yog lub ncuav ntawm lub ncuav qab zib nyob hauv 2-D Ncuav Qab Zib seem ntawm txoj kev tuaj yeem siv cov ntawv sau rau daim ntawv sau.
Lus Cim: Daim qauv qhia sab laug yeej ib txwm muaj lub ntsiab lus qhia, nrog daim ntawv qhia theem ob tuaj ntawm nws sab xis. Kev kho no tsis tuaj yeem hloov tau.
Hloov Poob Hom
Hloov los ntawm ib daim ntawv pov thawj uas niaj hnub ua rau ib lub ncuav los ntawm cov khoom noj los yog lub ncuav ntawm daim ntawv sau qhia:
- Txoj cai-nias lub thawv tam sim no los qhib lub ntsiab lus teb cov ntawv qhia;
- Nyob rau hauv cov ntawv qhia, nias ntawm Hloov Poob Hom qhib qhib Chart Hom dialog box;
- Hauv lub thawv ntawv, nyem rau ntawm Tag nrho Cov Ntaus ;
- Nias ntawm lub ncuav qab zib nyob rau sab laug pane, ces nias rau ntawm lub ncuav qab zib lossis Pie Bar ntawm Pie rau ntawm txoj cai pane rau ntawm lub box.
Hloov Cov Piav Qhia Cov Ntsiab Lus
Txhawm rau pauv cov ntsiab lus ntawm cov ntaub ntawv (slices) nyob rau hauv daim ntawv qhia theem nrab:
- Txoj cai-nias ntawm lwm daim ntawv nyob rau hauv daim ntawv (cov ntaub ntawv siv los tsim daim qauv qhia ntawv) qhib lub Hom Piav Cov Ntawv Teev Npe ;
- Hauv lub pane, nias ntawm qhov xub hauv qab ntawm Split Series Los ntawm kev xaiv.
Cov kev xaiv hais txog kev pauv cov xov xwm ntawm cov ntsiab lus hauv cov ntawv qhia theem siab yog:
- Faib lub koob los ntawm Txoj Haujlwm : hauv qhov tseem ceeb hauv ob lub thauv thaj tsam , nkag mus rau cov haujlwm ntawm cov haujlwm lossis cov kab xees uas tshwm nyob rau hauv daim ntawv qhia theem nrab - 3 yam tsawg;
- Faib cov koob ntawm Kev Ntsuas : hauv qhov tseem ceeb tsawg dua ntawm lub npov, sau tus naj npawb uas loj dua tus nqi tsawg tshaj plaws uas tau muab teev cia rau hauv daim ntawv qhia theem ob;
- Faib cov lej ntawm feem pua : hauv qhov tseem ceeb dua lub thawv, nkag mus rau ib qho ntawm feem pua ntawm 0% thiab 100% - qhov no muaj feem cuam tshuam txog feem pua ntawm cov ntawv qhia dav dav tus nqi tag nrho uas yuav tshwm nyob rau hauv daim ntawv qhia theem ob.