Shandisa Column Colors uye Show Percent Data Data

Kazhinji, chinyorwa che chati kana bharfu girafu inoratidza mamiriyoni akaenzana kana nhamba yezviitiko zvinokosha zvinoitika kwenguva yakatarwa. Iyo yakareba iyo chinyorwa, nhamba yakakura yenguva iyo kukosha kunoitika.

Mukuwedzera, chati yacho inowanzoratidza maverengedzero ehurukuro yedata nekamuri imwe neimwe mumakwikwi ari mufananidzo wakafanana.

Uchishandisa maitiro akawanikwa muExcel, zvinokwanisika kuva nekorodhe chati chinyorwa chati chepayiri uye kuratidza

• mapoka akasiyana-siyana emichindwe pane imwe nheyo imwe chete yakanyatsotarisa nyaya
• iyo yepamu inokosha iyo imwe column inomiririra yehuwandu hwemari

Kutevera matanho mune iyi tutori inokufambisa kuburikidza nekusika nekugadzirisa iyo chinyorwa chati inoratidzwa mumufananidzo pamusoro apa.

Cherechedza:
* Kana iwe uri kungofarira kuchinja mavara epa data kuti uratidze kupisa, ruzivo runogona kuwanikwa pane peji 3 yemudzidzi uyu
* Kuchinja mavara emirasiki kunogona kuwanikwa papeji 4

01 of 06

6 Matanho ekugadzirisa Chati cheKumberi mu Excel

Tsananguro paIndel Theme Theme Colors

Excel, kufanana nezvirongwa zveMicrosoft Office, inoshandisa zvinyorwa kuratidza kutarisa kwemagwaro ayo.

Musoro unoshandiswa pamusangano uyu ndiyo Wood Wood theme.

Kana ukashandisa imwe nhepfenyuro paunotevera chidzidzo ichi, mavara akarongwa mumatanho ekudzidzisa angasawanika mumusoro wauri kushandisa. Kana zvisingaiti, ingosarudza mavara kune iwe unofarira seanotsiva uye uenderere mberi.

02 of 06

Kutanga Chati Cherasi

Kupinda nekusarudza Tutorial Data

Kupinda mucheche data nguva dzose ndiyo danho rokutanga pakuumba chati - pasinei nokuti ndechipi che chati iri kusikwa.

Nhanho yechipiri iri kusimbisa dhesi iyo inoshandiswa mukugadzira chati.

1. Pinda data yakaratidzwa mumufananidzo pamusoro apa mumasero ekushanda mapepa
2. Pawakambopinda, sarudza huwandu hwemasero kubva kuA3 kusvika kuB6

Kuumba Chinyorwa Chakasira Chinyorwa

Nhanho dzinotevera dzichaita hurukuro yechandori chati - chidimbu, chisina kufanana chati-chinoratidza sarudzo dzakasarudzwa sedhesi uye zvinyorwa.

Nhanho dzinotevera kuumba gwaro rinokosha rinovhara kuti ungashandisa sei zvimwe zvakafanana pakugadzirisa maitiro, ayo, kana akatevedzwa, achachinja chati yekutanga yekufananidza chinyorwa chechati chinoratidzwa papeji 1 chekudzidzisa.

1. Dzvanya pa Inser tab yebhoni
2. Mubhokisi reCharts redhibhoni, chengetera paIndaneti Colon Chart icon kuti uzarure doro rezasi rwemafirimu
3. Hover your mouse pointer pamusoro pechati chinonzi kuverenga tsanangudzo ye chati
4. Dzvanya paClassed Column - chokutanga chokutanga munhengo 2-d Chikamu cherongwa - kuti uchisarudze
5. Chinokosha chinyorwa chati chakasikwa uye chakaiswa pamushandi webasa

Kuwedzera Chati Chinyorwa

Rongedza Chituti Chakanaka Chakasirika nekunyanya pairi kaviri - asi usatora kaviri

