Boholo ba ba kileng ba haha li-graph ho Microsoft Excel kapa PowerPoint ba hlokometse mofuta o sa tloaelehang le o qabolang oa lichate - li-bubble charts. Ba bangata ba li bone lifaeleng tsa batho ba bang kapa lipuong. Leha ho le joalo, maemong a 99 ho a 100, ha a leka ho haha setšoantšo se joalo ka lekhetlo la pele, basebelisi ba kopana le mathata a mangata a sa bonahaleng. Hangata, Excel e hana ho e etsa ho hang, kapa ea e theha, empa ka mokhoa o sa utloisiseheng ka ho felletseng, ntle le lipontšo le ho hlaka.
Ha re shebeng taba ena.
Chate ea bubble ke eng
Chate ea bubble ke mofuta o ikhethileng oa chate o ka bonts'ang data ea XNUMXD sebakeng sa XNUMXD. Ka mohlala, nahana ka chate ena e bontšang lipalo-palo ho ea ka linaha ho tsoa sebakeng se tsebahalang sa moqapi oa lichate http://www.gapminder.org/ :
U ka khoasolla boholo bo felletseng ba PDF ho tsoa mona http://www.gapminder.org/downloads/gapminder-world-map/
X-axis e tšekaletseng e emela chelete e tloaelehileng ea selemo le selemo ho motho ka mong ho USD. Mothalo wa y-axis o emetse tebello ya bophelo ka dilemo. Boholo (bophara kapa sebaka) ba bubble ka 'ngoe bo lekana le baahi ba naha ka 'ngoe. Kahoo, hoa khoneha ho hlahisa boitsebiso ba mahlakore a mararo chateng e le ’ngoe e bataletseng.
Phatlalatso e eketsehileng ea tlhahisoleseding e boetse e tsamaisoa ke 'mala, o bontšang ho kopana ha libaka tsa naha ka' ngoe ho ea k'honthinenteng e itseng.
Mokhoa oa ho theha chate ea bubble ho Excel
Ntlha ea bohlokoa ka ho fetisisa ea ho haha chate ea bubble ke tafole e lokiselitsoeng hantle e nang le lintlha tsa mohloli. Ka mantsoe a mang, tafole e tlameha ho ba le litšiea tse tharo ka tatellano e latelang (ho tloha ho le letšehali ho ea ho le letona):
- Paramethara ea ho beha holim'a x-axis
- Paramethara bakeng sa y-hula
- Paramethara e hlalosang boholo ba bubble
Ha re nke mohlala ka tafole e latelang e nang le lintlha tsa li-consoles tsa lipapali:
Ho aha chate ea bubble ho eona, o hloka ho khetha mefuta C3:E8 (ka ho hlaka - ke lisele tsa lamunu le tse bohlooho feela tse se nang kholomo e nang le mabitso) ebe:
- Ho Excel 2007/2010 - ea ho tab kenya - Group Litšoantšo - Ba bang ba - Bubble (Kenya — Chate — Bubble)
- Ho Excel 2003 le hamorao, khetha ho tsoa ho menu Kenya – Chate – Bubble (Kenya — Chate — Bubble)
Chate e hlahisoang e tla bonts'a lebelo la li-set-top boxes ho x-axis, palo ea mananeo a tsona ho y-axis, le karolo ea 'maraka e sebelisoang ke lebokose le leng le le leng la set-top - joalo ka boholo ba bubble:
Ka mor'a ho theha chate ea bubble, hoa utloahala ho theha mangolo bakeng sa lilepe - ntle le litlotla tsa lilepe, ho thata ho utloisisa hore na ke efe ea tsona e reriloeng. Ho Excel 2007/2010, sena se ka etsoa ho tab moralo (Mohaho), kapa liphetolelong tsa khale tsa Excel, ka ho tobetsa chate le ho khetha Likhetho tsa Chate (Likhetho tsa chate) – tab Lihlooho tsa litaba (Litlotla).
Ka bomalimabe, Excel ha e u lumelle hore u tlamelle 'mala oa li-bubble ka mokhoa o ikemetseng ho data ea mohloli (joalo ka mohlala o ka holimo le linaha), empa bakeng sa ho hlaka, o ka fomata li-bubble tsohle ka mebala e sa tšoaneng. Ho etsa sena, tobetsa ka ho le letona ho bubble efe kapa efe, khetha taelo Sebopeho sa lethathamo la data (Format series) ho tsoa ho li-menu tsa moelelo ebe o nolofalletsa khetho matheba a mebala-bala (Fapana ka mebala).
Bothata ba mesaeno
Bothata bo tloaelehileng boo basebelisi bohle ba tobanang le bona ha ba haha bubble (le ho hasanya, ka tsela, hape) lichate ke lileibole bakeng sa li-bubble. U sebelisa lisebelisoa tse tloaelehileng tsa Excel, u ka bonts'a e le li-signature feela boleng ba X, Y, boholo ba bubble, kapa lebitso la letoto (le tloaelehileng ho bohle). Haeba u hopola hore ha u theha chate ea bubble, ha ua khetha kholomo e nang le mangolo, empa ke litšiea tse tharo feela tse nang le data X, Y le boholo ba li-bubble, joale ntho e 'ngoe le e' ngoe e fetoha e utloahalang ka kakaretso: se sa khethoang se ke ke sa fumanoa. ho kena chate ka boeona.
Ho na le mekhoa e meraro ea ho rarolla bothata ba li-signature:
Mokhoa oa 1. Ka letsoho
Ka bouena reha mabitso a mang (fetola) bakeng sa bubble ka 'ngoe. U ka tobetsa feela sets'oants'o se nang le mongolo ebe u kenya lebitso le lecha ho keyboard ho fapana le la khale. Ho hlakile hore ka palo e kholo ea li-bubble, mokhoa ona o qala ho tšoana le masochism.
Mokhoa oa 2: XYChartLabeler add-in
Ha ho thata ho nahana hore basebelisi ba bang ba Excel ba kile ba kopana le bothata bo tšoanang ka pel'a rona. 'Me e mong oa bona, e leng Rob Bovey ea tummeng (Molimo a mo hlohonolofatse) o ngotse mme a beha kenyelletso ea mahala ho sechaba. XYChartLabeler, e leng se eketsang mosebetsi ona o sieo ho Excel.
U ka khoasolla tlatsetso mona http://appspro.com/Utilities/ChartLabeler.htm
Kamora ho kenya, o tla ba le tabo e ncha (liphetolelong tsa khale tsa Excel - toolbar) XY Chate Labels:
Ka ho khetha li-bubble le ho sebelisa konopo Kenya Labels o ka kenya lileibole kapele le ha bonolo ho li-bubble tsohle tse chate hang, feela ka ho beha mefuta e fapaneng ea lisele tse nang le mongolo bakeng sa lileibole:
Mokhoa oa 3: Excel 2013
Mofuta o mocha oa Microsoft Excel 2013 qetellong o na le bokhoni ba ho eketsa lileibole ho chate likarolo tsa data ho tsoa liseleng life kapa life tse khethiloeng ka tšohanyetso. Re ile ra leta 🙂