Tsela ea ho Etsa le ho bopa Setšoantšo sa Column ho Excel 2010

01 ea 06

Mehato ea ho etsa Chart ea Column ho Excel 2010

Litepisi tsa ho theha motheo oa khalase ea motheo ho Excel 2010 ke:

1. Totobatsa litlaleho tse kenyelletsoang ka chate - kenyeletsa lihlooho tsa mela le lihlooho empa eseng sehlooho sa tafoleng ea data;
2. Tobetsa ho kenya Taba ea lithane ;
3. Ka lebokose la Charts la lithane, tobetsa letšoao la Letlapa la Khaleng ho bula lenane la theolelo ea mefuta ea lichate e fumanehang;
4. Tlosa pointer ea mouse holima mofuta oa chate ho bala tlhaloso ea chate;
5. Tobetsa ka chate e lakatsehang;

Chate e hlakileng, e sa tsejoang-e bontsang letoto la data le khethiloeng feela, pale, le likhetho -a tla ekeletsoa leqepheng la kajeno la mosebetsi .

Ho se tšoane ha Version ho Excel

Litepisi tsa thupelo ena li sebelisa mekhoa ea ho etsa litlhaloso le mekhoa e fumanehang Excel 2010 le 2007. Tsena li fapane le tse fumanoang liphetolelong tsa pele le tsa morao-rao. Sebelisa li-link tse latelang bakeng sa lithuto tsa tatellano ea lihlooho tsa liphetolelo tse ling tsa Excel.

• Tlhahlobo ea Chart ea Column ea 2013
• Excel 2003 (le liphetolelo tsa pejana) Tutori ea Chate ea Column

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 thuto ena ke sehlooho se setsi sa ofisi .

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 ho joalo, khetha feela mebala ho seo u se ratang e le se nkang sebaka le ho tsoela pele.

• Ho hlahloba le ho fetola sehlooho sa hona joale sa buka ea mosebetsi

02 ea 06

Ho theha Letlapa la Motheo oa Column ka Excel

Ho kenya le ho khetha Tutorial Data

Tlhokomeliso: Haeba u se na data e lekaneng ho e sebelisa ka thupelo ena, mehato ea thupelo ena e sebelisa lintlha tse bontšitsoeng setšoantšong se ka holimo.

Bohato ba pele ha ho bōptjoa chate kamehla bo kena ka tatellano ea lintlha - 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.

Ha o khetha data, lihlooho le lihlooho tsa lihlooho li kenngoa ho khethiloeng, empa sehlooho se ka holimo ho tafoleng ea data ha se joalo. Sehlooho se tlameha ho kenyelletsoa ka chate ka letsoho.

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 tloha A2 ho ea ho D5 - ena ke lethathamo la data le tla emisoa ke chate ea molumo

Ho theha Letlapa la Motheo oa Leqhoa

1. Tobetsa ho kenya Taba ea lithane
2. Ka lebokoseng la Charts la lithane, tobetsa letšoao la Letlapa la Khaleng ho bula lenane le theoha la mefuta ea lichate e fumanehang
3. Tlosa pointer ea mouse holima mofuta oa chate ho bala tlhaloso ea chate
4. Karolong ea 3-D e kenyelletsoeng lethathamong la lethathamo, tobetsa ka Khoeli e Patiloeng - ho eketsa chate ea motheo ts'ebetsong ea mosebetsi

03 ea 06

Excel Chart Parts le ho tlosa Gridline

Ho tobetsa Karolong e Fosahetseng ea Chate

Ho na le likarolo tse ngata tse fapaneng ho chate e Excel - e kang sebaka sa sephetho se nang le chate ea molumo e emelang lihlooho tsa data , pale, le sehlooho sa chate.

