Sinthani Colors Column ndi Show Percent Data Labels

Kawirikawiri, gradi ya tchati kapena galasi imawonetsera ndalama kapena kuchuluka kwa nthawi zomwe zimakhalapo panthawi yomwe yakhazikitsidwa. Mtali wamtunduwu, nthawi zambiri mtengo umapezeka.

Kuwonjezera apo, tchati nthawi zambiri imasonyeza maulendo angapo a deta ndi ndime iliyonse mndandanda womwe uli mtundu womwewo.

Pogwiritsira ntchito mapangidwe omwe alipo mu Excel, n'zotheka kukhala ndi tchati cha mzere wofanana ndi tchati cha pie ndi mawonetseredwe

• mazithunzi osiyana a mtundu uliwonse pazithunzi zosiyana siyana
• peresenti ili yofunika kuti chigawo chilichonse chikuimira kuchuluka kwa ndalama

Kutsatira ndondomeko mu phunziroli kumakuyendetsani kupyolera mukukonza ndi kupanga mapangidwe a chithunzi chawonetsedwa pamwambapa.

Zindikirani:
* Ngati muli ndi chidwi chosintha malemba a deta kuti musonyeze zochepa, zowonjezereka mungazipeze pa tsamba 3 la phunziroli
* Kusintha mitundu ya mndandanda kungapezeke patsamba 4

01 ya 06

6 Njira Zokonzera Tchati cha Column mu Excel

Chidziwitso pa mutu wa Excel Colors

Excel, monga mapulogalamu onse a Microsoft Office, amagwiritsa ntchito malemba kuti ayang'ane mawonekedwe ake.

Mutu wogwiritsidwa ntchito pa phunziroli ndi mutu wa Wood Type .

Ngati mutagwiritsa ntchito mutu wina pamene mukutsatira phunziroli, mitundu yomwe ili muzochitikazi sizingapezeke pa mutu womwe mukugwiritsa ntchito. Ngati sichoncho, ingosankhira mitundu yomwe mukuikonda ngati m'malo ndi kupitiliza.

02 a 06

Kuyambira Tchati cha Mndandanda

Kulowa ndi Kusankha Deta Yophunzitsa

Kulowa mu ndondomekoyi ndi nthawi yoyamba kupanga tchati - ziribe kanthu mtundu wa tchati umene ulipo.

Khwerero yachiwiri ndikuwonetsa deta yomwe ingagwiritsidwe ntchito popanga tchati.

1. Lowetsani deta yosonyezedwa mu chithunzi pamwamba pa maselo ofiira a masamba
2. Mukalowa, onetsetsani maselo osiyanasiyana kuyambira A3 mpaka B6

Kupanga Tchati Choyambira Chachidule

Zotsatira zotsatirazi zidzakhazikitsa tchati chachinsinsi - tchati, chosasinthika - chomwe chikuwonetsera mndandanda wa deta komanso zosankha.

Ndondomeko zotsatirazi kuti mupange chithunzi chofunika kwambiri cha momwe mungagwiritsire ntchito zida zomwe zimagwiritsidwa ntchito, zomwe, ngati zitsatiridwa, zidzasintha ndondomeko yoyenera kutsata ndondomeko yomwe ili pa tsamba 1 la phunziro ili.

1. Dinani pa Insert tab ya riboni
2. Mu bokosi la Chitsulo cha riboni, dinani pa chithunzi cha Tchati cha Tchati Chotsitsa kuti mutsegule mndandanda wa mitundu yomwe ilipo.
3. Sungani chojambula chanu cha mouse pamtundu wa tchati kuti muwerenge kufotokoza kwa tchati
4. Dinani pa Zowonjezeredwa Pakhoma - Njira yoyamba mu gawo la 2-d Lamulo la mndandanda - kuti musankhe
5. Mndandanda wachindunji wapangidwe umapangidwa ndikuikidwa pa tsamba

Kuwonjezera Mutu wa Chati

Sinthani Chinthu Chachidule Chachidutswa podutsa pawiri kawiri - koma osabwereza kawiri

