01 ea 09
Kenya Sekhetho sa Sebeli ho Chate ea Excel
Tlhokomeliso : Mehato e boletsoeng thutong ena e sebetsa feela bakeng sa liphetolelo tsa Excel ho fihlela ho kenyeletsang Excel 2010 .
Excel eu lumella ho kopanya mefuta e 'meli kapa e mengata e fapaneng ea chate kapa ea graph ho nolofalletsa ho bonts'a boitsebiso bo amanang hammoho.
Tsela e le 'ngoe e bonolo ea ho finyella mosebetsi ona ke ho eketsa molumo oa bobeli kapa o hokae oa Y ka lehlakoreng le letona la chate. Lihlopha tse peli tsa boitsebiso li sa ntsane li arolelana karolo e tloaelehileng ea X kapa e holimo tlaase ho chate.
Ka ho khetha mefuta e fapaneng ea chate - e kang chate ea kholumo le linepe ea line - pontšo ea lisebelisoa tse peli tsa data e ka ntlafatsoa.
Tloaelo e tloaelehileng bakeng sa chate ena e kopanyelletsa ho bonts'a mocheso oa khoeli le khoeli le data, ho etsa lintlha tse kang li-unit tse hlahisoang le litšenyehelo tsa tlhahiso, kapa khoeli ea khoebo ea khoebo le theko ea khoeli ea thekiso ea khoeli le khoeli.
Litlhoko tsa Chart tse kopantsoeng
- Ntho e hlokahalang ea hore data e bontšoe ke hore e lokela ho arolelana litekanyetso tsa X axis (tse hokae) - tse kang nako ea nako kapa sebaka.
- Hape, ha ho mefuta eohle ea chate e ka kopantsoang. Di-charts tsa 3-D, mohlala, ha li kenyelelitsoe ka chate e kopaneng.
Excel Climate Graph Tutorial
Thupelo ena e akaretsa mehato e hlokahalang bakeng sa ho kopanya likopi le lichate tsa line hammoho ho etsa mochine oa boemo ba leholimo kapa climatograph , e bontšang mocheso oa khoeli le khoeli oa mocheso bakeng sa sebaka se fanoeng.
Joalokaha ho bontšoa setšoantšong se ka holimo, mochine oa lebokose, kapa graph, o bontša moeli o tloaelehileng oa khoeli le khoeli ha mochine oa linepe o bonts'a maemo a mocheso oa mocheso.
Lithuto tsa Thuto
Mehato e latellitsoeng thupelong ea ho bopa mobala oa mocheso ke:
- E theha mochine oa motheo oa mebala e mabeli, e bonts'ang boemo ba leholimo le mocheso ka lihlopha tse sa tšoaneng tsa mebala
- Fetola mofuta oa chate bakeng sa data ea mocheso ho tloha melaong ho ea ho mola
- Tlosa data ea mocheso ho tloha ka lehlakoreng le ka pele la chate (ka lehlakoreng le letšehali la chate) ho ea ho lehlakoreng le ka lehlakoreng le leng (ka lehlakoreng le letona la chate)
- Etsa kopo ea mefuta ea fomati ho ea motheo oa mochine oa mocheso e le hore o lumellane le graph e bonngoeng setšoantšong ka holimo
02 ea 09
Ho kenya le ho khetha Ditaba tsa Graph tsa Boemo ba leholimo
Mohato oa pele oa ho bopa mochine oa boemo ba leholimo ke ho kenya data ka har'a leqephe .
Hang ha data e kenngoa, mohato o latelang ke ho khetha lintlha tse tla kenngoa chate.
Ho khetha kapa ho totobatsa dintlha ho bolella Excel hore na tlhahisoleseding efe e hlahang mosebetsing e kenyelletsa le eng e hlokomolohang.
Ntle le dintlha tsa nomoro, etsa bonnete ba hore o kenyeletsa tsohle tsa lihlooho le lihlooho tse hlalosang data.
Tlhokomeliso: Thupelo ha e kenyelle mehato ea ho etsa setšoantšo sa leqephe joalokaha ho bontšoa setšoantšong se ka holimo. Lintlha tse ka khethoang ka mokhoa oa ho etsa mokhoa oa mokhoa o fumanehang ka thupelo ena ea bohlokoa ka ho fetisisa .
Lithuto tsa Thuto
- Kenya data joalokaha ho bonahala setšoantšong ka holimo ho lisele tse A1 ho ea ho C14.
- Totobolla lisele tsa A2 ho C14 - ena ke lethathamo la boitsebiso bo tla kenngoa chate
03 ea 09
Ho theha Letlapa la Motona oa Tlhahlobo
Liphetolelo tsohle li fumanoa tlas'a Letšoao la Insert la Ribbon e Excel, 'me bohle ba arolelana litšobotsi tsena:
- Ha o bopa chate leha e le efe Excel, lenaneo la pele le bōpa se bitsoang mokha oa motheo ho sebelisa data e khethiloeng
- Ho phahamisa pointer ea hau ea mouse ho sethaleng sa chate ho tla hlahisa tlhaloso ea chate
- Ho tobetsa sehlopha ho bula ho theoha ho bonts'a mefuta eohle ea chate e fumanehang karolong eo
Mohato oa pele ha ho bōptjoa chate leha e le efe ea motsoako - e kang mochine oa mocheso - ke ho arola boitsebiso bohle ka mofuta o le mong oa chate ebe o fetola data e le nngwe ho mofuta oa chate oa bobeli.
Joalokaha ho boletsoe pejana, bakeng sa mochine ona oa mocheso, re tla rera lipampiri tsa pele ka bobeli boitsebiso bo bontšitsoeng setšoantšong se ka holimo, ebe o fetola mofuta oa chate bakeng sa dintlha tsa mocheso ho diagram.
Lithuto tsa Thuto
- Ka chate ea data e khethiloeng, tobetsa ho kenya> Column> 2-d e kenyelletsoeng Kholumo ka lebone
- Taba ea motheo ea mohala, e tšoanang le e bonngoeng setšoantšong ka holimo, e lokela ho bōptjoa ebe e behoa leqepheng la mosebetsi
04 ea 09
Litaba tsa Mocheso oa ho Fetola ho Line Line
Ho fetola mefuta ea chate e Excel ho etsoa ho sebelisa lebokose la lebokose la Mocha oa Chart .
Kaha re lakatsa ho fetola se seng sa lihlopha tse peli tsa ditshwantsho tse bontsweng ho mofuta o fapaneng oa chate, re lokela ho bolella Excel hore na ke eng.
Sena se ka etsoa ka ho khetha, kapa ho tobetsa hanngoe, ho e 'ngoe ea lihlopha tsa chate, e hlalosang lihlopha tsohle tsa' mala o tšoanang.
Likgetho tsa ho bula lebokose la lebokose la lebokose la Chate li kenyelletsa:
- ho totobetsa letšoao la Mofuta oa Chart Change ho Design tab ea lithane
- ho tobetsa ka holimo ho e 'ngoe ea lihlopha tse khethiloeng le ho khetha khetho ea Mofuta oa Chart ea Fetoha ho tloha menu e theoha
Mefuta eohle ea lichate e fumanehang e thathamisitsoe lebokoseng la bokooa hore ho bonolo ho fetoha ho tloha ho e ngoe ho ea ho e 'ngoe.
Lithuto tsa Thuto
- Tobetsa hang-hang ho e 'ngoe ea likarolo tsa data tsa mocheso - tse bonts'itsoeng ka bofubelu setšoantšong se ka holimo - ho khetha mela eohle ea' mala oo chate
- Hover pointer ea mouse holim'a e 'ngoe ea lihlopha tsena mme o tobetsa ka ho le letona ka mouse ho bula menyetla ea moelelo o theoha
- Khetha mofuta oa Chart Type Chart Type ho tswa ho menu e theoha ho bula lebokose la lebokose la Mocha oa Chart
- Tobetsa ho kgetho ea pele ea lebokose ka letsohong le letona la lebokose la lebokose
- Tobetsa OK ho koala lebokose la lebokose le ho khutlela mosebetsing
- Ka chate, boitsebiso ba mocheso bo lokela ho bontšoa joale joaloka mola o moputsoa ho phaella ho mela ea ditshwantsho
05 ea 09
Ditshuputso ya ho fallela ho ya Sekondari Y Axis
Ho fetola data ea mocheso ho ea mohlophong oa mohala ho ka 'na ha nolofalletsa ho khetholla pakeng tsa lisebelisoa tse peli tsa data, empa, kaha bobeli ba merero e lekanngoe ka lehlakoreng le le leng , boemo ba mocheso bo bontšoa e le mola o otlolohileng o re bolellang hanyenyane haholo ka phapang ea khoeli le khoeli.
Sena se etsahetse ka lebaka la tekanyo ea motsoako o le mong o lekang ho amohela lisebelisoa tse peli tsa data tse fapaneng haholo.
Boitsebiso bo tloaelehileng ba mocheso oa Acapulco bo na le boholo bo fokolang ho tloha ho 26.8 ho ea ho 28.7 likhato tsa Celsius, ha ditshwantsho tsa mehla e fapana ho tloha ho limilimithara tse ka tlase ho tse tharo ka March ho feta 300 mm ka September.
Ha ho behoa litekanyetso tsa li-axis tse totobetseng ho bonts'a boitsebiso bo bongata ba marulelo, Excel e tlosa ponahalo leha e le efe ea ho fapana holima mocheso oa selemo.
Ho tsamaisa data ea mocheso ho e-na le motsoako oa bobeli-o bonngoeng ka lehlakoreng le letona la chate ho lumella litekanyo tse fapaneng bakeng sa mehala e 'meli ea data.
Ka lebaka leo, chate e tla khona ho bontša phapang ea lihlopha tse peli tsa data ka nako e le 'ngoe.
Ho tsamaisa data ea mocheso ho e-na le lisebelisoa tsa bobeli ba lerata ho etsoa ka lebokoseng la boitsebiso la Format Data Series .
Lithuto tsa Thuto
- Tobetsa hang ka mohala oa mocheso - o bontšitsoeng ka khubelu setšoantšong ka holimo - ho o khetha
- Hover pointer ea mouse holim'a mola le ho tobetsa ka ho le letona ka mouse ho bula menyako ea maemo a theoha
- Khetha kgetho ea Format Data Series ho tswa ho menu e theoha ho bula lebokose la dialog Data Format Series
06 ea 09
Ditaba tsa ho fallela ho Sekondari Y Axis (con't)
Lithuto tsa Thuto
- Tobetsa ho Sehlopha sa Liqeto tse ka letsohong le letšehali la lebokoseng la dialog ha ho hlokahala
- Tobetsa ho Kgetho ea Bobeli ba Sekhahla ka letsohong le letona la lebokose la lebokose joalokaha ho bontšoa setšoantšong se ka holimo
- Tobetsa konopo e butsoeng ho koala lebokose la lebokose mme u khutlele mosebetsing
- Ka chate, litekanyo bakeng sa boitsebiso ba mocheso o lokela ho bonts'a hona ka lehlakoreng le letona la chate
Ka lebaka la ho fetisetsa data ea mocheso ho e-na le moeli oa bobeli oa molumo, moeli o bontšang litlaleho tsa moholi o lokela ho bontša phapang e kholo ho tloha khoeli le khoeli ho nolofalletsa ho bona mocheso.
Sena se etsahala hobane tekanyo ea data ea mocheso ka lehlakoreng le letona la chate hona joale e na le feela ho koahela boholo ba likhato tse ka tlaase ho tse 'nè tsa Celsius ho e-na le tekanyo e ka bang ho tloha ho zero ho ea ho 300 ha lintlha tse peli li arolelana tekanyo e le 'ngoe.
Ho fetola boemo ba leholimo
Ka nako ena, mobala oa mocheso o lokela ho tšoana le setšoantšo se bontšitsoeng mohato o latelang oa thupelo.
Mehato e setseng e rutang e koahela mekhoa ea ho etsa mefuta e fapaneng ea mocheso oa mocheso ho etsa hore e tšoane le graph e bontšitsoeng mohato o le mong.
07 ea 09
Ho fetola boemo ba leholimo
Ha ho tluoa tabeng ea ho etsa lipatlisiso tsa lichate tse Excel ha ho hlokahale hore u amohele mokhoa o fokolang oa ho etsa mokhoa oa karolo leha e le efe ea chate. Likarolo tsohle kapa likarolo tsa chate li ka fetoloa.
Liphetho tsa lihlopha tsa lichate li atisa ho hlaha lithaneng tse tharo tsa lithane tseo ka kakaretso li bitsoang Chart Tools
Ka tloaelo, likhaba tsena tse tharo ha li bonahale. E le hore u li fumane, feela tobetsa lebokose la motheo leo u sa tsoa le bōpa le li-tab tse tharo - Tlhahiso, Liphetoho, le Format - li kenyelletsoa leboneng.
Ka holimo ho likhaba tsena tse tharo, u tla bona lihlooho tsa Chate Tools .
Thupelong e setseng mehato e latelang e tla etsoa ka liphetoho tse latelang:
- Kenya mabitso le litlotla
- fetisetsa pale ea tlhōrō ea chate
- Fetola mebala le mebala ea ka morao
- Bevel moeli o ka ntle oa chate
- Nchafatsa setha
Ho eketsa Sehlooho sa Horizontal Axis Title
Sehlopha se holimo se bontša matsatsi a ka tlaase ho chate.
- Tobetsa ka chate e ka sehloohong e sebetsanang le ho hlahisa litheipi tsa sate
- Tobetsa ho Taba ea Mohaho
- Tobetsa ho Axis Titles ho bula lenane la theoha
- Tobetsa Mongolo o ka sehloohong oa Axis Title> Sehlooho se ka tlaase ho Axis kgetho ho kenyelletsa sehlooho se ngotsoeng Axis Title ho chart
- Hlakola sehlooho se sa feleng ho se totobatsa
- Tšoaea sehlooho " Khoeli "
Ho eketsa Sehlooho se ka sehloohong sa Axis Title
Sehlooho se ka sehloohong sa litekanyetso se bontša boholo ba likarolo tse rekisoang ka lehlakoreng le letšehali la chate.
- Tobetsa chate haeba ho hlokahala
- Tobetsa ho Taba ea Mohaho
- Tobetsa ho Axis Titles ho bula lenane la theoha
- Tobetsa Mongoleng oa Motheo oa Sehlooho Sehlooho> Sekhetho sa Rotate se kentsoeng ho kenyelletsa sehlooho se hlakileng sa Sehlooho sa Axis ho chate
- Totobatsa sehlooho se sa feleng
- Tšoaea sehlooho " Precipitation (mm) "
Ho eketsa Sehlooho sa Ponahalo ea Sehlooho sa Sekondari
Sehlopha sa bobeli sa lerata se bontša boholo ba theko ea theko e rekisoang ka lehlakoreng le letona la chate.
- Tobetsa chate haeba ho hlokahala
- Tobetsa ho Taba ea Mohaho
- Tobetsa ho Axis Titles ho bula lenane la theoha
- Tobetsa ho Sehlooho sa Sehlooho sa Sehlooho sa Sehlooho> Sekhetho sa Rotate se kentsoeng ho kenyelletsa sehlooho se ka holimo sa Axis Title ho chate
- Totobatsa sehlooho se sa feleng
- Ngola sehlooho " Mocheso oa Mocheso (° C) "
Ho eketsa Title Chart
- Tobetsa chate haeba ho hlokahala
- Tobetsa Thabeng ea Setha ea lithane
- Tobetsa ho Sehlooho sa Chate> Ntho e ka hodimo ea Chate ho kenya Tlhaloso ea Chate ea kamehla ho chate
- Totobatsa sehlooho se sa feleng
- Tšoaea sehlooho sa Climatograph bakeng sa Acapulco (1951-2010)
Ho fetola Mobala oa Mongolo oa Font
- Tobetsa hang-hang ho Tlhaloso ea Chate ho e khetha
- Tobetsa Tobeng ea Lehae ho menu ea litebele
- Tobetsa motsu o ka tlaase oa Font Color ho bula menu e theoha
- Khetha Lefifi le Lefubelu ho tloha tlasa karolo ea Standard Colors ea menu
08 ea 09
Ho tsamaisa Taba le ho Fetola Sebaka sa Tsela ea Mokoloko
Ka kakaretso, pale ea chate e ka letsohong le letona la chate. Hang ha re eketsa sehlooho sa lihlahisoa tsa molumo oa bobeli, lintho li fumana tse nyane sebakeng seo. Ho fokotsa tšubuhlellano re tla fetisetsa pale ea tlhōrō ea chate e ka tlas'a sehlooho sa chate.
- Tobetsa chate haeba ho hlokahala
- Tobetsa Thabeng ea Setha ea lithane
- Tobetsa Tlhaloso ea ho bula lenane la theoha
- Tobetsa ho Show Legend ka Ntho e phahameng ho fetisetsa tšōmo ho tlasa sehlooho sa chate
U sebelisa Boitsebiso ba ho Etsa Mokhoa oa Mongolo o Ikhethang
Ho phaella ho lisebelisoa tsa chate tabeng, liphetoho tsa mekhoa e ka etsoa ho lichate tse sebelisang menu e theoha kapa ea moelelo e butsoeng ha u tobetsa tobetsa ho ntho.
Ho fetola mebala e ka morao bakeng sa chate eohle le sebaka sa sepheo - lebokoseng le ka sehloohong la chate e bonts'ang data - e tla etsoa ho sebelisa menyetla ea litaba.
Ho Fetola Chart Mobala oa Moelelo
- Tobetsa ka ho le letona lebaleng le tšoeu la chate ho bula mecha ea litaba ea chate
- Tobetsa motsu o monyenyane o ka tlase ho letsohong le letona la setšoantšo sa Tlaleho ea Tlaleho - pente e ka - ka mochini oa toolbar ho bulela Lenane la Tsela ea Colors
- Tobetsa ho White, Tlhaloso ea 1, Tlase 35% ho fetola mobala oa mochate oa chate ho ea bohlooho bo lefifi
Ho Fetola Sebaka sa Sebaka Botle ba Nako
Tlhokomeliso: E-ba hlokolosi hore u se ke ua khetha mela e metle ea marang-rang e tsamaeang sebakeng sa sebaka seo ho e-na le sebopeho ka boeona.
- Tobetsa ka ho le letona sebakeng se sekareleta sa sebaka se seholo ho bula menyetla ea sebaka sa sebaka sa mohaho
- Tobetsa motsu o monyenyane o ka tlase ho letsohong le letona la setšoantšo sa Tlaleho ea Tlaleho - pente e ka - ka mochini oa toolbar ho bulela Lenane la Tsela ea Colors
- Tobetsa ho White, Tlhaloso ea 1, Tlase 15% ho fetola mobala oa mobu oa mobu ho ea bohlooho
09 ea 09
Ho phaella ka katleho ea 3-D le Thabiso ea Tlhaho le Tlhaloso ea Bocha
Ho phaella mosebetsing oa bevello o 3-D ho eketsa botebo ho chate. E siea chate ka ho shebahala ka ntle ka ntle.
- Tobetsa ka ho toba sethaleng sa chate ho bula menyetla ea mochini oa chate
- Tobetsa ka kgetho ea Chart Area Format ka mochini oa toolbar ho bulela lebokose la lebokose
- Tobetsa moqapi oa 3-D ka lebokose le letšehali la lebokose la lebokose la Taba ea Mochini
- Tobetsa motsu o ka tlase ho ea ka letsohong le letona la Letšoao le Phahameng ka letsohong le letona ho bula likhetho tsa khetho ea bevel
- Tobetsa ho Circle kgetho ka lehlakore - khetho ea pele karolong ea Bevel ea karolo
- Tobetsa konopo e butsoeng ho koala lebokose la lebokose mme u khutlele mosebetsing
Hlahisa Chart
Ho nchafatsa chate ke mohato o mong oa boithaopo. Melemo ea ho etsa chate e khōloanyane ke hore e fokotsa ponahalo e pharaletseng e entsoeng ke setsi sa bobeli sa lerata ka letsohong le letona la chate.
Ho tla boela ho eketse boholo ba sebaka sa morero ho etsa hore lintlha li be bonolo ho li bala.
Tsela e bonolo ka ho fetisisa ea ho fetola chate ke ho sebelisa lisebelisoa tsa mahlahahlaha tse ntseng li sebetsa ho pota-pota ka ntle ho chate hang ha u li tobetsa.
- Tobetsa ka lekhetlo ka lekhetlong la chate ho khetha chate kaofela
- Ho khetha chate ho eketsa mola o moputsoa o hloekileng ho ea ka ntle ho chate
- Lintlheng tsa kemiso ena e putsoa ke likhahla tse sebetsang
- Tlosa pointer ea mouse ka holim'a e 'ngoe ea likhutlo ho fihlela pointer e fetoha motsu o motšo o nang le mabeli
- Ha pointer e le motsu o nang le lihlooho tse peli, tobetsa ka konopo ea letsohong le letšehali 'me u hulele ka ntle ho tla eketsa chate. Chate e tla boela e hōle ka bobeli le bophara. Sebaka sa morero se lokela ho eketseha ka boholo.
Haeba u latetse litepisi tsohle tseeteng ena thutong ena boemo ba hau ba leholimo bo lokela ho tšoana le mohlala o bontšitsoeng setšoantšong karolong ea pele ea thupelo ena.