Gadzirai Mutengo Wematunhu muExcel 2010

01 ye 09

Wedzera Sekondari Y Axis ku Excel Chart

Cherechedza : Matanho anotsanangurwa mumudzidzisi uyu anoshanda chete kune zvinyorwa zveExcel kusvika kune uye zvinosanganisira Excel 2010 .

Excel inokubvumira kuti ubatanidza maviri kana akawanda zvakasiyana-siyana zvechadhi kana mafirimu kuti zvive nyore kuratidza ruzivo rwakabatana pamwechete.

Imwe nzira iri nyore yekuita basa iri ndekuwedzera kwechipiri chechidimbu kana Y axis kurudyi rwe chati. Izvo zvikamu zviviri zvepa data zvichiri kugovana zvakafanana X kana tsvina yakadzika pasi pechati.

Nokusarudza mabhidhiyo mapato-akadai sechandori chati uye mutsara wegamba -kuratidzwa kwemaseri maviri e data kunogona kuwedzerwa.

Shanduro dzinowanzoenderana nerudzi urwu rwekubatanidza diki dzinosanganisira kuratidza huwandu hwemwedzi hwekushisa uye dhigiridzo pamwe chete, kushandiswa kwezvinhu zvakadai sezvikwata zvakabudiswa uye mari yekugadzira, kana kuti mwedzi wekutengesa wepamusoro uye mutengo wepamwedzi wekutengesa mutengo.

Chikwata Chechidiwa Zvaidiwa

• Chimwe chinhu chinodiwa kuti data iratidzwe ndechokuti inofanira kugovera maikirwo eX axis (horizontal) - akadai sokuti nguva kana nzvimbo.
• Uyewo, haasi yose yechati mhando inogona kusanganiswa. 3-D mabhadharo, somuenzaniso, haagoni kuiswa mubatanidzwa chati.

Excel Climate Graph Tutorial

Iyi dzidzo inotora matanho anodiwa ekubatanidza korona nematafura emutsara pamwe chete kuumba girafu yemamiriro ekunze kana climatograph , iyo inoratidza mavhareji emwedzi wechando nekupisa kweimwe nzvimbo inopiwa.

Sezvinoratidzwa mumufananidzo wepamusoro, chinyorwa chechati, kana girafu, chinoratidza mavhareji emwedzi kumativi ose apo mutsara wegara unoratidza mashizha ekupisa mafungiro.

Tutorial Steps

Matanho akaitevedzwa mumudzidzi wekugadzira dhigirimu yemamiriro okunze ndeokuti:

1. Inoita zvinhu zviviri zvakakosha sendima chati, iyo inoratidza zvose mvura inotonhora uye inotonhora mumakorani akasiyana-siyana
2. Shandura rudzi rwechati rwemashoko ekushisa kubva kubva kumakominisi kusvika kumutsara
3. Shandisa doro rekushanda kubva kumatanho okutanga vertical axis (kuruboshwe rworati) kusvika kune rimwe divi rinotsigira (kurutivi rworudyi rwe chati)
4. Shandisa maitiro ekugadzirisa maitiro ekutanga kwemafirimu emagetsi kuitira kuti ifanane nerafu inowanikwa mumufananidzo uri pamusoro

02 of 09

Kupinda uye Kusarudza Mamiriro ekunze Girafu Data

Nhanho yekutanga mukusika girafu yemamiriro ekunze ndeyekuisa dhidhiyo mumushandi webasa .

Kana imwe nhamba yave ichinyorwa, danho rinotevera nderekusarudza dambudziko richabatanidzwa mu chati.

Kusarudza kana kusimbisa deta inotsanangurira Excel kuti chii chinyorwa mubasa rekushandisa kuti chibatanidze uye chisingatauri.

Mukuwedzera kune nhamba ye data, iva nechokwadi chokuti unosanganisira zvose zvinyorwa uye mitsara yemutsara inotsanangura data.

Cherechedza: Dzidzo haisanganisi matanho ekugadzirisa pepa rekushandira sezvinoratidzwa mumufananidzo pamusoro apa. Mashoko pamusoro pekufambisa mafirimu ekushandurwa kwemashizha anowanika mune iyi inokosha yepamusoro yekudzidzisa maitiro .

