Animated bubble chati

Ini ndakatonyora chinyorwa chikuru chakatsanangurwa nezve akajairwa static bubble machati, saka ini handisi kuzogara pane izvo zvekutanga izvozvi. Muchidimbu, iyo bubble chart (Bubble Chart) iri, nenzira yayo, yakasarudzika mhando yechati yekuratidza uye yekuona hukama (kuwirirana) pakati akati wandei (3-4) paramita. Muenzaniso wekare ichati inoratidza hupfumi hwevagari vemo (pa-x-axis), tarisiro yehupenyu (pa-y-axis), uye huwandu hwevanhu (hukuru hwebhora) hwenyika dzakati wandei.

Ikozvino basa redu ndere kuratidza, tichishandisa bubble chart, kusimudzira mamiriro nekufamba kwenguva, semuenzaniso, kubva 2000 kusvika 2014, kureva kugadzira, chokwadi, inodyidzana animation:

Chati yakadaro inotaridzika kunge inonyepedzera, asi yakagadzirwa (kana uine Excel 2013-2016), chaizvo, mumaminetsi mashoma. Handei nhanho nhanho.

Danho 1. Gadzirira data

Kuvaka, tinoda tafura ine data yenyika imwe neimwe, uye yeimwe mhando:

Ziva kuti gore rega rega mutsara wakasiyana une zita renyika uye kukosha kweiyo matatu paramita (mari, tarisiro yehupenyu, huwandu hwevanhu). Kutevedzana kwemakoramu nemitsara (kuronga) hakuite basa.

Iyo yakajairika vhezheni yetafura, uko makore anoenda mumakoramu ekuvaka bubble machati, zvinosuruvarisa, haina kukodzera:

Iwe unogona kushandisa redesign crosstab macro kana pre-yakagadzirwa chishandiso kubva kuPLEX yekuwedzera kushandura tafura yakadaro kuita chitarisiko chakakodzera.

Danho 2. Batanidza Power View add-in

Basa rese rekuvaka rakadaro rinopindirana chati richatorwa neiyo nyowani Power View yekuwedzera kubva kune yebhizinesi intelligence toolkit (Business Intelligence = BI), iyo yakaonekwa muExcel kubvira 2013 vhezheni. Kuti utarise kana uine yekuwedzera yakadaro uye kana yakabatana, enda ku Faira - Sarudzo - Mawedzero, sarudza pazasi pehwindo mune yekudonhedza pasi COM yekuwedzera-in Uye chengetedza About (Faira - Sarudzo - Wedzera-Ins - COM Yekuwedzera - Enda):

Mufafitera rinovhurwa, tarisa kuti pane cheki chiratidzo padivi pacho Power view.

MuExcel 2013 mushure meizvozvo pane iyo tab Insert (Isa) bhatani rinofanira kuoneka:

MuExcel 2016, nekuda kwechimwe chikonzero, bhatani iri rakabviswa kubva paribhoni (kunyangwe iine cheki murondedzero yeCOM yekuwedzera-ins), saka unofanirwa kuiwedzera nemaoko kamwe chete:

1. Kurudyi tinya paribhoni, sarudza rairo Tongedza ribhoni (Gadzirisa Ribhoni).
2. Muchikamu chepamusoro chekuruboshwe chehwindo rinoonekwa, sarudza kubva pane yekudonhedza pasi Zvikwata zvese (Mirairo Yese) uye tsvaga icon Power view.
   
3. Muhafu yakarurama, sarudza tab Insert (Isa) uye gadzira boka idzva mariri uchishandisa bhatani Kugadzira boka (Boka Idzva). Isa chero zita, semuenzaniso Power view.
4. Sarudza boka rakagadzirwa uye wedzera bhatani rakawanikwa kwariri kubva kuruboshwe hafu yehwindo uchishandisa bhatani wedzera (Wedzera) pakati pehwindo.

   
   

Danho 3. Kuvaka chati

Kana iyo yekuwedzera-mukati yakabatana, saka kuvaka iyo chati pachayo inotora masekondi mashoma chete:

1. Isu tinoisa sero inoshanda mutafura ine data uye tinya pane bhatani Power view Tab Insert (Isa) -Itsva Power View report sheet ichawedzerwa kubhuku redu rebasa. Kusiyana nepeji reExcel rakajairwa, harina maseru uye rinotaridzika kunge Power Point siraidhi. Nekutadza, Excel inovaka pane iyi slide chimwe chinhu sepfupiso yedata redu. Pane panofanira kuonekwa kurudyi Power View minda, uko makoramu ese (minda) kubva patafura yedu achanyorwa.
2. Bvisa makoramu ese kunze Countries и Avhareji yemari yegore negore -Iyo tafura yakavakirwa otomatiki paPower View sheet inofanirwa kuvandudzwa kuratidza chete data rakasarudzwa.
   
3. Pa Advanced tabo Constructor (Dhizaini) watinya Imwe Chati - Kuparadzira (Imwe Chati - Kuparadzira).

   

   Tafura inofanira kushanduka kuita chati. Tambanudza kukona kuti ikwane siraidhi.
   

4. Dhonza mupanera Power View minda: munda Avhareji yemari yegore negore – kunharaunda X kukoshaMunda Lifespan - In Y-kukoshaMunda Population kunzvimbo zera, nemunda Gore в Playback axis:

   
   

Ndizvozvo - dhizaini rakagadzirira!

Chasara kupinda musoro, tanga iwo animation nekudzvanya pakanzi Play pakona yekuruboshwe yeslide uye unakirwe nekufambira mberi (mupfungwa dzese).

• Chii chinonzi bubble chati uye kuti ungachivaka sei muExcel
• Kuona geodata pamepu muExcel
• Maitiro ekugadzira Interactive Chati muExcel ine Mipumburu uye Toggles