1. Dzokorora kamwe chete pane chinyorwa chisina kukodzera chinyorwa kuti uchisarudze-bhokisi rinofanira kuonekwa mukati memashoko Chart Title
2. Dzvanya kechipiri kuti uise Excel mu edit mode , iyo inoisa chitupa mukati mebhokisi rebhokisi
3. Dzinga zvinyorwa zvisingashandisi uchishandisa makiro e Delete / Backspace pane keyboard
4. Itai chinyorwa chechati - July 2014 Mari - mubhokisi rebhokisi

03 of 06

Kuwedzera Data Labels se Percents

Kubva paChikamu Chisiri Chetati

Kune zvikamu zvakasiyana-siyana kune chati mune Excel - yakafanana nenzvimbo yenzvimbo ine mibiru inomirira yakasarudzwa nhepfenyuro yakasarudzwa, iyo yakanyatsojeka uye yakajeka, mazita, chikwangwani chechati uye mavara, uye magiradhi emigwagwa yakakwana.

Mune matanho anotevera, kana mitsva yako isingafananidzi yakanyorwa mumudzidzisi, zviri pachena kuti iwe hauna chikamu chakanaka chechati chasarudzwa pawakawedzera maitiro ekugadzirisa.

Chikanganiso chinowanzoitwa kakawanda ndechekutsvaga nzvimbo yepakati iri pakati pegrafu apo chinangwa ndechokusarudza iyo yose grafu.

Nzira yakareruka yekusarudza iyo yose grafu ndeyokudhonza kumusoro kwekuruboshwe kana kwekona yekukona kubva pachirongwa chechati.

Kana kukanganisa kuitwa, inogona kukurumidza kugadziriswa kuburikidza nekushandura kweAexcel kushandura kukanganisa. Uchitevera izvozvo, chengeta pane chikamu chakanaka che chati uye edza zvakare.

Kuwedzera Dhiyabhorosi Dhiyabhorosi

1. Dzvidza kamwechete pane zvinyorwa muhodhi - dzose mazamu mana muchati inofanira kusarudzwa
2. Enda pakananga paChinyorwa chezvinhu zvekushandisa kuti uzarure mamiriro ekutevedzana kwezvinhu zvakasangana
3. Muchirevo chemuongorori, shandisa mavhari pamusoro peDynamic Data Labels sarudzo kuti uzarure mamiriro acho ezvinhu wechipiri
4. Muchikamu chechipiri mamiriro acho, chengeta paDhadha Dhiyabhorosi Dhiyabhorosi kuti uwedzere mavara epa data pamusoro pevharo imwe neimwe mu chati

Kuchinja Dhiyabhorosi Dhiyabhorosi Kuratidza Mazana

Ikozvino mabhuku e data anogona kuchinjwa kuti aratidze peresenti imwe imwe yendarama muchati inomiririra mari yose kuburikidza kushandisa sero rinotarisa kumazana emari ayo akanyorwa muchitsetse C chetafura yedhadha mumutsetse .

Izvo zvisiri izvo zvinyorwa zvemashoko zvichagadziriswa nekucheka kaviri chimwe nechimwe, asi, zvakare, usatora kaviri.

1. Dzvidza kamwechete pane 25487 data label pamusoro peZvivako zvinyorwa mu chati - zvose mabhuku mana emadhora muchati inofanira kusarudzwa
2. Dzvanya kechipiri paIndaneti yedhizha rekushandisa - chete 25487 data label inofanira kusarudzwa
3. Kamwe kamwe mubhokisi remuzasi pasi pebhoni
4. Pinda musarudzo = C3 mu-bar bar uye tapindura muIndaniti yebhokisi
5. Iko 25487 data label inofanira kuchinja kuverenga 46%
6. Dzvidza kamwe chete pane tsamba 13275 yedhipi pamusoro peNyuniti yeUtilities mu chati - chete iyo dheti yedata inofanira kusarudzwa
7. Isa inotevera fomu = C4 mu-bar bar uye pinda kuIno
8. Dhaka ye data inofanira kuchinja kuverenga 24%
9. Dzvidza kamwechete pane 8547 yedhikisi yepamusoro pamusoro pekamberi yekutakura mu chati - chete iyo dheti yedata inofanira kusarudzwa
10. Isa inotevera chimiro = C5 mubharuti yebhari uye cheya Enter key
11. Dhaka ye data inofanira kuchinja kuverenga 16%
12. Dzokorora kamwe chete pane pepa 7526 yedheta pamusoro peMashandisi yemirairi mu chati - chete iyo dheti yedata inofanira kusarudzwa
13. Pinda inotevera: formula C6 mubharuti yebhairi uye tapindura muIndo inopinda
14. Dhaka ye data inofanira kuchinja kuverenga 14%

