Tse ka Hare
Wizard ea Chate e tlositsoe ho Excel 2007 mme ha ea ka ea hlola e khutla ka liphetolelo tsa morao-rao. Ha e le hantle, tsamaiso eohle ea ho sebetsa ka litšoantšo e ile ea fetoloa, 'me bahlahisi ha baa ka ba nka ho hlokahala ho ntlafatsa wizate ea setšoantšo le lisebelisoa tse amanang le tsona.
Ke tlameha ho bolela hore sistimi e ncha ea ho sebetsa ka lichate e hokahane ka botebo sebopehong se secha sa Ribone ea Menu mme e bonolo haholo ho sebetsa ho feta wizate e e eteletseng pele. Setupo se bonolo 'me mohatong o mong le o mong u ka bona ponelo-pele ea setšoantšo sa hau pele u etsa liphetoho.
Papiso ea "Chart Wizard" le lisebelisoa tsa sejoale-joale
Bakeng sa ba tloaetseng ho sebelisa wizate ea chate, re batla ho re ha re sebetsa le Ribone, lisebelisoa tsohle tse tšoanang li fumaneha, hangata ka nako e sa feteng makhetlo a mabeli a ho tobetsa mouse.
Liphetolelong tsa khale tsa Excel, ka mor'a ho tobetsa menu kenya (Kenya) > Setšoantšo se Qanollang (Chate) wizate e bonts'itse mabokose a mane a puisano ka tatellano:
- Mofuta oa chate. Pele o khetha data bakeng sa chate, o hloka ho khetha mofuta oa eona.
- Mohloli oa data oa chate. Khetha lisele tse nang le data ho rala chate le ho bolela mela kapa likholomo tse lokelang ho bontšoa e le letoto la lintlha chate.
- Likhetho tsa chate. Iketsetse lifomete le likhetho tse ling tsa lichate joalo ka lileibole tsa data le lilepe.
- Sebaka litšoantšo. Khetha leqephe le teng kapa u thehe leqephe le lecha ho amohela chate eo u e etsang.
Haeba u hloka ho etsa liphetoho ho setšoantšo se seng se entsoe (ho ka ba joang ntle le eona?!), U ka boela ua sebelisa wizate ea setšoantšo kapa, maemong a mang, menu ea moelelo kapa menu. Mookameli (Sebopeho). Ho qala ka Excel 2007, mokhoa oa ho etsa lichate o nolofalitsoe hoo Wizard ea Chate e seng e sa hlokahale.
- Totobatsa lintlha. Ka lebaka la hore qalong ho etsoa qeto ea hore na ke lintlha life tse tla sebelisoa ho haha graph, hoa khoneha ho bona setšoantšo pele ho ts'ebetso ea ho se etsa.
- Khetha mofuta oa chate. Ho Advanced tab kenya (Kenya) khetha mofuta oa chate. Ho tla buleha lethathamo la li-subtypes. Ka ho tsamaisa toeba holim'a e 'ngoe le e' ngoe ea tsona, u ka bona esale pele hore na graph e tla shebahala joang ho latela data e khethiloeng. Tobetsa ho subtype e khethiloeng mme Excel e tla theha chate leqepheng la mosebetsi.
- Iketsetse moralo le sebopeho. Tobetsa chate e entsoeng - tabeng ena (ho itšetlehile ka mofuta oa Excel) ho tla hlaha li-tab tse peli kapa tse tharo Riboneng. Li-tab Constructor (Moqapi), Mookameli (Format) le liphetolelong tse ling moralo (Sebopeho) se u lumella ho sebelisa mekhoa e fapaneng e entsoeng ke litsebi ho setšoantšo se entsoeng, feela ka ho tobetsa letšoao le lumellanang le Ribone.
- Iketsetse likarolo tsa hauligrama. Ho fihlella liparamente tsa karolo ea chate (mohlala, li-axis parameters), tobetsa ka ho le letona ho element ebe u khetha taelo e lakatsehang ho tsoa ho menyu ea litaba.
Mohlala: Ho etsa histogram
Re theha tafole pampiring e nang le data, mohlala, thekisong metseng e fapaneng:
Ho Excel 1997-2003
Tlanya ho menu kenya (Kenya) > Setšoantšo se Qanollang (Chate). Ka fensetere e hlahang, etsa se latelang:
- Mofuta oa chate (Mofuta oa Chate). Tobetsa chate ea bareki (Column) ebe u khetha ea pele ho mefuta e menyenyane e reriloeng.
- Mohloli elichate tsa data (Boitsebiso ba Mohloli oa Chate). Kenya tse latelang:
- Range (Lethathamo la lintlha): kenya B4:C9 (e totobalitsoe ka boputsoa bo boputsoa setšoantšong);
- Mela ka hare (Letoto): khetha Litšiea (likholomo);
- Ho Advanced tab Moqomo (Letoto) tšimong Li-signature tsa X axis (Sehlopha sa lileibole) hlakisa sebaka A4:A9.
- Likhetho tsa Chate (Dikgetho tsa Chate). Kenya sehlooho "Lithekiso ke Metropolitan Area»le tšōmo.
- Ho bea chate (Sebaka sa Chate). Hlahloba kgetho Beha chate leqepheng > fumaneha (E le ntho e ka hare) ebe o khetha Sheet1 (Letlapa1).
Ho Excel 2007-2013
- Khetha mefuta e mengata ea lisele ka mouse B4:C9 (e totobalitsoe ka boputsoa bo khanyang setšoantšong).
- Ho Advanced tab kenya (kenya) tobetsa Kenya histogram (Kenya Lethathamo la Kholomo).
- khetha Histogram e nang le lihlopha (Kholomo e Kopantsoeng ea 2-D).
- Sehlopheng sa di-tab se hlahang lenteng Ho sebetsa ka lichate (Lisebelisoa tsa Chate) bula tab Constructor (Moqapi) ebe o tobetsa Kgetha data (Khetha Lintlha). Ka lebokoseng la puisano le hlahang:
- ka Lileibole tsa axis tse otlolohileng (mekhahlelo) (Horizontal (sehlopha) labels) tobetsa Change (Edita) tsoela pele A4:A9ebe o tobetsa OK;
- Change Mola1 (Letoto la1): tšimong Lebitso la mola (Lebitso la lethathamo) khetha sele B3;
- Change Mola2 (Letoto la2): tšimong Lebitso la mola (Lebitso la lethathamo) khetha sele C3.
- Chate e entsoeng, ho latela mofuta oa Excel, e ka ba tobetsa habeli ho sehlooho sa chate, kapa bula tab Ho sebetsa ka lichate (Lisebelisoa tsa Chate) > moralo (Sebopeho) ebe u kenya "Lithekiso ke Metropolitan Area".
Se o lokelang ho se etsa?
Iphe nako ea ho hlahloba likhetho tse teng tsa lichate. Sheba hore na ke lisebelisoa life tse teng li-tab tsa lihlopha Ho sebetsa ka lichate (Lisebelisoa tsa Chart). Bongata ba tsona lia itlhalosa kapa li tla bontša ponelo-pele pele khetho e etsoa.
Etsoe, na ho na le tsela e molemo ea ho ithuta ho feta ho itloaetsa?