Na riga na rubuta babban cikakken labarin game da taswirar kumfa na yau da kullun, don haka ba zan tsaya a kan abubuwan yau da kullun ba. A taƙaice, ginshiƙi na kumfa (Bubble Chart) ita ce, ta hanyarta, nau'in ginshiƙi na musamman don nunawa da gano alaƙa (dangantaka) tsakanin sigogi da yawa (3-4). Misali na yau da kullun shine taswirar da ke nuna arzikin ƴan ƙasa (a kan axis x), tsammanin rayuwa (a kan y-axis), da yawan jama'a (girman ƙwallon ƙafa) na ƙasashe da yawa.
Yanzu aikinmu shine mu nuna, ta amfani da ginshiƙi na kumfa, ci gaban halin da ake ciki a kan lokaci, misali, daga 2000 zuwa 2014, watau ƙirƙirar, a zahiri, motsi mai motsi:
Irin wannan ginshiƙi yana da kyan gani, amma an ƙirƙira shi (idan kuna da Excel 2013-2016), a zahiri, a cikin 'yan mintuna kaɗan. Mu tafi mataki-mataki.
Mataki 1. Shirya bayanai
Don ginawa, muna buƙatar tebur mai bayanai ga kowace ƙasa, kuma na wani nau'i:
Yi la'akari da cewa kowace shekara wani layi ne daban tare da sunan ƙasar da kuma ƙimar ma'auni guda uku (shigarwa, tsawon rai, yawan jama'a). Jerin ginshiƙai da layuka (rarraba) baya taka rawa.
Sigar gama gari na tebur, inda shekaru ke tafiya cikin ginshiƙai don gina taswirar kumfa, abin takaici, a zahiri bai dace ba:
Kuna iya amfani da macro na crosstab na sake fasalin ko kayan aikin da aka riga aka yi daga PLEX add-on don canza irin wannan tebur zuwa yanayin da ya dace.
Mataki 2. Haɗa ƙarawar Duba Power
Duk aikin gina irin wannan ginshiƙi mai ma'amala za a ɗauka ta hanyar sabon ƙarawar Power View daga kayan aikin leken asiri na kasuwanci (Intelligence Business = BI), wanda ya bayyana a cikin Excel tun daga sigar 2013. Don bincika idan kuna da irin wannan ƙari kuma idan an haɗa shi, je zuwa Fayil - Zaɓuɓɓuka - Ƙara-kan, zaɓi a ƙasan taga a cikin jerin zaɓuka COM add-ins Kuma danna Game da (Fayil - Zaɓuɓɓuka - Ƙara-Ins - COM Add-Ins - Go):
A cikin taga da ya buɗe, duba cewa akwai alamar rajistan kusa kallon iko.
A cikin Excel 2013 bayan haka akan shafin Saka (Saka) maballin ya kamata ya bayyana:
A cikin Excel 2016, saboda wasu dalilai, an cire wannan maɓallin daga kintinkiri (ko da tare da alamar rajista a cikin jerin abubuwan add-ins na COM), don haka dole ne ku ƙara shi da hannu sau ɗaya:
- Dama danna kan ribbon, zaɓi umarni Sake siffanta kintinkiri (Canja Ribbon).
- A cikin ɓangaren hagu na sama na taga da ya bayyana, zaɓi daga jerin zaɓuka Duk ƙungiyoyi (Dukkan Dokokin) kuma sami ikon kallon iko.
- A cikin rabin dama, zaɓi shafin Saka (Saka) kuma ƙirƙirar sabon rukuni a ciki ta amfani da maɓallin Don ƙirƙirar ƙungiya (Sabon Rukuni). Shigar da kowane suna, misali kallon iko.
- Zaɓi ƙungiyar da aka ƙirƙira kuma ƙara maɓallin da aka samo zuwa gare ta daga rabin hagu na taga ta amfani da maɓallin Add (Ƙara) tsakiyar taga.
Mataki 3. Gina ginshiƙi
Idan an haɗa add-in, to gina taswirar kanta zai ɗauki 'yan daƙiƙa kaɗan kawai:
- Mun sanya tantanin halitta mai aiki a cikin tebur tare da bayanai kuma danna maɓallin kallon iko tab Saka (Saka) - Za a ƙara sabon takardar rahoton Duba Power cikin littafin aikin mu. Ba kamar takardar Excel ta yau da kullun ba, ba ta da sel kuma tana kama da nunin Wutar Wuta. Ta hanyar tsoho, Excel zai gina akan wannan faifan wani abu kamar taƙaitaccen bayanan mu. Ya kamata panel ya bayyana a hannun dama Filayen Duban Wuta, inda za a jera duk ginshiƙan (filaye) daga teburin mu.
- Cire duk ginshiƙai banda kasashen и Matsakaicin kudin shiga na shekara - Teburin da aka gina ta atomatik akan takaddar Duba Power yakamata a sabunta shi don nuna bayanan da aka zaɓa kawai.
- A kan Babba shafin Constructor (Zane) click Wani Chart - Watsawa (Sauran Chart - Watsawa).
Teburin ya kamata ya zama ginshiƙi. Miƙe shi a kusa da kusurwa don dacewa da zamewar.
- Jawo cikin panel Filayen Duban Wuta: filin Matsakaicin kudin shiga na shekara – zuwa yankin X darajarfilin Lifespan - A Y-darajarfilin Population zuwa yankin size, da filin shekara в Axis sake kunnawa:
Shi ke nan – an shirya zane!
Ya rage don shigar da take, fara rayarwa ta danna maɓallin Play a cikin kusurwar hagu na ƙasan faifan kuma ji daɗin ci gaba (a kowane ma'ana).
- Menene ginshiƙi na kumfa da yadda ake gina shi a cikin Excel
- Kallon geodata akan taswira a cikin Excel
- Yadda ake Ƙirƙirar Jadawalin Ma'amala a cikin Excel tare da Scrollbars da Toggles