Kuchenesa Gridlines uye Vertical Axis Labels

1. Muchidimbu, chengeta kamwechete pane 20,000 gridline inomhanya nepakati pebhokisi - dzose magiradhi epaigridhi anofanira kuiswa pachena (maduku maduku ebhuruu pakuguma kwegridline rimwe nerimwe)
2. Dhinda kachenesa khiye pakibhodi kuti ubvise magiradhi
3. Kamwe kamwe pane mavara e-axis Y - nhamba kune rumwe rutivi rworuboshwe chati - kuti uvasarudze
4. Dhinda reChenesa kiyi pane keyboard kuti ubvise mavara aya

Panguva ino, kana matanho ose ari pamusoro apa akateverwa, yako chinyorwa chati inofanira kufanana necha chati mufananidzo pamusoro apa.

04 of 06

Kushandura Chati Column Colors uye Kuwedzera Nhoroondo

Icho Chati Tools Tabs

Sezvinoratidzwa mumufananidzo uri pamusoro, kana chati iri kubudiswa muExcel, kana kana chero chati iripo yakasarudzwa nekutsvaga pairi, mamwe mafuti akawedzerwa akabatanidzwa kubhoni .

Aya mabhii Matati - Matongero uye maitiro - ane mafomati uye maitiro ekugadzirisa zvakananga pamatareti, uye achashandiswa mumatanho anotevera kuti apedze chinyorwa chati.

Kuchinja Chati Column Colors

Mukuwedzera pakushandura mararamiro echinyorwa chimwe nechimwe mu chati, chidimbu chinowedzerwa pamutsetse wega wega unoita mafomatiro imwe neimwe yechishanu nzira yekuita.

1. Dzvidza kamwechete pane zvinyorwa muhodhi - dzose mazamu mana muchati inofanira kusarudzwa
2. Dzvanya kechipiri pane Nyaya yezvinhu zvekushandisa mu chati - chete Nyaya yekushandisa inofanira kusarudzwa
3. Dzvanya ku Format yebhubhoni
4. Dzvanya paChimiro Chizadza chinyorwa kuti uzarure mifananidzo yeTill Colors
5. Muchikamu cheClass Colors pane menyu sarudza Blue
6. Dzvanya paChimiro Chizadza sarudzo kechipiri kuti uzarure menyu
7. Hover the mouse pointer pamusoro peGradient sarudzo pedyo nezasi kwe menyu kuti uzarure mifananidzo ye Gradient
8. Muchiedza chekusiyanisa chikamu cheGradient menu, chengetedza pane sarudzo yokutanga ( Linear Diagonal - Kuruboshwe Kwekuru Kumusoro Kurudyi ) kuti uwedzere ichi chidimbu kuNyaya yezvinhu
9. Dzvidza kamwechete paUtilities column in the chart - chete Utilities column inofanira kusarudzwa
10. Dzvanya paChifananidzo Chizadza icon uye wosarudza Red kubva kuClass Standard Colors yemenyu
11. Dzokorora matanho 6 kusvika ku8 kumusoro kuti uwedzere chidimbu kuUtilities column
12. Dzokorora kamwe chete paTendori yekutakura uye dzokorora matanho 10 ne11 kumusoro kuti uchinje chinyorwa chekutakura kusvika kuGreen uye kuwedzera chidimbu
13. Dzokorora kamwe chete paNhare yeChina uye dzokorora matanho 10 ne11 pamusoro apa kuti uchinje Nhumbi yekuchengetedza kune Purple uye kuwedzera mardient
14. Mavara emakona mana ari muchati anofanirwa kuenzana nevaya vakaratidzwa mumufananidzo peji 1 yekudzidzisa

Kuwedzera Gwara uye Kuchenesa X Axis Labels

