Iintlobo zeTyati zoHlangano kwi-Excel 2010

01 ka 09

Yongeza i-A Yesekondari kwiKhadi le-Excel

Qaphela : Amanyathelo acacisiwe kule khokelo asebenzayo kuphela kwiinguqu ze-Excel ukuya kwi- Excel 2010 .

I-Excel ikuvumela ukuba udibanise ezimbini okanye ezahlukeneyo zeshati okanye iintlobo zegrafu ukwenza kube lula ukubonisa ulwazi olunxulumene kunye.

Enye indlela elula yokufezekisa lo msebenzi ngowongezelelo lwesibini okanye i-Y axis kwicala lasekunene letshathi. Iiseti ezimbini zeenkcukacha zikwabelana ngesahluko esiqhelekileyo se-X okanye i-axis ephezulu ngaphantsi kwetshathi.

Ngokukhetha iintlobo zetshathi ezongezelelweyo - njengetshathi yekholomu kunye negrafu yomgca - ukunikezelwa kweeseti ezimbini zedatha kunokuphuculwa.

Ukusetyenziswa ngokuqhelekileyo kulolu hlobo lwendibaniso yetshathi kubandakanya ukubonisa ubushushu bemitha yenyanga kunye nedatha yenkcazelo kunye, ukuvelisa iinkcukacha ezifana neeyunithi eziveliswe kunye neendleko zemveliso, okanye umthamo wenyanga yokuthengisa kunye nexabiso eliqhelekileyo lokuthengiswa kwenyanga.

Iimfuneko zeKhadi leMpawu

• Enye imfuneko yedatha eboniswa kukuba kufuneka ihlanganyele ixabiso le-X axis (e-horizontal) - njengexesha lexesha okanye indawo.
• Kwakhona, akuzona zonke iindidi zetshathi ezidibeneyo. I-charts ezi-3-D, umzekelo, ayikwazi ukufakwa kwifati yentsebenziswano.

Excel Climate Graph Tutorial

Le tutorial ihlanganisa amanyathelo afanelekileyo okudibanisa iikholeji kunye neetrafikiti zomgca kunye nokwenza igrafu yemozulu okanye i- climmatograph , ebonisa ukushisa kwenyanga nganye kunye nendawo yokunyulela indawo.

Njengoko kuboniswe kumfanekiso ongentla, ireyati yekholomu, okanye igrafu, ibonisa imvula yenyanga imitha ngelixa igrafu yomgca ibonisa ixabiso lokushisa eliphakathi.

Iimfundiso zeTutorial

Amanyathelo alandelayo ekufundiseni ukudala igrafu yemozulu yile:

1. Yakha isatidi ebalulekileyo yesibini yomhlathi, ebonisa ubumninzi kunye nedatha lokushisa kumakholomu ahlukeneyo
2. Shintsha uhlobo lwetshathi kwidatha lokushisa ukusuka kwiikholam ukuya kumgca
3. Dlulisa idatha yobushushu kwi-axis eyimphambili eyona ndawo (kwicala lasekhohlo letshathi) ukuya kwi-axis esecaleni (ngakwesokudla kwetshathi)
4. Faka isicelo sokwenza ifomathi kwisiseko segrafu yemozulu ukuze ihambelane negrafu ebonwe kumfanekiso ongentla

02 we-09

Ukungena nokukhetha idatha yeGrafu yeGrafu

Isinyathelo sokuqala ekudaleni igrafu yemozulu kukufaka idatha kwiphepha lokusebenzela .

Xa idatha ingenisiwe, isinyathelo esilandelayo kukuba ukhethe idatha eya kufakwa kwishati.

Ukukhetha okanye ukugqamisa idatha ixelela i-Excel yintoni ulwazi olukwiphepha lokusebenzela elibandakanya kwaye lithintela.

Ukongeza kwidata yenani, qiniseka ukuba uquka zonke iikholomu kunye nezihloko zemiqolo ezichaza idatha.

Qaphela: Uqeqesho alubandakanyi amanyathelo okufometha iphepha lokusebenzela njengoko kuboniswe kumfanekiso ongentla. Ulwazi malunga neendlela zokwenza ifomathi yomsebenzi lufumaneka kule khokelo lokufomathiza elisezantsi .

Iimfundiso zeTutorial

1. Faka idatha njengoko iboniswe kumfanekiso ongentla kwiiseli A1 ukuya kwiC14.
2. Phakamisa iiseli ezi-A2 ukuya kwi-C14 - olu luhlu lolwazi oluya kubandakanywa kwitshathi

