Gxininisa iData yeDatha kunye neComple Pie Charts kwi-Excel

I-Excel ineenketho ezininzi zokuncedisa kugxininisa kumacandelo athile okanye iinkalo zeetayiti zepayiti ezingafaki ukutshintsha okanye ukulungiswa kwakhona kwedatha yedatha. Ezi ziquka:

• ukuqhuma okanye ukukhupha isakhethi esikhethiweyo ukusuka kwenye ipayi;
• ugxininise omnye okanye ngaphezulu kweetayi usebenzisa i- Pie yeTyiti yetshizi;
• ugxininise omnye okanye ezininzi iinkcazo usebenzisa ibhadi yePae .

Ukuxhaphaza Isiqhekeza esisodwa sePiyi

Ukongeza ugxininiso kwisicatshulwa esithile seetayiti yepayi ongashukumisela okanye "uqhube" le ngceka ephuma kwenye indawo yetshathi njengoko kunokubonwa kwicala lasekhohlo lomfanekiso ongentla.

Ukwenza oku:

1. Cofa kanye nge-pointer yemouse kwindawo yesalathisi yetshathi yeepayi ukuze uyiqakatheke - iiblue okanye amabhotshi amancinci kufuneka ibonakale ngaphaya komda we-pie;
2. Cofa okwesibini kwisiqwenga sokuqhutyelwa;
3. Amacandelo afanele ajikeleze ngoku nje isiqhekeza esisodwa se-pie - kubandakanywa icacisa phakathi kwitekiti;
4. Cofa uze udibanise ngesilathisi se mouse kwisakhethi esikhethiweyo se-pie, ukuyikhupha okanye ukuyiqhawula ngaphandle kwetshathi nganye;
5. Ukuhambisa isahluko esiqhekekileyo kwindawo yaso yangaphambili, sebenzisa i- Excel yokutshintshwa kwento xa kunokwenzeka;
6. Ukuba akunjalo, phinda amanyathelo oku-1 kunye no-2 ngasentla uze udonsa isahlulo kwi-pie. Kuya kubuyela ngokuzenzekelayo kwindawo yayo yangaphambili.

Ukuxhaphaza i-Pie epheleleyo

Ukuba zonke iicandelo ezitshatileyo ziqhumayo kuthetha ukuba awukhethi nje isahlulo esinye. Ukulungisa oku, dibanisa kwakhona iiplani kunye kunye nezama-2 kunye no-3 ngaphezulu.

I-Pie ye-Pie kunye neBar yeeCharts

Enye inketho yokunyusa ukugxininisa kwiindawo ezithile zetshathi yeepayi kukusebenzisa i- pie ye-pie okanye ityiti yepayiti kunokuba ityati ehlala rhoqo.

Ukuba unomlinganiselo omnye okanye ezimbini eziphambili ezithatha isatidi yepayi, okwenza kube nzima ukubona iinkcukacha zincinci ezincinci, tshintshela kwenye yale mibini yetshati, egxininisa iincinci ezincinci kwiteksi yesibini - nokuba iseshini yesibini okanye ityati yebhayibhile ekhethiweyo, ukhetho lenu.

Ngaphandle kokuba utshintshwe, i-Excel izakufaka ngokuzenzekelayo ezintathu zincinci zincinci ( iinkcukacha zedata ) kwipayiti yesibini okanye isitrakthi sebhayibhile.

Ukwenza i-pie ye-pie okanye ibha yetshathi yeepayi:

1. Phakamisa uluhlu lweedatha oluya kusetyenziswa kwitshati;
2. Cofa kwi- Insert ithebhu yebhebhoni ;
3. Kwibhokisi yeSetyiti yebhanethi, nqakraza kwi icon ye- Insert Pie Chart ukuvula imenyu ehlayo yeentlobo zeeseshati ezikhoyo;
4. Hambisa isalathisi sakho semouse phezu kwengubo yetshathi ukuze ufunde inkcazo yetshathi;
5. Cofa kwi- pie ye-pie okanye ibha yetshathi ye-pie kwicandelo le- 2-D lePi le menu ehlayo ukuze ungeze iseshati kwiphepha lokusebenzela.

Qaphela: I-chart yesandla sasekhohlo isoloko ishadi eliphambili, kunye neetshathi zesibini ezivela rhoqo ngakwesokudla. Eli lungiselelo alinakuguqulwa.

Iintlobo zeeTriki ezitshintshileyo

Ukutshintshwa kwiseshoni esele ikhona ipayiti ye-pie ukuya kwi- pie ye-pie okanye ibha yetshathi yepayi :

1. Nqakraza ngakwesokudla ishati yangoku ukuvula imenyu yomongo;
2. Kwimenyu, nqakraza Uhlobo lweTyhuthi yoTshintsho ukuze uvule ibhokisi yencoko yentshukumo yencoko yoTshintsho ;
3. Kwibhokisi yencoko, nqakraza kwiTyhuthi Yonke i-Charts ;
4. Cofa kwi- Pie kwicala lokunene lasekhohlo, uze uklikha kwi Pie of Pie okanye iBar of Pie kwicala lokunene kwibhokisi yencoko.

Ukutshintsha inani leenkcukacha zeenkcukacha

Ukutshintsha inani leedata (iinkalo) eziboniswe kwiteksi yesibini:

1. Nqakraza ngakwesinye isicekile kwitshathi (idatha esetyenziselwa ukwakha isatidi yesibini) ukuvula ifomathi yeSahluko seDatha yeDatha ;
2. Kwifowuni, nqakraza kwinqolo ephantsi kweSahlulo seSplit By option.

Izinketho ezinxulumene nokutshintsha inani lamanani eenkcukacha kwishadi lesibini zi:

• Ukwahlula uchungechunge ngendawo: kwiimilinganiselo kwibhokisi yesibini yesiqendu , faka inani lezithuba okanye iinkcazo eziboniswe kwiteksi yesibini-3 ubuncinci;
• Ukwahlula uchungechunge ngexabiso : kwiMilinganiselo engaphantsi kwebhokisi, faka inombolo enkulu kunexabiso elincinci leenkcukacha eliza kuboniswa kwiteksi yesibini;
• Ukwahlula uchungechunge ngexabiso lepesenti: kwixabiso elingaphantsi kwebhokisi, faka ixabiso leepesenti phakathi kwe-0% kunye ne-100%-eli xabiso lihambelana nepesenti yexabiso elipheleleyo lechati eliza kuboniswa kwiteksi yesibini.