Shintsha i-Column Colors ne-Show Percent Data Labels

Ngokuvamile, igrafu yeshadi noma ibrafu yekholomu ibonisa inani elibekiwe noma inani lezinkathi zenani livela isikhathi esithile. Ubude obude ikholomu, inani elikhulu izikhathi okubaluleka ngayo.

Ngaphezu kwalokho, ishadi ngokuvamile libonisa uchungechunge oluningi lwemininingwane ngekholomu ngayinye kulolu chungechunge olumbala owodwa.

Ukusebenzisa izici zokufometha ezitholakalayo ku-Excel, kungenzeka ukuthi ube neshadi lamakholomu ukulinganisa ishadi lokuphayela nokubonisa

• amakholomu anemibala ehlukene kumaphuzu ngayinye ochungechunge olulodwa lwedatha
• inani lephesenti ukuthi ikholomu ngayinye imelela inani

Ukulandela izinyathelo kulesi sifundo kukuhamba ngokudala nokufometha ishadi lamakholomu eliboniswe esithombeni ngenhla.

Qaphela:
* Uma unesithakazelo kuphela ekushintsheni amalebula wedatha ukuze ubonise amaphutha, ulwazi lungatholakala ekhasini 3 lale tutorial
* Ukushintsha imibala yekholomu kungatholakala ekhasini 4

01 ka-06

Izinyathelo eziyisithupha zokwenza ishadi lamakholomu ku-Excel

Inothi kwi-Excel's Theme Colors

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

Isihloko esetshenziselwa lesi sifundo siyinhloko yeThe Wood Type .

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.

02 ka 06

Ukuqala Ishadi Lamakholomu

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 Lamakholomu Eliyisisekelo

Izinyathelo ezilandelayo zizokwenza ishadi lamakholomu ayisisekelo - ishadi elicacile, elingashintshiwe - elibonisa uchungechunge lwemininingwane ekhethiwe kanye nezinkomba.

Izinyathelo ezilandelayo ngokudala ikhava eyisisekelo yeshadi ukuthi ungasebenzisa kanjani ezinye zezici zokufometha ezivame kakhulu, okulandelayo, uma zilandelwa, zizoshintsha ishadi eliyisisekelo ukufanisa ishadi lamakholomu eliboniswe ekhasini 1 lalo mfundo.

1. Chofoza ku- Faka ithebhu ye- ribbon
2. Ebhokisini Lamashadi webhebhoni, chofoza isithonjana seKhadi lekholomu lokufaka ukuze uvule uhlu olwehlisiwe lwezinhlobo zegrafu / ishadi elitholakalayo
3. Hambisa isikhombisi sakho segundane phezu kohlobo lweshadi ukuze ufunde incazelo yeshadi
4. Chofoza ku- Column Clustered - ukhetho lokuqala esigabeni se-2-d sekholomu ohlwini - ukulikhetha
5. Ishadi lamakholomu eyisisekelo lidalwa futhi lifakwe 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 - July 2014 Izindleko - ebhokisini lesihloko

03 ka 06

Ukungeza amalebula wedatha njengama-Percents

Ukuchofoza engxenyeni engalungile yeShadi

Kunezingxenye eziningi ezihlukene eshadini ku-Excel - njengendawo yendawo ephethe izingqimba ezimelela uchungechunge lwemininingwane ekhethiwe, izinkomba ezizungezile neziqondile, isihloko seshadi namalebula, namagaladi wegridi enezingqimba.

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 endaweni yesakhiwo phakathi nendawo yegrafu uma inhloso ukukhetha lonke igrafu.

Indlela elula yokukhetha lonke igrafu 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 kwikholomu yokwakha eshadini - wonke amakholomu amane eshadini kufanele akhethwe
2. Chofoza ngakwesokudla kukholomu yezinto zokwakha ukuze uvule imenyu yokuqukethwe yochungechunge lwedatha
3. Kumenyu yesimo , hlela igundane ngaphezu kwenketho yokwengeza idatha yamagama ukuze uvule imenyu yesibili yesimo
4. Kumenyu yesibili yesimo, chofoza ku- Engeza Amalebula Wedata ukuze ungeze amalebula wedatha ngenhla kwekholomu ngayinye eshadini

Ukushintsha Amalebula WeDatha Ukubonisa Amaphesenti

Amalebula wamanje wamanje angaguqulwa ukuze abonise iphesenti ikholomu ngayinye eshadini imelela izindleko eziphelele ngokusebenzisa ireferensi yeseli kumanani wephesenti abhalwe ohlwini lwekholomu C yedatha yedatha kwifomula .

