Hlanganisa izinhlobo zamatafula ku-Excel 2010

01 ka 09

Engeza i-Y Y Axis ku-Ishadi le-Excel

Qaphela : Izinyathelo ezichazwe kulesi sifundo zivumelekile kuphela ezihumulweni ze-Excel kuze kufike ku- Excel 2010 .

I-Excel ikuvumela ukuba uhlanganise izinhlobo ezimbili noma eziningi ezahlukene zeshadi noma igrafu ukwenza kube lula ukubonisa ulwazi oluhlobene ndawonye.

Enye indlela elula yokufeza lo msebenzi ngokufaka i-second ax or Y axis ngakwesokudla kweshadi. Lezi ziqoqo ezimbili zedatha zisabelana nge-X ejwayelekile noma e-horizontal axis ngezansi kweshadi.

Ngokukhetha izinhlobo zeshadi ezitholakalayo - njengefolda ishadi negrafu yesigcawu - isethulo samaseli amabili wedatha singathuthukiswa.

Ukusetshenziswa okuvamile kwaloluhlobo lwethedi lokuhlanganiswa kufaka phakathi ukubonisa izinga lokushisa lenyanga nenyanga kanye nedatha yokumisa ndawonye, ​​idatha yokukhiqiza njengamayunithi akhiqizwayo kanye nezindleko zokukhiqiza, noma ivolumu yokuthengisa yanyanga zonke kanye nentengo yokuthengisa yenyanga yonke.

Izidingo ZeKhadi Lezinhlanganisela

• Esinye isidingo sokuba idatha iboniswe ukuthi kufanele ihlanganyele amanani e-X axis (angama-horizontal) - njengengqikithi yesikhathi noma indawo.
• Futhi, akuzona zonke izinhlobo zeshadi ezingahlanganiswa. Amashadi angu-3-D, isibonelo, angeke afakwe eshadini lokuhlanganiswa.

I-Excel Yezulu Igrafu Yokufundisa

Lesi sifundo sihlanganisa izinyathelo ezidingekayo zokuhlanganisa amakholomu namashadi womugqa ndawonye ukudala igrafu lesimo sezulu noma i- climatograph , ebonisa izinga lokushisa lokushisa kwenyanga nendawo yendawo.

Njengoba kuboniswe esithombeni ngenhla, ishadi lamakholomu, noma igrafu, ibonisa imvula yenyanga nyangazonke ngenkathi igrafu yomugqa ibonisa izinga lokushisa lokujwayelekile.

Izinyathelo Zokufundisa

Izinyathelo ezilandelwe ekufundiseni ekudaleni igrafu lesimo sezulu ziyi:

1. Idala ishadi eliyisisekelo lamakholomu amabili, elibonisa kokubili imvula kanye nedatha lokushisa kumakholomu ahlukahlukene ahlukahlukene
2. Shintsha uhlobo lweshadi lwedatha lokushisa kusuka kumakholomu kuya emgqeni
3. Hambisa idatha yokushisa esuka e-axis eyinhloko (ngakwesobunxele kweshadi) ukuya e-axis eseceleni (ngakwesokudla kweshadi)
4. Faka isicelo sokukhetha ukufometha kwesigcawu esiyisisekelo sezulu ukuze ihambelane negrafu ebonwe esithombeni ngenhla

02 ka 09

Ukufaka nokukhetha Idatha yeGrafu yeGrimp

Isinyathelo sokuqala ekudaleni igrafu lesimo sezulu ukufaka idatha kushidi lokusebenzela .

Uma idatha ifakiwe, isinyathelo esilandelayo ukukhetha idatha ezofakwa eshadini.

Ukukhetha noma ukugqamisa idatha kudlulisa i-Excel ukuthi yiluphi ulwazi olusesikhathini somsebenzi lokufaka phakathi nokuthi yini engayinaki.

Ngaphandle kwedatha yenamba, qinisekisa ukufaka zonke izikhombo zamakholomu nezigqawu ezichaza idatha.

Qaphela: Isifundo asifaki izinyathelo zokufometha iphepha lokusebenzela njengoba kuboniswe esithombeni ngenhla. Ulwazi olukhethwa kukho lokufometha kweshidi lokusebenza luyatholakala kulokufundiswa okuyisisekelo okufometha kwefometha .

Izinyathelo Zokufundisa

1. Faka idatha njengoba kuboniswe esithombeni ngenhla kumaseli A1 kuya ku-C14.
2. Gqamisa amaseli A2 kuya ku-C14 - lokhu kuluhlu lolwazi oluzofakwa eshadini

