Tshintsha iikholamu yemibala kunye ne-Show Percent Data Labels

Ngokuqhelekileyo, igradi yekholomu okanye ibrafu ibonisa inani okanye inani lexesha elixabisekileyo lenzeke ngexesha elimiselweyo. Ubude bekholomu, inani elikhulu leexesha eliza kwenzeka.

Ukongeza, itshati idla ngokubonisa uluhlu lweedatha ezininzi kunye nekholamu nganye kwichungechunge lufana nombala ofanayo.

Ukusebenzisa iifomati zokufomatha ezifumaneka kwi-Excel, kunokwenzeka ukuba nekhodi yekholomu zifanise ityati yepayi kunye nokubonisa

Ukulandela amanyathelo kule khokelo kukuhamba ngokudala nokufomathiza iseshati yekholomu eboniswe kumfanekiso ongentla.

Phawula:
* Ukuba unomdla kuphela ekutshintsheni iilebula zedatha ukubonisa i-percents, ulwazi lunokufumaneka kwiphepha 3 lale tutitshala
* Ukutshintsha imibala yekholomu kungafumaneka kwiphepha 4

01 ngo-06

Izinyathelo ezi-6 zokwenza iKhadi lekholamu kwi-Excel

Tshintsha imibala kunye ne-Show Percents kwiTylate yekholeji ye-Excel. © Ted French

Inqaku kwi-Excel's Theme Colors

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

Umxholo osetyenziswe kule khokelo ngumxholo wohlobo lweThuthi.

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.

02 we-06

Ukuqala Ishadi lekholamu

Tshintsha imibala kunye ne-Show Percents kwiTylate yekholeji ye-Excel. © Ted French

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 Isatifiketi seKholamu esiSeko

Amanyathelo alandelayo aya kudala ishadi lomgca wesiseko - isatifiketi esicacileyo, engaqinisekanga-esibonisa uluhlu lweenkcukacha ezikhethiweyo kunye neexes.

Amanyathelo emva kokudala isicatshulwa esisiseko sokusebenzisa iindlela ezithile zokufomathiza eziqhelekileyo, eziya kuthi zilandelwe, ziza kutshintshisa isatiyibrari yokutshatya iseshati yekholomu eboniswe kwiphepha 1 yale khokelo.

  1. Cofa kwi- Insert ithebhu yebhebhoni
  2. Kwibhokisi yeSetyiti yebhebhoni, nqakraza kwi- Isalathisi yeKhadi leKholam yokufaka ukuvula uluhlu olwehlayo lweentlobo zegrafu / iintlobo zetshathi.
  3. Hambisa isalathisi sakho semouse phezu kwengubo yetshathi ukuze ufunde inkcazo yetshathi
  4. Cofa kwiColumn Clustered - ukhetho lokuqala kwicandelo le-2-d Ikholam yohlu - ukuyikhetha
  5. Isalathisi esisiseko sekholomu sidalwa kwaye sifakwe 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 sesitifiketi - i- Julayi 2014 Iindleko - kwibhokisi yebhokisi

03 we-06

Ukongeza iiLebhile zeDatha njengePercents

Tshintsha imibala kunye ne-Show Percents kwiTylate yekholeji ye-Excel. © Ted French

Ukuchofoza kwiCandelo elingalunganga leShadi

Kukho amaninzi ahlukeneyo kwitshati e-Excel - njengendawo yecala equlethe iikholomu ezimele uchungechunge lweedatha ezikhethiweyo, izikhwama ezicwangcisiweyo kunye nezicatshulwa, isihloko seetati kunye nealebula, kunye neegalari ezigciniweyo.

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 kwergraph xa injongo ikhetha yonke igrafu.

Indlela elula yokukhetha igrafu yonke ucofa kwikona 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. Cofa kanye kwizinto ezikhoyo kwikholam kwitshathi - zonke iikholomu ezine kwitshati mazikhethwe
  2. Chofoza ngokuchanekileyo kwiMpahla yohlulo ukuvula imenyu yenkcazo yenkcazo yedatha
  3. Kwimenyu yomongo, gxuma imouse ngaphezu kwe- Add Add Labels option ukuze uvule imenyu yomxholo wesibini
  4. Kwimenyu yesibini yesiqhosha, nqakraza kwieDareli zeDatha zoLwazi ukuze ungeze iileyile zedatha ngaphezu kwekholam nganye kwitshathi

Ukutshintsha iiLebhile zeDatha ukubonisa ipesenti

Iibhile zamanqaku ezikhoyo zingaguqulwa ukuze zibonise ipesenti nganye ikholomu kwitshati imela iindleko zesebenzisa ngokubhekisele kweseli yeefesenti ezidweliswe kwikholamu C yedatha yedata kwifom .

