Indlela yokudala nokuFometha Ishadi lePeyi kwi-Excel

Iitshathi ze-pie, okanye isangqa kwiigrafu njengoko zibizwa ngezinye izihlandlo, sebenzisa iipekisi zetekisi ukubonisa ipesenti okanye ixabiso lentengo leenkcukacha kwitshathi.

Njengoko zibonisa iimali ezihambelanayo, amashadi e-pie ayanceda ekuboniseni nayiphi na idatha ebonisa izixa ezihambelanayo kunye neentlobo eziphantsi kwexabiso elipheleleyo-njengokwenziwa komveliso omnye ngokuphathelele kwimveliso yenkampani ngokupheleleyo, okanye ingeniso eveliswa ngumnye umveliso onxulumene nokuthengiswa kwayo yonke imveliso yomgca.

Isangqa sesithati seepeyi silingana ne-100%. Icandelo ngalinye le-pie libhekiswa njengoluhlu kunye nobukhulu balo bubonisa ukuba yeyiphi inxalenye ye-100% emele yona.

Ngokungafani namanye amashadi, amashadi e-pie aqukethe uchungechunge olulodwa lweedatha , kwaye olu luchungechunge alukwazi ukufumana ixabiso elibi okanye elingu (0).

01 ngo-06

Bonisa ipesenteji ngeTyrt chart

Le tutorial ihlanganisa amanyathelo adingekayo ukudala nokufomathiza ityiti yeepeyi eboniswe kumfanekiso ongentla. Ishati ibonisa idatha enxulumene nokuthengiswa kwama-cookies ngo-2013.

Ishati ibonisa ixabiso lemali yokuthengisa nganye kwihlobo lecookie usebenzisa iilebula zedatha kunye nexabiso elixeleneyo ngalinye limelela imveliso yokuthengisa yonyaka.

Isitshathi siphinde sigxininise ukuthengisa kweekhikhi ze-lemon ngokutshitshisa eso siqwenga seesitile esivela kwabanye .

Inqaku kwi-Excel's Theme Colors

I-Excel, njengenkqubo zonke zeMicrosoft Office, isebenzisa iingqikithi ukusekwa kwimiqulu yayo.

Umxholo osetyenziswe kule khokelo ngumxholo oyi- Office .

Ukuba usebenzisa enye inqaku ngelixa ulandela le tutorial, imibala efakwe kumanyathelo okufundisa ayinakufumaneka kwimxholo oyisebenzisayo. Ukuba akunjalo, khetha nje imibala ekuthandeni kwakho njengabafaka indawo kwaye uqhubeke. Funda indlela yokujonga kwaye utshintshe umxholo wencwadi .

02 we-06

Ukuqala Ishadi lePie

Ukungena nokukhetha iData yeTutorial

Ukufaka idatha yetshathi kuhlala kuyisinyathelo sokuqala ekudaleni ishati - kungakhathaliseki ukuba yintoni na ishadi elenziweyo.

Isinyathelo sesibini sibonisa ukuba idatha iya kusetyenziswa ekudaleni ishati.

1. Faka idatha eboniswe kumfanekiso ngasentla kwiiseli zomsebenzi ezichanekileyo.
2. Emva kokungena, phawula uluhlu lweeseli ukusuka ku-A3 ukuya kwi-B6.

Ukudala i-Chart Basic Pie

Amanyathelo angezantsi aya kudala isatifiketi esisisiseko se-pie - isatifiketi esicacileyo, engaqinisekanga-esibonisa iindidi ezine zedatha, umxholo, kunye nesihloko esicatshulwa yetshathi.

Emva koko, ezinye zezixhobo ezifomathiweyo eziqhelekileyo zisetyenziselwa ukutshintsha isatshixo esisisiseko ukufanisa enye iboniswe kwiphepha 1 yale khokelo.

1. Cofa kwi- Insert ithebhu yebhebhoni .
2. Kwibhokisi yeSetyiti yebhebhoni, nqakraza kwi icon ye- Insert Pie Chart ukuvula uluhlu lokuhla kweentlobo zeesatriki ezikhoyo.
3. Hambisa isalathisi sakho semouse phezu kwengubo yetshathi ukuze ufunde inkcazo yetshathi.
4. Cofa kwi -Pie ye-3-D ukuze ukhethe isatidi esine-dimensional chart kwaye uyifake kwiphepha lokusebenzela.

Ukongeza Isihloko soTyati

Hlela isiKhadi seTyati esingagqibekanga ngokuchofoza kuso kabini kodwa ungaqakraza kabini.

