Mukati
Paunenge uchigadzira machati muExcel, iyo sosi data yayo haisi nguva dzose iri papepa rimwechete. Neraki, Microsoft Excel inopa nzira yekuronga dhata kubva maviri kana anopfuura akasiyana mashizha ekushanda mune imwechete chati. Ona pazasi kuti uwane mirairo yakazara.
Maitiro ekugadzira chati kubva kudhata mumapepa akawanda muExcel
Ngatifungei kuti kune akati wandei mapepa ane data yemari yemakore akasiyana mune rimwe faira respredishiti. Uchishandisa iyi data, unofanirwa kuvaka chati kuti uone mufananidzo mukuru.
1. Tinovaka chati inobva pane data yepepa rekutanga
Sarudza iyo data pane pepa rekutanga raunoda kuratidza muchati. Uyezve vhura masonry Insert. Muboka Mifananidzo Sarudza rudzi rwechati rwaunoda. Mumuenzaniso wedu, tinoshandisa Volumetric Stacked Histogram.
Ndiyo yakaturikidzana bhachati inova ndiyo inonyanya kufarirwa mhando yemachati anoshandiswa.
2. Tinopinza data kubva papepa rechipiri
Simbisa dhayagiramu yakagadzirwa kuti ivhure mini panhi kuruboshwe Zvishandiso zvechati. Zvadaro, sarudza Constructor uye tinya pane iyo icon Sarudza data.
Unogonawo kudzvanya bhatani Mafirita eChati . Kurudyi, pazasi chaipo pechinyorwa chinooneka, tinya Sarudza data.
Muhwindo rinoonekwa Source kusarudzwa data tevera chinongedzo Wedzera.
Isu tinowedzera data kubva papepa rechipiri. Ichi chinhu chakakosha, saka chenjera.
Paunodzvanya bhatani Wedzera, dialog box inobuda Row shanduko. Pedyo nemunda ukoshi iwe unofanirwa kusarudza iyo renji icon.
hwindo Row shanduko kupeta. Asi kana uchichinja kune mamwe mapepa, inoramba iri pachiratidziro, asi haizoshande. Iwe unofanirwa kusarudza pepa rechipiri kubva kwaunoda kuwedzera data.
Papepa rechipiri, zvinodikanwa kuratidza iyo data yakapinda muchati. Kuhwindo Row inochinja activated, unongoda kudzvanya pairi kamwe chete.
Kuitira kuti sero rine mavara richava zita remutsara mutsva, iwe unofanirwa kusarudza iyo data renji padivi peiyo icon. Zita remusara. Deredza hwindo remhando kuti uenderere mberi nekushanda mutebhu Row inochinja.
Ita shuwa kuti zvinongedzo mumitsetse Zita remusara и Zvinokosha inoratidzwa nemazvo. Dzvanya OK.
Sezvauri kuona kubva pamufananidzo wakanamirwa pamusoro, zita remutsara rinosanganiswa nesero V1apo pakanyorwa. Pane kudaro, musoro wacho unogona kuiswa semavara. Semuenzaniso, mutsara wechipiri we data.
Misoro yenhevedzano ichaonekwa mungano yechati. Naizvozvo, zviri nani kuvapa mazita ane musoro.
Panguva ino yekugadzira dhizaini, hwindo rekushanda rinofanira kutaridzika seizvi:
3. Wedzera mamwe matinji kana zvichidikanwa
Kana iwe uchiri kuda kuisa data muchati kubva kune mamwe mapepa Excel, wobva wadzokorora nhanho dzese kubva mundima yechipiri kune ese ma tabo. Tinobva tadzvanya OK muhwindo rinoonekwa Kusarudza nzvimbo yedata.
Mumuenzaniso pane mitsara mitatu yedata. Mushure mematanho ese, histogram inoita seizvi:
4. Gadzirisa uye uvandudze histogram (optional)
Paunenge uchishanda muExcel 2013 uye 2016 shanduro, zita uye ngano zvinowedzerwa otomatiki kana bar chart yagadzirwa. Mumuenzaniso wedu, havana kuwedzerwa, saka tichazviita isu pachedu.
Sarudza chati. Mune menyu inooneka Chati zvinhu dzvanya muchinjiko wakasvibira uye sarudza zvese izvo zvinoda kuwedzerwa kune histogram:
Mamwe marongero, akadai sekuratidzwa kwemazita edata uye mafomati emasanhu, anotsanangurwa mune imwe yakadhindwa.
Isu tinogadzira machati kubva kune yakazara data mutafura
Nzira yekuchata inoratidzwa pamusoro inongoshanda chete kana data iri pamatabhu ese egwaro riri mumutsara mumwechete kana koramu. Zvikasadaro, dhayagiramu inenge isingaverengeki.
Mumuenzaniso wedu, data rese riri mumatafura akafanana pamapepa matatu. Kana iwe usina chokwadi chekuti chimiro chakafanana mavari, zvingava zviri nani kutanga kuunganidza tafura yekupedzisira, zvichibva pane zviripo. Izvi zvinogona kuitwa uchishandisa basa VLOOKUP or Batanidza Tafura Wizards.
Kana mumuenzaniso wedu matafura ese aive akasiyana, saka fomula yaizove:
=VLOOKUP (A3, '2014'!$A$2:$B$5, 2, FALSE)
Izvi zvaizoita kuti:
Mushure maizvozvi, ingosarudza tafura inoguma. Mune tab Insert wana Mifananidzo uye sarudza rudzi rwaunoda.
Kugadzirisa chati yakagadzirwa kubva kune data pamashizha akawanda
Izvo zvinoitikawo kuti mushure mekugadzira girafu, shanduko yedata inodiwa. Muchiitiko ichi, zviri nyore kugadzirisa iripo pane kugadzira dhayagiramu itsva. Izvi zvinoitwa kuburikidza menyu. Kushanda nemachati, iyo isiri yakasiyana kune magirafu akavakwa kubva kune data yetafura imwe. Kuisa zvinhu zvikuru zvegirafu kunoratidzwa mune rimwe bhuku rakasiyana.
Pane nzira dzakati wandei dzekuchinja data inoratidzwa pachati pachayo:
- kuburikidza nemenyu Kusarudza nzvimbo yedata;
- Via filters
- ndinoreverera Data series formulas.
Kuvhura menyu Kusarudza nzvimbo yedata, inodiwa mune tab Constructor dzvanya submenu Sarudza data.
Kugadzirisa mutsara:
- sarudza mutsara;
- tinya pane tab chinja;
- chinja ukoshi or zita First, sezvataiita kare;
Kuti uchinje kurongeka kwemitsara yezvinokosha, unofanirwa kusarudza mutsara uye kufambisa uchishandisa yakakosha kumusoro kana pasi miseve.
Kuti udzime mutsara, unongoda kuisarudza uye tinya bhatani Bvisa. Kuti uvanze mutsara, iwe unofanirwawo kuisarudza uye uncheck bhokisi riri mumenyu legend elements, iro riri kuruboshwe rwehwindo.
Kugadzirisa Series kuburikidza neChati Sefa
Maseting ese anogona kuvhurwa nekudzvanya pabhatani resefa . Zvinoonekwa paunongodzvanya pachati.
Kuti uvanze data, ingobaya pa firita uye usatarise mitsetse isingafanirwe kunge iri muchati.
Hover the pointer pamusoro pemutsara uye bhatani rinoonekwa Shandura mutsara, tinya pairi. Hwindo rinobuda Kusarudza nzvimbo yedata. Isu tinoita zvirongwa zvinodiwa mairi.
Cherechedza! Paunofambisa mbeva pamusoro pemutsara, inosimbiswa kuti inzwisise zviri nani.
Kugadzirisa mutsara uchishandisa fomula
Yese yakatevedzana mugirafu inotsanangurwa neformula. Semuenzaniso, kana tikasarudza nhevedzano muchati yedu, inotaridzika seizvi:
=SERIES(‘2013′!$B$1,’2013′!$A$2:$A$5,’2013’!$B$2:$B$5,1)
Chero fomula ine zvikamu zvina zvikuru:
= SERIES([Zita rakatevedzana], [x-values], [y-values], mutsara nhamba)
Formula yedu mumuenzaniso ine tsananguro inotevera:
- Series zita ('2013'!$B$1) yakatorwa muchitokisi B1 pabepa 2013.
- Ukoshi hwemitsara ('2013'!$A$2:$A$5) yakatorwa mumaseru A2:A5 pabepa 2013.
- Koramu ukoshi ('2013'!$B$2:$B$5) yakatorwa mumaseru B2:B5 pabepa 2013.
- Nhamba (1) inoreva kuti mutsara wakasarudzwa une nzvimbo yekutanga pachati.
Kuti uchinje yakatarwa data nhevedzano, sarudza iyo mu chati, enda kune formula bar uye ita shanduko dzinodiwa. Ehe, iwe unofanirwa kungwarira zvakanyanya paunenge uchigadzirisa akateedzana formula, nekuti izvi zvinogona kutungamirira kune zvikanganiso, kunyanya kana iyo yekutanga data iri pane rakasiyana pepa uye haugone kuiona paunenge uchigadzirisa fomula. Zvakadaro, kana iwe uri advanced Excel mushandisi, unogona kufarira nzira iyi, iyo inokutendera iwe kukurumidza kuita shanduko diki kumachati ako.