Yakha bese Ufakela Igraph Line ku-Excel ngezinyathelo ezingu-5

Uma nje udinga umugqa, kukhona amathiphu alula ongayisebenzisa

Ku-Microsoft Excel, ukwengeza igrafu yomugqa kushidi noma ibhuku lokusebenzela lidala ukubonakala okubonakalayo kwedatha. Kwezinye izimo, leso sithombe sedatha singahle sibe nemikhuba yezinguquko nezinguquko ezingahle zingabonakali lapho idatha ingcwatshwe emigqeni namakholomu.

Ukwenza iGraph Line - The Short Version

Izinyathelo zokwengeza igrafu eyisisekelo yomugqa noma ishadi lomugqa kwiphepha lokusebenzela lase-Excel yilezi:

1. Qinisekisa idatha ukuthi ifakwe egrafu - faka izihloko zegqawu nekholomu kodwa hhayi isihloko setafula yedata.
2. Chofoza ku- Faka ithebhu ye- ribbon .
3. Engxenyeni ye-Charts yebhebhoni, chofoza isithonjana se- Insert Line Ishadi ukuze uvule uhlu lokudonsa phansi lwezinhlobo zeshadi / igrafu etholakalayo.
4. Hambisa isikhombisi sakho semouse phezu kohlobo lwebhadi ukuze ufunde incazelo yeshadi / igrafu.
5. Chofoza kugrafu oyifunayo.

Igrafu ecacile, engafaniwe - ekhombisa imigqa emele uchungechunge lwemininingwane ekhethiwe, isihloko seshadi esizenzakalelayo, i-legend, nama-value axxes - kuzongeniswa ephepheni lokusebenzela lamanje.

Izinguquko zenguqulo

Izinyathelo kulesi sifundo zisebenzisa izinketho zokufometha nezokuhlela ezitholakalayo ku-Excel 2013. Lokhu kuhluke kulabo abatholakala ekuhumusheni kokuqala kohlelo. Sebenzisa izixhumanisi ezilandelayo ezifundiswa kumagrafu wesigcawu kwezinye izinguqulo ze-Excel.

• I-Excel 2010 no-2007 Linegraph Training
• I-Excel 2003 (nezinguqulo zangaphambilini) Isifundo seGrafu

Inothi kwi-Excel's Theme Colors

I-Excel, njengezinhlelo zonke ze-Microsoft Office, isebenzisa izingqikithi ukubeka ubukeka bezincwadi zayo. Kuye ngendaba oyisebenzisayo ngenkathi ulandela le tutorial, imibala efakwe ezinyathelweni zokufundisa kungenzeka ukuthi ayifani naleyo oyisebenzisayo. Ungakhetha noma iyiphi indaba oyithandayo futhi uqhubeke.

Ukwenza iGraph Line - The Long Version

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

Ukungena kolunye ulwazi njalo kuyisinyathelo sokuqala ekudaleni igrafu - kungakhathaliseki ukuthi yiliphi igrafu noma ishadi elidalwa.

Isinyathelo sesibili sigcizelela idatha okufanele isetshenziswe ekudaleni igrafu. Idatha ekhethiwe ivame ukufaka izihloko zekholomu kanye nezihloko zomugqa, ezisetshenziswa njengamalebuli eshadini.

1. Faka idatha ekhonjiswe esithombeni ngenhla kumaseli afanele okushicilela .
2. Uma usufakiwe, qokomisa ububanzi bamaseli kusuka ku-A2 kuya ku-C6.

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

Ukudala i-Basic Line Graph

Izinyathelo ezilandelayo zizokwenza igrafu eyisisekelo yomugqa - igrafu ecacile, engafundiwe - ebonisa uchungechunge lwemininingwane ekhethiwe kanye nezinkomba.

Ngemva kwalokho, njengoba kukhonjisiwe, ukufundisa kuhlanganisa indlela yokusebenzisa ezinye izici zokufometha ezivame kakhulu, okulandelayo, uma zilandelwa, zizoshintsha igrafu eyisisekelo ukufanisa igrafu yomugqa eboniswe kusilayidi sokuqala salesi sifundo.

1. Chofoza ku- Faka ithebhu ye-ribbon.
2. Esigabeni se- Charts semenyu ye-Ribbon, chofoza isithonjana se- Insert Line Ishadi ukuze uvule uhlu olwehlisiwe lwezinhlobo zamagrafu / ishadi elitholakalayo.
3. Hambisa isikhombisi sakho segundane phezu kohlobo lwegrafu ukuze ufunde incazelo yesigrafu.
4. Chofoza kuhlobo lokuqala lwesitayela se-2-d ohlwini ukuze ukhethe.
5. I-graph line eyisisekelo idalwe futhi ifakwe ekhasini lakho lokusebenzela njengoba kuboniswa esithombeni esilayidi esilandelayo ngezansi.

