01 yegumi
Nhoroondo ye Excel 2003 Chart Wizard
Izvi zvidzidzo zvinotora matanho ekusika girafu yemutsara muExcel 2003 uchishandisa Excel Chart Wizard.
Kuzadza matanho ari mumusoro ari pasi apa kuchabudisa girafu yemutsara yakafanana nechifananidzo chiri pamusoro.
02 yegumi
Kupinda muChina Graph Data
Hazvina mhosva kuti uri kutora chati kana grafu, danho rokutanga mukugadzira Excel chati nguva dzose kuisa data mumushandi webasa .
Paunopinda munharaunda, chengeta mitemo iyi mupfungwa:
- Usasiya mitsetse isina kana mabhuroji kana uchinge waisa deta yako.
- Isa data yako muhurukuro.
- Paunenge uchiisa pepa rako, nyora mazita anotsanangura data iri mune imwe korombo uye, kune iyo yakarurama, iyo data pachayo.
- Kana pane pane imwe nhepfenyuro yedheta, nyora imwe imwe pashure peimwe mumakoroni ane musoro weheji yega yega data kumusoro.
Tutorial Steps
- Pinda data sezvinoonekwa mumufananidzo uri pamusoro apa mumasero A1 kusvika kuC6.
03 wegumi
Kusarudza iyo Line Graph Data
Achishandisa mouse
Kushandisa keyboard
- Dzvanya kumusoro kumusoro kuruboshwe rwemashoko erafu .
- Tora pasi SHIFT key pa keyboard.
- Shandisai miseve yemiseve pabhokisi kuti musarudze deta kuti iiswe mumutsara weropa.
Cherechedza: Iva nechokwadi chekusarudza chero imwe koromo uye mutsara wemutsara iwe waunoda kuiswa mugrafu.
Tutorial Steps
- Simbisa bhokisi remasero kubva paA2 kusvika kuC6, iro rinosanganisira mazita emakoroni uye misoro yemutsara uchishandisa imwe yenzira idzi dziri pamusoro.
04 yegumi
Kutanga Mutsetse Wadhidhi
Iwe une zvisarudzo zviviri zvekutanga Excel Chart Wizard.
- Dzvanya paChirati cheKadhi Wizard pachidimbu chebhari (ona mufananidzo wepamusoro)
- Dzvanya kuIta> Chati ... mumam menus.
Tutorial Steps
- Tanga Chati Wadhidhiyo uchishandisa nzira yaunoda.
05 of 10
The Excel Chart Wizard Step 1
Sarudza Chati pane Standard Tab
- Sarudza Chati chechirwere kubva kuruboshwe rworuboshwe.
- Sarudza chinyorwa chechidimbu kubva pane chakanaka.
Tutorial Steps
- Sarudza Mutsetse weChirongwa cheChina mune kuruboshwe-pane pane.
- Sarudza Mutsara nemakadhi echirongwa chemukati-werudzi mune kurudyi
- Dhinda Kutevera.
06 of 10
The Excel Chart Wizard Step 2
Ongorora Cheti yako
- Zvawakasarudza deta yako usati watanga Excel Chart Wizard, unofanira kuona muenzaniso wechadhi yako muwindo rehotera rebhokisi rebhokisi.
- Pamapepaneteti ako, dhesi iyo yakaiswa mu chati yacho yakakomberedzwa nemhashu dzinofamba-muganhu wakanga uri mutsva wakakomberedza deta yako.
- Pasi pewindo rekuona mahwindo ibhokisi rine zvinyorwa zvesekodhi zvehutano hwemashoko zvakabatanidzwa mu chati. Kana chati yako isingatarisi zvakanaka, chengeta kuti uve nechokwadi chokuti wakasarudza dhiyabhorosi yakarurama yedhesi muparapariti.
Tutorial Steps
- Dhinda Kutevera.
07 pa10
The Excel Chart Wizard Step 3
Chart Options
Kunyange zvazvo pane zvakawanda zvingasarudzwa pasi pemateji matanhatu ekugadzirisa maitiro echati yako, mu danho iri, tichava kungowedzera mazita.
Zvose zvikamu zveExcel chati zvinogona kuchinjwa mushure mekunge mazadza Mutengo Wetsva, saka hazvidikanwi kuita zvese zvamunogona kuita maitiro ikozvino.
Tutorial Steps
- Dzvanya paZita reZvitsa tab pamusoro peKateti Wizard bhokisi rebhokisi.
- Mubhokisi rebhokisi rebhokisi, nyora musoro wacho: Average Precipitation for Acapulco naAmsterdam .
- Muchikamu (X) axis box, chinyorwa: Mwedzi .
- Muchikamu (Y) axis box, chikwata: Precipitation (mm) (Cherechedza: mm = mamita).
- Apo chati iri muwindo rekuona maonero rinotarisa zvakanaka, chengeta Izvozvi.
Cherechedza: Sezvaunonyora zvinyorwa, dzinofanira kuwedzerwa kuwindo rekuona kurudyi kusvika kurudyi
08 yegumi
The Excel Chart Wizard Step 4
Girafu Nzvimbo
Pane zvingarudzo zviviri chete pane kwaunoda kuisa girafu yako:
- Sechitsva chetsva (inonyora chati pane rimwe bhuku rinobva kune rimwe bhuku rako rebhuku)
- Sechimwe chinhu chinyorwa 1 (isa chati pane peji rimwechete se data yako mubhuku rebhuku)
Tutorial Steps
- Dzvanya bhodhi redhiyo kuti uise girafu sechinhu chiri peji 1.
- Chofoza Finish.
Chinokosha girafu chakasikwa uye chakaiswa pane pepa rako rekushanda. Mapeji acho anotevera akavhara firimu iyi kuti ienzane nemutsara wegrafu unoratidzwa muChikamu chekutanga chekudzidzisa.
09 yegumi
Kugadzirisa Line Line Grafu
Isa chigaro che grafu pamitsara miviri
- Dzvidza kamwechete neine mouse pointer kupi zvako pane chinyorwa chemafirimu kuti uchisimbise.
- Dzvanya kechipiri pamwe nemushonga weguniti pamberi pegwaro Acapulco kuti uwane kuisa pfungwa.
- Dhinda iri ENTER kiyi pane keyboard kuti ugovere mutauro we grafu mumiganhu miviri.
Shandura ruvara rwemuvara we grafu
- Kurudyi-kanda kamwe chete ne mouse pane pointer chero kupi zvayo pamuchena mutsvuku wegrafu kuti uzarure menyu pasi.
- Dzvanya neefiniti pointer pane chokutanga chokutanga pane menyu: Ronga Chati Yenharaunda kuti uzarure Bhokisi reKwata Chakasi yebhokisi yebhokisi.
- Dzvanya paZvienzaniso tab kuti uzvisarudze.
- Mune chikamu chikamu, chengetera pavaravara remavara kuti uzvisarudze.
- Nokuda kweikudzidzisa, sarudza chiedza chine ruvara pasi pebhokisi rebhokisi.
- Dzvanya OK.
Shandura ruvara rwemukati / bvisa muganhu kubva munheyo
- Kurudyi-chengetedza kamwe chete nemushonga pointer chero kupi zvako kumucheto wegrafu's legend kuti uzarure mhuka inodonha.
- Dzvanya neiyo mouse pointer pane chokutanga pane menyu: Format Legend kuti uzarure Format Legend dialog box.
- Dzvanya paZvienzaniso tab kuti uzvisarudze.
- Muchikamu cheBorder pane kuruboshwe rwebhokisi rebhokisi, chengetedza paChina chisarudzo chokubvisa muganhu.
- Mune chikamu chikamu, chengetera pavaravara remavara kuti uzvisarudze.
- Nokuda kweikudzidzisa, sarudza chiedza chine ruvara pasi pebhokisi rebhokisi.
- Dzvanya OK.
10 pa10
Kugadzira Mutsara weGirafu (Inopfuurira)
Shandura ruvara / bvisa muganhu wenzvimbo yacho
- Kurudyi -click kamwe ne mouse pane pointer kupi zvako pane grey plot iri ye grafu kuti uzarure mhando yezvinyorwa.
- Dzvanya neyo mouse pointer pane chokutanga pane menyu: Ita Plot Area kuti uzarure Fomendi Plot Area dialog box.
- Dzvanya paZvienzaniso tab kuti uzvisarudze.
- Muchikamu cheBorder pane kuruboshwe rwebhokisi rebhokisi, chengetedza paChina chisarudzo chokubvisa muganhu.
- Muchikamu chechikamu kune kurudyi, chengetera pavaravara remavara kuti uzvisarudze.
- Nokuda kweikudzidzisa, sarudza chiedza chine ruvara pasi pebhokisi rebhokisi.
- Dzvanya OK.
Bvisa Y axis
- Kurudyi-chengetedza kamwe chete neine mouse pointer pa Y axis (iyo yakananga mutsara pedyo nemvura yakanyanyisa) yemirafu kuti uzarure mhando inodonha.
- Dzvanya ne mouse pane pointer pane chokutanga chokutanga pane menyu: Ronga Axis kuti uzarure Format Axis dialog box.
- Dzvanya paZvienzaniso tab kuti uzvisarudze.
- Muchikamu cheLines pane kuruboshwe rwebhokisi rebhokisi, chengetedza paChina chisarudzo chekubvisa mutsara wehesi.
- Dzvanya OK.
Pano, girafu yako inofanira kufanana nemutsara wegrafu unoratidzwa muChikamu chekutanga chekudzidzisa.