Animated npuas daim duab

Kuv twb tau sau ib tsab xov xwm ntxaws ntxaws txog cov kab kos ua npuas zoo li qub, yog li kuv yuav tsis nyob ntawm qhov pib tam sim no. Nyob rau hauv luv luv, daim ntawv npuas npuas (Bubble Chart) yog, nyob rau hauv nws tus kheej txoj kev, ib tug tshwj xeeb hom ntawm daim ntawv qhia rau displaying thiab xyuas kev sib raug zoo (kev sib raug zoo) ntawm ob peb (3-4) tsis. Ib qho piv txwv classic yog daim duab qhia txog kev nplua nuj ntawm cov pej xeem (ntawm x-axis), lub neej expectancy (ntawm y-axis), thiab cov pejxeem (pob loj) rau ntau lub teb chaws.

Tam sim no peb txoj haujlwm yog los qhia, siv daim duab npuas, kev txhim kho ntawm qhov xwm txheej dhau sijhawm, piv txwv li, los ntawm 2000 txog 2014, piv txwv li los tsim, qhov tseeb, kev sib tham sib animation:

Daim ntawv qhia zoo li no zoo li tsis txaus ntseeg, tab sis nws yog tsim (yog tias koj muaj Excel 2013-2016), lus, hauv ob peb feeb. Wb mus ib kauj ruam.

Kauj Ruam 1. Npaj cov ntaub ntawv

Txhawm rau tsim, peb xav tau ib lub rooj nrog cov ntaub ntawv rau txhua lub tebchaws, thiab ntawm qee hom:

Nco ntsoov tias txhua xyoo yog ib txoj kab sib cais nrog lub npe ntawm lub teb chaws thiab cov txiaj ntsig ntawm peb qhov kev txwv (cov nyiaj tau los, lub neej expectancy, pejxeem). Cov kab ke ntawm kab thiab kab (sorting) tsis ua lub luag haujlwm.

Ib qho piv txwv ntawm lub rooj, qhov twg xyoo mus rau hauv kab los tsim cov kab kos npuas, hmoov tsis, yog qhov tsis tsim nyog:

Koj tuaj yeem siv lub redesign crosstab macro lossis lub cuab yeej ua ntej los ntawm PLEX add-on los hloov lub rooj rau hauv qhov tsim nyog.

Kauj ruam 2. Txuas lub hwj huam saib ntxiv-hauv

Txhua txoj haujlwm ntawm kev tsim cov ntawv sib tham sib tham yuav raug coj los ntawm Power View tshiab ntxiv los ntawm cov khoom siv kev txawj ntse ua lag luam (Business Intelligence = BI), uas tau tshwm sim hauv Excel txij li xyoo 2013 version. Txhawm rau txheeb xyuas seb koj puas muaj qhov txuas ntxiv thiab yog tias nws txuas nrog, mus rau Cov ntaub ntawv – Kev xaiv – Ntxiv-ons, xaiv nyob rau hauv qab ntawm lub qhov rais nyob rau hauv lub drop-down daim ntawv teev COM ntxiv-ins Thiab nias qhov Hais txog (Cov ntaub ntawv - Kev xaiv - Ntxiv-Ins - COM Ntxiv-Ins - Mus):

Nyob rau hauv lub qhov rais uas qhib, xyuas tias muaj ib tug kos cim nyob ib sab ntawm lub zog saib.

Hauv Excel 2013 tom qab ntawd ntawm lub tab Insert (Ntxig) khawm yuav tsum tshwm:

Hauv Excel 2016, rau qee qhov laj thawj, lub pob no tau raug tshem tawm ntawm txoj kab (txawm tias muaj cov cim hauv daim ntawv teev npe ntawm COM add-ins), yog li koj yuav tsum ntxiv nws manually ib zaug:

1. Txoj nyem rau ntawm kab ntawv, xaiv cov lus txib Customize ribbon (Customize Ribbon).
2. Nyob rau sab laug sab laug ntawm lub qhov rais uas tshwm, xaiv los ntawm daim ntawv teev npe poob Txhua pab pawg (Tag nrho cov lus txib) thiab nrhiav lub icon lub zog saib.
   
3. Hauv txoj cai ib nrab, xaiv lub tab Insert (Ntxig) thiab tsim ib pab pawg tshiab hauv nws siv lub pob Tsim ib pab pawg (Cov pab pawg tshiab). Sau ib lub npe, piv txwv li lub zog saib.
4. Xaiv cov pab pawg tsim thiab ntxiv qhov pom khawm rau nws los ntawm sab laug ib nrab ntawm lub qhov rais siv lub pob Ntxiv (Ntxiv) nyob nruab nrab ntawm lub qhov rais.

   
   

Kauj Ruam 3. Tsim ib daim duab

Yog tias qhov add-in txuas nrog, ces tsim daim ntawv nws tus kheej yuav siv sijhawm li ob peb feeb xwb:

1. Peb muab lub active cell nyob rau hauv lub rooj nrog cov ntaub ntawv thiab nyem rau ntawm lub pob lub zog saib tab Insert (Ntxig) - Daim ntawv tshaj tawm Power View tshiab yuav muab ntxiv rau hauv peb phau ntawv ua haujlwm. Tsis zoo li daim ntawv Excel li niaj zaus, nws tsis muaj hlwb thiab zoo li Power Point swb. Los ntawm lub neej ntawd, Excel yuav tsim rau ntawm qhov swb no ib yam li cov ntsiab lus ntawm peb cov ntaub ntawv. Lub vaj huam sib luag yuav tsum tshwm nyob rau sab xis Power View teb, qhov twg tag nrho cov kab (thaj chaw) los ntawm peb lub rooj yuav raug teev tseg.
2. Uncheck tag nrho cov kab tshwj tsis yog Lub teb chaws и Cov nyiaj tau los nruab nrab txhua xyoo - Lub rooj tau tsim los ntawm daim ntawv Power View yuav tsum tau hloov kho kom pom cov ntaub ntawv xaiv nkaus xwb.
   
3. Hauv Advanced tab constructor (Tsim) nias Lwm Daim Ntawv Qhia - Scatter (Lwm daim duab - Scatter).

   

   Lub rooj yuav tsum tig mus rau hauv daim ntawv. Tight nws nyob ib ncig ntawm lub ces kaum kom haum tus swb.
   

4. Luag hauv lub vaj huam sib luag Power View teb: teb Cov nyiaj tau los nruab nrab txhua xyoo - mus rau cheeb tsam X tus nqiteb lifespan - Hauv Y-tus nqiteb pejxeem mus rau thaj chaw loj, thiab teb xyoo в Playback axis:

   
   

Qhov ntawd yog nws – daim duab yog npaj txhij!

Nws tseem yuav tau nkag mus rau lub npe, pib cov animation los ntawm txhaj rau lub khawm Ua si nyob rau sab laug ces kaum ntawm tus swb thiab txaus siab rau qhov kev nce qib (hauv txhua qhov kev nkag siab).

• Dab tsi yog daim duab npuas thiab yuav ua li cas tsim nws hauv Excel
• Visualization ntawm geodata ntawm daim ntawv qhia hauv Excel
• Yuav Ua Li Cas Tsim Daim Ntawv Sib Tham Sib Tham hauv Excel nrog Scrollbars thiab Toggles