Likarolo tsena kaofela li nkoa e le lintho tse fapaneng le lenaneong, 'me ka hona, e mong le e mong a ka etsoa ka tsela e ikemetseng. U bolella Excel karolo efe ea chate eo u batlang ho e etsa ka ho tobetsa ho eona ka pointer ea mouse.

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 atisang ho etsoa ke ho tobetsa sebakeng sa mohaho bohareng ba koloi ha morero oa bona ke ho khetha chate kaofela.

Tsela e bonolo ka ho fetisisa ea ho khetha chate 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 tlosa Gridline ho tloha Sebakeng sa Sebaka

Moelelo oa motheo oa li-graph o kenyelletsa lethathamo la marang-rang le tsamaeang ka hohle hohle sebakeng sa mohaho ho etsa hore ho be bonolo ho bala litekanyetso tsa lintlha tse itseng tsa data - haholo-holo lichabeng tse nang le boitsebiso bo bongata.

Kaha ho na le lihlopha tse tharo feela tsa lintlha ka chate ena, lintlha tsa lintlha li bonolo ho li bala, kahoo linea sa marang-rang se ka felisoa.

1. Ketsahaleng, tobetsa hang ka chelete ea $ 60,000 e tsamaeang ka bohareng ba graph ho totobatsa linepe tsohle tsa marang-rang - mebala e nyane ea leputsoa e lokela ho bonoa qetellong ea gridline e 'ngoe le e' ngoe
2. Tobetsa konopo ea Tlosa ho lebokose ho tlosa maralla

Ka nako ena, chate ea hau e lokela ho tšoana le mohlala o bontšitsoeng setšoantšong se ka holimo.

04 ea 06

Ho fetola Mongolo oa Chate

Litlhaku tsa Chart Tools

Ha chate e bōptjoa Excel 2007 kapa 2010, kapa neng kapa neng ha chate e teng e khethiloe ka ho e sheba, litebelisoa tse ling tse tharo li kenyelletsoa leboneng joalokaha ho bontšitsoe setšoantšong se ka holimo.

Litebelisoa tsena tsa Chart Tools - Design, Layout, le Format - li na le lihlopha le likhetho tse khethehileng bakeng sa lichate, 'me li tla sebelisoa mehatong e latelang ea ho eketsa sehlooho ho dichate tsa kholumo le ho fetola mebala ea chate.

Ho eketsa le ho Fetola Toro ea Chate

Ho Excel 2007 le 2010, lichate tsa motheo ha li kenye litlotla tsa chate. Tsena li tlameha ho kenyelloa ka mokhoa o arohaneng ho sebelisa khetho ea sehlooho sa Chate e fumanoang tabeng ea Layout mme e fetotsoe ho bontša sehlooho se lakatsehang.

1. Tobetsa hang ka chate ho e khetha, ha ho hlokahala, ho kenya lithapo tsa lisebelisoa tsa chate leboteng
2. Tobetsa ho Taba ea Mohaho
3. Tobetsa Lethatong la Chate khetho ho bula lenane la theoha la dikgetho
4. Khetha Chate e ka holimo ho lethathamong ho beha lebokose la lebokose la chate ka ho feletseng ka chate e ka holimo ho lihlopha tsa data
5. Tobetsa hang ka lebokoseng la sehlooho e le hore u fetole mongolo oa sehlooho oa kamehla
6. Tlosa temana e sa nepahaleng mme u kene sehlooho sa chate - Sehlooho sa Tlhahiso ea Khiro ea Cookie 2013 - ka lebokoseng la sehlooho
7. Beha sekhetho pakeng tsa Shop le 2013 sehloohong mme o tobetsa konopo ea ho kena ka lebokoseng ho arola sehlooho ho mela e 'meli

Ho fetola mofuta oa Font

Ho fetola mofuta oa mongolo o sebelisoang ka ho feletseng bakeng sa mongolo o mong le o mong ka chate ho ke ke ha ntlafatsa ponahalo ea chate feela, empa ho tla etsa hore ho be bonolo ho bala litlaleho le likhetho mabitso le litekanyetso.

