Fetola Column Colours le Show Percent Data Data Labels

Ka tloaelo, mochine o bontšitsoeng ka lebokose kapa mofo o bontšang likhakanyo tse behiloeng kapa palo ea linako tse ling bohlokoa ba teng ka nako e behiloeng. Nako e telele mohala, palo e kholoanyane ea bohlokoa ba teng.

Ho phaella moo, chate e atisa ho bontša letoto la dintlha tse ngata ka mohala o mong le o mong letotong leo e leng 'mala o le mong.

U sebelisa libopeho tse fumanehang Excel, ho ka khoneha hore u be le chate ea molumo oa litepisi ho etsisa chate ea pie le pontšo

• mela e fapaneng ea mebala bakeng sa ntlha ka 'ngoe ea lihlopha tse le' ngoe tsa data
• boleng ba peresente hore moeli ka mong o emela chelete eohle

Ho latela mehato ea thupelo ena ho tsamaea le uena ha u bōpa le ho etsa moralo oa chate e bontšitsoeng setšoantšong ka holimo.

Hlokomela:
* Haeba o thahasella feela ho fetola mabitso a data ho bonts'a li-percents, tlhahisoleseding e ka fumanoa leqepheng la 3 la thuto ena
* Ho fetola mebala e mebala e ka fumanoa leqepheng la 4

01 ea 06

Mehato e 6 ea ho etsa setšoantšo sa Chate ea Column ka Excel

Tlhokomeliso ea Sehlooho sa Colours ea Excel

Excel, joaloka tsohle tsa mananeo a Microsoft Office, e sebelisa lihlooho ho beha ponahalo ea litokomane tsa eona.

Sehlooho se sebelisetsoang thupelo ena ke sehlooho sa Wood Type .

Haeba u sebelisa sehlooho se seng ha u ntse u latela thuto ena, mebala e thathamisitsoeng mehato ea lithupelo e ka 'na ea se ke ea fumaneha sehloohong seo u se sebelisang. Haeba ha ho joalo, khetha feela mebala ho seo u se ratang e le libaka le ho tsoela pele.

02 ea 06

Ho qala ka Chate ea Column

Ho kenya le ho khetha Tutorial Data

Ho kenya dintlha kamehla ke mohato oa pele oa ho bopa chate - ho sa tsotellehe hore na ho na le chate ea mofuta ofe.

Mohato oa bobeli ke ho totobatsa lintlha tse lokelang ho sebelisoa ho theha chate.

1. Kenya data e bontšitsoeng setšoantšong ka holimo ho lisele tse nepahetseng tsa lisebelisoa
2. Hang ha o kene, o totobatsa lisele tsa lisele tse tsoang A3 ho ea ho B6

Ho theha Letlapa la Motheo oa Leqhoa

Mehato e latelang e tla hlahisa leseli la motheo la mohala-e leng lethathamo le hlakileng, le sa tsejoang - le bonts'ang lihlopha tse khethiloeng tsa data le likhahla.

Mehato e latelang ho theha sekoahelo sa chate mokhoa oa ho sebelisa tse ling tsa likarolo tse tloaelehileng tsa ho etsa litlhaloso, tseo, haeba li lateloa, li tla fetola chate ea motheo ho tšoantša lechate la lihlooho tse bontšitsoeng leqepheng la 1 la thuto ena.

1. Tobetsa ho kenya Taba ea lithane
2. Ka lebokose la Charts la lithane, tobetsa letšoao la Letlapa la Khaleng ho bula lenane la theoha la mefuta e fumanehang ea graph / chart
3. Tlosa pointer ea mouse holima mofuta oa chate ho bala tlhaloso ea chate
4. Tobetsa ka Khoeli e Patiloeng - khetho ea pele karolong ea 2-d Karolo ea lenane - ho e khetha
5. Taba ea motheo ea mohala e thehiloe mme e behoa leqepheng la mosebetsi

Ho eketsa Title Chart

Fetola Mongolo oa Chate ka ho feletseng ka ho o tobetsa ka makhetlo a mabeli - empa u se ke ua penya habeli

