Zamkatimu
Ambiri mwa iwo omwe adapangapo ma graph mu Microsoft Excel kapena PowerPoint awona mtundu wachilendo komanso woseketsa wa ma chart - ma chart a bubble. Ambiri adaziwona m'mafayilo a anthu ena kapena maulaliki. Komabe, muzochitika za 99 mwa 100, poyesera kupanga chithunzi chotere kwa nthawi yoyamba, ogwiritsa ntchito amakumana ndi zovuta zingapo zosaoneka bwino. Nthawi zambiri, Excel mwina imakana kuyipanga konse, kapena kuipanga, koma m'njira yosamvetsetseka, popanda siginecha ndi kumveka bwino.
Tiyeni tione nkhani imeneyi.
Kodi bubble chart ndi chiyani
Tchati chowira ndi mtundu wina wa tchati womwe ungawonetse deta ya XNUMXD mu danga la XNUMXD. Mwachitsanzo, lingalirani tchatichi chomwe chikuwonetsa ziwerengero malinga ndi dziko kuchokera patsamba lodziwika bwino la opanga ma chart a http://www.gapminder.org/ :
Mutha kutsitsa kukula kwa PDF kuchokera apa http://www.gapminder.org/downloads/gapminder-world-map/
X-axis yopingasa imayimira ndalama zapachaka pa munthu aliyense mu USD. y-axis yoyima imayimira zaka zoyembekezeka za moyo. Kukula (m'mimba mwake kapena dera) kwa kuwira kulikonse kumayenderana ndi kuchuluka kwa dziko lililonse. Motero, n’zotheka kusonyeza mfundo za mbali zitatu pa tchati chimodzi chathyathyathya.
Zowonjezera zambiri zowonjezera zimanyamulidwanso ndi mtundu, womwe umasonyeza mgwirizano wachigawo cha dziko lililonse ku kontinenti inayake.
Momwe mungapangire tchati cha bubble mu Excel
Mfundo yofunika kwambiri pomanga tchati cha bubble ndi tebulo lokonzekera bwino lomwe lili ndi deta yochokera. Mwakutero, tebulo liyenera kukhala ndi magawo atatu motsatira dongosolo ili (kuchokera kumanzere kupita kumanja):
- Parameter yoyika pa x-axis
- Parameter ya y-koka
- Parameter yofotokozera kukula kwa kuwira
Tiyeni titenge mwachitsanzo tebulo ili ndi data pamasewera otonthoza:
Kuti mupange tchati chodulirapo, muyenera kusankha mtundu C3:E8 (makamaka - maselo alalanje ndi imvi okha opanda ndime yokhala ndi mayina) ndiyeno:
- Mu Excel 2007/2010 - pitani ku tabu Ikani - gulu Zithunzi - ena - Bulu (Lowetsani - Tchati - Bulu)
- Mu Excel 2003 ndi kenako, sankhani kuchokera pa menyu Ikani - Tchati - Bubble (Lowetsani - Tchati - Bulu)
Tchati chotsatira chidzawonetsa kuthamanga kwa mabokosi apamwamba pa x-axis, kuchuluka kwa mapulogalamu awo pa y-axis, ndi gawo la msika lomwe limakhala ndi bokosi lililonse lapamwamba - monga kukula kwa thovu:
Pambuyo popanga tchati cha bubble, ndizomveka kukhazikitsa malemba a nkhwangwa - popanda maudindo a nkhwangwa, n'zovuta kumvetsa kuti ndi ndani mwa iwo omwe akukonzedwa. Mu Excel 2007/2010, izi zitha kuchitika pa tabu Kuyika (Mawonekedwe), kapena m'mitundu yakale ya Excel, podina kumanja tchati ndikusankha Zosankha za Tchati (Zosankha zamatchati) – tabu Mitu (Maudindo).
Tsoka ilo, Excel sikukulolani kuti mumangire utoto wa thovu kuzomwe zimayambira (monga momwe zilili pamwambapa ndi mayiko), koma kuti zimveke bwino, mutha kupanga ma thovu onse mwachangu mumitundu yosiyanasiyana. Kuti muchite izi, dinani kumanja pa thovu lililonse, sankhani lamulo Mawonekedwe a mndandanda wa data (Fomati mndandanda) kuchokera ku menyu yachidule ndikuyatsa njirayo madontho okongola (mitundu yosiyanasiyana).
Vuto ndi ma signature
Chovuta chofala chomwe ogwiritsa ntchito onse amakumana nacho pomanga kuwira (ndi kumwaza, mwa njira, nawonso) ma chart ndi zilembo za thovu. Pogwiritsa ntchito zida zokhazikika za Excel, mutha kuwonetsa ngati siginecha zokha za X, Y, kukula kwa thovulo, kapena dzina la mndandanda (odziwika kwa onse). Ngati mukukumbukira kuti pomanga tchati cha thovu, simunasankhe ndime yokhala ndi zilembo, koma mizere itatu yokha yokhala ndi data X, Y ndi kukula kwa thovu, ndiye kuti zonse zimakhala zomveka: zomwe sizinasankhidwe sizingapezeke. ku tchati komwe.
Pali njira zitatu zothetsera vuto la siginecha:
Njira 1. Pamanja
Sinthani pamanja (kusintha) mawu omasulira pamtundu uliwonse. Mutha kungodina pa chidebecho ndi mawu ofotokozera ndikuyika dzina latsopano kuchokera pa kiyibodi m'malo mwa yakale. Mwachiwonekere, ndi kuchuluka kwa thovu, njira iyi imayamba kufanana ndi masochism.
Njira 2: XYChartLabeler add-in
Sizovuta kuganiza kuti ogwiritsa ntchito ena a Excel adakumana ndi vuto lomweli pamaso pathu. Ndipo m'modzi wa iwo, yemwe ndi wodziwika bwino Rob Bovey (Mulungu amudalitse) adalemba ndikuyika chowonjezera chaulere kwa anthu. XYChartLabeler, zomwe zimawonjezera ntchito yosowayi ku Excel.
Mutha kutsitsa zowonjezera apa http://appspro.com/Utilities/ChartLabeler.htm
Mukakhazikitsa, mudzakhala ndi tabu yatsopano (m'mitundu yakale ya Excel - toolbar) XY Tchati Labels:
Mwa kusankha thovu ndi ntchito batani Onjezani Zolemba mutha kuwonjezera zilembo mwachangu komanso mosavuta pazithunzi zonse zomwe zili patchati nthawi imodzi, ndikungoyika ma cell angapo okhala ndi zilembo:
Njira 3: Excel 2013
Mtundu watsopano wa Microsoft Excel 2013 pamapeto pake uli ndi kuthekera kowonjezera zolemba pazithunzi za data kuchokera pamaselo aliwonse osankhidwa mwachisawawa. Tidadikirira 🙂