Iye zvino kuti chinyorwa chimwe nechimwe chine ruvara rwakasiyana, nheyo inogona kuwedzerwa pasi pemutauro wechati uye mabhii eX axis pasi pe chati iri kubviswa

1. Dzvanya pamatare echechi kuti usarudze chati yose
2. Dzvanya paGadziriro yebhubhoni
3. Dzvanya paAd Add Chart Element icon pane kuruoko rworuboshwe rwebhoni kuitira kuti uzarure mhuka inodonha
4. Sarudza Nharo> Pamusoro kubva pakurongwa kuti uwedzere nhepfenyuro iri pamusoro penzvimbo yemunda
5. Kamwe kamwe pane mazai e-axis X - mazita emutsetse pasi pe chati - kuti uasarudze
6. Dhinda reChenesa kiyi pane keyboard kuti ubvise mavara aya

05 of 06

Kufambisa Dhiyabhorosi Dhiyabhorosi uye Kuwedzera Mifananidzo Yecheti

Kugadzirisa Basa Renyu

Nhanho dzinoverengeka dzinotevera dzekudzidzisa dzichishandisa shanduko yekuita basa , iyo ine zvakawanda zvekugadzirisa mafungiro anowanika pamataiti.

MuExcel 2013, kana yakagadziridzwa, pane pane pane inowanikwa kuruoko rworudyi rweEccel chinyorwa sezvazvinoratidzwa mumufananidzo uri pamusoro. Musoro uye zvisarudzo zvinowanikwa munzvimbo dzakasiyana-siyana zvinoshandiswa zvichienderana nenzvimbo yechati inosarudzwa.

Kufambisa Dhiyabhorosi Dhiyabhorosi

Iyi danho ichafambisa mazita ekudhinda mukati memusoro wehandi imwe neimwe.

1. Dzvidza kamwechete pane 64% yepeyiti yedhidzi pamusoro peMakoronike emhando mu chati - zvose mavara emadhadhi mana muchati inofanira kusarudzwa
2. Dzvanya pa Format Format yebhoni kana zvichidiwa
3. Dzvanya paKutora Kusarudzwa Kwemafaira kune rumwe rutivi rworuboshwe rwebhoni kuitira kuti uzarure Pikicha Rakashandura Rutivi kurudyi rwekona
4. Kana zvichidikanwa, chengetera pane Options Options pane pane kuti uzarure zvirongwa zveraire sezvinoratidzwa mumufananidzo pamusoro apa
5. Dzvanya paIndaneti yekupedzisira mukati mechiratidziro nzvimbo panzvimbo yepamusoro kuti uende mavara ose emadhadharo mukati memusoro weiyo ma column

Kuwedzera Mifananidzo yeChirati

Kuwedzera mapuranga echati kuchatibvumira kuti tiwedzere huwandu hwemashoko emarenda e data, zvichiita kuti zvive nyore kuverenga.

Nekufambisa Task pane pane yakazaruka,

1. Dzvidza kamwechete paImakorani yezvinhu Zvigadzirwa muchati - zvese mazamu mana muchati inofanira kusarudzwa
2. Kana zvichidikanwa, chengetera pane Options Options pane pane kuti uzarure zvatevedzana zvatevedzeri
3. Isa Gari Kuwedzera kusvika ku40% kuti uwedzere hupamhi hwemashure mana mana mu chati

Kuwedzera Shadow kune Column yoga yoga

Nhanho iyi ichawedzera mumvuri shure kweumwe wemutsara mu chati.

Nekufambisa Task pane pane yakazaruka,

1. Dzvidza kamwechete paImakorani yezvinhu Zvigadzirwa muchati - zvese mazamu mana muchati inofanira kusarudzwa
2. Dzvidza kamwechete paMigumisiro yemaziso mufomati yepamusoro kuti uzarure zvatevedzana zvatevedzana
3. Dzvidza kamwechete paShadow musoro kuti uzarure mumashure masarudzo
4. Vhura mahedheni akafananidza mapeji nekudhinda pa Presets icon
5. Muchikamu cheMafungiro , chengeta paPepective Diagonal Upper Right icon
6. Mvuri inofanira kuonekwa shure kwega imwe yemapuranga echati