Amalebula wedatha okuzenzakalelayo azohlelwa ngokuchofoza kabili ngalunye, kodwa, futhi, ungachofoli kabili.

1. Chofoza kanye kwilebuli yedatha ye- 25487 ngenhla Ikholomu yezakhiwo eshadini - wonke amalebula amane wedatha eshadini kufanele akhethwe
2. Chofoza okwesibili kwilebuli yedatha yezinto zokwakha - kuphela i-label ye- 25487 yedatha okufanele ikhethwe
3. Chofoza kanye kwifolomu yefomula ngaphansi kwebhande
4. Faka ifomu = C3 kufomula yefomula bese ucindezela ukhiye we-Enter ekhibhodi
5. I-label ye- 25487 ye- data kufanele ishintshe ukuze ifunde 46%
6. Chofoza kanye kwilebuli yedatha ye- 13275 ngenhla kwekholomu yokusebenza eshadini - kuphela ukuthi ilebula yedatha kufanele ikhethwe
7. Faka ifomu elilandelayo = C4 kubha yefomula bese ucindezela ukhiye wokungena
8. Ithebula lwedatha kufanele lishintshe ukuze lifunde 24%
9. Chofoza kanye kwilebuli yedatha engu- 8547 ngenhla kwekholomu yezokuthutha eshadini-kuphela leyo ilebula yedatha okufanele ikhethwe
10. Faka ifomula elandelayo = C5 ebhasini lefomula bese ucindezela ukhiye wokungena
11. Ithebula lwedatha kufanele lishintshe ukuze lifunde 16%
12. Chofoza kanye kule ilebuli yedatha engu- 7526 ngenhla kwekholomu Yezinto Zokusebenza eshadini - kuphela leyo ilebuli yedatha okufanele ikhethwe
13. Faka ifomula elandelayo = C6 ebhafini yefomula bese ucindezela ukhiye wokungena
14. Ilebuli yedatha kufanele ishintshe ukuze ifunde 14%

Ukususa ama-Gridlines kanye namaLebhu Alinge Axis

1. Esikhathini, chofoza kanye ku-20,000 gridline egijima phakathi kwegrafu - zonke iziteshi zegridi kufanele ziqokonyiswe (imibuthano encane eluhlaza okwesibhakabhaka ekugcineni komgqa ngamunye)
2. Cindezela ukhiye wokususa kukhibhodi ukususa amarekhodi wegridi
3. Chofoza kanye kumalebula e-axis Y - izinombolo ngakwesobunxele ishadi - ukuzikhetha
4. Cindezela ukhiye wokususa kukhibhodi ukususa lawa malebula

Kuleli phuzu, uma zonke izinyathelo ezingenhla zilandelwe, ishadi lakho lekholomu kufanele lifane neshadi esithombeni ngenhla.

04 ka 06

Ukushintsha i-Colour Column Colors nokufaka i-Legend

Amathebhu we-Chart Tools

Njengoba kuboniswe esithombeni esingenhla, uma ishadi lidalwe ku-Excel, noma noma nini lapho ishadi elikhona likhethwa ngokuchofoza kukho, amathebhu amabili angeziwe kwi- Ribbon .

Lezi amathebhu wamathuluzi we-Chart - ukuklama nokufometha - aqukethe izinketho zokufometha kanye nezinketho ngokuqondile ngamashadi, futhi azosetshenziselwa izinyathelo ezilandelayo ukuqedela ishadi lamakholomu.

Ukushintsha i-Colour Column Colors

Ngaphandle kokushintsha umbala wekholomu ngayinye eshadini, i-gradient yengezwa kukholomu ngayinye yokwenza ukufometha ikholomu ngayinye inqubo yezinyathelo ezimbili.

