Ungangeza kanjani inganekwane eshadini le-Excel 2010

Ku-Microsoft Office Excel, ungakha ngokushesha umdwebo eceleni kwe-array yetafula edonswe ukukhombisa izici zayo eziphambili. Umdwebo wenziwa ukwengeza inganekwane yokubonisa imininingwane eboniswe kuyo, ibanikeze igama. Le ndatshana ithola izindlela zokwengeza inganekwane eshadini ngo-Excel 2010.

Ungayakha kanjani ishadi elise-Excel etafuleni

Okokuqala, kuyadingeka ukuqonda ukuthi umdwebo wakhiwa kanjani ohlelweni olubhekwayo. Inqubo yokwakhiwa kwayo ihlukaniswe ngezinyathelo ngezinyathelo ezilandelayo:

1. Etafuleni lomthombo, khetha uhla olufunayo lwamaseli, amakholomu lapho ukuthembela kufanele kuboniswe khona.

Khetha uhla oludingekayo lwamaseli etafuleni ukuze wakhe ishadi

1. Iya kuthebhu ethi "Insert" kugrafu ephezulu yemenyu enkulu yohlelo.
2. Evikini le- "Diagram" block, chofoza okukodwa kokumelwa kwesithombe kwe-graphic of array. Isibonelo, ungakhetha ishadi eliyindilinga noma lebha.

Izenzo zokwakha ishadi ku-Excel 2010

1. Ngemuva kokuqeda isenzo esedlule, iwindi elinomdwebo owakhiwe kufanele livele eduze kwegama legama langempela ku-Excel. Kuzobonisa ukuthembela phakathi kwamanani athathwa njengohlu. Ngakho-ke umsebenzisi angabonga ngokucacile umehluko kumanani, ahlaziye uhlelo bese ephetha ngalo.

Ungawengeza kanjani inganekwane eshadini ku-Excel 2010 ngendlela ejwayelekile

Le yindlela elula yokungeza i-legend engathathi umsebenzisi isikhathi esiningi okufanele usisebenzise. Umnyombo wendlela ukwenza lezi zinyathelo ezilandelayo:

1. Yakha umdwebo ohlelweni olungenhla.
2. I-Bead Key Manipulator cindezela isithonjana esiluhlaza esigcawu kubha yamathuluzi ngakwesokudla kwegrafu.
3. Ewindini lezinketho ezingenhla elivula eduze kwentambo ye-Legend, faka umkhaza ukwenza umsebenzi.

Ukugoqa umkhaza eduze komugqa "inganekwane" ngokuboniswa kwayo ohlelweni lwakhiwe

1. Hlaziya umdwebo. Kufanele ingeze amasiginesha ezinto ezivela ku-Source Table Array.
2. Uma kunesidingo, ungashintsha indawo yesheduli. Ukuze wenze lokhu, chofoza i-LKM ku-Legend bese ukhetha enye indlela yendawo yayo. Isibonelo, "ngakwesobunxele", "phansi", "Phezulu", "kwesokudla" noma "ngaphezulu kwesobunxele".

Ukushintsha indawo yomdwebo ebhlokini efasiteleni elifanele

Ungawuguqula kanjani umbhalo wenganekwane eshadini ku-Excel 2010

Ukusatshalaliswa kwenganekwane, uma kufiswa, kungashintshwa ngokubeka ifonti nosayizi ofanele. Ungenza lo msebenzi ngokuya ngemiyalo elandelayo:

1. Yakha umdwebo bese wengeza inganekwane kuyo ku-algorithm okuxoxwe ngayo ngenhla.
2. Shintsha usayizi, umthumeli wefonti ku-Source Table ARAY, kumaseli lapho uhlelo lwakhiwe ngalo. Lapho ufometha umbhalo kumakholomu etafula, umbhalo ngendlela yenganekwane yeshadi uzoshintsha ngokuzenzakalelayo.
3. Bheka umphumela.

Ungawagcwalisa kanjani ishadi

Ngaphezu kwenganekwane, kunemininingwane eminingi eminingana engabonakala ohlelweni elakhiwe. Isibonelo, igama laso. Ukuqamba into eyakhelwe, kuyadingeka ukwenza okulandelayo:

1. Yakha umdwebo epuletini yomthombo bese uhambisa kuthebhu ethi "Layout" ngaphezulu kwemenyu yohlelo main.
2. Indawo yokusebenza enemidwebo izovulwa, lapho amapharamitha ambalwa atholakala khona ukuze ashintshe. Kulesi simo, umsebenzisi kufanele achofoze inkinobho ethi "Diagram isihloko".
3. Uhlu olunwetshiwe lokukhethwa kukho, khetha uhlobo lohlobo lwendawo. Ingabekwa esikhungweni ngokugqashuka, noma ngaphezulu kwesheduli.

Ukungeza izihloko eshadini ku-Microsoft Office Excel

1. Ngemuva kokwenza okukhohlisayo kwangaphambilini, umdwebo wombhalo "uvela kwigrafu eyakhelwe. Umsebenzisi wayo uzokwazi ukushintsha, enquma ngesandla kwikhibhodi yekhompyutha noma iyiphi enye inhlanganisela yamagama afanelekile kwincazelo ethemuni yetafula lomthombo.

Shintsha ungezwe egameni legama

1. Kubalulekile futhi ukusayina i-eksisi eshadini. Bayabhalisela ngendlela efanayo. Evikini lomsebenzi elinamashadi, kuzodingeka uchofoze inkinobho ethi "Axis Name". Uhlu olungenziwanga, khetha eyodwa yama-axes: kungaba mpo noma avundlile. Okulandelayo, yenza ushintsho olufanele lwenketho ekhethiwe.

Ukusayina izembe eshadini

Enye indlela yokushintsha ishadi le-legend ku-Excel

Ungahlela umbhalo wamasiginesha ohlelweni usebenzisa ithuluzi elakhelwe ohlelweni. Ukuze wenze lokhu, udinga ukwenza izinyathelo ezimbalwa ezilula ku-algorithm:

1. I-manipulator eyikhiya i-Right-Key Chofoza ku-Legend Yegama Elifisayo eshadini elakhiwe.
2. Ewindows Window Window, chofoza umugqa we- "Filters". Ngemuva kwalokho, iwindi lokuhlunga ngokwezifiso liyavula.
3. Chofoza inkinobho ethi "Khetha Idatha", etholakala ezansi kwewindi.

I-Legend Properties iwindi e-Excel

1. Kumenyu entsha "Khetha Imithombo yedatha", kufanele uchofoze ku- "Shintsha" kubhulokhi "Yengane".
2. Efasiteleni elilandelayo ensimini "yomugqa", uzobhalisa igama elihlukile lento ekhethwe ngaphambilini bese uchofoza ku- "Kulungile".

Ukubhala igama elisha lezinto zegrafu

1. Bheka umphumela.

Ukugcina

Ngakho-ke, ukwakhiwa kwenganekwane ku-Microsoft Office Excel 2010 kuhlukaniswe ngezigaba eziningana, ngasinye sazo sidinga isifundo esinemininingwane. Uma ufisa, imininingwane eshadini ingahle ihlele ngokushesha. Ngaphezulu kwemithetho eyisisekelo yokusebenza namashadi ku-Excel kwachazwa.

Umlayezo wokuthi ungangeza kanjani inganekwane eshadini le-Excel 2010 kwavela kuqala ubuchwepheshe bolwazi.