Simudziwa kumanga tchati mu Excel

Ngati mukukumana ndi funso lakuti "Mungamange bwanji chithunzi mu Excel?", Ndiye nkhaniyi ndiyomwe mukufuna.

Pojambula pa Excel, komanso kumanga mitundu yonse ya ma grafu (mwachitsanzo, histograms), mayankho a Mtumiki wa Tchati.

Kotero, tiyeni tiyambe.

1. Tsegulani chikalata cha MS Office Excel. Yambani - Mapulogalamu onse - Microsoft Office - Microsoft Office Excel.

2. Yambitsani Wizard kuti mumange zithunzi zonse. Pamwamba pamsana, khetha "Insert", ndiye - Tchati.

3. Mdiresi wa tchati amayamba. Kuti mutsirize ntchito yake, muyenera kumaliza njira zinayi:

1) Sankhani mtundu wa tchati chamtsogolo. Mitundu khumi ndi inayi ikupezeka kumanga: petal, histogram, cylindrical, ulamuliro, bubble, graph, circular, dotted, ndi malo, annular, pamwamba, stock, conical, pyramidal. Komanso, posankha mtundu pamene mutembenukira ku tabu la "Mwambo", mungasankhe chithunzi chosati choyimira . Zambiri ...

2) Sankhani kuchuluka kwa deta. Ngati mupita patsogolo, i.e. Musanayambe wizard, munasankha zofunikira pazithunzi zamtsogolo, ndiye mundawo udzadzazidwa mosavuta, mwinamwake - mungosankha deta yanu mu gawo lachiwiri la Charting Wizard. Mu tabu ya "Row", mukhoza kufotokoza mayina a ziphaso kapena zida za bulletti.

3) sankhani mapangidwe a tchati. Ichi si chinthu choyenera, koma ndi chofunikira pa kudzaza kwathunthu. Popanda izo, chithunzichi chidzamangidwa, koma ngati mukufunabe momwe mungapangire chithunzi molondola mu Excel, ndiye kuti muyenera kuikwanitsa. Tsamba la "Mutu" limapereka mpata wotchula tchati chamtsogolo, komanso nkhwangwa zake. Tsambali la "Axis" likufunika kusankha mtundu wa zizindikiro za axes. Gawo la "Grid Lines" likukuthandizani kuti musonyeze kapena kusasonyeza mizere yeniyeni ndi yamkatiyi yomanga pa graph. Gawo lakuti "Lembali: Kusankha malo a nthano (kufotokozera za makhalidwe): Ma tebulo a data" amatha kuwonetsera deta yomwe grayi inakonzedwa bwino kumalo omangako. Tsamba la "Masayina a Deta" limakulolani kuti mulembe chizindikiro chilichonse chachitsulo ndi kusankha chisankho chokhazikika pakati pa miyezo.

4) Sankhani malo a tchati. Ngati, mwachitsanzo, mukufuna kudziwa momwe mungapangire histogram mu Excel pa pepala lapadera, sankhani chinthu "Chokha" ndikufotokozera dzina la tsamba latsopano. Zachitika!

Mayendedwe anai awa ndi yankho losavuta kwa funso lovuta kwambiri la momwe mungamangire chithunzi mu Excel.

Tsopano tiyeni tiyang'ane pa funso la kukonza kapena kupanga maonekedwe.

Pamaso panu chithunzi. Tiyerekeze kuti mukufunikira kusintha maonekedwe ake pang'ono. Kodi mungakonze bwanji chithunzi mu Excel ndi chilembo chazithunzi cha italic?

Yankho: dinani pang'onopang'ono pa batani lamanzere pamphindi pazithunzi. Ndichitachi, mutsegula mawindo a "Chigawo Chamawonekedwe", pomwe simungasinthe ndondomeko yomwe amagwiritsidwa ntchito kumalo omangako, komanso sankhani chimango ndi mtundu wosinthika, mtundu ndi makulidwe, ndipo yonjezerani chithunzi pamthunzi.

Pogwiritsa ntchito kawiri pa chithunzichi, mutsegula mawindo a "Fomu la kumanga" kumene mungasinthe malingaliro a chithunzicho.

Dinani kawiri pazitsulo za gridiyi zidzachititsa "Grid Lines Format". Pano, maonekedwe a mizere (mtundu, mtundu, makulidwe) angakhudzidwe, komanso kukula kwake. Pa tabu la "Scale", mukhoza kuyika mtengo wogawidwa, mtengo wa magawo awiri, magawo osachepera ndi apamwamba, ndi zina.

Ngati funso lanu likumveka bwino, mwachitsanzo: "Momwe mungapangire zithunzi mu Excel 2010?", Yankho lake lidzasiyana ndi nkhaniyi kokha mu MS Office Excel, mdiresi wojambulayo akutchedwa ndi batani lapadera pa toolbar. Zochita zina zonse zidzachitidwa molingana ndi ndondomekoyi.

Chithunzi sichimangidwe nthawi zonse. Onani Excel ndiwone nokha. Bwino!