03 ka 09

Ukwakha Ishadi Lamakholomu Eliyisisekelo

Wonke amashadi atholakala ngaphansi kwethebhu Faka i - Ribbon ku-Excel, futhi bonke babelane ngalezi zimpawu:

• Uma udala noma yisiphi ishadi ku-Excel, uhlelo kuqala ludala lokho okubizwa ngokuthi ishadi eliyisisekelo usebenzisa idatha ekhethiwe
• Ukuhambisa isikhombisi sakho segundane kwisigaba seshadi kuzokhipha incazelo yeshadi
• Ukuchofoza kwisigaba kuvula ukwehlisa phansi kubonisa zonke izinhlobo zeshadi ezitholakala kulesi sigaba

Isinyathelo sokuqala ekudaleni ishadi elihlanganisiwe - njengegrafu yesimo sezulu - ukuhlela yonke idatha ngohlobo olulodwa lwebhadi bese ushintsha isethi eyodwa yedatha kuhlobo lweshadi lesibini.

Njengoba kukhulunywe ngaphambilini, kule grafu yesimo sezulu, sizohlela kuqala kokubili amasethingi wedatha eshadini lesikholomu njengoba kuboniswa esithombeni ngenhla, bese ushintsha uhlobo lwetshedi yedatha lokushisa kumagrafu wesigcawu.

Izinyathelo Zokufundisa

1. Ngedatha yeshadi ekhethiwe, chofoza ku- Faka> Ikholomu> Ikholomu ehlanganisiwe engu-2-d kulayini
2. Ishadi eliyisisekelo lamakholomu, elifana nalo elibonwa esithombeni ngenhla, kufanele lenziwe futhi lifakwe ekhasini lokusebenzela

04 ka 09

Ukuguqula idatha yokushisa kuGraph Line

Ukushintsha izinhlobo zeshadi ku-Excel kwenziwa ngokusebenzisa ibhokisi lokubhalwa kohlobo lwethegi .

Njengoba sifisa ukushintsha kuphela uchungechunge olulodwa lwedatha oluboniswe kuhlu olulodwa lweshadi, kudingeka sitshele i-Excel ukuthi yiyiphi.

Lokhu kungenziwa ngokukhetha, noma ngokuchofoza kanye, kwelinye lamakholomu eshadini, eliveza zonke izinsika zombala ofanayo.

Izinketho zokuvula ibhokisi lebhokisi lokubhalwa kwethegi lishintsha zihlanganisa:

• ngokuchofoza isithonjana sohlobo lohlobo lwethegi kwi- Design ithebhu yebhande
• ngokuchofoza ngakwesokudla kweminye ikholomu ekhethiwe bese ukhetha inketho yohlobo lohlobo lwe-Series Series ukusuka kwimenyu ehla

Zonke izinhlobo zeshadi ezitholakalayo zifakwe ebhokisini lengxoxo ngakho kulula ukushintsha kusuka kweshadi elinye kuya kwelinye.

Izinyathelo Zokufundisa

1. Chofoza kanye kwenye yamakholomu wedatha lokushisa - uboniswe eluhlaza okwesibhakabhaka esithombeni ngenhla - ukhethe wonke amakholomu alowo mbala eshadini
2. Hambisa isikhombisi segundane phezu kweyodwa yalezi kholomu bese uchofoza ngakwesokudla ngegundane ukuze uvule imenyu yesimo sokudonsa phansi
3. Khetha inketho yohlobo lweThayidi Yohlu lwe-Series ukusuka kwimenyu ehla ukuze uvule ibhokisi lokubhalwa kohlobo lwethegi
4. Chofoza kukhetho lokuqala lwesagrafu ngakwesokudla ngakwesokudla kwebhokisi lebhokisi
5. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela
6. Esikhathini, idatha yokushisa kufanele iboniswe njengelinhla eluhlaza okwesibhakabhaka ngaphezu kwamakholomu wedatha yokuchithwa

05 ka 09

Ukuhambisa Idatha kwi-Axis Secondary

Ukushintsha idatha yezinga lokushisa kugrafu yomugqa kungase kwenze kube lula ukuhlukanisa phakathi kwalezi zinqola ezimbili zedatha, kodwa, ngoba bobabili bahlelwe ku- axis efanayo efanayo, idatha yokushisa iboniswa njengendlela eqondile esitshela kancane kakhulu ukushisa kwenyanga ukushisa.

