Yawancin waɗanda suka taɓa gina zane-zane a cikin Microsoft Excel ko PowerPoint sun lura da nau'in sigogin ban mamaki da ban dariya - bubble charts. Mutane da yawa sun gan su a cikin fayilolin wasu mutane ko gabatarwa. Koyaya, a cikin lokuta 99 daga cikin 100, lokacin ƙoƙarin gina irin wannan zane a karon farko, masu amfani suna fuskantar matsaloli da yawa waɗanda ba a bayyane suke ba. Yawancin lokaci, Excel ko dai ya ƙi ƙirƙira shi kwata-kwata, ko kuma ya ƙirƙira shi, amma a cikin sigar da ba za a iya fahimta gaba ɗaya ba, ba tare da sa hannun hannu ba kuma a bayyane.
Mu duba wannan batu.
Menene jadawalin kumfa
Taswirar kumfa takamaiman nau'in ginshiƙi ne wanda zai iya nuna bayanan XNUMXD a sararin samaniya na XNUMXD. Misali, yi la'akari da wannan ginshiƙi da ke nuna ƙididdiga ta ƙasa daga sanannen rukunin zanen zane http://www.gapminder.org/:
Kuna iya sauke cikakken girman PDF daga nan http://www.gapminder.org/downloads/gapminder-world-map/
A kwance x-axis yana wakiltar matsakaicin kudin shiga na kowace shekara a cikin USD. Madaidaicin y-axis yana wakiltar tsawon rai a cikin shekaru. Girman (diamita ko yanki) kowane kumfa ya yi daidai da yawan al'ummar kowace ƙasa. Don haka, yana yiwuwa a nuna bayanai mai girma uku akan ginshiƙi ɗaya.
Hakanan ana ɗaukar ƙarin nauyin bayanai ta launi, wanda ke nuna alaƙar yanki na kowace ƙasa zuwa wata nahiya.
Yadda ake gina taswirar kumfa a cikin Excel
Mahimmin mahimmanci wajen gina taswirar kumfa shine tebur da aka shirya da kyau tare da bayanan tushe. Wato, teburin dole ne ya ƙunshi ginshiƙai guda uku a cikin tsari mai zuwa (daga hagu zuwa dama):
- Siga don kwanciya akan axis x
- Siga don ja-ja
- Siga da ke bayyana girman kumfa
Bari mu ɗauki misali tebur mai zuwa tare da bayanai akan consoles game:
Don gina taswirar kumfa akansa, kuna buƙatar zaɓar kewayo ku 3:E8 (kawai - kawai orange da launin toka sel ba tare da ginshiƙi mai sunaye ba) sannan:
- A cikin Excel 2007/2010 - je zuwa shafin Saka - Group Diagrams - wasu - Bubble (Saka - Chart - Kumfa)
- A cikin Excel 2003 kuma daga baya, zaɓi daga menu Saka - Chart - Kumfa (Saka - Chart - Kumfa)
Taswirar da aka samo za ta nuna saurin akwatunan saiti akan x-axis, adadin shirye-shiryen da aka yi musu akan y-axis, da kasuwar kasuwar da kowane akwatin saiti-saman ya mamaye - kamar girman kumfa:
Bayan ƙirƙirar ginshiƙi na kumfa, yana da ma'ana don saita alamomi don gatari - ba tare da taken gatari ba, yana da wahala a fahimci wanene daga cikinsu aka ƙulla. A cikin Excel 2007/2010, ana iya yin wannan akan shafin Layout (Layout), ko a cikin tsofaffin nau'ikan Excel, ta danna-dama akan ginshiƙi kuma zaɓi Zaɓuɓɓukan Chart (Zaɓuɓɓukan zane) – tab Adadin labarai (Titutuna).
Abin baƙin ciki shine, Excel ba ya ƙyale ka ka ɗaure launi na kumfa ta atomatik zuwa bayanan tushen (kamar yadda yake a cikin misalin da ke sama tare da ƙasashe), amma don tsabta, zaka iya tsara duk kumfa cikin launuka daban-daban. Don yin wannan, danna-dama akan kowane kumfa, zaɓi umarni Tsarin bayanai (Tsarin Tsarin) daga mahallin menu kuma kunna zaɓi ɗigo masu launi (Sababan launuka).
Matsala tare da sa hannu
Wahalar gama gari wacce gaba ɗaya duk masu amfani ke fuskanta lokacin gina kumfa (da watsewa, ta hanya, ma) ginshiƙi alamun kumfa. Yin amfani da daidaitattun kayan aikin Excel, zaku iya nunawa azaman sa hannu kawai ƙimar X, Y, girman kumfa, ko sunan jerin (na kowa ga kowa). Idan kun tuna cewa lokacin gina ginshiƙi na kumfa, ba ku zaɓi ginshiƙi mai lakabi ba, amma ginshiƙai uku ne kawai tare da bayanan X, Y da girman kumfa, to komai ya zama mai ma'ana gabaɗaya: abin da ba a zaɓa ba ba zai iya samu ba. cikin ginshiƙi kanta.
Akwai hanyoyi guda uku don magance matsalar sa hannu:
Hanyar 1. Da hannu
Sake suna da hannu (canza) taken ga kowane kumfa. Za ka iya kawai danna kan akwati tare da taken kuma shigar da sabon suna daga madannai maimakon tsohon. Babu shakka, tare da adadi mai yawa na kumfa, wannan hanya ta fara kama masochism.
Hanya 2: XYChartLabeler add-in
Ba shi da wahala a ɗauka cewa sauran masu amfani da Excel sun fuskanci irin wannan matsala a gabanmu. Kuma daya daga cikinsu, wato fitaccen jarumin nan Rob Bovey (Allah ya jikan shi) ya rubuta kuma ya buga wani karin bayani kyauta ga jama'a. XYChartLabeler, wanda ke ƙara wannan aikin da ya ɓace zuwa Excel.
Kuna iya saukar da add-on anan http://appspro.com/Utilities/ChartLabeler.htm
Bayan shigarwa, za ku sami sabon shafin (a cikin tsoffin juzu'in Excel - Toolbar) Lambobin Chart XY:
Ta hanyar zaɓar kumfa da amfani da maɓallin Ƙara Lakabi za ku iya da sauri da kuma dacewa da ƙara lakabi zuwa duk kumfa a cikin ginshiƙi a lokaci ɗaya, ta hanyar saita kewayon sel tare da rubutu don alamun:
Hanyar 3: Excel 2013
Sabuwar sigar Microsoft Excel 2013 a ƙarshe tana da ikon ƙara lakabi don tsara abubuwan bayanai daga kowane sel da aka zaɓa ba da gangan ba. Mun jira 🙂