1. Nqakraza kanye kwinqaku lechasi elikhethiweyo ukulikhetha - ibhokisi kufuneka ibonakale ngeenxa zonke kwigama lesiTyhuthi.
2. Cofa okwesihlandlo sesibini ukubeka i-Excel kwimodi yokuhlela , ebeka isikhombisi ngaphakathi kwebhokisi lebhokisi.
3. Cima itekisi engagqibekanga usebenzisa iifayile zokuCima / i-Backspace kwikhibhodi.
4. Faka isihloko seshati - I-Cookie Shop 2013 Imali evela kwiiNtengiso- kwi-bhokisi yebhokisi.
5. Beka isikhombisi phakathi kwe-2013 kunye neNgeniso kwisihloko kwaye cinezela ukhiye wokungena kwibhodibhodi ukuze uhlukanise isihloko kwisiqendu ezimbini.

03 we-06

Ukongeza iiLebhile zeDatha kwiChart Chart

Kukho amaninzi ahlukeneyo kwitshathi e-Excel - njengengingqi yecala equlethe ityiti yepayili emele i-series ekhethiweyo yedatha, umlandele, kunye nesihloko seetati kunye neelayibhile.

Zonke ezi ndawo zibhekwa njengezinto ezihlukeneyo kwinkqubo, kwaye, ngoko kunjalo, nganye inokufomelwa ngokuhlukileyo. Utshela i-Excel nayiphi inxalenye yetshathi ofuna ukuyifomatha ngokuchofoza kuyo nge-pointer ye mouse.

Kwimanyathelo alandelayo, ukuba iziphumo zakho azifani nazo ezidweliswe kwi-tutorial, kunokwenzeka ukuba awukho inxalenye efanelekileyo yetshathi ekhethiweyo xa ungeze ukhetho lokufomatha.

Impazamo eqhelekileyo eyenziwa ngokuchofoza kwindawo yesalathisi phakathi kwitektshi xa injongo ikhetha ishadi lonke.

Indlela elula yokukhetha iseshati yonke kukucofa kwikhohlo eliphezulu okanye ngakwesokudla ukusuka kwisihloko seshati.

Ukuba kukho impazamo, iyakulungiswa ngokukhawuleza usebenzisa isicatshulwa se-Excel sokulungisa umpazamo. Emva koko, nqakraza kwicala elifanelekileyo letshathi uze uzame kwakhona.

Ukongeza iiLebhile zeDatha

1. Nqakraza kanye kwinqanaba le-pie kwindawo yesalathini ukuyikhetha.
2. Nqakraza ngokuchanekileyo kwitshathi ukuvula imenyu yenkcazo yenkcazo yedatha.
3. Kwimenyu yomongo, gxuma imouse ngaphezu kwe- Add Add Labels option ukuze uvule imenyu yomxholo wesibini.
4. Kwimenyu yomxholo wesibini, nqakraza kwiZongeza iiLebhanki zeDatha ukuze ungeze ixabiso lezentengiso kwicookie nganye - kwisiqendu ngasinye se-pie kwitshathi.

Ukususwa kweGrade yeTrafik

Kwixesha elizayo, amagama amacandelo aya kufakwa kwiibhile zedatha kunye neendaluko ezikhoyo ngoku, ngoko ke, umyalezo ongaphantsi kwetshathi ayifuni kwaye ungasuswa.

1. Cofa kanye kwimbali engezantsi kwendawo yeqonga ukuyikhetha.
2. Cinezela ukhiye wokucima kwikhibhodi ukuze ususe umgca.

Kule ngongoma, ishati kufuneka ifane nomzekelo oboniswe kumfanekiso ongentla.

04 we-06

Ukutshintsha imibala kwiTebhu Yomxholo

Xa ityati idalwa kwi-Excel, okanye nayiphi na ikhetshi ekhoyo ekhethiweyo ngokuchofoza kuyo, iithebhu ezimbini ezongezelelweyo zongezwa kwibhoni njengoko kuboniswe kumfanekiso ongentla.

Ezi ithebhu zeTyrt Tools - ukuyila kunye nefomati - ziqukethe ukufomatha nokukhethwa kwindlela yokukhetha ngokuthe ngqo kwiitshathi, kwaye ziya kusetyenziswa kumanyathelo alandelayo ukufomathiza ityiti yeepeyi.

Ukutshintsha Umbala wee-Pie Slices

1. Cofa kwi-background yangesetyati ukuze ukhethe lonke isati.
2. nqakraza kwiNketho yoLuhlu lwemibala ekhohlo kwicala lasekhohlo lweTydi yoyilo yebhanethi ukuze uvule uluhlu oluphahlayo lokukhetha umbala.
3. Hambisa isalathisi semouse yakho phezu komqolo ngamnye wembala ukuze ubone igama lokukhetha.
4. Cofa kwiNketho yoMbala 5 kuluhlu - okokuqala kukhetho kwicandelo leMonochromatic kwoluhlu.
5. Iingqimba ezine zepayi kwitshati kufuneka zitshintshe kwiimpawu eziluhlaza.

