Indlela Yakha I-Graph Line ku-Excel 2010

Amagrafu womugqa asetshenziselwa ukuhlela ushintsho kwimininingwane ngokuhamba kwesikhathi, njengokushintsha kwenyanga lokushisa noma izinguquko zansukuzonke ezintengo zamakethe. Zingasetshenziselwa ukuhlela idatha eqoshiwe kusuka ekuhlolweni kwesayensi, njengokuthi ikhambi liyakuthinta kanjani izinga lokushisa lokushisa noma ingcindezi yomoya.

Njengamanye amagrafu amaningi, amagrafu emigqa ane-axis eqondile kanye ne-axis enezingqimba. Uma uhlela izinguquko kudatha ngokuhamba kwesikhathi, isikhathi sihlelwe eceleni kwe-axis noma i-x-axis kanye nedatha yakho, njengemali yemvula ihlelwe njengamaphuzu ngamanye amaphuzu eceleni kwe-yile noma y-axis.

Uma amaphuzu emininingwane yedatha exhunyiwe ngemigqa, abonisa ngokucacile ushintsho kudatha yakho - njengokuthi indlela ikhemikhali ishintshe ngayo ngokushintsha ingcindezi yomkhathi. Ungasebenzisa lezi zinguquko ukuthola izitayela kudada yakho futhi mhlawumbe ukubikezela imiphumela yesikhathi esizayo. Ukulandela izinyathelo kulesi sifundo kukuhamba ngokudala nokufometha igrafu yomugqa ebonwe esithombeni ngenhla.

Izinguquko zenguqulo

Izinyathelo kulesi sifundo zisebenzisa izinketho zokufometha nezakhiwo ezitholakalayo ku-Excel 2010 no-2007. Lokhu kuhluke kulabo abatholakala kwezinye izinguqulo zohlelo, njenge- Excel 2013 , i- Excel 2003 , nezinguqulo zangaphambili.

01 ka-06

Ukufaka idatha yeGrafu

Faka Idatha yeGrifu

Ukuze uthole usizo ngalezi ziqondiso, bheka isibonelo sesithombe ngenhla

Kungakhathaliseki ukuthi uluhlobo luni lweshadi noma igrafu owenzayo, isinyathelo sokuqala ekudaleni i-Excel ishadi njalo ukufaka idatha kufasiteleni lokusebenzela .

Uma ufaka idatha, gcina le mithetho engqondweni:

1. Ungashiyi imigqa noma amakholomu angenalutho uma ufaka idatha yakho.
2. Faka idatha yakho kukholomu.

• Uma ubeka ispredishithi sakho, hlola amagama achaza idatha kukholomu eyodwa futhi, ngakwesokudla kwalokho, idatha ngokwayo.
• Uma kunezinchungechunge ezingaphezu kweyodwa yedatha, zifake ohlwini olulodwa ngemva kweminye kukholomu ngesihloko sochungechunge lwedatha ngayinye phezulu.

Kulesi sifundo

1. faka idatha etholakala esigabeni 8.

02 ka 06

Khetha Idatha yeGrafu ye-Line

Izinketho ezimbili zokukhetha idatha yeGrafu

Ukusebenzisa igundane

1. Hudula ukhethe inkinobho yegundane ukugqamisa amangqamuzana aqukethe idatha ukuba ifakwe egrafu yomugqa.

Ukusebenzisa ikhibhodi

1. Chofoza phezulu ngakwesokunxele kwedatha yesigrafu yomugqa.
2. Gweba ukhiye we- SHIFT kukhibhodi.
3. Sebenzisa izinkinobho zemicibisholo ekhibhodi ukuze ukhethe idatha ukuthi ifakwe egrafu yomugqa.

Qaphela: Qinisekisa ukuthi ukhetha noma yiliphi ikholomu nezihloko zegqa ofunayo ezifakwe kugrafu.

Kulesi sifundo

1. Qinisekisa ibhokisi lamaseli ukusuka ku-A2 kuya ku-C6, okufaka izihloko zekholomu kanye nezihloko zomugqa

03 ka 06

Ukukhetha i-Line Line Graph Uhlobo

Ukukhetha i-Line Line Graph Uhlobo

Ukuze uthole usizo ngalezi ziqondiso, bheka isibonelo sesithombe ngenhla.

