I-Excel 2003 I-Graph Training Tutorial

01 kwezingu-10

Sibutsetelo se-Excel 2003 Ishadi le-Wizard

Lokhu kufundisa kuhlanganisa izinyathelo zokwakha igrafu yomugqa ku-Excel 2003 usebenzisa i-Excel Chart Wizard.

Ukugcwalisa izinyathelo ezihlokweni ezingezansi kuzoveza igrafu elayini efana nesithombe ngenhla.

02 kwezingu-10

Ukufaka idatha yeGraph Line

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.

Izinyathelo Zokufundisa

1. Faka idatha njengoba kuboniswe esithombeni ngenhla kumaseli A1 kuya ku-C6.

03 ka-10

Ukukhetha i-Data Line Graph

Ukusebenzisa igundane

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

Ukusebenzisa ikhibhodi

1. Chofoza phezulu ngakwesokunxele kwedatha yesigrafu .
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 nezinhlobonhlobo zegqa ofuna ukufakwa kulesi grafu.

Izinyathelo Zokufundisa

1. Gqamisa ibhokisi lamaseli ukusuka ku-A2 kuya ku-C6, okufaka izihloko zekholomu kanye nezihloko zegqawu usebenzisa enye yezindlela ezingenhla.

04 kwezingu-10

Ukuqala i-Wizard Ishadi

Unezinketho ezimbili zokuqala iWebel Chart Wizard.

1. Chofoza isithonjana se- Ishadi le- Ishadi kwibha yamathuluzi ejwayelekile (bheka isibonelo sesithombe ngenhla)
2. Chofoza ku- Faka> Ishadi ... kumamenyu.

Izinyathelo Zokufundisa

1. Qala iWi Wizard usebenzisa indlela oyithandayo.

05 ka-10

I-Excel Chart Wizard Isinyathelo 1

Khetha Ishadi kuThebhu elijwayelekile

1. Khetha uhlobo lweThart kusuka kwiphaneli lesobunxele.
2. Khetha uhlobo oluthile lweshadi kusuka kwipaneli lokunene.

Izinyathelo Zokufundisa

1. Khetha uhlobo lwezhadi lomugqa ngakwesokunxele kwesokunxele.
2. Khetha Ulayini nge- shadi-sub-hlobo engakwesokudla ngakwesokunene
3. Chofoza Okulandelayo.

06 kwangu-10

I-Excel Chart Wizard Isinyathelo 2

Buka kuqala Ishadi lakho

• Njengoba ukhethe idatha yakho ngaphambi kokuqala iWebel Chart Wizard, kufanele ubone isibonelo seshadi lakho ewindini eliphezulu lebhokisi lebhokisi.
• Esikhatsini sakho sepredishithi, idatha efakiwe eshadini ijikelezwe izintuthwane ezihambayo - umngcele omnyama omnyama ozungeza idatha yakho.
• Ngezansi iwindi lokubuka kuqala ibhokisi eliqukethe izinkomba zeseli ebangeni ledatha ezifakwe eshadini. Uma ishadi lakho lingabonakali kahle, hlola ukuqinisekisa ukuthi ukhethe ibanga ledatha elilungile kuspredishithi.

Izinyathelo Zokufundisa

1. Chofoza Okulandelayo.

07 kwangu-10

I-Excel Chart Wizard Isinyathelo 3

Izinketho zamashadi

Nakuba kunezinketho eziningi ngaphansi kwamathebhu ayisithupha wokuguqula ukubukeka kweshadi lakho, kulesi sinyathelo, sizobe sesifaka iziqu kuphela.

Zonke izingxenye zethebula ze-Excel zingashintshwa ngemuva kokuthi usuqedile iWeb Wizard, ngakho-ke akudingekile ukwenza zonke izinketho zakho zokufometha okwamanje.

Izinyathelo Zokufundisa

1. Chofoza kuthebhu ye- Titles phezulu kwebhokisi lengxoxo ye-Chart Wizard.
2. Ebhokisini lesitifiketi se-Ishadi, thayipha isihloko: Isilinganiso sokunciphisa i-Acapulco ne-Amsterdam .
3. Ebhokisini le-Isigaba (X), uhlobo: Inyanga .
4. Ebhokisini le-Category (Y) le-axis, uthayipha: Ukuchithwa (mm) (Qaphela: mm = imitha).
5. Uma ishadi elisewindini lokubuka kuqala libukeka kahle, chofoza Okulandelayo.

Qaphela: Njengoba uthayipha izihloko, kufanele zengezwe iwindi lokubuka kuqala ngakwesokudla

