Papa kiʻi ʻōhū ʻoniʻoni

Ua kākau mua wau i kahi ʻatikala kikoʻī nui e pili ana i nā pakuhi pahu static maʻamau, no laila ʻaʻole wau e noʻonoʻo i nā kumu kumu i kēia manawa. ʻO ka pōkole, ʻo ka pakuhi pahu (Bubble Chart), ma kona ʻano ponoʻī, he ʻano ʻokoʻa o ka pakuhi no ka hōʻike ʻana a me ka ʻike ʻana i nā pilina (correlations) ma waena o kekahi (3-4) mau ʻāpana. ʻO kahi hiʻohiʻona maʻamau he pakuhi e hōʻike ana i ka waiwai o nā kamaʻāina (ma ka x-axis), ka manaʻolana ola (ma ka axis-y), a me ka heluna kanaka (ka nui o ka pōleʻa) no kekahi mau ʻāina.

I kēia manawa, ʻo kā mākou hana e hōʻike, me ka hoʻohana ʻana i kahi pakuhi bubble, ka hoʻomohala ʻana o ke kūlana i ka manawa, no ka laʻana, mai 2000 a 2014, ʻo ia hoʻi, e hana i kahi animation interactive:

Ke nānā aku nei kēlā ʻano pakuhi, akā ua hana ʻia (inā loaʻa iā ʻoe ka Excel 2013-2016), ʻoiaʻiʻo, i loko o ʻelua mau minuke. E hele kāua i kēlā me kēia pae.

KaʻAnuʻu 1. E hoʻomākaukau i kaʻikepili

No ke kūkulu ʻana, pono mākou i kahi papa me nā ʻikepili no kēlā me kēia ʻāina, a me kekahi ʻano:

E hoʻomaopopo i kēlā me kēia makahiki he laina kaʻawale me ka inoa o ka ʻāina a me nā waiwai o nā ʻāpana ʻekolu (loaʻa, ola ola, heluna kanaka). ʻAʻole pāʻani ke kaʻina o nā kolamu a me nā lālani.

ʻO kahi mana maʻamau o ka papaʻaina, kahi e hele ai nā makahiki i loko o nā kolamu e kūkulu i nā kiʻi pahu, akā naʻe, ʻaʻole kūpono.

Hiki iā ʻoe ke hoʻohana i kahi macro crosstab redesign a i ʻole kahi mea hana i hana mua ʻia mai ka PLEX add-on e hoʻohuli i kēlā papa i kahi nānā kūpono.

KaʻAnuʻu Hana 2. Hoʻohui i ka Power View add-in

E lawe ʻia nā hana a pau o ke kūkulu ʻana i ia pakuhi pānaʻi e ka Power View hoʻohui hou mai ka ʻoihana akamai ʻoihana (Business Intelligence = BI), i ʻike ʻia ma Excel mai ka mana 2013. E nānā inā loaʻa iā ʻoe kahi mea hoʻohui like a inā pili ia, e hele i Kōnae - Nā koho - Nā mea hoʻohui, koho ma ka lalo o ka puka makani ma ka papa inoa hāʻule iho Nā mea hoʻohui COM A e kaomi i About (Kōnae - Nā koho - Hoʻohui - Hoʻohui COM - Hele):

Ma ka puka aniani e wehe ai, e nānā inā aia kahi māka ma ka ʻaoʻao ike mana.

Ma Excel 2013 ma hope o kēlā ma ka pā hookomo (Hookomo) e puka mai ke pihi:

Ma Excel 2016, no kekahi kumu, ua wehe ʻia kēia pihi mai ka lipine (ʻoiai me ka māka i ka papa inoa o COM add-ins), no laila pono ʻoe e hoʻohui me ka lima hoʻokahi:

1. Kaomi pololei ma ka lipine, koho i ke kauoha Hoʻonohonoho i ka lipin (Hoʻopilikino lipine).
2. Ma ka ʻaoʻao hema hema o ka puka aniani e kū mai ana, koho mai ka papa inoa hāʻule Nā hui a pau (Nā Kauoha a pau) a e imi i ka ikona ike mana.
   
3. Ma ka hapa ʻākau, koho i ka pā hookomo (Hookomo) a hana i hui hou i loko me ka hoʻohana ʻana i ke pihi No ka hana ʻana i hui (Pūʻulu Hou). E hoʻokomo i kekahi inoa, no ka laʻana ike mana.
4. E koho i ka hui i hana ʻia a hoʻohui i ke pihi i loaʻa iā ia mai ka ʻaoʻao hema o ka puka aniani me ka hoʻohana ʻana i ke pihi Hoʻohui (Hohua mai) i waenakonu o ka puka makani.

   
   

KaʻAnuʻu 3. Ke kūkuluʻana i ka pakuhi

Inā pili ka mea hoʻohui, a laila e hana i ka pakuhi ponoʻī he mau kekona wale nō:

1. Hoʻokomo mākou i ka cell active i ka papa me ka ʻikepili a kaomi i ke pihi ike mana uku pila hookomo (Hookomo) - E hoʻohui ʻia kahi pepa hōʻike Power View hou i kā mākou puke hana. ʻAʻole e like me ka pepa Excel maʻamau, ʻaʻohe ona cell a ʻoi aku ka like me ka Power Point slide. Ma ka maʻamau, e kūkulu ʻo Excel ma kēia paheʻe i kahi mea e like me ka hōʻuluʻulu o kā mākou ʻikepili. Pono e ʻike ʻia kahi papa ma ka ʻākau Nā kahua Nānā Mana, kahi e helu ʻia ai nā kolamu a pau mai kā mākou papa ʻaina.
2. Wehe i nā kolamu a pau koe 'āina и Awelika loaʻa makahiki - Pono e hōʻano hou ʻia ka pākaukau i kūkulu ʻia ma ka pepa Power View e hōʻike i nā ʻikepili i koho ʻia.
   
3. Ma ka ʻaoʻao kiʻekiʻe Kukahula (Hoʻolālā) kaomi ʻO kekahi pakuhi - Scatter (Pākuhi ʻē aʻe — Scatter).

   

   Pono ka papaʻaina e lilo i pakuhi. E kikoo a puni ke kihi e kūpono i ka paheʻe.
   

4. Kauō i ka pā Nā kahua Nānā Mana: kahua Awelika loaʻa makahiki – i ka ʻāina Waiwai Xkahua Holoholo - I loko Y-waiwaikahua Ka heluna kanaka i ka wahi Size, a me ke kula Makahiki в axis pāʻani:

   
   

ʻO ia - ua mākaukau ke kiʻikuhi!

Ke hoʻomau nei e komo i ke poʻo inoa, e hoʻomaka i ka animation ma ke kaomi ʻana i ka pihi Play ma ka ʻaoʻao hema hema o ka slide a hauʻoli i ka holomua (ma nā ʻano āpau).

• He aha ka pakuhi bubble a pehea e kūkulu ai ma Excel
• ʻO ka ʻike ʻana i ka geodata ma kahi palapala ʻāina ma Excel
• Pehea e hana ai i kahi pakuhi Interactive ma Excel me nā Scrollbars a me Toggles