Indlela Yokwenza Nokwenza Ishadi Lamakholomu ku-Excel 2010

01 ka-06

Izinyathelo zokwenza Ishadi lamakholomu ku-Excel 2010

Izinyathelo zokwakha ishadi lamakholomu eyisisekelo ku-Excel 2010 yizi:

1. Qinisekisa idatha ukuthi ifakwe eshadini - faka izihloko zegqawu nekholomu kodwa hhayi isihloko setafula yedatha;
2. Chofoza ku- Faka ithebhu ye- ribbon ;
3. Ebhokisini Lamashadi webhebhoni, chofoza isithonjana seKhadi lekholomu lokufaka ukuze uvule uhlu lokudonsa phansi lwezinhlobo zeshadi ezitholakalayo;
4. Hambisa isikhombisi sakho semouse phezu kohlobo lwebhadi ukuze ufunde incazelo yeshadi;
5. Chofoza kushadi elifunayo;

Ishadi elicacile, elingashintshiwe - elibonisa kuphela uchungechunge olukhethiwe lwedatha, i-legend, ne-axxes value - kuzongeniswa ephepheni lomsebenzi wamanje.

Ukuhluka kohlobo ku-Excel

Izinyathelo kulolu hlelo zisebenzisa izinketho zokufometha nezokuhlela ezitholakalayo ku-Excel 2010 no-2007. Lokhu kuhluke kulabo abatholakala ekuhumusweni kokuqala nakamuva kwaloluhlelo. Sebenzisa izixhumanisi ezilandelayo zamakholi wekholomu wekholomu kwezinye izinguqulo ze-Excel.

• I-Excel 2013 Yokufundisa Ishadi Lamakholomu
• I-Excel 2003 (nezinguqulo zangaphambilini) Ukufundisa Ishadi lamakholomu

Inothi kwi-Excel's Theme Colors

I-Excel, njengezinhlelo zonke ze-Microsoft Office, isebenzisa izingqikithi ukubeka ubukeka bezincwadi zayo.

Isihloko esetshenziselwa lesi sifundo yisihloko se- Office esizenzakalelayo.

Uma usebenzisa enye indaba elandelayo ngenkathi ulandela le tutorial, imibala efakwe ezinyathelweni zokufundisa kungenzeka ingatholakali engqikithi oyisebenzisayo. Uma kunjalo, khetha nje imibala ekuthandeni kwakho njengama-substitute bese uqhubeka.

• Hlola kanjani futhi ushintshe isihloko samanje somsebenzi

02 ka 06

Ukudala Ishadi Lamakholomu Eliyisisekelo ku-Excel

Ukufaka nokukhetha Idatha Yezokufundisa

Qaphela: Uma ungenalo idatha esetshenziselwe ukuyisebenzisa nalesi sifundo, izinyathelo kulo mfundo zisebenzisa idatha eboniswe esithombeni ngenhla.

Isinyathelo sokuqala ekudaleni ishadi lihlala lifaka idatha yeshadi - kungakhathaliseki ukuthi yiluphi uhlobo leshadi oludalwa.

Isinyathelo sesibili sigcizelela idatha okufanele isetshenziswe ekudaleni ishadi.

Uma ukhetha idatha, izihloko zegqawu nekholomu zifakiwe ekukhethweni, kodwa isihloko esiqongweni sedatha yedatha asikho. Isihloko kufanele sengezwe eshadini ngesandla.

1. Faka idatha ekhonjiswe esithombeni ngenhla kumaseli afanele okushicilela
2. Uma usungenwe, qokomisa ububanzi bamaseli kusuka ku-A2 kuya ku-D5 - lokhu kuluhlu lwedatha oluzobe lumelelwe ishadi lamakholomu

Ukudala Ishadi Lamakholomu Eliyisisekelo

1. Chofoza ku- Faka ithebhu ye-ribbon
2. Ebhokisini Lamashadi webhebhoni, chofoza ku-Isithonjana seKhadi lekholomu lokufaka ukuze uvule uhlu lokudonsa phansi lwezinhlobo zeshadi ezitholakalayo
3. Hambisa isikhombisi sakho segundane phezu kohlobo lweshadi ukuze ufunde incazelo yeshadi
4. Esigabeni samakholomu angu-3-D axhunyiwe ohlwini, chofoza kukholomu encane - ukwengeza ishadi eliyisisekelo ekhasini lokusebenzela

03 ka 06

I-Excel Chart Parts kanye nokususa ama-Gridlines

Ukuchofoza engxenyeni engalungile yeShadi

