Pambuyo posonkhanitsa, kukonza ndi kukonza deta, nthawi zambiri zimakhala zofunikira kuziwonetsa. Matebulo ndiabwino popereka deta mzere ndi mzere, koma tchati imatha kutulutsa moyo. Chithunzi chimapanga chithunzithunzi chomwe sichimangopereka deta, komanso ubale wawo ndi tanthauzo.
Tchati cha pie ndi muyezo wamakampani powonetsa ubale pakati pa magawo ndi zinthu zonse. Ma chart a pie amagwiritsidwa ntchito ngati pakufunika kuwonetsa momwe zidutswa za data (kapena magawo) zimathandizira pa chithunzi chachikulu. Ma chart a pie siwoyenera kuwonetsa deta yomwe imasintha pakapita nthawi. Komanso, musagwiritse ntchito tchati cha chitumbuwa kuti mufananize zomwe sizimawonjezera chiwopsezo chachikulu pamapeto.
Zotsatirazi zikuwonetsa momwe mungawonjezere tchati cha chitumbuwa pa pepala la Excel. Njira zomwe zaperekedwa zimagwira ntchito mu Excel 2007-2013. Zithunzi zimachokera ku Excel 2013 za Windows 7. Kutengera mtundu wa Excel womwe mukugwiritsa ntchito, masitepe amodzi amatha kusiyanasiyana pang'ono.
Kuyika tchati
Muchitsanzo ichi, tikufuna kuwonetsa mgwirizano pakati pa magulu osiyanasiyana a opereka omwe amatenga nawo mbali m'bungwe lachifundo, poyerekeza ndi kuchuluka kwa zopereka. Tchati cha chitumbuwa ndi chabwino kufotokoza izi. Tiyeni tiyambe ndi kufotokoza mwachidule zotsatira za gawo lililonse la zopereka.
- Sankhani mtundu kapena tebulo la data lomwe mukufuna kuwonetsa patchati. Dziwani kuti ngati tebulo lili ndi mzere Chotsatira chonse (Grand total), ndiye kuti mzerewu suyenera kusankhidwa, apo ayi udzawonetsedwa ngati gawo limodzi la tchati cha pie.
- Pa Advanced tabu Ikani (Ikani) mu gawo Zithunzi (Matchati) dinani chizindikiro cha tchati. Pali ma chart angapo okhazikika omwe mungasankhe. Mukayang'ana pa ma chart omwe aperekedwa, chithunzithunzi chidzayatsidwa. Sankhani njira yabwino kwambiri.
Mwachangu! Mu Excel 2013 kapena mitundu yatsopano, mutha kugwiritsa ntchito gawoli Zithunzi (Matchati) chida Kusanthula mwachangu (Quick Analysis), batani lomwe limawonekera pafupi ndi deta yosankhidwa. Kuphatikiza apo, mutha kugwiritsa ntchito batani Ma chart ovomerezeka (Matchati Ovomerezeka) tabu Ikani (Ikani) kuti mutsegule zokambirana Ikani tchati (Lowetsani ma chart).
★ Werengani zambiri m'nkhaniyi: → Momwe mungapangire tchati cha pie mu Excel, mafomula, chitsanzo, malangizo a sitepe ndi sitepe
Kusintha Tchati cha Pie
Chithunzicho chikayikidwa pamalo oyenera, padzakhala kufunika kowonjezera, kusintha kapena kusintha zinthu zake zosiyanasiyana. Dinani pa tchati chomwe mukufuna kusintha kuti mubweretse gulu la tabu pa Riboni Kugwira ntchito ndi ma chart (Zida zama chart) ndi mabatani osintha. Mu Excel 2013, zosankha zambiri zitha kusinthidwa pogwiritsa ntchito mabatani osintha omwe ali pafupi ndi tchati.
Pa Design tabu
- Onjezani zolemba za data, sinthani mutu wa tchati ndi nthano. Dinani Zosankha zina (Zosankha Zambiri) kuti mutsegule gulu losamalitsa ndikupeza zina zambiri.
- Yesani kusintha Mtundu wa Ma chart (Tchati kalembedwe) ndi Mitundu ya ma chart (Mitundu ya Tchati).
Pa tabu ya Format
- Sinthani ndikusintha mawonekedwe amtundu wamutu, nthano, ndi zina zambiri.
- Kokani ma chart omwe ali pawokha kupita kumalo atsopano.
- Ganizirani magawo padera:
- Kuti muchepetse gawo limodzi, ingosankhani ndikulikoka kutali ndi tchati.
- Kuti muchotse magawo onse pakati, dinani kumanja pazithunzi ndikusankha Mawonekedwe a mndandanda wa data (Format Data Series). Pagawo lomwe likuwoneka, dinani Tchati Chachitumbuwa (Pie Explosion) kuti musinthe mtunda pakati pa zidutswazo.
- Kwa tchati chamitundu itatu, mutha kusintha makulidwe, ngodya yozungulira, kuwonjezera mthunzi ndi magawo ena a tchati palokha komanso malo opangira.
Zotsatira zake sizongowonetsa chidziwitso chothandizira gulu lililonse laopereka pazifukwa za bungwe, komanso chithunzi chopangidwa mwaluso chomwe chili choyenera mabulosha, zikwangwani ndi kuyika pamasamba, kulemekeza mitundu yamakampani ndi mawonekedwe a bungwe lanu. .