Ungadala kanjani futhi Ufake Ishadi Lama-pie ku-Excel

Amashadi we-pie, noma umbuthano wegrafu njengoba kuthiwa ngezinye izikhathi aziwa, sebenzisa tincetu ze-pie ukukhombisa iphesenti noma inani elilinganiselwe lwedatha eshadini.

Njengoba kubonisa inani elilinganiselwe, amashadi we-pie awusizo ekuboniseni noma iyiphi idatha ebonisa inani elilinganiselwe lezinkampani ezincane ngokumelene nenani eliphelele - njengokukhiqizwa kwefayili eyodwa ngokuphathelene nokukhishwa kwenkampani yonke, noma imali okhiqizwa umkhiqizo owodwa ngokuphathelene nokuthengiswa kwayo yonke umugqa womkhiqizo.

Umbuthano weshadi lephayi lilingana no-100%. Ingxenye ngayinye ye-pie ibizwa ngokuthi isigaba futhi ubukhulu bayo bubonisa ukuthi iyiphi ingxenye ye-100% emele yona.

Ngokungafani namanye amashadi amaningi, amashadi we-pie aqukethe uchungechunge olulodwa lwedatha , futhi lolu chungechunge alukwazi ukuqukatha amanani amabi noma ama-0 (0).

01 ka-06

Bonisa Amaphesenti nge-Pie Chart

Lesi sifundo sihlanganisa izinyathelo ezidingekayo zokudala nokufometha ishadi lephayi eliboniswe esithombeni ngenhla. Ishadi libonisa idatha ehlobene nokuthengiswa kwamakhukhi ngo-2013.

Ishadi libonisa kokubili inani lemali yokuthengisa ngohlobo ngalunye lwekhukhi usebenzisa amalebula wedatha kanye nenani elilinganiselwe ngalinye isakhiwo se-total sales sales for the year.

Ishadi libuye ligcizelele ukuthengisa kwama-cookie ka-lemon ngokuqhuma leyo ngxenye yeshadi lephayi kusuka kwabanye .

Inothi kwi-Excel's Theme Colors

I-Excel, njengezinhlelo zonke ze-Microsoft Office, isebenzisa izingqikithi ukubeka ubukeka bezincwadi zayo.

Isihloko esetshenziselwa lesi sifundo yisihloko se- Office esizenzakalelayo.

Uma usebenzisa enye indaba elandelayo ngenkathi ulandela le tutorial, imibala efakwe ezinyathelweni zokufundisa kungenzeka ingatholakali engqikithi oyisebenzisayo. Uma kungenjalo, khetha nje imibala ekuthandeni kwakho njengama-substitute futhi uqhubeke. Funda ukuthi ungabheka kanjani futhi ushintshe isihloko samanje somsebenzi .

02 ka 06

Ukuqala Ishadi Le-Pie

Ukufaka nokukhetha Idatha Yezokufundisa

Ukufaka idatha yeshadi kuhlale kuyisinyathelo sokuqala ekudaleni ishadi - kungakhathaliseki ukuthi yiluphi uhlobo leshadi oludalwa.

Isinyathelo sesibili sigcizelela idatha okufanele isetshenziswe ekudaleni ishadi.

1. Faka idatha ekhonjiswe esithombeni ngenhla kumaseli afanele okushicilela .
2. Uma usufakiwe, qokomisa ububanzi bamaseli kusuka ku-A3 kuya ku-B6.

Ukudala ishadi eliyisisekelo le-Pie

Izinyathelo ezingezansi zizokwenza ishadi eliyisisekelo le-pie - ishadi elicacile, elingashintshiwe - elibonisa izigaba ezine zedatha, umlando, kanye nesihloko seshadi elizenzakalelayo.

Ngemva kwalokho, ezinye zezici zokufometha ezivame ukusetshenziswa zisetshenziselwa ukushintsha ishadi eliyisisekelo ukufanisa eliboniswe ekhasini 1 lale tutorial.

1. Chofoza ku- Faka ithebhu ye- ribbon .
2. Ebhokisini Lamashadi webhebhoni, chofoza isithonjana se- Insert Pie Chart ukuvula uhlu oludonsela phansi lwezinhlobo zeshadi ezitholakalayo.
3. Hambisa isikhombisi sakho segundane phezu kohlobo lweshadi ukuze ufunde incazelo yeshadi.
4. Chofoza ku- 3-D Pie ukuze ukhethe ishadi le-pie lesithathu eliyingxenye bese ulifaka ekhasini lokusebenzela.

Ukungeza isihloko seshadi

Hlela isihloko seShadi elizenzakalelayo ngokuchofoza kukho kabili kodwa ungachofoli kabili.

