Kugadzirisa machati muExcel: kuwedzera zita, demo, ngano

Chii chekutanga chaunoita mushure mekugadzira chati muExcel? Sezvingatarisirwa, ronga kuti uenderane nemufananidzo wakaitwa nefungidziro yako.

Mushanduro dzichangoburwa dzemaspredishiti, kugadzirisa machati inzira yakanaka uye iri nyore.

Microsoft yaenda kure kure kurerutsa maitiro ekugadzirisa. Somuenzaniso, anoisa mabhatani anodiwa munzvimbo dzinonyanya nyore kusvika paari. Uye gare gare muchidzidzo ichi, iwe uchadzidza akatevedzana enzira dzakareruka dzekuwedzera nekugadzirisa zvinhu zvese zvemachati uye magirafu muExcel.

Nhatu Dzakareruka Kugadzirisa Nzira

Kana iwe uchiziva kugadzira magirafu muExcel, unoziva kuti unogona kuwana marongero ayo nenzira nhatu:

1. Sarudza chati uye svetuka kune chikamu "Kushanda nemachati", iyo inogona kuwanikwa pane tab “Mugadziri”.
2. Tinya-kurudyi pane chinhu chinoda kuchinjwa uye sarudza chinhu chaunoda kubva pane pop-up menyu.
3. Shandisa bhatani rekugadzirisa chati rinoratidzwa mukona yepamusoro yekurudyi yechati mushure mekudzvanya pairi nebhatani rekuruboshwe.

Kana iwe uchida kugadzirisa dzimwe sarudzo dzinokutendera kuti ugadzirise kutaridzika kwegirafu, unogona kuzviona munzvimbo inoratidzwa nemusoro. "Chati Nzvimbo Format", iyo inogona kuwanikwa nekudzvanya pane chinhu “Dzimwe sarudzo” mune popup menyu. Unogonawo kuona sarudzo iyi muboka "Kushanda nemachati".

Kuti uratidze pakarepo "Format Chart Area" panel, unogona kudzvanya kaviri pane chinodiwa chinhu.

Zvino zvatabata ruzivo rwekutanga rwunodiwa, ngationei kuti tingashandura sei zvinhu zvakasiyana kuti chati itaridzike nenzira yatinoda kuti iite.

Ungawedzera sei zita

Sezvo vanhu vazhinji vachishandisa shanduro dzichangoburwa dzemaspredishiti, chingave chinhu chakanaka kutarisa maitiro ekuwedzera musoro muExcel 2013 uye 2016. 

Maitiro ekuwedzera zita kune chati muExcel 2013 uye 2016

Mushanduro dzemaspredishiti aya, musoro wacho wakatoiswa pachati. Kuti uigadzirise, ingobaya pairi uye nyora zvinyorwa zvinodiwa mundima yekupinza.

Iwe unogona zvakare kutsvaga musoro mune imwe sero mugwaro. Uye, kana iyo yakabatana sero ikagadziridzwa, zita rinoshanduka mushure maro. Iwe unozodzidza zvakawanda nezve nzira yekuzadzisa iyi mhedzisiro gare gare.

Kana zita racho risina kugadzirwa nepurogiramu, saka unofanira kudzvanya pane chero nzvimbo muchati kuratidza tab "Kushanda nemachati". Tevere, sarudza iyo "Gadzira" tebhu uye tinya pa "Wedzera Chati Element". Tevere, iwe unofanirwa kusarudza zita uye kuratidza nzvimbo yaro sezvakaratidzwa muscreenshot.

Iwe unogona zvakare kuona chiratidzo chekuwedzera mukona yepamusoro yekurudyi yechati. Kana ukadzvanya pairi, rondedzero yezvinhu zviripo mudhayagiramu inobuda. Kuti uratidze musoro, unofanira kutarisa bhokisi riri pedyo nechinhu chinoenderana.

Neimwe nzira, unogona kudzvanya pamuseve uri padyo "Chati Title" uye sarudza imwe yeinotevera sarudzo:

1. Pamusoro pedhayagiramu. Uku ndiko kukosha kwekutanga. Ichi chinhu chinoratidza zita riri pamusoro pechati uye chinochigadzirisa.
2. Center. Muchiitiko ichi, chati haichinje hukuru hwayo, asi musoro wacho wakanyanyisa pane chati pachayo.

Kuti ugadzirise mamwe ma parameter, unofanirwa kuenda kune tab “Mugadziri” uye tevera sarudzo idzi:

1. Wedzera chinhu chechati.
2. Musoro wechati.
3. Zvimwe zvingasarudzwa zvemusoro.

Iwe unogona zvakare kudzvanya pane iyo icon "Chati zvinhu", ndokuzo - "Chati Title" и “Dzimwe sarudzo”. Chero zvazvingava, hwindo rinovhura "Chati Title Format"zvinotsanangurwa pamusoro.

Kugadzirisa musoro muExcel 2007 uye 2010 shanduro

Kuti uwedzere zita muExcel 2010 uye pazasi, tevera matanho aya:

1. Dzvanya chero pachati.
2. Boka rematabo richaonekwa kumusoro. "Kushanda nemachati", paunoda kusarudza chinhu "Marongerwo". Ipapo unofanira kudzvanya "Chati Title".
3. Tevere, iwe unofanirwa kusarudza nzvimbo yaunoda: muchikamu chepamusoro chenzvimbo yekuronga kana kufukidza musoro pane chati.

Kubatanidza musoro kune imwe sero mugwaro

Kune huwandu hukuru hwemhando dzechati muExcel, iyo ichangobva kugadzirwa chati inoiswa pamwe chete nezita rakafanonyorwa nevagadziri. Inofanira kutsiviwa neyako. Iwe unofanirwa kudzvanya pairi uye kunyora zvinyorwa zvinodiwa. Izvo zvakare zvinogoneka kuibatanidza kune chaiyo sero mugwaro (zita retafura pacharo, semuenzaniso). Muchiitiko ichi, zita rechati richagadziridzwa kana iwe uchigadzirisa sero rainodyidzana naro.

Kuti ubatanidze musoro kune sero, tevera matanho aya:

1. Sarudza zita. 
2. Muchikamu chekuisa fomu, unofanira kunyora =, chengetedza pasero rine zvinyorwa zvinodiwa, uye shandisa bhatani re "Enter".

Mumuenzaniso uyu, takabatanidza musoro wechati inoratidza kutengesa kwemichero kune cell A1. Izvo zvakare zvinogoneka kusarudza maviri kana anopfuura maseru, semuenzaniso, maviri emisoro yemakoramu. Unogona kuita kuti vaoneke mumusoro wegirafu kana chati.

Nzira yekufambisa musoro

Kana uchida kuendesa musoro kune chimwe chikamu chegirafu, unofanira kuisarudza woifambisa negonzo.

Kubvisa musoro

Kana iwe usingade kuwedzera zita pane chati, saka unogona kubvisa zita racho nenzira mbiri:

1. Pa Advanced tabo “Mugadziri” tinya zvinotevedzana pazvinhu zvinotevera: “Wedzera Chati Zvinhu” - "Chati Title" - “Kwete”.
2. Tinya-kurudyi pane zita uye fonera iyo mamiriro menyu maunoda kuwana chinhu "Bvisa".

Header Formatting

Kuti ugadzirise rudzi rwefonti uye ruvara rwezita, unofanirwa kutsvaga chinhu chiri mumenu yemukati "Font". Iwindo rinoenderana richaonekwa kwaunogona kuseta ese anodiwa marongero.

Kana iwe uchida mamwe akajeka mafomati, iwe unofanirwa kudzvanya pane zita regirafu, enda kune tab "Fomati" uye shandura marongero sezvaunoona zvakakodzera. Heino skrini inoratidza matanho ekuchinja zita refonti ruvara kuburikidza neribhoni.