1. Chofoza kanye kwikholomu yokwakha eshadini - wonke amakholomu amane eshadini kufanele akhethwe
2. Chofoza okwesibili kwikholomu yezinto zokwakha eshadini - kuphela ikholomu yezakhiwo kufanele zikhethwe
3. Chofoza kuthebhu yefomathi yedibhoni
4. Chofoza ku-Isithonjana Sokugcwalisa Uhlobo ukuze uvule imenyu yokugcwalisa imibala
5. Esigabeni Esijwayelekile se-Colors semenyu khetha i- Blue
6. Chofoza ku-Option Shape Fill option okwesibili ukuvula imenyu
7. Hambisa isikhombisi segundane ngenketho ye- Gradient eduze kweminye imenyu ukuvula imenyu ye-Gradient
8. Esigabeni sokushintsha kokukhanya kweminye imenyu ye- Gradient , chofoza inketho yokuqala (i- Linear Diagonal - Ephezulu Kwesobunxele kuya Ngakwesokudla ) ukuze ungeze lesi sigaba kwikholomu yezakhiwo
9. Chofoza kanye kwikholomu yezinsiza kwikholomu ye- Utilities kuphela okufanele ukhethwe
10. Chofoza ku-Isithonjana Sokugcwalisa Uhlobo bese ukhetha Olubomvu kusuka kusigaba Esijwayelekile se-Colors semenyu
11. Phinda izinyathelo ezingu-6 ukuya ku-8 ngenhla ukuze ungeze i-gradient kwikholomu yezinsiza
12. Chofoza kanye kwikholomu yezokuThutha bese uphinda izinyathelo 10 no-11 ngenhla ukuze ushintshe ikholomu yezokuThutha ukuya kuGreen futhi wengeze i-gradient
13. Chofoza kanye kwikholomu yezixhobo bese uphinda izinyathelo ezingu-10 no-11 ngenhla ukuze ushintshe ikholomu yezixhobo ku- Purple bese wengeza i-gradient
14. Imibala yamakholomu amane eshadini kufanele manje afane nalabo aboniswe esithombeni ekhasini 1 lesifundo

Ukungeza i-Legend and Deleting the X Axis Labels

Manje ukuthi ikholomu ngayinye ingumbala ohlukile, inganekwane ingezwa ngaphansi kwesihloko seshadi futhi amalebula we-axis e-X ngaphansi kweshadi isusiwe

1. Chofoza kusemuva leshadi ukuze ukhethe ishadi lonke
2. Chofoza kuthebhu Yokwakha yedibhoni
3. Chofoza kusithonjana se- Add Chart Element ngakwesokunxele sobhande ukuze uvule imenyu yehla
4. Khetha Isigoli> Phezulu ohlwini ukuze ungeze inganekwane ngaphezu kwendawo yesakhiwo
5. Chofoza kanye kumalebula e-axis e-X - amagama ekholomu ngaphansi kweshadi - ukuwakhetha
6. Cindezela ukhiye wokususa kukhibhodi ukususa lawa malebula

05 ka 06

Ukuhambisa amalebula weDatha nokuvula Amakholomu weShadi

Ukufometha Iphaneli Lomsebenzi

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.

Ukuhambisa amalebula wedatha

Lesi sinyathelo sizohambisa amalebula wedatha ngaphakathi kwekholomu ngayinye.

1. Chofoza kanye kwilebuli yedatha engu - 64% ngaphezu kwekholomu yezakhiwo eshadini - wonke amalebula amane wedatha eshadini kufanele akhethwe
2. Chofoza kuthebhu yefomethi yebhebhoni uma kunesidingo
3. Chofoza ukhetho lokufometha kwefomathi ngakwesokunxele kwebhande ukuze uvule iphoyinti le- Tasting Task ngakwesokudla kweskrini
4. Uma kunesidingo, chofoza inkinobho yezinketh in the pane ukuze uvule izinketho zelebula njengoba kuboniswe esithombeni ngenhla
5. Chofoza kukhetho lokungena ngaphakathi ngaphakathi kwendawo ye - ilebula yokuma kwilawenda ukuze uhambise wonke amalebula wedatha amane ngaphakathi kwezingqimba zawo ezifanele

Ukwandisa Amakholomu Wekhadi

Ukwandisa amakholomu eshadi kuzosenza sikwandise usayizi wombhalo wamalebula wedatha, okwenza kube lula ukufunda.

Ngomdwebo womsebenzi wokufometha ovuliwe,

1. Chofoza kanye kwikholomu yezakhiwo eshadini - wonke amakholomu amane eshadini kufanele akhethwe
2. Uma kunesidingo, chofoza inkinobho yezinketh in the pane ukuze uvule izinketho zochungechunge
3. Hlela ububanzi be- Gap kuya ku-40% ukwandisa ububanzi bawo wonke amakholomu amane eshadini

Ukungeza i-Shadow Kwikholamu ngayinye

Isinyathelo sizofaka isithunzi ngemuva kwekholomu ngayinye eshadini.

Ngomdwebo womsebenzi wokufometha ovuliwe,

