Sinthani ma chart mu Excel: onjezani mutu, nkhwangwa, nthano, zilembo za data ndi zina zambiri

Kodi chinthu choyamba chomwe timaganizira titapanga tchati mu Excel ndi chiyani? Za momwe tingaperekere chithunzicho momwe tinkaganizira titayamba bizinesi!

M'mitundu yamakono ya Excel 2013 ndi 2016, kusintha ma chart ndikosavuta komanso kosavuta. Microsoft yapita kutali kwambiri kuti njira yokhazikitsira ikhale yosavuta komanso zosankha zofunika kuzifikika mosavuta. Pambuyo pake m'nkhaniyi, tikuwonetsani njira zosavuta zowonjezerera ndikusintha ma chart onse mu Excel.

• Kuwonjezera mutu wa tchati
• Kusintha makonda a ma chart
• Kuwonjezera zilembo za data
• Kuonjezera, Kuchotsa, Kusuntha, ndi Kusintha Mawonekedwe a Nthano ya Tchati
• Onetsani kapena bisani mizere ya gridi
• Sinthani kapena kubisa mndandanda wa data mu tchati
• Sinthani mtundu ndi kalembedwe ka tchati
• Sinthani mitundu yosasinthika ya tchati
• Kusinthana nkhwangwa zoima ndi zopingasa
• Sinthani tchati mu Excel kuchokera kumanzere kupita kumanja

Njira za 3 Zosinthira Zosankha Zachati mu Excel

Mukadakhala ndi mwayi wowerenga nkhani yathu yam'mbuyomu yamomwe mungapangire tchati ku Excel, ndiye kuti mukudziwa kale kuti mutha kupeza zida zoyambira m'njira zitatu:

1. Sankhani tchati ndikugwiritsa ntchito ma tabu a gulu Kugwira ntchito ndi ma chart (Zida zama chart) - Constructor (Kapangidwe) Makhalidwe (Fomati).
2. Dinani kumanja pa tchati chomwe mukufuna kusintha ndikusankha lamulo lomwe mukufuna kuchokera pamenyu yankhani.
3. Gwiritsani ntchito zithunzi zapadera zomwe zimawonekera pafupi ndi ngodya yakumanja kwa tchati mukadina ndi mbewa.

Zosankha zinanso zili pagulu Mtundu wa Ma chart (Tchati cha Format), chomwe chimawonekera kumanja kwa tsamba logwirira ntchito mukadina Zosankha zina (Zowonjezera zina) mu mndandanda wazomwe zili pachithunzichi kapena pamagulu agulu Kugwira ntchito ndi ma chart (Zida zama chart).

Tip: Kuti mutsegule gawo lomwe mukufuna la gululo kuti muyike magawo a tchati, dinani kawiri pa chinthu chofananiracho pa tchati.

Pokhala ndi chidziwitso choyambirirachi, tiyeni tiwone momwe tingasinthire zinthu zosiyanasiyana za tchati mu Excel kuti ziwonekere momwe timafunira.

Momwe mungawonjezere mutu ku tchati cha Excel

Mu gawoli, tikuwonetsani momwe mungawonjezere mutu pa tchati m'mitundu yosiyanasiyana ya Excel ndikuwonetsani komwe zida zazikulu zojambulira zili. M'nkhani yonseyi, tiwona zitsanzo za ntchito m'mitundu yatsopano kwambiri ya Excel 2013 ndi 2016.

Kuwonjezera Mutu ku Tchati mu Excel 2013 ndi Excel 2016

Mu Excel 2013 ndi Excel 2016, mukapanga tchati, mawu akuti "Mutu wa tchati“. Kuti musinthe mawuwa, ingosankhani ndikuyika dzina lanu:

Mutha kulumikizanso mutu wa tchati ku cell yomwe ili patsambalo pogwiritsa ntchito ulalo kuti mutuwo ungosinthidwa zokha zikasintha zomwe zili mu cell yolumikizidwa. Momwe mungachitire izi zafotokozedwa pansipa.

Ngati pazifukwa zina mutuwo sunawonjezedwe zokha, ndiye dinani paliponse pachithunzichi kuti mubweretse gulu la ma tabo Kugwira ntchito ndi ma chart (ChartTools). Tsegulani tabu Constructor (Design) ndikusindikiza Onjezani Chart Element (Onjezani Chart Element) > Mutu wa tchati (Tchati Mutu) > Pamwambapa tchati (Pamwambapa Tchati) kapena Pakati (kuphimba) (Kuphimba Pakati).