Kunezingxenye eziningi ezihlukene eshadini ku-Excel - njengendawo yendawo ephethe ishadi lekholomu elimele uchungechunge lwedatha olukhethiwe, i-legend, nesihloko seshadi.

Zonke lezi zincenye zibhekwa njengezinto ezihlukene yihlelo, futhi, ngaleyo ndlela, ngayinye ingenziwa ifomathiwe ngokwehlukana. Utshela i-Excel ukuthi iyiphi ingxenye yeshadi ofuna ukuyifometha ngokuchofoza kuyo nge-pointer yegundane.

Ezinyathelweni ezilandelayo, uma imiphumela yakho ingafani nalabo ababalwe kusifundo, cishe kungenzeka ukuthi awunayo ingxenye efanele yeshadi elikhethiwe uma ungeze ukhetho lokufometha.

Iphutha elivame ukukwenziwa ngokuchofoza endaweni yesakhiwo phakathi kwenqola lapho inhloso ukukhetha ishadi lonke.

Indlela elula yokukhetha ishadi lonke ukuchofoza ngakwesokunxele noma ngakwesokudla ngakwesokudla kude nesihloko seshadi.

Uma kwenzeka iphutha, lingalungiswa ngokushesha usebenzisa isici sokuhlehlisa i-Excel ukulungisa iphutha. Ngemva kwalokho, chofoza ngakwesokudla kweshadi uphinde uzame futhi.

Ukususa amarekhodi weGridi kusuka ku-Plot Area

Igrafu eyisisekelo yomugqa ihlanganisa amarekhodi wegridi asebenza ngokuzungezile endaweni yonke yesakhiwo ukwenza kube lula ukufunda amanani ngamaphuzu athile yedatha - ikakhulukazi kumashadi aqukethe idatha enkulu.

Njengoba kukhona kuphela uchungechunge oluthathu lwedatha kuleli shidi, amaphuzu wedatha alula ukufunda, ngakho-ke amarekhodi wegridi angenziwa.

1. Esikhathini, chofoza kanye nge-$ 60,000 yegridline egijima phakathi kwegrafu ukugqamisa wonke amashadidi wegridi - imibuthano encane eluhlaza okwesibhakabhaka kufanele ibonwe ekugcineni komgqa ngamunye
2. Cindezela ukhiye wokususa ekhibhodi ukuze ususe ama-gridlines

Kuleli phuzu, ishadi lakho kufanele lifane nesibonelo esiboniswe esithombeni ngenhla.

04 ka 06

Ukushintsha Umbhalo Weshadi

Amathebhu we-Chart Tools

Uma ishadi lidalwa ku-Excel 2007 noma ngo-2010, noma noma nini lapho ishadi elikhona likhethwa ngokuchofoza kukho, amathebhu amathathu atholakale ku-Ribbon njengoba kuboniswe esithombeni ngenhla.

Lawa mathemikhali Amathuluzi we-Chart - Ukuklama, Ukuhlelwa, nokufometha - aqukethe izinketho zokufometha nezinketho ngokukhethekile ngamashadi, futhi azosetshenziselwa izinyathelo ezilandelayo ukwengeza isihloko eshadini lekholomu nokushintsha imibala yeshadi.

Ukwengeza nokuhlela isihloko seshadi

Ku-Excel 2007 no-2010, amashadi ayisisekelo awafaki izihloko zeshadi. Lezi kumele zengezwe ngokwahlukana ngokusebenzisa inketho yeTayiti yeTayiti etholakala kuthebhu yeLungiselelo bese ihlelwe ukubonisa isihloko esifisa.

1. Chofoza kanye eshadini ukuze ukhethe, uma kunesidingo, ukwengeza amathebhu wamathuluzi eshadi kwibhebhoni
2. Chofoza kuthebhu ye- Layout
3. Chofoza kuKhetho le- Chart Title ukuvula uhlu lokudonsa phansi lwezinketho
4. Khetha Ishadi Laphezulu Kuloluhlu ukubeka ibhokisi lesitayela elizenzakalelayo eshadini ngaphezulu kwamakholomu wedatha
5. Chofoza kanye ebhokisini lesihloko ukuze uhlele umbhalo ozozenzakalelayo wesihloko
6. Susa umbhalo ozenzakalelayo bese ufaka isihloko seshadi - Isifinyezo Sokuthola Imali ka-Cookie 2013 - ebhokisini lesihloko
7. Faka isikhombisi phakathi kwe- Shop no- 2013 esihlokweni bese ucindezela ukhiye we-Enter ekhibhodi ukuze uhlukanise isihloko emigqeni emibili

