Sparklines mu Microsoft Excel

Sparklines adawonekera koyamba mu Excel 2010 ndipo akhala akutchuka kuyambira pamenepo. Ngakhale mizere yotsetsereka ndi yofanana kwambiri ndi ma chart azithunzi, sizinthu zofanana ndipo zimakhala ndi zolinga zosiyana pang'ono. Mu phunziro ili, tikudziwitsani za sparklines ndikuwonetsani momwe mungagwiritsire ntchito mu Excel workbook.

Pali nthawi zina zomwe muyenera kusanthula ndikuwunika kudalira pa data ya Excel osapanga tchati chathunthu. Sparklines ndi matchati ang'onoang'ono omwe amalowa mu selo limodzi. Chifukwa cha kuphatikizika kwawo, mutha kuphatikiza mizere ingapo nthawi imodzi mubuku limodzi.

M'malo ena, ma sparklines amatchedwa mizere yazidziwitso.

Mitundu ya sparklines

Pali mitundu itatu ya sparklines mu Excel: Sparkline Graph, Sparkline Histogram, ndi Sparkline Win/Loss. Sparkline Plot ndi Sparkline Histogram amagwira ntchito mofanana ndi ziwembu wamba ndi histograms. Mzere wa win/loss sparkline ndi wofanana ndi histogram wamba, koma suwonetsa kukula kwa mtengowo, koma kaya ndi wabwino kapena woipa. Mitundu itatu yonse ya sparklines imatha kuwonetsa zolembera pamalo ofunikira, monga okwera ndi otsika, zomwe zimapangitsa kuti zikhale zosavuta kuwerenga.

Kodi sparklines amagwiritsidwa ntchito chiyani?

Sparklines mu Excel ali ndi maubwino angapo kuposa ma chart okhazikika. Tangoganizani kuti muli ndi tebulo lokhala ndi mizere 1000. Tchati chokhazikika chimatha kupanga 1000 mndandanda wa data, mwachitsanzo mzere umodzi pamzere uliwonse. Ndikuganiza kuti sizovuta kuganiza kuti zidzakhala zovuta kupeza chilichonse pazithunzi zotere. Ndizothandiza kwambiri kupanga mzere wonyezimira wosiyana pamzere uliwonse patebulo la Excel, lomwe lidzakhala pafupi ndi zomwe zachokera, kukulolani kuti muwone ubale ndikusintha padera pamzere uliwonse.

Pachithunzi chomwe chili pansipa, mutha kuwona graph yovuta momwe ndizovuta kupanga chilichonse. Sparklines, kumbali ina, amakulolani kuti muwone bwinobwino malonda a wogulitsa aliyense.

Kuphatikiza apo, ma sparklines ndi opindulitsa mukafuna chithunzithunzi chosavuta cha data ndipo palibe chifukwa chogwiritsa ntchito ma chart ochulukirapo okhala ndi katundu ndi zida zambiri. Ngati mungafune, mutha kugwiritsa ntchito ma graph okhazikika ndi mizere yonyezimira pa data yomweyo.

Kupanga Sparklines mu Excel

Monga lamulo, mzere wonyezimira umodzi umapangidwira pamtundu uliwonse wa data, koma ngati mukufuna, mutha kupanga ma sparklines angapo ndikuyika ngati kuli kofunikira. Njira yosavuta yopangira mzere woyamba wa sparkline ili pamzere wapamwamba kwambiri wa data, ndiyeno gwiritsani ntchito chikhomo chodzaza zokha kuti mukopere mizere yonse yotsalayo. Muchitsanzo chotsatirachi, tipanga tchati chonyezimira kuti tiwone momwe malonda akugulitsira aliyense wogulitsa pa nthawi inayake.

