Ungayakha kanjani igrafu ku-Excel

Umsebenzi owodwa ojwayelekile wezibalo ukwakha uhlelo lokuthembela. Ibonisa ukuthembela komsebenzi ngokushintsha impikiswano. Ephepheni, le nqubo ayihlali ilula ngaso sonke isikhathi. Kepha amathuluzi e-Excel, uma sizivikela kakhulu, sikuvumele wenze lo msebenzi ngokunembile nangokushesha. Ake sibheke ukuthi lokhu kungenziwa kanjani kusetshenziswa idatha yomthombo ehlukahlukene.

Inqubo yokudala yokudala

Ukuthembela kokusebenza kwengxabano kungukuncika okujwayelekile kwe-algebraic. Imvamisa, impikiswano nenani lomsebenzi lenziwa ukukhombisa izimpawu: ngokulandelana, "x" no "y". Imvamisa, kuyadingeka ukwenza isibonisi esibonakalayo sokuncika kwengxabano kanye nemisebenzi eqoshwe etafuleni, noma yethulwa njengengxenye yefomula. Masihlaziye izibonelo ezithile zokwakha igrafu (imidwebo) ngaphansi kwezimo ezahlukahlukene zenkomba.

Indlela 1: Ukwakha itafula lokuncika kwesikrini

Okokuqala, sizohlaziya ukuthi singakha kanjani igrafu ngokuya ngedatha esekelwe kuhlu lwetafula. Sisebenzisa itafula lokuncika kwendlela ehamba ngezinyawo (y) ngesikhathi (x).

1. Sigqamisa itafula bese siya kuthebhu ethi "Insert". Chofoza inkinobho ethi "Isheduli", enokwenziwa kwasendaweni eqenjini leshadi ku-Ribbon. Ukukhetha kwezinhlobo ezahlukahlukene zamagrafu ziyavuleka. Ngezinhloso zethu, khetha okulula. Itholakala kuqala ohlwini. Ubumba kukho.



2. Uhlelo lwenza umdwebo. Kepha, njengoba sibona, imigqa emibili iboniswa endaweni yokwakha, ngenkathi sidinga eyodwa kuphela: sibonisa ukuncika kwebanga ngezikhathi ezithile. Ngakho-ke, sabela inkinobho yegundane kwesobunxele ngomugqa oluhlaza okwesibhakabhaka ("isikhathi"), njengoba kungafani nomsebenzi, bese uqhafaza ukhiye wokususa.



3. Umugqa okhethiwe uzosuswa.

Empeleni, kulokhu, ukwakhiwa kohlelo lomlingiswa olula kungabhekwa kugcwaliswe. Uma ufisa, ungahlela futhi amagama eshadi, izembe, susa inganekwane futhi ukhiqize ezinye izinguquko. Lokhu kuchazwa ngemininingwane eminingi esifundweni esihlukile.

Isifundo: Ungayenza kanjani uhlelo ku-Excel

Indlela 2: Ukudala Izenzo Ngemigqa Eminingi

Isimo esiyinkimbinkimbi segrafu sokuncika yilapho ingxabano eyodwa ihambelana nemisebenzi emibili ngasikhathi sinye. Kulokhu, uzodinga ukwakha imigqa emibili. Isibonelo, thatha itafula lapho imali engenayo yebhizinisi nenzuzo yayo ipendiwe.

1. Sigqamisa lonke itafula nge-cap.



2. Njengasesimweni esedlule, sichofoza inkinobho ethi "Sheduli" esigabeni samashadi. Futhi, khetha indlela yokuqala evezwa ohlwini oluvulwa.



3. Uhlelo lukhiqiza ukwakhiwa okunemidwebo ngokuya ngemininingwane etholakele. Kepha, njengoba sibona, kulokhu, asinawo umugqa wesithathu owedlule, kodwa futhi nokwabiwa kwe-axis evundlile yezixhumanisi akuhambelani nalezo ezidingekayo.

   Susa ngokushesha umugqa owedlulele. Ungukuphela okuqondile kulo mdwebo - "unyaka." Njengasendleleni eyedlule, sigqamisa ngokuchofoza kuyo ngegundane bese uqhafaza inkinobho yokususa.



