Kusintha ma chart mu Excel: kuwonjezera mutu, nkhwangwa, nthano

Chinthu choyamba chomwe mumachita mutapanga tchati mu Excel ndi chiyani? Mwachibadwa, ikonzeni kuti igwirizane ndi chithunzi chimene m’maganizo mwanu munajambula.

M'mawonekedwe aposachedwa amasamba, kusintha ma chart ndi njira yabwino komanso yosavuta.

Microsoft yapita kutali kwambiri kuti ikhale yosavuta kusintha makonda. Mwachitsanzo, anaika mabatani ofunikira m’malo amene kuli kosavuta kuwafikira. Ndipo pambuyo pake mu phunziroli, muphunzira njira zingapo zosavuta zowonjezerera ndikusintha zinthu zonse za ma chart ndi ma graph mu Excel.

Njira Zitatu Zosavuta Zopangira

Ngati mukudziwa kupanga ma graph mu Excel, mukudziwa kuti mutha kupeza zosintha zake m'njira zitatu:

1. Sankhani tchati ndikudumphira kugawo "Kugwira ntchito ndi ma chart", yomwe imapezeka pa tabu "Constructor".
2. Dinani kumanja pa chinthu chomwe chiyenera kusinthidwa ndikusankha chinthu chomwe mukufuna kuchokera pamenyu yowonekera.
3. Gwiritsani ntchito batani losintha makonda lomwe likuwonetsedwa pakona yakumanja kwa tchati mutadina ndi batani lakumanzere.

Ngati mukufuna kukonza zina zomwe zimakupatsani mwayi wosintha mawonekedwe a graph, mutha kuwawona m'malo omwe akuwonetsedwa ndi mutu. "Chart Area Format", yomwe ingapezeke podina chinthucho "Zowonjezera zina" mu popup menyu. Mukhozanso kuwona njira iyi mu gulu "Kugwira ntchito ndi ma chart".

Kuti muwonetse nthawi yomweyo gulu la "Format Chart Area", mutha kudina kawiri chinthu chofunikira.

Tsopano popeza tafotokoza mfundo zofunika kwambiri, tiyeni tione mmene tingasinthire zinthu zosiyanasiyana kuti tchaticho chiwoneke mmene tikufunira.

Momwe mungawonjezere mutu

Popeza anthu ambiri amagwiritsa ntchito mitundu yaposachedwa yamaspredishiti, lingakhale lingaliro labwino kuyang'ana momwe mungawonjezere mutu mu Excel 2013 ndi 2016. 

Momwe mungawonjezere mutu ku tchati mu Excel 2013 ndi 2016

M'mitundu yamaspredishiti awa, mutuwo walowetsedwa kale mutchati. Kuti musinthe, ingodinani ndikulemba mawu ofunikira m'gawo lolowetsa.

Mutha kupezanso mutu mu cell inayake mu chikalatacho. Ndipo, ngati selo lolumikizidwa lisinthidwa, dzina limasintha pambuyo pake. Muphunzira zambiri za momwe mungakwaniritsire izi pambuyo pake.

Ngati mutuwo sunapangidwe ndi pulogalamuyi, ndiye kuti muyenera kudina malo aliwonse patchati kuti muwonetse tabu "Kugwira ntchito ndi ma chart". Kenako, sankhani "Design" tabu ndikudina "Add Chart Element". Kenako, muyenera kusankha mutu ndi kusonyeza malo ake monga momwe chithunzi cha skrini.

Mutha kuwonanso chizindikiro chowonjezera pakona yakumanja kwa tchati. Mukadina, mndandanda wazinthu zomwe zikupezeka pachithunzichi zimawonekera. Kuti muwonetse mutuwo, muyenera kuyang'ana bokosi pafupi ndi chinthu chofananiracho.

Kapenanso, mutha kudina muvi womwe uli pafupi ndi "Tchati Mutu" ndipo sankhani imodzi mwa izi:

1. Pamwamba pajambula. Uwu ndiye mtengo wokhazikika. Chinthuchi chikuwonetsa mutu pamwamba pa tchati ndikuchikulitsa.
2. Pakati. Pankhaniyi, tchati sichimasintha kukula kwake, koma mutuwo umayikidwa pamwamba pa tchaticho.

Kuti mukonze magawo ambiri, muyenera kupita ku tabu "Constructor" ndipo tsatirani izi:

1. Onjezani chinthu chachati.
2. Mutu wa tchati.
3. Zosankha zowonjezera pamutu.

Mukhozanso dinani chizindikirocho "Zinthu zama chart", Kenako - "Tchati Mutu" и "Zowonjezera zina". Mulimonsemo, zenera limatsegulidwa "Mawonekedwe a Mutu wa Ma chart"zafotokozedwa pamwambapa.

Kusintha kwamutu mumitundu ya Excel 2007 ndi 2010

Kuti muwonjezere mutu mu Excel 2010 ndi pansipa, tsatirani izi:

1. Dinani paliponse patchati.
2. Gulu la ma tabo lidzawonekera pamwamba. "Kugwira ntchito ndi ma chart", pomwe muyenera kusankha chinthu "Kapangidwe". Pamenepo muyenera dinani "Tchati Mutu".
3. Kenaka, muyenera kusankha malo omwe mukufuna: kumtunda kwa malo okonzerako kapena kuphimba mutu pa tchati.

Kulumikiza mutu ku selo linalake mu chikalata

Pamitundu yambiri yama chart mu Excel, tchati chomwe changopangidwa kumene chimayikidwa pamodzi ndi mutu womwe udalembedwa kale ndi opanga mapulogalamu. Iyenera kusinthidwa ndi yanu. Muyenera alemba pa izo ndi kulemba zofunika lemba. Ndikothekanso kuyilumikiza ku cell inayake muzolemba (dzina la tebulo lokha, mwachitsanzo). Pamenepa, mutu wa tchati udzasinthidwa mukasintha selo yomwe ikugwirizana nayo.

Kuti mulumikize mutu ku selo, tsatirani izi:

1. Sankhani mutu. 
2. M'gawo lolowetsa fomula, muyenera kulemba =, dinani pa cell yomwe ili ndi mawu ofunikira, ndikusindikiza batani la "Lowani".

Muchitsanzo ichi, talumikiza mutu wa tchati chosonyeza kugulitsa zipatso ku selo A1. N'zothekanso kusankha maselo awiri kapena kuposerapo, mwachitsanzo, mitu yandalama. Mutha kuwapanga kuti awoneke pamutu wa graph kapena tchati.

Momwe mungasunthire mutu

Ngati mukufuna kusuntha mutuwo ku gawo lina la graph, muyenera kusankha ndikusuntha ndi mbewa.

Kuchotsa mutu

Ngati simukuyenera kuwonjezera mutu patchati, mutha kuchotsa mutuwo m'njira ziwiri:

1. Pa Advanced tabu "Constructor" Dinani motsatizana pazinthu izi: "Add Chart Elements" - "Tchati Mutu" - “Ayi”.
2. Dinani kumanja pamutu ndikuyitanitsa menyu yankhani yomwe mukufuna kupeza chinthucho "Chotsani".

Kupanga Kwamutu

Kuti mukonze mtundu wa font ndi mtundu wa dzinalo, muyenera kupeza chinthucho mumenyu yankhani "Fonti". Zenera lolingana lidzawonekera pomwe mutha kukhazikitsa zokonda zonse zofunika.

Ngati mukufuna masanjidwe obisika, muyenera dinani mutu wa graph, pitani ku tabu "Mtundu" ndikusintha makonda momwe mukuwonera. Nachi chithunzi chowonetsa masitepe osinthira mtundu wamtundu wamutu kudzera pa riboni.