Ukutshintsha Umbala weTrafik's Color

Kule nyathelo elithile, ukufomatha imvelaphi yinkqubo yezinyathelo ezibini kuba i-gradient yongezwa ukubonisa utshintsho oluthile kumbala ngokubonakalayo ukusuka phezulu ukuya ngasezantsi kwitshathi.

1. Cofa kwimvelaphi ukukhetha yonke isati.
2. Cofa kwi Fomati ithebhu yerbhoni.
3. Cofa kwi- Shape Fill option ukuze uvule iphaneli yokulahla yebala lokugcwalisa.
4. Khetha iBlue, Accent 5, Darker 50% ukusuka kwiCandelo leMbala leMbala yePaneli ukutshintsha umbala wektshi kumbala obomvu.
5. Cofa kwiCandelo lokugcwalisa ifom yexesha lesibini ukuvula iphaneli yehla yeClass.
6. Khupha isalathisi se mouse phezu kwekhetho elifutshane ngasezantsi kwoluhlu ukuvula iPanelient Gradient.
7. Kwiqendu leNguqulelo ebumnyama , nqakraza kwiNketho ye - Linear Up ukwengeza i-gradient ehamba phambili emnyama ukusuka phezulu ukuya phezulu.

Ukutshintsha Umbala Wombhalo

Ngoku ukuba imvelaphi imnyama ebomvu, umbhalo obumnyama ongezantsi awubonakali. Eli candelo lilandelayo litshintsha umbala wezobhaliweyo kwitshathi kumhlophe

1. Cofa kwimvelaphi ukukhetha yonke isati.
2. Cofa kwi Fomati ithebhu yebhebhoni xa kuyimfuneko.
3. Cofa kwiTekisi Gcwalisa inketho yokuvula uluhlu lokuhlahlela phantsi kweMbhalo.
4. Khetha i- White, Imvelaphi ye-1 ukusuka kwiCandelo leMbala ye-Color Colors .
5. Yonke itekisi kwiibhloko zetekisi kunye nedatha kufuneka zitshintshe zibe mhlophe.

05 ka 06

Ukongeza iCandelo lamagama kunye nokujikeleza iSatifiketi

Amanyathelo ambalwa alandelayo ekufundiseni asebenzise ifomathi yomsebenzi wokufomathiza , equle ininzi yeendlela zokufomatha ezikhoyo kwiitshathi.

Kwi-Excel ka-2013, xa isebenze, ikhefu ibonakala ngakwesokunene kwicala le-Excel kwesikrini njengoko kuboniswe kumfanekiso ongentla. Isihloko kunye neenketho ezibonakala kwiphetshana lokutshintsha ngokuxhomekeke kwingingqi yetshathi ekhethiweyo.

Ukongeza iCandelo lwamagama kunye nokuhambisa iiLebhile zeDatha

Eli nyathelo liya kwengeza igama lento nganye yecookie kwiibhile zedatha kunye nekhati yentengo okwangoku ibonisiwe. Kuya kuqinisekisa kwakhona ukuba iilebula zedata ziboniswa ngaphakathi kwetshathi ukuze kungabi nasidingo sokubonisa imizila yenkcubeko edibanisa ilebula kwisiqwenga sayo seshati yepayi.

1. Cofa kanye kwenye yeeleyibhile yedatha kwitshathi - zonke iileyile zedatha ezine kwitshathi mazikhethwe.
2. Cofa kwi Fomati ithebhu yebhebhoni xa kuyimfuneko.
3. Cofa kwikhetho lokukhethwa kwefomathi kwicala lesobunxele lebhanethi ukuvula ifomathi yomsebenzi wefomathi ngakwesokudla kwesikrini.
4. Ukuba kuyimfuneko, nqakraza kwi-icon yeenketho kwipaneli ukuvula iinketho zeleyile njengoko kuboniswe kumfanekiso ongentla.
5. Ngaphantsi kweleta Iqulethwe kwicandelo loluhlu, faka uphawu lokukhangela kwiCandelo Igama lokukhetha ukubonisa amagama amakhukhi kunye neemali zokuthengisa, kwaye ususe uphawu lokukhangela kwi- Show Shower Lines .
6. Ngaphantsi kweCandelo leNqaku leTeksi loluhlu, nqakraza ekupheleni kwe- Inside ukuhambisa zonke iilebula zedatha ezine emaphethelweni angaphandle zamacandelo abo etafile.

Ukujikeleza i-Pie Chart kwi-X kunye nee-Axes

