Mukati
Sparklines yakatanga kuoneka muExcel 2010 uye yanga ichikura mukuzivikanwa kubva ipapo. Kunyangwe mitsara yakatsvuka yakafanana zvikuru nemachati echigunwe, haasi chinhu chimwe chete uye ane zvinangwa zvakasiyana zvishoma. Muchidzidzo ichi, tichakuzivisa iwe kune sparklines uye tokuratidza mashandisiro aungaita muExcel workbook.
Pane nguva dzaunofanirwa kuongorora uye kuongorora kutsamira muExcel dataset pasina kugadzira chati yakazara. Sparklines machati madiki anokwana musero rimwechete. Nekuda kwekubatana kwavo, unogona kusanganisira akati wandei ma sparklines kamwechete mubhuku rimwe rebasa.
Mune dzimwe nzvimbo, sparklines vanonzi mitsara yeruzivo.
Mhando dze sparklines
Kune marudzi matatu esparklines muExcel: Sparkline Graph, Sparkline Histogram, uye Sparkline Win/Loss. Sparkline Plot uye Sparkline Histogram inoshanda nenzira imwechete seyakajairwa zvirongwa uye histograms. Kuhwina/kurasikirwa kupenya kwakafanana neyakajairwa histogram, asi hairatidzi ukuru hwekukosha, asi ingave yakanaka kana yakaipa. Ese matatu marudzi esparklines anogona kuratidza mamaki panzvimbo dzakakosha, senge dzakakwirira uye dzakaderera, zvichiita kuti zvive nyore kuverenga.
Chii chinonzi sparklines chinoshandiswa?
Sparklines muExcel ine akati wandei mabhenefiti pane akajairwa machati. Fungidzira uine tafura ine mitsara zana. Chati yakajairwa inoronga 1000 data series, kureva mutsara mumwe pamutsara wega wega. Ndinofunga kuti hazvina kuoma kufungidzira kuti zvichave zvakaoma kuwana chero chinhu pamufananidzo wakadaro. Izvo zvakanyanya kunyatso shanda kugadzira sparkline yakaparadzana yemutsara wega wega muExcel tafura, iyo ichave iri padivi peiyo sosi data, ichikubvumidza iwe kuona nekuona hukama uye mafambiro zvakasiyana pamutsara wega wega.
Mumufananidzo uri pazasi, iwe unogona kuona girafu rinorema umo zvakaoma kugadzira chero chinhu. Sparklines, kune rumwe rutivi, inokubvumira kuti uone zvakajeka kutengesa kwemumiririri wega wega wekutengesa.
Uye zvakare, sparklines inobatsira kana iwe uchida ongororo yakapusa yedata uye hapana chikonzero chekushandisa machati akakura ane akawanda zvivakwa uye maturusi. Kana uchida, unogona kushandisa ese akajairwa magirafu uye sparklines kune imwechete data.
Kugadzira Sparklines muExcel
Semutemo, imwe sparkline inovakwa kune yega yega data nhevedzano, asi kana uchida, iwe unogona kugadzira chero nhamba ye sparklines uye woiisa pazvinenge zvichidikanwa. Nzira iri nyore yekugadzira yekutanga sparkline iri pamutsetse wepamusoro wedata, wobva washandisa iyo autofill marker kuikopa kune yese mitsara yasara. Mumuenzaniso unotevera, isu tichagadzira sparkline chati yekuona matengesi ekutengesa kune yega yega mutengesi rep pane yakatarwa nguva yenguva.
- Sarudza maseru anozoshanda sekuisa kune yekutanga sparkline. Tichasarudza mhando B2: G2.
- Dzvanya iyo tab Insert uye sarudza rudzi rwaunoda rwe sparkline. Semuenzaniso, sparkline chati.
- A dialog box ichaonekwa Kugadzira Sparklines. Uchishandisa mbeva, sarudza sero kuti uise sparkline, wobva wadzvanya OK. Muchiitiko chedu, isu tichasarudza sero H2, chinongedzo kune sero chichaonekwa mumunda Nzvimbo yenzvimbo.
- Iyo sparkline ichaonekwa musero rakasarudzwa.
- Dzvanya uye bata bhatani rekuruboshwe uye dhonza mubato wekuzadza wega kuti ukope sparkline kumaseru ari pedyo.
- Sparklines ichaonekwa mumitsara yese yetafura. Nhamba inotevera inoratidza kuti sparklines inofungidzira sei kutengesa kwekutengesa kwega yega rep rep pamusoro pemwedzi mitanhatu.
Shandura kutaridzika kwemavara anopenya
Kugadzirisa kutaridzika kwe sparkline kuri nyore. Excel inopa huwandu hwezvishandiso zvechinangwa ichi. Iwe unogona kugadzirisa kuratidzwa kwemaki, kuseta iyo ruvara, shandura mhando uye chimiro cheiyo sparkline, uye zvimwe zvakawanda.
Marker display
Iwe unogona kutarisa kune dzimwe nzvimbo dze sparkline graph uchishandisa mamaki kana mapoinzi, nekudaro uchiwedzera ruzivo rwayo. Semuenzaniso, pane sparkline ine zvakawanda zvakakura uye zviduku zvakakosha, zvakaoma zvikuru kunzwisisa kuti ndeipi iyo yakanyanya uye ndeipi shoma. Nesarudzo dzakagoneswa Maximum point и Minimum point zviite nyore.
- Sarudza mitsara inopenya yaunoda kuchinja. Kana vakaiswa mumasero akavakidzana, saka zvakakwana kusarudza chero ipi zvayo kusarudza boka rose kamwechete.
- Pa Advanced tabo Constructor muboka rekuraira ratidza gonesa sarudzo Maximum point и Minimum point.
- Kuonekwa kwema sparklines kuchagadziridzwa.
Kuchinja kwemaitiro
- Sarudza mitsara inopenya yaunoda kuchinja.
- Pa Advanced tabo Constructor tinya pamuseve wekudonhedza kuti uone mamwe masitayera.
- Sarudza chimiro chaunoda.
- Kuonekwa kwema sparklines kuchagadziridzwa.
Type shanduko
- Sarudza mitsara inopenya yaunoda kuchinja.
- Pa Advanced tabo Constructor sarudza rudzi rwe sparkline yaunoda. Semuyenzaniso, bha chati.
- Kuonekwa kwema sparklines kuchagadziridzwa.
Imwe neimwe mhando ye sparkline yakagadzirirwa chinangwa chaicho. Semuyenzaniso, kuhwina/kurasikirwa sparkline kwakanyatsokodzera dhata uko kune zvakanaka kana zvisina kunaka hunhu (semuenzaniso, mambure mari).
Kuchinja ratidziro yemhando
Nekumisikidza, imwe neimwe sparkline muExcel inoyerwa kuti ienderane nehupamhi uye hudiki kukosha kweiyo sosi data. Iyo yakanyanya kukosha iri pamusoro pesero, uye iyo shoma iri pasi. Nehurombo, izvi hazviratidze ukuru hwehukoshi kana uchienzaniswa nedzimwe sparklines. Excel inobvumidza iwe kuti uchinje kutaridzika kwe sparklines kuitira kuti vaenzaniswe kune mumwe nemumwe.
Ungashandura sei ratidziro
- Sarudza mitsara inopenya yaunoda kuchinja.
- Pa Advanced tabo Constructor sarudza timu akabatana. Menyu yekudonhedza ichaonekwa.
- Mune maparamendi ehupamhi uye hudiki kukosha padivi peiyo vertical axis, gonesa iyo sarudzo Yakagadzirirwa kune ese ma sparklines.
- Sparklines ichagadziridzwa. Iye zvino vanogona kushandiswa kuenzanisa kutengesa pakati pevamiririri vekutengesa.