Nenzira yakafanana, zvinogoneka kugadzirisa kuumbwa kwezvimwe zvinhu, senge ngano, matemo, mazita.

Chart axis customization

Kazhinji mbariro (Y) uye yakachinjika (X) mbezo inowedzerwa kamwechete paunogadzira girafu kana chati muExcel.

Unogona kuvaratidza kana kuvavanza uchishandisa bhatani re "+" mukona yekurudyi uye tinya museve uri padyo ne "Axes". Muhwindo rinoonekwa, unogona kusarudza izvo zvinofanirwa kuratidzwa uye izvo zviri nani zvakavanzika.

Mune mamwe marudzi emagrafu nemachati, imwe axis inogonawo kuratidzwa.

Kana iwe uchida kugadzira XNUMXD chati, unogona kuwedzera yakadzika axis.

Mushandisi anogona kutsanangura kuti maekisi akasiyana acharatidzwa sei paExcel chati. Matanho akadzama anotsanangurwa pazasi.

Kuwedzera Axis Mazita

Kuti ubatsire muverengi kunzwisisa data, unogona kuwedzera mavara ematemo. Kuti uite izvi, ita zvinotevera:

1. Dzvanya padhayagiramu, wozosarudza chinhu chacho "Chati zvinhu" uye tarisa bhokisi "Mazita eAxis". Kana iwe uchida kudoma zita chete kune chaiyo axis, unofanirwa kudzvanya pane museve uye kujekesa imwe yemabhokisi echeki.
2. Dzvanya pane axis title yekupinda ndima uye isa zvinyorwa.

Kutsanangura chimiro chezita, tinya-kurudyi uye tsvaga chinhu che "Axis Title Format". Tevere, pani icharatidzwa umo zvese zvinogoneka mafomati sarudzo zvinogadziriswa. Zvinogoneka kuedza nzira dzakasiyana dzekutaridza musoro patebhu "Fomati", sezvaratidzwa pamusoro kana zvasvika pakuchinja chimiro chezita.

Kubatanidza zita reaxis nesero regwaro chairo

Sezvakangoita nemazita echati, unogona kusunga axis zita kune chaiyo sero mugwaro kuitira kuti rigadzirise nekukurumidza kana sero rinoenderana mutafura ragadziriswa.

Kusunga musoro, unofanira kuusarudza, nyora = mumunda wakakodzera uye sarudza sero yaunoda kusunga kune axis. Mushure mekuita izvi, unofanirwa kudzvanya bhatani rekuti "Enter".

Shandura chiyero chematemo

Excel pachayo inowana kukosha kukuru uye kudiki, zvichienderana nedata rakaiswa nemushandisi. Kana iwe uchida kuseta mamwe ma parameter, unogona kuzviita nemaoko. Iwe unofanirwa kuita zvinotevera:

1. Sarudza x-axis yechati uye tinya pane icon "Chati zvinhu".
2. Dzvanya pane museve icon mumutsara "Axis" uye mune pop-up menyu tinya pa “Dzimwe sarudzo”.
3. Kunotevera kunouya chikamu "Axis Options"apo chimwe chezviito izvi zvinoitwa:
   1. Kuseta yekutanga uye yekupedzisira kukosha kweiyo Y axis, iwe unofanirwa kuitsanangura muminda "Minimum" uye "Maximum".
   2. Kuti uchinje chiyero cheaxis, unogona zvakare kutsanangura kukosha mumunda "Basic divisions" и "Zvikamu zvepakati".
   3. Kuti ugadzirise kuratidzwa mune reverse kurongeka, unofanirwa kutarisa bhokisi riri padivi pechisarudzo “Reverse Order of Values”.

Sezvo iyo yakatwasuka axis inowanzo ratidza mavara mavara, ine mashoma ekugadzirisa sarudzo. Asi iwe unogona kugadzirisa huwandu hwezvikamu zvinoratidzwa pakati pemazita, kutevedzana kwawo uye panopindirana demo.