Isinyathelo sokugqibela sokufometha siza kukurhawula okanye siphumelele iqhekeza lemon kwi-pie yonke ukuze siyigxininise kuyo. Okwangoku, itholakala phantsi kwesihloko sestya, kwaye uyikhupha ngaphandle ngeli xesha kule ndawo iya kukhwela kwisihloko.

Ukutshintshisa ishati kwi-X axis - ujikeleza ishati ngeenxa zonke ukuze ucezu lwemon ekhomba ngasezantsi kwinqanaba letshathi-luza kunika indawo eninzi yokuyiqhawula ngaphandle kwetshathi.

Ukujikeleza ishati kwi-axis ye-Y kuya kutsala ubuso beseshati phantsi ukwenzela ukuba kulula ukufunda iilebula zedatha kwiingcezu zeepayi phezulu kwetshathi.

Ngefayile yokufometha yomsebenzi ovulekileyo:

1. Nqakraza kamva kwitektha yetshathi ukuze ukhethe ishadi lonke.
2. Cofa kwi icon yeempembelelo kwifowuni ukuze uvule uluhlu lwezinto ezingakhetha kuzo.
3. Cofa kwi- 3-D Utshintsho kuloluhlu ukujonga iindlela ezikhoyo.
4. Hlela ukujikeleza kwe- X ukuya kwi-170 ^o ukuza kutshintshisa ishati ukuze iqela lemon lijongane nekona lokunene lesitehlo.
5. Beka i- Y Ukujikeleza ukuya kwi-40 ^o ukukrazula ubuso beseshati phantsi.

06 we-06

Uhlobo lokuguqula iiPolisi kunye noPhuculo lweSahluko seTyati

Ukutshintsha ubukhulu kunye nohlobo lwefonti elisetyenziswe kwitshathi, akusayi kuphucuka kuphela kwipolisi engagqibekanga esetyenziswe kwitshathi, kodwa kuya kwenza kube lula ukufunda amagama amacandelo kunye nexabiso lwedatha kwitshati.

Qaphela : Ubungakanani befonti bulinganiselwa kumaphuzu -wafowunwe athotshelwe kwi- pt .
Umbhalo we-pt wama-72 ulingana no-intshi enye-2.5 cm - ngobukhulu.

1. Cofa kanye kwihloko yetshathi ukuze ukhethe.
2. Cofa kwiThebhu yasekhaya yerbhoni.
3. Kwifayile yefonti yebhebhoni, nqakraza kwibhokisi yePolisi ukuvula uluhlu lokuhlahla lwamagama afumanekayo.
4. Skrolela ufumane kwaye uqhosha kwifonti yeBritannic Bold kwoluhlu ukuguqula isihloko kule fom.
5. Kwiphepha lefonti elisecaleni kwebhokisi lefonti, setha ubungakanani befayili yesitayela kwi-18 pt.
6. Cofa kanye kwiileyibhile zedatha kwitshathi ukukhetha zonke iilebula ezine.
7. Ukusebenzisa amanyathelo angentla, setha iilebula zedatha kwi-12 pt Britannic Bold.

Ukuxhaphaza i-Piece ye-Pie Chart

Isinyathelo sokugqibela sokufometha ukutsala okanye ukuqhuma isakram lemon kwi-pie yonke ukuze ugxininise kuyo.

Emva kokuqhaqha isiqhekeza se- lemon , zonke iitshathi zeepeya ziya kuncipha ngobukhulu ukuze zilungele ukutshintsha. Ngenxa yoko, kunokuba kuyimfuneko ukubeka kwakhona elinye okanye ezininzi zeeleyibhile zedatha ukuzibeka ngokupheleleyo ngaphakathi kwamacandelo abo.

1. Nqakraza kanye kwinqanaba le-pie kwindawo yesalathini ukuyikhetha.
2. Cofa kanye kwiqhekeza le- lemon yetshathi yeepeyi ukukhetha kuphela icandelo leseshati - qinisekisa ukuba ucezu lwimilo kuphela lujikelezwe ngamachaphaza amancinci amancinci.
3. Cofa uze udibanise isiqhekeza seLeyiphu ephuma kwiteyiti yepayi ukuze uyichithe.
4. Ukubeka kwakhona itekisi yedatha, nqakraza kanye kwilebula yedatha - zonke iilebula zedatha mazikhethwe.
5. Cofa okwesibini kwileyibhile yedatha ukuba uhanjiswe uze uyihusele endaweni efunwayo.

Kule ngongoma, ukuba ulandele onke amanyathelo kule khokelo, ishati yakho kufuneka ifane nomzekelo oboniswe kwiphepha 1 le-tutorial.