Gcizelela idatha yedatha nge-Charts Pie Charts ku-Excel

I-Excel inezinketho eziningana zokwengeza kugcizelela ezingxenyeni ezithile noma iziqephu zeshadi lephayi elingathinti ukushintsha noma ukuhlela kabusha idatha yeshadi. Lokhu kufaka:

• ukuqhuma noma ukukhipha isigaba esikhethiwe kukho konke okuyi-pie;
• sigxile eyodwa noma ngaphezulu tincetu besebenzisa i- pie ye-pie ishadi;
• sigxile eyodwa noma ngaphezulu tincetu besebenzisa i- Bar of Pie ishadi.

Ukuxhaphaza Uhlangothi Olulodwa Lwe-Pie

Ukwengeza ukugcizelela kwesinye ishadi leshadi lephayi ungakwazi ukuhambisa noma "ukuqhuma" lolu hlobo kusuka kulo lonke ishadi njengoba kungabonakala ngakwesokunxele kwesithombe ngenhla.

Ukwenza lokhu:

1. Chofoza kanye ne-pointer yegundane endaweni yendawo yesiteji sephayi ukuyiqokomisa - imibuthano encane ye-bluish noma amachashazi kufanele abonakale emaphethelweni angaphandle kwe-pie;
2. Chofoza okwesibili kusiqephu esingaqhutshwa;
3. Amachashazi kufanele manje azungeze lo mkhakha owodwa we-pie - kufaka phakathi ichashazi phakathi kweshadi;
4. Chofoza bese uhudula nge-pointer yegundane kusigaba esikhethiwe se-pie, ukuyikhipha noma ukuyixhaphaza kude nayo yonke ishadi;
5. Ukuhambisa isigaba esiphelile emuva endaweni yaso yokuqala, sebenzisa isici sokuhlehlisa i-Excel uma kungenzeka;
6. Uma kungenjalo, phinda izinyathelo 1 no-2 ngenhla uphinde uhudule ucezu ku-pie. Izobuyela ngokuzenzakalelayo endaweni yayo yasekuqaleni.

Ukusebenzisa i-Pie Enye

Uma zonke izincezu eshadini ziqhuma kusho ukuthi awuzange ukhethe uhlangothi olulodwa. Ukulungisa lokhu, donsela izinkamu ndawonye bese uzama izinyathelo ezimbili no-3 ngaphezulu.

Pie of Pie kanye neBar of Pie Charts

Enye indlela yokwengeza igcizelela ezingxenyeni ezithile zeshadi lokuphayela ukusebenzisa i- pie ye-pie noma ishadi lepayipi kuneshadi elivamile lepayipi.

Uma unesisindo esisodwa noma ezimbili ezikhudlwana ezilawula ishadi lepayipi, okwenze kube nzima ukubona imininingwane yezincezu ezincane, shiya kwenye yalezi zinhlobo ezimbili zebhadi, ezigcizelela izintwana ezincane eshadini lesibini - noma ishadi lesibini lephayi noma ishadi elibhayiwe, isinqumo senu.

Ngaphandle kokuguqulwa, i-Excel izofaka ngokuzenzakalelayo lezi zingcezu ezincane kunazo zonke ( amaphuzu wedatha ) eshadini lesibini le-pie noma ibha yebhasi.

Ukwakha uphayi we-pie noma ibha leshadi lephayi:

1. Qinisekisa ububanzi bemininingwane okufanele isetshenziswe eshadini;
2. Chofoza ku- Faka ithebhu ye- ribbon ;
3. Ebhokisini Lamashadi webhebhoni, chofoza isithonjana se- Insert Pie Chart ukuvula imenyu yehla yezinhlobo zeshadi ezitholakalayo;
4. Hambisa isikhombisi sakho semouse phezu kohlobo lwebhadi ukuze ufunde incazelo yeshadi;
5. Chofoza ku -pie noma i- bar ye-pie ishadi engxenyeni ye- 2-D ye-Pie ye-drop down menu ukuze ungeze leso shadi ekhasini lokusebenzela.

Qaphela: Ishadi lesokunxele lesikhathi njalo ishadi eliyinhloko, nekhadi lesibili libonakala njalo ngakwesokudla. Leli lungiselelo alinakushintshwa.

Uhlobo lweShadi lushintsha

Ukushintsha kusuka eshadini elivamile lepayipi kuze kube ngu- pie we-pie noma ibha leshadi lephayi :

1. Chofoza ngakwesokudla ishadi lamanje ukuvula imenyu yokuqukethwe;
2. Ku imenyu, chofoza Uhlobo Lweshadi Lokushintsha ukuze uvule ibhokisi lengxoxo yeTjhuguluko leshadi ;
3. Ebhokisini lengxoxo, chofoza kuthebhu Yonke Amashadi ;
4. Chofoza ku- Pie ngakwesokunxele, bese uchofoza ku- Pie of Pie noma i- Bar of Pie ngakwesokudla ngakwesokudla ibhokisi lezingxoxo.

Ukushintsha inani lamaphuzu wedatha

Ukushintsha inani lamaphuzu wedatha (tincetu) eziboniswe eshadini lesibini:

1. Chofoza ngakwesokudla kwesinye isigaba eshadini (idatha esetshenziselwa ukwakha ishadi lesibini) ukuze uvule i- Format Data Series Series ;
2. Esikhathini esingaphansi, chofoza umcibisholo ophansi ngaphansi kochungechunge lweSplit By option.

Izinketho ezihlobene nokushintsha inani lamaphuzu wedatha eshadini lesibili yizi:

• Hlukanisa uchungechunge nge- Isikhundla : kuma- Values ebhokisini lesigcawu sesibili , faka inombolo yezikhundla noma tincetu ezikhonjiswe eshadini elincane - 3 ubuncane;
• Hlukanisa uchungechunge nge- Value : ezimweni ezingaphansi kwebhokisi, faka inombolo ekulu kunenani elincane kunazo zonke lokubonisa idatha eshadini lesibini;
• Hlukanisa uchungechunge Ngenani lamaphesenti : kumanani angaphansi kwebhokisi, faka inani lamaphesenti phakathi kuka-0% no-100% - leli xabiso lihlobanisa namaphesenti okubaluleka kwenani eliyinhloko okufanele liboniswe eshadini lesibini.