03 ka 09

Ukudala Isatifiketi seKholeji esisisiseko

Zonke iitshathi zifunyenwe phantsi kweTayiti ye- Ribbon ye-Excel, kwaye bonke babelane ngezi zixhobo:

• Xa udala nayiphi na isati e-Excel, inkqubo yokuqala idala into ebizwa ngokuba isatiyi esisiseko usebenzisa idatha ekhethiweyo
• Ukuhambisa i- pointer yakho ye mouse kwimigangatho yetshathi iya kuvelisa inkcazo yetshathi
• Ukuchofoza kwinqanaba livula ukuhla kwehla kubonisa zonke iintlobo zeeshati ezifumaneka kulolu hlobo

Isinyathelo sokuqala ekudaleni nayiphi na ididi yentsebenzo - njengegrafu yemozulu - kukucwangcisa yonke idatha kwifayile enye yetshathi uze utshintshe isethi enye yedatha kwindlela yesibini yetshathi.

Njengoko kuthethwe ngaphambili, kule grafu yemozulu, siza kuqala kwisakhelo seenkcukacha zedatha yekholomu njengoko kuboniswe kumfanekiso ongentla, kwaye utshintshe uhlobo lwetshathi kwidatha lokushisa kwigrafu yomgca.

Iimfundiso zeTutorial

1. Ngedatha yetshathi ekhethiweyo, chofoza kwi Faka> Ikholomu> I-Column e-2-d eqingqiwe kwi-Ribbon
2. Isalathisi esisiseko sekholomu, esifana nesibonwa kumfanekiso ongentla, kufuneka senziwe kwaye sifakwe kwiphepha lokusebenzela

04 we-09

Idatha yokuTshintshisa idatha kwiGraph Line

Ukutshintsha iintlobo zetshathi kwi-Excel zenziwe ngokusebenzisa ibhokisi yencoko yohlobo lwebhokisi yeTyhuthi .

Ekubeni sifuna ukutshintsha enye yezinto ezimbini zedatha eziboniswe kwindlela ekhethiweyo yetshathi, kufuneka sixelele i-Excel ukuba yeyiphi.

Oku kungenziwa ngokukhetha, okanye ukucofa kanye, kwinye yamakholomu kwitshati, ebonisa zonke iikholomu zombala ofanayo.

Iinqununu zokuvula ibhokisi yencoko yebhokisi yencoko yababini ibandakanya:

• nqakraza kwiSimbo soTshintsho lweTyrtti kwiThebhu yoyilo yebhoni
• ngokuchofoza ngokukodwa kwenye iikholomu ezikhethiweyo kwaye ukhetha inketho yoTshintsho lweTyati yeSahluko kwiMenyu ehlayo

Zonke iindidi zetshathi ezikhoyo zifakwe kwibhokisi yencoko, kulula ukuba utshintshe ukusuka kwetshathi enye ukuya kwenye.

Iimfundiso zeTutorial

1. Cofa kanye ngeyinye yamakholomu wedatha lokushisa - uboniswe ngokuluhlaza kumfanekiso ongentla - ukhethe zonke iikholomu zaloo mbala kwitshathi
2. Hlela ummangali we mouse phezu kwelinye lemihlathi kunye neqhosha lokunene nge mouse ukuze uvule imenyu yenkomfa yokulahla
3. Khetha Uhlobo lweTyrtti yeTyrtti yoTshintsho ukusuka kwimenyu ehlayo ukuvula ibhokisi yencoko yohlobo lwebhokisi leTshintsho
4. Cofa kwindlela yokuqala yegrafu kwinqanaba lokunene lebhokisi yencoko
5. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela
6. Kwitshathi, idatha lokushisa kufuneka ngoku iboniswe njengomgca ohlaza okwesibhakabhaka ngokungekho kwiikholomu zedatha yolwakhiwo

05 ka 09

Ukuhambisa idatha kwi-Axis yesiThili

Ukutshintsha idatha yobushushu kumgca wegrafu kunokukwenza kube lula ukwahlula phakathi kweesethi ezimbini zeedatha, kodwa, ngenxa yokuba zombini zicwangciswe kwi- axis efanayo, iqondo lokushisa liboniswa njengomgca othe ngqo osixelela kakhulu ukushisa kwenyanga.

Oku kwenzeke ngenxa yesikali se-axis enye ezama ukufumana iiseti ezimbini zeedatha ezihluka kakhulu ngobukhulu.

Idatha yeqondo lokushisa ye-Acapulco inomlinganiselo omncinci kuphela ukusuka kwi-26.8 ukuya kwi-28.7 degrees Celsius, ngelixa ichanelo lwedatha lihluka ukusuka ngaphantsi kwama-millimitha ngoMatshi ukuya kuma-300 mm ngoSeptemba.

Ekusekeni umlinganiselo we-axis ecacileyo ukubonisa uluhlu oluninzi lweedatha zokunkcenkceshela, i-Excel isusile nayiphi na imbonakalo yokutshintsha kwedatha lokushisa yonyaka.

Ukuhambisa idatha yeqondo lokushisa kwi-axis yesibini ebonakalayo-kuboniswe kwicala lasekunene kwetshathi livumela izikali ezihlukeneyo kwimigangatho emibini yedatha.

Ngenxa yoko, ishati iya kuba nakho ukubonisa ukuhluka kweesethi zombini yedatha ngexesha elifanayo.

Ukuhambisa idatha yeqondo lokushisa kwi-axis ye-sectical vertical yenziwe kwibhokisi yencoko yababini yoCwangciso lweDatha .

Iimfundiso zeTutorial

1. Cofa kanye kwinqanaba lokushisa - luboniswe obomvu kumfanekiso ongentla - ukuwukhetha
2. Ukuhambisa umgca we mouse phezu komgca kwaye nqakraza ngakwesokudla kunye nemouse ukuze uvule imenyu yomxholo wehla
3. Khetha inketho yoCwangciso lweDatha yeDatha ukusuka kwimenyu ehlayo ukuvula ibhokisi yencoko yomxholo weDatha yeDatha

06 ka 09

Ukuhambisa idatha kwi-Y eSekondari Y (Axis)

Iimfundiso zeTutorial

1. Cofa kwiCandelo leeNqakrazo kwicala lokunxele lasebhokisi yencoko xa kuyimfuneko
2. Cofa kwiCandelo le- Axis yeSecondari kwicala lokunene lebhokisi yencoko yababini njengoko kuboniswe kumfanekiso ongentla
3. Cofa kwiQhosha eliValiweyo ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela
4. Kwitshathi, ireyithi yedatha lokushisa kufuneka iboniswe ngokufanelekileyo kwicala

Njengomphumo wokufudumala kwedatha lokushisa kwi-axis yesibini ebonakalayo, umgca obonisa idatha yechanelo kufuneka ubonise ukuhluka kobuninzi kwinyanga ukuya kwinyanga ukwenza kube lula ukubona ukushisa.

Oku kwenzeka ngenxa yokuba umlinganiselo wedatha lokushisa kwi- axis ecacileyo kwicala lasekunene letshathi ngoku sele likhupha uluhlu lwee-degrees Celsius ngaphantsi kwezinga elide ukusuka kwi-zero ukuya ku-300 xa idilesi ezimbini zikwabelwana ngazo esinye isixa.

Ukufometha iGrafu yemozulu

Kule ngongoma, igrafu yemozulu ifanele ifane nomfanekiso oboniswe kwisinyathelo esilandelayo sesifundo.

Amanyathelo aseleyo kwiphepha lokufundisa ekusebenziseni ukhetho lokufomathiza kwigrafu yemozulu ukuze lifane negrafu eboniswe kwisinyathelo esinye.

07 ka 09

Ukufometha iGrafu yemozulu

Xa kuziwa ekufomeni amashadi kwi-Excel akumele uvume ukufomathiza okungagqibekanga kuyo nayiphi na into yetshathi. Zonke iindawo okanye izinto zetshathi zingatshintshwa.

Izinketho zokufomathiza zetshathi zifumaneka kwiithebhu ezintathu zebhanethi ezibizwa ngokuba ziTyhuthi zixhobo

Ngokuqhelekileyo, ezi zithebhu ezintathu azibonakali. Ukufikelela kuzo, nqakraza kwiqati elisisiseko owayidalile kunye namathathu amathathu - Ukuyila, ukuPhathwa, kunye neFomathi - zongezwa kwidbhoni.

Ngaphezulu kwezi zithuba ezintathu, uza kubona i- Chart Tools Tools .

Kwimanyathelo okufundisa aseleyo okutshintshwayo okuza kwenziwa:

• Yongeza iibhanti kunye nezihloko zeeteksi
• ukuhambisa umgca kwi-top yetshathi
• Tshintsha imibala kunye nemibala yangemvelaphi
• Bevel umda wangaphandle kwetshathi
• Nciphisa ishati

Ukongeza I-Axis Title I-Horizontal

I-axis ene-horizontal ibonisa imihla ephantsi kwetadi.

1. Cofa kwichati eyisiseko kwiphepha lokusebenzela ukuze uvelise iithebhu zethuluzi leseshati
2. Cofa kwiTyhu yoTywala
3. Cofa kwiAxis Titles ukuvula uluhlu lokuhla
4. Cofa kwiSihloko se-Axisi esiPrayimari esiPhambili> Isihloko Ngezantsi kwe-Axis inketho yokongeza isihloko esizenzekelayo Isihloko se- Axis kwitshathi
5. Hudula ukhethe isihloko esizenzekelayo ukusigxininisa
6. Thayipha kwisihloko esithi " Inyanga "

Ukongeza I-Axis yokuqala ye-Axis Title

I-axis eyona nto yokuqala ibonisa ixabiso lezabelo ezithengiswa ngecala lasekhohlo kwetshathi.

1. Cofa kwitshathi xa kuyimfuneko
2. Cofa kwiTyhu yoTywala
3. Cofa kwiAxis Titles ukuvula uluhlu lokuhla
4. Cofa kwiSiqendu se-Axisi esiPhezulu esiPrayimari> Ukhetho lweSitifiketi olujikelezayo ukufaka isihloko esiyiNtloko kwisiXhosa
5. Gqamisa isihloko esilungileyo
6. Thayipha kwisihloko esithi " Ukunqumla (mm) "

Ukongeza I-Axis I-Axis Title eSekondari

I-axis ebonakalayo yesibini ibonisa uluhlu lweentengo zentengiso ezithengiswa kwicala lasekunene letshathi.

1. Cofa kwitshathi xa kuyimfuneko
2. Cofa kwiTyhu yoTywala
3. Cofa kwiAxis Titles ukuvula uluhlu lokuhla
4. Cofa kwiSixikethi se-Axisi eSekondari eSekondari> Ukhetho lweSihloko olujikelezayo ukuze ungeze isihloko esizenzekelayo Isihloko se- Axis kwishati
5. Gqamisa isihloko esilungileyo
6. Thayipha kwisihloko esithi " Umyinge wokushisa (° C) "

Ukongeza Isihloko soTyati

1. Cofa kwitshathi xa kuyimfuneko
2. Cofa kwiTyhu yoLungiselelo yerbhoni
3. Cofa kwiSihloko soTyati> Ukhetho olungaphezulu kweTyrt ukuze ungeze isihloko seTreyiti esizenzekelayo kwishati
4. Gqamisa isihloko esilungileyo
5. Thayipha kwisihloko esithi Climatograph ye-Acapulco (1951-2010)

Ukutshintsha Umbala weTayiti yeBlue Font

1. Cofa kanye kwiSihloko soTyati ukuze ukhethe
2. Cofa kwiThebhu yaseKhaya kwimenyu yebhondi
3. Cofa kwinqolo engezantsi yohlobo lweMbala yePolisi ukuvula imenyu ehlayo
4. Khetha Uluhlaza obomvu ngaphantsi kwecandelo eliqhelekileyo lemibala yemenyu

08 ka 09

Ukuhambisa iNkundla kunye nokutshintsha iMvelaphi yeNgingqi

Ngokungagqibekanga, i-legend yetshathi ikhona kwicala lasekunene leseshati. Xa sithe wongeza isihloko sesibini se-axis, izinto zifumana indawo encinane kuloo ndawo. Ukunciphisa ukudibanisa siya kuhambisa umgca phezulu kwitshathi ngaphantsi kwesihloko seetati.

1. Cofa kwitshathi xa kuyimfuneko
2. Cofa kwiTyhu yoLungiselelo yerbhoni
3. Cofa kwiGosa lokuvula uluhlu lokuhla
4. Cofa kwi- Show Legend kwi-Top option ukuhambisa umgca ukuya kwinqanaba lesicatshulwa ngaphantsi

Ukusebenzisa Imenyu yokuCwangcisa Imenyu Yomxholo

Ukongeza kwizixhobo zetshathi zetshathi kwi-ribbon, utshintsho lwefomathi lungenziwa kwiitshathi usebenzisa imenyu yokuhla okanye imenyu evulwayo xa ucofa ngokuchanekileyo kwinto.

Ukutshintsha imibala engemvelaphi yetshathi yonke kunye nendawo yesalathiso - ibhokisi ephambili yetshathi ebonisa idatha - iya kwenziwa ngokusebenzisa imenyu yomongo.

Ukutshintsha Umgca weNgingqi Umbala

1. Ukucofa ngokuchanekileyo kwimvelaphi emhlophe yetshathi ukuvula imenyu yenkcazelo yetshathi
2. Cofa kwiincinci ezantsi ezantsi kwesokudla se- Shape Fill icon - ipeyinti inakho-kwibar yomxholo wendawo yokuvula i-panel Colors panel
3. Cofa kwi- White, Imvelaphi 1, i-35% emnyama ukutshintsha umbala wesiqalo somtya kwi-gray grey

Ukutshintshwa kwendawo yoMbala Umbala

Qaphela: Qaphela ukuba ungakhethi imigca yegridi ejikelezayo ehamba kwindawo yendawo yeqonga kunokuba imvelaphi ngokwayo.

1. Ukucofa ngakwesokudla kwendawo yangasese yendawo yokuvula ukuvula imenyu yomxholo wendawo yengingqi
2. Cofa kwiincinci ezantsi ezantsi kwesokudla se- Shape Fill icon - ipeyinti inakho-kwibar yomxholo wendawo yokuvula i-panel Colors panel
3. Cofa kwi- White, Imvelaphi ye-1, i-Darker 15% ukuguqula umbala wendawo yengqumbo ukuze ukhanyise imvi

09 we 09

Ukongeza umphumo we-3-D we-Bevel Effect kunye nokuCwangcisa iShadi

Ukongeza umphumo we-3-D uvelisa ubuncinane kwitshathi. Ushiya ishati kunye nekhongo elikhangele ngaphandle.

1. Ukucofa ngakwesokudla kwimvelaphi yetshathi ukuvula imenyu yenkcazelo yetshathi
2. Cofa kwiKharithi yeTrafik yeNgingqi kwi-bar toolbar ukuvula ibhokisi yencoko
3. Cofa kwifomathi ye- 3-D kwifayile yesandla sokunxele yebhokisi yencoko yencoko yendawo yefayile
4. Cofa kwinqolo engezantsi ukuya kwesokudla se icon ephezulu kwipaneli yokunene ukuze uvule iphaneli yezinketho ze-bevel
5. Cofa kwiCyclecle inketho kwipaneli - ukhetho lokuqala kwicandelo le- Bevel yepaneli
6. Cofa kwiQhosha eliValiweyo ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela

Ukuphonononga kwakhona iTharthi

Ukulungiswa kwakhona kwetadi enye inyathelo lokuzikhethela. Inzuzo yokwenza ishadi elikhulu kukuba liyanciphisa ukubukeka okubanzi okudalwe yisekhsi yesibini engezantsi ngakwesokunene kwiteksi.

Kuya kwandisa ubungakanani bendawo yesalathisi eyenza idatha yetshathi ibe lula ukuyifunda.

Indlela elula yokutshintsha isatshati ukusebenzisa izicwangciso zokubamba ezisebenzayo ezisebenzayo ngaphaya komda wangaphandle kwetshathi emva kokuchofoza kuyo.

1. Nqakraza kamva kwitektha yetshathi ukuze ukhethe ishadi lonke
2. Ukukhetha ishati kufaka umgca oluhlaza okwesibhakabhaka ukuya kumda wangaphandle kwetshathi
3. Kwiinkalo zalo mphahla eluhlaza okwesibhakabhaka ziyakwenza izicwangciso
4. Hambisa i-pointer yakho ye mouse phezu kwelinye lamacangci kude kube i-pointer ishintshela kwintolo emnyama ebanzi
5. Xa i-pointer yile ntloko eneentloko ezimbini, nqakraza kunye nekhompi ye mouse kwaye ushenxise ngaphandle ukuze ukwandise ishati. Ishati iya kubuya kwakhona ngobubanzi nobubanzi. Indawo yesalathisi kufuneka ikhulise ngobukhulu.

Ukuba ulandele onke amanyathelo kule khokelo kule ngongoma igrafu yakho yemozulu ifana nomzekelo oboniswe kumfanekiso kwinxalenye yokuqala yale tutorial.