Maitiro ekuwedzera iyo Legend mune Execel 2010 Chati

Anonim

MuMicrosoft Office Excel, iwe unogona kukurumidza kuvaka dhizaini padivi petafura yakarongedzwa kuti aratidze hunhu hwayo hukuru. Iyo dhayati inoitwa kuwedzera ngano kuti ione ruzivo rwunofungidzirwa nezvakapiwa pamusoro payo, uvape zita. Ichi chinyorwa chinoburitsa nzira dzekuwedzera ngano kune chati muExcel 2010.

Maitiro ekuvaka chati muExcel patafura

Kutanga, zvinodikanwa kuti unzwisise kuti dhayaini yakavakwa sei muchirongwa ichi chiri kufunga. Maitiro okuvaka ayo akakamurwa zvakatemerwa matanho anotevera:

  1. MuTafura yepafura, sarudza iyo yaunoda mhando yemasero, iyo makoramu ayo anofanirwa kutsamira anofanira kuratidzwa.
Maitiro ekuwedzera iyo Legend mune Execel 2010 Chati 1348_1
Sarudza iyo inodikanwa mhando yemasero patafura yekuvaka chati
  1. Enda kune iyo "Insert" tab mune iyo yepamusoro girafu yemamenji makuru echirongwa.
  2. Mu "Dhizaini" block, tinya pane imwe yevasiri vechiratidzo chemiromo. Semuenzaniso, unogona kusarudza denderedzwa kana bar chati.
Maitiro ekuwedzera iyo Legend mune Execel 2010 Chati 1348_2
Zviito zvekuvaka chati muExcel 2010
  1. Mushure mekupedza chiitiko chakapfuura, hwindo rine dhiji yakavakwa inofanira kuoneka padyo nezita rekutanga ndiro pamusara webhokisi. Icharatidza kutsamira pakati pehunhu hunonzi mune rondedzero. Saka mushandisi anogona kunyatsoonga mutsauko mutsika, ongorora hurongwa uye unogumisa pazviri.

Maitiro ekuwedzera iyo ngano kune chati muExcel 2010 nenzira yakajairika

Iyi ndiyo nzira iri nyore yekuwedzera iyo ngano isingatore mushandisi nguva yakawanda yekuita. Iyo yakakosha yenzira ndeyekuita matanho anotevera:

  1. Kuvaka dhizaini pane iyo iri pamusoro chirongwa.
  2. Kuruboshwe Key Manipulator Press tinya Green Cross Icon mune mudziyo wekushandisa kurudyi rwegirafu.
  3. Mune iyo yepamusoro sarudzo yewindo rinovhura padyo nenziyo ngarava, isa tick kumisa basa racho.
Maitiro ekuwedzera iyo Legend mune Execel 2010 Chati 1348_3
Kubata tick padhuze neiyo mutsara "ngano" yekuratidzira kwayo pane yakavakirwa purogiramu
  1. Ongorora dhizaini. Inofanira kuwedzera masisitimu ezvinhu kubva kuSista Lafura Tafura.
  2. Kana zvichidikanwa, iwe unogona kushandura nzvimbo yehurongwa. Kuti uite izvi, tinya iyo lkm pane iyo ngano uye sarudza imwe sarudzo yenzvimbo yayo. Semuenzaniso, "kuruboshwe", "pazasi", "kumusoro", "kurudyi" kana "pamusoro kuruboshwe".
Maitiro ekuwedzera iyo Legend mune Execel 2010 Chati 1348_4
Kuchinja nzvimbo yedhirowa mune block pahwindo rorudyi

Maitiro ekuchinja iwo mavara eiyo ngano mune chati muExcel 2010

Sappings yeiyo ngano, kana ichida, inogona kushandurwa nekuisa iyo yakakodzera font uye saizi. Iwe unogona kuita izvi kushanda zvinoenderana nemirairo inotevera:
  1. Vakai dhizaini uye wedzera ngano pairi pane algorithm inokurukurwa pamusoro apa.
  2. Gadzirisa saizi, mavara anotarisa murugwaro rwemberi, mumasero anovakwa purogiramu pachayo. Paunenge uchigadzira zvinyorwa mumakoramu etafura, iwo mavara mune ngano ye chati ichangoerekana zvachinja.
  3. Tarisa uone mhedzisiro yacho.