1. Dinani kamodzi pa mutu wosasinthika wa chithunzi kuti muwusankhe - bokosi liyenera kuwonekera kuzungulira mawu Chart Title
2. Dinani kachiwiri kuti muike Excel mu edit mode , yomwe imaika cursor mkati mwa mutu wa bokosi
3. Chotsani malemba osasintha pogwiritsa ntchito makiyi Otsala / Backspace pa makiyi
4. Lowani mutu wa tchati - July 2014 Zowonjezera - mu mutu wa bokosi

03 a 06

Kuwonjezera Malemba Achidule monga Percents

Kulimbana ndi Gawo Lolakwika la Tchati

Pali zigawo zambiri pa tchati mu Excel - monga malo amalo omwe ali ndi zizindikiro zomwe zikuyimira mndandanda wa deta , zitsulo zopingasa ndi zowonekera, mutu wa tchati ndi malembo, ndi mzere wojambulidwa.

Muzotsatira izi, ngati zotsatira zanu sizifanana ndi zomwe zalembedwa mu phunziroli, ndizotheka kuti mulibe gawo loyenera la tchati yomwe mwasankha pamene mwasankha machitidwe omwe mumasankha.

Kulakwitsa kowonjezeka kwambiri ndiko kukudutsa gawo la chiwembu pakati pa graph pamene cholinga chake ndi kusankha grafu yonse.

Njira yosavuta yosankhira galasi lonse ndikukweza pamwamba kumanzere kapena kumanzere kumbali ya mutu wa tchati.

Ngati kulakwitsa kwapangidwa, kungakonzedwe mwamsanga pogwiritsa ntchito chithunzi cha Excel kukonza cholakwika. Pambuyo pake, dinani mbali yoyenera ya tchati ndikuyesanso.

Kuwonjezera Ma Labels Data

1. Dinani kamodzi pazomwe zipangizo zili mu tchati - zipilala zinayi pa chithunzicho zisankhidwe
2. Dinani pazomwe Zipangizo zazitsulo kuti mutsegule mndandanda wazinthu zamndandanda
3. Mu menyu yachidule , sungani mbewa pamwamba pazowonjezera Zowonjezera Labels kuti mutsegule mndandanda wachiwiri
4. Muwondomeko yachiwiri yachiwiri, dinani pa Add Data Labels kuti muwonjezere malemba apamwamba pamwamba pa ndime iliyonse mu tchati

Kusintha Malemba Achidule Kuti Onetsani Maenti

Malemba amtundu wamakono angasinthidwe kuti asonyeze kuti peresenti iliyonse pa chithunzicho imayimira ndalama zonse zomwe zimagwiritsidwa ntchito pogwiritsa ntchito selolo peresenti ya ndalama zomwe zili m'ndandanda wa C wa tebulo la deta.

Malemba osasinthika a deta adzasinthidwa mwa kudindikiza kawiri payekha, koma, kachiwiri, musati muwoneke.

1. Dinani kamodzi pa lemba lapafupi la 25487 pamwamba pa Zida zazitsulo mu tchati - malemba onse a data pa tchati ayenera kusankhidwa
2. Dinani kachiwiri palemba la Zipangizo Zamatabwa - ndiyekha 25487 seti ya deta iyenera kusankhidwa
3. Dinani kamodzi mu barolo lazenera pansi pa nkhono
4. Lowetsani ndondomeko = C3 muzitsulo zamakono ndipo pindani makiyi a Enter mu makiyi
5. Mayina a deta 25487 ayenera kusintha kuti awerenge 46%
6. Dinani kamodzi pa bolodi la deta la 13275 pamwamba pa Zopangira Zowonjezera mu chart - kokha kuti chizindikiro cha deta chiyenera kusankhidwa
7. Lowetsani ndondomeko zotsatirazi = C4 muzitsulo zamakono ndikukankhira pakani
8. Chiwerengero cha deta chiyenera kusintha kuti chiwerengere 24%
9. Dinani kamodzi pa bolodi la deta ya 8547 pamwamba pa chithunzi cha Transport pa chart - kokha kuti chizindikiro cha deta chiyenera kusankhidwa
10. Lowetsani ndondomeko zotsatirazi: C5 muzitsulo zamakono ndikusindikizira
11. Mayina a deta ayenera kusintha kuti awerenge 16%
12. Dinani kamodzi pa lemba la data la 7526 pamwamba pa Zida zam'manja mu chart - kokha kuti chizindikiro cha deta chiyenera kusankhidwa
13. Lowetsani ndondomeko zotsatirazi: C6 muzitsulo zamakono ndikukankhira pakani
14. Deta ya deta iyenera kusintha kuti iwerengere 14%

