Okuqukethwe
I-Sparklines yaqala ukuvela ku-Excel 2010 futhi ibilokhu ikhula ngokuduma kusukela ngaleso sikhathi. Nakuba imigqa ye-spark ifana kakhulu namashadi ezithonjana, ayiyona into efanayo futhi inezinjongo ezihluke kancane. Kulesi sifundo, sizokwethula imigqa ye-sparkline futhi sikubonise ukuthi uyisebenzisa kanjani encwadini yokusebenzela ye-Excel.
Kunezikhathi lapho udinga ukuhlaziya futhi uhlole ukuncika kudathasethi ye-Excel ngaphandle kokudala ishadi eliphelele. Olayini bezinhlansi amashadi amancane angena kuseli eyodwa. Ngenxa yokubumbana kwazo, ungafaka izinhlansi ezimbalwa ngesikhathi esisodwa ebhukwini lokusebenza elilodwa.
Kweminye imithombo, kubizwa ngokuthi ama-sparklines imigqa yolwazi.
Izinhlobo zolayini bezinhlansi
Kunezinhlobo ezintathu zemigqa yenhlansi ku-Excel: Igrafu ye-Sparkline, i-Sparkline Histogram, kanye ne-Sparkline Win/Loss. I-Sparkline Plot kanye ne-Sparkline Histogram zisebenza ngendlela efanayo neziqephu ezivamile nama-histogram. I-sparkline yokuwina/ukulahlekelwa iyafana ne-histogram evamile, kodwa ayibonisi ubukhulu bevelu, kodwa noma ngabe iphozithivu noma inegethivu. Zontathu izinhlobo ze-sparklines zingabonisa omaka ezindaweni ezibalulekile, ezifana nokuphakama nokwehla, okubenza kube lula kakhulu ukuzifunda.
I-sparklines isetshenziselwa ini?
Imigqa ye-Sparkline ku-Excel inezinzuzo eziningi ngaphezu kwamashadi avamile. Cabanga ukuthi unetafula elinemigqa eyi-1000. Ishadi elijwayelekile lingahlela uchungechunge lwedatha engu-1000, okungukuthi umugqa owodwa womugqa ngamunye. Ngicabanga ukuthi akunzima ukuqagela ukuthi kuzoba nzima ukuthola noma yini kumdwebo onjalo. Kusebenza kahle kakhulu ukudala inhlansi ehlukile yomugqa ngamunye kuthebula le-Excel, elizotholakala eduze kwedatha yomthombo, okukuvumela ukuthi ubone ngeso lengqondo ubudlelwano kanye nethrendi ngokwehlukana kumugqa ngamunye.
Emfanekisweni ongezansi, ungabona igrafu enzima lapho okunzima khona ukwenza noma yini. I-Sparklines, ngakolunye uhlangothi, ikuvumela ukuthi ulandelele ngokucacile ukuthengiswa kommeleli ngamunye wokuthengisa.
Ngaphezu kwalokho, imigqa ye-sparkline inenzuzo uma udinga ukubuka konke okulula kwedatha futhi asikho isidingo sokusebenzisa amashadi amakhulu anezakhiwo namathuluzi amaningi. Uma uthanda, ungasebenzisa kokubili amagrafu avamile kanye nemigqa ye-spark kudatha efanayo.
Ukudala i-Sparklines ku-Excel
Njengomthetho, i-sparkline eyodwa yakhelwe uchungechunge lwedatha ngayinye, kodwa uma ufisa, ungakha noma iyiphi inombolo ye-sparklines futhi uyibeke lapho kunesidingo. Indlela elula yokudala i-sparkline yokuqala iserowuni ephezulu kakhulu yedatha, bese usebenzisa umaka wokugcwalisa okuzenzakalelayo ukuze uwukopishele kuyo yonke imigqa esele. Esibonelweni esilandelayo, sizodala ishadi le-sparkline ukuze sibone ngeso lengqondo amandla okuthengisa kumthengisi ngamunye ngesikhathi esithile.
- Khetha amaseli azosebenza njengokufakwayo komugqa wenhlansi wokuqala. Sizokhetha uhla B2:G2.
- Chofoza ithebhu Faka bese ukhetha uhlobo olufunayo lwe-sparkline. Isibonelo, ishadi lomugqa wenhlansi.
- Ibhokisi lengxoxo lizovela Ukudala iSparklines. Usebenzisa igundane, khetha iseli ukuze ubeke umugqa wenhlansi, bese uchofoza OK. Esimweni sethu, sizokhetha iseli H2, isixhumanisi seseli sizovela ensimini Ibanga lendawo.
- Umugqa wenhlansi uzovela kuseli elikhethiwe.
- Chofoza futhi ubambe inkinobho yegundane kwesokunxele bese uhudula isibambo sokugcwalisa ngokuzenzakalela ukuze ukopishele umugqa wenhlansi kumaseli aseduze.
- Imigqa yezinhlansi izovela kuyo yonke imigqa yethebula. Isibalo esilandelayo sibonisa ukuthi i-sparklines ibona kanjani izitayela zokuthengisa zomthengisi ngamunye esikhathini esiyizinyanga eziyisithupha.
Shintsha ukubukeka kolayini benhlansi
Ukulungisa ukubukeka kwe-sparkline kulula kakhulu. I-Excel inikeza uhla lwamathuluzi ale njongo. Ungenza ngendlela oyifisayo ukuboniswa komaka, usethe umbala, ushintshe uhlobo nesitayela se-sparkline, nokunye okuningi.
Isibonisi somaka
Ungagxila ezindaweni ezithile zegrafu ye-sparkline usebenzisa omaka noma amaphuzu, ngaleyo ndlela wandise ulwazi lwayo. Isibonelo, emgqeni we-sparkline onamanani amaningi amakhulu namancane, kunzima kakhulu ukuqonda ukuthi yikuphi okuphezulu nokuthi yikuphi okuncane. Ngezinketho ezinikwe amandla Iphoyinti eliphezulu и Iphuzu elincane yenza kube lula kakhulu.
- Khetha imigqa ye-spark ofuna ukuyishintsha. Uma ziqoqwe kumaseli angomakhelwane, kwanele ukukhetha noma iyiphi yazo ukuze ukhethe lonke iqembu ngesikhathi esisodwa.
- Kuthebhu ethuthukisiwe umakhi eqenjini lomyalo Bonisa vumela izinketho Iphoyinti eliphezulu и Iphuzu elincane.
- Ukubukeka kolayini bezinhlansi kuzobuyekezwa.
Ukushintsha isitayela
- Khetha imigqa ye-spark ofuna ukuyishintsha.
- Kuthebhu ethuthukisiwe umakhi chofoza kumcibisholo owehlayo ukuze ubone izitayela ezengeziwe.
- Khetha isitayela osithandayo.
- Ukubukeka kolayini bezinhlansi kuzobuyekezwa.
Thayipha ushintsho
- Khetha imigqa ye-spark ofuna ukuyishintsha.
- Kuthebhu ethuthukisiwe umakhi khetha uhlobo lwe-sparkline oyifunayo. Ngokwesibonelo, ishadi lebha.
- Ukubukeka kolayini bezinhlansi kuzobuyekezwa.
Uhlobo ngalunye lwe-sparkline luklanyelwe izinjongo ezithile. Isibonelo, i-win/loss sparkline ifaneleka kakhulu kudatha lapho kunamanani amahle noma angalungile (isibonelo, imali yonke engenayo).
Ukushintsha ububanzi bokubonisa
Ngokuzenzakalelayo, i-sparkline ngayinye ku-Excel ikalwa ukuze ifane namanani aphezulu nobuncane bedatha yomthombo wayo. Inani eliphakeme lingaphezulu kweseli, futhi inani elincane lingezansi. Ngeshwa, lokhu akubonisi ubukhulu bevelu uma kuqhathaniswa nezinye imigqa yezinhlansi. I-Excel ikuvumela ukuthi uguqule ukubukeka kwemigqa ye-sparkline ukuze iqhathaniswe nenye.
Ungashintsha kanjani ibanga lokubonisa
- Khetha imigqa ye-spark ofuna ukuyishintsha.
- Kuthebhu ethuthukisiwe umakhi khetha iqembu Axis. Imenyu yokudonsela phansi izovela.
- Kumapharamitha wamanani aphezulu nobuncane ahambisana ne-eksisi eqondile, nika amandla inketho Ilungiselwe zonke imigqa yezinhlansi.
- I-Sparklines izobuyekezwa. Manje zingasetshenziswa ukuqhathanisa ukuthengisa phakathi kwabamele ukuthengisa.