1. Chofoza kanye esihlokweni seshadi elizenzakalelayo ukulikhetha - ibhokisi kufanele livele kuzungeze isihloko seThikhthi.
2. Chofoza okwesibili ukubeka i-Excel kumodi yokuhlela , ebeka isikhombisi ngaphakathi kwebhokisi lesihloko.
3. Susa umbhalo ozenzakalelayo usebenzisa okhiye we- Delete / Backspace ekhibhodi.
4. Faka isihloko seshadi - I-Cookie Shop 2013 Imali evela ku-Sales - ebhokisini lesihloko.
5. Faka isikhombisi phakathi kuka-2013 ne-Revenue esihlokweni bese ucindezela ukhiye we-Enter ekhibhodi ukuze uhlukanise isihloko kuya emigqeni emibili.

03 ka 06

Ukungeza amalebula wedatha kwi-Pie Chart

Kunezingxenye eziningi ezihlukene eshadini ku-Excel - njengendawo yendawo ephethe ishadi lephayi elimele uchungechunge lwedatha olukhethiwe, i-legend, nesihloko seshadi namalebula.

Zonke lezi zincenye zibhekwa njengezinto ezihlukene yihlelo, futhi, ngaleyo ndlela, ngayinye ingenziwa ifomathiwe ngokwehlukana. Utshela i-Excel ukuthi iyiphi ingxenye yeshadi ofuna ukuyifometha ngokuchofoza kuyo nge-pointer yegundane.

Ezinyathelweni ezilandelayo, uma imiphumela yakho ingafani nalabo ababalwe kusifundo, cishe kungenzeka ukuthi awunayo ingxenye efanele yeshadi elikhethiwe uma ungeze ukhetho lokufometha.

Iphutha elivame ukwenziwa ngokuchofoza indawo yesakhiwo phakathi kweshadi uma inhloso ukukhetha ishadi lonke.

Indlela elula yokukhetha ishadi lonke ukuchofoza ngakwesokunxele noma ngakwesokudla ngakwesokudla kude nesihloko seshadi.

Uma kwenzeka iphutha, lingalungiswa ngokushesha usebenzisa isici sokuhlehlisa i-Excel ukulungisa iphutha. Ngemva kwalokho, chofoza ngakwesokudla kweshadi uphinde uzame futhi.

Ukwengeza Amalebula Wedata

1. Chofoza kanye eshadini lephayi endaweni yesakhiwo ukuze ukhethe.
2. Chofoza ngakwesokudla eshadini ukuvula imenyu yenkomfa yenkomfa yedatha.
3. Kumenyu yesimo, hlela igundane ngaphezu kwenketho yokwengeza idatha yamagama ukuze uvule imenyu yesibili yesimo.
4. Kumenyu yesibili yomongo, chofoza ku- Engeza Amalebula Wedatha ukuze ungeze amanani okuthengisa kumakhukhi ngayinye - kunoma yikuphi uhlaka lwe-pie eshadini.

Ukususa i-Legend Ishadi

Esikhathini esilandelayo, amagama omkhakha azokwengezwa kumalebula wedatha kanye namagugu okwamanje abonisiwe, ngakho-ke, inganekwane engezansi ishadi ayidingi futhi ingasuswa.

1. Chofoza kanye kwendlalelo engezansi endaweni yesakhiwo ukuze ukhethe.
2. Cindezela ukhiye wokususa ekhibhodi ukuze ususe umlando.

Kuleli phuzu, ishadi lakho kufanele lifane nesibonelo esiboniswe esithombeni ngenhla.

04 ka 06

Imibala Eshintshayo kuthebhu yefomethi

Uma ishadi lidalwe ku-Excel, noma noma nini lapho ishadi elikhona likhethwa ngokuchofoza kukho, amathebhu amabili engeziwe angeziwe kubhande njengoba kuboniswa esithombeni ngenhla.

Lezi ithebhu zamathuluzi we-Chart - ukuklama nokufometha - zinezinketho zokufometha kanye nezinketho ngokuqondile ngamashadi, futhi zizosetshenziswa kulezi zinyathelo ezilandelayo ukufometha ishadi lephayi.

Ukushintsha Umbala wezinhlamvu ze-pie

1. Chofoza kusemuva leshadi ukuze ukhethe ishadi lonke.
2. chofoza inketho ye- Change Colors ehlangothini lwesobunxele beThe Design ithebhu yebhande ukuze uvule uhlu lokudonsa lokukhetha kombala.
3. Hambisa isikhombisi sakho segundane phezu komugqa ngamunye wembala ukuze ubone igama lokukhetha.
4. Chofoza ku- Okthoba 5 ukhetho ohlwini - okokukhetha kuqala esigabeni se- Monochromatic ohlwini.
5. Iziqephu ezine zokupaka eshadini kufanele zishintshe ku-shade ezihlukahlukene eziluhlaza okwesibhakabhaka.

