Yuav Tsim Yeeb Yeeb Thiab Hom Ntawv Pie Daim Ntawv Qhia Rau Hauv Excel

Cov khoom noj qab zib, los yog lub voj voog ua ke thaum lawv paub, siv cov ncuav qab zib kom pom cov feem pua ​​lossis cov txheeb ze ntawm cov ntaub ntawv hauv cov ntawv qhia.

Vim tias lawv pom cov nqi txhim kho, cov khoom noj qab zib muaj txiaj ntsim rau kev qhia tawm cov ntaub ntawv uas qhia txog cov nqi txheeb ze ntawm cov khoom muaj nqi - xws li kev tsim tawm ntawm ib lub koomhaum rau kev tsim tawm ntawm lub tuam txhab tag nrho, lossis cov nyiaj tau los generated los ntawm ib yam khoom txheeb rau qhov muag ntawm tag nrho cov khoom kab.

Lub voj voog ntawm daim ntawv cog paj sib npaug sib npaug 100%. Txhua daim ntawm ncuav qab zib yog raug xa mus ua ib pawg thiab nws me me qhia tau hais tias feem ntawm 100% nws sawv cev.

Tsis zoo li lwm cov kab kos, cov ncuav qab zib muaj qhov tsuas yog ib cov ntaub ntawv tawm , thiab qhov koob no tsis tuaj yeem muaj qhov tsis zoo los yog xoom (0) qhov tseem ceeb.

01 ntawm 06

Qhia Cov Feem Pua nrog Daim Ntawv Qhia Pie

Qhov kev qhia no yog siv cov txheej txheem tsim los tsim thiab muab cov duab kos rau hauv daim duab saum toj no. Daim phiaj qhia tau hais tias cov ntaub ntawv ntsig txog kev muag khoom qab zib rau xyoo 2013.

Cov lus qhia qhia txog ob qho tib si ntawm txhua hom khoom qab zib uas siv cov ntaub ntawv cov ntaub ntawv nrog rau tus nqi sib txig ntawm txhua daim ntawv teev npe ntawm tag nrho cov khoom lag luam rau lub xyoo.

Daim duab tseem qhia txog cov qaub ncaug qaub muag ntawm qhov tawg ntawm daim ntawv pov thawj ntawm lwm tus .

Ib qho lus qhia txog Excel lub ntsiab xim

Excel, zoo li tag nrho Microsoft Office cov kev pabcuam, siv cov ntsiab lus los tsim qhov zoo ntawm nws cov ntaub ntawv.

Lub ntsiab lus siv rau qhov kev qhia no yog lub Office Office ntsiab.

Yog tias koj siv lwm lub ntsiab lus thaum ua raws li qhov kev qhia no, cov xim uas teev rau hauv cov kauj ruam kev qhia kuj yuav tsis muaj nyob rau hauv lub ntsiab lus uas koj siv. Yog hais tias tsis yog, cia li xaiv cov xim rau koj li kev hloov chaw thiab kev ua haujlwm. Kawm seb yuav ua li cas los xyuas thiab hloov cov ntsiab lus hauv phau ntawv no .

02 ntawm 06

Pib Pie Chie

Nkag Mus thiab Xaiv Cov Ntaub Ntawv Qhia Tawm

Nkag mus rau hauv cov ntawv qhia cov ntaub ntawv yeej yog thawj kauj ruam hauv kev tsim cov ntawv qhia - tsis muaj teeb meem dab tsi ntawm cov ntawv sau.

Cov kauj ruam thib ob yog qhov tseem ceeb ntawm cov ntaub ntawv siv los tsim cov ntawv qhia.

1. Sau cov ntaub ntawv uas tau muab teev rau hauv daim duab saum toj no rau hauv cov nplooj ntawv ua haujlwm tseeb.
2. Thaum nkag, qhia ntau txog cov hlwb ntawm A3 rau B6.

Tsim Tsa Pie Daim Ntawv Qhia Txog

Cov kauj ruam hauv qab no yuav tsim ib daim ntawv pov thawj yooj yim - ib daim ntawv dawb, tsis muaj qauv - uas qhia txog plaub yam ntawm cov ntaub ntawv, cov lus dab neeg, thiab lub npe ntawv pov thawj.