Liphetoho tsena li tla etsoa ka dikgetho tse fumanehang karolong ea mongolo oa Thabiso ea Lehae ea Ribbon.

Tlhokomeliso : Boholo ba font e lekantsoe lintlheng - hangata li khutšoanyane ho pt.
72 pt. mongolo o lekana le inch - 2.5 cm - ka boholo.

Ho Fetola Toro Lengolo la Mongolo

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 Arial Black lethathamong ho fetola sehlooho ho toto ena

Ho fetola Tlhaloso ea Taba le Tsela

1. Pheta litepisi tse ka holimo ho fetola temana sechabeng sa chate le X le Y axes ho Arial Black

05 ea 06

Ho Fetola Mebala ka Charteng ea Column

Ho Fetola Mobala oa Lefatše le Lebala la Lehlakoreng

Mehato ena thupelong e kenyelletsa ho fetola 'mala oa mokatlane le lerako le lehlakoreng ho ea batsho joalokaha ho bonngoe setšoantšong se ka holimo.

• Mohareng oa chate ke lehlaka le holimo le ka tlaase ho litšiea tsa data sebakeng sa sebaka seo.
• Lerako le ka lehlakoreng le ka letsohong le letšehali la sebaka sa mohaho pakeng tsa likhaka tsa data le maele a li-Y (vertical) axis.

Lintho tse peli li tla khethoa ho sebelisa lethathamo la likarolo tse theohelang lethathamong le ka lehlakoreng le letšehali la Taba ea Layout ea lithane.

1. Tobetsa molaong oa chate ho khetha chate kaofela ha ho hlokahala
2. Tobetsa Thabeng ea Setha ea lithane
3. Ka chate eohle e khethiloeng, lintlha tsa litekanyetso li thathamisitse lebitso la Chate sebakeng se ka holimo sa lehlakoreng le letšehali la lithane.
4. Tobetsa motsu o ka tlase ho setšoantšo sa likarolo khetho ho bula lenane la theolelo ea likarolo tsa chate
5. Khetha Floor ho tloha lethathamong la likarolo tsa chate ho totobatsa mokatong oa chate
6. Tobetsa ho Temo ea tabeng
7. Tobetsa Tseleng ea Tsela ea ho tlatsa Tlatsa ho bula Mahlaseli a Tlatsa a theohela fatše
8. Khetha Black, Text 1 ho tloha karolo ea Theme Colors ea lehlakore ho fetola 'mala oa mokatla oa fatše ho ba batsho
9. Pheta mehato ea 2 ho ea ho 6 holimo ho fetola 'mala oa khalase e ka thōko ho lebota

Haeba u latetse mehato eohle tseleng, thutong ena, chate ea hau e lokela ho tšoana le e bonngoeng setšoantšong ka holimo.

06 ea 06

Ho fetola Column Colours le Ho Fetisa Chate

Ho Fetola Mobala oa Litšoantšo tsa Chate tsa Data

Mohato ona thutong o fetola ponahalo ea likhaka tsa dintlha ka ho fetola mebala, ho eketsa mobala, le ho eketsa kemiso ho moelelo ka mong.

Sebopeho se tlatsa le ho etsa likhetho tsa kemiso , tse hlahang tabeng ea Temo li tla sebelisoa ho ama liphetoho tsena. Liphetho li tla tšoana le lihlopha tse bonngoeng setšoantšong se ka holimo.

Ho fetola Mobala oa Column oa Lekhetho

1. Tobetsa ka lekhetlo le leng ho e 'ngoe ea likhalutsoana tsa Lekhetho la Likakaretso ka chate ho khetha lihlopha tse tharo tse putsoa
2. Tobetsa ho Thabiso ea tabeng ha ho hlokahala
3. Tobetsa Tseleng ea Tsela ea ho tlatsa Tlatsa ho bula Mahlaseli a Tlatsa a theohela fatše
4. Khetha Tlase e Lefubelu, Tlhahiso ea 2, Lesebelisoa 60% ho tloha karolong ea Sehlopha sa Lihlooho ho ea ho fetola 'mebala' ea 'mala ho ea putsoa