Iilebula zedatha ezizenzakalelayo ziya kulungiswa ngokuchofoza kabini enye nganye, kodwa, kwakhona, ungaqakraza kabini.

  1. Cofa kanye kwi- ileyile yedatha ye- 25487 ngaphaya kweMpahla yohlulo kwitshathi - zonke iileyile zedatha ezine kwitshathi mazikhethwe
  2. Cofa okwesihlandlo sesibini kwiileyibhile yedatha yezinto eziphathekayo - kuphela i- label ye - 25487 yedatha kufuneka ikhethwe
  3. Cofa kanye ngebhayibha yefomula ngaphantsi kwebhebhoni
  4. Faka ifom = = C3 kwibha yefom kwaye cinezela iqhosha lokungena kwikhibhodi
  5. I-label ye- 25487 yedatha kufuneka ishintshele ukufunda i- 46%
  6. Cofa kanye kwi- ileyile yedatha ye- 13275 ngaphaya kwekholam yokusebenza kwi- tshatari- kuphela yileta yedata kufuneka ikhethwe
  7. Faka okulandelayo ifom = C4 kwibha yefomula uze ucine iqhosha lokungena
  8. Iileyibhile yedata kufuneka iguqule ukufunda i- 24%
  9. Cofa kanye kwi- ileyile yedatha ye- 8547 ngaphaya kwekholam yezothutho kwitshathi-kuphela yile ileta yedata kufuneka ikhethwe
  10. Faka ifom elandelayo = C5 kwibha yefom uze ucine iqhosha lokungena
  11. Iileyibhile yedata kufuneka iguqule ukufunda i- 16%
  12. Cofa kanye kwi- ilebhu yedatha ye- 7526 ngaphaya kwekhompyutheni yezinto zokusebenza kwindawo yetshathi-kuphela yile ileta yedata kufuneka ikhethwe
  13. Faka okulandelayo ifom = C6 kwibha yefomula uze ucinezela ukhiye wokungena
  14. Iileyibhile yedata kufuneka iguqule ukufunda i- 14%

Ukususa iiGridlines kunye neeLebhu zeAxis eziPhezulu

  1. Kwitshathi, nqakraza kanye kwi-20,000 yegridline ehamba phakathi kwegrafu - zonke iifayile zegridi kufuneka zigqitywe (iibhululo eziluhlaza okwesibhakabhaka ekupheleni kwegridline nganye)
  2. Cinezela ukhiye wokucima kwikhibhodi ukucima ii-gridlines
  3. Cofa kanye kwiileyibhile ze-axis ze-Y - iinombolo ezibhekise kwicala lasekhohlo ishadi-ukuzikhetha
  4. Cinezela iqhosha lokucima kwikhibhodi ukuze ususe ezi lebhile

Kule ngongoma, ukuba onke amanyathelo angentla alandelwe, ishadi lakho lekholomu kufanele lifane neesati kumfanekiso ongentla.

04 we-06

Ukutshintsha iKhadi leKholamla imibala kunye neNgcali

Ukutshintsha i-Colour Column Colors. © Ted French

Iimpawu zeTyrt Tools

Njengoko kuboniswe kumfanekiso ongentla, xa isatshati sidalwa kwi-Excel, okanye nayiphi na isati ekhoyo ekhethiweyo ngokuchofoza kuyo, iithebhu ezongezelelweyo zongezwa kwi- Ribbon .

Ezi ithebhu zeTyrt Tools - ukuyila kunye nefomathi - ziququzelele ukufomathiza kunye neendlela zokukhethwa ngokuthe ngqo kwiitshathi, kwaye ziya kusetyenziswa kula ma nyathelo alandelayo ukugqiba ididi yekholomu.

Ukutshintsha i-Colour Column Colors

