Edza neExcel chati uye mairafu kuratidza data yako
Zvinyorwa uye mafuro ndiwo maonero ekufananidzira kwedhesi rebasa. Vanowanzoita kuti zvive nyore kunzwisisa dhesi iri mune pepa rekushandura nokuti vashandi vanogona kutsvaga mararamiro nemafambisirwo akaoma zvakaoma kuona mu data. Kazhinji, magrafu anoshandiswa kuenzanisira mamiriro ekufamba kwenguva, asi machati anoenzanisa mapepa kana ane ruzivo pamusoro pezvizhinji. Sarudza Excel chati kana graf format iyo inonyatsoratidza ruzivo rwezvaunoda.
Pie Charts
Pie chati (kana kutenderera mairafu) zvinoshandiswa kurongedza zvinongedzo imwe chete panguva imwechete. Somugumisiro, vanogona kungoshandiswa kuratidza zvikamu.
Denderedzwa yematokari emakumbo anomiririra zana muzana. Denderedzwa yakapatsanurwa muzvidimbu zvinomirira nhamba yehutano. Hukuru hwechikamu chimwe nechimwe chinoratidza kuti chikamu chezana chezana chinomirira.
Dhavhiti inogona kushandiswa paunenge uchida kuratidza chii chezana chimwe chinhu chimwe chinomiririra dhepfenyuro ye data. Semuyenzaniso:
- Imari yekambani pamwedzi wega wega inogona kuratidzwa ne chati yepayiri sepakati yemari yegore rose.
- Average player's batting average can be shown with a pie chart because it represents the percentage of hits compared to the total of at-bats for a season.
- Ikoji yezana yako yezuva nezuva koriori yekuti imwe cheese uye bacon hamburger inomiririra.
Column Charts
Column charts , iyo inozivikanwawo sebar barfu, inoshandiswa kuratidza kuenzanisa pakati pezvinhu zve data. Icho chimwe chezvinhu zvakajairika zvemafirimu anoshandiswa kuratidza deta. Nhamba yacho inoratidzirwa uchishandisa bundu rakavhara kana rutsanga, uye imwe imwe column mu chati inomiririra imwe nhamba yemari. Semuyenzaniso:
- Muchikoro chekuchikoro, unogona kushandisa bar bar kuti uratidze uye kuenzanisa nhamba yevadzidzi vane mavara akasiyana-siyana. Kuwedzera kwevadzidzi vane rumwe ruvara rutsvuku, iyo yakareba ibha yemuvara iwoyo pane grafu.
- Iwe unogona kushandisa mahwendefa akasiyana-siyana kuti uenzanise ma koriori mune cheese uye bhakoni hamburger kana uchienzaniswa nemakori mubhokisi rebeet.
Bharati mafuro anoita kuti zvive nyore kuona kusiyana kweiyo kuenzaniswa.
Bharati Dharedhi
Bharati mapepa ndiwo mifananidzo yematsetse akawira pamusoro pavo. Mizariro kana zvikamu zvinotarisana nechepamusoro peji pane pane kutenderera. Masanhu anoshanduka pamwe-y y-axis ndiyo nheyo yakanyanyisa iri pasi pechati, uye x-axis inomhanya yakananga kumusoro.
Line Charts
Mutsara wematafura , kana mifananidzo yemiganhu, anoshandiswa kuratidza mamiriro ekufamba kwenguva. Mutsetse wega wega mugrafu unoratidza kuchinja kwehuwandu hweimwe chinhu che data.
Kufanana nemamwe magrafu, magrafu emirara ane vertical axis uye yakanyatsosangana axis. Kana iwe uri kuronga kuchinja mune data pane nguva, nguva yakarongwa pamwe chete nechepakati kana x-axis, uye imwe yemamwe mashoko, zvakadai semvura inogadziriswa inorongwa semunhu pachake pamutsara kana y-axis.
Apo iyo munhu wepodha manotsi akabatanidzwa nemitsetse, anoratidza kuchinja mune data.
Somuenzaniso, iwe unogona kuratidza kuchinja kwehutano hwako pamusoro pemwedzi yakawanda semugumisiro wekudya cheese uye bhakoni hamburger zuva rega rega kwemasikati, kana iwe unogona kuronga kuchinja zuva nezuva mumatengo emusika. Inogonawo kushandiswa kugadzira deta yakanyorwa kubva kuongororo yezvesayenzi, yakadai sekushandiswa kwemakemikari kunoshandura kutonhora kana kushanda kwemhepo.
Shatura Plot Grafu
Kuparadzira girafu mapirati anoshandiswa kuratidzira mafambiro mune data. Iyo inonyanya kubatsira kana iwe uine nhamba huru yedhadha data. Kungofanana nemirafu yemirara, inogona kushandiswa kugadzira deta yakanyorwa kubva kuongororo yesayenzi, yakadai sekushandiswa kwemakemikari kunoshandura kutonhora kana kushanda kwemhepo.
Nepo mavara emagetsi akabatanidza mavara kana mapepa e data kuti aratidze shanduko imwe neimwe, nechinangwa chekuparadzira iwe unotora "zvakakodzera kukodzera" mutsara. Nhamba dze data dzakapararira pamusoro pemutsara. Izvo zvakanyanya nenyaya dzepasita dziri kumurongo zvakasimba kusiyanisa kana kushanda kushandiswa kwakasiyana pane kune imwe.
Kana iyo yakanakisisa yakakonzera mutsara inowedzera kubva kuruboshwe kuenda kurudyi, nzvimbo inoparadzira inoratidza kuwirirana kwakanaka munharaunda. Kana iyo mutsara ichiderera kubva kuruboshwe kuenda kurudyi, pane kuwirirana kusina kuwanikwa mune data.
Combo Charts
Combo charts pamwe nemhando dzakasiyana-siyana dzematafura muchiratidzo chimwe. Kazhinji, mapepa aya maviri ari mutsara wemutsara uye chinyorwa chati. Kuti uite izvi, Excel inoshandisa shanduro yechitatu inonzi y second Y axis, iyo inomira kurutivi rworudyi rwe chati.
Mifananidzo yakasiyana-siyana inogona kuratidza chiyero chemazuva ose ekushisa uye kudonhedzana kwedenga pamwe chete, kudhinda zvinhu zvakadai sezvikwata zvakabudiswa uye mari yekutengeswa, kana mwedzi wekutengesa yepamusoro uye mutengo wepamwedzi wekutengesa mutengo.
Pictographs
Pictographs kana pictograms zvikamu zvemashoko anoshandisa mifananidzo kuratidza dhara panzvimbo yemirasi yakazara yemifananidzo. Pikichagraph ingashandisa mazana emafuta emagaladha akaiswa pane imwe pamusoro peimwe kuratidza kuti makorii akawanda cheki uye bhakoni hamburger ine chienzaniswa necheche duku yemifananidzo yebeet greens.
Stock Market Charts
Stock Market charts kuratidza ruzivo pamusoro pematokari kana zvikamu zvakadai sematengo avo ekuzarura nekuvhara uye kuwanda kwezvikamu zvakatengeswa panguva imwe nguva. Kune marudzi akasiyana ematepa ematokari anowanikwa muExcel. Mumwe nomumwe anoratidza ruzivo rwakasiyana.
Zvitsva zvekare zveExcel dzinosanganisirawo mapepa eSuface , charts XY (kana kuparadzira), uye mativi eRadar.
Kuwedzera Chati mu Excel
Nzira yakanakisisa yekudzidza pamusoro pematare akasiyana-siyana muExcel ndokuedza kwavari.
- Vhura an Excel file ine data.
- Sarudza mararamiro aunoda girafu nekukanda-kutengesa kubva kukutanga kero kusvika kunekupedzisira.
- Dzvanya paIndai tab uye sarudza Chati kubva kumenyu yakaderera.
- Sarudza imwe yematafura acho kubva kumadhi-menyu. Paunenge uchiita, Tati Yakarongeka yeTati inotanga kuratidza zvingasarudzwa zvemarudzi chaiwo echadhi yawakasarudza. Ita zvaunosarudza uye ona chati iri kuwanikwa mumagwaro.
Iwe unofanirwa kuedza kutsvaga kuti ndeupi rudzi rwechati runoshanda zvakanakisisa neshoko rako rakasarudzwa, asi unogona kutarisa mhando dzakasiyana dzematafura kuti uone kuti ndezvipi zvinokubatsira iwe.