06 of 06

Kuwedzera Pasi Remavara Akakura uye Kufambisa Rugwaro

Kuwedzera Chimiro Chakasira Gradient

Iyi danho ichawedzera chivara chemavara kumucheto uchishandisa zvingasarudzwa muIttingting Task pane iyo inoratidzwa mumufananidzo uri pamusoro.

Kana pasina matatu katatu inomira apo panopfigwa, shandisai kuwedzera / kubvisa maitiro ekumira zvishoma pedyo ne-gradient stop bar kuti uise nhamba kuitatu.

Nekufambisa Task pane pane yakazaruka,

1. Dzvanya kumucheto kuti usarudze iyo yose grafu
2. Dzvanya paIzadza neRin'i icon (iyo pende inogona) mukati
3. Dzvanya paDzadza uchitungamira kuti uzarure zvingasarudzwa
4. Dzvanya paChidient sarudzo mune urongwa kuti uzarure chikamu chechidimbu pasi apa pane pane
5. Muchikamu chechididient, chengetedza kuti uone kuti Rudzi rwekutsvaga runoshandiswa kuNow Linear
6. Ita Mutungamiri sarudzo kune Linear Down kuti ugadzire nzvimbo yakasvibiswa yakasvibiswa sezvinoonekwa mumufananidzo uri papeji 1
7. Muchi Gradient inogadzirisa bar, tora pane kuruboshwe rwema-gradient stop
8. Iva nechokwadi chokuti iyo Position value ndeye 0%, uye isa mutsara wakazadza kuMucherechedzo Wacho 1 uchishandisa mukana weropa pasi apa
9. Dzvanya pakati pepakati pekumira
10. Iva nechokwadi chekuti Position yake yakagadzirwa ne 50%, uye gadzira marara ayo akazadza kuTan Background 2 Mumiririri 10% kuchinja pakati pemadidient stop color to light tan
11. Dzvanya pamusana wekodzero yakasimba
12. Iva nechokwadi chokuti iyo Position value ndeye 100%, uye isa marimu ayo akazadza kuMucherechedzo 1

Kushandura Mutauro Wemafaira, Kukura, uye Kuratidza

Kuchinja ukuru uye rudzi rwefonti rinoshandiswa mu chati, hakusi kungovandudzika pamusoro pemhando yekushandiswa inoshandiswa mu chati, asi zvichaitawo kuti zvive nyore kuverenga mazita emasikirwo uye mazano e data mu chati.

Cherechedza : Uhu hwefonti hunotaridzwa pamakona - kazhinji hupfupiswa kusvika pt .
72 pt manyorero akaenzana ne inch (2.5 cm) muhukuru.

1. Kamwe kamwe pane chinyorwa chechati kuti uchisarudzire
2. Dzvanya paImba yebhu yebhoni
3. Muchikamu chetimiro rebhoni, tsvaga paBhokisi rePolisi kuti uzarure pasi rezasi rwemavara akawanikwa
4. Mipumburu kuti uwane uye tora pafonti Bondini MT Black mumutsara unoshandura musoro kune iyi faira
5. MumaSpain Size box pedyo nefonti yebhokisi, sarudza musoro weusita we18 pt
6. Dzokorora kamwe chete munhego kuti uisarudze
7. Uchishandisa matanho ari kumusoro, gadzira rugwaro rwemashoko kusvika ku10 pt Bondini MT Black
8. Dzvidza kamwechete pane 64% yedheta rekushandisa muChinyorwa chekushandisa mukati mechati - zvinyorwa zvese zvepa data mu chati zvinofanira kusarudzwa
9. Isai mazita ematarenda kune 10.5 pt Bondini MT Black
10. Neyodhadhi dzema data dzichiri kusarudzwa, tora pa Font Font icon ibhoni (tsamba A) kuti uzarure jira rePaul Pavara
11. Dzvanya pa White Background 1 muvara mavara mukati mejeri kuti uchinje data yepeti yevaravara yemuvara kune mutsvuku

Panguva ino, kana iwe wakatevera matanho ose mune izvi zvidzidzo, chati yako inofanira kuenzanisa muenzaniso wakaratidzwa peji 1.