4. Umugqa ususiwe futhi kanye nalowo, njengoba ukwazi ukuqaphela, amanani asePaneli yokuxhumanisa mpo aguqulwa. Banembile ngokwengeziwe. Kepha inkinga ngokuboniswa okungalungile kwe-axis evundlile yezinsuku zokuxhumana. Ukuxazulula le nkinga, chofoza emkhakheni wokwakha inkinobho yegundane efanele. Kumenyu, kufanele uyeke ukukhetha "Khetha idatha ...".



5. Iwindi lokukhethwa komthombo liyavula. Evikini le- "axisontal axis Signature", chofoza inkinobho ethi "Shintsha".



6. Iwindi livula ngisho nangaphansi kwalokho okwedlule. Kuyo, udinga ukucacisa izixhumanisi etafuleni lalawo magugu okufanele aboniswe e-eksisi. Kuze kube manje, setha isikhombisi kwisimu sendima kuphela. Ngemuva kwalokho ngibamba inkinobho yegundane kwesobunxele bese ngikhetha konke okuqukethwe yikholomu yonyaka, ngaphandle kwegama laso. Ikheli lizothinta ngokushesha inkambu, chofoza u- "OK".



7. Ukubuyela ewindini lokukhetha umthombo wedatha, chofoza u- "Kulungile".



8. Ngemuva kwalokho, womabili amahluzo abekwe ephepheni aboniswa kahle.

Indlela 3: Ukwakhiwa kwehluzo lapho usebenzisa amayunithi ahlukahlukene wokulinganisa

Ngendlela edlule, sibheke ukwakhiwa komdwebo onemigqa eminingana endizeni efanayo, kepha yonke imisebenzi yayinezilinganiso ezifanayo zokulinganisa (izinkulungwane ama-ruble). Yini okufanele ngiyenze uma udinga ukudala uhlelo lokuxhomekeka ngokusekelwe etafuleni elilodwa, lapho amayunithi womsebenzi wokulinganisa ahlukile khona? I-Excel inokuphuma nokusuka kulesi sikhundla.

Sinetafula, eliveza idatha ngevolumu yokuthengisa komkhiqizo othile kumathani nangemali engenayo evela ekusetshenzisweni kwayo ezinkulungwaneni zama-ruble.

1. Njengasezimweni zangaphambilini, sabela yonke imininingwane yohlu lwethebula kanye ne-cap.



2. Ubumba enkombeni ethi "Isheduli". Siphinde sikhethe inketho yokuqala yokwakha kusuka ohlwini.



3. Iqoqo lezinto ezithombeni zenziwa endaweni yokwakha. Ngendlela efanayo, eyachazwa ezinguqulweni ezedlule, sisusa unyaka owedlule "unyaka".



4. Njengasendleleni edlule, kufanele sikhombise unyaka kwiphaneli yokuxhumanisa evundlile. Chofoza endaweni yokwakha kanye nohlu lwesenzo, khetha inketho "Khetha idatha ...".



5. Ewindini elisha, uchofoza inkinobho ethi "Shintsha" ku-block "yesiginesha" ye-axis evundlile.



6. Ewindini elilandelayo, ukukhiqiza izenzo ezifanayo ezichazwe ngokuningiliziwe ngendlela edlule, sethula izixhumanisi zekholomu yonyaka ukuya endaweni yohlobo lwe-Axis Signature. Chofoza ku- "Kulungile".



7. Uma ubuyela ewindini elidlule, nawe wenza ngokuchofoza inkinobho ethi "KULUNGILE".



8. Manje kufanele sixazulule inkinga lapho engakaze ihlangane khona emaqenjini ezedlule elokwakha, okungukuthi, inkinga yokungahambisani namayunithi amanani. Ngemuva kwakho konke, uzovuma, ngeke akwazi ukutholakala kwi-SAMUME ehlukanisayo ukuxhumanisa iphaneli, okwakheka kanyekanye nenani lemali (izinkulungwane ama-ruble) kanye neMisa (amathani). Ukuxazulula le nkinga, sizodinga ukwakha i-axis eyengeziwe eqondile yezixhumanisi.

   Kuthu, ukuqoka imali engenayo, sizoshiya i-eksisi emile esele ikhona, futhi nge "Volumu Yezentengiso" izokwakha i-Aixiliary. Ubumba kule nkinobho yegundane kwesokudla bese ukhetha ohlwini "ifomethi yedatha ethile ...".