1. Chofoza kuthebhu ye-Ribbon yokufaka.
2. Chofoza kusigaba seshadi ukuze uvule uhlu oludonsa phansi lwezinhlobo zegrafu ezitholakalayo (Ukuhambisa inkomba yakho yegundane phezu kohlobo lwegrafu kuzokhipha incazelo yegrafu).
3. Chofoza kuhlobo lwegrafu ukulikhetha.

Kulesi sifundo

1. Khetha Faka> Umugqa> Umugqa ngamakaki .
2. Igrafu eyisisekelo yomugqa idalwa futhi ifakwe ekhasini lakho lokusebenzela. Amakhasi alandelayo afaka ukufometha leli grafu ukufanisa igrafu yomugqa eboniswe ku- Isinyathelo 1 salesi sifundo.

04 ka 06

Ukufometha iGraph Line - 1

Ukufometha iGraph Line - 1

Uma uchofoza igrafu, amathebhu amathathu - Amathebhu, ama-Layout, kanye nefomathi afakwa kwi-Ribbon ngaphansi kwesihloko seTshi Tools .

Ukukhetha isitayela segrafu yesigcawu

1. Chofoza kugrafu yesigcawu.
2. Chofoza kuthebhu Yokuklama .
3. Khetha isitayela 4 seStyles Styles

Ukwengeza isihloko kumagrafu wesigcawu

1. Chofoza kuthebhu ye- Layout .
2. Chofoza kusihloko seshadi ngaphansi kwesigaba se- Labels .
3. Khetha inketho yesithathu - Ishadi eliphezulu .
4. Thayipha isihloko esithi " Isilinganiso sokunciphisa (mm) "

Ukushintsha umbala wefonti we-graph title

1. Chofoza kanye ku- Title Graph ukuze ukhethe.
2. Chofoza kuthebhu yasekhaya emenyu ye-Ribbon.
3. Chofoza umcibisholo ophansi we- Font Color inketho ukuvula imenyu yokudonsa.
4. Khetha Okubomvu Okumnyama kusuka ngaphansi kwesigaba se- Standard Colors semenyu.

Ukushintsha umbala wefonti legend legrafu

1. Chofoza kanye kuGrafu Legend ukuze ukhethe.
2. Phinda izinyathelo 2 - 4 ngenhla.

Ukushintsha umbala wefonti wamalebula axis

1. Chofoza kanye kumalebula enyanga ngezansi kwe- axis e-horizontal ukuze ukhethe.
2. Phinda izinyathelo 2 - 4 ngenhla.
3. Chofoza kanye ngezinombolo eceleni kwe- Y axis ezimele ukuze uzikhethe.
4. Phinda izinyathelo 2 - 4 ngenhla.

05 ka 06

Ukufometha iGraph Line - 2

Ukufometha iGraph Line - 2

Ibala umlando wesigrafu

1. Chofoza kusizinda sesigrafu.
   
2. Chofoza ku-Option Shape Fill ukuvula imenyu yokudonsa.
   
3. Khetha u- Olubomvu, u-Accent 2, I-Lighter engu-80% kusigaba se- Theme Colors semenyu.

Ibala umbala wendawo yengcebo

1. Chofoza kwesinye imigqa yegridi enezingqimba ukuze ukhethe indawo yendawo yesigrafu.
2. Khetha Ukugcwaliswa Kwesimo> I-Gradient> Kusuka ku-Ongakhetha Kwesikhungo kusuka kumenyu.

Ivelisa umkhawulo wegrafu

1. Chofoza kugrafu ukuze ukhethe.
2. Chofoza ku-Option Shape Fill ukuvula imenyu yokudonsa.
3. Khetha i- Bevel> Cross kusukela kwimenyu.

Kuleli phuzu, igrafu yakho kufanele ifane negrafu elayini ekhonjiswe ku-Isinyathelo 1 salesi sifundo.

06 ka-06

Idatha yeTayimu yeTraph

Faka idatha ngezansi kumaseli aboniswe ukudala igrafu yesigcawu ehlanganiswe kule tutorial.

Cell - Idatha
I-A1 - Isilinganiso sokunciphisa (mm)
A3 - Januwari
A4 - Ephreli
A5 - Julayi
A6 - Okthoba
B2 - I-Acapulco
B3 - 10
B4 - 5
B5 - 208
B6 - 145
C2 - Amsterdam
C3 - 69
C4 - 53
C5 - 76
C6 - 74