Kuchinja Mafomati eAxis Values

Kana iwe uchida kuratidza kukosha pamatemo sechikamu, nguva, kana chero imwe fomati, iwe unofanirwa kusarudza chinhu kubva pane pop-up menyu. "Format Axis", uye muchikamu chekurudyi chehwindo, sarudza imwe yezvinobvira sarudzo painoti “Nhamba”.

Mazano: kugadzirisa iyo fomati yeruzivo rwekutanga (kureva, kukosha kwakaratidzwa mumaseru), unofanirwa kutarisa bhokisi riri padivi pechinhu. "Link kune Source". Kana iwe usingakwanisi kuwana chikamu “Nhamba” mupanera "Format Axis", unofanirwa kuve nechokwadi chekuti wakambosarudza axis inoratidza kukosha. Kazhinji ndiyo X axis.

Kuwedzera Data Labels

Kuita kuti chati ive nyore kuverenga, unogona kuwedzera mavara kune data raunopa. Iwe unogona kuwedzera ivo kumutsara mumwe kana kune vese. Excel inopawo kugona kuwedzera mavara chete kune mamwe mapoinzi.

Kuti uite izvi, unofanirwa kutevera matanho aya:

1. Dzvanya pane data rakateedzana rinoda kusaina. Kana iwe uchida kumaka poindi imwe chete nemavara, unofanirwa kudzvanya pairi zvakare.
2. Dzvanya pane icon "Chati zvinhu" uye tarisa bhokisi padyo ne "Data Siginecha".

Semuenzaniso, hezvino zvinotaridzika seimwe yemachati mushure mekunge mavara awedzerwa kune imwe yedata data mutafura yedu.

Kune mamwe marudzi emachati (akadai semapie machati), unogona kutsanangura nzvimbo yezita. Kuti uite izvi, tinya pane museve uri padyo nemutsetse "Data Siginecha" uye ratidza nzvimbo yakakodzera. Kuti uratidze mavara munzvimbo dzinoyangarara dzekuisa, unofanira kusarudza chinhu chacho "Data Callout". Kana iwe uchida mamwe marongero, unogona kudzvanya pane chinhu chinoenderana pazasi chaipo pemenu yemamiriro.

Maitiro ekushandura zvirimo mumasaini

Kuti uchinje iyo data inoratidzwa mumasaini, unofanirwa kudzvanya bhatani "Chati zvinhu" - "Data Siginecha" - “Dzimwe sarudzo”. Iyo panel inozoonekwa. "Data Label Format". Ikoko iwe unofanirwa kuenda kune iyo tab "Signature Options" mukati uye sarudza yaunoda sarudzo muchikamu “Include in Signature”.

Kana iwe uchida kuwedzera yako mameseji kune imwe nzvimbo yedata, iwe unofanirwa kudzvanya-kaviri pane inoenderana label kuitira kuti iyo chete inosarudzwa. Zvadaro, sarudza label ine mavara aripo uye isa mavara aunoda kutsiva.

Kana iwe ukafunga kuti mavara akawandisa anoratidzwa muchati, unogona kubvisa chero iwo nekudzvanya-kurudyi pane rinoenderana label uye nekudzvanya bhatani. "Bvisa" mumenu yezvinyorwa inooneka.

Mimwe nhungamiro yekutsanangura mazita e data:

1. Kuti uchinje nzvimbo ye siginicha, unofanirwa kudzvanya pairi uye woiendesa kunzvimbo yaunoda negonzo.
2. Kugadzirisa iyo yekumashure ruvara uye siginecha font, sarudza ivo, enda kune iyo tab "Fomati" uye isa zvinodiwa parameters.

Legend setup

Mushure mekunge magadzira chati muExcel, ngano ichangoerekana yaonekwa pazasi pechati kana Excel version iri 2013 kana 2016. Kana shanduro yepakutanga yepurogiramu yakaiswa, icharatidzwa kurutivi rworudyi rwenzvimbo.