Lokhu kwenzeka ngenxa yesilinganiso se-axis eyodwa yokuzama ukuzama ukufaka amasheya amabili wedatha ahluka kakhulu ngobukhulu.

Idatha lokushisa ejwayelekile ye-Acapulco inebala elincane kuphela kusuka ku-26.8 kuya ku-28.7 degrees Celsius, kanti idatha yokuchithwa ihlukahluka kusuka kumamitha angaphansi kwamathathu ngoMashi kuya kuka-300 mm ngoSepthemba.

Ekusetheleni ububanzi be-axis ebonakalayo ukukhombisa uhla olubanzi lwemininingwane yesikhukhula, i-Excel isusiwe noma yikuphi ukubukeka kokuhlukahluka kwedatha lokushisa lonyaka.

Ukuhambisa idatha yokushisa ku-axis yesibili ebonakalayo - kuboniswe ngakwesokudla kweshadi kuvumela izilinganiso ezihlukene zamathafa amabili wedatha.

Ngenxa yalokho, ishadi lizokwazi ukubonisa ukuhluka kokubili kokusetha kwedatha ngesikhathi esifanayo.

Ukuhambisa idatha yokushisa kwi-axis ebonakalayo ephilile kwenziwa ebhokisini lebhokisi le- Idatha yokuDatha idatha .

Izinyathelo Zokufundisa

1. Chofoza kanye emgqeni wokushisa - uboniswe obomvu esithombeni ngenhla - ukuyikhetha
2. Hlulela umdwebo wegundane phezu komugqa bese uchofoza ngakwesokudla ngegundane ukuze uvule imenyu yesimo sokudonsa phansi
3. Khetha okukhethwa kukho kochungechunge lweDatha yedatha kusuka kwimenyu ehla ukuze uvule ibhokisi lokubhalwa kweDatha yedatha yedatha

06 ka 09