Mwa njira yofananira, ndizotheka kusintha mapangidwe azinthu zina, monga nthano, nkhwangwa, maudindo.

Kusintha kwa ma chart axis

Nthawi zambiri nkhwangwa zoyimirira (Y) ndi zopingasa (X) zimawonjezedwa nthawi imodzi mukapanga graph kapena tchati ku Excel.

Mutha kuziwonetsa kapena kuzibisa pogwiritsa ntchito batani "+" pakona yakumanja yakumanja ndikudina muvi womwe uli pafupi ndi "Nkhwangwa". Pazenera lomwe likuwoneka, mutha kusankha omwe akuyenera kuwonetsedwa ndi omwe abisika bwino.

Mumitundu ina ya ma graph ndi ma chart, axis yowonjezera imatha kuwonetsedwanso.

Ngati mukufuna kupanga tchati cha XNUMXD, mutha kuwonjezera axis yakuya.

Wogwiritsa ntchito amatha kufotokozera momwe ma nkhwangwa osiyanasiyana aziwonetsera pa tchati cha Excel. Njira zambiri zafotokozedwa pansipa.

Kuwonjezera Maina a Axis

Kuti muthandize owerenga kumvetsetsa zambiri, mutha kuwonjezera zilembo za nkhwangwa. Kuti muchite izi, chitani zotsatirazi:

1. Dinani pa chithunzicho, kenako sankhani chinthucho "Zinthu zama chart" ndipo onani bokosilo "Maina a Axis". Ngati mukufuna kufotokoza mutu wa axis yeniyeni, muyenera kudina muvi ndikuchotsa chimodzi mwamabokosi ochombola.
2. Dinani pa gawo lolowera mutu wa axis ndikulowetsa mawuwo.

Kuti mufotokoze maonekedwe a mutuwo, dinani kumanja ndikupeza chinthu cha "Axis Title Format". Kenako, gulu lidzawonetsedwa momwe zosankha zonse zotheka zimakonzedwera. Ndizotheka kuyesa njira zosiyanasiyana zowonetsera mutu pa tabu "Mtundu", monga momwe tawonetsera pamwambapa pakusintha mtundu wa mutu.

Kugwirizanitsa mutu wa axis ndi selo lachikalata linalake

Monga momwe zilili ndi mitu yamatchati, mutha kumangirira mutu wa axis ku cell inayake mu chikalatacho kuti chisinthidwe pomwe selo lofananira patebulo lisinthidwa.

Kuti mumange mutu, muyenera kusankha, kulemba = m'munda woyenera ndikusankha selo lomwe mukufuna kumangirira ku axis. Pambuyo pa izi, muyenera dinani batani la "Enter".

Sinthani sikelo ya nkhwangwa

Excel palokha imapeza mtengo waukulu kwambiri komanso wocheperako, kutengera zomwe wogwiritsa ntchito adalemba. Ngati mukufuna kukhazikitsa magawo ena, mutha kuchita pamanja. Muyenera kuchita izi:

1. Sankhani x-axis ya tchati ndikudina chizindikirocho "Zinthu zama chart".
2. Dinani chizindikiro cha muvi pamzerewu "Axis" ndipo dinani pa pop-up menyu "Zowonjezera zina".
3. Kenako pakubwera gawo "Zosankha za Axis"pomwe chilichonse mwa izi chikuchitidwa:
   1. Kuti muyike zoyambira ndi zomaliza za Y axis, muyenera kuzifotokoza m'magawo "Minimum" ndi "Maximum".
   2. Kuti musinthe kukula kwa axis, mutha kufotokozeranso zofunikira m'munda "Basic Division" и "Magawo apakatikati".
   3. Kuti mukonze zowonetsera motsatira dongosolo, muyenera kuyang'ana bokosi pafupi ndi njirayo “Reverse Order of Values”.