Kuchotsa Gridlines ndi Vertical Axis Labels

1. Mu chithunzicho, dinani kamodzi pa galimoto ya 20,000 yomwe ikuyenda pakati pa galasi - magalasi onse ayenera kufotokozedwa (magulu ang'onoang'ono a buluu kumapeto kwa gridline)
2. Thandizani Chotsani Chotsani pa khibhodi kuti muchotse ma gridlines
3. Dinani kamodzi pamakalata a Y axis - manambala kumbali yakumanzere chati - kuti muwasankhe
4. Thandizani Chotsani Chotsani pa khibhodi kuti muchotse malemba awa

Panthawiyi, ngati masitepe onsewa athandizidwa, tchati chanu chachindunji chiyenera kufanana ndi chithunzi chomwe chili pamwambapa.

04 ya 06

Kusintha Tchati Colour Colours ndi Kuwonjezera Lembali

Makanema a Chart Tools

Monga momwe tawonetsera pa chithunzi pamwambapa, pamene tchati chajambulidwa ku Excel, kapena pamene chithunzi chomwe chilipo chikusankhidwa pogwiritsa ntchito, ma tebulo awiri akuwonjezeredwa ku kaboni .

Ma tebulo a Chart - mapangidwe ndi mapangidwe - ali ndi mawonekedwe ndi machitidwe omwe angakonzedwe mwachitsulo, ndipo amagwiritsidwa ntchito pazinthu zotsatirazi kuti mutsirize tchatichi.

Kusintha Tchati Colour Colors

Kuwonjezera pa kusintha mtundu wa chigawo chilichonse mu tchati, chophatikizidwa chikuwonjezeredwa pa ndime iliyonse kupanga mapangidwe a ndime iliyonse magawo awiri.

1. Dinani kamodzi pazomwe zipangizo zili mu tchati - zipilala zinayi pa chithunzicho zisankhidwe
2. Dinani kachiwiri pazomwe Zipangizo zidalembedwa mu tchati - zokhazokhazo Zida zofunika zisankhidwe
3. Dinani pa Tsambidwe la Mtambo wa Riboni
4. Dinani pazithunzi Pangani mawonekedwe kuti mutsegule Menyu Yodzaza Mitambo
5. Mu gawo la Standard Colors la menyu musankhe Buluu
6. Dinani pa Fomu Yodzaza njira yachiwiri kuti mutsegulezomwe menyu
7. Sungani pointer ya mouse pamasankhidwe a Gradient pafupi ndi pansi pa menyu kuti mutsegule Menyu yambiri
8. Mu gawo la Kusintha kwa Kuunika kwa mndandanda wa Masamba, dinani njira yoyamba ( Lumikizanani Ndimzere - Kumanzere Kumanzere Kumanja Kumanja ) kuti muwonjezere gawo ili ku Zipangizo zamtundu
9. Dinani kamodzi pa Zowonjezera Zowonjezera mu tchati - Chinthu chokha cha Utilities chiyenera kusankhidwa
10. Dinani pa Chithunzi chodzaza Zithunzi ndipo kenako Sankhani Tsamba loyera kuchokera ku gawo la Standard Colors la menyu
11. Bweretsani masitepe 6 mpaka 8 pamwamba kuti muwonjezere gawoli ku Utilities column
12. Dinani kamodzi pazomwe Mnyanja Yoyendetsa ndi kubwereza masitepe 10 ndi 11 pamwamba kuti musinthe ndime ya Transport kupita ku Green ndi kuwonjezera padi
13. Dinani kamodzi pa Chipangizo Chachitsulo ndi kubwereza masitepe 10 ndi 11 pamwamba kuti musinthe Zida Zapangidwe ku Purple ndi kuwonjezera malemba
14. Mitundu ya zipilala zinayi pa chithunzichi tsopano ikugwirizana ndi zomwe zawonetsedwa pa tsamba 1 la phunziroli

