Zamkatimu
Mu Microsoft Office Excel, mutha kupanga tchati mwachangu pamndandanda wamatebulo ophatikizidwa kuti muwonetse mawonekedwe ake akulu. Ndichizoloŵezi chowonjezera nthano pachithunzichi kuti muwonetsere zomwe zafotokozedwapo, kuwapatsa mayina. Nkhaniyi ifotokoza njira zowonjezerera nthano ku tchati mu Excel 2010.
Momwe mungapangire tchati mu Excel kuchokera patebulo
Choyamba muyenera kumvetsetsa momwe chithunzicho chimapangidwira pulogalamu yomwe ikufunsidwa. Kamangidwe kake kagawidwa m'magawo awa:
- Patsamba loyambira, sankhani ma cell omwe mukufuna, magawo omwe mukufuna kuwonetsa kudalira kwake.
- Pitani ku tabu ya "Insert" yomwe ili pamwamba pazida za menyu yayikulu ya pulogalamuyi.
- Mu chipika cha "Diagrams", dinani chimodzi mwazosankha zowonetsera gululo. Mwachitsanzo, mutha kusankha tchati cha pie kapena tchati cha bar.
- Mukamaliza sitepe yapitayi, zenera lokhala ndi tchati lopangidwa liyenera kuwonekera pafupi ndi mbale yoyambirira patsamba la Excel. Iwonetsa mgwirizano pakati pa zikhalidwe zomwe zasankhidwa pamndandanda. Chifukwa chake wogwiritsa ntchito azitha kuyang'ana mowoneka kusiyana kwa zikhalidwe, kusanthula graph ndikumaliza.
Tcherani khutu! Poyamba, tchati "chopanda kanthu" chidzamangidwa popanda nthano, chizindikiro cha data, ndi nthano. Izi zitha kuwonjezeredwa ku tchati ngati mukufuna.
Momwe mungawonjezere nthano ku tchati mu Excel 2010 mwanjira yokhazikika
Iyi ndi njira yosavuta yowonjezerera nthano ndipo sizingatengere wogwiritsa ntchito nthawi yayitali kuti akwaniritse. Chinsinsi cha njira ndikuchita izi:
- Mangani chithunzi molingana ndi dongosolo lomwe lili pamwambapa.
- Ndi batani lakumanzere la mbewa, dinani chizindikiro chobiriwira chomwe chili pazida zomwe zili kumanja kwa tchati.
- Pazenera lazomwe zilipo zomwe zimatsegulidwa, pafupi ndi mzere wa "Legend", fufuzani bokosi kuti mutsegule ntchitoyi.
- Unikani tchati. Zolemba za zinthu zochokera patebulo loyambirira ziyenera kuwonjezeredwa pamenepo.
- Ngati ndi kotheka, mukhoza kusintha malo a graph. Kuti muchite izi, dinani kumanzere pa nthanoyo ndikusankha njira ina yamalo ake. Mwachitsanzo, Kumanzere, Pansi, Pamwamba, Kumanja, kapena Pamwamba Kumanzere.
Momwe mungasinthire zolemba za nthano pa tchati mu Excel 2010
Mawu a nthano amatha kusinthidwa ngati angafune pokhazikitsa font yoyenera ndi kukula kwake. Mutha kuchita izi potsatira malangizo omwe ali pansipa:
- Pangani tchati ndikuwonjezera nthano molingana ndi algorithm yomwe takambirana pamwambapa.
- Sinthani kukula, mawonekedwe a zolemba patebulo loyambirira, m'maselo omwe graphyo imapangidwira. Mukasanjikiza mawu m'magawo a tebulo, mawu omwe ali munthano yamatchati angosintha.
- Onani zotsatira.
Zofunika! Mu Microsoft Office Excel 2010, ndizovuta kupanga zolemba zanthano pa tchati chomwe. Ndikosavuta kugwiritsa ntchito njira yomwe imaganiziridwa posintha ma data a tebulo lomwe graph imamangidwa.
Momwe mungamalizire tchati
Kuphatikiza pa nthano, pali zina zambiri zomwe zingawonekere pachiwembucho. Mwachitsanzo, dzina lake. Kuti mutchule chinthu chopangidwa, muyenera kuchita motere:
- Pangani chithunzi molingana ndi mbale yoyambirira ndikusunthira ku tabu ya "Mapangidwe" pamwamba pa mndandanda waukulu wa pulogalamuyi.
- Tsamba la Zida za Chart limatsegulidwa, ndi zosankha zingapo zomwe zilipo kuti musinthe. Izi zikachitika, wogwiritsa ntchitoyo ayenera dinani batani la "Tchati".
- Pamndandanda wotsikira pansi wa zosankha, sankhani mtundu wa kuyika mutu. Ikhoza kuikidwa pakatikati ndikudutsana, kapena pamwamba pa tchati.
- Pambuyo popanga zosintha zam'mbuyomu, tchati chojambulidwa chidzawonetsa "Dzina la Tchati". Wogwiritsa azitha kusintha polemba pamanja mawu ena aliwonse kuchokera pa kiyibodi ya pakompyuta yomwe ikufanana ndi tanthauzo la mndandanda wa tebulo loyambirira.
- Ndikofunikiranso kulemba nkhwangwa pa tchati. Amasainidwa mofananamo. Mu chipika chogwirira ntchito ndi ma chart, wogwiritsa ntchito ayenera dinani batani la "Axis Names". Pamndandanda wotsikira pansi, sankhani imodzi mwa nkhwangwazo: yoyima kapena yopingasa. Kenako, pangani kusintha koyenera pazosankha zomwe mwasankha.
Zina Zowonjezera! Malinga ndi dongosolo lomwe takambirana pamwambapa, mutha kusintha tchati mu mtundu uliwonse wa MS Excel. Komabe, kutengera chaka chomwe pulogalamuyo idatulutsidwa, masitepe oyika ma chart angasiyane pang'ono.
Njira ina yosinthira Nthano ya Chart mu Excel
Mukhoza kusintha malemba omwe ali pa tchati pogwiritsa ntchito zida zomwe zili mu pulogalamuyi. Kuti muchite izi, muyenera kutsatira njira zingapo zosavuta malinga ndi algorithm:
- Ndi batani lakumanja la mbewa, dinani pa mawu ofunikira a nthano pazithunzi zomwe zidapangidwa.
- Pazenera lamtundu wa nkhaniyo, dinani mzere wa "Zosefera". Izi zidzatsegula zenera la Custom Filters.
- Dinani batani la Sankhani Data pansi pawindo.
- Pamndandanda watsopano wa "Select Data Sources", muyenera dinani batani la "Sinthani" mu block ya "Legend Elements".
- Pazenera lotsatira, m'munda wa "Row Name", lowetsani dzina lina la chinthu chomwe mwasankha kale ndikudina "Chabwino".
- Onani zotsatira.
Kutsiliza
Choncho, ntchito yomanga nthano mu Microsoft Office Excel 2010 imagawidwa m'magawo angapo, iliyonse yomwe iyenera kuphunziridwa mwatsatanetsatane. Komanso, ngati mungafune, zomwe zili patchati zitha kusinthidwa mwachangu. Malamulo oyambira ogwirira ntchito ndi ma chart mu Excel afotokozedwa pamwambapa.