Yuav Paub
- Xaiv cov ntaub ntawv thiab mus rau Insert > Insert Pie Chart > xaiv kab ntawv hom.
- Tom qab ntxiv daim ntawv ncuav qab zib, koj tuaj yeem ntxiv daim ntawv teev npe, ntxiv cov ntawv sau, thiab hloov xim.
Kab lus no piav qhia yuav ua li cas ua daim ntawv ncuav qab zib hauv Excel rau Microsoft 365, Excel 2019, 2016, 2013, thiab 2010.
Nkag mus thiab xaiv cov ntaub ntawv qhia
Daim ntawv ncuav qab zib yog qhov pom kev pom ntawm cov ntaub ntawv thiab siv los tso saib cov nyiaj ntawm ntau pawg txheeb ze rau tag nrho cov nqi ntawm txhua pawg. Daim duab ncuav qab zib yog siv, piv txwv li, los qhia txog kev tsim khoom ntawm ib lub Hoobkas cuam tshuam nrog cov khoom tsim tawm los ntawm lub tuam txhab lossis qhia cov nyiaj tau los ntawm ib qho khoom lag luam txheeb ze rau kev muag khoom ntawm tag nrho cov khoom kab.
Ua ntej koj tsim ib daim ntawv qhia ncuav qab zib, sau cov ntaub ntawv qhia. Tom qab ntawd, taw qhia cov ntaub ntawv koj xav siv hauv daim ntawv qhia ncuav qab zib.
Ua raws li cov lus qhia no, nkag mus rau cov ntaub ntawv qhia hauv daim duab saum toj no rau hauv daim ntawv ua haujlwm dawb.
Create the Basic Pie Chart
Daim ntawv qhia ncuav qab zib yooj yim yog daim ntawv qhia yooj yim, tsis muaj ntaub ntawv uas qhia txog pawg ntawm cov ntaub ntawv, lus dab neeg, thiab lub npe daim ntawv teev npe.
Txhawm rau tsim daim ntawv qhia ncuav qab zib, taw qhia cov ntaub ntawv hauv hlwb A3 txog B6 thiab ua raws li cov lus qhia no:
-
Nyob rau ntawm kab, mus rau Insert tab.
-
Xaiv Insert Pie Chart los tso saib hom ntawv ncuav qab zib muaj.
-
Hover dua ib hom kab ntawv nyeem cov lus piav qhia ntawm daim ntawv qhia thiab saib ua ntej daim ntawv ncuav qab zib.
- Xaiv hom kab kos. Piv txwv li, xaiv 3-D Pie txhawm rau ntxiv daim duab peb sab rau daim ntawv ua haujlwm.
Add the Chart Title
Kho kom raug lub npe daim ntawv teev npe ntxiv kom haum ib qho ntxiv.
- Xaiv lub npe ntawm daim ntawv teev npe. Ib lub thawv tshwm nyob ib ncig ntawm lub npe.
-
Nias rau ntawm cov ntawv los tso Excel hauv hom hloov kho thiab tso tus cursor rau hauv lub thawv npe.
- nias Delete or Backspace txhawm rau rho tawm cov ntawv uas twb muaj lawm.
-
Tau ib daim ntawv teev npe. Piv txwv li, ntaus Lub Khw Muag Khoom Qab Zib 2018 Cov Nyiaj Tau Los ntawm Muag.
- Txhawm rau cais lub npe ua ob kab, tso tus cursor ntawm ob lo lus thiab nias Enter. Piv txwv li, tso tus cursor ntawm 2018 thiab Revenue.
Ntxiv cov ntawv sau rau daim ntawv Pie
Muaj ntau qhov sib txawv rau daim ntawv qhia hauv Excel, xws li thaj chaw thaj chaw uas muaj daim ntawv ncuav qab zib sawv cev rau cov ntaub ntawv xaiv, cov lus dab neeg, thiab daim ntawv teev npe thiab cov ntawv sau. Tag nrho cov khoom no yog cov khoom sib cais, thiab txhua qhov tuaj yeem muab faib ua ke. Txhawm rau qhia Excel qhov twg ntawm daim ntawv koj xav ua, xaiv nws.
Yog tias koj tsis tau txais cov txiaj ntsig xav tau, qhov yog ntawm daim ntawv tsis raug xaiv. Ib qho yuam kev feem ntau yog xaiv thaj chaw hauv nruab nrab ntawm daim ntawv qhia thaum lub hom phiaj yog xaiv tag nrho daim ntawv. Txoj kev yooj yim tshaj plaws los xaiv tag nrho daim ntawv yog xaiv ib lub ces kaum ntawm daim ntawv.
Yog tias koj ua yuam kev, siv Excel undo feature kom tshem tawm qhov yuam kev. Tom qab ntawd, xaiv qhov yog ntawm daim ntawv qhia thiab sim dua.
Txhawm rau ntxiv cov ntawv sau rau daim ntawv ncuav qab zib:
- Xaiv thaj tsam ntawm daim ntawv ncuav qab zib.
-
Right-click the chart.
-
Xaiv Ntxiv cov ntaub ntawv sau npe.
- Xaiv Add Data Labels. Hauv qhov piv txwv no, kev muag khoom rau txhua lub ncuav qab zib yog ntxiv rau cov hlais ntawm daim ntawv ncuav qab zib.
Hloov Xim
Thaum daim duab tsim nyob rau hauv Excel, lossis thaum twg ib daim duab uas twb muaj lawm raug xaiv, ob lub tab ntxiv ntxiv rau ntawm kab. Cov cuab yeej Chart tabs, Tsim thiab Hom, muaj cov kev xaiv tsim thiab layout tshwj xeeb rau cov kab kos.
Txhawm rau hloov xim ntawm cov hlais, keeb kwm yav dhau los, lossis ntawv:
-
Xaiv ib cheeb tsam ntawm daim duab keeb kwm yav dhau los xaiv tag nrho daim ntawv ncuav qab zib.
-
Txhawm rau hloov cov xim ntawm daim ntawv ncuav qab zib, mus rau Daim Ntawv Qhia Tsim thiab xaiv Hloov Xim.
- Hover ib kab ntawm cov xim saib ua ntej cov xim hauv daim ntawv ncuav qab zib.
-
Xaiv xim. Cov ncuav qab zib hloov mus rau ntau qhov ntxoov ntxoo ntawm cov xim xaiv.
-
Txhawm rau hloov xim tom qab ntawm daim ntawv ncuav qab zib, mus rau Daim Ntawv Qhia Cov Cuab Yeejtab.
-
Select Shape Fill.
-
Xaiv xim.
- Txhawm rau ntxiv qhov gradient rau xim tom qab, xaiv Shape Sau.
- Xaiv Gradient.
-
Xaiv qhov gradient style.
-
Txhawm rau hloov xim ntawm cov ntawv hauv lub npe thiab cov ntawv sau, xaiv qhov Text Sau poob xub.
- Xaiv xim.
Explode ib daim ntawm daim ntawv Pie
Thaum koj xav ntxiv qhov tseem ceeb rau ib daim ntawm lub ncuav qab zib, luag lossis tawg cov hlais ntawm cov ncuav qab zib. Tom qab tus swb tau tawg lawm, qhov seem ntawm daim ntawv ncuav qab zib yuav txo qis kom daim ntawv qhia thaj chaw nyob twj ywm tib yam.
Resizing ib daim ntawv yuav txav cov ntaub ntawv cov ntaub ntawv sab nraum lub ncuav qab zib. Luag daim ntawv lo kom rov muab nws tso rau hauv ib daim.
Tau tawg ib daim ntawm daim ntawv ncuav qab zib:
- Xaiv thaj tsam ntawm daim ntawv ncuav qab zib.
-
Xaiv ib daim ntawm daim ntawv qhia ncuav qab zib los nyob ib puag ncig daim hlais nrog cov xim xiav xiav me me.
-
Txiav daim hlais tawm ntawm daim ntawv ncuav qab zib kom tawg nws.
- Txhawm rau hloov daim ntawv lo, xaiv cov ntaub ntawv daim ntawv lo xaiv tag nrho cov ntawv sau.
- Xaiv daim ntawv lo koj xav txav thiab rub nws mus rau qhov chaw xav tau.