E eketsa ea Gradient

1. Ka melamu ea Total Revenue e sa ntse e khethiloe, tobetsa khetho ea Shape Fill ka lekhetlo la bobeli ho bula menyetla e theoha ea Fill Colors
2. Hover pointer ea mouse holim'a khetho ea Gradient haufi le tlase lethathamong ho bula Panopo e kholo
3. Karolong ea Phapang ea Leseli ea karoloana, tobetsa ho khetholla ka lehlakoreng le letona ho kenyelletsa setšoantšo se ntseng se le bobebe ho tloha ka letsohong le letšehali ho ea ka ho lehlakoreng la khoeli

Ho eketsa Kemiso ea Column

1. Ka melamu ea Total Revenue e sa ntse e khethiloe, tobetsa ho khetholla ka har'a Shape Outline ho bula menyetla ea ho theoha ea Outline
2. Karolong ea Standard Colours ea karoloana, khetha Lefifi le Lefubelu ho kenyelletsa kemiso e lefifi le letšo ho khoeli ka 'ngoe
3. Tobetsa ho khethollo ea khetho ka lekhetlo la bobeli
4. Tobetsa ho khethollo ea boima ho menu ho bula menyetla e tlaase ea dikgetho
5. Khetha 1 1/2 pt. ho eketsa botenya ba litlhaloso 'tsa kemiso

Ho fetola hohle litšenyehelo tsa lichelete

Pheta litepisi tse sebelisetsoang ho bopa melamu ea Total Revenue , u sebelisa mekhoa e latelang:

• Column Tlatsa Mobala: Bohale bo bofubelu 2, Lefifi le leholo 50%
• Boholo: Leseli le fapaneng , le letona le letona
• Column Outline Colour: Boitsebiso bo khubelu 2, Lefifi le leholo 50%
• Tlhaloso ea Boima ba Likhoeli: 1 1/2 pt.

Ho hlahisa Lenane la Melemo / Lahlehelo

Pheta litepisi tse sebelisetsoang ho bopa melamu ea Total Revenue , u sebelisa mekhoa e latelang:

• Column Tlatsa Mobala: Mohalaleli oa Mofuta oa Olive 3, Lefifi le 25%
• Boholo: Leseli le fapaneng , le letona le letona
• Column Outline Colour: Olive Green Accent 3, Lefifi le 50%
• Tlhaloso ea Boima ba Likhoeli: 1 1/2 pt.

Hona joale, haeba mehato eohle ea ho etsa mekhoa e latetsoe, chate ea moqolo e lokela ho tšoana le chate e bonngoeng setšoantšong ka holimo.

Ho fetisa Chate ho Lethathamo le arohaneng

Bohato ba ho qetela thupelong bo fetisetsa chate ho lekhasi le arohaneng bukeng ea libuka ho sebelisa lebokose la lebokose la Mochini oa Chart.

Ho tsamaisa chate ho letlapa le arohileng ho etsa hore ho be bonolo ho hatisa chate mme ho ka boela ha fokotsa tšubuhlellano ka leqephe le leholo la mosebetsi le tletseng dintlha.

1. Tobetsa mokokotlong oa chate ho khetha chate kaofela
2. Tobetsa Taba ea Design ea Ribbon
3. Tobetsa letšoao la Chate le tsamaeang ka lehlakoreng le letona la ribone ho bula lebokose la lebokose la Mochini oa Chart
4. Joalokaha ho bontšoa setšoantšong se ka holimo, tobetsa sekhetho se Ncha lebokoseng la lebokose le - ka khetho - fa lebitso lakane, e kang Cookie Shop 2013 Summary Summary
5. Tobetsa OK ho koala lebokose la lebokose - chate e lokela ho fumanoa ka letlapa le nang le lebitso le lecha le bonahalang tabeng ea lakane tlase ea skrine.