Chate ea bubble ea animated

Ke se ke ngotse sengoloa se seholo se nang le lintlha tse mabapi le lichate tse tloaelehileng tsa bubble, kahoo nke ke ka lula holim'a lintho tsa motheo hona joale. Ka bokhutšoanyane, chate ea bubble (Bubble Chart) ke, ka tsela ea eona, mofuta o ikhethang oa chate bakeng sa ho bonts'a le ho lemoha likamano (likamano) pakeng tsa mekhahlelo e mengata (3-4). Mohlala oa khale ke chate e bontšang leruo la baahi (ho x-axis), tebello ea bophelo (ho y-axis), le palo ea baahi (boholo ba bolo) bakeng sa linaha tse 'maloa.

Hona joale mosebetsi oa rona ke ho bonts'a, ho sebelisa chate ea bubble, nts'etsopele ea maemo ha nako e ntse e ea, mohlala, ho tloha 2000 ho isa 2014, ke hore, ho theha, ha e le hantle, animation e kopanetsoeng:

Chate e joalo e shebahala e le boikaketsi haholo, empa e entsoe (haeba u na le Excel 2013-2016), ka ho toba, ka metsotso e seng mekae. Ha re yeng kgato ka kgato.

Mohato 1. Lokisetsa ya data

Ho haha, re hloka tafole e nang le data bakeng sa naha ka 'ngoe, le ea mofuta o itseng:

Hlokomela hore selemo se seng le se seng ke moeli o arohaneng o nang le lebitso la naha le litekanyetso tsa mekhahlelo e meraro (chelete, nako ea bophelo, palo ea baahi). Tatelano ya dikholomo le mela (ho hlopha) ha e bapale karolo.

Mofuta o tloaelehileng oa tafole, moo lilemo li eang ka likholomo ho aha lichate tsa bubble, ka bomalimabe, ha e ea nepahala:

U ka sebelisa crosstab macro ea redesign kapa sesebelisoa se entsoeng esale pele ho tsoa ho tlatsetso ea PLEX ho fetolela tafole e joalo hore e be chebahalo e nepahetseng.

Mohato 2. Hokela Power View add-in

Mosebetsi oohle oa ho aha chate e joalo e sebetsanang le eona e tla nkuoa ke tlatsetso e ncha ea Power View ho tsoa ho sesebelisoa sa bohlale sa khoebo (Business Intelligence = BI), se hlahileng Excel ho tloha ka mofuta oa 2013. Ho hlahloba hore na u na le tlatsetso e joalo le hore na e hokahane, e ea ho Faele – Dikgetho – Dikeketso, khetha botlaaseng ba fensetere lenaneng la ho theoha Lisebelisoa tsa COM 'Me u tobetse About (Likhetho - Likhetho - Li-add-Ins - Li-add-Ins tsa COM - E-ea):

Fesetereng e butsoeng, hlahloba hore na ho na le letšoao haufi le pono ea matla.

Ho Excel 2013 kamora moo ho tab kenya (Kenya) konopo e lokela ho hlaha:

Ho Excel 2016, ka lebaka le itseng, konopo ena e ile ea tlosoa riboneng (esita le lets'oao le lethathamong la li-add-ins tsa COM), kahoo u tlameha ho e kenyelletsa hang hang:

1. Tobetsa ka ho le letona lenteng, khetha taelo Iketsetse mohatla (Iketsetse Ribone).
2. Karolong e ka holimo le letšehali ea fensetere e hlahang, khetha lethathamong le theoha Lihlopha tsohle (Litaelo Tsohle) 'me u fumane letšoao pono ea matla.
   
3. Halofo e nepahetseng, khetha tab kenya (Kenya) 'me u thehe sehlopha se secha ho eona u sebelisa konopo Ho theha sehlopha (Sehlopha se Secha). Kenya lebitso lefe kapa lefe, mohlala pono ea matla.
4. Khetha sehlopha se entsoeng 'me u kenye konopo e fumanoeng ho sona ho tloha halofo e letšehali ea fensetere u sebelisa konopo Add (Kenya) bohareng ba fensetere.

   
   

Mohato oa 3. Ho haha ​​chate

Haeba kenyelletso e hokahane, ho aha chate ka boeona ho tla nka metsotsoana e seng mekae feela:

1. Re kenya sele e sebetsang tafoleng ka data ebe o tobetsa konopo pono ea matla tab ya kenya (Kenya) - Letlapa le lecha la tlaleho ea Power View le tla eketsoa bukeng ea rona ea mosebetsi. Ho fapana le leqephe le tloaelehileng la Excel, ha le na lisele mme le shebahala joalo ka slide ea Power Point. Ka kamehla, Excel e tla haha ​​holim'a slide ena ntho e kang kakaretso ea data ea rona. Phanele e lokela ho hlaha ka ho le letona Libaka tsa Power View, moo ho tla thathamisoa litšiea tsohle (masimo) ho tloha tafoleng ea rona.
2. Tlosa ho lekola litšiea tsohle ntle le Countries и Karolelano ea chelete ea selemo - Tafole e hahiloeng ka bo eona leqepheng la Power View e lokela ho ntlafatsoa ho bonts'a data e khethiloeng feela.
   
3. Ho Advanced tab Constructor (Moralo) tlelike Chate e 'ngoe - Hasanya (Chate e 'ngoe - Scatter).

   

   Tafole e lokela ho fetoha chate. E otlolle ho potoloha hukung hore e lekane selaete.
   

4. Hula ka phanele Libaka tsa Power View: lebala Karolelano ea chelete ea selemo – ho ea sebakeng X bolengTšimo Bolele ba bophelo - In Y-bolengTšimo Baahi sebakeng Size, le tšimo Year в Sebaka sa ho bapala:

   
   

Ke phetho - setšoantšo se se se lokile!

Ho sala ho kenya sehlooho, qala animation ka ho tobetsa konopo ea Play e hukung e ka tlase e ka letsohong le letšehali la selaete 'me u natefeloe ke tsoelo-pele (ka moelelo o mong le o mong).

• Chate ea bubble ke eng le mokhoa oa ho e haha ​​​​ho Excel
• Ho bona geodata 'mapeng ho Excel
• Mokhoa oa ho theha Chate e sebetsang ho Excel e nang le Scrollbar le Toggles