Tutorial Steps

1. Pinda data sezvinoonekwa mumufananidzo uri pamusoro apa mumasero A1 kusvika C14.
2. Simbisai masero A2 kusvika kuC14 - iyi ndiyo ruzivo rwemashoko achazobatanidzwa mu chati

03 of 09

Kuumba Chati Chakanyora Chinyorwa

Mifananidzo yose inowanikwa pasi peIndaneti tab yebhoni muExcel, uye vose vanogovera zvinhu izvi:

• Paunenge uumba chero chati mu Excel, purogiramu inotanga kuumba icho chinonzi chechi chekutanga kushandisa data yakasarudzwa
• Kunyorera mouse yako pointer pamusoro pechikwata chechati kuchaunza tsanangudzo ye chati
• Kushanda pane chimwe chikamu chinotanga kudonha pasi kuratidzira zvose zvema chati zvinowanikwa mune iyoyo

Nhanho yekutanga yekusika chati yekubatanidza - yakadai sedhigirimu yemamiriro ekunze - ndeyekugadzirisa zvose data mune imwe tsati yechati uye shandura imwe deta yakagadzirirwa kune chechi yechipiri chinyorwa.

Sezvambotaurwa kare, nekuda kwemafirimu aya, tinotanga kuita mapepa ose ehurukuro pane imwe chandori chati sezvinoonekwa mumufananidzo uri pamusoro, uye zvino shandura rudzi rwechati ye data yekushisa kusvika kumurongo weropa.

Tutorial Steps

1. Ne chati ye data yakasarudzwa, chengeta paItai> Column> 2-d Dhigirii Column mubhubhoni
2. Chinokosha chinyorwa chati, chakafanana neicho chinoonekwa mumufananidzo uri pamusoro, chinofanira kusikwa uye chakaiswa mune pepa rekushanda

04 of 09

Kushandura Purezi Dhigirii kusvika kuGirafu reGirafu

Kushandura chati mifananidzo muEccel kunoitwa kuburikidza neChirongwa cheKushandura Chati yebhokisi rebhokisi .

Sezvo tichida kuchinja imwe chete yezvinyorwa zviviri zvekutsvaga zvakaratidzwa kune rimwe diki rakasiyana, tinofanira kutaurira Excel kuti ndeyei.

Izvi zvinogona kuitwa nekusarudza, kana kudhonza kamwe chete, pane imwe yemapuranga mu chati, iyo inotarisa mapuranga ose ezvo ruvara rumwechete.

Zvisarudzo zvekuvhara Chishanduko Chetatu Chengano rebhokisi rinosanganisira:

• achitsvaga paKushandura Chart Type icon paGadzira tab yebhoni
• kurondedzera pane imwe yemakorani akasarudzwa uye kusarudza Change Series Chart Type pane kubva pakaderera menu

Zvose zvinowanika mabhadhi mazita zvakanyorwa mubhokisi rebhokisi saka zviri nyore kuchinja kubva kune rimwe chati kune rimwe.

Tutorial Steps

1. Dzvanya kamwe pane imwe yehurukuro yedenga yekushisa - inoratidzwa mubhuruu mumufananidzo uri pamusoro - kusarudza mazamu ose emuvara iwoyo mu chati
2. Hover the mouse pointer pane imwe yemazamu ezvo uye chofa nechokuita ne mouse kuti uzarure mamiriro ekuderedza mamiriro acho
3. Sarudza Chishanduko Chatepa Chart Type pane kubva pakaderera pasi kuti uzarure Bhuku reKushandura Mutauro weBhokisi rekukurukura
4. Dzvanya pamutsetse wekutanga girafu sarudzo muboshwe-kuruboshwe rwebhokisi rebhokisi
5. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda
6. Muchidimbu, data yekushisa inofanirwa kuve yakaratidzwa semutsara webhuruu pakuwedzera kune zvinyorwa zvemvura yakanyanyisa

05 of 09

Kuendesa Dhairi kuChipiri Y Axis

Kushandura data yekushisa kumutsara wegamba kunogona kunge kwakaita kuti zvive nyore kusiyanisa pakati pematafura maviri e data, asi, nokuti zvose zviri kurongwa pane imwechete yakananga, data yekushisa inoratidzirwa senzira inenge yakajeka inotitaurira zvishomanana zvikuru pamusoro mwedzi wekushisa kwemazuva ose.

