INDLELA YOKWENZA I-QUOTE KU-EXCEL

Omunye wemisebenzi ejwayelekile yemathemikhali ukwakha igrafu yokuthembela. Ibonisa ukuthembeka komsebenzi ekuguqulweni kwempikiswano. Ephepha, ukwenza le nqubo akulula ngaso sonke isikhathi. Kodwa amathuluzi we-Excel, uma aqondwe kahle, akuvumela ukuba ufeze lo msebenzi ngokunembile futhi ngokushesha. Ake sithole ukuthi lokhu kungenziwa kanjani ngokusebenzisa idatha ehlukahlukene yomthombo.

Inqubo yokudala uhlelo

Ukuxhomekeka komsebenzi ophikisanayo kuxhomeke ekuthembekeni kwe-algebraic. Ngokuvamile, impikiswano nokubaluleka komsebenzi kuvame ukuboniswa ngezimpawu: "x" no "y", ngokulandelanayo. Ngokuvamile udinga ukuveza ukubonisa okucacile kokuxhomeka kwempikiswano nomsebenzi, okulotshwe etafuleni, noma okuvezwe njengengxenye yefomula. Ake sihlaziye izibonelo ezithile zokwakha igrafu elinjalo (umdwebo) ngaphansi kwezimo ezihlukahlukene ezicacisiwe.

Indlela 1: Dala igrafu yokuxhomeka ngokusekelwe kwedatha yetafula

Okokuqala, ake sibheke indlela yokwakha igrafu yokuxhomeka ngokusekelwe kwedatha yangaphambili efakwe ohlwini lwetafula. Sebenzisa itafula lokuxhomeka kwebanga elihambayo (y) kusukela ngesikhathi (x).

Khetha ithebula bese uya kuthebhu "Faka". Chofoza inkinobho "Hlela"okuyinto ibe endaweni yangaphakathi eqenjini "Amashadi" kwi-tape. Ukukhethwa kwezinhlobo ezahlukene zamagrafu kuvulwa. Ngezinhloso zethu, sikhetha okulula. Kubekwe ohlwini lokuqala ohlwini. Siyalibethela.

Uhlelo luveza ishadi. Kodwa, njengoba sibona, imigqa emibili iboniswa endaweni yokwakhiwa, kuyilapho sidinga eyodwa kuphela: ukuxhomeka kwesikhathi kwendlela. Ngakho-ke, khetha umugqa ohlaza okwesibhakabhaka ngokuchofoza inkinobho yegundane lesokunxele ("Isikhathi"), ngoba ayihambisani nomsebenzi, bese uchofoza ukhiye Susa.

Umugqa ogqamile uzosuswa.

Eqinisweni kulokhu ukwakhiwa kwegrafu elula yokuthembela kungacatshangwa kuqedile. Uma ufisa, ungabuye uhlele igama leshadi, izinkomba zalo, ususe i-legend wenze ezinye izinguquko. Lokhu kuxoxwa ngokuningiliziwe emfundweni ehlukile.

Isifundo: Indlela yokwenza igrafu ku-Excel

Indlela 2: Dala igrafu yokuxhomeka ngemigqa eminingi

Ukuhlukahluka okunzima ngokwengeziwe kokuhlelwa kokuxhomekeka kunoma kunjalo lapho imisebenzi emibili ihambisana nengxabano eyodwa ngesikhathi esisodwa. Kulesi simo, udinga ukwakha imigqa emibili. Isibonelo, ake sithathe itafula lapho imali engenayo yebhizinisi kanye nenzuzo yayo enikezwa ngonyaka.

Khetha ithebula lonke kanye ne-header.

Njengokwesikhashana esidlule, chofoza inkinobho. "Hlela" esigabeni semidwebo. Phinda futhi, ukhethe okukhethwa kukho kokuqala okwethulwa kuhlu oluvula.

Lolu hlelo luveza ukwakhiwa kwemidwebo ngokulandela idatha etholakalayo. Kodwa, njengoba sibona, kulokhu asikho nje umugqa wesithathu owodwa, kodwa futhi izinkomba kwi-axis enezingqimba zezixhumanisi azihambisani nalabo okudingekayo, okungukuthi, umyalelo weminyaka.
Khipha ngokushesha umugqa owengeziwe. Yona kuphela umugqa oqondile kulo mdwebo - "Unyaka". Njengendlela yangaphambilini, khetha umugqa ngokuchofoza kuso ngegundane bese ucindezela inkinobho Susa.