Maitiro ekuzadza chati

Kuwedzera kune ngano, pane imwezve data imwe inogona kuratidzwa pane yakavakirwa purogiramu. Semuenzaniso, zita raro. Kuti utumidze chinhu chakavakirwa chinhu, chinodiwa kuti uite zvinotevera:

  1. Vakai dhirowa pane iyo sosi ndiro uye fambisa kune "maumbirwo" tab pamusoro peiyo huru chirongwa cheProgram menyu.
  2. Iyo nharaunda yebasa ine madhiramu ichavhura, mune iyo akati wandei ma parmeter aripo kuti achinje. Mumamiriro ezvinhu aya, mushandisi anoda kudzvanya pane "Diagram Musoro" bhatani.
  3. Mune rondedzero yakawedzerwa yesarudzo, sarudza mhando yerudzi rwemhando yenzvimbo. Inogona kuiswa pakati nepakati uye pamusoro pehurongwa.
Maitiro ekuwedzera iyo Legend mune Execel 2010 Chati 1348_5
Kuwedzera mazita kune chati muMicrosoft Office Excel
  1. Mushure mekubata zvakapfuura manipulations, diair "dhayiti" inoonekwa pane yakavakirwa graph. Mushandisi wayo anozogona kuchinja, achiratidza kuti anobva mumakomputa keyboard chero imwe musanganiswa wemashoko akakodzera mune zvinorehwa kune iyo sosi tafura.
Maitiro ekuwedzera iyo Legend mune Execel 2010 Chati 1348_6
Shanduko yakawedzerwa kuzita rezita
  1. Izvo zvakakoshawo kusaina axis pane chati. Ivo vanonyorera nenzira imwe chete. Mubasa rebasa rine machati, iwe uchazoda kudzvanya pane "Axis zita" bhatani. Mune zvinyorwa zvisingaruki, sarudza imwe yeiyo demo: kungave kwakamira kana kutwasuka. Tevere, ita shanduko yakakodzera yeiyo sarudzo yakasarudzwa.
Maitiro ekuwedzera iyo Legend mune Execel 2010 Chati 1348_7
Kusaina maAxes mune chati

Imwe nzira yekuchinja iyo ngano yeChigiri muExcel

Iwe unogona kugadzirisa zvinyorwa zvemasaini pane chirongwa ichi uchishandisa chishandiso chakavakwa muchirongwa. Kuti uite izvi, iwe unofanirwa kuita mashoma mashoma matatu pane algorithm:
  1. Right-Key Manipulator Dzvanya pane yaunoda izwi ngano mune yakavakirwa chati.
  2. MuComerTual Window Window, tinya pane "mafirita" mutsara. Mushure meizvozvo, hwindo retsika mafirita rinovhura.
  3. Dzvanya pane "Sarudza data" bhatani, iri pazasi pewindo.
Ngano zvivakwa zvewindo muExcel
  1. Mune menyu itsva "Sarudza data zvinyorwa", iwe unofanirwa kudzvanya pane "shanduko" mu "ngano" block.
  2. Muwindo rinotevera mu "mutsara zita" munda, iwe unonyoresa zita rakasiyana rezita rakambosarudzwa uye tinya pa "Zvakanaka".
Kunyora zita idzva rezvinyorwa zvegirafu
  1. Tarisa uone mhedzisiro yacho.

Mhedziso

Nekudaro, kuvakwa kweiyo ngano muMicrosoft Office Excel 2010 kwakakamurwa kuita matanho akati wandei, chimwe nechimwe chinoda kudzidza kwakadzama. Kana iwe uchida, ruzivo rwechati runogona kukurumidza kugadzirisa. Pamusoro pemitemo yekutanga yebasa nemacLAS mukurondedzerwa kwakatsanangurwa.

Mharidzo Maitiro Ekuwedzera Legend muExcel 2010 Chart yakaonekwa kutanga kune tekinoroji yeruzivo.

Verenga zvimwe