Ukushintsha Umbala Wendatshana Yomdwebo

Kulesi sinyathelo esithile, ukufometha isizinda kuyisinyathelo esinezinyathelo ezimbili ngoba i-gradient yengezwa ukukhombisa izinguquko ezincane ngombala ngokuqondile ukusuka phezulu kuya phansi eshadini.

1. Chofoza ngemuva ukuze ukhethe ishadi lonke.
2. Chofoza kuthebhu yefomathi yedibhoni.
3. Chofoza ku-Option Shape Fill ukuze uvule iphaneli yehla ye-Fill Colors.
4. Khetha i- Blue, i-Accent 5, i-Darker 50% kusukela kusigaba se- Theme Colors sephaneli ukuze ushintshe umbala wesizinda sangasese kuluhlaza okwesibhakabhaka.
5. Chofoza ku-Option Shape Fill option okwesibili ukuvula iphaneli yehla ye-Colors.
6. Hambisa isikhombisi segundane ngenketho ye- Gradient ngasekugcineni kohlu ukuze uvule iphaneli elikhulu.
7. Esigabeni Sokushintsha Okubumnyama , chofoza inketho ye- Linear Up ukwengeza i-gradient eqhubeka ijubane kancane kusukela phansi kuya phezulu.

Ukushintsha Umbala Wombhalo

Manje ukuthi ingemuva ibumnyama okwesibhakabhaka, umbhalo omnyama ozenzakalelayo awubonakali. Lesi sigaba esilandelayo sishintsha umbala wazo wonke umbhalo eshadini ukuze umhlophe

1. Chofoza ngemuva ukuze ukhethe ishadi lonke.
2. Chofoza kuthebhu yefomethi yebhebhoni uma kunesidingo.
3. Chofoza kwikhombandlela Yokugcwalisa Umbhalo ukuvula uhlu lwe-Down Colors lwehla.
4. Khetha Okumhlophe, Ingemuva 1 kusukela kusigaba se- Theme Colors ohlwini.
5. Yonke imibhalo yamalebula wethimba nedatha kufanele ishintshe ibe mhlophe.

05 ka 06

Ukwengeza Amagama Omkhakha nokuguqula Ishadi

Izinyathelo ezimbalwa ezilandelayo zesifundo zisebenzisa isitayela somsebenzi wokufometha , esinezinketho eziningi zokufometha ezitholakalayo zamashadi.

Ku-Excel 2013, uma kusebenziwe, i-paneli ibonakala ngakwesokudla ngakwesokunxele kwesikrini se-Excel njengoba kuboniswe esithombeni ngenhla. Isihloko kanye nezinketho ezivela ekuguquleni kwesimo sezansi kuncike endaweni yeshadi elikhethiwe.

Ukwengeza amagama wamagama nokuhambisa amalebula wedatha

Lesi sinyathelo sizofaka igama lohlobo ngalunye lwekhukhi kumalebula wedatha kanye nekhwama lentengo okwamanje elibonisiwe. Kuzoqinisekisa nokuthi amalebula wedatha aboniswa ngaphakathi kweshadi ngakho ngeke kube nesidingo sokubonisa imigqa yomholi ehlanganisa ilebula kwisigaba sayo esithile sehadi lephayi.

1. Chofoza kanye kwenye yamalebula wedatha eshadini - wonke amalebula amane wedatha eshadini kufanele akhethwe.
2. Chofoza kuthebhu yefomethi yebhebhoni uma kunesidingo.
3. Chofoza kuKhetho Lokukhethwa Kwefomathi ngakwesokunxele kwebhande ukuze uvule i- Postting Task pane ehlangothini lwesokudla kwesikrini.
4. Uma kunesidingo, chofoza inkinobho yezinketh in the pane ukuze uvule izinketho zelebula njengoba kuboniswe esithombeni ngenhla.
5. Ngaphansi kwegama eliqukethe isigaba sohlu, engeza uphawu lokungena ohlwini lwegama le- Category ukuze ubonise amagama we-cookie kanye nemali yokuthengisa, bese ususa uphawu lokuhlola kusuka ku- Show Leader Lines .
6. Ngaphansi kwesigaba se- Label Position ohlwini, chofoza ku- Inside ekugcineni ukuhambisa amalebula amane wedatha engxenyeni yangaphandle yezingxenye zawo ezisheshayo zeshadi.