Ukushintsha Uhlobo Lwefonti

Ukushintsha uhlobo lwefonti olusetshenziswe ngokuzenzakalelayo kuwo wonke umbhalo eshadini ngeke kuthuthukise ukubonakala kweshadi, kodwa kuzokwenza kube lula ukufunda umlando kanye namagugu amagama namanani.

Lezi zinguquko zizokwenziwa ngokusebenzisa izinketho ezisendaweni yefonti yethebhu yaseKhaya yebhebhoni.

Qaphela : Ubukhulu befonti bulinganiselwa amaphuzu - ngokuvamile kufushaniswa ku- pt.
72 pt. umbhalo ulingana no-inch - 2.5 cm - ngosayizi.

Ukushintsha Umbhalo Wesihloko Somdwebo

1. Chofoza kanye esihlokweni seshadi ukuze ukhethe
2. Chofoza kuthebhu yaseKhaya ye-ribbon
3. Engxenyeni yefonti yebhebhoni, chofoza ebhokisini lefonti ukuvula uhlu oludonsela phansi lwamafonti atholakalayo
4. Pheqela ukuze uthole futhi uchofoze ku-font Arial Black kuhlu ukuze ushintshe isihloko kule fonti

Ukushintsha umbhalo we-Legend and Axes

1. Phinda izinyathelo ezingenhla ukuze ushintshe umbhalo emlandweni weshadi kanye ne-X ne-Y axxes kuya ku-Arial Black

05 ka 06

Imibala Eshintshayo Emshini Wekholomu

Ukushintsha Umbala we-Floor ne-Side Side

Lezi zinyathelo ekufundiseni zihilela ukushintsha umbala wesigcawu nesitezi eseceleni kuya kumnyama njengoba kuboniswe esithombeni ngenhla.

• Iphadi lesiteji yikona eligobile elitholakala ngaphansi kwamakholomu wedatha endaweni yendawo.
• Udonga ohlangothini luhlangothini lwesobunxele bendawo yendawo phakathi kwamakholomu wedatha kanye namalebula angama-Y (mpo) axiski.

Zombili izinto zizokhethwa ngokusebenzisa izakhi zeshadi ezihlahlisayo uhlu olusehlangothini olude lwesokunxele lwethebhu Yokuhlela yebhande.

1. Chofoza kusemuva leshadi ukuze ukhethe ishadi lonke uma kunesidingo
2. Chofoza kuthebhu ye- Layout yedibhoni
3. Ngayo ishadi lonke elikhethiwe, uhlu lwezinto zeshadi kufanele lubonise igama leShadi lesikhangiso ekhoneni eliphezulu lesokunxele lebhebhoni.
4. Chofoza umcibisholo ophansi ngezansi kwezinto zeshadi izinketho ukuvula uhlu lokudonsa phansi lwezingxenye zeshadi
5. Khetha isitela kusukela ohlwini lwezingxenye zeshadi ukugqamisa phansi ishadi
6. Chofoza kuthebhu yefomathi yedibhoni
7. Chofoza ku-Option Shape Fill ukuze uvule iphaneli yehla ye-Fill Colors
8. Khetha u- Black, Umbhalo 1 kusuka kusigaba se- Theme Colors sephaneli ukuze ushintshe umbala webala weshadi ube mnyama
9. Phinda izinyathelo ezimbili kuya kwezingu-6 ngenhla ukuze ushintshe umbala weBhande Lecala leShadi ukuya kumnyama

Uma ngabe ulandele zonke izinyathelo ekufundiseni, kuleli phuzu, ishadi lakho kufanele lifanane nalo elibonwe esithombeni ngenhla.

06 ka-06

Ukushintsha Ikholomu Imibala nokuhambisa Ishadi

Ukushintsha Umbala Wezithombe Zedatha Yedata

Lesi sinyathelo ekufundiseni sishintsha ukubukeka kwamakholomu wedatha ngokushintsha imibala, ngokungeza i-gradient, nokufaka inkomba kukholomu ngayinye.

Isakhiwo sigcwalisa futhi senze izinketho zohlaka , ezisethempyutheni yeFomathi izosetshenziselwa ukuphazamisa lezi zinguquko. Imiphumela izohambisana namakholomu abonwe esithombeni ngenhla.

Ukushintsha Umbala Wekholomu Yonke Imbuyiselo

