Indlela uhlela? Ku-Excel!

Noma yimuphi inqubo ezimpilweni zethu, ngandlela-thile, ehambisana nezinombolo. Kwezokwelapha, sibona ezicwaningiwe ukudla thina ukubala inani kilojoule emisebenzini kubhekwe kunilungele nokunye.

Ngokuvamile okubonwa izinguquko ambalwa usebenzisa ihluzo. Bavumela ukuba zibukeke ukubona inqubo zezinombolo.

Ukuze charting ehhovisi elula kunazo Excel. Yakha igrafu Excel kulula. Kudinga futhi umugqa noma ukusingatha kahle noma isiphi yokubala nofana amapensela abavamile. Ngoba zonke kalula wenze PC.

Ngakho, uma ezibuza ngalokho indlela yokwakha amashadi ku-Excel, bese ubheka impendulo kulesi sihloko.

Ngaphambi indlela yokwakha igrafu Excel 2010 noma e-Excel 2003, kuzomele uvule idokhumende elingenalutho. Ngokuvamile, igama ezizenzakalelayo ifayela elingenalutho enkulu ohlelweni - "Book1".

Yenza elandelayo imiyalo:

inkinobho 'Qala' (ekhoneni ngezansi kwesokunxele qapha), uhlu oluphelele izinhlelo ifakiwe, i-Microsoft Office, i-Excel.

Umsebenzi wokuqala usuphothuliwe.

Isinyathelo esilandelayo ukudala ifomu idatha yethebula ukukhonjiswa sokuqhafaza. Yenza i-spreadsheet, kukwenza kudingeke izinkomba, isihloko kanye nemigqa.

Isinyathelo sesibili usuphothuliwe.

Manje, umbuzo wakho mayelana nendlela yokwakha amashadi ku-Excel, uyoba nomthwalo "Ishadi Iseluleki" ofuna ukumshayela kusukela yamathuluzi. Ukuze wenze lokhu, cindezela izinkinobho ezilandelayo: Faka, Ishadi ...

Iseluleki lula ukwakha iyiphi ishadi noma histogram, befuna ukusebenza izigaba ezine kuphela.

Qhubeka.

esigabeni sokuqala.

Kulokhu, ucelwa ukuba ukhethe uhlobo isheduli esizayo. A ezihlukahlukene ongakhetha iyamangalisa iphuzu, mbhoshongo, bubble, izifundazwe, Radar, njll Lolonga ikusasa ukwakhiwa kungabonwa ebhokisini efanayo lengxoxo, engxenyeni kwesokudla.

Eyesibili esiteji.

isigaba Digital lomsebenzi. Lapha udinga ukukhetha izinkomba imidvwebo esizayo. Ukuze wenze lokhu, ukhethe itafula idatha wadala ekuqaleni. Ngesikhathi esifanayo isethi esiteji imigqa amagama.

Isigaba sesithathu.

I okubanzi kokusebenza. Ngeke ukukuholela impendulo yombuzo indlela yokwakha amashadi Excel iyona ulwazi kakhulu. Ukuze ukugcwaliswa efanele udabula amathebhu.

1. Legend. It ikuvumela ukuba wengeze uchungechunge isignesha emikhawulweni ngokwakha amashadi noma, kunalokho, ukuze ususe ekhona.
2. Imigqa yegridi. It ikuvumela ukuba wengeze noma ususe Lesisemkhatsini eziyisisekelo ingcaca ilebula lokumaka ngethikhi.
3. Axis. Ikhetha uhlobo axis.
4. Izihloko. Icacisa amagama ahlangene yeshadi ngalinye.
5. Idatha Ithebula. Iyanezela noma ikhiphe itafula nezinkomba zezinombolo esekelwe okuyinto ukwakhiwa kwakhiwa endaweni ehambisana.
6. Idatha Amalebula. Ungene nge iphuzu eshadini (inombolo, isigaba, inani) ngasinye.

Isigaba sesine.

Final. It "isizukulwane wizadi" ngeke anikele kukhethwa indawo ngoba imidvwebo esizayo. Kukhethwa sizonikeza ezimbili ongakhetha ekhasini ezikhona (kanye umbhalo namathebula kwamanani) noma ekhasini ahlanzekile entsha.

Phela izinyathelo ezine umsebenzi "charting Iseluleki" igcwaliswe ngesibindi ucindezele inkinobho ka- "Qedile" bese uphendula umbuzo indlela yokwakha amashadi Excel, uyazi! Ngiyavuma ukuthi kuba lula kakhulu kunokuba kubonakala efika kuqala. Imfundiso ngaso sonke isikhathi kufanele usekelwe umkhuba. Ngakho zama! Uzophumelela.

Ngikufisela inhlahla!