Umugqa ususiwe futhi kanye nawo, njengoba ubona, amanani ku-bar yangaphakathi yezixhumanisi ashintshiwe. Baye banembile kakhulu. Kodwa inkinga ngokubonisa okungalungile kwe-axis enezingqimba zezixhumanisi kusalokhu. Ukuze uxazulule le nkinga, chofoza endaweni yokwakhiwa nge inkinobho yegundane kwesokudla. Emenyu kufanele ume ukukhethwa endaweni "Khetha idatha ...".

Iwindi lokukhetha umthombo ivula. Ku-block "Amasignesha we-axis enezingqimba" chofoza inkinobho "Shintsha".

Ifasitela ivula ngisho nangaphansi kweyaphambilini. Kuyo udinga ukucacisa izixhumanisi etafuleni lalezo zimiso okufanele ziboniswe kwi-axis. Ngalesi sizathu, sibeka isikhombisi ensimini kuphela yale festile. Bese sibamba inkinobho yesinxele segundane bese ukhetha konke okuqukethwe kukholomu. "Unyaka"ngaphandle kwegama layo. Ikheli liboniswa ngokushesha ensimini, chofoza "Kulungile".

Ukubuyela ewindini lokukhetha umthombo wedatha, sithinta futhi "Kulungile".

Emva kwalokho, zombili amagrafu afakwe kushidi aboniswa ngendlela efanele.

Indlela 3: ukuhlela lapho usebenzisa amayunithi ahlukene

Ngendlela eyedlule, sibheke ukwakhiwa komdwebo onemigqa eminingana endizeni efanayo, kodwa ngesikhathi esifanayo yonke imisebenzi yayinezilinganiso ezifanayo zesilinganiso (ama-ruble ayizinkulungwane). Yini okufanele uyenze uma udinga ukwakha amagrafu okuxhomeka ngokusekelwe etafuleni elilodwa okusebenza kuzo izinyunithi? E-Excel kunendlela yokuphuma kule simo.

Sinetafula lapho idatha ngevolumu yokudayiswa komkhiqizo othize ngamathani kanye nemali engenayo kusuka ekuthengisweni kwayo ezinkulungwaneni zamaRuble.

Njengamacala amandulele, sikhetha yonke idatha etafuleni ehlanganisiwe nekhanda.

Sichofoza inkinobho "Hlela". Futhi, khetha inguqulo yokuqala yokwakhiwa kohlu.

Iqoqo lezinto ezicacile lenziwa endaweni yokwakhiwa. Ngendlela efanayo echazwe ezinguqulweni zangaphambilini, sisusa umugqa owengeziwe "Unyaka".

Njengendlela yangaphambilini, kufanele sibonise unyaka kubha yokuxhumanisa enezingqimba. Chofoza endaweni yokwakhiwa futhi ohlwini lwezenzo khetha ukhetho "Khetha idatha ...".

Ewindini elisha, chofoza inkinobho. "Shintsha" ku-block "Amasignesha" i-axis enezingqimba.

Ewindini elilandelayo, ukukhiqiza izenzo ezifanayo ezichazwe ngokuningiliziwe endleleni yangaphambilini, sifaka izixhumanisi zekholomu "Unyaka" endaweni "I-Axis Signature Range". Chofoza "Kulungile".

Uma ubuyela ewindini langaphambilini, chofoza futhi inkinobho. "Kulungile".

Manje kufanele sikwazi ukuxazulula inkinga engakaze ihlangabezane namacala okwakhiwa wangaphambilini, okungukuthi, inkinga yokungahambisani phakathi kwamayunithi amaningi. Ngemuva kwakho konke, uyabona, angeke atholakale kwi-panel efanayo yezixhumanisi zesigaba, okwathi ngesikhathi esisodwa sichaza isamba semali (ama-ruble ayizinkulungwane) nobuningi (amathani). Ukuxazulula le nkinga, sidinga ukwakha i-axis eyengeziwe yezixhumanisi.
Esimweni sethu, ukubhekisela kwimali engenayo, sishiya i-axis eqondile ekhona kakade, futhi emgqeni "Ukuthengisa" yakha oyisizayo. Sichofoza kulolu umugqa ngenkinobho yegundane kwesokudla bese ukhetha ohlwini olukhethwa kukho "Ifomethi yochungechunge lwedatha ...".