08 kwezingu-10

I-Excel Chart Wizard Isinyathelo 4

Indawo yeGrafu

Kunezinqumo ezimbili kuphela lapho ufuna ukufaka khona igrafu yakho:

1. Njengeshidi elisha (faka ishadi ephepha lokusebenzela elihlukile kusuka encwadini yakho yokusebenzela)
2. Njengento eshicilelwe 1 (faka ishadi eshadini elifanayo njengedatha yakho encwadini yokusebenzela)

Izinyathelo Zokufundisa

1. Chofoza inkinobho yomsakazo ukubeka igrafu njengento eshimbeni 1.
2. Chofoza Qedela.

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

09 kwezingu-10

Ukufometha iGraph Line

Beka isihloko segrafu emigqeni emibili

1. Chofoza kanye nge-pointer yegundane noma yikuphi kusihloko sesigrafu ukuze usiqokomise.
2. Chofoza okwesibili nge-pointer yegundane phambi kwegama elithi Acapulco ukuthola indawo yokufaka.
3. Cindezela inkinobho ENTER ekhibhodi ukuze uhlukanise isihloko segrafu emigqeni emibili.

Shintsha umbala wangemuva wegrafu

1. Chofoza ngakwesokudla kanye ne-pointer yegundane noma yikuphi ngemuva kwesizinda esimhlophe sesigrafu ukuvula imenyu yehla.
2. Chofoza inkinobho yegundane ekukhethweni kokuqala kumenyu: Yenza Ishadi Lendawo Yokwakheka ukuvula ibhokisi lengxoxo yeShadi leShadi leThebula.
3. Chofoza kuthebhu yamaphethini ukuze ukhethe.
4. Esigabeni Sendawo , chofoza kwesikwere esinemibala ukuyikhetha.
5. Kule tutorial, khetha umbala ophuzi obala ophansi ebhokisini lengxoxo.
6. Chofoza OK.

Shintsha umbala wangemuva / susa umngcele kusuka endlebeni

1. Ngakwesokudla-chofoza kanye ne-pointer yegundane noma yikuphi ngemuva kwenganekwane yegrafu ukuvula imenyu yehla.
2. Chofoza nge-pointer yegundane ekukhethwa kukho kokuqala kumenyu: Yenza i-Legend Legend ukuvula ibhokisi lengxoxo ye-Format Legend.
3. Chofoza kuthebhu yamaphethini ukuze ukhethe.
4. Esigabeni somngcele ngakwesokunxele kwebhokisi lebhokisi, chofoza ku- Ongakhetha kukho ukususa umngcele.
5. Esigabeni Sendawo , chofoza kwesikwere esinemibala ukuyikhetha.
6. Kule tutorial, khetha umbala ophuzi obala ophansi ebhokisini lengxoxo.
7. Chofoza OK.

10 kwangu-10

Ukufometha iGraph Line (Kuqhubeka)

Shintsha umbala / susa umngcele wendawo yesakhiwo

1. Ngakwesokudla -cindezela kanye ne-pointer yegundane noma yikuphi lapho kuluhlaka oluluhlaza kukhona igrafu ukuvula imenyu yehla.
2. Chofoza inkinobho yegundane ekukhethweni kokuqala kwimenyu: Fometha Indawo Yendawo Yendawo ukuvula ibhokisi lebhokisi lengxoxo yefomathi yefomathi.
3. Chofoza kuthebhu yamaphethini ukuze ukhethe.
4. Esigabeni somngcele ngakwesokunxele kwebhokisi lebhokisi, chofoza ku- Ongakhetha kukho ukususa umngcele.
5. Esigabeni Sendawo ngakwesokudla, chofoza isikwele esinemibala ukuyikhetha.
6. Kule tutorial, khetha umbala ophuzi obala ophansi ebhokisini lengxoxo.
7. Chofoza OK.

Susa i-axis Y

1. Ngakwesokudla-chofoza kanye nge-pointer yegundane engxenyeni ye-Y (umugqa oqondile eduze namanani okushisa) wegrafu ukuvula imenyu yehla.
2. Chofoza inkinobho yegundane ekukhethwa kukho kokuqala kwimenyu: Fometha i-Axis ukuvula ibhokisi le-dialog Axis.
3. Chofoza kuthebhu yamaphethini ukuze ukhethe.
4. Esigabeni seMigqa ngakwesokunxele kwebhokisi lebhokisi, chofoza ku- Ongakhetha kukho ukususa umugqa we-axis.
5. Chofoza OK.

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