1. Chofoza kanye kwenye yekholomu e-Blue Total Revenue eshadini ukuze ukhethe wonke amakholomu amathathu aluhlaza okwesibhakabhaka
2. Chofoza kuthebhu yefomethi yebhebhoni uma kunesidingo
3. Chofoza ku-Option Shape Fill ukuze uvule iphaneli yehla ye-Fill Colors
4. Khetha i- Dark Blue, Umbhalo 2, I-Lighter engu-60% kusukela kusigaba se- Theme Colors sephaneli ukuze ushintshe umbala wekholomu ukuze ukhanyise okwesibhakabhaka

Ukungeza i-Gradient

1. Ngamakholomu weRevenue Revenue okhethiwe, chofoza inketho ye- Shape Fill okwesibili ukuvula imenyu ye-Fill Colors yehla
2. Hambisa isikhombisi segundane ngenketho ye- Gradient ngasekugcineni kohlu ukuze uvule iphaneli elikhulu
3. Esigabeni sokushintsha kokukhanya kwephaneli, chofoza inketho ye- Linear Right ukwengeza i-gradient elula kakhulu ukusuka kwesobunxele kuya kwesokudla ngaphesheya kwekholomu

Ukwengeza Uhlaka Lwekholomu

1. Ngamakholomu weRevenue Revenue okhethiwe, chofoza inketho ye-Shape Outline ukuvula imenyu ye-Downline ye-Shape Outline
2. Esigabeni se- Standard Colors sephaneli, khetha i- Dark Blue ukuze ungeze uhlaka oluhlaza okwesibhakabhaka kukholomu ngayinye
3. Cindezela inketho ye- Shape Outline okwesibili
4. Chofoza kokukhethwa kwesisindo kwimenyu ukuvula imenyu engaphansi kwezinketho
5. Khetha 1 1/2 pt. ukwandisa ubukhulu bamakholomu 'amakholomu'

Ukufometha Isamba Sezindleko Zonke

Phinda izinyathelo ezisetshenziselwa ukufometha amakholomu weRevenue Revenue , usebenzisa amafomu alandelayo:

• Umbala Wokugcwalisa Umbala: I- Akhaphu Ebomvu 2, Emnyama 50%
• I-Gradient: Ukushintsha Kokukhanya , Ukunene Kwamanzi
• Umbala we-Column Outline: I- Red Accent 2, Emnyama 50%
• Ikholomu Yokwehlukanisa Umthamo Wezinhlamvu: 1 1/2 pt.

Ukufometha i-Incit / Loss Series

Phinda izinyathelo ezisetshenziselwa ukufometha amakholomu weRevenue Revenue , usebenzisa amafomu alandelayo:

• Umbala Wokugcwalisa Umbala: I- Olive Green Accent 3, Emnyama 25%
• I-Gradient: Ukushintsha Kokukhanya , Ukunene Kwamanzi
• Umbala we-Column Outline: I- Olive Green Accent 3, Emnyama 50%
• Ikholomu Yokwehlukanisa Umthamo Wezinhlamvu: 1 1/2 pt.

Kuleli phuzu, uma zonke izinyathelo zokufomatha sezilandelwe, ishadi lamakholomu kufanele lifane neshadi elibonwe esithombeni ngenhla.

Ukuhambisa Ishadi kwiShidi Elihlukile

Isinyathelo sokugcina esifundweni sishukumisela ishadi ukuya kwelinye ishidi ebhokisini lokusebenzela usebenzisa ibhokisi lengxoxo ye-Move Chart.

Ukuhambisa ishadi kwelinye ishidi elihlukile kwenza kube lula ukuphrinta ishadi futhi kunganciphisa ukuhlanganiswa kwiphepha elibanzi lomsebenzi eligcwele idatha.

1. Chofoza kusemuva leshadi ukuze ukhethe ishadi lonke
2. Chofoza kuthebhu Yokwakha yedibhoni
3. Chofoza ku-Isithonjana se-Ishubhu se-Chart ngakwesokudla ngakwesokudla kwebhebhoni ukuze uvule ibhokisi lengxoxo ye-Move Chart
4. Njengoba kuboniswe esithombeni ngenhla, chofoza inketho entsha ye-sheet ebhokisini lengxoxo futhi - ngokuzithandela - unikeza ishidi igama, njenge-Cookie Shop 2013 Income Summary
5. Chofoza OK ukuze uvale ibhokisi lengxoxo - ishadi kufanele litholakale ephepheni elihlukile negama elisha elibonakalayo kuthebhu leshidi ngaphansi kwesikrini.