Excel 2003 Pie Chart Tutorial

01 yegumi

Excel 2003 Pie Chart Tutorial

Iyi tutori inosanganisira matanho ekugadzira chati yepayiri muExcel 2003 uchishandisa Excel Chart Wizard.

Kuzadza matanho ari mumusoro ari pasi apa kuchabudisa chati yepayiri yakafanana nechomufananidzo.

Kusiyana kweshanduro

Nhanho dziri mumudzidzi uyu dzinoshandisa maitiro uye maitiro aunogona kuwanikwa muExcel 203. Izvi zvakasiyana kubva kune zvakawanikwa mumavambo ekutanga ehurongwa. Shandisa zvinotevera zvinoshandiswa kumatareji emutsara emagetsi kune dzimwe shanduro dze Excel.

02 yegumi

Kupinda Data yePie Chart

Cherechedza: Kuti ubatsirwe nemirairo iyi, ona muenzaniso wechifananidzo pamusoro apa.

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:

1. Usasiya mitsetse isina kana mabhuroji kana uchinge waisa deta yako.
2. 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.

Nokuda kweikudzidzisa iyi

1. Pinda data sezvinoonekwa mumufananidzo uri pamusoro apa mumasero A3 kusvika B6.

03 wegumi

Kusarudza Data yePie Chart

Cherechedza: Kuti ubatsirwe nemirairo iyi, ona muenzaniso wechifananidzo pamusoro apa.

Achishandisa mouse

1. Dragradza nebhokisi rekuisa kuti uise pachena masero ane data kuti aiswe muchirafu.

Kushandisa keyboard

1. Dzvanya kumusoro kumusoro kuruboshwe rwemashoko erafu.
2. Tora pasi SHIFT key pa keyboard.
3. Shandisai mitsara yemiseve pabhokisi kuti musarudze deta kuti iiswe mu chati yepee.

Cherechedza: Iva nechokwadi chekusarudza chero imwe koromo uye mutsara wemutsara iwe waunoda kuiswa mugrafu.

Nokuda kweikudzidzisa iyi

1. Simbisa bhokisi remasero kubva paA3 kusvika kuB6 uchishandisa imwe yenzira idzi pamusoro apa.

04 yegumi

Kutanga Mutsetse Wadhidhi

Cherechedza: Kuti ubatsirwe nemirairo iyi, ona muenzaniso wechifananidzo pamusoro apa.

Iwe une zvisarudzo zviviri zvekutanga Excel Chart Wizard.

1. Dzvanya paChirati cheKadhi Wizard pachidimbu chebhari (ona mufananidzo wepamusoro)
2. Dzvanya kuIta> Chati ... mumam menus.

Nokuda kweikudzidzisa iyi

1. Tanga Chati Wadhidhiyo uchishandisa nzira yaunoda.

05 of 10

The Excel Chart Wizard Step 1

Sarudza Chati pane Standard Tab

Cherechedza: Kuti ubatsirwe nemirairo iyi, ona muenzaniso wechifananidzo pamusoro apa.

1. Sarudza Chati chechirwere kubva kuruboshwe rworuboshwe.
2. Sarudza chinyorwa chechidimbu kubva pane chakanaka.

Nokuda kweikudzidzisa iyi

1. Sarudza dhairi yepaPe inonzi kuruboshwe-pane pane.
2. Sarudza Pie ne-3-D inooneka sechati chinonzi sub-type mune kurudyi
3. Dhinda Kutevera.

06 of 10

The Excel Chart Wizard Step 2

Ongorora Cheti yako

Cherechedza: Kuti ubatsirwe nemirairo iyi, ona muenzaniso wechifananidzo pamusoro apa.

• 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.

Nokuda kweikudzidzisa iyi

1. Dhinda Kutevera.

07 pa10

The Excel Chart Wizard Step 3

Chart Options

Cherechedza: Kuti ubatsirwe nemirairo iyi, ona muenzaniso wechifananidzo pamusoro apa.

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.

Nokuda kweikudzidzisa iyi

1. Dzvanya paZita reZvitsa tab pamusoro peKateti Wizard bhokisi rebhokisi.
2. Mubhokisi rebhokisi rebhokisi, tanga zita racho: The Cookie Shop 2007 Sales Revenue .
3. Dzvanya paDhiyabhorosi Dheyo Dhaseti pamusoro peKateti Wizard bhokisi rebhokisi.
4. Mune Zita Rine Chikamu, chengeta pa Percentage option kuti uisarudze.
5. Apo chati iri muwindo rekuona maonero rinotarisa zvakanaka, chengeta Izvozvi.