Ukufometha i-Basic Line Graph: Ukwengeza isihloko seshadi

Hlela isihloko seShadi elizenzakalelayo ngokuchofoza kukho kabili kodwa ungachofoli kabili

1. Chofoza kanye esihlokweni seshadi elizenzakalelayo ukulikhetha - ibhokisi kufanele livele kuzungeze isihloko seThikhthi.
2. Chofoza okwesibili ukubeka i-Excel kumodi yokuhlela , ebeka isikhombisi ngaphakathi kwebhokisi lesihloko.
3. Susa umbhalo ozenzakalelayo usebenzisa okhiye we-Delete / Backspace ekhibhodi.
4. Faka isihloko seshadi - Isilinganiso sokunciphisa (mm) - ebhokisini lesitifiketi

Ukuchofoza engxenyeni engalungile yeShadi

Kunezingxenye eziningi ezihlukene eshadini ku-Excel - njengesihloko seshadi namalebula, indawo yendawo ephethe imigqa emele idatha ekhethiwe, izinkomba eziqondile nezama mpo, nezitayela zegridi eziphezulu.

Zonke lezi zincenye zibhekwa njengezinto ezihlukene yihlelo, futhi, ngaleyo ndlela, ngayinye ingenziwa ifomathiwe ngokwehlukana. Utshela i-Excel ukuthi iyiphi ingxenye yesigcawu ofuna ukuyifomatha ngokuchofoza kuso nge-mouse ye-mouse ukuze uyikhethe.

Phakathi nalesi sifundo, uma imiphumela yakho ingafani nalabo abalwe ohlwini, cishe kungenzeka ukuthi awunayo ingxenye efanele yeshadi elikhethiwe uma ufaka ukukhetha kokufometha.

Iphutha elivame ukwenziwa ngokuchofoza endaweni yesakhiwo phakathi nendawo yegrafu uma inhloso ukukhetha lonke igrafu.

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

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

Ukushintsha Imibala YeGrafu Ukusebenzisa Ithebhu Yamathuluzi Amashadi

Uma ishadi / igrafu lidalwe ku-Excel, noma noma nini lapho igrafu ekhona ikhethwa ngokuchofoza kuyo, amathebhu amabili engeziwe angeziwe kubhebhoni njengoba kuboniswe esithombeni ngenhla.

Lezi ithebhu zamathuluzi we-Chart - Ukuklama nokufometha - ziqukethe ukufometha nokukhethwa kwezinketho ngokukhethekile ngamashadi, futhi kuzosetshenziselwa izinyathelo ezilandelayo ukushintsha umbala nombala wombhalo wegrafu.

Ukushintsha Umbala Wemvelaphi WeGrafu

Kulo grafu oluthile, ukufometha isizinda kuyisinyathelo esinezinyathelo ezimbili ngoba i-gradient yengezwa ukukhombisa izinguquko ezincane embala ngokuzungezile kuwo wonke igrafu.

1. Chofoza ngemuva ukuze ukhethe lonke igrafu.
2. Chofoza ithebhu yefomathi yedibhoni.
3. Chofoza ku-Option Shape Fill , ekhonjiswe esithombeni ngenhla, ukuvula iphaneli yehla ye-Fill Colors.
4. Khetha Okumnyama, Umbhalo 1, I-Lighter 35% kusukela kusigaba se-Theme Colors ohlwini.
5. Chofoza ku-Option Shape Fill option okwesibili ukuvula imenyu yehla ye-Colours.
6. Hambisa isikhombisi segundane ngenketho ye- Gradient ngasekugcineni kohlu ukuze uvule iphaneli elikhulu.
7. Esigabeni Sokushintsha Okumnyama kwephaneli, chofoza inketho engakwesobunxele ongakwesokunxele ukuze ungeze i-gradient ehamba kancane kancane ukusuka kwesobunxele kuya kwesokudla ngaphesheya kwegrafu.

Ukushintsha Umbala Wombhalo

Manje ukuthi isizinda sinobumnyama, umbhalo omnyama ozenzakalelayo awusabonakali. Lesi sigaba esilandelayo sishintsha umbala wazo wonke umbhalo kumagrafu ukuze ube mhlophe

