Ungayenza kanjani igrafu ku-Excel

Isheduli ikuvumela ukuba uhlole ngokuthembela kwedatha kusuka kwizinkomba ezithile noma ama-Dynamics abo. Lezi zinto zisetshenziswa emsebenzini wesayensi noma yocwaningo, nasezintlelweni. Ake sibheke ukuthi ungakha kanjani igrafu ku-Microsoft Excel.

Ukwakha amagrafu ku-Excel

Umsebenzisi ngamunye, afisa ukukhombisa ngokucacile noma yiluphi ulwazi lwezinombolo ngohlobo lwezikhulumi, angakha uhlelo. Le nqubo ilula futhi isho khona ubukhona bethebula elizosetshenziselwa database. Ngokubona kwayo, into ingashintshwa ukuze ibukeke kangcono futhi iphendule zonke izidingo. Sizohlaziya ukuthi singazakha kanjani izinhlobo ezahlukahlukene zamagrafu ku-Excel.

Ukwakha uhlelo olujwayelekile

Ungadweba uhlelo ku-Excel kuphela ngemuva kokuthi ithebula lilungele idatha ngesisekelo lapho izokwakhiwa khona.

1. Ukuba kuthebhu ethi "Insert", yabela indawo yetafula lapho idatha ebaliwe esifuna ukuyibona eshadini. Ngemuva kwalokho ethepheni ku-Ithuluzi le- "Diagraph" Block block ngokuchofoza inkinobho ethi "Isheduli".
2. Ngemuva kwalokho, kukhona uhlu lapho kumelwe izinhlobo eziyisikhombisa zamagrafu:
   • Ejwayelekile;
   • Ngokuqongelela;
   • Indilinga ngokuqongelela;
   • Nabamaka;
   • Ngamamaki nokuqongelela;
   • Ejwayelekile ngezimpawu nokuqongelela;
   • Ivolumu.

   Khetha eyodwa ukuthi umbono wakho ulungele kakhulu izinhloso ezithile zokwakhiwa kwalo.



3. Ngaphezu kwalokho i-Excel yenza ngokuqondile ukwakha uhlelo.

Ukuhlela Ihluzo

Ngemuva kokwakha igrafu, ungayenza ukuyihlela ukunikeza into uhlobo olubonakalayo futhi yenza lula ukuqonda kwezinto eziboniswayo.

1. Ukusayina isheduli, iya kuthebhu ethi "Layout" yomthamo womsebenzi namashadi. Chofoza inkinobho ku-Ribbon enegama elithi "isihloko seshadi". Kuluhlu oluvula, sicacisa ukuthi kuzotholakala kuphi igama: enkabeni noma ngaphezulu kohlelo. Inketho yesibili imvamisa kufanelekile, ngakho-ke sisebenzisa "ngaphezulu komdwebo" njengesibonelo. Ngenxa yalokhu, igama liyavela, elingashintshwa noma lihlelwe ngokubona kwalo, ngokumane lichofoze kulo bese lifaka izinhlamvu ozifunayo kwikhibhodi.



2. Ungacacisa igama lezimbazo ngokuchofoza inkinobho ethi "Axis Name". Ohlwini olwehliswayo, khetha into ethi "Igama le-Axis Expontal ephakeme", bese uya endaweni ethi "Igama Ngaphansi Kwe-Axis".



3. Ngaphansi kwe-axis kukhona ifomu legama umuntu angasebenza kulo ngokubona kwalo.



4. Ngokufanayo, sisayina i-eksisi emile. Chofoza inkinobho ethi "Igama le-Axis Axis", kepha kumenyu evela, khetha "igama le-axis eyinhloko eqonde phezulu". Uhlu lwezinketho ezintathu zendawo yeziginesha ezizovulwa: ukuguqulwa, okuthe mpo, okuvundlile. Kungcono ukusebenzisa igama elijikelezayo, njengoba kuleli cala indawo igcinwa ephepheni.



5. Eshidini eduze kwe-eksisi ehambisanayo, inkambu ivela lapho ungafaka khona igama elifanele kakhulu ngomongo wedatha etholakala.



6. Uma ucabanga ukuthi ukuqonda uhlelo lwenganekwane aludingeki futhi kwenzeka kuphela, ungakususa. Chofoza inkinobho ye-Legend, etholakala ethepheni, bese ngokukhethwa kukho "Cha". Ngokushesha, ungakhetha noma yisiphi isikhundla se-legend, uma ungawususi, kepha shintsha kuphela indawo.

Ukwakha Isheduli Nge-Axle Engasizi

Kunezimo lapho udinga ukubeka amagrafu amaningana endizeni efanayo. Uma zinezindlela ezifanayo ze-Calculator, lokhu kwenziwa ngendlela efanayo njengoba kuchaziwe ngenhla. Kepha kuthiwani uma kunezinyathelo ezihlukile?

1. Ukuba sethebhu ethi "Insert", njengoba okokugcina, qokomisa amanani etafula. Okulandelayo, sichofoza inkinobho ethi "Sheduli" bese ukhetha inketho efanelekayo kakhulu.



2. Njengoba sibona, kwakhiwa imidwebo emibili. Ukuze ubonise igama elifanele lamayunithi wokulinganisa ohlelweni ngalunye, uchofoza inkinobho yegundane efanelekile lapho esizongeza khona i-axis eyengeziwe. Kumenyu evela, chaza into "ifomethi yedatha yedatha".



3. Kuthulwa iwindi ledatha yedatha yedatha. Esigabeni sayo "amapharamitha roll", okufanele avule ngokuzenzakalelayo, ahlele kabusha inkinobho ethi "AUxilial axis". Chofoza inkinobho ethi "Vala".



4. Kwakhiwa i-eksisi entsha, futhi uhlelo luzohlelela kabusha.



5. Kumele nje sisayine i-eksisi negama legrafu kwi-algorithm efana nesibonelo esedlule. Uma kukhona amagrafu athile, inganekwane ingcono ukungahlanzeki.

Ukwakhiwa kwehluzo zomsebenzi

Manje ake sithole ukuthi singakha kanjani ishadi emsebenzini onikezwe.

1. Ake sithi sinomsebenzi y = x ^ 2-2. Isinyathelo sizolingana no-2. Siqala ukwakha itafula. Kwesobunxele, gcwalisa inani le-X ngesinyathelo 2, okungukuthi, 2, 4, 6, 8, 10, njll. Engxenyeni efanele sishayela ifomula.



2. Okulandelayo, siletha isikhombisi ekhoneni elingezansi kwesokudla sengqamuzana, chofoza inkinobho yegundane kwesobunxele bese "welula" ezansi kwetafula, ngaleyo ndlela ulikopishe ifomula kwamanye amaseli.



3. Bese uye kuthebhu ethi "Faka". Khetha idatha yethebhulethi bese uqhafaza inkinobho ethi "Point Diagram" ethepheni. Kusuka kuhlu olwethuliwe wemidwebo, khetha iphuzu ngama-curves abushelelezi kanye namamaki, njengoba lolu hlobo lufaneleke kakhulu ukwakha.



4. Ihluzo zomsebenzi zisuselwa ku.



5. Ngemuva kokuthi le nto yakhiwe, ungasusa i-legend futhi wenze ezinye izindlela ezibonakalayo esezidingide ngenhla.

Njengoba ukwazi ukubona, iMicrosoft Excel inikeza amandla okwakha izinhlobo ezahlukahlukene zamagrafu. Isimo esiyinhloko salokhu ukudalwa kwetafula elinedatha. Ishedyuli edaliwe ingashintshwa futhi ilungiswe ngokwenhloso okuhlosiwe.