1. Tobetsa ka lekhetlo le le leng sehloohong sa chate e le hore u se khethe - lebokose le lokela ho hlaha ho potoloha mantsoe a Chate ea Toro
2. Tobetsa ka lekhetlo la bobeli ho beha Excel ka mokhoa oa ho fetola , e leng sebaka se ka har'a lebokose la sehlooho
3. Tlosa mongolo o sa sebelisoang ka ho sebelisa linotlolo tsa Delete / Backspace ho lebokose
4. Kenya sehlooho sa chate - Lits'enyehelo tsa July 2014 - lebokoseng la sehlooho

03 ea 06

Ho eketsa Labels ea Data joaloka Percents

Ho tobetsa Karolong e Fosahetseng ea Chate

Ho na le likarolo tse fapaneng ho chate e Excel - e kang sebaka sa sebopeho se nang le lihlopha tse emelang lihlooho tse khethiloeng tsa data , lihlahisoa tse totobetseng le tse totobetseng, sehlooho sa chate le mabitso, le li-grid line tse holimo.

Mehatong e latelang, haeba liphetho tsa hau li sa tšoane le tse thathamisitsoeng thupelong, ho ka etsahala hore ebe ha u na karolo e nepahetseng ea chate e khethiloeng ha o kentse khetho ea ho etsa mekhoa.

Phoso e tloaelehileng ka ho fetisisa ke ho tobetsa sebakeng sa mohaho bohareng ba graph ha morero oa ho khetha graph eohle.

Tsela e bonolo ka ho fetisisa ea ho khetha lirapa kaofela ke ho tobetsa ka holimo ho le letšehali kapa ka ho le letona ho tloha mohloling oa chate.

Haeba phoso e etsoa, ​​e ka lokisoa ka potlako ka mokhoa o hlalosang oa Excel ho fetola phoso. Ka mor'a moo, tobetsa karolong e nepahetseng ea chate mme leka hape.

Ho eketsa Labels tsa Data

1. Tobetsa ka lekhetlo le le leng ho lintlheng tsa lisebelisuoa - litšiea tse 'nè ka chate li lokela ho khethoa
2. Tobetsa ka ho le letona ho lisebelisoa tsa lisebelisoa ho bula mecha ea litaba ea lihlooho tsa data
3. Nthong ea moelelo oa litaba, hulela mouse ka holimo ho kgetho ea Add Data Labels ho bula menu ea moelelo oa bobeli
4. Nthong ea bobeli ea litaba, kopa ho Add Labels Labels ho kenyelletsa mabitso a data ka holimo ho moqolo ka mong chate

Ho fetola Labele ea Ditaba ho Bontša Percent

Mabitso a hona joale a data a ka fetoloa ho bonts'a karolo ea karolo e 'ngoe le e' ngoe ka chate e emela litsenyehelo tsohle ka ho sebelisa lisele tsa litekanyetso tsa litefello tsa chelete e thathamisitsoeng karolong ea C ea tafoleng ea data ka mokhoa o itseng .

Mabitso a kamehla a data a tla hlophisoa ka ho tobetsa habeli e 'ngoe le e' ngoe, empa, hape, u se ke ua tobetsa habeli.

1. Tobetsa ka lekhetlo le le leng ka lebokose la data la 25487 ka holimo ho Lintlha tsa lisebelisoa ka chate - litekete tse 'nè tsa dintlha tsa chate li lokela ho khethoa
2. Tobetsa ka lekhetlo la bobeli lebokose la lisebelisoa tsa lisebelisuoa - ke feela lengolo la data la 25487 le lokelang ho khethoa
3. Tobetsa hang ka lebota la foromo ka tlas'a letlapa
4. Kenya foromo = C3 mohareng oa lebota mme o tobetsa konopo ea Kena ho lebokose
5. Lethathamo la data la 25487 le lokela ho fetoha ho bala 46%
6. Tobetsa ka lekhetlo le le leng ka lebokose la data la 13275 ka holimo ho lintlha tsa Utilities ka chate - feela hore letšoao la data le khethoe
7. Kenya mokhoa o latelang : C4 kahare ea mokoetliso mme o tobetsa konopo ea ho kena
8. Lethathamo la data le tlameha ho fetoha ho bala 24%
9. Tobetsa ka lekhetlo le leng ho letšoao la data la 8547 ka holimo ho mohala oa lipalangoang ka chate - feela hore letšoao la data le khethoe
10. Kenya mokhoa o latelang : C5 ka mohareng o lebisitsoeng mme o tobetsa konopo ea ho kena
11. Lethathamo la data le tlameha ho fetoha ho bala 16%
12. Tobetsa ka lekhetlo le le leng ka lebokose la data la 7526 ka holim'a Sesebelisoa sa lisebelisoa ka chate - feela hore letšoao la data le khethoe
13. Kenya mokhoa o latelang : C6 kahare ea baromoro mme o tobetsa konopo ea ho kena
14. Lethathamo la data le tlameha ho fetoha ho bala 14%