Iwindi lefomethi yesigcawu sedatha iqala. Sidinga ukuthuthela esigabeni. "Ama-parameters Row"uma kuvuliwe kwesinye isigaba. Ngakwesokudla kwefasitela kuyisihlalo "Yakha umugqa". Kudinga ushintsho endaweni "Isixhumi esisizayo". I-Klaatsay ngegama "Vala".

Ngemuva kwalokho, i-axis ebonakalayo ezayo izokwakhiwa, kanye nomugqa "Ukuthengisa" ivuselelwe kabusha kwizixhumanisi zayo. Ngakho-ke, umsebenzi owenziwa kulo msebenzi ugcwaliswe ngempumelelo.

Indlela 4: Yakha igrafu yokuxhomeka ngokusekelwe emsebenzini we-algebraic

Manje ake sicabangele indlela yokwakha igrafu elisekelwe kulo elizokwenziwa umsebenzi we-algebraic.

Sinomsebenzi olandelayo: y = 3x ^ 2 + 2x-15. Ngalesi sisekelo, kufanele wakhe igrafu yamagugu y kusuka x.

Ngaphambi kokuqhubeka nokwakhiwa komdwebo, kuzodingeka sakha itafula ngokusekelwe emsebenzini ocacisiwe. Izindinganiso zempikiswano (x) etafuleni lethu ziyoba phakathi kokungu--15 kuya ku-30 ku-increments ka-3. Ukusheshisa inqubo yokufaka idatha, sizosebenzisa ithuluzi eligcwalise ngokuzenzakalela. "Ukuqhubeka".
Sichaza esitokisini sokuqala sekholomu "X" kusho "-15" bese ukhetha. Kuthebhu "Ikhaya" chofoza inkinobho "Gcwalisa"efakwe ebhodini Ukuhlela. Kuloluhlu, khetha inketho "Ukuqhubeka ...".

Ukuvuselela iwindi "Ukuqhubeka" "Indawo" uphawu igama "Ngamakholomu", ngoba sidinga ukugcwalisa ncamashi ikholomu. Eqenjini "Thayipha" shiya inani "I-Arithmetic"efakwe ngokuzenzakalelayo. Endaweni "Isinyathelo" kufanele usethe inani "3". Endaweni "Inani elilinganiselwe" ufake inombolo "30". Yenza ngokuchofoza "Kulungile".

Ngemva kokukhishwa kwalesi algorithm, ikholomu yonke "X" izogcwaliswa ngamagugu ngokuhambisana nesimiso esicacisiwe.

Manje sidinga ukusetha amanani Yehambisana namanani athile X. Ngakho khumbula ukuthi sinayo ifomula y = 3x ^ 2 + 2x-15. Kudingeka iguqulwe kwifomula ye-Excel, lapho amanani X kuzothathwa indawo yizikhombisi zamaseli etafula aqukethe izimpikiswano ezihambelanayo.
Khetha iseli lokuqala kukholomu. "Y". Uma sicabanga ukuthi kulokhu ikheli lempikiswano yokuqala X emelelwe izixhumanisi A2ke esikhundleni sendlela ekhonjisiwe ngenhla sithola inkulumo elandelayo:
= 3 * (A2 ^ 2) + 2 * A2-15
Bhala le nkulumo esitokisini sokuqala kukholomu. "Y". Ukuthola umphumela wokuchofoza ukuchofoza Ngena.

