Yuav Paub
- Tshuav ib daim ncuav qab zib: Qhia daim ntawv qhia > xaiv hlais kom tawg > xaiv thiab rub hlais.
- Pie ntawm ncuav qab zib lossis Bar ntawm Pie daim ntawv qhia: Cov ntaub ntawv tseem ceeb > xaiv Insert > kab kos > Insert Pie Daim duab> xaiv hom.
- Hloov kab ntawv hom: nyem nyem thiab xaiv Hloov kab ntawv hom > Txhua kab ntawv > Pie> xaiv hom kab ntawv tshiab.
Kab lus no piav qhia yuav ua li cas "tawg tawm" ib daim ntawv ntawm Excel ncuav qab zib lossis tsim Pie ntawm Pie lossis Bar ntawm Pie kab kos los hais txog cov ntaub ntawv tseem ceeb. Cov lus qhia npog Excel versions 2019, 2016, 2013, thiab Excel rau Microsoft 365.
Tshuaj kho ib lub ncuav qab zib
Txhawm rau ntxiv qhov tseem ceeb rau ib qho ntawm daim ntawv qhia ncuav qab zib, koj tuaj yeem txav los yog explode daim hlais tawm ntawm qhov seem ntawm daim ntawv raws li qhia hauv daim duab saum toj no.
- Xaiv ib zaug ntawm thaj tsam ntawm daim ntawv ncuav qab zib kom pom nws.
- Xaiv zaum ob ntawm slice kom tawg.
- Qhov tseem ceeb tam sim no yuav tsum nyob ib puag ncig ntawm lub ncuav qab zib no, suav nrog ib qho chaw nyob hauv nruab nrab ntawm daim ntawv.
- Xaiv thiab rub cov kab uas tau xaiv ntawm lub ncuav, rub tawm tam sim ntawd ntawm daim ntawv qhia.
- Yog tias koj xav tau txav cov hlais tawg rov qab mus rau nws qhov chaw qub, siv Excel lub undo feature, lossis rub lub hlais rov qab mus rau daim ntawv ncuav qab zib thiab nws yuav rov qab mus rau nws qhov chaw qub.
Pie ntawm ncuav qab zib thiab Bar ntawm ncuav qab zib kab kos
Lwm qhov kev xaiv ntxiv rau qhov tseem ceeb rau qee qhov ntawm daim ntawv qhia ncuav qab zib yog siv Pie ntawm Pie lossis Bar ntawm ncuav qab zib daim ntawv es tsis yog daim ntawv qhia ncuav qab zib.
Yog tias koj muaj ib lossis ob daim ntawv loj dua uas yog tus thawj daim ntawv ncuav qab zib, ua rau nws nyuaj rau pom cov ntsiab lus ntawm cov ntawv me me, koj tuaj yeem hloov mus rau ib qho ntawm cov lus hais saum toj no; cov no qhia txog cov me me nyob rau hauv daim ntawv thib ob, ob lub ncuav qab zib thib ob lossis ib daim ntawv teev cov kab ntawv.
Tshwj tsis yog hloov pauv, Excel yuav cia li suav nrog peb daim ntawv me me (cov ntaub ntawv cov ntsiab lus) hauv cov ncuav qab zib thib ob lossis pawg kab ntawv. Txhawm rau tsim Pie ntawm Pie lossis Bar ntawm Pie daim duab:
- Highlight ntau yam ntawm cov ntaub ntawv siv rau hauv daim ntawv.
- Xaiv tus Insert tab ntawm kab.
-
In the Charts lub npov ntawm ribbon, xaiv lub Insert Pie Chart icon txhawm rau qhib cov ntawv qhia zaub mov ntawm hom kab ntawv muaj. Hover koj tus nas pointer hla ib hom kab ntawv nyeem cov lus piav qhia ntawm daim duab.
- Xaiv yog Pie ntawm Pie los yog Bar of Pie daim duab hauv 2-D Pie seem ntawm cov ntawv qhia zaub mov ntxiv daim duab ntawd rau daim ntawv ua haujlwm.
Daim ntawv qhia sab laug yog ib daim ntawv qhia tseem ceeb, nrog daim ntawv thib ob ib txwm tshwm sim ntawm nws txoj cai. Qhov kev npaj no hloov tsis tau.
Hloov hom kab kos
Tau hloov los ntawm daim ntawv qhia ncuav qab zib uas twb muaj lawm mus rau ib qho Pie ntawm Pie los yog Bar ntawm ncuav qab zib daim ntawv:
- Right-click the tam sim no daim duab los qhib cov ntsiab lus teb.
- Xaiv Hloov hom kab ntawv txhawm rau qhib qhov Hloov kab ntawv hom dialog box.
- Nyob hauv lub dialog box, xaiv lub Tag nrho kab ntawv tab.
-
Select Pie nyob rau sab laug pane thiab tom qab ntawd xaiv Pie ntawm ncuav qab zib lossis Bar ntawm ncuav qab zibnyob rau hauv txoj cai pane rau lub dialog box.
Hloov tus lej ntawm Cov Ntaub Ntawv Cov Ntsiab Lus
Txhawm rau hloov cov ntaub ntawv cov ntsiab lus (slices) tso tawm hauv kab ntawv thib ob:
- Tub-nias lub daim ntawv qhia ncuav qab zib tseem ceeb txhawm rau qhib lub Format Data Series pane.
- Nyob rau hauv lub pane, xaiv tus down xub ib sab ntawm Split Series By kev xaiv.
Cov kev xaiv muaj los hloov cov naj npawb ntawm cov ntsiab lus hauv kab ntawv thib ob suav nrog:
- Split the Series by Position: Nyob rau hauv Nqis nyob rau hauv ob zajlus lub npov, nkag mus rau tus naj npawb ntawm txoj haujlwm lossis cov hlais tso rau hauv qhov thib ob daim duab (yam tsawg kawg ntawm peb).
- Split the Series by Value: Hauv Tus nqi tsawg dua lub npov, sau tus lej uas loj dua cov ntaub ntawv tsawg tshaj plaws rau muab tso rau hauv daim ntawv thib ob.
- Split the Series by Percentage Value: Nyob rau hauv Tus nqi tsawg dualub npov, sau tus nqi feem pua ntawm 0% thiab 100%. Tus nqi no cuam tshuam rau feem pua ntawm daim ntawv qhia tseem ceeb tus nqi tag nrho yuav tsum tau muab tso rau hauv daim ntawv thib ob.
