Yuav ua li cas Tsim thiab Tsim Daim Ntawv Pie hauv Excel

Cov txheej txheem:

Yuav ua li cas Tsim thiab Tsim Daim Ntawv Pie hauv Excel
Yuav ua li cas Tsim thiab Tsim Daim Ntawv Pie hauv Excel
Anonim

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.

Image
Image

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:

  1. Nyob rau ntawm kab, mus rau Insert tab.

    Image
    Image
  2. Xaiv Insert Pie Chart los tso saib hom ntawv ncuav qab zib muaj.

    Image
    Image
  3. Hover dua ib hom kab ntawv nyeem cov lus piav qhia ntawm daim ntawv qhia thiab saib ua ntej daim ntawv ncuav qab zib.

    Image
    Image
  4. 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.

  1. Xaiv lub npe ntawm daim ntawv teev npe. Ib lub thawv tshwm nyob ib ncig ntawm lub npe.
  2. Nias rau ntawm cov ntawv los tso Excel hauv hom hloov kho thiab tso tus cursor rau hauv lub thawv npe.

    Image
    Image
  3. nias Delete or Backspace txhawm rau rho tawm cov ntawv uas twb muaj lawm.
  4. Tau ib daim ntawv teev npe. Piv txwv li, ntaus Lub Khw Muag Khoom Qab Zib 2018 Cov Nyiaj Tau Los ntawm Muag.

    Image
    Image
  5. 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:

  1. Xaiv thaj tsam ntawm daim ntawv ncuav qab zib.
  2. Right-click the chart.

    Image
    Image
  3. Xaiv Ntxiv cov ntaub ntawv sau npe.

    Image
    Image
  4. 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:

  1. Xaiv ib cheeb tsam ntawm daim duab keeb kwm yav dhau los xaiv tag nrho daim ntawv ncuav qab zib.

    Image
    Image
  2. Txhawm rau hloov cov xim ntawm daim ntawv ncuav qab zib, mus rau Daim Ntawv Qhia Tsim thiab xaiv Hloov Xim.

    Image
    Image
  3. Hover ib kab ntawm cov xim saib ua ntej cov xim hauv daim ntawv ncuav qab zib.
  4. Xaiv xim. Cov ncuav qab zib hloov mus rau ntau qhov ntxoov ntxoo ntawm cov xim xaiv.

    Image
    Image
  5. Txhawm rau hloov xim tom qab ntawm daim ntawv ncuav qab zib, mus rau Daim Ntawv Qhia Cov Cuab Yeejtab.

    Image
    Image
  6. Select Shape Fill.

    Image
    Image
  7. Xaiv xim.

    Image
    Image
  8. Txhawm rau ntxiv qhov gradient rau xim tom qab, xaiv Shape Sau.
  9. Xaiv Gradient.
  10. Xaiv qhov gradient style.

    Image
    Image
  11. Txhawm rau hloov xim ntawm cov ntawv hauv lub npe thiab cov ntawv sau, xaiv qhov Text Sau poob xub.

    Image
    Image
  12. 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:

  1. Xaiv thaj tsam ntawm daim ntawv ncuav qab zib.
  2. Xaiv ib daim ntawm daim ntawv qhia ncuav qab zib los nyob ib puag ncig daim hlais nrog cov xim xiav xiav me me.

    Image
    Image
  3. Txiav daim hlais tawm ntawm daim ntawv ncuav qab zib kom tawg nws.

    Image
    Image
  4. Txhawm rau hloov daim ntawv lo, xaiv cov ntaub ntawv daim ntawv lo xaiv tag nrho cov ntawv sau.
  5. Xaiv daim ntawv lo koj xav txav thiab rub nws mus rau qhov chaw xav tau.

Pom zoo: