Tse ka Hare
bothata: Ho na le lintlha tse mabapi le bafani ba likete tse 'maloa le menehelo ea bona ea selemo le selemo. Tafole ea kakaretso e hahiloeng ho tsoa ho data ena e ke ke ea khona ho fana ka setšoantšo se hlakileng sa hore na bafani ba kenya letsoho haholo, kapa hore na ke bafani ba bakae ba fanang ka sehlopha sefe kapa sefe.
Qeto: U hloka ho theha chate ea pivot. Tlhahiso e hlakileng ea tlhahisoleseling e bokelletsoeng ho PivotTable e ka ba molemo bakeng sa nehelano ea PowerPoint, e sebelisoa kopanong, tlalehong, kapa tlhahlobong e potlakileng. PivotChart e u fa setšoantšo sa lintlha tse khahlang (joalo ka chate e tloaelehileng), empa e boetse e tla le li-filters tse sebetsanang ka kotloloho ho tsoa ho PivotTable tse u lumellang ho sekaseka ka potlako likarolo tse fapaneng tsa data.
Etsa chate ea pivot
Ho Excel 2013, o ka etsa PivotChart ka mekhoa e 'meli. Tabeng ea pele, re sebelisa melemo ea sesebelisoa "Lichate tse khothalelitsoeng»ka Excel. Ha re sebetsa ka sesebelisoa sena, ha ho hlokahale hore re qale ka ho etsa tafole ea pivot hore hamorao re hahe chate ea pivot ho eona.
Tsela ea bobeli ke ho theha PivotChart ho tsoa ho PivotTable e teng, ho sebelisa li-filters le masimo a seng a entsoe.
Khetho ea 1: Theha PivotChart U Sebelisa Sesebelisoa sa Lichate se Featured
- Khetha data eo u batlang ho e bontša chate.
- Ho Advanced tab kenya (Kenya) karolong Litšoantšo (Lichate) tobetsa Lichate tse khothalelitsoeng (Lichate tse khothalelitsoeng) ho bula puisano Kenya chate (Kenya Chate).
- Lebokose la puisano le tla buleha ho tab Lichate tse khothalelitsoeng (Lichate tse khothalelitsoeng), moo lenane le ka letsohong le letšehali le bontšang lenane la lithempleite tsa chate tse loketseng. Karolong e kaholimo ho le letona la setšoantšo sa setšoantšo ka seng, ho na le lets'oao la chate ea pivot:
- Tobetsa setšoantšong sefe kapa sefe ho tsoa lethathamong le khothaletsoang ho bona sephetho sebakeng sa tlhahlobo.
- Khetha mofuta oa chate o loketseng (kapa o batlang o loketse) ebe o tobetsa OK.
Leqephe le lecha le tla kenngoa ka letsohong le letšehali la leqephe la data, moo PivotChart (le PivotTable e tsamaeang le eona) e tla etsoa.
Haeba ho se le e 'ngoe ea litšoantšo tse khothalelitsoeng e lumellanang, koala lebokose la puisano Kenya chate (Kenya Chate) 'me u latele mehato e ho Khetho ea 2 ho theha PivotChart ho tloha qalong.
Khetho ea 2: Etsa PivotChart ho tsoa ho PivotTable e teng
- Tobetsa kae kapa kae ho PivotTable ho hlahisa sehlopha sa li-tab ho Menu Ribone Ho sebetsa le litafole tsa pivot (PivotTable Tools).
- Ho Advanced tab Analysis (Hlahloba) tobetsa Chate ea Pivot (Pivot Chart), sena se tla bula lebokose la puisano la Pivot Chart. Kenya chate (Kenya Chate).
- Ka lehlakoreng le letšehali la lebokose la puisano, khetha mofuta o nepahetseng oa chate. E latelang, khetha mofuta o monyenyane oa chate ka holimo ho fensetere. Chate ea ka moso ea pivot e tla bontšoa sebakeng sa tlhahlobo.
- Press OKho kenya PivotChart leqepheng le tšoanang le la PivotTable ea mantlha.
- Hang ha PivotChart e se e theiloe, u ka iketsetsa likarolo le mebala ea eona u sebelisa lethathamo la likarolo ho menu ea Ribbon kapa litšoantšo. Lintlha tsa chate (Lintlha tsa Chate) le Mekhoa ea lichate (Litaele tsa Chate).
- Sheba chate ea pivot e hlahang. U ka laola li-filters ka kotloloho ho chate ho bona likarolo tse fapaneng tsa data. Ho hotle, ka 'nete!