Umphumela womsebenzi wempikiswano yokuqala yefomula ibalwa. Kodwa sidinga ukubala amanani ayo kwezinye iziphakamiso zetafula. Faka ifomula yenani ngalinye Y Umsebenzi omude kakhulu futhi obabazayo. Ngokushesha kakhulu futhi kulula ukukopisha. Le nkinga ingaxazululwa ngosizo lomakaki wokugcwalisa futhi ngenxa yalokho impahla yezingcaphuno ku-Excel, njengento ehlobene ngayo. Uma ukopisha ifomula kwezinye izigaba Y amanani X kwifomula izoshintsha ngokuzenzekelayo ngokuphathelene nezixhumanisi zabo eziyinhloko.
Sibeka isikhombisi esinqenqemeni esingakwesokudla kwesici lapho ifomula ibhalwe ngaphambilini. Kulesi simo, ukuguqulwa kufanele kwenzeke nge-cursor. Kuyoba cross cross, elibizwa negama lokugcwalisa. Gwema inkinobho yesinxele segundane bese uhudulela lo maka phansi kwetafula kukholomu "Y".

Isenzo esingenhla senze ikholomu "Y" yayigcwele ngokuphelele imiphumela yefomula y = 3x ^ 2 + 2x-15.

Manje sekuyisikhathi sokwakha umdwebo ngokwayo. Khetha yonke idatha yethebula. Nakuphinde kuthebhu "Faka" cindezela inkinobho "Hlela" amaqembu "Amashadi". Kulokhu, ake sikhethe ohlwini lokukhethwa kukho "Ishadi elinamakaki".

Ishadi elinamaki liboniswa endaweni yesakhiwo. Kodwa, njengamanye amacala asedlule, kuzodingeka senze izinguquko ezithile ukuze lilungiswe.

Okokuqala susa umugqa "X"okuyinto ifakwe ngokuzenzekelayo emakethe 0 izixhumanisi. Khetha le nto bese uchofoza inkinobho. Susa.

Futhi asidingi inganekwane, ngoba sinomugqa owodwa kuphela ("Y"). Ngakho-ke, khetha i-legend bese uchofoza ukhiye Susa.

Manje sidinga ukufaka esikhundleni samagugu kuphaneli yokuxhumanisa enezingqimba nalabo abahambisana nekholomu "X" etafuleni.
Chofoza inkinobho yesokudla yegundane ukuze ukhethe ishadi lomugqa. Emenyu siyathutha ngexabiso. "Khetha idatha ...".

Ewindini lokukhetha lomthombo osebenziwe sichofoza inkinobho esazijwayele kakade. "Shintsha"esithombeni "Amasignesha we-axis enezingqimba".

Ifasitela iqala. I-Axis Signatures. Endaweni "I-Axis Signature Range" sichaza izixhumanisi zesigaba ngekholomu yedatha "X". Faka isikhombisi emkhakheni wensimu, bese-ke, ukhiqiza ukuphoqa okudingekayo kwenkinobho yegundane lesokunxele, ukhethe wonke amanani wekholomu elihambelanayo etafuleni, ngaphandle kwegama layo kuphela. Ngokushesha lapho izixhumanisi zikhonjiswa ensimini, chofoza igama "Kulungile".

Ukubuyela ewindini lokukhetha umthombo wedatha, chofoza inkinobho. "Kulungile" kuwo, njengoba ngaphambili kwenziwe efasiteleni langaphambilini.

Ngemuva kwalokho, lolu hlelo luzohlela umdwebo owakhiwe ngaphambili ngokuvumelana nezinguquko ezenziwe ezilungiselelweni. Igrafu yokuthembela ngesisekelo somsebenzi we-algebraic ingacatshangwa ekugcineni ilungile.

Isifundo: Indlela yokwenza i-autocomplete ku-Microsoft Excel

Njengoba ubona, ngosizo lwe-Excel, inqubo yokuhlela ukuxhomeka kuncike kakhulu uma kuqhathaniswa nokuyibeka ephepheni. Umphumela wokwakhiwa ungasetshenziswa kokubili emsebenzini wezemfundo kanye ngqo nezinhloso ezingokoqobo. Inguqulo ethize yokwakhiwa kuncike kulokho umdwebo kusekelwe kuwo: amanani etafula noma umsebenzi. Esikhathini sesibili, ngaphambi kokwakha ishadi, kuzodingeka udale itafula ngezimpikiswano nemigomo yokusebenza. Ngaphezu kwalokho, isimiso singakhiwa ngesisekelo somsebenzi owodwa noma eziningana.