Ukongezelela ekutshintsheni umbala wekholam nganye kwitshathi, i-gradient yongezwa kwikholam nganye ukwenza ifomathi nganye kwinkqubo yezinyathelo ezimbini.

  1. Cofa kanye kwizinto ezikhoyo kwikholam kwitshathi - zonke iikholomu ezine kwitshati mazikhethwe
  2. Cofa okwesihlandlo sesibini kwiMpahla yohlulo kwitshathi - kuphela iikholeji zoMsebenzi kufuneka zikhethwe
  3. Cofa kwi Fomati ithebhu yerbhoni
  4. Cofa kwi- Shape Fill icon ukuze uvule imenyu yokugcwalisa imibala
  5. Kwinqanaba le- Colours eliqhelekileyo lemenyu khetha iBlue
  6. Cofa kwi- Shape Fill option okwesibini ukuvula kwakhona imenyu
  7. Ukuhambisa umgca we mouse phezu kwekhetho elifutshane ngasezantsi kwimenyu ukuvula imenyu ye-Gradient
  8. Kwiqhosha lokuKhanya koMbane weMenyu eyi- Gradient , nqakraza kwindlela yokuqala ( Uluhlu oluxubileyo - Ukhohlo oluphezulu ukuya ngasekunene ) ukuze ungeze lo mgca kwiiNkcukacha zoMsebenzi
  9. Cofa kanye kwiikholamu zeeUtilities kwikholam ye- Utilities kuphela
  10. Cofa kwi icon ye Shape Fill uze ukhethe obomvu ukusuka kwicandelo eliqhelekileyo lemibala kwimenyu
  11. Phinda amanyathelo 6 ukuya ku-8 ngasentla ukuze ungeze i-gradient kwikholam ye- Utilities
  12. Cofa kanye kwikholam yeThutho uze uphinde uphendule amanqanaba 10 no-11 ngasentla ukuze utshintshe ikholomu yezothutho ukuya kwiGreen uze ungeze i-gradient
  13. Cofa kanye kwiSikholamu soMxhobo kunye nokuphinda amanyathelo 10 no-11 ngaphezulu ngenjongo yokutshintsha iikhomputha yezixhobo kwi- Purple kwaye ukongeza i-gradient
  14. Imibala yee-columns ezine kwitshathi kufuneka ngoku idibanise nalawo aboniswe kumfanekiso kwiphepha 1 le-tutorial

Ukongeza iThe Legend kunye nokuSusa ii-Axis Labels

Ngoku ukuba nganye ikholomu ngumbala ohlukileyo, umgca unokuba wongezwa ngaphantsi kwesihloko seetati kunye neileyile ze-axis ze-X ngaphantsi kwetshathi zisusiwe

  1. Cofa kwi-background yangesetyati ukuze ukhethe lonke isati
  2. Cofa kwiThebhu yoyilo yerbhoni
  3. Cofa kwi-icon ye- Chart Element icon kwicala lasekhohlo lebhandi ukuvula imenyu ehlayo
  4. Khetha Umgca> Phezulu ukusuka kwoluhlu ukufaka umgca ongentla kwendawo yesalathisi
  5. Cofa kanye kwiibhile ze-axis ze-X - amagama ekholam ngaphantsi kwetshathi-ukuyikhetha
  6. Cinezela iqhosha lokucima kwikhibhodi ukuze ususe ezi lebhile

05 ka 06

Ukuhambisa iiLebhankile zeDatha nokuKhula iikholeji zeTyrt

Tshintsha imibala kunye ne-Show Percents kwiTylate yekholeji ye-Excel. © Ted French

Ukufomatha Ikhefu Lomsebenzi

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.

Ukuhambisa iiLebhile zeDatha

Eli nyathelo liya kuhambisa iilebhile zedatha ngaphakathi kwikholam nganye.

  1. Cofa kanye kwi-ileyibhile yedatha ye- 64% ngaphaya kwekhompyutheni yezinto eziphathekayo kwitshathi - zonke iileyile zedatha ezine kwitshathi mazikhethwe
  2. Cofa kwi Fomati ithebhu yebhebhoni xa kuyimfuneko
  3. Cofa kwikhetho lokukhethwa kwefomathi kwicala lesobunxele lebhanethi ukuvula ifowuni yefomathi yokuFometha ngakwesokudla kwesikrini
  4. Ukuba kuyimfuneko, nqakraza kwi-icon yeenketho kwipaneli ukuvula iinketho zeleyile njengoko kuboniswe kumfanekiso ongentla
  5. Cofa kwikhetho lokungena ngaphakathi ngaphakathi kwendawo yebhanki kwindawo yefowuni ukuhambisa zonke iileyile zedatha ezine ngaphakathi kwimiqolo yazo

Ukwandisa iikholeji zeTyrt

Ukwandisa iikholeji zetshathi kuya kusenza sikwandise ubungakanani bombhalo weilebula zedatha, okwenza kube lula ukufunda.

Ngefayile yokuSebenza yokuvula,

  1. Cofa kanye kwiMpahla yohlulo kwitshathi - zonke iikholomu ezine kwitshati kufuneka zikhethwe
  2. Ukuba kuyimfuneko, nqakraza kwi-icon yeenketho kwipakethe ukuze uvule iinketho zechungechunge
  3. Beka ububanzi beGap ukuya kwi-40% ukunyusa ububanzi bazo zonke iikholomu ezine kwitshati

Ukongeza iSithunzi kwiKholamu nganye