Izvi zvakaitika nekuda kweshamba reyero imwe chete iri kuedza kugadzirisa mbiri dzese data dzinosiyana zvakakura zvikuru.

Ivhareji yekutema data yeAcapulco ine zvishoma chete kubva pa 26.8 kusvika 28.7 degrees Celsius, asi dhigirii dheinasi yakasiyana kubva pamamiriyoni matatu kubva muna March kusvika pane 300 mm munaSeptember.

Mukugadzirisa zviyero zveatisiti yakananga kuratidza huwandu hwakawanda hwehuwandu hwemashoko, Excel yakabvisa chero kuonekwa kwekusiyana kune data yekutonhora kwegore.

Kufambisa data yechando kumutsara wechipiri wechiratidzo-kuratidzwa kurudyi kwechadhi kunobvumira zviyero zvakasiyana zvezvikamu zviviri zvepa data.

Somugumisiro, chati yacho ichakwanisa kuratidza kusiyana kweeseri mbiri dze data panguva imwecheteyo.

Kufambisa data yekushisa kune imwe yechikwata chepamusoro yakananga kunoitwa muFomendi Data Series dialog box.

Tutorial Steps

1. Dzvidza kamwe chete pamutsetse wekushisa - unoratidzwa uri mutsvuku mumufananidzo kumusoro - kuti uusarudze
2. Hover the mouse pointer pamusoro pemutsara uye kurudyi nechokuita kuti uzarure mamiriro ekuderedza mamiriro acho
3. Sarudza iyo Format Data Series yakasarudza kubva pakaderera pasi menyu kuti uzarure Format Data Series dialog box

06 of 09

