I-Excel 2003 ye-Pie Tutorial Teutorial

01 kwezingu-10

I-Excel 2003 ye-Pie Tutorial Teutorial

Lesi sifundo sihlanganisa izinyathelo zokudala ishadi lephayi ku-Excel 2003 usebenzisa i-Excel Chart Wizard.

Ukugcwalisa izinyathelo ezihlokweni ezingezansi kuzokhipha ishadi lephayi elifana nesithombe ngenhla.

Izinguquko zenguqulo

Izinyathelo kulesi sifundo zisebenzisa izinketho zokufometha nezokuhlela ezitholakalayo ku-Excel 203. Lezi zihluke kulabo abatholakala ezinhumulweni zakuqala zohlelo. Sebenzisa izixhumanisi ezilandelayo ezifundiswa kumagrafu wesigcawu kwezinye izinguqulo ze-Excel.

02 kwezingu-10

Ukufaka idatha ye-Pie Chart

Qaphela: 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 njengoba kuboniswa esithombeni ngenhla kumaseli A3 kuya ku-B6.

03 ka-10

Ukukhetha idatha yedatha ye-Pie

Qaphela: Ukuze uthole usizo ngalezi ziqondiso, bheka isibonelo sesithombe ngenhla.

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 okhiye bomcibisholo ekhibhodi ukuze ukhethe idatha ukuthi ifakwe eshadini lepayipi.

Qaphela: Qinisekisa ukuthi ukhetha noma yiliphi ikholomu nezinhlobonhlobo zegqa ofuna ukufakwa kulesi grafu.

Kulesi sifundo

1. Gqamisa ibhokisi lamaseli kusuka ku-A3 kuya ku-B6 usebenzisa enye yezindlela ezingenhla.

04 kwezingu-10

Ukuqala i-Wizard Ishadi

Qaphela: Ukuze uthole usizo ngalezi ziqondiso, bheka isibonelo sesithombe ngenhla.

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.

Kulesi sifundo

1. Qala iWi Wizard usebenzisa indlela oyithandayo.

05 ka-10

I-Excel Chart Wizard Isinyathelo 1

Khetha Ishadi kuThebhu elijwayelekile

Qaphela: Ukuze uthole usizo ngalezi ziqondiso, bheka isibonelo sesithombe ngenhla.

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

Kulesi sifundo

1. Khetha uhlobo lweshadi le- Pie ngakwesokunxele kwesokunxele.
2. Khetha i- pie nge-3-D effect effect chart sub-hlobo ngakwesokudla ngakwesokudla
3. Chofoza Okulandelayo.

06 kwangu-10

I-Excel Chart Wizard Isinyathelo 2

Buka kuqala Ishadi lakho

Qaphela: Ukuze uthole usizo ngalezi ziqondiso, bheka isibonelo sesithombe ngenhla.

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

Kulesi sifundo

1. Chofoza Okulandelayo.

07 kwangu-10

I-Excel Chart Wizard Isinyathelo 3

Izinketho zamashadi

Qaphela: Ukuze uthole usizo ngalezi ziqondiso, bheka isibonelo sesithombe ngenhla.

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.

Kulesi sifundo

1. Chofoza kuthebhu ye- Titles phezulu kwebhokisi lengxoxo ye-Chart Wizard.
2. Ebhokisini lesitifiketi se-Ishadi, thayipha isihloko: IReko Yokuthengisa Ye-Cookie 2007 .
3. Chofoza kuthebhu ye- Data Labels phezulu kwebhokisi lengxoxo ye-Chart Wizard.
4. Kulebuli Iqukethe isigaba, chofoza inketho yePhesenti yokuyikhetha .
5. Uma ishadi elisewindini lokubuka kuqala libukeka kahle, chofoza Okulandelayo.

Qaphela: Njengoba ufaka amalebula wetekisi nedatha okufanele afakwe kwiwindi lokubuka kuqala ngakwesokudla.

08 kwezingu-10

I-Excel Chart Wizard Isinyathelo 4

Indawo Yeshadi

Qaphela: Ukuze uthole usizo ngalezi ziqondiso, bheka isibonelo sesithombe ngenhla.

Kunezinqumo ezimbili kuphela lapho ufuna ukufaka khona ishadi lakho:

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

Kulesi sifundo

1. Chofoza inkinobho yomsakazo ukubeka ishadi njengento into eshicilelwe 1.
2. Chofoza Qedela.

Ishadi eliyisisekelo lephayi lidalwa futhi lifakwa ekhasini lakho lokusebenzela. Amakhadi alandelayo afaka lesi shadi ukuze afane neshadi lephayi eliboniswe ku-Isinyathelo 1 salesi sifundo.

09 kwezingu-10

Ukwengeza Umbala ku-Chae Ishadi

Qaphela: Ukuze uthole usizo ngalezi ziqondiso, bheka isibonelo sesithombe ngenhla.

Shintsha umbala wangemuva weshadi

1. Chofoza ngakwesokudla kanye ne-pointer yegundane noma yikuphi ngemuva kwesizinda esimhlophe segrafu 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 obomvu phansi ngezansi kwebhokisi lengxoxo.
6. Chofoza OK.

Shintsha umbala wangemuva / susa umngcele kusuka endlebeni

1. Chofoza ngakwesokudla 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 obomvu phansi ngezansi kwebhokisi lengxoxo.
7. Chofoza OK.

10 kwangu-10

Ukuqhuma i-Piece of the Pie

Qaphela: Ukuze uthole usizo ngalezi ziqondiso, bheka isibonelo sesithombe ngenhla.

Ukwengeza ukugcizelela kwesinye isiqeshana se-pie ongashukumisela noma "ukuqhuma" lesi sigaba kusuka kulo lonke ishadi.

1. Chofoza ngesininzana segundane eshadini ukuze usiqokomise. Amabhuloki amancane amnyama kufanele abonakale enqenqemeni yangaphandle ye-pie.
2. Chofoza okwesibili ngesikhombisi segundane esiqwini somvini ophuzi (oatmeal raisin). Emabhuloki omnyama kufanele manje azungeze kuphela le slice eyodwa yephayi.
3. Chofoza bese uhudula ngakwesobunxele ngesinxele segundane esakhiweni esiphuzi se-pie. Isiqephu kufanele sisuke kulo lonke ishadi.
4. Ukuhambisa isitshalo esikhuphukele endaweni yayo yasekuqaleni phindaphinda izinyathelo 1 no-2 ngenhla bese uhudulela uhlangothi ku-pie. Izobuyela ngokuzenzakalelayo endaweni yayo yasekuqaleni.

Ngesiqephu esiphuzi siphume ishadi lakho kufanele lifanane neshadi lephayi eliboniswe ku-Isinyathelo 1 salesi sifundo.