Vazhinji veavo vakambovaka magirafu muMicrosoft Excel kana PowerPoint vakaona isingawanzo uye inosetsa mhando yemachati - bubble machati. Vazhinji vakazviona mumafaira evamwe vanhu kana mharidzo. Zvisinei, muzviitiko zve99 kubva pa100, pakuedza kuvaka mufananidzo wakadaro kwekutanga, vashandisi vanosangana nematambudziko akawanda asingaonekwi. Kazhinji, Excel inogona kuramba kuigadzira zvachose, kana kuigadzira, asi nenzira isinganzwisisike zvachose, isina siginecha uye kujeka.
Ngatitarisei munyaya iyi.
Chii chinonzi bubble chart
Bubble chati imhando chaiyo yechati inogona kuratidza XNUMXD data munzvimbo yeXNUMXD. Semuyenzaniso, funga iyi chati inoratidza nhamba nenyika kubva panzvimbo inozivikanwa kwazvo yekugadzira machati http://www.gapminder.org/ :
Unogona kudhaunirodha saizi yakazara PDF kubva pano http://www.gapminder.org/downloads/gapminder-world-map/
Iyo yakachinjika x-axis inomiririra avhareji yemari yegore rega rega muUSD. Iyo vertical y-axis inomiririra hupenyu hunotarisirwa mumakore. Saizi (dhayamita kana nharaunda) yebubble rega rega inoenderana nehuwandu hwehuwandu hwenyika imwe neimwe. Saka, zvinokwanisika kuratidza ruzivo rwematatu-dimensional pane imwe flat chart.
Imwezve ruzivo rwekuremerwa inotakurwawo nemuvara, unoratidza mubatanidzwa wedunhu renyika imwe neimwe kune imwe kondinendi.
Maitiro ekugadzira bubble chati muExcel
Chinhu chakanyanya kukosha pakuvaka bubble chati itafura yakanyatsogadzirirwa ine sosi data. Sezvineiwo, tafura inofanirwa kunge ine makoramu matatu muhurongwa hunotevera (kubva kuruboshwe kuenda kurudyi):
- Parameter yekuisa pane x-axis
- Parameter ye y-drag
- Parameter inotsanangura saizi yebubble
Ngatitorei semuenzaniso tafura inotevera ine data pane mutambo consoles:
Kuti ugadzire bubble chart pairi, unofanirwa kusarudza huwandu C3:E8 (chaizvo - chete orenji uye grey maseru asina koramu ine mazita) uyezve:
- MuExcel 2007/2010 - enda kune iyo tab Insert - boka Mifananidzo - vamwe - dhudhumira (Isa - Chati - Bubble)
- MuExcel 2003 uye gare gare, sarudza kubva kumenyu Pinza – Chati – Bubble (Isa - Chati - Bubble)
Chati inozobuda icharatidza kumhanya kwemabhokisi ekumusoro-soro pa-x-axis, huwandu hwezvirongwa zvavo pane y-axis, uye mugove wemusika unogarwa nebhokisi rega rega-repamusoro - sehukuru hwebubble:
Mushure mekugadzira bubble chati, zvinonzwisisika kugadzira zvinyorwa zvemasanhu - pasina mazita emasanhu, zvakaoma kunzwisisa kuti ndeupi wavo akarongwa. MuExcel 2007/2010, izvi zvinogona kuitwa pane tab Maitiro (Magadzirirwo), kana mushanduro dzekare dzeExcel, nekudzvanya-kurudyi chati uye kusarudza Chati Sarudzo (Sarudzo dzechati) – tab Musoro (Mazita).
Nehurombo, Excel haikubvumidze kuti uzvisungirire otomatiki ruvara rwemabhuru kune iyo sosi data (semumuenzaniso uri pamusoro nenyika), asi kuti ujekese, unogona kukurumidza kufomati mabhuru ese mune akasiyana mavara. Kuti uite izvi, tinya-kurudyi pane chero bubble, sarudza kuraira Data series format (Format series) kubva pane yemukati menyu uye gonesa iyo sarudzo mavara ane mavara (Vary colours).
Dambudziko nemasaini
Dambudziko rakajairwa iro vese vashandisi vanotarisana naro kana vachivaka bubble (uye kuparadzira, nenzira, zvakare) machati mazita emabhuru. Uchishandisa maturusi eExcel akajairwa, unogona kuratidza semasiginicha chete X, Y kukosha, saizi yebubble, kana zita renhevedzano (yakajairika kune vese). Kana iwe ukayeuka kuti pakuvaka bhurocha chati, iwe hauna kusarudza koramu ine mavara, asi matatu chete makoramu ane data X, Y uye saizi yemabhubhu, ipapo zvese zvinoshanduka kuve zvine musoro: izvo zvisina kusarudzwa hazvigone kuwana. muchati chaimo.
Pane nzira nhatu dzekugadzirisa dambudziko remasaini:
Nzira 1. Nemaoko
Pamaoko rename (shandura) zvinyorwa zvebubble rega rega. Iwe unogona kungodzvanya pamudziyo une chinyorwa uye woisa zita idzva kubva pane keyboard pane yekare. Zviripachena, nenhamba yakawanda yemabhuru, nzira iyi inotanga kufanana nemasochism.
Nzira 2: XYChartLabeler yekuwedzera-mukati
Hazvina kuoma kufunga kuti vamwe vashandisi veExcel vakasangana nedambudziko rakafanana pamberi pedu. Uye mumwe wavo, anonzi ane mukurumbira Rob Bovey (Mwari vamuropafadze) akanyora uye akatumira yemahara yekuwedzera kune veruzhinji. XYChartLabeler, iyo inowedzera ichi chisipo basa kuExcel.
Unogona kudhawunirodha yekuwedzera pano http://appspro.com/Utilities/ChartLabeler.htm
Mushure mekuisa, iwe uchave neiyo tebhu nyowani (mune ekare mavhezheni eExcel - toolbar) XY Chart Labels:
Nekusarudza mabhuru uye kushandisa bhatani Wedzera Labels unogona kukurumidza uye zviri nyore kuwedzera mavara kune ese mabhubhu muchati kamwechete, nekungoisa huwandu hwemasero ane mavara ezvinyorwa:
Nzira 3: Excel 2013
Iyo nyowani vhezheni yeMicrosoft Excel 2013 pakupedzisira ine kugona kuwedzera mavara kune chati data data kubva kune chero akasarudzika akasarudzwa maseru. Takamirira 🙂