Kapena dinani chizindikirocho Ma chart a zinthu (Zinthu za Tchati) pafupi ndi ngodya yakumanja ya tchati ndipo chongani bokosilo Mutu wa tchati (Mutu wa Tchati).

pafupi ndi njira Mutu wa tchati (Mutu wa Tchati), mutha kudina muvi wolozera kumanja (onani chithunzi pamwambapa) ndikusankha chimodzi mwazosankha:

• Pamwambapa tchati (Pamwamba pa Tchati) - dzinali limayikidwa pamwamba pa malo opangira tchati, pamene kukula kwa tchati kumachepetsedwa; njira iyi imagwiritsidwa ntchito mwachisawawa.
• Pakati (kuphimba) (Kuphimba Pakati) - mutu wapakati umayikidwa pamwamba pa malo okonzekera, pamene kukula kwa tchati sikumasintha.

Kuti mudziwe zambiri, dinani tabu Constructor (Design) ndikusindikiza Onjezani Chart Element (Onjezani Chart Element) > Mutu wa tchati (Tchati Mutu) > Zosankha zowonjezera pamutu (Zosankha zina). Kapena dinani chizindikirocho Ma chart a zinthu (Tchati Elements), ndiye Mutu wa tchati (Tchati Mutu) > Zosankha zina (Zowonjezera Zina).

Dinani batani Zosankha zina (Zosankha Zambiri), muzochitika zonsezi, zimatsegula gululo Mtundu wa Mutu wa Tchati (Mutu wa Tchati cha Format) kumanja kwa tsamba lantchito, komwe mungapeze zosankha zomwe mukufuna.

Kuwonjezera Mutu ku Tchati mu Excel 2010 ndi Excel 2007

Kuti muwonjezere mutu ku tchati ku Excel 2010 ndi koyambirira, tsatirani izi:

1. Dinani kulikonse mu tchati cha Excel kuti mubweretse gulu la ma tabu pa Menyu Riboni Kugwira ntchito ndi ma chart (Zida zama chart).
2. Pa Advanced tabu Kuyika (Kapangidwe) dinani Mutu wa tchati (Tchati Mutu) > Pamwambapa tchati (Pamwambapa Tchati) kapena Pakati (kuphimba) (Kuphimba Pakati).

Kuphatikiza mutu wa tchati ndi cell sheet sheet

Ma chart amitundu yosiyanasiyana mu Excel nthawi zambiri amapangidwa ndi mawu alt m'malo mwa mutu. Kuti muyike dzina lanu la tchati, mutha kusankha gawo la tchati ndikuyika mawuwo pamanja, kapena kulumikiza ku selo iliyonse patsamba lothandizira lomwe lili, mwachitsanzo, dzina la tebulo. Pankhaniyi, mutu wa tchati cha Excel udzasinthidwa zokha nthawi iliyonse zomwe zili mu cell yolumikizidwa zikusintha.

Kuti mulumikize mutu wa tchati ku cell sheet sheet:

1. Onetsani mutu wa tchati.
2. Mu formula bar, lembani chizindikiro chofanana (=), dinani pa cell yomwe ili ndi mawu omwe mukufuna, ndikudina Lowani.

Mu chitsanzo ichi, tikugwirizanitsa mutu wa tchati cha Excel ku selo A1. Mutha kusankha ma cell awiri kapena kupitilira apo (mwachitsanzo, mitu ingapo) ndipo mutu wotsatira uwonetsa zomwe zili m'maselo onse osankhidwa.

Kusuntha mutu mu tchati

Ngati mukufuna kusamutsa mutu wa tchati kumalo ena, sankhani ndikuukoka ndi mbewa yanu:

Kuchotsa mutu wa tchati

Ngati tchati cha Excel sichifuna mutu, ndiye kuti chikhoza kuchotsedwa m'njira ziwiri:

• Pa Advanced tabu Constructor (Kupanga) dinani Onjezani Ma chart (Onjezani Chart Element) > Mutu wa tchati (Tchati Mutu) > Ayi (Palibe).
• Dinani kumanja pa dzina la tchati ndikudina pazosankha Chotsani (Chotsani).

Sinthani mawonekedwe ndi kapangidwe ka mutu wa tchati