Kuendesa Dhiyabhorosi kuChipiri Y Axis (con't)

Tutorial Steps

1. Dzvanya pa Series Series Options muboshwe-pane pane yebhokisi rebhokisi kana zvichidikanwa
2. Dzvanya paSecond Axis sarudzo muboshwe-kurudyi rwebhokisi rebhokisi sezvinoratidzwa mumufananidzo uri pamusoro
3. Dzvanya paBhura Rakatseka kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda
4. Muchidimbu, chiyero chemashoko ekushisa chinofanira kuonekwa zvino kurudyi rwe chati

Somugumisiro wekufambisa data yekushisa kune imwe yechipiri yakananga, mutsara unoratidzira dhigirii inofanirwa kuenzanirana inofanira kuratidza kuchinja kukuru kubva pamwedzi kusvika mwedzi zvichiita kuti zvive nyore kuona kutonhora.

Izvi zvinowanzoitika nokuti chiyero chemashoko ekushisa pamutsara wekutenderera kurutivi rworudyi che chati chava kungovhara mararamiro eashoma kudarika mana degrees Celsius pane chiyero chakatangira kubva zero kusvika ku 300 apo iyo data yakagadzirirwa kugovana one scale.

Kugadzirisa Mamiriro Okunze Girafu

Panguva ino, girafu yemamiriro ekunze inofanira kufanana nechifananidzo chakaratidzirwa muchikamu chinotevera chekudzidzisa.

Nhanho dzinosara mumudzidzisi dzinoshandisa maitiro ekufomisa kwemafirimu emamiriro ekunze kuitira kuti zvifanane nemufananidzo unoratidzwa mudanho rimwe.

07 of 09

Kugadzirisa Mamiriro Okunze Girafu

Kana zvasvika pakugadzirisa matati mu Excel haufaniri kubvuma kushandiswa kwekusimbisa kwechikamu chipi nechipi che chati. Zvikamu zvose kana zvikamu zvechati zvinogona kuchinjwa.

Maikirwo ekugadzirisa ematsetse acho anowanikwa pane matatu matabhi edhibhoni ayo anowanzonzi Chart Tools

Kazhinji, aya matatu matatu haaoneki. Kuti uwane mazviri, zvinyoronyoro pa chati yawakangobva kuumba uye matatu matabhi - Kugadzira, Kurongeka, uye Format - yakawedzerwa kubhoni.

Pamusoro pematatu matatu, iwe uchaona musoro weChirati Tools .

Muchikamu chekudzidzisa chinotevera matanho aya anotevera achachinja:

• Wedzera chati uye mazita ane mazita
• fambisa chikamu kumusoro kwecha chati
• Shandura mafaira uye mivara yakabva
• Itai rutivi rwekunze kwechati
• Resize chati

Kuwedzera Horizontal Axis Title

Mutsara wakarurama unoratidza mazuva ari pasi pechati.

1. Dzvanya pane chetatu iri mubasa rekushanda kuti uburise tashandisi tate
2. Dzvanya paIndaneti tab
3. Dzvanya paAxis Titles kuti uzarure pasi rezasi
4. Dzvanyira paPamusoro Pakuzorora Axis Title> Musoro Pasi paAxis sarudzo yekuti uwedzere mutsetse wekuti Axis Title ku chati
5. Dragradza chinyorwa chekutsvaga kuti chionekwe
6. Nyora mubhuku rinonzi " Mwedzi "

Kuwedzera Primary Primary Vertical Axis Title

Inonyanya kutaridzika inoratidza huwandu hwemagove akatengeswa kurutivi rworuboshwe rwechati.

1. Dzvanya pa chati kana zvichidikanwa
2. Dzvanya paIndaneti tab
3. Dzvanya paAxis Titles kuti uzarure pasi rezasi
4. Dzvanya paIt Primary Vertical Axis Title> Yakatenderedzwa Chete Chokutora kuti uwedzere mutemo weAxis Title unotsvaga pane chati
5. Simbisa zita rakashata
6. Nyora mubhuku rinonzi " Precipitation (mm) "

Kuwedzera chikamu cheSekondari Chinyorwa Chekutanga

Ikosi yepamusoro yakananga inoratidza kutengesa kwematengo ematengesi akatengeswa kurutivi rworudyi rwe chati.

1. Dzvanya pa chati kana zvichidikanwa
2. Dzvanya paIndaneti tab
3. Dzvanya paAxis Titles kuti uzarure pasi rezasi
4. Dzvanya paChipiri Chechipiri Axis Title> Yakatenderedzwa Tsvakurudzo Chokutanga kuti uwedzere mutsetse wekuti Axis Title ku chati
5. Simbisa zita rakashata
6. Nyora mumusoro unoti " Average Temperature (° C) "

Kuwedzera Chati Chinyorwa

1. Dzvanya pa chati kana zvichidikanwa
2. Dzvanya paIndaneti tab yebhoni
3. Dzvanya pane Chati Chete> Chapa Chati chokusarudza kuti uwedzere Mutsetsi weTrasi yekutsika pane chati
4. Simbisa zita rakashata
5. Nyora mubhuku rinonzi Climatograph yeAcapulco (1951-2010)

Kuchinja Chati Title Font Font

1. Dzvidza kamwechete pane Chati Chete kuti uchisarudze
2. Dzvanya paImba yebhu pa menu yebhoni
3. Dzvanya pamusika wezasi wePolisi Colour sarudzo kuti uzarure masiki pasi
4. Sarudza Denga Dzvuku kubva pasi peClass Standard Colors yemenyu

08 of 09

Kufambisa Gwara uye Kuchinja Nzvimbo Yenharaunda Colors

Nokusingaperi, chikamu chechati chiri kuruoko rworudyi rwe chati. Kana tikangowedzera chikamu chechikwata chechipiri, zvinhu zvinowanikwa zvishoma munzvimbo iyoyo. Kuti kuderedza kusanganisa tichaendesa nheyo yacho kumusoro kwecha chati pasi pechinyorwa chechati.

1. Dzvanya pa chati kana zvichidikanwa
2. Dzvanya paIndaneti tab yebhoni
3. Dzvanya paGe Legend kuti uzarure pasi rezasi
4. Dzvanya paRendendendende yeZvinyorwa paKusarudza kwakanakisisa kutamisa nharo kuva pasi pechati chechati

Kushandisa Kontext Menu Kufambisa Options

Mukuwedzera kune zvishandisi zvechadhi thabhi pane ribhoni, kuchinja maitiro kunogona kuitwa kumatarethi uchishandisa yemvura yakaderera kana mamiriro ekutenderera iyo inotanga kana iwe ukanyora pane chimwe chinhu.

Kushandura mavara ekupedzisira kwechadhi rose uye nzvimbo yenzvimbo - iyo bhokisi rakakura re chati rinoratidza data - richaitwa kuburikidza nemenyu yakatarisana.

Kushandura Mutero Wacho Mamiriro Akasiyana-siyana

1. Kumbofa nechokuita pane chichena chemashure kuti uzarure mamiriro ekutenderera kwechati
2. Dzvanya pamutsara muduku pasi kusvika kurudyi rweZviza Zara Radzaza - pende inogona - mumubhairi wezvakakonzera kuti uzarure hurukuro yeChinyorwa Chevara
3. Dzvanya paGreen, Chigadziko 1, Chima 35% kuti uchinje chikara chemutsara kumusi mutema

Kuchinja Nzvimbo Yacho Mavara Akasiyana

Cherechedza: Chenjerera kuti usasarudza mitsetse yakananga yemigero inoshandisa nzvimbo iyo nzvimbo panzvimbo yemamiriro acho pachako.

1. Kumbofa nechokuita pane chivara chenzvimbo chekuyera kuti uzarure nzvimbo yemugariro yemamiriro ezvinhu
2. Dzvanya pamutsara muduku pasi kusvika kurudyi rweZviza Zara Radzaza - pende inogona - mumubhairi wezvakakonzera kuti uzarure hurukuro yeChinyorwa Chevara
3. Dzvanya paGreen, Chigadziko 1, Chima 15% kuti uchinje nzvimbo yakatarisa ruvara rwemuvara kuchena grey

09 of 09

Kuwedzera Dhiyabhorosi ye-3-D uye Kubatazve Chati

Kuwedzera kuitika kwe 3-D kunowedzera kumwe kwakadzika kune chati. Iyo inobva mubati iri nechemberi yakatarisa kunze kwechokumativi.

1. Kumbofa nechokuita pakatarisa chati chakanaka kuti uzarure mamiriro ekutenderera yechati
2. Dzvanya paGadzira Chirongwa cheSain Area munzvimbo yebhari yezvakakosha kuti uzarure bhokisi rebhokisi
3. Dzvanya pa 3-D Format mubhokisi rweruboshwe rweBhokisi reKirasi yeChikwata chebhokisi
4. Dzvanya pamusara wezasi kusvika kurudyi rweIndaneti yepamusoro mubhokisi rekurudyi kuti uzarure mararamiro evevel
5. Dzvanya pa Circle sarudzo mujeri - chokutanga chokutanga muchikamu cheBevel chepaneti
6. Dzvanya paBhura Rakatseka kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda

Kudzokorora Chati

Kudzokorora chati yacho ndeimwe imwe danho rekuita. Kubatsira pakuita chati yakawanda ndechokuti kunoderedza kutarira kwevanhu vakawanda kwakagadzirwa nechechipiri yakananga kudivi kuruoko rworudyi rwe chati.

Ichawedzerawo huwandu hwemaiti nzvimbo iyo inoita chati chati nyore kuverenga.

Nzira iri nyore yokugarisa chati ndeyokushandisa zvigadziro zvinoshandiswa zvinoshanda zvakapoteredza nechekunze kwechati kana iwe ukanyora pairi.

1. Dzvanya kamwe pane chati yechati kuti usarudze chati yose
2. Kusarudza chati kunowedzera mutsetse wakachena webhuruu kusvika kumucheto kunze kwechati
3. Mumakona emutsara uyu webhuruu ndeyekusimudza mashizha
4. Hover your mouse pointer pamusoro peimwe yemakona kusvika iyo pointer ichinje kuva museve wakaita mutsvuku
5. Apo pointer iyi iyi museve-musoro, tsanidza nebhokisi reboshwe redu uye tira kunze zvishoma kuti uwedzere chati. Icho chati ichadzokorora zvakare mukati marefu nehupamhi. Nzvimbo yacho inofanira kuwedzera muhukuru pamwe chete.

Kana iwe wakatevera matanho ose mune izvi zvidzidzo panguva ino Mamiriro ako ekunze anoratidza kufanana nemuenzaniso wakaratidzwa mumufananidzo pane chikamu chekutanga chekudzidzisa.