Isinyathelo siya kwandisa isithunzi emva kweekholamu nganye kwitshathi.

Ngefayile yokuSebenza yokuvula,

  1. Cofa kanye kwiMpahla yohlulo kwitshathi - zonke iikholomu ezine kwitshati kufuneka zikhethwe
  2. Cofa kanye kwi icon yeempembelelo kwifomathi yokufomathiza ukuvula ukhetho lweetekisi
  3. Cofa kanye kwiShadow ukuvula ukukhetha izithunzi
  4. Vula iphaneli yepakethi ye-preset ngokuchofoza uphawu lwe- Presets
  5. Kwinqanaba lempembelelo , nqakraza kwi- Perspective Diagonal Upper Right icon
  6. Isithunzi kufuneka sibonakale emva kweekholamu zetshathi nganye

06 we-06

Ukongeza Umbala weMvelaphi yeMbala kunye nokuFometha umbhalo

Imvelaphi yeGrade Options. © Ted French

Ukongeza Umbala weMvelaphi yeMbala

Eli nyathelo liya kwengeza umbala webala kumbindi usebenzisa iindlela kwifayile yokuSebenza ifomathi njengoko kuboniswe kumfanekiso ongentla.

Ukuba akukho zixhobo ezintathu eziye zayeka xa kukho ifowuni ivuliwe, sebenzisa ukongeza / ukususa i-gradient stop icons eceleni kwebar bar stop bar ukusetha inamba ukuya kwiintathu.

Ngefayile yokuSebenza yokuvula,

  1. Cofa kwimvelaphi ukukhetha yonke igrafu
  2. Cofa kwi icon ye- Fill & Line (ipeyinti ingakwazi) kwifowuni
  3. Cofa kwi Gcwalisa isihloko ukuvula iinketho zokuzalisa
  4. Cofa kwiKhowudi ye - Gradient kuluhlu ukuvula icandelo le-gradient elingezansi kwipowini
  5. Kwinqanaba le-gradient, khangela ukuze uqinisekise ukuba Uhlobo lohlobo lubekwe kwiNqakraza engapheliyo
  6. Khetha indlela yokuLawula kwi- Linear Down ukudala i-gradient yangemvelaphi engezantsi njengoko iboniswe kumfanekiso kwiphepha 1
  7. Kwi- Gradient yeka ibha, nqakraza kwi-stop-gradient stop stop
  8. Qinisekisa ukuba ixabiso lePosition liyi-0%, kwaye ubeke umbala ogcwalayo kuMgca weNtshonalanga 1 usebenzisa umbala wendlela phantsi kwe-gradient
  9. Cofa kwi-stop middle gradient stop
  10. Qinisekisa ukuba ixabiso lePosition liyi-50%, kwaye usethe umbala ogcwalayo kwi- Tan Background 2 Ubumnyama 10% ukutshintsha umbala we-gradient stop stop to tan
  11. Cofa kwi-stop-gradient stop stop
  12. Qinisekisa ukuba ixabiso lePosition liyi 100%, kwaye usethe umbala wokugcwalisa kwiNtshonalanga Yesiqalo 1

Ukutshintsha uhlobo lwefonti, ubukhulu, kunye nombala

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 bulinganiswa kumaphuzu - kaninzi kufutshane ukuya 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 yebhoni, nqakraza kwibhokisi yePolisi ukuvula uluhlu lokuhla lweentlobo ezikhoyo
  4. Skrolela ufumane kwaye uqhosha kwifonti Bondini MT Black kuloluhlu ukuguqula isihloko kule fom
  5. Kwiphepha lefonti elisecaleni kwebhokisi lefonti, setha ubungakanani befayili yesitayela kwi-18 pt
  6. Cofa kanye kwinqanaba lokukhetha
  7. Ukusebenzisa amanyathelo angentla, setha umbhalo wendatshana kwi-10 pt yeBondini MT Black
  8. Cofa kanye kwi-ileyibhile yedata ye- 64% kwiMpahla yohlulo kwitshathi - zonke iilebula zedatha ezine kwitshati mazikhethwe
  9. Beka iilebula zedatha kwi-10.5 pt Bondini MT Black
  10. Ngamabhalana edatha akhethiweyo, nqakraza kwi- Font Color icon i-Ribbon (ileta A) ukuvula ipaneli Yemibala Yemibala
  11. Cofa kwiNtshukumo Yomgca we- White Background 1 kwiphaneli ukutshintsha umbala wefayili yenkcazo yedatha kumhlophe

Ngeli nqanaba, ukuba ulandele onke amanyathelo kule khokelo, ishati yakho kufuneka ifane nomzekelo oboniswe kwiphepha 1.