Nzira Yokugadzira Nayo Girafu muExcel 2010

Mirafu yemirara inowanzoshandiswa kuronga kuchinja munharaunda pane nguva, zvakadai sekushanda kwemazuva ose kwemazuva kana kuchinja kwezuva nezuva mumatengo emusika. Inogonawo kushandiswa kugadzira deta yakanyorwa kubva kuongororo yezvesayenzi, yakadai sekushandiswa kwemakemikari kunoshandura kutonhora kana kushanda kwemhepo.

Kufanana nemamwe magrafu, magrafu emirara ane vertical axis uye yakanyatsosangana axis. Kana iwe uri kuronga kuchinja mune data pane nguva, nguva yakarongwa pamwe chete nechepakati kana x-axis nedzimwe nhepfenyuro yako, zvakadai semvura inogadziriswa inorongwa semunhu pachake pamutsara kana y-axis.

Kana munhu wepodha manotsi akabatanidzwa nemitsara, anonyatsoratidza kuchinja mune deta yako - seyakadai semakemikari anoshanduka nekuchinja kushandiswa kwemhepo. Iwe unogona kushandisa shanduko idzi kuti uwane maitiro muudada wako uye zvichida kufanotaura zvichaitika mune ramangwana. Kutevera matanho mune iyi tutori inokufambisa kuburikidza nekusika nekugadzirisa mutsara wemavara unoonekwa mumufananidzo uri pamusoro.

Kusiyana kweshanduro

Nhanho dziri mumudzidzi uyu dzinoshandisa maitiro ekugadzirisa uye masarudzo anowanikwa muExcel 2010 uye 2007. Izvi zvinopesana neawanikwa mune dzimwe shanduro dzepurogiramu, saExcel 2013 , Excel 2003 , uye mavambo akare.

01 of 06

Kupinda muGrafu Data

Pinda muGrafu Data

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 iri muchitsauko 8.

02 of 06

Sarudza Line Graph Data

Zvisarudzo zviviri zvekusarudza Girafu Data

Achishandisa mouse

1. Dragraya nebhokisi rekuisa kuti uise pachena masero ane data kuti aiswe mumutsara wegrafu.

Kushandisa keyboard

1. Dzvanya kumusoro kumusoro kuruboshwe rwemashoko emirasi yemurongo.
2. Tora pasi SHIFT key pa keyboard.
3. Shandisai miseve yemiseve pabhokisi kuti musarudze deta kuti iiswe mumutsara weropa.

Cherechedza: Iva nechokwadi chekusarudza chero imwe koromo uye mitsara yemutsara iwe waunoda inowanikwa muirafu.

Nokuda kweikudzidzisa iyi

1. Simbisa bhokisi remasero kubva paA2 kusvika kuC6, iro rinosanganisira mazita emakoromoni uye mutsara wemutsara

03 of 06

Kusarudza Mutsara Girafu Rudzi

Kusarudza Mutsara Girafu Rudzi

Kuti ubatsirwe nemirairo iyi, ona muenzaniso wechifananidzo pamusoro apa.

1. Dzvanya paIndaneti ribhoni tab.
2. Dzvanya pane chikamu chechati kuti uzarure rutsoka rwezasi rwemafirimu aripo (Hovering your mouse pointer pamusoro pemhando yeropa ichaunza tsananguro yemirafu).
3. Dzvanya pamhando yeropa kuti uisarudze.

Nokuda kweikudzidzisa iyi

1. Sarudza Insert> Mutsara> Mutsara pamwe neMarkers .
2. Chinokosha girafu chakasikwa uye chakaiswa pane pepa rako rekushanda. Mapeji acho anotevera akavhara firimu iyi kuti ienzane nemutsara wegrafu unoratidzwa muChikamu chekutanga chekudzidzisa.

04 of 06

Kugadzira Mutsara Girafu - 1

Kugadzira Mutsara Girafu - 1

Paunenge uchinyora patafura, tate matatu - Design, Layout, uye Format tabo dzinowanikwa kudhibhoni pasi pezita reChirt Tools .

Kusarudza chimiro chekambani yemirafu

1. Dzvanya pamurongo weropa.
2. Dzvanya paGadziriro yebhu.
3. Sarudza Chimiro chechina cheChart Styles

Kuwedzera musoro kumurongo weropa

1. Dzvanya paIndaneti tab.
2. Dzvanya pa Chati Chete pasi pechikamu cheMabhuku .
3. Sarudza chisarudzo chechitatu - Pamusoro Chetati .
4. Nyora mubhuku rinonzi " Average Precipitation (mm) "

Kushandura mutsetse wepavara wepeji ye grafu

1. Kamwe kamwe paGrafu Title kuti uisarudze.
2. Dzvanya paImba yebhu pa menu yebhoni.
3. Dzvanya pamusika wezasi wePolisi Ruvara sarudzo kuti uzarure mhando inodonha.
4. Sarudza Denga Dzvuku kubva pasi peClass Standard Colors yemenyu.

Kuchinja mhando yepavara yemifananidzo yegrafu

1. Kamwe kamwe paGrafu Legend kuti uisarudze.
2. Dzokorora matanho 2 - 4 pamusoro.

Kuchinja mhando yepavara yemashizha e-axis

1. Dzvidza kamwechete pamavara emwedzi ari pasi pepakanyanyisa X axis kuti uvasarudze.
2. Dzokorora matanho 2 - 4 pamusoro.
3. Dzvidza kamwechete pane nhamba pedyo ne- Y axis yechiratidzo kuti uvasarudze.
4. Dzokorora matanho 2 - 4 pamusoro.

05 of 06

Kugadzira Mutsara Girafu - 2

Kugadzira Mutsara Girafu - 2

Kuisa ruvara rwemafirimu

1. Dzvanya pane grafu chitubu.
   
2. Dzvanya paChimiza Chizadza sarudzo yekuti uzarure imenyu inodonha.
   
3. Sarudza Tsvuku, Chipiri 2, Chiedza 80% kubva muchikamu cheMutambo Wechikamu chemenyu.

Kuisa ruvara rwemaunda nzvimbo yakatarwa

1. Dzvanya pane imwe yemigwagwa yakanyatsokonzera kuti uwane nzvimbo yepadhi ye grafu.
2. Sarudza Mifananidzo Yadzadza> Madireji> Kubva Pakati pekusarudza kubva mumenyu.

Kuchengetedza ruzivo rwemafirimu

1. Dzvanya patafura kuti uisarudze.
2. Dzvanya paChimiza Chizadza sarudzo yekuti uzarure imenyu inodonha.
3. Sarudza Bhuku > Muchinjikwa kubva kumenyu.

Pano, girafu yako inofanira kufanana nemutsara wegrafu unoratidzwa muChikamu chekutanga chekudzidzisa.

06 of 06

Mifananidzo Grafu Tutorial Data

Pinda data iri pasi apa mumasero akaratidzirwa kuti uite girafu yemutsara yakavharwa mune iyi tutori.

Cell - Data
A1 - Average Precipitation (mm)
A3 - January
A4 - April
A5 - July
A6 - October
B2 - Acapulco
B3 - 10
B4 - 5
B5 - 208
B6 - 145
C2 - Amsterdam
C3 - 69
C4 - 53
C5 - 76
C6 - 74