txheem
Qhov teeb meem: Muaj cov ntaub ntawv ntawm ntau txhiab tus neeg pub dawb thiab lawv cov nyiaj pub dawb txhua xyoo. Ib lub ntsiab lus uas tau tsim los ntawm cov ntaub ntawv no yuav tsis tuaj yeem muab cov duab meej ntawm cov neeg pub dawb uas tau pab ntau tshaj plaws, lossis muaj pes tsawg tus neeg pub dawb muab rau hauv ib pawg twg.
Kev txiav txim siab: Koj yuav tsum tsim ib daim duab pivot. Ib daim duab sawv cev ntawm cov ntaub ntawv uas tau sau rau hauv PivotTable tuaj yeem pab tau rau kev nthuav qhia PowerPoint, siv hauv kev sib tham, hauv tsab ntawv ceeb toom, lossis rau kev soj ntsuam ceev. Ib PivotChart muab cov duab thaij duab ntawm cov ntaub ntawv txaus siab rau koj (ib yam li daim ntawv qhia tsis tu ncua), tab sis nws kuj tuaj nrog cov ntxaij lim dej sib tham ncaj qha los ntawm PivotTable uas tso cai rau koj los soj ntsuam cov ntawv sib txawv ntawm cov ntaub ntawv sai sai.
Tsim ib daim duab pivot
Hauv Excel 2013, koj tuaj yeem tsim PivotChart hauv ob txoj hauv kev. Hauv thawj kis, peb siv qhov zoo ntawm cov cuab yeej "Daim duab pom zoo» hauv Excel. Ua hauj lwm nrog cov cuab yeej no, peb tsis tas yuav xub tsim ib lub rooj pivot thiaj li tom qab tsim ib daim duab pivot los ntawm nws.
Txoj kev thib ob yog los tsim PivotChart los ntawm PivotTable uas twb muaj lawm, siv cov ntxaij lim dej thiab cov teb uas twb tau tsim lawm.
Option 1: Tsim ib PivotChart siv lub Featured Charts Tool
- Xaiv cov ntaub ntawv koj xav qhia hauv daim duab.
- Hauv Advanced tab Insert (Ntxig) hauv ntu Kev kuaj mob (Chav) nyem Daim duab pom zoo (Cov kab lus pom zoo) qhib lub dialog Ntxig ib daim duab (Insert Chart).
- Lub dialog box yuav qhib rau ntawm lub tab Daim duab pom zoo (Cov Ntawv Pom Zoo), qhov twg cov ntawv qhia zaub mov nyob rau sab laug qhia cov npe ntawm cov qauv tsim nyog. Nyob rau sab xis sab xis ntawm tus thumbnail ntawm txhua tus qauv, muaj ib daim duab pivot icon:
- Nyem rau ntawm txhua daim duab los ntawm cov npe pom zoo kom pom qhov tshwm sim hauv thaj chaw saib ua ntej.
- Xaiv qhov tsim nyog (lossis yuav luag tsim) hom kab kos thiab nias OK.
Ib daim ntawv tshiab yuav muab tso rau sab laug ntawm daim ntawv teev cov ntaub ntawv, uas lub PivotChart (thiab nrog PivotTable) yuav raug tsim.
Yog tias tsis muaj daim duab pom zoo haum, kaw lub dialog box Ntxig ib daim duab (Insert Chart) thiab ua raws cov kauj ruam hauv Kev Xaiv 2 los tsim PivotChart los ntawm kos.
Option 2: Tsim ib PivotChart los ntawm PivotTable uas twb muaj lawm
- Nyem qhov twg hauv PivotTable kom coj tau ib pab pawg tab ntawm Cov Ntawv Qhia Ribbon Ua haujlwm nrog cov lus pivot (PivotTable Tools).
- Hauv Advanced tab Analysis (Tsim) nyem Pivot Daim Ntawv (Pivot Chart), qhov no yuav qhib lub Pivot Chart dialog box. Ntxig ib daim duab (Insert Chart).
- Nyob rau sab laug ntawm lub dialog box, xaiv hom kab ntawv tsim nyog. Tom ntej no, xaiv ib daim ntawv subtype nyob rau sab saum toj ntawm lub qhov rais. Daim duab pivot yav tom ntej yuav raug pom hauv thaj chaw saib ua ntej.
- Xovxwm OKmus ntxig rau PivotChart rau tib daim ntawv raws li tus pivotTable qub.
- Thaum PivotChart tau tsim, koj tuaj yeem kho nws cov ntsiab lus thiab xim siv cov npe ntawm cov teb ntawm Ribbon ntawv qhia zaub mov lossis cov cim Daim ntawv qhia (Chart Elements) thiab Daim duab style (Style Chart).
- Saib ntawm daim duab pivot uas tshwm sim. Koj tuaj yeem tswj cov ntxaij lim dej ncaj qha rau ntawm daim ntawv kom pom cov ntawv sib txawv ntawm cov ntaub ntawv. Nws zoo heev, tiag tiag!
