Indlela yokudala iGrafu yeGrafu / iKhadi leKholamu kwi-Excel

01 ka 09

Yenza i-Grafu yeGrafu / Ikholethi yekholeji ngeWeb Wizard kwi-Excel 2003

Olu qeqesho luquka iWeb Wizard kwi-Excel 2003 ukudala igrafu yebha. Ikukhokela ngokusebenzisa izinto eziqhelekileyo ezifunyenweyo kwizikrini ezine zeWeb Wizard.

I-Wizard yeTyrt yenziwe ngoluhlu lweebhokisi zeebhokisi ezikunika zonke iindlela ezikhoyo zokudala ishati.

Iibhokisi ezine zeDialog okanye iiNkqubo zoMgcini weTyrt

1. Ukukhetha uhlobo lwetshathi efana neesayiti, ipaki, okanye ishadi lomgca.
2. Ukukhetha okanye ukuqinisekiswa kwedatha eya kusetyenziselwa ukwenza ishati.
3. Ukongeza izihloko kwitshati kwaye ukhethe iindlela ezahlukeneyo zetshathi ezifana nokongeza amalebula kunye nomlando.
4. Ukugqiba ukuba ubeke ishati kwiphepha elifanayo njengedatha okanye kwiphepha elilodwa.

Qaphela: Ziziphi izinto ezininzi esizibiza ngegrafu yebhayibha ekubhekiselelwe kuzo, kwi-Excel, njengetshathi yekholomu , okanye ishadi lebha .

IWeb Wizard ayikho

Idizadidi yetshathi isuswe kwi-Excel ngokuqala ngo-2007.

Ukuba unenguqu yeprogram emva kwe-Excel 2003, sebenzisa ezi zilandelayo ziqhagamshelwano nezinye izifundo zegrafu / zeetriki kwi-Excel:

• Excel 2013 Igrafu yeGrafu / iTrayorial Trtorial
• Excel 2010/2007 Igrafu yeGrafu / iTyrtti yeTyhulamu

02 we-09

Ukungena kwiDatha yeGraf Data

Isinyathelo sokuqala ekudaleni igrafu yebhayi kukufaka 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.
   

Qaphela: Xa ubeka ispredishithi sakho, dwelisa amagama achaza idatha kwikholam enye kunye nokunene kwalo, idatha ngokwayo. Ukuba kukho uchungechunge olungaphezulu kweyodwa yedatha, babhale uluhlu emva kolunye kwiikholamu kunye nesihloko kwinqaku nganye yedatha phezulu.

Ukuze ulandele le khosi, faka idatha ekhoyo kwisigaba 9 sale khokelo.

03 ka 09

Khetha iDatha yeGraf Data - Iindlela ezimbini

Ukusebenzisa iMouse

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

Ukusebenzisa ikhibhodi

1. Cofa kwi-top left of data yegrafu yebar.
2. Gcina phantsi iqhosha le- SHIFT kwibhodibhodi.
3. Sebenzisa izitshixo zokucoca kwikhibhodi ukukhetha idatha ukuba ifakwe kwigrafu yebar.

Qaphela: Qiniseka ukuba ukhethe nayiphi na iikholomu kunye nezihloko zomqolo ozifunayo zifakwe kwigrafu.

Kule Tutorial

1. Phakamisa ibhloko yeeseli ukusuka kwi-A2 ukuya kwi-D5, equka izihloko zekholomu kunye nezihloko ezigciniweyo

04 we-09

Indlela Yokuqala IWebhu Yesihadi

Unokukhetha ezimbini ukuqala iWebel Chart Wizard.

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

Kule Tutorial

1. Qala iWebhu yeSiza ngeendlela ozikhethayo.

Amaphepha alandelayo asebenza ngamanyathelo amane eWebhu yeehadi.

05 ka 09

Inyathelo 1 - Ukukhetha uhlobo lweGrafu

Khumbula: Yintoni eninzi esiyibiza ngegrafu yebhayinti ibhekiselwa kuyo, kwi-Excel, njengetshathi yekholomu , okanye ishadi lebha .

