Iningi lalabo abake bakhe amagrafu ku-Microsoft Excel noma i-PowerPoint baye baqaphela uhlobo lwamashadi olungajwayelekile noluhlekisayo - amashadi we-bubble. Abaningi bawabonile kumafayela abanye abantu noma izethulo. Kodwa-ke, ezimweni ezingu-99 kwezingu-100, lapho uzama ukwakha umdwebo onjalo okokuqala, abasebenzisi bahlangabezana nenani lezinkinga ezingabonakali. Ngokuvamile, i-Excel iyenqaba ukuyidala nhlobo, noma iyakha, kodwa ngendlela engaqondakali ngokuphelele, ngaphandle kwamasignesha nokucaca.
Ake sibheke lesi sihloko.
Liyini ishadi lebhamuza
Ishadi lebhamuza wuhlobo oluthile lweshadi elingabonisa idatha ye-XNUMXD esikhaleni se-XNUMXD. Ngokwesibonelo, cabanga ngaleli shadi elibonisa izibalo ngezwe elivela kusayithi elaziwa kakhulu lomklami weshadi elithi http://www.gapminder.org/ :
Ungadawuniloda usayizi ogcwele we-PDF lapha http://www.gapminder.org/downloads/gapminder-world-map/
I-x-eksisi evundlile imelela isilinganiso semali engenayo yomuntu ngamunye ngama-USD. I-axis ka-y emile imelela ubude bempilo ngeminyaka. Usayizi (ububanzi noma indawo) yebhamuza ngalinye lilingana nenani labantu bezwe ngalinye. Ngakho-ke, kungenzeka ukubonisa ulwazi lwezinhlangothi ezintathu eshadini elilodwa eliyisicaba.
Umthwalo ongeziwe wolwazi nawo uthwalwa ngumbala, obonisa ukuhlangana kwesifunda kwezwe ngalinye ezwenikazi elithile.
Ungalakha kanjani ishadi lebhamuza ku-Excel
Iphuzu elibaluleke kakhulu ekwakheni ishadi lebhamuza itafula elilungiswe kahle elinedatha yomthombo. Okungukuthi, ithebula kufanele libe namakholomu amathathu ngokuqinile ngokulandelana (kusuka kwesokunxele kuye kwesokudla):
- Ipharamitha yokubeka ku-x-eksisi
- Ipharamitha ye-y-drag
- Ipharamitha echaza usayizi webhamuza
Ake sithathe isibonelo ithebula elilandelayo elinedatha yamakhonsoli egeyimu:
Ukuze wakhe ishadi lebhamuza kulo, udinga ukukhetha ububanzi C3:E8 (ngokuqondile - amaseli awolintshi kuphela nampunga ngaphandle kwekholomu enamagama) bese:
- Ku-Excel 2007/2010 - yiya kuthebhu Faka - Group Imidwebo - Abanye - Ibhola (Faka — Ishadi — Ibhamuza)
- Ku-Excel 2003 nakamuva, khetha kumenyu Faka – Ishadi – Ibhamuza (Faka — Ishadi — Ibhamuza)
Ishadi eliwumphumela lizobonisa isivinini samabhokisi aphezulu ku-x-eksisi, inani lezinhlelo zawo ku-y-eksisi, kanye nesabelo semakethe esithathwa yibhokisi ngalinye le-set-top - njengosayizi webhamuza:
Ngemva kokudala ishadi lebhamuza, kunengqondo ukusetha amalebula ezimbazo - ngaphandle kwezihloko zezimbazo, kunzima ukuqonda ukuthi iyiphi yazo ehleliwe. Ku-Excel 2007/2010, lokhu kungenziwa kuthebhu Isakhiwo (Isakhiwo), noma ezinguqulweni ezindala ze-Excel, ngokuchofoza kwesokudla ishadi nokukhetha Izinketho Zeshadi (Izinketho zeshadi) – ithebhu Izihloko (Izihloko).
Ngeshwa, i-Excel ayikuvumeli ukuthi ubophe ngokuzenzakalelayo umbala wamabhamuza kudatha yomthombo (njengakusibonelo esingenhla namazwe), kodwa ukuze kucace, ungafometha ngokushesha wonke amabhamuza ngemibala ehlukene. Ukuze wenze lokhu, chofoza kwesokudla kunoma iyiphi ibhamuza, khetha umyalo Ifomethi yochungechunge lwedatha (Fometha uchungechunge) kusuka kumenyu yokuqukethwe bese unika amandla inketho amachashazi anemibala (Imibala ehlukahlukene).
Inkinga namasignesha
Ubunzima obujwayelekile bonke abasebenzisi ababhekana nabo lapho bakha ibhamuza (futhi bahlakaze, kanjalo, futhi) amashadi amalebula amabhamuza. Usebenzisa amathuluzi e-Excel ajwayelekile, ungabonisa njengamasiginesha kuphela amanani we-X, Y, usayizi webhamuza, noma igama lochungechunge (okujwayelekile kubo bonke). Uma ukhumbula ukuthi lapho wakha ishadi lebhamuza, awukhethanga ikholomu enamalebula, kodwa amakholomu amathathu kuphela anedatha X, Y kanye nosayizi wamabhamuza, khona-ke yonke into iba ngokunengqondo: okungakhethiwe ngeke kutholwe. eshadini ngokwalo.
Kunezindlela ezintathu zokuxazulula inkinga yamasignesha:
Indlela 1. Ngesandla
Qamba kabusha ngesandla (shintsha) amagama-ncazo ebhamuza ngalinye. Ungavele uchofoze esiqukathini esinamagama-ncazo bese ufaka igama elisha elisuka kukhibhodi esikhundleni selidala. Ngokusobala, ngenani elikhulu lama-bubbles, le ndlela iqala ukufana ne-masochism.
Indlela 2: Isengezo se-XYChartLabeler
Akunzima ukucabanga ukuthi abanye abasebenzisi be-Excel bahlangabezane nenkinga efanayo phambi kwethu. Futhi omunye wabo, okungu-Rob Bovey (uNkulunkulu ambusise) wabhala futhi wathumela isengezo samahhala emphakathini. XYChartLabeler, okwengeza lo msebenzi ongekho ku-Excel.
Ungalanda isengezo lapha http://appspro.com/Utilities/ChartLabeler.htm
Ngemva kokufaka, uzoba nethebhu entsha (ezinguqulweni ezindala ze-Excel - ibha yamathuluzi) Amalebula Eshadi le-XY:
Ngokukhetha amabhamuza nokusebenzisa inkinobho Engeza Amalebula ungakwazi ukwengeza amalebula ngokushesha nakalula kuwo wonke amabhamuza eshadi ngesikhathi esisodwa, ngokumane uhlele ububanzi bamaseli ngombhalo wamalebula:
Indlela 3: I-Excel 2013
Inguqulo entsha ye-Microsoft Excel 2013 ekugcineni inekhono lokwengeza amalebula eshadini izici zedatha kusuka kunoma imaphi amaseli akhethwe ngokungahleliwe. Silindile 🙂
