Akwazi ukuba kwakhiwe indlela itshati e-Excel

Ukuba ujamelene umbuzo othi "Indlela ukwakha itshati e-Excel?», Koko eli nqaku kanye le nto uyifunayo.

Kuba ukwakhiwa iitshati ukuya Excel, kwakunye nokwakhiwa zonke iintlobo leetshathi (umzekelo, histograms), sihlangene Wizard Chart.

Makhe siqale.

1. Vula uxwebhu MS Office Excel. Qala - Zonke Iinkqubo - Microsoft Office - Microsoft Office Excel.

2. Run Master ukwakhiwa zonke iigrafu. Kwi toolbar top, khetha i "Faka", emva koko - kwiSazobe.

3. Chart Wizard iyasebenza. Ukugqibezela umsebenzi wayo amanyathelo amane kufuneka senziwe:

1) Khetha uhlobo yomzobo elizayo. Ukulungisa i ekhoyo iintlobo ezilishumi elinesine apata, ngumbala osetyenziselwa ukuzoba, zezindlu, abalawula, iqamza, igrafu, setyhula, uphosa, kunye neendawo, thunzi, exchange umphezulu, etsobhileyo, pyramidal. Ngenxa yoko, le lokukhetha uhlobo inguqu kwi tab "Custom" uyakwazi ukukhetha engekho semgangathweni iintlobo ngeetshathi. Okunye ...

2) Ukukhetha le uluhlu lweenkcukacha. Ukuba phambili, ie phambi kokusebenza wizard khetha uluhlu ezinqwenelekayo nemizobo elizayo, ngoko ke intsimi iya kuzaliswa ngokuzenzekelayo, ngenye indlela - khetha nje uluhlu data kwi Inqanaba lesibini iwizard yatshati. Kwi sithuba 'inani' banikwa ithuba lokubuza amagama nezamazembe okanye amaxabiso itshathi enombhalo.

3) Ukukhetha i parameters itshathi. Olu kufuneka, kodwa kuyanqweneleka ukugcwalisa ngokupheleleyo. Ngaphandle kwalo, itshati uya kwakhiwa; kodwa ukuba uqhubeka emangele yokwakha ngayo itshathi e Excel ngokuchanekileyo, oko kuyimfuneko ukugcwalisa kwi ubuninzi. Tab "zamaphephandaba" inika ithuba ukunika igama itshathi elizayo kunye layo nangeempahla ezibukhali zesinyithi. Lwesithuba "axis" kuyafuneka ukuba ukhethe uhlobo iilebhile axis. Jonga "Grid Lines" ikuvumela ukubonisa okanye hayi ukubonisa igrafu zokwakha ezingundoqo kunye neziphakathi line. I "Legend. Ukhetho Indawo legend (amaxabiso ingcaciso). Tables Data" ikuvumela ukubonisa data, leyo iyelenqe ngqo ekwakhiweni kwayo. I-tab "Labels Data" ekuvumela ukuba ungene elimakishayo nganye graphic kunye nokukhethwa njengomahluli lula phakathi kwamaxabiso.

4) Ukukhetha indawo yemizobo. Umzekelo, ukuba unomdla ukwakha indlela ngumbala osetyenziselwa ukuzoba kwi Excel kwiphepha elahlukileyo, uze ukhethe "Special" kwaye ucacise igama kwiphepha elitsha. Kwenziwe!

La manyathelo mane ukubabona ukuphendula akukho mbuzo kunzima kangaka ukwakha indlela kwitshati e-Excel.

Ngoku makhe ukujamelana umbuzo wokuhlola okanye ufomato kubangela.

Nantsi umzobo. Masithi kufuneka encinane kakhulu ukutshintsha inkangeleko yakhe. Indlela ukwakha itshati e-Excel kunye amavo Italic?

Impendulo: nje ezimbalwa amaxesha, nqakraza i ekhohlo iqhosha le mouse kwi imvelaphi kokwakhiwa imifanekiso. Ngesi senzo ukubiza i window "yokuFomatha Chart Wall", apho awukwazi ukutshintsha kuphela bomgca osetyenziswayo kummandla yokwakha, kodwa ukuba azikhethele isakhelo yakhe uhlobo umgca adjustable, umbala kunye balo babulingana nesandla, makongeze nempembelelo ukwehla isithunzi kwisakhelo.

Kabini nqakraza kwi mouse kwi itshati ngokwayo, uvula i window "yokuFomatha Plot Area", apho kanye kwakhona ukutshintsha imbonakalo yesakhelo.

nqakraza kabini ngokucacileyo kwi kwimigca enqamlezeneyo uya kunokubangela i "imigca yegrid Format". lunokuxhomekeka ukutshintsha imigca (uhlobo, umbala, ubukhulu), kunye nezinga apho. On the "Lungisa" zingacwangciswa kwizahlulo, ixabiso lomahluko esiphakathi, amaxabiso asezantsi kunye eliphezulu, kwakunye nezinye iparameters.

Ukuba umbuzo wakho ngqo, umzekelo, "Indlela yokwenza ekunikeni e-Excel 2010", impendulo iya kwahluka kweli nqaku, kuphela into yokuba i-MS Office Excel Chart Wizard kuthiwa iqhosha eyahlukileyo kwi toolbar Standard. Zonke ezinye izenzo ziya kuqhutywa ngokungqinelana algorithm ngasentla.

Chart - oku akusoloko nzima zokwakha. Jonga Excel uze uzibonele ngokwakho. ithamsanqa!