1. Chofoza kanye kwikholomu yezakhiwo eshadini - wonke amakholomu amane eshadini kufanele akhethwe
2. Chofoza kanye ngakwesithonjana se- Effects ku-pane yokufometha ukuze uvule izinketho zochungechunge
3. Chofoza kanye esihlokweni se- Shadow ukuvula izinketho zezithunzi
4. Vula iphaneli yamasethingi ehleliwe ngokuchofoza isithonjana se- Presets
5. Engxenyeni yePhromoshini , chofoza kwi- Perspective Diagonal Upper Right icon
6. Isithunzi kufanele sivele ngemuva kwekholomu ngayinye yamashadi

06 ka-06

Ukwengeza Umbala Wemvelaphi Ongemuva nokufometha Umbhalo

Ukungeza i-Background Color Gradient

Lesi sinyathelo sizokwengeza umbala wombala ngemuva ngemuva kokusebenzisa okukhethwa kukho kukhofini yokuhlela ifomathi njengoba kuboniswe esithombeni ngenhla.

Uma kungekho ama-gradient amathathu ayama lapho ivulethi ivuliwe, sebenzisa ukufaka / ukususa izithombe ze-stop gradient eceleni kwe-bar dialent stop ukuze ubeke inombolo ibe yintathu.

Ngomdwebo womsebenzi wokufometha ovuliwe,

1. Chofoza ngemuva ukuze ukhethe lonke igrafu
2. Chofoza ku-Isithonjana se- Fill & Line (ukudweba kungaba khona) kukhompuyutha
3. Chofoza kusihloko sokugcwalisa ukuvula izinketho zokugcwalisa
4. Chofoza ku-Okukhethwa kukho Okuphezulu ohlwini ukuze uvule isigaba se-gradient ngezansi kufane
5. Esigabeni se-gradient, hlola ukuze uqiniseke ukuthi ukhetho lohlobo lubekwe ku- Linear engaguquki
6. Setha inketho ye- Direction kuya ku- Linear Down ukuze udale i-background gradient enezingqimba njengoba kuboniswe esithombeni ekhasini 1
7. E- Gradient yeka ibha, chofoza ku-stop gradient stop kakhulu
8. Qiniseka ukuthi i- Position value yayo ngu-0%, bese ubeka umbala ogcwalayo kumsuka ongenhla 1 usebenzisa inketho yombala ngezansi kwe-stodient stop
9. Chofoza ku-stop middle gradient stop
10. Qiniseka ukuthi i- Position value yayo ngu-50%, bese usetha umbala ogcwalayo kwi- Tan Background 2 Emnyama 10% ukushintsha umbala we-gradient stop stop to tan light
11. Chofoza ku-stop-gradient stop
12. Qinisekisa ukuthi inani laso lePosition liyi-100%, bese usetha umbala ogcwalayo kuMsuka ongcwele 1

Ukushintsha uhlobo lwefonti, Usayizi, nombala

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 bulinganiselwa amaphuzu - ngokuvamile kufushaniswa ku- pt .
Umbhalo we-pt angu-72 ulingana no-intshi eyodwa (2.5 cm) ngesayizi.

1. Chofoza kanye esihlokweni seshadi ukuze ukhethe
2. Chofoza kuthebhu yaseKhaya ye-ribbon
3. Engxenyeni yefonti yebhebhoni, chofoza ebhokisini lefonti ukuvula uhlu oludonsela phansi lwamafonti atholakalayo
4. Pheqa ukuze uthole futhi uchofoze kwifolda Bondini MT Black ohlwini ukuze ushintshe isihloko kule fonti
5. Ebhokisini lefonti eliseduze kwebhokisi lefonti, setha isihloko samagama wefonti ku-18 pt
6. Chofoza kanye kwendlovu ukuze ukhethe
7. Ukusebenzisa izinyathelo ezingenhla, setha umbhalo we-legend ube ngu-10 pt Bondini MT Black
8. Chofoza kanye kwilebuli yedatha engama - 64% kwikholomu yezakhiwo eshadini - wonke amalebula amane wedatha eshadini kufanele akhethwe
9. Hlela amalebula wedatha ku-10.5 pt Bondini MT Black
10. Ngamalebula wedatha okhethiwe, chofoza isithonjana seMbala Yombhalo i-Ribbon (incwadi A) ukuvula iphaneli Yombala Wefonti
11. Chofoza okukhethwa kukho kombala oMsuka onguMhlophe 1 iphaneli ukuze ushintshe umbala wefonti yombhalo we-label kumhlophe

Kuleli phuzu, uma ulandele zonke izinyathelo kulolu hlelo, ishadi lakho kufanele lifanane nesibonelo esiboniswe ekhasini 1.