Kuwonjezera Lembali ndi Kuchotsa Ma X Axis Labels

Tsopano kuti ndime iliyonse ndi mtundu wosiyana, nthano ikhoza kuwonjezedwa pansi pa mutu wa tchati ndi malemba a X axis pansi pa tchati achotsedwa

1. Dinani kumbuyo kwa tchati kuti musankhe tchati chonsecho
2. Dinani pa tabu Yopanga ya kasoni
3. Dinani pa chithunzi Chakuwonjezera Chakiti kumbali ya kumanzere kwa riboni kuti mutsegule menyu otsika
4. Sankhani Lembali> Pamwamba kuchokera pa mndandanda kuti muwonjezere nthano pamwamba pa chigawocho
5. Dinani kamodzi pamakalata a X axis - maina a mndandanda pansi pa tchati - kuti muwasankhe
6. Thandizani Chotsani Chotsani pa khibhodi kuti muchotse malemba awa

05 ya 06

Kusuntha Malemba Achidindo ndi Kukulitsa Mapu a Tchati

Kukonza Mapu a Ntchito

Zotsatira zochepa za phunziroli zimagwiritsa ntchito mapangidwe a ntchito pamanja , omwe ali ndi mitundu yambiri yopangira ma chart.

Mu Excel 2013, pamene atsegulidwa, mawonekedwewo akuwonekera kumanja kwa dzanja la Excel pulogalamu monga momwe tawonetsera pa chithunzi pamwambapa. Mutu ndi zosankha zomwe zikuwonekera pazithunzi zimasintha malinga ndi dera lomwe lasankhidwa.

Kusuntha Ma Labels Data

Khwerero iyi idzasuntha malemba a deta mkati mwa pamwamba pa ndime iliyonse.

1. Dinani kamodzi pa lemba la data la 64% pamwamba pa Zida zolembera pa tchati - malemba onse a data pa tchati ayenera kusankhidwa
2. Dinani pa tabu ya foni ya riboni ngati kuli kofunikira
3. Dinani pa Kusankhidwa kwa Mpangidwe wa Maonekedwe kumbali ya kumanzere kwa riboni kuti mutsegule Pulogalamu Yokonza Mapulogalamu kumbali yakanja ya chithunzi
4. Ngati ndi kotheka, dinani pazithunzi Zotsalira pazithunzi kuti mutsegule zolemba zomwe zili pa chithunzi pamwambapa
5. Dinani pa njira yamkati mkati mwa malo omwe muli malo omwe ali pambali pazithunzi kuti musunthire malemba onse a deta mkati mwa pamwamba pa mazati awo

Kukulitsa Mapu a Tchati

Kukulitsa zigawo za tchatichi kudzatithandiza kuwonjezera kukula kwa malemba a deta, kuti tiwerenge mosavuta.

Pogwiritsa ntchito Pulogalamu Yowonekera ,

1. Dinani kamodzi pa Zida zakuthandizira mu tchati - zipilala zinayi zonse mu chithunzicho zisankhidwe
2. Ngati ndi kotheka, dinani pa Options Options mmwamba kuti mutsegule zosankha
3. Ikani Kuphatikiza kwa Pakati kwa 40% kuti muwonjezere kupatulira kwazitsulo zinayi zonse mu tchati

Kuwonjezera Mthunzi ku Khola Lililonse

Gawolo lidzawonjezera mthunzi pambali pazomwe zili muzithunzi.

Pogwiritsa ntchito Pulogalamu Yowonekera ,

1. Dinani kamodzi pa Zida zakuthandizira mu tchati - zipilala zinayi zonse mu chithunzicho zisankhidwe
2. Dinani kamodzi pa chithunzi cha Zotsatira m'mawonekedwe apamwamba kuti mutsegule zomwe mungachite
3. Dinani kamodzi pa mutu wa Shadow kuti mutsegule zosankha zamthunzi
4. Tsegulani mthunzi wazithunzi zamtunduwu podalira chizindikiro cha Presets
5. Mu gawo lowonetsera , dinani pa Chithunzi cha Diagonal Upper Right
6. Mthunzi uyenera kuwonekera kumbuyo kwa ndondomeko iliyonse ya tchati

06 ya 06