Tom qab ntawd, qee qhov kev hloov ntau tshaj yog siv los hloov cov ntawv qhia yooj yim kom phim raws li tau qhia nyob rau phab 1 ntawm phau ntawv no.

1. Nias rau ntawm daim ntxig ntawm daim ntawv sau .
2. Nyob hauv lub thawv ntawv ntawm txoj kab, nyem rau ntawm Daim Pie Chart icon qhib lub npe ntawm cov ntawv muaj hom.
3. Hover koj tus pointer nas hla ib hom ntawv coj los nyeem cov lus piav qhia ntawm daim phiaj.
4. Nias ntawm 3-D Ncuav Ncuav Qab Zo mus xaiv peb daim duab ncuav qab zib thiab ntxiv rau daim ntawv sau.

Muab Daim Ntawv Chart Ntxiv

Kho kom raug lub npe Chart Title los txhaj rau nws ob zaug tab sis tsis txhob muab ob npaug rau.

1. Nias ib zaug rau ntawm lub npe hu ua nws xaiv - ib lub thawv yuav tsum tshwm nyob ib ncig ntawm cov lus ntawm Daim Ntawv Chart.
2. Nyem ib zaug thib ob los muab cov Excel hloov kho hom , uas tso tus cursor hauv lub npov lub npe.
3. Rho tawm cov qauv ntawv siv lub Delete / Backspace tuav ntawm cov keyboard.
4. Nkag mus rau lub npe ntawm daim ntawv sau npe - Cov Khw Muag Khoom Khw 2013 ntawm Kev Muag Khoom - rau hauv lub thawv rau npe.
5. Muab tus cursor ntawm 2013 thiab Revenue nyob rau hauv lub npe thiab nias tus Sau yuam rau ntawm cov keyboard kom cais lub npe ntawm ob kab.

03 ntawm 06

Muab Cov Ntawv Sau Ntxiv Rau Daim Ntawv Qhia Rau Khoom Noj

Muaj ntau ntau qhov sib txawv rau hauv daim chart hauv Excel - xws li daim duab thaj chaw uas muaj lub ncuav qab zib uas muaj cov qauv ntawv xaiv, cov lus dab neeg, thiab cov ntawv qhia thiab cov ntawv sau.

Tag nrho cov seem no yog xam lwm yam khoom los ntawm qhov kev zov me nyuam, thiab, li ntawd, txhua tus tuaj yeem cais nyias. Koj qhia rau Excel uas yog ib feem ntawm daim duab uas koj xav kom tau los ntawm kev txhaj tshuaj nrog tus pointer pointer.

Hauv cov kauj ruam nram qab no, yog tias koj cov qhabnias tsis zoo li cov teev nyob rau hauv kev nyeem, nws yuav yog qhov koj tsis muaj feem ntawm txoj cai xaiv thaum koj ntxiv qhov kev xaiv cov kev xaiv.

Qhov feem ntau ua yuam kev yog txhaj rau thaj tsam ntawm lub cheeb tsam ntawm qhov kev teeb tsa thaum lub tswv yim yuav xaiv tag nrho cov ntawv qhia.

Qhov yoojyim tshaj los xaiv tag nrho cov ntawv qhia yog mus nyem rau ntawm sab laug sab laug los yog sab xis ntawm lub npe ntawv.

Yog hais tias muaj qhov yuam kev, nws tuaj yeem kho sai siv tus Excel lub undo feature kom tshem tawm qhov yuam kev. Tom qab ntawd, nyem rau ntawm sab xis ntawm daim qauv thiab sim dua.

Muab cov ntawv sau ntxiv

1. Nyem ib zaug ntawm daim ntawv ncuav nyob hauv cheeb tsam thaj av los xaiv nws.
2. Txoj cai-nias rau ntawm daim chart qhia qhib cov ntsiab lus teb cov lus qhia hauv cov ntawv qhia.
3. Nyob rau hauv cov ntawv qhia zaub mov, hover nas saum toj ntawm Add Data Labels xaiv qhib ob lub ntsiab lus teb ntsiab lus teb.
4. Hauv cov ntawv qhia zaub mov thib ob, nias rau Ntxiv Cov Ntawv Sau Ntxiv cov khoom siv ntxiv rau txhua qhov khoom qab zib - rau txhua daim ncuav qab zib hauv daim phiaj.