Ukushintshanisa ishadi le-Pie ku-X no-Y Axes

Isinyathelo sokugcina sokufometha sizoba ukuhudula noma ukuxhaphaza ucezu lwamalamula kusuka kuwo wonke amapayi ukuze ungeze ugcizelele kulo. Njengamanje, itholakala ngaphansi kwesihloko seshadi, futhi uyidonsela ngaphandle ngenkathi kulesi sikhundla iyobe ibhekene nesihloko.

Ukushintshanisa ishadi ku-axis X - ukuvula ishadi elizungezile ukuze ucezu lwelamula lukhomba ngasekhoneni elingezansi ngakwesokudla leshadi - kuzonikeza isikhala esiningi sokuyixosha kuleso sonke ishadi.

Ukushintshanisa ishadi kwi-axis Y kuzokhipha ubuso beshadi phansi ukuze kube lula ukufunda amalebula wedatha ezinkantweni ze-pie phezulu kweshadi.

Ngomdwebo womsebenzi wokufometha ovuliwe:

1. Chofoza kanye kwirekhodi leshadi ukuze ukhethe ishadi lonke.
2. Chofoza kusithonjana se- Effects esithombeni ukuze uvule uhlu lwezinketho zomphumela.
3. Chofoza ku -3D-Rotation ohlwini ukuze ubuke izinketho ezitholakalayo.
4. Hlela ukushintshwa kwe- X kuya ku-170 ^o ukufaka ishadi ukuze uhlaka lwelamula lubheke ngakwesokudla kwesokudla kweshadi.
5. Beka i- Y Ukushintshela ku-40 ^o ukudonsa ubuso beshadi phansi.

06 ka-06

Ukushintsha Amafonti Uhlobo Nokuxhaphaza Ingxenye Yesiqeshana

Ukushintsha usayizi nohlobo lwefonti elisetshenziswe eshadini, ngeke lube ngcono kuphela phezu kwefonti ezenzakalelayo esetshenziswe eshadini, kodwa kuzokwenza kube lula ukufunda amagama wesigaba namanani wedatha eshadini.

Qaphela : Ubukhulu befonti bulinganiswa kumaphoyinti -wafingqiwe kufinyelelwe ku- pt .
Umbhalo we-pt angu-72 ulingana no-intshi - 2.5 cm - ngobukhulu.

1. Chofoza kanye esihlokweni seshadi ukuze ukhethe.
2. Chofoza kuthebhu yaseKhaya ye-ribbon.
3. Engxenyeni yefonti yebhande, chofoza ebhokisini lefonti ukuvula uhlu lokudonsa phansi lwamafonti atholakalayo.
4. Pheqa ukuze uthole futhi uchofoze kufolda i- Britannic Bold kuhlu ukuze ushintshe isihloko kule fonti.
5. Ebhokisini lefonti eliseduze kwebhokisi lefonti, setha isihloko samagama wefonti ku-18 pt.
6. Chofoza kanye kumalebula wedatha eshadini ukuze ukhethe wonke amalebula amane.
7. Ukusebenzisa izinyathelo ezingenhla, setha amalebula wedatha ku-12 pt Britannic Bold.

Ukusebenzisa i-Piece of the Pie Chart

Lesi sinyathelo sokugcina sokufometha ukuhudula noma ukuxhaphaza isiqephu selamula kuwona wonke ophayi ukufaka ukugcizelela kuso.

Ngemva kokuqothula ucezu le- Lemon , lonke ishadi lephayi lizohlehliswa ngosayizi ukuze lenze ushintsho. Ngenxa yalokho, kungase kudingekile ukubeka kabusha amanye amalebula wedatha ukuze uwabeke ngokugcwele ngaphakathi kwezigaba zawo.

1. Chofoza kanye eshadini lephayi endaweni yesakhiwo ukuze ukhethe.
2. Chofoza kanye kwi- lelice le- Lemon yeshadi lephayi ukuze ukhethe nje leso sigaba seshadi - qiniseka ukuthi kuphela ucezu lwamakhemikhali elizungezwe amachashazi amancane okugqamile.
3. Chofoza uphinde uhudule i- leqamu le- Lemon kusuka eshadini lephayi ukuze ulichithe.
4. Ukuze ubuyekeze ilebuli yedatha, chofoza kanye kwilebuli yedatha - wonke amalebula wedatha kufanele akhethwe.
5. Chofoza okwesibili kuthebula lwedatha ukuthi lihanjiswe bese ulihudula endaweni oyifunayo.

Kuleli phuzu, uma ulandele zonke izinyathelo kulolu hlelo, ishadi lakho kufanele lifanise isibonelo esiboniswe ekhasini 1 lesifundo.