Khetha iThart kwi-Standard Tab

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

Qaphela: Ukuba ufuna ukudala iigrafu ezidlulileyo, khetha iItroniki zeTebhu zeNtlobo phezulu kwebhokisi yencoko yebhokisi yencoko.

Kule Tutorial
(kwi-Standard Standard Chart tab)

1. Khetha uhlobo lwetshathi lwekholomu kwiphepha lesandla sasekhohlo.
2. Khetha i-sub-type ye- colum edidiyelweyo yekholeji kwicala lokunene.
3. Chofoza Okulandelayo.

06 ka 09

Inyathelo 2 - Hlaziya ibrafu yakho yeBharf

• Ukuba ukhetha idatha yakho ngaphambi kokuba uqale iWebel Chart Wizard, uya kubona umboniso wegrafu yakho kwibrafini ephezulu kwibhokisi yencoko.
• Kwi-spreadsheet yakho, idatha efakiwe kwigrafu ijikelezwe yizintuthwane ezijikelezayo-umda omnyama omnyama ojikeleze idatha yakho.
• Ngaphantsi kwefestile yokujonga kuqala ibhokisi equlethe iiferensi zeeselfowuni zolwazi olufakwe kwigrafu.
• Ukuba ibrafu yakho yebar ayibukeka kakuhle, khangela ukuba ukhethe udidi lweedatha olufanelekileyo kwi-spreadsheet.

Kule Tutorial

1. Ukuba igrafu yakho ibonakala ichanekileyo kwiwindow yokubuka kuqala, nqakraza Okulandelayo .

07 ka 09

Inyathelo 3 - Ukufometha igrafu yeBhara

Nangona kukho inketho ezininzi phantsi kweetekisi ezithandathu zokuguqula ukubonakala kwegrafu yakho kweli nqanaba, siza kwengeza kuphela isihloko kwisigrafu sethu sebha.

Zonke iigrafu ziyakwazi ukuguqulwa emva kokugqiba iWebdi yoMtshini.

Akukho imfuneko yokwenza zonke iinketho zakho zokufometha kwangoku.

Kule Tutorial

1. Cofa kwiibhloko ithebhu phezulu kwibhokisi yencoko.
2. Kwibhokisi yebhokisi yeTyrtti, thayipha isihloko esithi I-Cookie Shop 2003-2005 yeNgeniso .

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

08 ka 09

Isinyathelo 4 - Igrafu Indawo

Kukho ukhetho olubini kuphela apho ufuna ukubeka igrafu yakho yebhayisi:

1. Njengomshicileli omtsha (faka igrafu kwiphepha ehlukileyo ukusuka kwidata yakho kwincwadi yokusebenzela)
2. Njengento kwiphepha 1 (faka igrafu kwiphepha elifanayo njengedatha yakho kwincwadi yokusebenzela)

Kule Tutorial

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

Ukufometha igrafu yeBhara

Emva kokuba idilesi yesigqityi igqityiwe, igrafu yakho yebar iya kufakwa kwiphepha lokusebenzela. Igrafu isadinga ukufomatha phambi kokuba ingacingwa ingqalelo.

09 we 09

Idatha yeGrafu yeTutorial Data

Faka idatha engezantsi kwiiseli eziboniswe ukudala igrafu yebar ehlanganiswe kule khokelo. Akukho fomathi yokwenza umsebenzi ehlanganiswe kule khokelo, kodwa loo nto ayiyi kuchaphazela ibrafu yakho yebar.

Cell - Data
I-A1 - Isishwankathelo seNgeniso - I-Cookie Shop
A3 - Iimali ezipheleleyo:
A4 - Iindleko ezipheleleyo:
A5 - Inzuzo / Ukulahleka:
B2 - 2003
B3 - 82837
B4 - 57190
B5 - 25674
C2 - 2004
C3 - 83291
C4 - 59276
C5 - 26101
D2 - 2005
D3 - 75682
D4 - 68645
D5 - 18492

Buyela kwisinyathelo 2 sale khokelo.