Contents
Sparklines sun fara bayyana a cikin Excel 2010 kuma suna girma cikin shahara tun daga lokacin. Ko da yake sparklines sun yi kama da ginshiƙan thumbnail, ba abu ɗaya ba ne kuma suna da wasu dalilai daban-daban. A cikin wannan koyawa, za mu gabatar muku da layukan walƙiya kuma mu nuna muku yadda ake amfani da su a cikin littafin aikin Excel.
Akwai lokutan da kuke buƙatar yin nazari da bincika dogaro a cikin bayanan bayanan Excel ba tare da ƙirƙirar cikakken ginshiƙi ba. Sparklines ƙananan ginshiƙi ne waɗanda suka dace cikin tantanin halitta ɗaya. Saboda ƙaƙƙarfan su, zaku iya haɗa lambobi da yawa lokaci ɗaya a cikin littafin aiki ɗaya.
A wasu kafofin, ana kiran sparklines layin bayanai.
Nau'in kyalkyali
Akwai nau'ikan walƙiya iri uku a cikin Excel: Sparkline Graph, Sparkline Histogram, da Sparkline Win/Loss. Sparkline Plot da Sparkline Histogram suna aiki daidai da filaye na al'ada da tarihin tarihi. Lashe nasara/asara yana kama da daidaitaccen tarihin tarihi, amma baya nuna girman ƙimar, amma ko yana da inganci ko mara kyau. Duk nau'ikan walƙiya guda uku na iya nuna alamomi a wurare masu mahimmanci, kamar masu tsayi da ƙasa, suna sa su sauƙin karantawa.
Menene sparklines ake amfani dashi?
Sparklines a cikin Excel suna da fa'idodi da yawa akan sigogi na yau da kullun. Ka yi tunanin kana da tebur mai layuka 1000. Madaidaicin ginshiƙi zai tsara jerin bayanai 1000, watau jere ɗaya don kowane layi. Ina tsammanin ba shi da wahala a yi tsammani cewa zai yi wuya a sami wani abu a irin wannan zane. Yana da matukar inganci don ƙirƙirar keɓaɓɓen walƙiya don kowane jere a cikin tebur na Excel, wanda zai kasance kusa da bayanan tushen, yana ba ku damar ganin alaƙar da yanayin daban don kowane jere.
A cikin hoton da ke ƙasa, zaku iya ganin jadawali mai ban sha'awa wanda a cikinsa yana da wahala a fitar da wani abu. Sparklines, a gefe guda, suna ba ku damar bin diddigin tallace-tallace na kowane wakilin tallace-tallace.
Bugu da ƙari, sparklines suna da fa'ida lokacin da kuke buƙatar taƙaitaccen bayani game da bayanan kuma babu buƙatar amfani da ginshiƙai masu yawa tare da kaddarorin da kayan aiki da yawa. Idan kuna so, zaku iya amfani da hotuna na yau da kullun da layukan walƙiya don bayanai iri ɗaya.
Ƙirƙirar Sparklines a cikin Excel
A matsayinka na mai mulki, an gina layin walƙiya ɗaya don kowane jerin bayanai, amma idan kuna so, zaku iya ƙirƙirar kowane adadin walƙiya kuma sanya su a inda ya cancanta. Hanya mafi sauƙi don ƙirƙirar layi na farko shine a saman jere na bayanai, sannan a yi amfani da alamar cikawa ta atomatik don kwafe shi zuwa duk sauran layuka. A cikin misali mai zuwa, za mu ƙirƙiri ginshiƙi mai walƙiya don ganin yanayin haɓakar tallace-tallace na kowane mai tallan tallace-tallace a kan takamaiman lokaci.
- Zaɓi sel waɗanda zasu yi aiki azaman shigarwa don layin farko. Za mu zaɓi kewayon B2:G2.
- Danna shafin Saka kuma zaɓi nau'in walƙiya da ake so. Misali, ginshiƙi mai walƙiya.
- Akwatin maganganu zai bayyana Ƙirƙirar Sparklines. Yin amfani da linzamin kwamfuta, zaɓi tantanin halitta don sanya layin walƙiya, sannan danna OK. A cikin yanayinmu, za mu zaɓi cell H2, hanyar haɗi zuwa tantanin halitta zai bayyana a cikin filin Kewayon wuri.
- Layin walƙiya zai bayyana a cikin tantanin halitta da aka zaɓa.
- Danna ka riƙe maɓallin linzamin kwamfuta na hagu kuma ja hannun rigar cikawa don kwafi layin walƙiya zuwa sel kusa.
- Layukan spark zasu bayyana a duk layuka na tebur. Hoto na gaba yana nuna yadda layukan walƙiya ke hango yanayin tallace-tallace na kowane wakilin tallace-tallace a cikin tsawon watanni shida.
Canja bayyanar kyalkyali
Daidaita bayyanar walƙiya abu ne mai sauƙi. Excel yana ba da kayan aiki da yawa don wannan dalili. Kuna iya tsara nunin alamomi, saita launi, canza nau'in da salon walƙiya, da ƙari mai yawa.
Nuni mai alama
Kuna iya mayar da hankali kan wasu wurare na jadawali ta amfani da alamomi ko maki, don haka ƙara bayanin sa. Misali, akan layin kyalkyali mai yawa manya da kanana dabi'u, yana da matukar wahala a gane wanne ne mafi girman kuma wanne ne mafi karanci. Tare da kunna zaɓuɓɓuka Matsakaicin matsayi и Mafi ƙarancin batu yi shi da sauki.
- Zaɓi layukan walƙiya da kuke son canzawa. Idan an haɗa su a cikin sel makwabta, to ya isa a zaɓi ɗaya daga cikinsu don zaɓar ƙungiyar gaba ɗaya.
- A kan Babba shafin Constructor a cikin rukunin umarni show ba da damar zaɓuɓɓuka Matsakaicin matsayi и Mafi ƙarancin batu.
- Za a sabunta bayyanar sparklines.
Canjin salo
- Zaɓi layukan walƙiya da kuke son canzawa.
- A kan Babba shafin Constructor danna kan zazzage kibiya don ganin ƙarin salo.
- Zaɓi salon da ake so.
- Za a sabunta bayyanar sparklines.
Nau'in canji
- Zaɓi layukan walƙiya da kuke son canzawa.
- A kan Babba shafin Constructor zaɓi nau'in walƙiya da kuke so. Misali, ginshiƙi na banki.
- Za a sabunta bayyanar sparklines.
Kowane nau'in walƙiya an tsara shi don takamaiman dalilai. Misali, layin cin nasara/asara ya fi dacewa da bayanai inda akwai halaye masu kyau ko mara kyau (misali, samun kudin shiga).
Canza kewayon nuni
Ta hanyar tsohuwa, kowane layin walƙiya a cikin Excel ana ƙididdige shi don dacewa da matsakaicin matsakaici da mafi ƙarancin ƙimar bayanan tushen sa. Matsakaicin ƙimar yana saman tantanin halitta, kuma mafi ƙarancin yana a ƙasa. Abin takaici, wannan baya nuna girman ƙimar idan aka kwatanta da sauran layukan walƙiya. Excel yana ba ku damar canza bayyanar sparklines ta yadda za a iya kwatanta su da juna.
Yadda ake canza kewayon nuni
- Zaɓi layukan walƙiya da kuke son canzawa.
- A kan Babba shafin Constructor zaɓi ƙungiya axis. Menu mai saukewa zai bayyana.
- A cikin sigogi don matsakaicin da ƙananan ƙima tare da axis na tsaye, kunna zaɓi Kafaffen don duk layukan walƙiya.
- Za a sabunta layin Sparklines. Yanzu ana iya amfani da su don kwatanta tallace-tallace tsakanin wakilan tallace-tallace.