Tchati chojambulira chojambulidwa

Ndalemba kale nkhani yayikulu yokhudzana ndi ma chart wamba a static bubble, kotero sindikhala pa zoyambira pano. Mwachidule, tchati chodumphira (Bubble Chart) ndi, mwa njira yakeyake, mtundu wapadera wa tchati chowonetsera ndikuzindikira maubale (malumikizidwe) pakati pa magawo angapo (3-4). Chitsanzo chodziwika bwino ndi tchati chosonyeza chuma cha nzika (pa x-axis), kutalika kwa moyo (pa y-axis), ndi kuchuluka kwa anthu (kukula kwa mpira) m'maiko angapo.

Tsopano ntchito yathu ndikuwonetsa, pogwiritsa ntchito tchati chodumphira, kukula kwa zomwe zikuchitika pakapita nthawi, mwachitsanzo, kuyambira 2000 mpaka 2014, mwachitsanzo, kupanga makanema ojambula pamanja:

Tchati chotere chimawoneka ngati chodzikweza, koma chimapangidwa (ngati muli ndi Excel 2013-2016), kwenikweni, mumphindi zingapo. Tiyeni tipite sitepe ndi sitepe.

Gawo 1. Konzani deta

Kuti timange, tifunika tebulo lokhala ndi data ya dziko lililonse, komanso mtundu wina wake:

Dziwani kuti chaka chilichonse ndi mzere wosiyana ndi dzina la dziko ndi mfundo za magawo atatu (ndalama, nthawi ya moyo, chiwerengero cha anthu). Kutsatizana kwa mizati ndi mizere (kusanja) sikumagwira ntchito.

Mtundu wamba wa tebulo, pomwe zaka zimapita m'mizere kuti apange ma chart a buluu, mwatsoka, sizoyenera:

Mutha kugwiritsa ntchito redesign crosstab macro kapena chida chopangidwa kale kuchokera ku chowonjezera cha PLEX kuti musinthe tebulo lotere kukhala mawonekedwe oyenera.

Gawo 2. Lumikizani Power View kuwonjezera-mu

Ntchito zonse zomanga tchati cholumikizirana choterechi zidzatengedwa ndi chowonjezera chatsopano cha Power View kuchokera mubizinesi Intelligence Toolkit (Business Intelligence = BI), yomwe yawonekera mu Excel kuyambira mtundu wa 2013. Kuti muwone ngati muli ndi zowonjezera zotere ndipo ngati zilumikizidwa, pitani ku Fayilo - Zosankha - Zowonjezera, sankhani pansi pa zenera pa mndandanda wotsitsa Zowonjezera za COM Ndipo dinani About (Fayilo - Zosankha - Zowonjezera - Zowonjezera za COM - Pitani):

Pazenera lomwe limatsegulidwa, onetsetsani kuti pali cholembera pafupi ndi mawonekedwe amphamvu.

Mu Excel 2013 pambuyo pake pa tabu Ikani (Ikani) batani liyenera kuwoneka:

Mu Excel 2016, pazifukwa zina, batani ili linachotsedwa pa riboni (ngakhale ndi cholembera pamndandanda wazowonjezera za COM), kotero muyenera kuwonjezera pamanja kamodzi:

1. Dinani kumanja pa riboni, sankhani lamulo Sinthani nthiti (Sinthani Riboni).
2. Pamwamba kumanzere kwa zenera lomwe likuwoneka, sankhani kuchokera pamndandanda wotsitsa Magulu onse (Malamulo Onse) ndi kupeza chizindikiro mawonekedwe amphamvu.
   
3. Mu theka lamanja, sankhani tabu Ikani (Ikani) ndi kupanga gulu latsopano mmenemo pogwiritsa ntchito batani Kupanga gulu (Gulu Latsopano). Lembani dzina lililonse, mwachitsanzo mawonekedwe amphamvu.
4. Sankhani gulu lopangidwa ndikuwonjezera batani lopezeka kuchokera kumanzere kwazenera pogwiritsa ntchito batani kuwonjezera (Onjezani) mkatikati mwa zenera.

   
   

Gawo 3. Kupanga tchati

Ngati chowonjezeracho chikugwirizana, ndiye kuti kupanga tchati palokha kudzatenga masekondi angapo okha:

1. Timayika cell yogwira patebulo ndi data ndikudina batani mawonekedwe amphamvu tsamba Ikani (Ikani) - Tsamba latsopano la lipoti la Power View lidzawonjezedwa ku bukhu lathu lantchito. Mosiyana ndi pepala lokhazikika la Excel, ilibe ma cell ndipo imawoneka ngati slide ya Power Point. Mwachikhazikitso, Excel idzamanga pa slide iyi ngati chidule cha deta yathu. Gulu liyenera kuwoneka kumanja Power View minda, pomwe mizati yonse (minda) kuchokera patebulo lathu idzalembedwa.
2. Chotsani chojambula pamagawo onse kupatula Mayiko и Avereji ya ndalama zomwe amapeza pachaka - Gome lomwe lamangidwa pa Power View sheet liyenera kusinthidwa kuti liwonetse zomwe zasankhidwa zokha.
   
3. Pa Advanced tabu Constructor (Kapangidwe) pitani Tchati china - Scatter (Tchati Lina - Kuwaza).

   

   Gome liyenera kusandulika kukhala tchati. Tambasulani pakona kuti igwirizane ndi slide.
   

4. Kokani gululo Power View minda: munda Avereji ya ndalama zomwe amapeza pachaka - ku dera X mtengoMunda Utali wamoyo - Mu Y-mtengoMunda Anthu ku dera kukula, ndi munda chaka в Sewero axis:

   
   

Ndi momwemo - chithunzicho chakonzeka!

Zimatsalira kulowa mutuwo, yambitsani makanema podina batani la Play kumunsi kumanzere kwa slide ndikusangalala ndi kupita patsogolo (m'lingaliro lililonse).

• Kodi tchati cha bubble ndi momwe mungapangire mu Excel
• Kuwona kwa geodata pamapu mu Excel
• Momwe Mungapangire Charti Yogwiritsa Ntchito mu Excel yokhala ndi Mipukutu ndi Ma Toggles