Ungayakha njani igrafu kwi-Excel

Umsebenzi omnye oqhelekileyo wemathematics kukwakha ishedyuli yokuxhomekeka. Ibonisa ukuxhomekeka komsebenzi wokutshintsha impikiswano. Ephepheni, le nkqubo ayisoloko ilula. Kodwa izixhobo ze-Excel, ukuba siyazifumana ukubahluthi, sivumele ukuba wenze lo msebenzi ngokuchanekileyo nangokukhawuleza. Masifumanise ukuba le nto inokwenziwa njani kusetyenziswa idatha eyahlukeneyo yemithombo.

Inkqubo yendalo

Ukuxhomekeka komsebenzi wempikiswano yinto eqhelekileyo ye-algebraic. Uninzi kakhulu, impikiswano kunye nexabiso lomsebenzi elenziwa ukuba babonise iisimboli: ngokulandelelana, "x" kunye "y" kunye "y" no "y". Rhoqo, kubalulekile ukwenza umboniso wegraphing ngokuxhomekeka kwengxoxo kunye nemisebenzi ebhalwe kwitafile, okanye iboniswa njengenxalenye yefomula. Masihlalutye imizekelo ethile yokwakha igrafu (Imizobo) phantsi kweemeko ezahlukeneyo zemigaqo.

Indlela yoku-1: Ukwenza itafile esekwe kwiScreen esekwe kwiScreen

Okokuqala, siya kuhlalutya indlela yokwenza igrafu esekwe kwidatha esekwe kuluhlu lwetafile. Sisebenzisa itafile yokuxhomekeka kwendlela ehambileyo (y) ngexesha (X).

1. Sibonisa itafile kwaye siye kwithebhu "yokufaka". Cofa kwi "Shedyuli", esele ikwindawo kwiqela letshathi kwiRibbon. Ukukhetha iintlobo ezahlukeneyo zeegrafu ezivula. Ngeenjongo zethu, khetha eyona ilula. Ifumaneka kuqala kuluhlu. Udongwe kuwo.



2. Inkqubo ivelisa umzobo. Kodwa, njengoko sibonayo, imigca emibini iboniswa kwindawo yokwakha, ngelixa sidinga kuphela: ibonisa ukuxhomekeka komgama amaxesha ngamaxesha. Ke ngoko, sabela iqhosha le mouse lasekhohlo nge-Blue umgca ("Ixesha"), njengoko lingangqinelani nomsebenzi, kwaye ucofe iqhosha lokucima.



3. Umgca okhethiweyo uya kucinywa.

Ngokwenyani, kule, ukwakhiwa kweshedyuli yophawu olulula kunokuqwalaselwa kugqityiwe. Ukuba unqwenela, unokuhlela amagama etshathi, i-axes yayo, susa ibali kwaye uvelise ezinye iinguqu. Oku kuchazwe kwiinkcukacha ezingakumbi kwisifundo esahlukileyo.

ISIFUNDO: INDLELA YOKUYENZA I-SHEDYISEKILE NGOKUGQIBELA

Indlela 2: Ukwenza izenzo ezinemigca emininzi

I-ECODDIGTIONGE ENTONI YENKCAZO YENKCAZO YABADALA XA KUPHELA IXESHA LENXA YENZE IMISEBENZI EMITHUMENTE NGOKU. Kule meko, kuya kufuneka wakhe imigca emibini. Umzekelo, thatha itafile apho ingeniso ngokubanzi yeshishini kunye nenzuzo yayo ipeyintiwe.

1. Sibonisa itafile yonke kunye ne-cap.



2. Njengakwicala elidlulileyo, sicofa iqhosha "ishedyuli" kwicandelo letshathi. Kwakhona, khetha ukhetho lokuqala oluboniswe kuluhlu oluvulekileyo.



3. Le nkqubo ivelisa ukwakhiwa kwegraphic ngokwedatha efunyenweyo. Kodwa, njengoko sibonayo, kule meko, asinawo kuphela umgca wesithathu kuphela, kodwa kunye nesaziso kwi-Axis ethe tyaba yokulungelelanisa ayihambelani nezo zifunwayo, ezizenzelwe iodolo yonyaka.

   Cima ngokukhawuleza umgca ogqithisileyo. Nguye kuphela ngokuthe ngqo kulo mzobo - "unyaka." Njengakwindlela edlulileyo, sibalaselisa ukucofa kuyo ngemouse kwaye ucofe kwi-Cima iqhosha.



4. Umgca ususiwe kwaye kunye nayo, njengoko unokuqaphela, amaxabiso kwiphaneli yokulungelelanisa ethe nkqo iyatshintshwa. Bachaneka ngakumbi. Kodwa ingxaki ngokuboniswa okungalunganga kwe-axis ethe tyaba yokunxibelelanisa i-Axis. Ukusombulula le ngxaki, cofa kwicandelo lokwakha iqhosha lemouse lasekunene. Kwimenyu, kuya kufuneka uyeke ukukhetha "Khetha idatha ...".



5. Ifestile yokukhetha i-files ivulwa. Kwi-Axis Axis Axis Axis "ibhloko, cofa kwiqhosha" lotshintsho ".



6. Ifestile ivula ngaphantsi kwangaphambili. Kuyo, kuya kufuneka uchaze ukulungelelanisa kwitafile yelixabiso ekufuneka uboniswe kwi-Axis. Ukuza kuthi ga ngoku, setha isikhombisi kwicandelo kuphela le festile. Emva koko ndibambe iqhosha lemouse lasekhohlo kwaye ukhethe yonke imixholo yekholamu yonyaka, ngaphandle kwegama labo. Idilesi iya kuyichaphazela ngokukhawuleza intsimi, cofa u "Kulungile".



7. Ukubuyela kwi-windows yokukhetha idatha, iphinde icofe u "Kulungile".



8. Emva koko, zombini imizobo ebekwe kwiphepha iboniswe ngokuchanekileyo.

Indlela 3: Ukwakhiwa kwemizobo xa usebenzisa iiyunithi ezahlukeneyo zemilinganiselo

Kwindlela yangaphambili, siqwalasele ukwakhiwa komzobo kunye nemigca eliqela kwindiza enye, kodwa yonke imisebenzi yayineeyunithi ezifanayo (eziliwaka le-rubles). Yintoni endimele ndiyenze ukuba ufuna ukwenza ishedyuli yokuxhomekeka ngokusekwe kwitafile enye, apho iiyunithi zomsebenzi wokulinganisa zahlukile? I-Excel inemveliso kwaye ukusuka kwesi sikhundla.

Sinetafile, esibonisa idatha kumthamo wentengiso yemveliso ethile kwiitoni nakwingeniso evela ekuphunyezweni kwayo kumawakawaka ee-ruble.

1. Njengakwiimeko zangaphambili, sibela i-data yetafile yetafile kunye ne-cap.



2. I-Clay kwiqhosha "ishedyuli". Siphinda sikhethe ukhetho lokuqala lokwakha kuluhlu.



3. Iseti yemizobo yenziwa kwindawo yokwakha. Ngendlela efanayo, eyayichazwe kwiinguqulelo zangaphambili, sisusa unyaka wonke ".



4. Njengakwindlela edlulileyo, kufuneka sibonise unyaka kwiphaneli yokulungelelanisa ethe tyaba. Cofa kwindawo yokwakha kunye noluhlu lwesenzo, khetha ukhetho "Khetha idatha ...".



5. Kwifestile entsha, wenza iqhosha "utshintsho" kwi "Sigin" ibhloko ye-axis ethe tyaba.



6. Kwifestile elandelayo, ivelisa izenzo ezifanayo ezichazwe ngokweenkcukacha kwimeko yangaphambili, sazisa ngokunxibelelanisa konyaka ikholamu ukuya kwindawo yoluhlu lwe-Axis Trans. Cofa kwi "Kulungile".



7. Xa ubuyela kwifestile yangaphambili, nawe wenza iqhosha "Kulungile".



8. Ngoku kufuneka sisombulule ingxaki apho bengakhange bafezekise kwiimeko zangaphambili zokwakha, oko kukuthi, ingxaki yokungahambelani kweeyunithi zamaxabiso. Emva kwayo yonke loo nto, uya kuvumelana, abanakubekwa kwiphaneli yecandelo elinye, ekwakhetha inani lemali (i-ruble ye-ruble) kunye nobunzima (iitoni). Ukusombulula le ngxaki, kuya kufuneka sakhe i-axis eyongezelelweyo ye-axis yolungelelaniso.

   Kwimeko yethu, ukuchaza ingeniso, sizakushiya i-axis ethe nkqo esele ikho, kwaye kwi-"mboleko" yentengiso "iya kudala. Udongwe kule mgca gca kwiqhosha le mouse kwaye ukhethe kuluhlu "Ifomati yenani ledatha ...".



9. Inani lefestile yedatha isunguliwe. Kufuneka sifudukele kwicandelo "leParameter", ukuba ivuliwe kwelinye icandelo. Kwicala lasekunene lefestile kukho ibhloko "ukwakha umqolo". Kuya kufuneka ufake i-switch kwisikhundla "nge-axilist axis". Udongwe ngegama "Vala".



10. Emva koko, kuya kwakhiwa i-axis ethengisayo, kwaye umgca wentengiso uya kuphinda ahlaziyeke kulungelelaniso lwayo. Ke, sebenza ngomsebenzi ugqityiwe ngempumelelo.

Indlela 4: Ukwenza igrafu yokuxhomekeka esekwe kumsebenzi we-algebrac

Ngoku masiqwalasele ukhetho lokwakha ishedyuli yokuxhomekeka eya kusetshwa ngumsebenzi we-algebraic.

Sinomsebenzi olandelayo: y = 3x ^ 2 + 2X-15. Ngenxa yoko, kuyimfuneko ukwakha igrafu yokuxhomekeka kweenqobo ze-Y kwi-X.

1. Ngaphambi kokuqhubeka nokwakha umzobo, kuya kufuneka senze itafile esekwe kumsebenzi othile. Ixabiso lengxoxo (x) kwitafile yethu liya kudweliswa kuluhlu ukusuka kwi-1,5 ukuya kwi-+3 ukuya kwiNqanaba 3. Ukukhawulezisa isixhobo seNgeniso "

   Sibonisa kwisisele sokuqala sekholamu "X" Ixabiso "-15" kwaye labela. Kwi-theb "yekhaya", udongwe kwiqhosha "Landisa" kwiCandelo lokuHlela. Kuluhlu, khetha "ukuqhubela phambili ..." ukhetho.



2. Ukusebenza kwefestile "yokuqhubela phambili" yenziwa. Kwi "Indawo" ibhloko, phawula igama "kwikholamu", kuba kufuneka sigcwalise ikholamu. Kwiqela elithi "Chwetheza", shiya ixabiso "le-arithmetic", elimiselwe ngokungagqibekanga. Kwindawo "yenqanaba", setha ixabiso "3". Kumda wokuxabiseka, sibeke inani "30". Yenza i-cock kwi "Kulungile".



3. Emva kokwenza le algorithm yesenzo, yonke ikholamu "" X "iya kuzaliswa yimilinganiselo ngokungqinelana neskimu esichaziweyo.



4. Ngoku kufuneka sisete amaxabiso e-y esinokuqokelela amaxabiso athile e-X. Ke, sikhumbula ukuba sinayo ifomula y = 3x ^ 2x-15. Kuyimfuneko ukuguqula kwifomula ye-Excel, apho amaxabiso ane-X aya kutshintshwa zizingqinisiso zetafile ezineepropathi ezihambelana nempikiswano ehambelana nayo.

   Khetha iseli yokuqala kwikholamu ye "Y". Ukujonga oko kwimeko yethu, idilesi yengxoxo yokuqala X imelwe yi-A2 yokulungelelanisa, ke endaweni yefomula ingentla, sifumana ibinzana elinje:

   = 3 * (A2 ^ 2) + 2 * A2-15

   Sibhala le ntetho kwisisele sokuqala sekholam yokuqala "y". Ukufumana isiphumo sokubala, cofa iqhosha le-ENTER.



5. Iziphumo zomsebenzi wengxoxo yokuqala yefomula yenziwa. Kodwa kufuneka ukubala amaxabiso ayo kwezinye iimpikiswano zetafile. Ngenisa ifomula yexabiso ngalinye y Umsebenzi omde kakhulu kwaye udanile. Ikhawuleza kakhulu kwaye kulula ukuyikopa. Lo msebenzi unokusonjululwa usebenzisa uphawu lokuzalisa kunye nombulelo kule ndawo yokubhekiswa kwi-Excel, njengoLungelelo lwabo. Xa kutsala ifomula kwenye i-Rangs y, amaxabiso e-X axabiseke ngokuzenzekelayo aya kutshintsha ngokuzenzekelayo ulungelelwaniso.

   Siphethe isikhombisi kumda osezantsi womda wendawo apho iFomula ibirekhodiwe ngaphambili. Kwangelo xesha, utshintsho kufuneka lwenzeke kwisikhombisi. Iya kuba yintsika emnyama ephethe igama lommakishi wokugcwalisa. Cofa iqhosha lemouse lasekhohlo kwaye uthathe lo mphawu ukuya kwimida engezantsi yetafile kwikholam ye "y".



6. Esi senzo singentla sikhokelele kwinto yokuba ikholam ye "Y" yagcwaliswa ngokupheleleyo ngeziphumo zokubala ifomula y = 3x ^ 2 + 2X-15.



7. Ngoku lixesha lokuba sakhele ngqo umzobo ngokwayo. Khetha yonke idatha yecala. Kwakhona kwi "Faka" ithebhu, cinezela "itshathi" yeQela "yeQela". Kule meko, masikhethe kuluhlu lweendlela zokhetho "ishedyuli kunye nabamakishi".



8. Itshathi kunye nabamakishi baya kuboniswa kwindawo yokwakha. Kodwa, njengakwimeko esandulelayo, kuya kufuneka senze utshintsho ukuze ifumane ukujonga ngokuchanekileyo.



9. Okokuqala, sicima umgca "X", obekwe ngokuthe tye kumanqaku alungelelaniso. Sabela le nto kwaye ucofe iqhosha le-Cima.



10. Asifuni nentsomi, kuba sinomgca omnye ("y"). Ke ngoko, sibalaselisa imbali kwaye sicinezele iqhosha lokucima kwakhona.



11. Ngoku kufuneka sitshintshwe kwiphaneli enamacala athe tyaba ukuya kwikholam ye "X" kwitafile.

    Iqhosha leqhosha lasekunene liqaqambisa umgca womzobo. Hambisa i "Khetha idatha ..." kwimenyu.



12. Kwifestile evunyiweyo yebhokisi yokhetho esebenzayo, iqhosha "lokutshintsha" sele lisiqhelekile kuthi, elikwisiginitsha ye-axis ethe tyaba ".



13. Ifestile "Axis I-Window isunguliwe. Kwindawo yoluhlu lweesayini ze-Axis, sibonisa ukuba uluhlu lunemida yedatha "x". Sibeka isikhombisi kumhlaba wecandelo, emva koko, sivelise inkqutyana efunekayo kwiqhosha lasekhohlo le mouse, khetha onke amaxabiso etafile, ngaphandle kwegama kuphela. Nje ukuba izinxibelelanisi ziboniswe ebaleni, udongwe egameni "Kulungile".



14. Ukubuyela kwi-windows yokukhetha idatha, udongwe kwiqhosha "Kulungile" kuyo, njengaphambi kokuba benze ngefestile yangaphambili.



15. Emva koko, le nkqubo iya kuhlela itshathi eyakhiwe ngaphambili ngokotshintsho enziweyo kwizicwangciso. Igrafu yokuxhomekeka kwisiseko somsebenzi we-algebracic inokuqwalaselwa ekugqibeleni.

Isifundo: Ungayenza njani i-autogram kwiMicrosoft Excel

Njengoko ubona, usebenzisa inkqubo ye-Excel, inkqubo yokwakha isangqa inzulu ilungiselelwe ngokuthelekisa indalo ephepheni. Iziphumo zokwakha zinokusetyenziswa zombini kumsebenzi woqeqesho kwaye ngqo kwiinjongo ezisebenzayo. Umzobo othile uxhomekeke kwinto esekwe kumzobo: amaxabiso etafile okanye umsebenzi. Kwicala lesibini, ngaphambi kokwakha umzobo, kuya kufuneka wenze itafile ngengxoxo kunye nexabiso lemisebenzi. Ukongeza, ishedyuli inokwakhiwa njengoko kusekwe emsebenzini omnye kwaye ezininzi.