Kuwonjezera Maonekedwe Akumbuyo Kwambiri ndi Kupanga Malemba

Kuwonjezera Maonekedwe Akumbuyo Kwambiri

Khwerero iyi idzawonjezera maonekedwe a mtundu kumbuyo pogwiritsira ntchito zosankha muzithunzi zojambula Zojambula monga zikuwonetsedwa pa chithunzi pamwambapa.

Ngati palibe katatu katayika pamene pulogalamuyi yatsegulidwa, gwiritsani ntchito kuwonjezera / kuchotsa zithunzi zoyima pafupi ndi barrient stop bar kuti muyike nambala itatu.

Pogwiritsa ntchito Pulogalamu Yowonekera ,

1. Dinani kumbuyo kuti musankhe grafu yonse
2. Dinani pajambula Yodzaza & Mzere (utoto ukhoza) pazithunzi
3. Dinani pa Zodzaza kuti mutsegulire zosankha zodzaza
4. Dinani pa Chinthu Chachikulu m'ndandanda kuti mutsegule gawo lapafupi pansipa
5. Mu gawo lachigawo, fufuzani kuti muwonetsetse kuti mtundu Wosankha ukukhazikitsidwa ku Mzere Wosatha
6. Ikani njira ya Direction ku Linear Down kuti mupange malo osasunthika kumbuyo monga momwe tawonera pa chithunzi patsamba 1
7. Mu Gradient kuimitsa bar, dinani kumbuyo kwa gradient stop
8. Onetsetsani kuti malo ake apamwamba ndi 0%, ndipo ikani mtundu wake wodzaza ku White Background 1 pogwiritsa ntchito njira pansipa
9. Dinani pakatikati ya gradient stop
10. Onetsetsani kuti Mtengo wake uli ndi 50%, ndipo ikani mtundu wake wodzaza ndi Tan Background 2 Mdima wambiri 10% kusintha mtundu wofiira pakati pa tani
11. Dinani kuima kwabwino kwambiri
12. Onetsetsani kuti malo ake apamwamba ndi 100%, ndipo ikani mtundu wake wonse ku White Background 1

Kusintha mtundu wa mtundu, kukula, ndi mtundu

Kusintha kukula ndi mtundu wa ndondomeko yomwe ikugwiritsidwa ntchito pa tchati, sikungokhala kusintha pamwamba pa mapulogalamu osasinthika omwe akugwiritsidwa ntchito pa chithunzicho, koma zidzakhalanso zosavuta kuwerengera mayina ndi magulu a deta.

Zindikirani : Kukula kwa foni kumayikidwa pa mfundo - kawirikawiri kumachepetsedwa ku pt .
Malembo 72 pt ndi ofanana ndi masentimita 2.5 mu kukula.

1. Dinani kamodzi pa mutu wa tchati kuti muisankhe
2. Dinani pa tabu la Home la riboni
3. Mu gawo la foni la riboni, dinani pa Bokosi la Masamba kuti mutsegule tsambali la zilembo zomwe zilipo
4. Pemphani kuti mupeze ndikusindikiza pazithunzithunzi Bondini MT Black mu mndandanda kuti musandulike mutu wa ma foni awa
5. Mu Bokosi Lomasulira pafupi ndi bokosi lazithunzi, yikani kukula kwake kwazithunzi kwa 18 pt
6. Dinani kamodzi pa nthano kuti musankhe
7. Gwiritsani ntchito ndondomeko zapamwambayi, lembani mutuwu kwa 10 pt Bondini MT Black
8. Dinani kamodzi pa lemba la data la 64% muzitsulo Zolemba mu chart - malemba onse a data pa chithunzi ayenera kusankhidwa
9. Ikani malemba a data pa 10.5 pt Bondini MT Black
10. Ndi malemba a deta omwe adasankhidwa, dinani pajambulo la Font Color laboni (kalata A) kuti mutsegule Pulogalamu Yamitundu Yake
11. Dinani pa White Background 1 mtundu wosankhidwa pazenera kuti musinthe deta ya mtundu wa ma tepi ku white

Panthawi imeneyi, ngati mwatsatira zonsezi mu phunziroli, chithunzi chanu chiyenera kufanana ndi chitsanzo chomwe chili patsamba 1.