Muab Daim Ntawv Qhia Cov Lus Qhia

Hauv ib lub neej yav tom ntej, cov npe ntawm npe yuav muab ntxiv rau cov ntawv teev lus nrog rau cov nqi tseem ceeb tshwm sim, yog li ntawd, cov lus dab neeg hauv qab daim ntawv qhia tsis tas thiab yuav muab deleted.

1. Nyem ib zaug ntawm cov lus dab neeg hauv qab ntawm thaj chaw ua si xaiv nws.
2. Nias qhov rho tawm qhov tseem ceeb ntawm cov keyboard kom tshem tawm cov lus dab neeg.

Nyob rau ntawm no, koj daim duab yuav tsum zoo li tus qauv uas tau pom hauv daim duab saum toj no.

04 ntawm 06

Hloov Xim ntawm Hom ntawv Tab

Thaum ib daim ntawv teev lus hauv Excel, lossis thaum twg ib daim ntawv xaiv ntsej xaiv raug xaiv los ntawm txhaj rau nws, ob qho ntxiv tabs ntxiv rau qhov xov raws li pom hauv daim duab saum toj no.

Cov Chart Tools tab - tsim thiab hom ntawv - muaj cov kev teeb tsa thiab kev xaiv qhov tshwj xeeb rau cov kab kos, thiab lawv yuav siv rau cov kauj ruam nram qab no los teeb cov khoom noj qab zib.

Hloov cov xim ntawm lub Ncuav Ncuav Qab Zib

1. Nias ntawm daim duab qhia tom qab xaiv tag nrho cov ntawv qhia.
2. nyem rau ntawm Kev Hloov Xim Xaiv nyob rau ntawm sab laug sab ntawm Tus Tsim Cov Ntawv ntawm cov ntawv sau kom qhib lub npe ntawm cov xim xaiv.
3. Hover koj tus nas pointer dua txhua kab ntawm cov xim kom pom lub npe xaiv.
4. Nias rau ntawm Xaiv 5 qhov kev xaiv - qhov kev xaiv thawj zaug nyob rau hauv seem Monochromatic ntawm daim ntawv.
5. Plaub lub ncuav ntawm qhov khoom noj nyob hauv daim phiaj yuav tsum hloov mus rau qhov txawv txav ntawm xiav.

Hloov Cov Daim Ntawv Cheeb Tsam Xim

Rau cov kauj ruam tshwj xeeb no, formatting tom qab yog txheej txheem ob-kauj ruam vim tias qhov gradient muab ntxiv los qhia cov kev hloov me ntsis ntawm xim ntawm sab saum toj mus rau hauv qab hauv daim duab.

1. Ndliv lub keeb kwm yav dhau los xaiv tag nrho cov ntawv qhia.
2. Nias rau ntawm Hom ntawv ntawm daim qauv.
3. Nias rau ntawm Daim Phiaj Xaiv kom qhib qhov Filling Colors drop down panel.
4. Xaiv Blue, Accent 5, Darker 50% ntawm lub ntsiab lus xim ntawm lub vaj huam sib luag los hloov daim phiaj xim tom qab xim tsaus nti.
5. Nias ntawm Daim Phiaj Xaiv qhov thib ob zaug qhib lub Xaiv cov xim ntawm qhov nco qab.
6. Hover tus nas pointer dua Gradient xaiv nyob ze ntawm qab ntawm daim ntawv qhib lub Gradient vaj huam sib luag.
7. Hauv seem tsaus nti , nyem rau ntawm qhov Kev Tawm Tsav Xwm kom ntxiv qhov gradient uas tau nce zuj zus ib qho zuj zus los ntawm qab mus rau saum toj.

Hloov Cov Ntawv Xim

Tam sim no hais tias keeb kwm yav dhau yog xiav xiav, lub neej ntawd dub dub yog tshwm sim. Qhov seem tom ntej no hloov cov xim ntawm tag nrho cov ntawv nyeem hauv daim duab qhia dawb

