Ungayenza njani igrafu kwi-Excel

Ishedyuli ikuvumela ukuba uvavanye rhoqo ukuxhomekeka kwedatha evela kwizikhombisi ezithile okanye izinto zawo. Ezi zinto zisetyenziswa kumsebenzi wesayensi okanye ophandayo, nakwimiboniso. Makhe sijonge indlela yokwakha igrafu kwiMicrosoft Excel.

Ukudala iigrafu kwi-Excel

Umsebenzisi ngamnye, onqwenela ukubonisa ngokucacileyo naluphi na ulwazi lwenombolo ngohlobo lwezithethi, unokwenza ishedyuli. Le nkqubo ilula kwaye ibonisa ubukho betafile eya kusetyenziselwa i-database. Ngokubona kwawo, into leyo inokuguqulwa ukuze ijongeke ngcono kwaye iphendule zonke iimfuno. Siza kuhlalutya indlela yokwenza iintlobo ezahlukeneyo zegrafu kwi-Excel.

Ukwakha ishedyuli eqhelekileyo

Ungazomisa ishedyuli kwi-Excel kuphela emva kokuba itafile ilungele idatha kwisiseko sokuba iya kwakhiwa ngayo.

1. Ukuba kwi "Faka" ithebhu, yabela indawo yetafile apho idatha ebaliweyo esifuna ukuyibona kwitshathi. Emva koko kwiteyiphu kwi "FRAAR" ibloko ibhloko ngokunqakraza kwiqhosha "ishedyuli".
2. Emva koko, kukho uluhlu apho kumelwe kwiindidi ezisixhenxe zeegrafu:
   • Ngesiqhelo;
   • Ngokuqokelelwa;
   • Ijikelezwe ngokuqokelelwa;
   • Nabamakishi;
   • Nabamakishi kunye nokuqokelelwa;
   • Okhethekileyo nabamakishi kunye nokuqokelelwa;
   • Ivolumu.

   Khetha enye ukuba umbono wakho ulungele iinjongo ezithile zolwakhiwo lwayo.



3. I-Excel ye-Excel yenza ngokwakha ngokuthe ngqo ishedyuli.

Imizobo ehlelayo

Emva kokwakha igrafu, ungayenza ukuba ihlele ukuze inike into ebonakalayo kwaye iququzelele ukuqonda kwento eboniswayo.

1. Ukutyikitya ishedyuli, yiya kwi-"yobeko" ithebhu ye-wizard yomsebenzi kunye neetshathi. Cofa kwiqhosha kwi-ribbon ngegama "i-chart tict". Kuluhlu oluvula, sichaza ukuba igama liya kuba phi: embindini okanye ngaphezulu kweshedyuli. Inketho yesibini ihlala ifanelekile ngakumbi, ke sisebenzisa "ngaphezulu komzobo" njengomzekelo. Ngenxa yoko, igama liyavela, elinokutshintshwa okanye lihlelwe ngokokubona kwalo, ngokunqakraza kulo kwaye lingene kubalinganiswa abafunayo kwikhibhodi.



2. Ungachaza igama le-axes ngokunqakraza kwiqhosha "le-Axis Igama". Kuluhlu olusezantsi, khetha le nto "igama le-axis ephambili", emva koko uye kwisikhundla "igama phantsi kwe-axis".



3. Phantsi kwe-axis kukho ifom yegama apho kusetyenziswa nabani na ukuba asetyenziswe khona.



4. Ngokufanayo, sisayina i-axis ethe nkqo. Cofa kwi "Igama leqhosha le-Axis", kodwa kwimenyu ebonakalayo, khetha "igama le-Axis ephambili". Uluhlu lweendlela ezintathu zokutyikitya ziya kuvulwa: ijikelezwe, nkqo, ethe tye, ethe tyaba. Kungcono ukusebenzisa igama elijikelezileyo, kuba kule meko indawo igcinwe ephepheni.



5. Kwiphepha elikufutshane ne-axis elihambelanayo, intsimi ivele apho ungangenisa igama elifanelekileyo ngokwemeko yedatha ekhoyo.



6. Ukuba ucinga ukuba ukuqonda ishedyuli yelegend ayifuneki kwaye kwenzeka kuphela, ungayicima. Cofa kwiqhosha le-Legend, ibekwe kwi-tepi, kwaye emva koko inketho ". Kwangoko, unokukhetha nasiphi na isikhundla sentsomi, ukuba awuyilicimi, kodwa tshintsha kuphela indawo.

Ukwakha ishedyuli ene-axle encedisayo

Kukho iimeko apho kufuneka ubeke iigrafu ezininzi kwindiza enye. Ukuba banamanyathelo olwalo olunye, oku kwenziwa ngendlela efanayo njengoko kuchaziwe apha ngasentla. Kodwa kuthekani ukuba kukho amanyathelo ahlukeneyo?

1. Ukuba kwi "Faka" ithebhu, okokugqibela, chaza amaxabiso etafile. Emva koko, sicofa iqhosha "ishedyuli" kwaye ukhethe eyona ndlela ifanelekileyo.



2. Njengoko sibona, kwenziwa imifanekiso emibini. Ukuze ubonise igama elichanekileyo leeyunithi zemilinganiselo yeShedyuli nganye, ukucofa iqhosha lemouse ekunene kwindawo nganye esiya kuyongeza i-Axis eyongezelelweyo. Kwimenyu ebonakalayo, chaza into "yefomathi yenani ledatha".



3. Inani lefestile yedatha isunguliwe. Kwicandelo layo "imiqolo", ekufuneka ivulwe ngokungagqibekanga, lungisa ukutshintshela kwindawo "ye-Auxiling Axilic". Cofa kwiqhosha elithi "Vala".



4. I-Axis entsha yenziwa, kwaye ishedyuli iya kulungiswa ngokutsha.



5. Kufuneka sisayine i-axis kunye negama legrafu kwi-algorithm efana nomzekelo wangaphambili. Ukuba kukho iigrafu, intsomi ilunge ngakumbi ukungacoceki.

Ukwakhiwa kwemizobo yomsebenzi

Ngoku makhe siyifumane indlela yokwakha itshathi kumsebenzi onikiweyo.

1. Masithi sinomsebenzi y = x ^ 2-2. Inyathelo liza kulingana no 2. Siqala ukwakha itafile. Kwinxalenye yasekhohlo, gcwalisa ixabiso le-X kwiNyathelo 2, oko kukuthi, 2, 4, 8, 10, njl njl. Kwinxalenye elungileyo siqhuba ifomula.



2. Okulandelayo, sizisa isikhombisi kwikona esezantsi yeselfowuni, cofa iqhosha lemouse lasekhohlo kwaye "wolule" emazantsi etafile, ngokwenza oko kwifomula.



3. Emva koko yiya kwithebhu "Faka" ithebhu. Khetha idatha yethebhulethi kwaye ucofe iqhosha le "Point" kwiteyiphu. Ukusuka kuluhlu olubonisiweyo lwemizobo, khetha inqaku ngejika eligudileyo kunye nabamakishi, njengoko olu hlobo lulungele ukwakha.



4. Imizobo yeMisebenzi isekwe kuyo.



5. Emva kokuba kwakhiwe into, ungayisusa imbali kwaye wenze amanye amathuba abonakalayo esele etshisiwe apha ngasentla.

Njengoko ubona, iMicrosoft Excel inikezela amandla okwakha iintlobo ezahlukeneyo zegrafu. Eyona meko iphambili kukuyila itafile nedatha. Ishedyuli edaliweyo inokutshintshwa kwaye ilungiswe ngokwenjongo.