9. Kuthulwa iwindi ledatha yedatha yedatha. Sidinga ukufudukela engxenyeni ethi "Parameters", uma kuvuliwe kwenye ingxenye. Ngakwesokunene sewindows kukhona ibhlokhi ethi "Yakha umugqa". Udinga ukufaka i-switch uye endaweni ethi "nge-axis ezayo". Ubumba lwegama elithi "vala".



10. Emva kwalokho, kuzokwakhiwa i-eksisi elisizayo mpo, futhi umugqa wokuthengisa uzovunyelwa kabusha kwizixhumanisi zawo. Ngakho-ke, ukusebenza emsebenzini kuqediwe ngempumelelo.

Indlela 4: Ukwakha igrafu yokuthembela ngokusekelwe emsebenzini we-algebraic

Manje ake sibheke inketho yokwakha uhlelo lokuncika oluzobekwe ngumsebenzi we-algebraic.

Sinomsebenzi olandelayo: y = 3x ^ 2 + 2x-15. Ngokuyisisekelo sayo, kuyadingeka ukwakha igrafu yokuncika kwamanani we-y kusuka ku-x.

1. Ngaphambi kokuqhubeka nokwakha umdwebo, kuzodingeka senze itafula elisuselwa emsebenzini obekiwe. Amanani wengxabano (x) etafuleni lethu azofakwa ohlwini kusuka ku-Una kusuka-ku-A5 kuya ku-30 ​​ku-Isinyathelo 3. Ukusheshisa Inqubo ye "Progression".

   Sibonisa esitokisini sokuqala sekholamu "X" inani "--15" labela. Kuthebhu "Yasekhaya", ubumba enkombeni ethi "Gcwalisa" olusendaweni yokuhlela. Kuluhlu, khetha inketho ethi "Ukuqhubeka ...".



2. Ukusebenza kwewindi le- "Progression" kwenziwa. Evikini le- "Indawo", phawula igama elithi "kumakholomu", ngoba sidinga ukugcwalisa ikholamu ngqo. Eqenjini elithi "Uhlobo", shiya inani elithi "izibalo", elisethwe ngokuzenzakalelayo. Endaweni "yesinyathelo", setha inani "3". Ngenani lomkhawulo, sibeka inombolo "30". Yenza ngokuchofoza ku- "Kulungile".



3. Ngemuva kokwenza le algorithm yesenzo, lonke ikholomu "X" izogcwaliswa ngamanani ngokuya ngesikimu esibekiwe.



4. Manje sidinga ukusetha amanani we-y azohambelana namanani athile ka-X. Ngakho-ke, siyakhumbula ukuthi sinefomula y = 3x + 2x-15. Kuyadingeka ukuyiguqula kwifomula ye-Excel, lapho amanani we-X ezothathelwa indawo yizinkomba zamaseli etafula aqukethe izimpikiswano ezihambisanayo.

   Khetha iseli lokuqala kukholamu "Y". Uma kucatshangelwa ukuthi kithi, ikheli lengxabano yokuqala X limelelwa yizixhumanisi ze-A2, khona-ke esikhundleni sefomula engenhla, sithola le nkulumo:

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

   Sibhala le nkulumo esitokisini sokuqala sekholomu "Y". Ukuthola umphumela wokubala, chofoza ukhiye we-ENTER.