Ukuhambisa idatha ku-Y Yase-Secondary Axis (i-con't)

Izinyathelo Zokufundisa

1. Chofoza kwizinketho zezinkinobho ngakwesobunxele kwesobunxele bebhokisi lengxoxo uma kunesidingo
2. Chofoza ku-Option Secondary Axis ngakwesokudla ngakwesokudla kwebhokisi lebhokisi njengoba kuboniswe esithombeni ngenhla
3. Chofoza inkinobho ethi Vala ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela
4. Esikhathini, isilinganiso se-data lokushisa kumele siboniswe ngakwesokudla kweshadi

Njengomphumela wokuhambisa idatha yokushisa kumklomelo wesibili oqondile, umugqa obonisa idatha yokwehliswa kufanele ubonise ukuhluka okukhulu kunenyanga kusukela enyangeni ukwenza kube lula ukubona ukushisa.

Lokhu kwenzeka ngoba isikali se-data lokushisa e- axis esezansi ngakwesokudla kweshadi manje sesigubungele ububanzi obungaphansi kwama-degree angama-Celsius kunezinga elilinganisa ukusuka ku-zero kuya ku-300 uma idatha ekwabelwana ngayo isilinganiso esisodwa.

Ukufometha Igrafu Yesimo sezulu

Kuleli phuzu, igrafu lesimo sezulu kufanele ifane nesithombe esiboniswe esiteji esilandelayo sesifundo.

Izitebhisi ezisele ezisekhaveni lokufundisa zisebenzisa izinketho zokufometha kumagrafu wesimo sezulu ukuze zifane negrafu eboniswe esiteji esisodwa.

07 ka 09

Ukufometha Igrafu Yesimo sezulu

Uma kuziwa ekufomeni amashadi ku-Excel akudingeki ukuthi wamukele ukufometha okuzenzakalelayo kunoma iyiphi ingxenye yeshadi. Zonke izingxenye noma izakhi zeshadi zingashintshwa.

Izinketho zokufometha zamashadi zitholakala kakhulu kumathebhu amathathu webhande elihlanganiswa ngokubizwa ngokuthi amaTharthi Amathuluzi

Ngokuvamile, lawa mathubhu amathathu awabonakali. Ukuze ufinyelele kubo, mane uchofoze eshadini eyisisekelo ovele wadala namathebhu amathathu - Ukuklama, Ukuhlelwa, neFomathi - zengezwe kuhabhoni.

Ngaphezulu kwalezi zithebhu ezintathu, uzobona i- Chart Tools Tools .

Ezinyathelweni ezisele zokufundisa ezenzelwe izinguquko ezilandelayo:

• Engeza izitayela nezihloko ze-axes
• hambisa inganekwane phezulu kweshadi
• Shintsha imibala nemidwebo yangemuva
• Bevel umphetho wangaphandle we ishadi
• Shintsha kabusha ishadi

Ukungeza i-Axis Isihloko se-Axis

I-axis enezingqimba ikhombisa izinsuku ezansi kweshadi.

1. Chofoza kushadi eliyisisekelo ekhasini lokusebenzela ukuze ukhuphule amathebhu wethuluzi leshadi
2. Chofoza kuthebhu ye- Layout
3. Chofoza ku- Axis Titles ukuvula uhlu lokudonsa phansi
4. Chofoza kwi- Primary Horizontal Axis Title> Isihloko Ngezansi kwe-Axis inketho yokwengeza isihloko esizenzakalelayo Isihloko se- Axis eshadini
5. Hudula ukhethe isihloko esizenzakalelayo ukuze usiqokomise
6. Thayipha isihloko esithi " Inyanga "

Ukungeza i-Primary Axis Title Axis

I-axis eyinhloko ebonakalayo ibonisa ivolumu yamasheya athengiswe ngakwesokunxele kweshadi.

1. Chofoza eshadini uma kunesidingo
2. Chofoza kuthebhu ye- Layout
3. Chofoza ku- Axis Titles ukuvula uhlu lokudonsa phansi
4. Chofoza kwi- Primary Axis I-Axis Title> Okukhethwa Kwisihloko Sokushintshaniswa ukuze ungeze isihloko se- Axis Isihloko esizenzakalelayo eshadini
5. Qinisekisa isihloko esizenzakalelayo
6. Thayipha isihloko esithi " Isikhuphulelo (mm) "

Ukwengeza isihloko se-Axis Vertical Axis

I-axis yesibili ebonakalayo ibonisa izintengo zamasheya ezithengiswa ngakwesokudla kweshadi.

1. Chofoza eshadini uma kunesidingo
2. Chofoza kuthebhu ye- Layout
3. Chofoza ku- Axis Titles ukuvula uhlu lokudonsa phansi
4. Chofoza ku- Axis Isihloko se-Axis yesibili> Isikhethi se-Title shintshiwe ukuze ungeze isihloko se- Axis Isihloko esizenzakalelayo eshadini
5. Qinisekisa isihloko esizenzakalelayo
6. Thayipha isihloko esithi " Ukushisa Okuphakathi (° C) "

Ukungeza isihloko seshadi

1. Chofoza eshadini uma kunesidingo
2. Chofoza kuthebhu ye- Layout yedibhoni
3. Chofoza kusihloko se-Ishadi> Okukhethwa kukho kweThart ukuze ungeze Isihloko Ishadi Lesichazamazwi eshadini
4. Qinisekisa isihloko esizenzakalelayo
5. Thayipha isihloko se- Climatograph ye-Acapulco (1951-2010)

Ukushintsha Umbala Wefonti Yesihloko Sokwabelana

1. Chofoza kanye kwiSihloko soKhadi ukuze ukhethe
2. Chofoza kuthebhu yasekhaya emenyu ye-Ribbon
3. Chofoza umcibisholo ophansi we- Font Color inketho ukuvula imenyu yehla
4. Khetha Okubomvu Okumnyama kusuka ngaphansi kwesigaba se-Standard Colors semenyu

08 ka 09

Ukuhambisa iLendendende nokushintsha i-Background Area Colors

Ngokuzenzakalelayo, umlando weshadi ukhona ngakwesokudla ngakwesokunxele seshadi. Uma sengeze isihloko se-axis esiqondile, izinto zithola indawo encane kule ndawo. Ukunciphisa ukuxubana sizohambisa umlando phezulu kweshadi ngaphansi kwesihloko seshadi.

1. Chofoza eshadini uma kunesidingo
2. Chofoza kuthebhu ye- Layout yedibhoni
3. Chofoza kuLendlovu ukuvula uhlu lokudonsa phansi
4. Chofoza ku- Show Legend ku-Top option ukuze uhambise inganekwane ibe ngaphansi kwesihloko seshadi

Ukusebenzisa Izinketho Zokufometha Imenyu Yokuqukethwe

Ngaphezu kwamathebhu wamathuluzi eshadile ku-Ribbon, izinguquko zokufometha zingenziwa kumashadi usebenzisa imenyu ehla noma imenyu evamile evula uma uchofoza ngakwesokudla into.

Ukushintsha imibala yangemuva yeshadi lonke nendawo yesakhiwo - ibhokisi eliphakathi leshadi elibonisa idatha - lizokwenziwa ngokusebenzisa imenyu yesimo.

Ukushintsha Umbala Ongemuva Wesigcawu

1. Chofoza ngakwesokudla ngemuva kwekhadi elimhlophe ukuze uvule imenyu yesimo somdwebo
2. Chofoza umcibisholo omncane ophansi ngakwesokudla seSithombe sokugcwalisa ifomu - upende ungakwazi - kubha yamathuluzi yomongo ukuvula iphaneli ye- Theme Colors
3. Chofoza ku- White, Ingemuva 1, Okumnyama okungu-35% ukushintsha umbala wangemuva weshadi ku-grey emnyama

Ukushintsha Umbala Wendawo Yombala Ongemuva

Qaphela: Qaphela ukuba ungakhethi imigqa yegridi enezingqimba egijima endaweni yesakhiwo kunesizinda ngokwaso.

1. Chofoza ngakwesokudla ngemuva kwesizinda sangasese sendawo ukuze uvule imenyu yomongo wesimo sendawo
2. Chofoza umcibisholo omncane ophansi ngakwesokudla seSithombe sokugcwalisa ifomu - upende ungakwazi - kubha yamathuluzi yomongo ukuvula iphaneli ye- Theme Colors
3. Chofoza ku- White, Ingemuva 1, Okumnyama okwe-15% ukushintsha umbala wangemuva wesakhiwo ukuze ukhanyise grey

09 ka 09

Ukwengeza umphumela we-3-D we-Bevel nokuphinde uphinde uhlele Ishadi

Ukwengeza umphumela we-bevel we-3-D ufaka kancane ukujula kushadi. Ushiya ishadi ngombono ongaphandle obuka ngaphandle.

1. Chofoza ngakwesokudla ngemuva kwesiqeshana ukuze uvule imenyu yesimo somongo
2. Chofoza kuKhetho lwamaShadi weShadi lethebula kubha yamathuluzi yomongo ukuze uvule ibhokisi lengxoxo
3. Chofoza kufomethi ye- 3-D ngakwesokunxele kwephaneli lebhokisi lengxoxo yesitayela sefomethi yefomethi
4. Chofoza umcibisholo ophansi ngakwesokudla kwesithonjana esiphezulu ngakwesokudla kwesandla ukuze uvule iphaneli yezinketho ze-bevel
5. Chofoza ku- Circle inketho kuphaneli - ukhetho lokuqala esigabeni se- Bevel sephaneli
6. Chofoza inkinobho ethi Vala ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela

Hlela kabusha Ishadi

Ukulungisa kabusha ishadi kungenye isinyathelo sokuzikhethela. Inzuzo yokwenza ishadi elikhudlwana ukuthi liyanciphisa ukubukeka okuxubile okudalwe yi-axis yesibili yokuma ngakwesokunene kweshadi.

Kuzophinde kwandise ubukhulu bendawo yendawo eyenza idatha yedatha ibe lula ukuyifunda.

Indlela elula yokuguqula ishadi ukusebenzisa izibambo zokugqoka ezisebenza ngokuzungezile engxenyeni yangaphandle yeshadi uma uchofoza kuso.

1. Chofoza kanye kwirekhodi leshadi ukuze ukhethe ishadi lonke
2. Ukukhetha ishadi kunezela umugqa ohlaza okwesibhakabhaka ohlangothini lwangaphandle lweshadi
3. Ezingxenyeni zalolu luhlaka oluhlaza okwesibhakabhaka kukhona ukuphatha izinto
4. Hambisa isikhombisi sakho segundane ngaphezu kweyodwa yamakona kuze kube yilapho isichazamazwi sishintsha kumcibisholo omnyama ophethwe kabili
5. Uma i-pointer yile mcibisholo ohlosiwe kabili, chofoza inkinobho yegundane lesokunxele bese uphumela ngaphandle ukuze ukwandise ishadi. Ishadi lizophinde libe nosayizi kokubili ubude nobubanzi. Indawo yesakhiwo kufanele ikhule ngobukhulu.

Uma ulandele zonke izinyathelo kulokhu okufundiswa kulokhu iphuzu lakho lesikhathi sezulu lifane nesibonelo esiboniswe esithombeni engxenyeni yokuqala yalesi sifundo.