Kuti musinthe mawonekedwe a tchati ku Excel, dinani kumanja kwake ndikudina Zilembo (Font) mu menyu yankhani. Bokosi lazokambirana la dzina lomweli lidzatsegulidwa, momwe mungakhazikitsire mafonti osiyanasiyana.

Ngati mukufuna makonda atsatanetsatane, sankhani dzina lachithunzicho, tsegulani tabu Makhalidwe (Format) ndi kusewera mozungulira ndi zosankha zosiyanasiyana. Umu ndi momwe, mwachitsanzo, mungasinthire mutu wa tchati pogwiritsa ntchito Riboni ya Menyu:

Momwemonso, mutha kusintha mawonekedwe a ma chart ena, monga mitu ya axis, zilembo za axis, ndi nthano yachati.

Kuti mumve zambiri za izi, onani nkhani Momwe mungawonjezere mutu pa tchati mu Excel.

Kupanga ma chart ax mu Excel

Kwa mitundu yambiri yama chart mu Excel nkhwangwa yakhazikika (ndilonso mtengo wamtengo wapatali kapena Y axis) ndi yopingasa olamulira (ndiwonso gulu la axis kapena X axis) zimangowonjezeredwa popanga tchati.

Kuti mubise kapena kuwonetsa nkhwangwa zamatchati, dinani chizindikirocho Ma chart a zinthu (Zinthu Zachati), kenako dinani muvi womwe uli mumzerewu Nkhwangwa (Nkhwangwa) ndipo chongani nkhwangwa zomwe mukufuna kuwonetsa, kapena sankhani mabokosi omwe ali pafupi ndi omwe mukufuna kubisa.

Pamitundu ina yamatchati, monga ma combo chart, axis yachiwiri ikhoza kuwonetsedwa.

Mukapanga ma chart a XNUMXD, mutha kuwonetsa kuya kwa axis:

Pachinthu chilichonse cha ma axes a tchati mu Excel, mutha kusintha magawo osiyanasiyana (tilankhula za izi mwatsatanetsatane pambuyo pake):

Kuwonjezera Mitu ya Axis ku Tchati

Mukapanga tchati mu Excel, mutha kuwonjezera mitu ya nkhwangwa zoyima ndi zopingasa kuti zikhale zosavuta kwa ogwiritsa ntchito kumvetsetsa zomwe zikuwonetsedwa patchati. Kuti muwonjezere maudindo a axis, muyenera kuchita izi:

1. Dinani kulikonse pa tchati cha Excel, kenako dinani chizindikirocho Ma chart a zinthu (Zinthu za Tchati) ndipo chongani bokosi Mayina a axis (Maudindo a Axis). Ngati mukungofuna kuwonetsa mutu wa nkhwangwa imodzi (yoyimirira kapena yopingasa), dinani muvi womwe uli kumanja ndikuchotsa chimodzi mwamabokosiwo.
2. Dinani pa tchati mu gawo la mutu wa axis ndikulowetsa mawuwo.

Kuti musinthe mawonekedwe a mutu wa axis, dinani kumanja kwake ndikudina menyu yankhaniyo Mtundu wa dzina la axis (Mutu wa Axis Format). Izi zidzatsegula gulu la dzina lomwelo ndi kusankha kwakukulu kwazomwe mungasankhe. Mukhozanso kugwiritsa ntchito zosankha zomwe zimaperekedwa pa tabu Makhalidwe (Format) Ma riboni a menyu, monga tidachitira pokhazikitsa zosankha zamutu wa tchati.

Gwirizanitsani mitu ya axis ndi ma cell sheet sheet

Monga mutu wa tchati, mutu wa axis ukhoza kulumikizidwa ku selo latsamba lopatsidwa pogwiritsa ntchito ulalo kuti mutuwo ungosinthidwa zokha data mu cell yolumikizidwa ikusintha.

Kuti mupange ulalo wotere, sankhani dzina la axis ndipo mu bar ya formula lowetsani chizindikiro chofanana (=), kenako dinani pa selo lomwe mukufuna kulumikizako dzina la axis, ndikudina Lowani.

Sinthani sikelo ya tchati axis

Microsoft Excel imadziwonetsera yokha kuti ikhale yocheperako komanso yapamwamba kwambiri, komanso mayunitsi a axis of the vertical axis, kutengera deta yomwe imagwiritsidwa ntchito popanga tchati. Ngati ndi kotheka, mutha kuyika magawo anu oyenera a axis ofukula.

