Excel 2003 Uluhlu lweGraph Tutorial

01 ngo-10

Ubume bemiSebenzi yeeKharityhulam ze-Excel 2003

Le tutorial ihlanganisa amanyathelo okudala igrafu yomgca kwi-Excel 2003 usebenzisa i-Excel Chart Wizard.

Ukugqiba amanyathelo kwizihloko ezingezantsi kuza kuvelisa igrafu yomgca efana nomfanekiso ongentla.

02 ngo 10

Ukufaka i-Data Graph Data

Kungakhathaliseki ukuba uluphi uhlobo lwetshathi okanye igrafu oyidalayo, isinyathelo sokuqala ekudaleni idilesi ye-Excel lihlala lifaka idatha kwiphepha lokusebenzela .

Xa ufaka idatha, gcina le mithetho engqondweni:

1. Ungashiyi imigca okanye iikholomu ezingenanto xa ufaka idatha yakho.
2. Faka idatha yakho kwiikholomu.

• Xa ubeka i- spreadsheet yakho, dwelisa amagama achaza idatha kwikholamu enye kwaye, ekunene kwaloo, idatha ngokwayo.
• Ukuba kukho uchungechunge olungaphezulu kweyodwa yedatha, babhale uluhlu emva kolunye kwiikholamu kunye nesihloko kwinqaku nganye yedatha phezulu.

Iimfundiso zeTutorial

1. Faka idatha njengoko iboniswe kumfanekiso ongentla kwiiseli A1 ukuya ku-C6.

03 ngo 10

Ukukhetha iDatha yeGrafu Data

Ukusebenzisa imouse

1. Drag ukhethe kunye nekhompi ye mouse ukuze ukhankasele iiseli eziqulethe idatha ukuba zifakwe kwigrafu.

Ukusebenzisa ikhibhodi

1. Cofa kwi-top left of data yegrafu .
2. Gcina phantsi iqhosha le- SHIFT kwibhodibhodi.
3. Sebenzisa izitshixo zitshixo kwibhodibhodi ukhethe idatha ukuba ifakwe kwigrafu yomgca.

Qaphela: Qiniseka ukuba ukhethe nayiphi na ikholomu kunye nezihloko ezihamba phambili ofuna ukufakwa kwigrafu.

Iimfundiso zeTutorial

1. Gqamisa ibloko leeseli ukusuka ku-A2 ukuya ku-C6, equka izihloko zekholomu kunye nezihloko ezilandelelweyo usebenzisa enye yeendlela ezi ngasentla.

04 we-10

Ukuqala kwiWeb Wizard

Unokukhetha ezimbini ukuqala iWebel Chart Wizard.

1. Cofa kwi icon yeWebhu yeTyrtti kwibharari yesikhokelo esiphantsi (khangela umzekelo wesithombe ngaphezulu)
2. Chofoza kwi Faka> Ishadi ... kumamenyu.

Iimfundiso zeTutorial

1. Qala iWebhu yeSiza ngeendlela ozikhethayo.

05 we-10

I-Excel iKhadi Wizard Isinyathelo 1

Khetha iThart kwi-Standard Tab

1. Khetha uhlobo lweTrart ukusuka kwipaneli lasekhohlo.
2. Khetha icandelo elingaphantsi kwetafile ukusuka kwicala elifanelekileyo.

Iimfundiso zeTutorial

1. Khetha uhlobo lweThafa lweNqakrazo kwiphepha elingakwesobunxele.
2. Khetha ulayini kunye nomatshini wesigatshana ngaphantsi kwesandla sokunene
3. Chofoza Okulandelayo.

06 ngo 10

I-Excel iKhadi Wizard Isinyathelo 2

Khangela kuqala iTharthi yakho

• Emva kokuba ukhethe idatha yakho ngaphambi kokuba uqale iWebel Chart Wizard, kufuneka ubone umzekelo wetshathi yakho kwifestile ephezulu kwibhokisi yencoko.
• Kwi-spreadsheet yakho, idatha efakwe kwitekiti ijikelezwe yizintuthwane ezihambayo-umda omnyama onomtsalane malunga nedatha yakho.
• Ngaphantsi kwefestile yokujonga kuqala ibhokisi equlethe iinkcukacha zeseli zoluhlu lweedatha olufakwe kwitshathi. Ukuba isatshati yakho ingakhange ibonakale kakuhle, khangela ukuba unyule uluhlu lwe data olufanelekileyo kwi-spreadsheet.

Iimfundiso zeTutorial

1. Chofoza Okulandelayo.

07 ngo 10

I-Wizard ye Excel Chart Isinyathelo 3

Izinketho zeTyrt

Nangona kukho iinketho ezininzi phantsi kweetekisi ezithandathu zokuguqula ukubonakala kwetshathi yakho, kweli nqanaba, siza kufaka izihloko kuphela.

Zonke iicandelo zetshathi ye-Excel zingaguquzwa emva kokuba ugcwalise iWeb Wizard, ngoko akufuneki ukuba wenze zonke iindlela zakho zokufometha kwangoku.

Iimfundiso zeTutorial