Kuti uvanze ngano, unofanira kudzvanya bhatani nechiratidzo chekuwedzera mukona yekurudyi yechati uye wobvisa bhokisi rinoenderana.

Kuti uifambise, unofanirwa kudzvanya padhiyagiramu, famba kune iyo tab “Mugadziri” uye tigoshingairira "Wedzera Chati Element" uye sarudza nzvimbo inodiwa. Iwe unogona zvakare kudzima ngano kuburikidza neiyi menyu nekudzvanya pabhatani “Kwete”. 

Iwe unogona zvakare kushandura nzvimbo nekudzvanya-kaviri pairi uye mune sarudzo (kurudyi rwechidzitiro) kusarudza nzvimbo yaunoda.

Kuti uchinje kurongeka kweiyo ngano, kune huwandu hukuru hwezvigadziriso mune iyo tab "Shading nemiganhu", "Effects" mupaneru yekurudyi.

Maitiro ekuratidza kana kuvanza grid yeExcel gwaro

Iyo grid inoratidzwa kana kuvanzwa uchishandisa imwechete pop-up menyu inoshandiswa kuratidza zita, ngano, uye zvimwe machati zvinhu.

Iyo purogiramu inozozvisarudzira iyo yakanyatsokodzera grid mhando yeimwe chati. Kana iwe uchida kuchichinja, iwe unofanirwa kudzvanya pamuseve uri padivi pechinhu chinoenderana uye tinya pa “Dzimwe sarudzo”.

Kuviga uye kugadzirisa data data muExcel

Kuti uvanze kana kugadzirisa yega data data muExcel, unofanirwa kudzvanya bhatani riri kurudyi rwegirafu “Masefa eChati” uye bvisa zvisina basa mabhokisi ekutarisa. 

Kuti ugadzirise data, tinya pa "Change Row" kurudyi rwemusoro. Kuti uone bhatani iri, unofanirwa kutenderedza pamusoro pezita remutsara.

Shandura rudzi rwechati uye maitiro

Kuti uchinje rudzi rwechati, unofanirwa kudzvanya pairi, enda kune tab “Isert” uye muchikamu "Dhiagiramu" sarudza rudzi rwakakodzera.

Iwe unogona zvakare kuvhura iyo mamiriro menyu uye tinya pa "Chinja Chati Type".

Kuti uchinje chimiro chechati nekukurumidza, unofanirwa kudzvanya bhatani rinoenderana (nebhurashi) kurudyi rwechati. Iwe unogona kusarudza yakakodzera kubva pane rondedzero inooneka.

Iwe unogonawo kusarudza maitiro akakodzera muchikamu “Matayera eChati” mu tab “Mugadziri”.

Shandura mavara emachati

Kugadzirisa iyo color scheme, tinya pane bhatani “Matayera eChati” uye mu tab "Ruvara" sarudza musoro wakakodzera.

Iwe unogona zvakare kushandisa iyo tab "Fomati"pekudzvanya bhatani "Shape fill".

Nzira yekunzwisisa nzvimbo dzeaxis

Kuti uwane chinangwa ichi, zvakakosha pane tab “Mugadziri” pusha bhatani "Row column".

Chati inopararira kubva kuruboshwe kuenda kurudyi

Kutenderedza chati kubva kuruboshwe kuenda kurudyi, unofanirwa kudzvanya-kurudyi pane yakachinjika axis wodzvanya. "Format Axis".

Iwe unogona zvakare mune iyo tab “Mugadziri” tsvaga chinhu "Dzimwe Axis Sarudzo".

Muchikamu chekurudyi, sarudza chinhu "Reverse order of categories".

Kune zvakare huwandu hwezvimwe zvinogoneka, asi hazvibviri kufunga zvese. Asi kana ukadzidza kushandisa zvinhu izvi, zvichava nyore zvikuru kudzidza zvitsva iwe pachako. Rombo rakanaka!