1. Sankhani mzere woyima wa tchati ndikudina chizindikirocho Ma chart a zinthu (Zinthu Zachati).
2. Dinani muvi mumzerewu Nkhwangwa (Axis) ndi menyu yomwe ikuwoneka, sankhani Zosankha zina (Zosankha zina). Gulu lidzatsegulidwa Mtundu wa Axis (Fomati axis).
3. Mu gawo Magawo a axis (Zosankha za Axis) chitani chimodzi mwa izi:
   • Kuti muyike zoyambira ndi zomaliza za axis yoyimirira, lowetsani zofunikira m'magawo. osachepera (Zochepa) kapena Zolemba (Zapamwamba).
   • Kuti musinthe masikelo a axis, lowetsani mfundo m'minda Magawano aakulu (Zazikulu) ndi Magawano apakatikati (Wamng'ono).
   • Kuti musinthe ma axis values, chongani bokosi Sinthani dongosolo la zinthu (Makhalidwe mosinthana).

   

Mzere wopingasa, mosiyana ndi woyimirira, nthawi zambiri umakhala ndi zilembo zamalemba m'malo mokhala manambala, ndiye kuti mbali iyi imakhala ndi masikelo ochepa. Komabe, mutha kusintha kuchuluka kwa magulu oti awonetsedwe pakati pa zolembera, dongosolo la maguluwo, ndi pomwe nkhwangwa ziwirizo zimadutsana:

Kusintha manambala a zilembo za axis

Ngati mukufuna kuti manambala omwe ali mu axis awoneke ngati ndalama, maperesenti, nthawi, kapena mtundu wina, dinani kumanja pazolembazo ndikudina pamenyu yankhaniyo. Mtundu wa Axis (Fomati axis). Pagawo lomwe likutsegulidwa, pitani ku gawolo Number (Nambala) ndikusankha imodzi mwamitundu yomwe ilipo:

Tip: Kuti muyike mtundu wa data yochokera kwa manambala (imodzi m'maselo a tsambalo), chongani bokosi Lumikizani ku gwero (Zogwirizana ndi gwero). Ngati simungapeze gawolo Number (Nambala) mu mapanelo Mtundu wa Axis (Format Axis), fufuzani kuti mtengo wa axis wasankhidwa pa tchati (izi nthawi zambiri zimakhala zowongoka).

Kuwonjezera Ma Labels a Data ku Excel Chart

Kuti tchaticho chimveke chosavuta kumva mu Excel, onjezani zolemba zama data zomwe zikuwonetsa zambiri za mndandanda wama data. Kutengera ndi zomwe mukufuna kuti ogwiritsa ntchito azilabadira, mutha kuwonjezera zilembo pamndandanda umodzi wa data, pamndandanda wonse, kapena pamagawo amodzi.

1. Dinani pazotsatira zomwe mukufuna kuwonjezera zilembo. Kuti muwonjezere chizindikiro pamalo amodzi okha a data, dinaninso pa datayo.
2. Dinani pachizindikiro Ma chart a zinthu (Zinthu za Tchati) ndipo chongani bokosi Zizindikiro za Data (Data Labels).

Mwachitsanzo, umu ndi momwe tchati chathu cha Excel chimawonekera ndi zilembo zamtundu umodzi wa data.

Nthawi zina, mutha kusankha momwe zilembo zidzayikidwire. Kuti muchite izi, dinani muvi womwe uli pamzere Zizindikiro za Data (Data Labels) ndikusankha njira yoyenera. Kuti muwonetse zilembo m'mawu oyandama, sankhani Callout Data (Chidziwitso cha data).

Momwe mungasinthire zomwe zikuwonetsedwa m'malebulo

Kuti musinthe zomwe zili pamalemba a data pa tchati, dinani chizindikirocho Ma chart a zinthu (Zinthu Zachati) > Zizindikiro za Data (Zolemba Za data) > Zosankha zina (Zosankha zina). Gulu lidzatsegulidwa Mtundu wa Label ya Data (Malemba a Format Data) kumanja kwa tsamba logwirira ntchito. Pa tabu Zosankha za Signature (Zosankha Zolemba) mu gawo Phatikizani mu Siginecha (Label Muli) sankhani kuchokera pazomwe zaperekedwa.

Ngati mukufuna kuwonjezera mawu osankhidwa pa malo amodzi a data, dinani chizindikiro cha nsongayo, kenako dinaninso kuti musunge chizindikirocho chokhacho chomwe mwasankha, komanso pacholembacho kuti musankhe. Kenako, lowetsani mawu anuanu.

Zikawoneka kuti zilembo zambiri zimadzaza tchati cha Excel, ndiye kuti mutha kuchotsa iliyonse. Dinani pa siginecha ndi batani lakumanja la mbewa ndikudina menyu yankhaniyo Chotsani (Chotsani).

Malangizo ogwiritsira ntchito ndi zilembo za data:

• Kuti musinthe siginecha imodzi, ingoikokerani ndi mbewa kupita komwe mukufuna.
• Kuti musinthe mtundu wa font ndikudzaza zilembo za data, sankhani, kenako dinani tabu Makhalidwe (Format) ndikusintha zosankha zomwe mukufuna.

Kuonjezera, Kuchotsa, Kusuntha, ndi Kusintha Mawonekedwe a Nthano ya Tchati

Mukapanga tchati mu Excel 2013 ndi Excel 2016, nthano imawonjezedwa pansi pa tchati mwachisawawa. Mu Excel 2010 ndi kale, kumanja kwa malo omanga.

Kuti muchotse nthano, dinani chizindikirocho Ma chart a zinthu (Zinthu za Tchati) pafupi ndi ngodya yakumanja ya tchati ndikuchotsa cholembera m'bokosilo Bakuman (Nthano).

Kuti musunthire nthano ya tchati kumalo ena, sankhani tchati, tsegulani tabu Constructor (Kupanga), dinani Onjezani Chart Element (Onjezani Chart Element) > Bakuman (Nthano) ndikusankha malo atsopano a nthanoyo. Kuti muchotse nthano, dinani Ayi (Palibe).

Njira ina yosunthira nthanoyo ndikudina kawiri ndikusankha malo omwe mukufuna mugawolo. Zosankha za nthano (Nthano Zosankha) mapanelo Mtundu wa Legend (Nthano ya Format).

Kuti musinthe mawonekedwe a nthano, pali zosankha zambiri pama tabu Shading ndi Borders (Dzazani & Mzere) ndi zotsatira (Zotsatira) mapanelo Mtundu wa Legend (Nthano ya Format).

Onetsani ndikubisa gululi mu tchati cha Excel

Mu Excel 2013 ndi 2016, kusonyeza kapena kubisa gululi ndi nkhani ya masekondi. Ingodinani pa chithunzi Ma chart a zinthu (Zinthu Zachati) ndikuyang'ana kapena kutsitsa bokosilo Mesh (Mizere yamagetsi).

Microsoft Excel imadziwonetsera yokha kuti ndi mizere iti yomwe ili yabwino kwambiri pamtundu womwe wapatsidwa. Mwachitsanzo, tchati cha bar chiwonetsa mizere yayikulu yowongoka, pomwe tchati chamizere chidzawonetsa mizere yayikulu yopingasa.

Kuti musinthe mtundu wa mizere ya gridi yomwe ikuwonetsedwa, dinani muvi wakumanja pamzerewu Mesh (Mizere ya gridi) ndikusankha yoyenera kuchokera pazosankha zomwe mukufuna, kapena dinani Zosankha zina (Zowonjezera Zina) kuti mutsegule gululo Main Grid Line Format (Mizere Yaikulu ya Grid).

Kubisa ndikusintha mndandanda wa data mu tchati cha Excel

Tchati cha Excel chikawonetsa zambiri, nthawi zina pamafunika kubisa kwakanthawi gawo la mndandanda kuti muyang'ane zomwe mukufuna pakadali pano.

Kuti muchite izi, dinani chizindikiro chomwe chili kumanja kwa graph. Zosefera Ma chart (Zosefera Tchati) ndikuchotsa mizere ndi/kapena magulu omwe mukufuna kubisa.

Kuti musinthe mndandanda wazinthu, dinani batani Sinthani mzere (Sinthani Series) kumanja kwa dzina lake. Batani limawonekera mukasuntha mbewa pa dzina la mzerewu. Izi ziwunikira mzere wofananira pa graph, kotero mutha kuwona mosavuta chomwe chidzasinthidwa.

Sinthani mtundu wa tchati ndi kalembedwe

Ngati tchati chomwe mudapanga sichikugwirizana bwino ndi zomwe mukuwonetsa, mutha kusintha mtundu wa tchati mosavuta. Kuti muchite izi, sankhani chithunzicho, tsegulani tabu Ikani (Ikani) ndi mu gawo Zithunzi (Matchati) sankhani mtundu wina wa tchati.

Njira ina ndikudina kumanja kulikonse pa tchati ndikudina pamenyu yankhaniyo Sinthani mtundu wa tchati (Sintha Mtundu wa Tchati).

Kuti musinthe mwachangu kalembedwe ka tchati chopangidwa, dinani chizindikirocho Masitayilo a ma chart (Masitayelo a Tchati) kumanja kwa malo omangawo ndikusankha yoyenera pa masitayelo omwe akuperekedwawo.

Kapena sankhani imodzi mwa masitayelo omwe ali mugawoli Masitayilo a ma chart (Masitayelo a Ma chart) tabu Constructor (Kupanga):

Kusintha mitundu ya tchati

Kuti musinthe mutu wa tchati mu Excel, dinani chizindikirocho Masitayilo a ma chart (Masitayelo a Tchati), tsegulani tabu mtundu (Mtundu) ndikusankha imodzi mwamitu yomwe mukufuna. Mitundu yosankhidwa idzagwiritsidwa ntchito nthawi yomweyo pajambula, ndipo mukhoza kuyesa nthawi yomweyo ngati ikuwoneka bwino mu mtundu watsopano.

Kuti musankhe mtundu wa mndandanda uliwonse payekhapayekha, sankhani mndandanda wa data mu tchati, tsegulani tabu Makhalidwe (Format) ndi mu gawo Mawonekedwe masitayilo (Mawonekedwe Masitayilo) dinani Kudzaza mawonekedwe (Kudzaza Mawonekedwe).

Momwe mungasinthire ma axes a x ndi y a tchati

Mukapanga tchati ku Excel, momwe tchatichi chimayang'ana zimadziwikiratu potengera kuchuluka kwa mizere ndi mizere yazomwe zimayambira pomwe tchaticho chimapangidwira. Mwanjira ina, Microsoft Excel imasankha paokha momwe ingajambulire bwino graph pamizere ndi mizere yosankhidwa.

Ngati kusasinthika kwa mizere ndi mizati pa tchati sikukugwirizana ndi inu, mutha kusinthana mosavuta nkhwangwa zopingasa ndi zoyima. Kuti muchite izi, sankhani chithunzicho ndi pa tabu Constructor (Kupanga) dinani Mzere wa mzere (Sinthani Mzere/Mzere).

Momwe mungasinthire tchati mu Excel kuchokera kumanzere kupita kumanja

Kodi mudapangapo tchati ku Excel ndipo pamapeto pake ndidazindikira kuti ma data ali mosiyana ndi zomwe mukufuna kupeza? Kuti mukonze izi, muyenera kusintha momwe zigawozo zimapangidwira pazithunzi, monga momwe zilili pansipa.

Dinani kumanja pa axis yopingasa ya tchati ndikudina Mtundu wa Axis (Format Axis) mu menyu yankhani.

Ngati mumazolowera kugwira ntchito ndi Riboni, tsegulani tabu Constructor (Design) ndikusindikiza Onjezani Chart Element (Onjezani Chart Element) > Nkhwangwa (Nkhwangwa) > Zosankha Zowonjezera za Axis (Zosankha Zambiri za Axis).

Mulimonsemo, gulu lidzawoneka. Mtundu wa Axis (Format Axis) pomwe pa tabu Magawo a axis (Zosankha za Axis) muyenera kusankha njirayo Sinthani dongosolo la magulu (Magulu mu dongosolo la reverse).

Kuphatikiza pa kutembenuza tchati mu Excel kuchokera kumanzere kupita kumanja, mutha kusintha dongosolo la magawo, zikhalidwe, kapena mndandanda wa data mu tchati, kubweza makonzedwe a ma data, kutembenuza tchati cha pie ku ngodya iliyonse, ndi zina zambiri. Nkhani ina imaperekedwa pamutu wa ma chart ozungulira mu Excel.

Lero mwaphunzira momwe mungasinthire ma chart mu Excel. Zachidziwikire, nkhaniyi imangokulolani kuti muyang'ane pamutu wa makonda ndi ma chart mu Excel, ngakhale zambiri zitha kunenedwa za izi. M'nkhani yotsatira, tidzapanga tchati kuchokera ku deta yomwe ili pamapepala osiyanasiyana. Pakadali pano, ndikupangira kuti muyesetse kuphatikiza chidziwitso chomwe mwapeza lero.