Haeba u batla mokhoa o bonolo oa ho bona lintlha tsa hau ho Excel, lichate tsa phae ke khetho e ntle haholo. Ka Nka etsa chate ea phae joang ho Excel? Re tla u bontša hore na ho bonolo hakae ho theha chate ea phae sesebelisoa sena se tsebahalang sa spreadsheet. Hore na o hlahisa lintlha tsa lichelete, lipalo-palo tsa thekiso, kapa mofuta ofe kapa ofe oa lintlha tsa linomoro, tekete ea phae e ka etsa hore lintlha tsa hau li utloisisehe habonolo le ho ipiletsa haholoanyane ho fumana hore na ho bonolo hakae ho iketsetsa pie chate ho Excel le hore na u ka e etsa joang hore e lekane litlhoko tsa hau.
- Mohato ka mohato ➡️ Nka etsa chate ea apie joang ho Excel?
- 1 Mohato: Bula Microsoft Excel khomphuteng ea hau.
- 2 Mohato: Kenya lintlha tseo u batlang ho li kenyelletsa chate ea hau ea phae ho spreadsheet.
- 3 Mohato: Khetha data eo u batlang ho e kenyelletsa ho pie chate.
- 4 Mohato: Tobetsa "Insert" tab ya ka holimo ho skrine.
- Mohato oa 5: Ka har'a tab ea "Insert", fumana sehlopha sa lichate ebe u khetha "Ring Chart" kapa "Pie Chart".
- Mohato oa 6: Tobetsa konopo ea "OK" ho etsa hore Excel e iketsetse chate ea pie ea hau ho latela lintlha tse khethiloeng.
- 7 Mohato: Iketsetse chate ea hau ea pie ho latela seo u se ratang, joalo ka ho fetola mebala, ho eketsa litlotla le lileibole, le tse ling.
- 8 Mohato: Ha u se u thabetse chebahalo ea chate ea hau ea phae, e boloke komporong ea hau kapa u e arolelane ka kotloloho ho tsoa Excel.
Q&A
Nka etsa chate ea phae joang ho Excel?
- Bula Excel 'me u khethe lintlha tseo u batlang ho li kenyelletsa ho chate ea pie .
- Tobetsa konopo ea "Insert" kaholimo ho fensetere ea Excel.
- Sehlopheng sa sa "Lits'oants'o", tobetsa "Insert Donut or Circle Chart."
- Khetha khetho ea "Chate e felile" kapa "Circle Chart" ho latela khetho ea hau.
- Chate ea hau ea phae e tla hlahisoa ka bo eona ho spreadsheet, 'me u ka e etsa ho ea ka litlhoko tsa hau.
Nka fetola mebala joang chate ea phae ho Excel?
- Tobetsa chate ea phae ho e khetha.
- Ka nako eo, tobetsa "Design" tab ya e hlahang ka holimo ho fensetere.
- Sehlopheng sa Ditaele tsa Chate, kgetha Mebala e Potlakileng ebe o kgetha sekeme sa mebala seo o se ratang.
- Haeba u batla ho fetola mebala le ho feta, u ka tobetsa "Mebala ea Chate" 'me u khethe mebala ka bonngoe.
Nka kenya litlotla le lileibole joang ho a pie chate ho Excel?
- Tobetsa ho chate ea pie ho e khetha.
- Ka nako eo, tobetsa "Design" tab ya e hlahang ka holimo ho fensetere.
- Sehlopheng sa "Labels", khetha "Add Chart Elements" 'me u khethe hore na u kenye sehlooho, lileibole tsa data, tšōmo, joalo-joalo.
- Hang ha ntho e khethiloe, u ka e etsa hore e lumellane le litlhoko tsa hau ka ho tobetsa ho eona ka ho le letona.
Nka fetola fonte joang chate ea phae ho Excel? .
- Tobetsa mongolo oo u batlang ho o fetola (sehlooho, lileibole, tšōmo, joalo-joalo) ho chate ea phae.
- Ebe tobetsa ho "Home" tabe hlahang kaholimo ho fensetere.
- Sebelisa likhetho tse karolong ea "Font" ho fetola fonte, boholo, 'mala, sebete, mongolo o tšekaletseng, joalo-joalo.
- Etsa bonnete ba hore khetha mongolo pele o kenya liphetoho tsa ho fomata.
Nka ntlafatsa data joang ka chate ea phae ho Excel?
- Haeba data e le ka har'a spreadsheet e le 'ngoe, ntlafatsa feela boleng ba lisele tse ntseng li sebelisoa chate ea pie.
- Haeba data e tsoa ho leqephe le leng la Excel kapa bukeng ea mosebetsi, tobetsa chate ea phae, ebe u khetha "Layout", 'me qetellong "Khetha Lintlha."
- Mona o ka fetola lethathamo la data le sebelisoang ho hlahisa chate ea pie.
Nka romela chate ea pie joang ho tloha Excel ho ea lenaneong le leng?
- Tobetsa ho chate ea pie ho e khetha.
- Ebe u tobetsa ka ho le letona ebe u khetha "Kopitsa" kapa "Seha".
- Bula lenaneo leo u batlang ho le romella chate ho (Lentsoe, PowerPoint, joalo-joalo) 'me u khomarele chate u sebelisa khetho ea "Paste".
- Ho itšetlehile ka lenaneo, ho ka 'na ha hlokahala hore u lokise boholo ba setšoantšo hang ha se peisitsoe.
Nka eketsa liperesente joang chate ea phae ho Excel?
- Tobetsa chate ea phae ho e khetha.
- Ka nako eo, tobetsa "Design" tab ya e hlahang ka holimo ho fensetere.
- Sehlopheng sa "Labels", khetha "Data Legend" 'me u khethe khetho ea "Percentage".
- Liphesente li tla hlahisoa haufi le karolo ka 'ngoe ea chate ea phae.
Nka etsa chate ea phae joang e nang le data e sa kopaneng ho Excel?
- Tšoara konopo ea "Ctrl" ho keyboard ea hau ebe u khetha sete e 'ngoe le e 'ngoe ea lintlha tse sa kopaneng tseo u batlang ho li kenyelletsa chateng ea phae.
- Hang ha data e se e khethiloe, latela mehato e tloaelehileng ea ho theha chate ea phae ho Excel.
- Excel e tla hlahisa chate ea pie e sebelisa lintlha tse sa kopaneng tseo u li khethileng.
Nka fetola boholo ba chate ea phae joang ho Excel?
- Tobetsa ho chate ea pie ho e khetha.
- Ebe, tobetsa ho e 'ngoe ea mathōko a kerafo 'me ue hule ho e fetola boholo.
- U ka tobetsa ka ho le letona, khetha "Size le Properties" 'me u fetole litekanyo ka nepo.
- Ka kopo hlokomela hore ho fetola boholo ba chate ho ka ama ponahalo ea eona le ho baloa ha eona.
Nka kenya chate ea phae joang leqepheng le lecha ho Excel?
- Tobetsa chate ea phae ho e khetha.
- E latelang, tlanya ho "Design" tab e hlahang ka holimo ho fensetere.
- Sehlopheng sa "Location", khetha "Move Chart" ebe u khetha "As Object In" hammoho le "New Sheet."
- Leqephe le lecha le tla hlaha bukeng ea hau ea mosebetsi ea Excel mme chate ea phae e kentsoe.
Ke 'na Sebastián Vidal, moenjiniere oa k'homphieutha ea chesehelang theknoloji le DIY. Ho feta moo, ke 'na moetsi oa tecnobits.com, moo ke arolelanang lithupelo ho etsa hore theknoloji e fumanehe le ho utloisisoa ke motho e mong le e mong.