Ho tlosa Gridline le Vertical Axis Labels

1. Ketsahaleng, tobetsa hang kamora li-20 000 tse tsamaeang ka hare ho mohaho - khalase eohle ea li- grid e lokela ho totobatsoa (lihlopha tse nyenyane tsa leputso qetellong ea gridline ka 'ngoe)
2. Tobetsa konopo ea Tlosa ho lebokose ho tlosa khalase ea marang-rang
3. Tobetsa ka lekhetlo le le leng mabitso a li-axis Y - lipalo ka lehlakoreng le letšehali chate - ho li khetha
4. Tobetsa konopo ea Tlosa lebokoseng ho tlosa mabitso ana

Hona joale, haeba mehato eohle e ka holimo e latetsoe, chate ea hau ea molaleng e lokela ho tšoana le chate e setšoantšong ka holimo.

04 ea 06

Ho fetola Tsela Column Colors le Ho eketsa Legend

Litlhaku tsa Chart Tools

Joalokaha ho bontšitsoe setšoantšong se ka holimo, ha chate e bōptjoa Excel, kapa neng kapa neng ha chate e teng e khethiloe ka ho e sheba, litapole tse peli tse eketsehileng li kenngoa ka leboneng .

Litheba tsena tsa Matla a Chart - moralo le moralo - li na le lihlopha le likhetho tse khethehileng bakeng sa lichate, 'me li tla sebelisoa mehatong e latelang ho tlatsa chate ea mohala.

Ho fetola Chart Column Colors

Ntle le ho fetola 'mala oa karolo e' ngoe le e 'ngoe ka chate, karolo e kholo e kenyelletsoa ho e' ngoe ea likarolo ho etsa moralo o mong le o mong mohato oa mehato e 'meli.

1. Tobetsa ka lekhetlo le le leng ho lintlheng tsa lisebelisuoa - litšiea tse 'nè ka chate li lokela ho khethoa
2. Tobetsa ka lekhetlo la bobeli lintlheng tsa lisebelisuoa ka chate - feela lisebelisoa tsa lisebelisoa li lokela ho khethoa
3. Tobetsa ho Temo ea tabeng
4. Tobetsa Letšoao la Tlatsa Fumana ho bula menu ea Fill Colors
5. Karolong ea Standard Colors ea menu khetha Blue
6. Tlanya ka khetho ea Tsela ea ho tlatsa ka lekhetlo la bobeli ho bulela menyetla hape
7. Hover pointer ea mouse holim'a khetho ea Gradient haufi le tlase ho menu ho bula menu ea Gradient
8. Ka karolo ea Light Variations ea menu e kholo, tobetsa kgetho ea pele ( Linear Diagonal - Top Left ho ea ka tlaase ka ho le letona ) ho kenyelletsa setšoantšo sena ho Lintlheng tsa lisebelisoa
9. Tobetsa ka lekhetlo le le leng ho Sesebelisoa sa Utilities ka chate - sehlahisoa sa Utilities feela se lokela ho khethoa
10. Tobetsa Letšoao la Tlatsa Fumana 'me u khethe Bofubelu ho tloha karolong ea Standard Colors ea menu
11. Pheta mehato ea 6 ho isa ho ea 8 ka holimo ho kenyeletsa mohala ho Utilities column
12. Tobetsa ka lekhetlo le le leng ka lethathamong la Lipalangoang 'me u phete mehato ea 10 le ea 11 ka holimo ho fetola khoeli ea Tsamaiso ho ea ho Green le ho eketsa mohala
13. Tobetsa hang-hang ho Sesebelisoa sa lisebelisoa mme u pheta mehato ea 10 le ea 11 ka holimo ho fetola Thepa ea lisebelisoa ho Purple le ho eketsa lintlha
14. Mebala ea lihlopha tse 'nè chate e lokela ho bapisa le ba bontšitsoeng setšoantšong leqepheng la 1 la thuto

Ho eketsa Litaba le ho tlosa li-Lab Axis Labels

Hona joale hore karolo e 'ngoe le e' ngoe ke 'mala o fapaneng, pale e ka kenyelletsoa tlas'a sehlooho sa chate le mabitso a X axis ka tlase ho chate e tlosoa

1. Tobetsa mokokotlong oa chate ho khetha chate kaofela
2. Tobetsa Taba ea Design ea Ribbon
3. Tobetsa letšoao la Add Chart Element ka lehlakoreng le letšehali la ribone ho bula menu e theoha
4. Khetha Mongolo> Holimo ho tsoa lethathamong ho kenya tlhaloso ka holimo ho sebaka sa mohaho
5. Tobetsa ka lekhetlo le le leng mabitso a li-axis tsa X - mabitso a ka tlas'a chate - ho ba khetha
6. Tobetsa konopo ea Tlosa lebokoseng ho tlosa mabitso ana

05 ea 06

Ho tsamaisa Labelle ea Data le Ho Atolosa Liqhobo tsa Chate

Ho hlahisa Pina ea Mosebetsi

Mehato e seng mekae e latelang ea thupelo e sebelisa mokhoa oa ho etsa melaetsa ea setšoantšo, e nang le boholo ba likhetho tse fanoang bakeng sa lichate.

Ka Excel 2013, ha e ts'oaroe, phaposi e hlaha ka letsohong le letona la skrine ea Excel joalokaha ho bontšoa setšoantšong se ka holimo. Sehlooho le lits'ebetso tse hlahang ho phapanyetsano ea liphahlo ho latela sebaka sa chate e khethiloeng.

Ho tsamaisa Labelle ea Data

Mohato ona o tla tsamaisa mabitso a data ka hare ho karolo e 'ngoe le e' ngoe.

1. Tobetsa ka lekhetlo le leng holim'a lebokose la data la 64% ka holimo ho Lintlha tsa lisebelisoa ka chate - litekete tse 'nè tsa data tsa chate li lokela ho khethoa
2. Tobetsa ho Thabiso ea tabeng ha ho hlokahala
3. Tobetsa ka khetho ea Khetho ea Phatlalatso ka lehlakoreng le letšehali la lithane ho bula pontšo ea Temo ea Temo ka lehlakoreng le letona la skrine
4. Haeba ho hlokahala, tobetsa letšoao la Options ka har'a lehare ho bula likhetho tseo u li khethileng tse bontšitsoeng setšoantšong se ka holimo
5. Tobetsa ho kgetho ea ka hare ho ka hare ho sebaka sa lebokose sebakeng sa ho palame ho tsamaisa mabitso a mane a data holimo ka hare ho lihlopha tse latelang

Ho atolosa Columns ea Chate

Ho atolosa melamu ea chate ho tla re nolofalletsa ho eketsa boholo ba mongolo oa mangolo a data, ho ba nolofalletsa ho bala.

Ka Settingting Task pane e bulehileng,

1. Tobetsa ka lekhetlo le le leng ho lintlheng tsa lisebelisuoa ka chate - likarolo tse 'nè ka chate li lokela ho khethoa
2. Haeba ho hlokahala, tobetsa konopo ea Options u le ka holim'a holimo ho bula lihlooho tsa lihlooho
3. Beha bophara ba Gap ho 40% ho eketsa bophara ba lihlopha tse 'nè ka chate

Ho ekelletsa ho Shadow To Column ka 'ngoe

Mohato o tla eketsa moriti ka mongolo o mong le o mong ka chate.

Ka Settingting Task pane e bulehileng,

1. Tobetsa ka lekhetlo le le leng ho lintlheng tsa lisebelisuoa ka chate - likarolo tse 'nè ka chate li lokela ho khethoa
2. Tobetsa hang-hang ho letšoao la Tlhōlisano ho setting pane ho bula lihlopha tsa lihlooho
3. Tobetsa ka lekhetlo le leng sehloohong sa Shadow ho bula likhetho tsa moriti
4. Bula setšoantšo sa lihlopha tsa setšoantšo ka ho tobetsa letšoao la Presets
5. Karolong ea Phatlalatso , tobetsa ho Letšoao la Diagonal Upper Right
6. Setšoantšo se lokela ho hlaha ka mor'a mela e 'ngoe ea chate

06 ea 06

Ho eketsa Mobala oa Mobala oa Mobala le ho Fetola Lengolo

Ho eketsa Karolo ea Mobala oa Mobala

Mohato ona o tla eketsa mobala oa mebala ka morao ho sebelisa dikgetho ho Settingting Task pane ho bontšoa setšoantšong se ka holimo.

Haeba ho na le li-gradient tse tharo tse khaotsang ho hlahisa ha pampiri e buloa, sebelisa lisebelisoa tsa ho eketsa / ho tlosa litšoantšo tse emang haufi le bar barent stop ho beha nomoro ho ea boraro.

Ka Settingting Task pane e bulehileng,

1. Tlanya ka morao ho khetha mohaho oohle
2. Tobetsa letšoao la Tlatsa le Linaele (pente e ka ba) ka holim'a marang-rang
3. Tlanya ho Tlatsa ho tsamaisa ho bula likhetho tse tlatsitsoeng
4. Tobetsa ho kgetho e ntle ho lenaneng ho bula karolo ea mahlakoreng ka tlase ho pane
5. Karolong e hlahlamang, hlahloba ho netefatsa hore Mofuta oa mofuta o khethoa ho Linear e sa lekanyetsoang
6. Beha khetho ea Direction ho Linear Down ho theha setšoantšo se sa tsitsang sa morao ho latela setšoantšo se leqepheng la 1
7. Ka Gradient e emisa bar, tobetsa seteishene se seholo ka ho fetisisa se letšehali
8. Etsa bonnete ba hore boemo ba eona ba Position ke 0%, 'me u behe mmala o khotsofatsang ho Ts'ebetso e Tšoeu ea pele 1 u sebelisa khetho ea mebala ka tlase ho setopo
9. Tobetsa bohareng bo bohareng ba setopo
10. Etsa bonnete ba hore Palo ea eona ea boemo ke 50%, 'me u behe mmala o khotsofatsang ho Tan Background 2 Ntle ho 10% ho fetola mmala o bohareng oa phapang pakeng tsa tane e khanyang
11. Tobetsa seteishene se nepahetseng ka ho fetisisa
12. Etsa bonnete ba hore boemo ba eona ba Position ke 100%, 'me u behe mmala o khotsofatsang ho Ts'ebetso e Tšoeu 1

Ho fetola mofuta oa Font, Size, le Mobala

Ho fetola boholo le mofuta oa fonte o sebelisitsoeng ka chate, ha se feela ntlafatso ho feta molaetsa o sa sebelisoang ka chate, empa hape o tla nolofalletsa ho bala mabitso a lihlopha le litekanyetso tsa data ka chate.

Tlhokomeliso : Boholo ba font e lekantsoe lintlheng - hangata li khutšoanyane ho pt .
Mongolo oa 72 pt o lekanang le lisenthimithara tse 2,5 ka boholo.

1. Tobetsa hang ka sehlooho sa chate ho se khetha
2. Tobetsa Thabeng ea Lehae ea Ribbon
3. Karolong ea fonte ea lithane, tobetsa lebokoseng la Font ho bula lenane la theoha la li-fonte tse fumanehang
4. Moqolo ho fumana le ho tobetsa fonong Bondini MT Black lethathamong ho fetola sehlooho ho font
5. Ka lebokoseng la Font Size haufi le lebokose la fonte, beha boholo ba taele ea sehlooho ho 18 pt
6. Tobetsa hang ka tlhōlo ho e khetha
7. U sebelisa mehato e ka holimo, beha temana ea legend ho 10 pt Bondini MT Black
8. Tobetsa ka lekhetlo le le leng ho e-na le label ea 64% ea lisebelisoa tsa lisebelisoa tsa lisebelisuoa - litekete tse 'nè tsa dintlha tsa chate li lokela ho khethoa
9. Beha mabitso a data ho 10.5 pt Bondini MT Black
10. Ka mabitso a data a ntseng a khethiloe, tobetsa letšoao la Font Color la Ribbon (lengolo A) ho bula marang-rang a Font Font
11. Tobetsa Tlase e Tlasehileng 1 mmala oa khetho ho lehlakoreng ho fetola lesela la sebopeho sa melaetsa ho tšoeu

Hona joale, haeba u latetse mehato eohle ea thupelo ena, chate ea hau e lokela ho bapisa mohlala o bontšitsoeng leqepheng la 1.