Cov txheej txheem:

Koj puas tuaj yeem muab daim duab pivot hauv PowerPoint?
Koj puas tuaj yeem muab daim duab pivot hauv PowerPoint?

Video: Koj puas tuaj yeem muab daim duab pivot hauv PowerPoint?

Video: Koj puas tuaj yeem muab daim duab pivot hauv PowerPoint?
Video: Узнайте, как скопировать и вставить условное форматирование в другую ячейку 2024, Hlis ntuj nqeg
Anonim

Txhawm rau qhib a pivot daim duab hauv PowerPoint , datasource (Excel worksheet) uas daim duab los ntawm yuav tsum berunning hauv keeb kwm yav dhau. Yog koj qhib lub PowerPoint swb yam tsis muaj Excel ua haujlwm qhib, lub pivot chart tau tsuas yog saib raws li daim duab.

Ib yam li ib tug yuav nug, koj yuav ua li cas ntxig ib daim duab pivot rau hauv PowerPoint?

Txhawm rau embed ib daim duab los ntawm Excel:

  1. Hauv PowerPoint, xaiv Insert tab. Nyem qhov Inserttab.
  2. Nyem qhov Object hais kom ua nyob rau hauv pawg Text.
  3. Ib lub dialog box yuav tshwm sim.
  4. Nrhiav thiab xaiv cov ntaub ntawv Excel xav tau, tom qab ntawd nyem Insert.
  5. Kos lub npov nyob ib sab ntawm Txuas mus ua ntaub ntawv yog tias koj xav txuas cov ntaub ntawv mus rau Excel daim ntawv.
  6. Nyem OK.

Tsis tas li ntawd, koj puas tuaj yeem tso cov hlais hauv PowerPoint? Ntawm lub Tsev tab, mus rau Ntxig > Slicer . Nyob hauv Ntxig Slicers dialog box, xaiv lub checkboxes rau cov teb koj xav tso saib, ces xaiv OK. A slicer yuav tau tsim rau txhua qhov chaw uas koj xaiv. Nyem ib yam ntawm cov tshuab txiav khawm yuav cia li siv cov lim ntawd mus rau lub rooj sib txuas lossis PivotTable.

Hauv qhov no, koj puas tuaj yeem tso lub rooj pivot hauv PowerPoint?

Kev siv ntawm Pivot Tables nyob rau hauv Excel yog ib tug highleverage txav nyob rau hauv nws tus kheej. Txawm zoo siab tshaj qhov ntawd, koj tuaj yeem siv a Pivot Table nrog tag nrho nws cov kev sib tham sib nta hauv Microsoft PowerPoint swb. Thawj qhov peb xav ua yog qhib Blank Presentation (los yog ntxiv ib qho tshiab, blankslide rau qhov kev nthuav qhia uas twb muaj lawm).

Kuv yuav txuas lub rooj Excel rau PowerPoint li cas?

Txuas ib ntu ntawm cov ntaub ntawv hauv Excel rau PowerPoint

  1. Hauv Excel, qhib cov ntaub ntawv khaws tseg nrog cov ntaub ntawv koj xav tau thiab txuas rau.
  2. Luag hla thaj tsam ntawm cov ntaub ntawv koj xav txuas rau hauv PowerPoint, thiab ntawm lub Tsev tab, nyem lossis coj mus rhaub Luam.
  3. Hauv PowerPoint, nyem qhov swb uas koj xav muab cov ntaub ntawv theej ua haujlwm.

Pom zoo: