Yakha uphinde Ufake umgca weGrafa kwi-Excel kwiiNtshukumo ezi-5

by Ted French

Xa ufuna nje umgca, kukho iingcebiso ezilula zokusebenzisa

Kwi-Microsoft Excel, ukongeza igrafu yomgca kwiphepha okanye incwadi yokusebenzela yenza ukubonakaliswa kokubonakala kwedatha. Kwezinye iziganeko, loo mfanekiso wedatha ingabonakalisa izitshintshi kunye nezinguqu ezinokuthi zingabonakali xa idatha ingcwatywa kwimigqa kunye neikholomu.

Ukwenza iGraph Line-The Short Version

Amanyathelo okongeza isiseko somgca wesigcawu okanye ishadi lomgca kwiphepha lokusebenzela lase Excel yile:

Phakamisa ulwazi ukuba lufakwe kwigrafu - zibandakanya izihloko zemiqolo kunye nekholomu kodwa kungekhona isihloko setafile yedatha.
Cofa kwi- Insert ithebhu yebhebhoni .
Kwiphepha leSahluko sebhebhoni, nqakraza kwi icon ye- Insert Line Chart ukuvula uluhlu lokuhlahla lweetayiti / igrafu ezikhoyo.
Hambisa isalathisi sakho se mouse phezu kwendlela yetshathi yokufunda inkcazo / igrafu.
Cofa kwigrafu efunwayo.

Igrafu ecacileyo, engakhange ifaniswe - ebonisa kuphela imigca emele inkqutyana yedatha ekhethiweyo, isihloko seshati esingagqibekanga, i-legend, kunye nemilinganiselo ye-axes - iya kufakwa kwiphepha lokusebenzela elikhoyo.

Ukwahluka kweenguqulelo

Amanyathelo kule tutorial basebenzisa iindlela zokufometha kunye neendlela zokufumaneka ezikhoyo kwi-Excel 2013. Ezi zihluke kwizinto ezifumaneka kwiinguqulelo zangaphambili zenkqubo. Sebenzisa ezi zilandelayo ziqhagamshelo zezifundo zegrafu zeetrafini kwezinye iinguqulelo ze-Excel.

Inqaku kwi-Excel's Theme Colors

I-Excel, njengenkqubo zonke zeMicrosoft Office, isebenzisa iingqikithi ukusekwa kwimiqulu yayo. Ngokuxhomekeke kwimxholo oyisebenzisayo ngelixa ulandela le khosi, imibala echazwe kumanyathelo okufundisa ayinakufana nawawasebenzisayo. Unokukhetha nayiphi na umxholo oyithandayo kwaye uqhubeke.

Ukwenza iGraph Line-The Long Version

Qaphela: Ukuba awunayo idatha esetyenziswayo kunye nale khokelo, amanyathelo kule tutorial asebenzise idatha eboniswe kumfanekiso ongentla.

Ukungenisa enye idatha kuhlala isinyathelo sokuqala ekudaleni igrafu - kungakhathaliseki ukuba uluphi uhlobo lwegrafu okanye ishati edalwayo.

Isinyathelo sesibini sibonakalisa idatha ekufuneka isetyenziswe ekudaleni igrafu. Idatha ekhethiweyo ibandakanya izihloko zekholomu kunye nezihloko ezilandelwayo, ezisetyenzisiweyo njengeebhalile kwitshati.

Faka idatha eboniswe kumfanekiso ngasentla kwiiseli zomsebenzi ezichanekileyo.
Emva kokungena, phawula uluhlu lweeseli ezivela kwi-A2 ukuya ku-C6.

Xa ukhetha idatha, izihloko zekhowudi kunye nekholomu zifakiwe ekukhetheni, kodwa isihloko esiphezulu setafile yedata asikho. Isihloko kufuneka songezwe kwigrafu ngesandla.

Ukudala i-Basic Line Graph

Amanyathelo alandelayo aya kudala igrafti yomgca wesiseko - igrafu ecacileyo, engaqinisekanga - ebonisa uchungechunge lwedatha olukhethiweyo kunye neenxeksi.

Emva koko, njengoko kukhankanywe, i-tutorial ihlanganisa indlela yokusebenzisa ezinye iimpawu zokufomathiza eziqhelekileyo, ezilandelayo, eziya kulandelwa, ziya kutshintsha igrafu yesiseko ukufanisa igrafu yomgca eboniswe kwisilayidi sokuqala sale khokelo.

Cofa kwi- Insert ithebhu yebhebhoni.
Kwisiqendu seSahluko semenyu yombonakalo, nqakraza uphawu lwe- Insert Line Chart ukuvula uluhlu lokuhlahla lweefayile zegrafu / ietshathi.
Hambisa isikhombisi sakho semouse phezu kohlobo lwegrafu ukufunda inkcazo yegrafu.
Cofa kwi-2-d yokuqala yegrafu yomgca woluhlu kuluhlu lokukhetha.
Isiseko somgca wegrafu sidalwe kwaye sifakwe kwiphepha lakho lokusebenzela njengoko kuboniswe kumfanekiso kwisilayidi esilandelayo ngezansi.

Ukufometha iSiseko soMgca weGraf: Ukongeza isiGaba seTyati

Hlela isiKhadi seTyati esingagqibekanga ngokuchofoza kuso kabini kodwa ungaqakraza kabini

Nqakraza kanye kwinqaku lechasi elikhethiweyo ukulikhetha - ibhokisi kufuneka ibonakale ngeenxa zonke kwigama lesiTyhuthi.
Cofa okwesihlandlo sesibini ukubeka i-Excel kwimodi yokuhlela , ebeka isikhombisi ngaphakathi kwebhokisi lebhokisi.
Cima itekisi engagqibekanga usebenzisa iifayile zokuCima / i-Backspace kwikhibhodi.
Faka isihloko sesithati - Umyinge wokuNciphisa (mm) - kwibhokisi yebhokisi

Ukuchofoza kwiCandelo elingalunganga leShadi

Kukho iinxalenye ezininzi ezahlukileyo kwiitshathi kwi-Excel - njengesihloko seshati kunye neelayibhile, indawo yesalathisi equlethe imigca emele idatha ekhethiweyo, iinqununu ezizenzekelayo kunye nezicwangciso eziqhelekileyo.

Zonke ezi ndawo zibhekwa njengezinto ezihlukeneyo kwinkqubo, kwaye, ngoko kunjalo, nganye inokufomelwa ngokuhlukileyo. Utshela i-Excel ukuba yiyiphi inxalenye yegrafu ofuna ukuyifomatha ngokuchofoza kuyo kunye ne-pointer ye mouse ukuze ukhethe.

Ngeli thuba, ukuba iziphumo zakho azifani nazo zidweliswe, mhlawumbi ungenayo inxalenye efanelekileyo yetshathi ekhethiweyo xa usebenzisa isicelo sokhetho.

Impazamo eqhelekileyo eyenziwa ngokuchofoza kwindawo yesalathisi phakathi kwergraph xa injongo ikhetha yonke igrafu.

Indlela elula yokukhetha igrafu yonke ucofa kwikona eliphezulu okanye ngakwesokudla ukusuka kwisihloko seshati.

Ukuba kukho iphutha, lingaqwalatshwa ngokukhawuleza usebenzisa isicatshulwa se-Excel. Emva koko, nqakraza kwicala elifanelekileyo letshathi uze uzame kwakhona.

Ukutshintsha imibala yeGrafu usebenzisa iiTyhu Tools Tools

Xa ityati / igrafu idalwe kwi-Excel, okanye nayiphi na igrafu ekhethiweyo ikhethiweyo ngokuchofoza kuyo, iithebhu ezimbini ezongezelelweyo zongezwa kwi-Ribbon njengoko kuboniswe kumfanekiso ongentla.

Ezi ithebhu zeTyrt Tools - Design kunye neFomathi - ziqukethe ukufomatha nokukhethwa kwezinto ezikhethiweyo ngokukhethekileyo kwiitshathi, kwaye ziya kusetyenziswa kula ma nyathelo alandelayo ukutshintsha imvelaphi kunye nombala wombhalo wegrafu.

Ukutshintsha Umbala weGrafu

Kule grafu elithile, ukufometha imvelaphi yinkqubo yezinyathelo ezimbini kuba i-gradient yongezwa ukubonisa utshintsho oluthile kumbala ojikelezayo kwigrafu.

Cofa kwimvelaphi ukukhetha yonke igrafu.
Cofa kwiTyhubhu ithebhu yebhoni.
Cofa kwi- Shape Fill option, echongiweyo kumfanekiso ongentla, ukuvula i-Panneza yokuLawula imibala phantsi.
Khetha i- Black, Umbhalo 1, I-Lighter engu-35% ukusuka kwisiqendu se-Theme Colors kwoluhlu.
Cofa kwi- Shape Ukugcwalisa inketho okwesihlandlo sesibini ukuvula iMenyu ye-Colours yehla.
Khupha isalathisi se mouse phezu kwekhetho elifutshane ngasezantsi kwoluhlu ukuvula iPanelient Gradient.
Kwiphepha leNguqulelo ebumnyama yepaneli, nqakraza kwiCandelo elikhethiweyo elikhethiweyo ukufaka isalathisi esenza ukuba kube mnyama ngokunyuka ukusuka kwesobunxele ukuya ngasekunene kwigrafu.

Ukutshintsha Umbala Wombhalo

Ngoku ukuba imvelaphi ibumnyama, umbhalo obumnyama ongezantsi awubonakali. Eli candelo lilandelayo litshintsha umbala wezobhaliweyo kwigrafu ukuya kumhlophe

Cofa kwimvelaphi ukukhetha yonke igrafu.
Cofa kwifomathi yefomathi yebhebhoni xa kuyimfuneko.
Ncofa iqhosha lokugcwalisa ifayile ukuvula uluhlu lwe-Text Colors.
Khetha i- White, Imvelaphi ye-1 ukusuka kwiCandelo leMbala ye-Color Colors.
Yonke isicatshulwa kwisihloko, x kunye ne-y axxes, kunye nomxholo kufanele uguqule kumhlophe.

Ukutshintsha Imibala Yemibala: Ukufometha kwiPaini YeeSebenzi

Amanqanaba amabini okugqibela okufundiswayo asebenzise ifomati yomsebenzi wefomathi , equlethe ezininzi zeendlela zokufomatha ezikhoyo kwiitshathi.

Kwi-Excel ka-2013, xa isebenze, ikhefu ibonakala ngakwesokunene kwicala le-Excel kwesikrini njengoko kuboniswe kumfanekiso ongentla. Isihloko kunye neenketho ezibonakala kwiphetshana lokutshintsha ngokuxhomekeke kwingingqi yetshathi ekhethiweyo.

Ukutshintsha Umbala Wemibala ye-Acapulco

Kwigrafu, nqakraza kamva kumgca welalanti we-Acapulco ukuze ukhethe - iincinci ezincinci zimele zivele kunye nobude bomgca.
Cofa kwi Fomati ithebhu yebhebhoni xa kuyimfuneko.
Kwiphepha elingakwesokunxele lebhebhoni, nqakraza kwindlela yokukhethwa kwefomathi ukuvula ifomathi yomsebenzi wokufometha .
Ekubeni umgca we-Acapulco wawukhethiwe ngaphambili, isihloko kwisifowuni kufuneka sifunde I-Series Data Data Series.
Kwifowuni, chofoza kwi-icon yokugcwalisa (upende unakho) ukuvula uluhlu lwezinketho zendlela.
Kuludwe lweenketho, nqakraza kwi-icon yokuzalisa ecaleni kwilebula yebalayi ukuze uvule uluhlu lweNqabileyo yokuLawula.
Khetha i- Green, Accent 6, Lighter 40% ukusuka kwisiqendu se-Theme Colours kwoluhlu - umgca we-Acapulco kufuneka uguqule kumbala oluhlaza.

Ukutshintsha iAmsterdam

Kwigrafu, nqakraza kanye nge-blue line ye-Amsterdam ukuyikhetha.
Kwifayile yefayile yokufometha, umbala we-Fill Ugcwaliso oboniswe phantsi kwe icon kufuneka utshintshe ukusuka eluhlaza ukuya kubomvu obonisa ukuba uluhlu lubonisa ngoku ukhetho lwe-Amsterdam.
Cofa kwi-icon yokugcwalisa ukuvula uluhlu lwe-Line Colours.
Khetha i- Blue, i-Accent 1, iLighter 40% ukusuka kwicandelo le-Color Colors yoluhlu - umgca we-Amsterdam kufuneka utshintshe kumbala obala obomvu.

Ukugqitywa kweGridlines

Utshintsho lokugqibela lokufomathiza olwenziweyo ukulungisa ii-gridlines ezihamba ngokubanzi ngapha kwegrafu.

Umgca wesiseko wegrafu uquka ezi zigalari ukuze wenze kube lula ukufunda amaxabiso ngamanqaku athile kwimigca yedatha.

Noko ke, akufuneki ukuba kuboniswe ngokugqithiseleyo. Enye indlela elula yokuyibeka phantsi kukuba ulungelelanise ukukhanya kwabo ngokusebenzisa ifowuni yomsebenzi wefomathi.

Ngokungagqibekanga, izinga labo lokungabonakali li-0%, kodwa ngokunyuka oko, iifayile zegridi ziya kuvela kwindawo esemvelaphi.

Cofa kwikhetho lokukhethwa kwefomati kwifomathi yefomathi yebhebhoni xa kuyimfuneko ukuvula ifowuni yomsebenzi wefomathi
Kwigrafu, nqakraza kanye kwi 150mm gridline ehamba phakathi kwegrafu - zonke iifayile zegridi kufuneka zigqitywe (amachaphaza amacwecwe ekupheleni kwegridline nganye)
Kwifowuni utshintshe izinga lokufihla kwi- 75% - iifriji zegridi kwigrafu kufuneka zilahleke kakhulu