1. Chofoza ngemuva ukuze ukhethe lonke igrafu.
2. Chofoza ithebhu yefomathi yebhebhoni uma kudingekile.
3. Chofoza inketho Yokugcwalisa Umbhalo ukuvula uhlu lwe-Text Colors.
4. Khetha Okumhlophe, Ingemuva 1 kusukela kusigaba se-Theme Colors ohlwini.
5. Yonke umbhalo esihlokweni, x kanye nama-axis, futhi i-legend kufanele ishintshe ibe mhlophe.

Ukushintsha Imibala Yemibala: Ukufometha Kwiphepha Lomsebenzi

Izinyathelo zokugcina ezimbili zokufundisa zisebenzisa isitayela somsebenzi wokufometha , esinezinketho eziningi zokufometha ezitholakalayo zamashadi.

Ku-Excel 2013, uma kusebenziwe, i-paneli ibonakala ngakwesokudla ngakwesokunxele kwesikrini se-Excel njengoba kuboniswe esithombeni ngenhla. Isihloko kanye nezinketho ezivela ekuguquleni kwesimo sezansi kuncike endaweni yeshadi elikhethiwe.

Ukushintsha Umbala Womugqa we-Acapulco

1. Egrafini, chofoza kanye emgqeni we-orange we-Acapulco ukuze ukhethe - okuvelele okuncane kufanele kuvele phakathi nobude bomugqa.
2. Chofoza kuthebhu yefomethi yebhebhoni uma kunesidingo.
3. Ngakwesokunxele ngakwesokunxele kwebhebhoni, chofoza inketho yokukhethwa kwefomathi ukuvula ifasitelana lokusebenza lokufometha .
4. Njengoba umugqa we-Acapulco wawukhethiwe ngaphambilini, isihloko esibukweni kufanele sifunde Uhlu Lwase Data Data.
5. Esikhathini esingaphansi, chofoza uphawu lokugcwalisa (upende lungakwazi) ukuvula uhlu lokukhethwa kukho kolayini.
6. Kuhlu lokukhethwa kukho, chofoza ku-Ithebula lokugcwalisa eduze kweMbala yelebula ukuvula uhlu lwe-Line Colors.
7. Khetha i- Green, i-Accent 6, i-Lighter engu-40% kusukela kusigaba se-Theme Colors ohlwini - umugqa we-Acapulco kufanele ushintshe kumbala obala obala.

Ukushintsha i-Amsterdam

1. Egrafini, chofoza kanye emgqeni wobuluhlaza we-Amsterdam ukuze ukhethe.
2. Kulayini lomsebenzi wokufometha, umbala wokugcwalisa okwamanje okhonjisiwe ngaphansi kwesithonjana kufanele ushintshe kusuka eluhlaza kuze kuluhlaza okwesibhakabhaka okubonisa ukuthi iwashi manje ibonisa izinketho ze-Amsterdam.
3. Chofoza ku- Ithebula lokugcwalisa ukuvula uhlu lwe-Line Colors.
4. Khetha i- Blue, i-Accent 1, i-Lighter engu-40% kusukela kusigaba se-Theme Colors ohlwini - umugqa we-Amsterdam kufanele ushintshe umbala obala okwesibhakabhaka.

Ukuphuma ku-Gridlines

Ukuguqulwa kokugcina kokufometha okumelwe kwenziwe ukulungisa amarekhodi wegridi asebenza ngokuzungezile kuwo wonke igrafu.

I-graph line eyisisekelo ihlanganisa lezi ziteshi zegridi ukuze kube lula ukufunda amanani amaphuzu athile kumigqa yedatha.

Nokho, akudingeki ukuthi iboniswe ngokuphawulekayo. Enye indlela elula yokuyibeka phansi ukulungisa ukukhanya kwabo ngokusebenzisa i-Postting Task pane.

Ngokuzenzakalelayo, izinga labo lokubala liyi-0%, kodwa ngokukhuphula lokho, ama-gridlines azokwehlela ngemuva.

1. Chofoza ukhetho lokufometha kwefomati kuthebhu Yokwakheka kwebhoni uma kudingeka ukuvula i-Postting Task pane
2. Egrafini, chofoza kanye kwi- gridline engu - 150 mm egijima phakathi kwegrafu - zonke iziteshi zegridi kufanele ziqokonyiswe (amachashazi aluhlaza okwesibhakabhaka ekugcineni komgqa ngamunye)
3. Esikhathini samasitjhi sishintsha izinga lokukhanyisa ku- 75% - amarekhodi wegridi egrafini kufanele aphele kakhulu