Cherechedza: Sezvaunowedzera mazita uye zvinyorwa zvepa data zvinofanira kuwedzerwa pawindo rekuona kurudyi kusvika kurudyi.

08 yegumi

The Excel Chart Wizard Step 4

Chati Nzvimbo

Cherechedza: Kuti ubatsirwe nemirairo iyi, ona muenzaniso wechifananidzo pamusoro apa.

Pane zvingarudzo zviviri chete paunoda kuisa chati yako:

1. Sechitsva chetsva (inonyora chati pane rimwe bhuku rinobva kune rimwe bhuku rako rebhuku)
   
2. Sechimwe chinhu chinyorwa 1 (isa chati pane peji rimwechete se data yako mubhuku rebhuku)

Nokuda kweikudzidzisa iyi

1. Dzvanya bhodhi redhiyo kuti uise chati yacho sechinhu chiri peji 1.
2. Chofoza Finish.

Chimwe chetatu chepee chinogadzirwa uye chakaiswa pane pepa rako rekushanda. Mapeji anotevera anovhara fomati iyi chinyorwa kuti ifanane ne chati yepayiri inoratidzwa muChikamu chekutanga chekudzidzisa.

09 yegumi

Kuwedzera Ruvara kuChirati chePie

Cherechedza: Kuti ubatsirwe nemirairo iyi, ona muenzaniso wechifananidzo pamusoro apa.

Shandura ruvara rwemukati che chati

1. Kumbofa kamwe chete ne mouse pane chero kupi zvayo pamucheto mutsvuku wegrafu kuti uzarure masiki pasi.
2. Dzvanya neefiniti pointer pane chokutanga chokutanga pane menyu: Ronga Chati Yenharaunda kuti uzarure Bhokisi reKwata Chakasi yebhokisi yebhokisi.
3. Dzvanya paZvienzaniso tab kuti uzvisarudze.
4. Mune chikamu chikamu, chengetera pavaravara remavara kuti uzvisarudze.
5. Nokuda kweiyo maitirwo, sarudza muvara wepepuru pasi nechokurudyi kwebhokisi rebhokisi.
6. Dzvanya OK.

Shandura ruvara rwemukati / bvisa muganhu kubva munheyo

1. Kungofa kamwe chete ne mouse pane imwe nzvimbo pamusana pegwara regrafu kuti uzarure menyu.
2. Dzvanya neiyo mouse pointer pane chokutanga pane menyu: Format Legend kuti uzarure Format Legend dialog box.
3. Dzvanya paZvienzaniso tab kuti uzvisarudze.
4. Muchikamu cheBorder pane kuruboshwe rwebhokisi rebhokisi, chengetedza paChina chisarudzo chokubvisa muganhu.
5. Mune chikamu chikamu, chengetera pavaravara remavara kuti uzvisarudze.
6. Nokuda kweiyo maitirwo, sarudza muvara wepepuru pasi nechokurudyi kwebhokisi rebhokisi.
7. Dzvanya OK.

10 pa10

Kubvongodza Chikamu chePie

Cherechedza: Kuti ubatsirwe nemirairo iyi, ona muenzaniso wechifananidzo pamusoro apa.

Kuti uwedzere kusimbiswa kune chimwe chidimbu chechipiri iwe unogona kutama kana "kuputika" ichi chikamu kubva kune imwe sarati.

1. Dzvanya pamwe nehomwe pointer pane chati kuti uisimbise. Zviduku zviduku zvakasvibirira zvinofanira kuonekwa pamucheto wekunze weiyo.
2. Dzvanya kechipiri neine mutsara weganda pajena (oatmeal raisin) slice we pie. Zuva rakasvibirira rinofanira kunge rakapoteredza ikozvino rumwe rutivi rwecheka.
3. Dzvanya uye dhonza kuruboshwe nehomwe pointer pachikamu chekasi chechipiri. Tsanga yacho inofanira kubva kune imwe shata.
4. Kuti ushandise chikamu chakaputika kudzokera kunzvimbo yaro yepakutanga kudzokorora matanho 1 ne2 kumusoro uye dhonza slice kumashure. Ichazodzokera kunzvimbo yayo yepakutanga.

Nekacheka tsvuku yakaputika chati yako inofanira kufanana ne chati yepayiri inoratidzwa muChikamu chekutanga chekudzidzisa.