1. Cofa kwiTyhupha yeTytile phezulu kwebhokisi yencoko yababini yeShadi.
2. Kwibhokisi yetayiti yeTyrtti, thayipha isihloko: Umyinge wokuNciphisa kwe-Acapulco kunye ne-Amsterdam .
3. Kwibhokisi ye-axis yeCandelo (X), uhlobo: Inyanga .
4. Kwibhokisi ye-axis yeCandelo (Y), uhlobo: Ukunqumla (mm) (Qaphela: mm = imitha).
5. Xa ishati kwiwindow yokubuka kuqala ibonakala kakuhle, nqakraza Okulandelayo.

Qaphela: Njengoko uthayipha izihloko, kufuneka zongezwe kwiwindow yokubuka kuqala ukuya kwesokudla

08 ngo 10

I-Wizard ye Excel Chart Isinyathelo 4

Indawo yeGrafu

Kukho ezimbini zokukhetha apho ufuna ukufaka igrafu yakho:

1. Njengomshicileli omtsha (faka ishadi kwikhasi lokusebenzela eyahlukileyo ukusuka kwincwadi yakho yokusebenzela)
2. Njengento kwiphepha 1 (faka ishadi kwikhasi elifanayo kunye nedatha yakho kwincwadi yokusebenzela)

Iimfundiso zeTutorial

1. Cofa iqhosha leserediyo ukuze ufake igrafu njengento kwiphepha 1.
2. Cofa uqhafaza.

Umgca wesiseko wegrafu uyadalwa kwaye kufakwe kwiphepha lakho lokusebenzela. La maphepha alandelayo afomathiza ukufomathiza eli grafu ukufanisa igrafu yomgca eboniswe kwiNyathelo 1 yale khokelo.

09 we-10

Ukufometha umgca weGrafu

Faka isihloko segrafu kumigca emibini

1. Nqakraza kanye kunye nekhompi yesalathisi naphi na kwisihloko segrafu ukusigqamisa.
2. Cofa okwesihlandlo sesibini kunye nomgca we mouse ngokuphambi kwegama elithi Acapulco ukufumana indawo yokufaka.
3. Cinezela ENTER iqhosha kwikhibhodi ukwahlula isihloko segrafu kwiimizila ezimbini.

Shintsha umbala wesiqendu wegrafu

1. Nqakraza ngokukhawuleza kunye ne mouse kwiinambuzane naphi na emgceni omhlophe wegrafu ukuvula imenyu ehlayo.
2. Cofa nge mouse ekhompyutheni kwindlela yokuqala kwimenyu: Yenza ifomathi yeStatshi ukuze uvule ibhokisi yencoko yendawo yefayile yeTyrtti.
3. Cofa kwii Patterns ithebhu ukuze ukhethe.
4. Kwinqanaba leNgingqi , nqakraza kwisikwere semibala ukuze ukhethe.
5. Kule khokelo, khetha umbala ophuzi ophantsi kwebhokisi yencoko yababini.
6. Chofoza OK.

Shintsha umbala wesiqalo / susa umda ukusuka kumgca

1. Ngakwesokudla-nqakraza kanye kunye nekhompi ye mouse kwiyiphi imvelaphi yesigcawu segrafu ukuvula imenyu ehlayo.
2. Cofa kunye nekhompi ye mouse kwikhetho lokuqala kwimenyu: Yenza i-Legend Legend ukuvula ibhokisi yencoko yencoko yefayile.
3. Cofa kwii Patterns ithebhu ukuze ukhethe.
4. Kwiqendu lomdawulo ngakwesobunxele kwibhokisi yencoko, nqakraza kwiNdawo engekho yokususa umda.
5. Kwinqanaba leNgingqi , nqakraza kwisikwere semibala ukuze ukhethe.
6. Kule khokelo, khetha umbala ophuzi ophantsi kwebhokisi yencoko yababini.
7. Chofoza OK.

10 kwi-10

Ukufometha umgca weGrafu (iqhubekile)

Shintsha umbala / ususe umda wendawo yesalathisi

1. Ngakwesokudla -cofa kunye kunye ne mouse kwi-intlanzi egciniweyo yegrafu ukuvula imenyu ehlayo.
2. Cofa kunye nesincomo se mouse kwimenyu yokuqala: Yenza iFomathi yeNgingqi ukuvula ibhokisi yencoko yebhokisi yencoko yefomathi.
3. Cofa kwii Patterns ithebhu ukuze ukhethe.
4. Kwiqendu lomdawulo ngakwesobunxele kwibhokisi yencoko, nqakraza kwiNdawo engekho yokususa umda.
5. Kwinqanaba leNgingqi ukuya ngakwesokudla, nqakraza kwisikwere semibala ukuze ukhethe.
6. Kule khokelo, khetha umbala ophuzi ophantsi kwebhokisi yencoko yababini.
7. Chofoza OK.

Susa i-Y axis

1. Ngakwesokudla -chukumisa kanye kunye ne-pointer ye mouse kwi-axis ye-Y (umgca wecala eduze kweemali zamanzi) wegrafu ukuvula imenyu ehlayo.
2. Cofa kunye nesincomo se mouse kwikhetho lokuqala kwimenyu: Tshintsha iAxis ukuvula ibhokisi yencoko yebhokisi yebhokisi yencoko.
3. Cofa kwii Patterns ithebhu ukuze ukhethe.
4. Kwimigca yeLines ngakwesobunxele kwibhokisi yencoko, nqakraza kwiNdawo engekho yokucima umgca we-axis.
5. Chofoza OK.

Ngeli nqanaba, igrafu yakho imele ifane negrafu yomgca eboniswe kwiNyathelo 1 yale khokelo.