Popeza opingasa opingasa nthawi zambiri amawonetsa zolemba, amakhala ndi zosankha zochepa. Koma mutha kusintha kuchuluka kwa magulu omwe akuwonetsedwa pakati pa zilembo, kutsatizana kwawo komanso komwe nkhwangwa zimadutsa.

Kusintha Mawonekedwe a Axis Values

Ngati mukufuna kuwonetsa zikhalidwe pa nkhwangwa ngati peresenti, nthawi, kapena mtundu wina uliwonse, muyenera kusankha chinthucho pamenyu yotulukira. "Format Axis", ndipo kumanja kwa zenera, sankhani imodzi mwa njira zomwe zingatheke pomwe ikunena "Nambala".

Malangizo: kuti musinthe mawonekedwe a chidziwitso choyambirira (ndiko kuti, zomwe zimawonetsedwa m'maselo), muyenera kuyika bokosi pafupi ndi chinthucho. "Link to Source". Ngati simungapeze gawolo "Nambala" mu gulu "Format Axis", muyenera kuonetsetsa kuti mwasankha kale axis yomwe ikuwonetsa zikhalidwe. Nthawi zambiri ndi X axis.

Kuwonjezera Data Labels

Kuti tchati chikhale chosavuta kuwerenga, mutha kuwonjezera zilembo ku data yomwe mumapereka. Mutha kuwawonjezera pamzere umodzi kapena onse. Excel imaperekanso kuthekera kowonjezera zilembo kuzinthu zina.

Kuti muchite izi, muyenera kutsatira njira izi:

1. Dinani pazotsatira zomwe zimafuna siginecha. Ngati mukufuna kuyika mfundo imodzi yokha ndi mawu, muyenera kudinanso.
2. Dinani pachizindikiro "Zinthu zama chart" ndipo fufuzani bokosi pafupi "Zisaina Za data".

Mwachitsanzo, izi ndi momwe matchati amawonekera pambuyo poti zilembo zawonjezedwa ku gulu limodzi lazolemba patebulo lathu.

Pamitundu yeniyeni ya matchati (monga ma pie charts), mutha kufotokoza komwe lebulo lili. Kuti muchite izi, dinani muvi womwe uli pafupi ndi mzerewu "Zisaina Za data" ndikuwonetsa malo oyenera. Kuti muwonetse zilembo m'malo olowetsamo zoyandama, muyenera kusankha chinthucho "Kuwerengera kwa data". Ngati mukufuna makonda ena, mutha kudina chinthucho chomwe chili pansi pa menyu yankhaniyo.

Momwe mungasinthire zomwe zili mu siginecha

Kuti musinthe zomwe zikuwonetsedwa pamasigino, muyenera dinani batani "Zinthu zama chart" - "Zisaina Za data" - "Zowonjezera zina". Kenako gulu liziwoneka. "Data Label Format". Apa muyenera kupita ku tabu "Signature Options" mu ndikusankha njira yomwe mukufuna mu gawoli "Phatikizani mu Signature".

Ngati mukufuna kuwonjezera zolemba zanu pamalo enaake a data, muyenera kudina kawiri pa lebulo lolingana kuti lisankhe lokha. Kenako, sankhani chizindikiro chokhala ndi mawu omwe alipo kale ndikulowetsa mawu omwe mukufuna kusintha.

Ngati muwona kuti zilembo zambiri zikuwonetsedwa patchati, mutha kuchotsa iliyonse mwa kudina kumanja palemba lofananira ndikudina batani. "Chotsani" mu menyu yankhani yomwe ikuwoneka.

Malangizo ena ofotokozera zilembo za data:

1. Kuti musinthe malo a siginecha, muyenera kudina ndikusunthira kumalo omwe mukufuna ndi mbewa.
2. Kuti musinthe mtundu wakumbuyo ndi siginecha, sankhani, pitani ku tabu "Mtundu" ndikukhazikitsa magawo ofunikira.

Kupanga Legend

Mutatha kupanga tchati mu Excel, nthanoyo idzawonekera pansi pa tchati ngati Excel version ndi 2013 kapena 2016. Ngati ndondomeko yoyamba ya pulogalamuyo yaikidwa, idzawonetsedwa kumanja kwa dera lachiwembu.

Kuti mubise nthanoyo, muyenera dinani batani lokhala ndi chizindikiro chowonjezera pakona yakumanja kwa tchati ndikuchotsa bokosi lomwe likugwirizana nalo.

Kuti musunthe, muyenera dinani chithunzicho, sunthirani ku tabu "Constructor" Ndi kukanikiza "Add Chart Element" ndikusankha malo ofunikira. Mutha kufufutanso nthano kudzera pa menyuyi podina batani “Ayi”. 

Mutha kusinthanso malowo ndikudina kawiri pamenepo komanso pazosankha (kumanja kwa chinsalu) posankha malo omwe mukufuna.

Kusintha masanjidwe a nthano, pali zosintha zambiri pa tabu "Mithunzi ndi malire", "Zotsatira" mu gulu lamanja.

Momwe mungasonyezere kapena kubisa gululi la chikalata cha Excel

Gululi limawonetsedwa kapena kubisika pogwiritsa ntchito menyu omwe amawoneka omwe amagwiritsidwa ntchito kuwonetsa mutu, nthano, ndi ma chart ena.

Pulogalamuyo imangosankha mtundu wa gridi yoyenera kwambiri pa tchati inayake. Ngati mukufuna kusintha, muyenera dinani muvi womwe uli pafupi ndi chinthucho ndikudina "Zowonjezera zina".

Kubisa ndikusintha mndandanda wa data mu Excel

Kuti mubise kapena kusintha mndandanda wa data mu Excel, muyenera dinani batani lomwe lili kumanja kwa graph “Zosefera ma chart” ndikuchotsani mabokosi osafunikira. 

Kuti musinthe deta, dinani "Sinthani Row" kumanja kwa mutuwo. Kuti muwone batani ili, muyenera kuyang'ana pamwamba pa dzina la mzere.

Sinthani mtundu wa tchati ndi kalembedwe

Kuti musinthe mtundu wa tchati, muyenera kudina, pitani ku tabu "Ikani" ndi mu gawo "Zithunzi" sankhani mtundu woyenera.

Mukhozanso kutsegula menyu yankhani ndikudina "Sintha Mtundu wa Tchati".

Kuti musinthe mawonekedwe a tchati mwachangu, muyenera dinani batani lolingana (ndi burashi) kumanja kwa tchati. Mutha kusankha yoyenera pamndandanda womwe umawonekera.

Mukhozanso kusankha kalembedwe koyenera m'gawolo “Masitayelo a Ma chart” mu tab "Constructor".

Sinthani mitundu yamatchati

Kuti musinthe mtundu, dinani batani “Masitayelo a Ma chart” ndi mu tab "Mtundu" sankhani mutu woyenera.

Mukhozanso kugwiritsa ntchito tabu "Mtundu"kumene dinani batani "kudzaza mawonekedwe".

Momwe mungamvetsetse malo a axis

Kuti mukwaniritse cholinga ichi, ndikofunikira pa tabu "Constructor" kanikizani batani "Row column".

Tchati chofalikira kuchokera kumanzere kupita kumanja

Kuti muzungulire tchati kuchokera kumanzere kupita kumanja, muyenera kudina kumanja pa axis yopingasa ndikudina "Format Axis".

Mukhozanso mu tabu "Constructor" pezani chinthu "Zosankha Zowonjezera za Axis".

Pagawo lakumanja, sankhani chinthucho "Reverse order of categories".

Palinso zina zingapo zomwe zingatheke, koma ndizosatheka kulingalira zonse. Koma ngati mutaphunzira kugwiritsa ntchito zinthu zimenezi, kudzakhala kosavuta kuti inunso muphunzire zina zatsopano. Zabwino zonse!