5. Umphumela womsebenzi wengxabano yokuqala yefomula yakhelwe. Kepha sidinga ukubala amanani alo ezinye izimpikiswano zethebula. Faka ifomula ngenani ngalinye y umsebenzi omude kakhulu futhi onzima. Kushesha kakhulu futhi kulula ukuyikopisha. Lo msebenzi ungaxazululwa usebenzisa umaki wokugcwalisa futhi ubonge kule mpahla yezinkomba ukuze uphumelele, njengokuhlobana kwawo. Lapho ukopisha ifomula kwamanye ama-R Ranges y, amanani we-X efomula ngokuzenzakalelayo azoshintsha ngokuzenzakalelayo okuhlobene nezixhumanisi zawo eziyinhloko.

   Siphethe isikhombisi esiya emaphethelweni aphansi kwesokudla sento lapho ifomula ngaphambili yaqoshwa khona. Ngasikhathi sinye, ushintsho kufanele lwenzeke kusikhombisi. Kuzoba yisiphambano esimnyama esiphethe igama lomaki wokugcwalisa. Chofoza inkinobho yegundane kwesobunxele bese uthatha lo mbhalo emingceleni engezansi yetafula kwikholamu "Y".



6. Isenzo esingenhla saholela ekutheni ikholomu "Y" igcwele ngokuphelele imiphumela yokubalwa kwefomula y = 3x ^ 2x-15.



7. Manje sekuyisikhathi sokwakha ngqo umdwebo uqobo. Khetha yonke imininingwane ye-tabular. Futhi kuthebhu ethi "Insert", cindezela i- "Chart" Group "Chart". Kulokhu, ake sikhethe kusuka ohlwini lwezinketho "ezinamamaki".



8. Ishadi elinamamaki lizoboniswa endaweni yokwakha. Kepha, njengasemacaleni adlule, kuzodingeka senze izinguquko ezithile ukuze sithole ukubukeka okulungile.



9. Okokuqala, sisusa umugqa "x", okutholakala ngokuvundlile kuphawu lwezixhumanisi ezi-0. Sabela le nto bese sichofoza inkinobho yokususa.



10. Futhi asidingi i-legend, ngoba sinomugqa owodwa kuphela ("y"). Ngakho-ke, sigcizelela inganekwane bese sicindezela inkinobho yokususa futhi.



11. Manje kudingeka sithathelwe indawo ephanelini evundlile yokuxhumanisa kulabo abahambelana nekholomu "X" etafuleni.

    Inkinobho yegundane elifanele iqokomisa umugqa we-DIAGRAM. Hambisa "idatha Khetha ..." kumenyu.



12. Efasiteleni elicushiwe lebhokisi lokukhethwa komthombo, inkinobho ethi "Shintsha" isivele isijwayele kithi, esisesigineshani se-axis evundlile ".



13. Iwindi le- "Axis Signature" liyasungulwa. Endaweni yohlu lwamasiginesha e-axis, sibonisa ukuthi ama-array axhumanisa nedatha yekholomu ye- "X". Sibeka isikhombisi emgodini wensimu, bese sikhiqiza ukugcwala okudingekayo kwenkinobho yegundane kwesobunxele, khetha wonke amanani wekholomu ehambisanayo yetafula, ngaphandle kwegama lawo kuphela. Lapho izixhumanisi zikhonjiswa ensimini, ubumba egameni elithi "KULUNGILE".



14. Ukubuyela ewindini lokukhethwa komthombo wedatha, ubumba enkombeni ethi "KULUNGILE" kulo, njengakuqala lapho benze efasiteleni edlule.



15. Ngemuva kwalokho, uhlelo luzohlela ishadi elakhiwe ngaphambili ngokuya ngoshintsho olwenziwe kuzilungiselelo. Igrafu yokuncika ngesisekelo somsebenzi we-algebraic ingabhekwa ekugcineni isilungile.

Isifundo: Ungayenza kanjani i-autocomplete ku-Microsoft Excel

Njengoba ubona, usebenzisa uhlelo lwe-Excel, inqubo yokwakha ukusakazwa lula kakhulu uma kuqhathaniswa nokudalwa kwalo ephepheni. Umphumela wokwakha ungasetshenziswa kokubili emsebenzini wokuqeqesha futhi ngokuqondile ngezinhloso ezisebenzayo. Isimo esithile esithile sincike kulokho okusekwe kumdwebo: amanani ethebula noma umsebenzi. Endabeni yesibili, ngaphambi kokwakha umdwebo, kuzofanele udale itafula ngezimpikiswano namanani wemisebenzi. Ngaphezu kwalokho, uhlelo lungakhiwa njengoba kususelwa emsebenzini owodwa naku-SING.