Ungadala kanjani iGrafu yeGrafu / Ishadi Lamakholomu ku-Excel

01 ka 09

Dala Ishadi LamaGrafu / Ikholomu Yekholomu ne-Wizard Ishadi ku-Excel 2003

Lokhu kufundisa kuhlanganisa ukusebenzisa iWeb Wizard ku-Excel 2003 ukudala igrafu yebha. Ikuqondisa ngokusebenzisa izici ezivame kakhulu ezitholakala ezikrinini ezine ze-Wizard Ishadi.

I-Wizard ye-Chart yenziwe uchungechunge lwamabhokisi wezingxoxo ezikunika zonke izinketho ezitholakalayo zokudala ishadi.

Amabhokisi amane Ezingxoxo noma Izinyathelo Zomshicileli Wezhadi

1. Ukukhetha uhlobo leshadi olufana neshadi lephayi, ishadi lebha, noma ishadi lendiza.
2. Ukukhetha noma ukuqinisekisa idatha ezosetshenziswa ukudala ishadi.
3. Ukwengeza izihloko eshadini bese ukhetha izinketho ezahlukene zeshadi ezifana nokwengeza amalebuli kanye nomlando.
4. Ukunquma noma ukubeka ishadi ekhasini elifanayo njengedatha noma ekhasini elihlukile.

Qaphela: Yiziphi eziningi zethu esizibiza ngegrafu yamabha kukhonjelwa kuyo, ku-Excel, njengeshadi lamakholomu , noma ishadi lesibha .

Umshayeli wezhadi Awusasekho

Idizadidi leshadi lisusiwe kusukela ku-Excel kusukela ngenguqulo ka-2007. Ishintshiwe ngezinketho ze-charting ezitholakala ngaphansi kwethebhu yokufaka yebhebhoni .

Uma unenguqulo yesimiso kamuva kune-Excel 2003, sebenzisa izixhumanisi ezilandelayo kwamanye amathrekhi wegrafu / ishadi ku-Excel:

• I-Excel 2013 Igrafu yeBrafu / Ikholomu Ishadi Lombhalo
• I-Excel 2010/2007 Igrafu yeGrafu / Ikholomu Ishadi Lombhalo

02 ka 09

Ukufaka idatha yeGrafu yeBrafu

Isinyathelo sokuqala ekudaleni igrafu yebhayi ukungenisa idatha kufomethe lokusebenzela .

Uma ufaka idatha, gcina le mithetho engqondweni:

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

Qaphela: Uma ubeka ispredishithi sakho, uhlu lwamagama 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.

Ukuze ulandele le tutorial, faka idatha esezitegeni 9 salesi sifundo.

03 ka 09

Khetha Idatha yeGrafu yeBrafu - Izinketho ezimbili

Ukusebenzisa uMouse

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

Ukusebenzisa ikhibhodi

1. Chofoza ngakwesokunxele ngakwesokudla kwedatha yegrafu.
2. Gweba ukhiye we- SHIFT kukhibhodi.
3. Sebenzisa okhiye bomcibisholo ekhibhodi ukuze ukhethe idatha ukuthi ifakwe kugrafu yebha.

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

Kule Nfundo

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

04 ka 09

Indlela Yokuqala I-Wizard Ishadi

Unezinketho ezimbili zokuqala iWebel Chart Wizard.

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

Kule Nfundo

1. Qala iWi Wizard usebenzisa indlela oyithandayo.

Amakhasi alandelayo asebenza ngezinyathelo ezine zoMshicileli wezhadi.

05 ka 09

Isinyathelo 1 - Ukukhetha uhlobo lweGrafu

Khumbula: Yikuphi iningi lethu elibiza ikhografu yamabha kukhonjiswe kuyo, ku-Excel, njengesiqeshana sekholomu , noma ishadi lesibha .

Khetha Ishadi kuThebhu elijwayelekile

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

Qaphela: Uma ufuna ukudala amagrafu okungeyona into engavamile, khetha i- Custom Types ithebhu phezulu ebhokisini lengxoxo yeTayitela.

Kule Nfundo
(kuthebhu ye-Standard Chart Types)

1. Khetha uhlobo lwekhadi lamakholomu ngakwesokunxele sesandla sesokunxele.
2. Khetha uhlobo oluthile lweshadi lamakholomu e-Clustered kwesokudla ngakwesokudla.
3. Chofoza Okulandelayo.

06 ka 09

Isinyathelo sesi-2 - Hlola ibrafu yakho ye-Bar

• Uma ukhetha idatha yakho ngaphambi kokuqala iWebel Chart Wizard, uzobona isibonelo segrafu yakho yebha bar efasiteleni eliphezulu lebhokisi lebhokisi.
• Esikhatsini sakho sepredishithi, idatha efakiwe egrafu ishaywa izintuthwane ezihambayo-umngcele omnyama omnyama ozungeza idatha yakho.
• Ngezansi iwindi lokubuka kuqala ibhokisi eliqukethe izingqikithi zeseli zohla lwedatha olufakwe kugrafu.
• Uma ibrafu yakho yebha ibonakala ingakalungi, hlola ukuqinisekisa ukuthi ukhethe ibanga lemininingwane elilungile kuspredishithi.

Kule Nfundo

1. Uma igrafu yakho ibonakala ilungile efasiteleni lokubuka kuqala, chofoza Okulandelayo .

07 ka 09

Isinyathelo 3 - Ukufometha Igrafu Yebha

Nakuba kunezinketho eziningi ngaphansi kwamathebhu ayisithupha wokuguqula ukubukeka kwesigrafu sakho kulesi sinyathelo, sizobe sesifaka isihloko esihlokweni sethu segrafu.

Zonke izingxenye zegrafu zingashintshwa emva kokuthi usuqedile i-Wizard yeThart.

Akudingekile ukwenza zonke izinketho zakho zokufometha okwamanje.

Kule Nfundo

1. Chofoza kuzihloko zamagama phezulu kwebhokisi lebhokisi.
2. Ebhokisini lesitifiketi seThadi, thayipha isihloko esithi I-Cookie Shop 2003 - 2005 Imali .

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

08 ka 09

Isinyathelo 4 - Indawo yeGrifu

Kunezinketho ezimbili kuphela lapho ufuna ukufaka khona igrafu yakho yebha:

1. Njengeshidi elisha (faka igrafu eshefini ehlukile kusuka kwedatha yakho encwadini yokusebenzela)
2. Njengento eshimbeni 1 (faka igrafu kushidi elifanayo njengedatha yakho encwadini yokusebenzela)

Kule Nfundo

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

Ukufometha Igrafu Yebha

Uma isitidi seshadi isiphelile, igrafu yakho yebha kuzofakwa efomini lokusebenzela. Igrafu isadinga ukufomatha ngaphambi kokuthi ibhekwe njengokuphelele.

09 ka 09

Idatha yeGrafu Yokufundisa

Faka idatha ngezansi kumaseli abonisiwe ukudala igrafu ye-bar ehlanganiswe kule tutorial. Akukho ukufometha kwephepha lokusebenza okuhlanganiswe kulokhu okufundiswa, kodwa lokho ngeke kuthinte igrafu yakho yebha.

Cell - Idatha
I-A1 - Isifinyezo seNgeniso - I-Cookie Shop
A3 - Imali engenayo:
A4 - Ingqikithi Imali:
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 ku-Isinyathelo sesi-2 salesi sifundo.