1. Sankhani ma cell omwe adzakhale ngati cholowetsa pa mzere woyamba. Tidzasankha mtundu wa B2: G2.
2. Dinani tabu Ikani ndikusankha mtundu womwe mukufuna wa sparkline. Mwachitsanzo, tchati chonyezimira.
3. A dialog box adzaoneka Kupanga Sparklines. Pogwiritsa ntchito mbewa, sankhani selo kuti muyike mzere wonyezimira, kenako dinani OK. Kwa ife, tidzasankha selo H2, ulalo wa cell udzawonekera m'munda Malo osiyanasiyana.
4. Mzere wonyezimira udzawonekera mu selo yosankhidwa.
5. Dinani ndikugwira batani lakumanzere la mbewa ndikukokera chogwirira chodzaza zokha kuti mukopere mzere wonyezimira kumaselo oyandikana nawo.
6. Sparklines adzawoneka m'mizere yonse ya tebulo. Chithunzi chotsatirachi chikuwonetsa momwe ma sparklines amawonera momwe malonda akugulitsira aliyense wogulitsa m'miyezi isanu ndi umodzi.

Kusintha mawonekedwe a sparklines

Kusintha mawonekedwe a sparkline ndikosavuta. Excel imapereka zida zingapo zochitira izi. Mutha kusintha mawonedwe a zolembera, kuyika mtundu, kusintha mtundu ndi mawonekedwe a sparkline, ndi zina zambiri.

Chiwonetsero cha chikhomo

Mutha kuyang'ana mbali zina za graphline graph pogwiritsa ntchito zolembera kapena mfundo, potero mukuwonjezera chidziwitso chake. Mwachitsanzo, pa sparkline yokhala ndi zikhalidwe zambiri zazikulu ndi zazing'ono, zimakhala zovuta kumvetsetsa kuti ndi imodzi iti yomwe ili yokwanira komanso yocheperako. Ndi zosankha zathandizidwa Maximum point и Malo ochepera zikhale zosavuta.

1. Sankhani mizere yomwe mukufuna kusintha. Ngati aikidwa m'magulu oyandikana nawo, ndiye kuti ndikwanira kusankha aliyense wa iwo kuti asankhe gulu lonse nthawi imodzi.
2. Pa Advanced tabu Constructor mu command group Onetsani yambitsani zosankha Maximum point и Malo ochepera.
3. Mawonekedwe a sparklines adzasinthidwa.

Kusintha masitayelo

1. Sankhani mizere yomwe mukufuna kusintha.
2. Pa Advanced tabu Constructor dinani muvi wotsitsa kuti muwone masitayelo enanso.
3. Sankhani mtundu womwe mukufuna.
4. Mawonekedwe a sparklines adzasinthidwa.

Kusintha kwamtundu

1. Sankhani mizere yomwe mukufuna kusintha.
2. Pa Advanced tabu Constructor sankhani mtundu wa sparkline womwe mukufuna. Mwachitsanzo, tchati cha bar.
3. Mawonekedwe a sparklines adzasinthidwa.

Mtundu uliwonse wa sparkline umapangidwira zolinga zenizeni. Mwachitsanzo, sparkline yopambana / yotayika ndiyoyenera kwambiri pazambiri pomwe pali zabwino kapena zoyipa (mwachitsanzo, ndalama zonse).

Kusintha mawonekedwe

Mwachikhazikitso, sparkline iliyonse mu Excel imayikidwa kuti ifanane ndi kuchuluka kwake komanso kochepa kwambiri komwe kumayambira. Mtengo wapamwamba uli pamwamba pa selo, ndipo osachepera ali pansi. Tsoka ilo, izi sizikuwonetsa kukula kwa mtengowo poyerekeza ndi ma sparklines ena. Excel imakulolani kuti musinthe mawonekedwe a sparklines kuti athe kufanana wina ndi mnzake.

Momwe mungasinthire mawonekedwe owonetsera

1. Sankhani mizere yomwe mukufuna kusintha.
2. Pa Advanced tabu Constructor sankhani timu Axis. Menyu yotsitsa idzawonekera.
3. M'magawo azinthu zazikulu komanso zocheperako motsatana ndi mayendedwe oyima, yambitsani mwayiwo Zokhazikika pama sparklines onse.
4. Sparklines adzasinthidwa. Tsopano angagwiritsidwe ntchito poyerekeza malonda pakati pa oimira malonda.