1. Ndliv lub keeb kwm yav dhau los xaiv tag nrho cov ntawv qhia.
2. Nias rau ntawm Hom Txheej ntawm txoj kab yog tsim nyog.
3. Nias rau ntawm Daim Ntawv Sau Ntawv los qhib cov Ntawv Xim Sau Ncauj Lus.
4. Xaiv Dawb, Tom Qab 1 ntawm Xam Xim ntawm cov npe.
5. Tag nrho cov ntawv nyeem nyob rau hauv lub npe thiab cov ntaub ntawv cov ntawv yuav tsum hloov mus dawb.

05 ntawm 06

Ntxiv Qib Npe thiab Tsav Daim Ntawv Qhia

Ob peb kauj ruam tom qab ntawm kev nyeem ntawv siv qhov kev ua hauj lwm pane formatting , uas muaj feem ntau ntawm cov kev xaiv formatting rau cov kab kos.

Nyob hauv Excel 2013, thaum qhib txais, cov pane tshwm nyob rau ntawm sab tes xis ntawm daim Excel raws li muaj nyob hauv daim duab saum toj no. Cov nqe lus thiab cov hau kev xaiv hauv pane hloov nyob ntawm cheeb tsam ntawm daim ntawv teev lus xaiv tau.

Ntxiv Qib Npe thiab Tshawb Cov Ntawv Sau Npe

Cov kauj ruam no yuav ntxiv lub npe ntawm txhua hom khoom qab zib rau cov ntawv teev lus nrog rau lub kaus mom nqe yog tam sim no tso tawm. Nws tseem yuav xyuas kom meej tias cov ntawv cov ntaub ntawv tau muab teev rau hauv daim phiaj qhia ntawv thiaj li yuav tsis muaj cov thawj coj sib txuas rau cov ntawv sau rau nws daim ntawv qhia cov khoom noj qab zib.

1. Nyem ib zaug ntawm ib qho ntawm cov ntawv sau rau hauv daim qauv - tag nrho plaub daim ntawv teev lus hauv daim ntawv yuav tsum raug xaiv.
2. Nias rau ntawm Hom Txheej ntawm txoj kab yog tsim nyog.
3. Nias rau ntawm Kev Xaiv Npe Xaiv rau sab laug ntawm txoj kab ntawv kom qhib lub Formatting Task pane ntawm sab xis ntawm lub vijtsam.
4. Yog tias tsim nyog, nias ntawm qhov kev xaiv icon hauv pane qhib cov ntawv xaiv lus qhia raws li muaj nyob hauv daim duab saum toj no.
5. Nyob rau hauv daim ntawv lo ntawm daim ntawv teev npe, ntxiv ib qho cim kos rau lub Npe Lub Npe xaiv saib cov npe cookie thiab cov nqi muag khoom, thiab tshem tawm lub cim kos npe los ntawm Show Lead Lines .
6. Hauv qab ntawm Daim Ntawv Qhia Txog Cov Hauj Lwm ntawm daim ntawv, nias ntawm Sab kawg ntawm kom tshem tag nrho plaub daim ntawv teev npe rau sab nraud ntawm lawv cov seem hauv cov ntawv qhia.

Muab cov Khoom Pie rau nws X thiab Y Axes

Cov kauj ruam tom qab kawg yuav ua kom luag los yog tawg ntawm lub txiv qaub hla tawm ntawm qhov ncuav qab zib kom ntxiv rau nws. Tam sim no, nws nyob hauv qab daim ntawv teev npe, thiab nws tabtom tawm thaum nyob rau hauv qhov chaw no yuav muaj kev cuam tshuam rau hauv lub npe.

Muab cov duab kos rau ntawm X axis - khij qhov qhia nyob ib ncig ntawm lub lemon slice yog taw mus rau sab qab ces kaum ntawm daim ntawv qhia - yuav muaj chaw txaus kom tawg tawm ntawm qhov seem ntawm daim npav.

Kev hloov daim ntawv ntawm Y axis yuav rub lub ntsej muag ntawm cov ntawv qhia kom nws yooj yim nyeem cov ntawv sau rau ntawm lub ncuav qab zib nyob rau saum toj ntawm daim duab.

Nrog rau Formatting Task Pane qhib:

1. Nyem ib zaug hauv daim duab qhia tom qab xaiv tag nrho cov ntawv qhia.
2. Nias rau ntawm cov teebmeem hauv pane los qhib cov npe ntawm cov nyhuv xaiv.
3. Nias ntawm 3-D Kev Hloov Teb rau hauv daim ntawv txhawm rau saib cov kev xaiv muaj.
4. Teem X X Xya mus rau 170 ^o mus spin daim ntawv qhia kom lub txiv qaub hlais tig rau sab qab ces kaum ntawm daim phiaj.
5. Teem lub Y Yim mus rau 40 ^o los rub lub ntsej muag ntawm daim qauv.

06 ntawm 06

Hloov Cov Qauv Ntaus Nres thiab Tshaj Plaub Ib Daim Ntawv Qhia ntawm Daim Ntawv Qhia

Hloov qhov loj thiab hom ntawv siv nyob rau hauv daim phiaj qhia, yuav tsis tsuas yog kev txhim kho cov qauv siv nyob rau hauv daim ntawv qhia, tab sis nws tseem yuav ua kom yooj yim nyeem cov npe thiab cov ntaub ntawv tseem ceeb hauv daim phiaj.

Lus Cim : Qhov luaj li cas ntawm cov font yog ntsuas hauv cov ntsiab lus - lub sij hawm luv luv rau pt .
72 pt ntawv yog sib npaug rau ib nti - 2.5 cm - loj.

1. Nyem ib zaug hauv daim ntawv qhia lub npe xaiv nws.
2. Nias rau ntawm lub tsev tab ntawm txoj hlua.
3. Nyob rau hauv seem ntawm daim ntawv ntawm txoj kab, nyem rau ntawm Lub Thawv Sau ntawv kom qhib lub npe ntawm cov ntawv sau tseg.
4. Tshem mus nrhiav thiab nyem rau ntawm daim font Britannic Bold nyob rau hauv daim ntawv teev cov npe ntawm daim ntawv no.
5. Nyob rau hauv lub thawv ntawv loj ntawm lub npov ntawm lub thawv ntawv, muab lub npe ntawv loj rau 18 pt.
6. Nyem ib zaug ntawm cov ntaub ntawv hauv daim ntawv xaiv los xaiv tag nrho plaub phau ntawv.
7. Siv cov kauj ruam saum toj no, teev cov ntawv sau rau 12 pt Britannic Bold.

Tawm ib Daim ntawm Daim Pie Che

Qhov kev ua si dhau los no yog ua kom luag los yog tawg ntawm lub txiv qaub hla tawm ntawm lub ncuav mus so ntxiv rau nws.

Tom qab tau tawg tawm lub txiv qaub , daim ntawv so ntawm lub ncuav yuav ua rau me me kom haum qhov kev hloov. Yog li ntawd, nws yuav tsum rov qab los ua ib qho los yog ntau dua ntawm cov ntawv teev lus sau tseg rau hauv lawv cov seem.

1. Nyem ib zaug ntawm daim ntawv ncuav nyob hauv cheeb tsam thaj av los xaiv nws.
2. Nyem ib zaug rau ntawm lub txiv kab ntxwv ntawm daim ntawv ncuav qab zib kom tau xaiv qhov seem ntawm daim phiaj qhia - nco ntsoov tias tsuas yog cov txiv qaub daim diav yog ncig los ntawm lub me me xiav highlight dots.
3. Nyem thiab luag cov txiv qaub hlais tawm ntawm daim ntawv cog paj rau nws tawg.
4. Yuav kom rov qab muab cov ntaub ntawv sau tseg, nyem ib zaug ntawm cov ntawv qhia - tag nrho cov ntawv sau yuav tsum raug xaiv.
5. Nyem ib zaug ntxiv nyob rau ntawm daim ntawv lo qhia kom tau txav thiab cab nws mus rau qhov chaw txaus siab.

Nyob rau ntawm lub sij hawm no, yog tias koj tau ua raws li tag nrho cov kauj ruam hauv phau ntawv no, koj daim ntawv yuav tsum piv rau tus qauv nyob hauv nplooj ntawv 1 ntawm kev nyeem.