Kamoo U ka Bōpa Letlapa la Bar Graph / Column ka Excel

01 ea 09

Bopa Chate ea Bar Graph / Column le Mohala oa Chart ka Excel 2003

Thupelo ena e akaretsa ho sebelisa Mochini oa Chate ho Excel 2003 ho etsa moralo oa bar. E u tataisa ka ho sebelisa litšobotsi tse tloaelehileng tse fumanoang lipapaling tse 'nè tsa Mochini oa Chate.

Chate Wizard e entsoe ka letoto la li- lebokose tsa lebokose tse u fang lintho tsohle tse fumanehang bakeng sa ho bopa chate.

Lihlopha tse 'nè tsa Dialog Box kapa Mehato ea Mochini oa Chate

1. Ho khetha mofuta oa chate joalo ka chate ea pie, chate ea bar, kapa chate ea mohala.
2. Ho khetha kapa ho netefatsa lintlha tse tla sebelisoa ho bopa chate.
3. Ho kenya litlotla ho chate le ho khetha mekhoa e sa tšoaneng ea chate e kang ho eketsa mangolo le pale.
4. Etsa qeto ea hore na u tla beha chate leqepheng le le leng kapa che.

Tlhokomeliso: Seo ba bangata ba rona ba reng ke graph ea bar, ho buuoa ka eona, ho Excel, joaloka chate ea kholumo , kapa chate ea bar .

Ha ho sa na Mocha oa Chart

Sehlopha sa diagram se tlosoa Excel ho qala ka phetolelo ea 2007. E nkeloe sebaka ke likhetho tse khethiloeng ka tlas'a lebokose la letlapa .

Haeba u na le phetolelo ea lenaneo hamorao ho feta Excel 2003, sebelisa li-link tse latelang bakeng sa lithuto tse ling tsa graph / chart ho Excel:

• Excel 2013 Moralo oa Kerete ea Tlhahlobo ea Gray / Column ea Toro
• Excel 2010/2007 Mochini oa Tatale ea Bar Graph / Column

02 ea 09

Ho kenya Ditaba tsa Grafu ea Bar

Mohato oa pele oa ho theha mohapa oa bar ke ho kenya data ka har'a leqephe .

Ha u kenya data, boloka melao ena kelellong:

1. U se ke ua tlohela mela kapa li-column tse se nang letho ha u kenya data ea hau.
2. Kenya dintlha tsa hau ka dikoropo.
   

Tlhokomeliso: Ha u beha lethathamo la hao, thathamisa mabitso a hlalosang boitsebiso bo le ka lehlakoreng le leng le ho le letona la seo, data ka boeona. Haeba ho na le lihlopha tse fetang tse le 'ngoe tsa lintlha, li thathamise tsona ka mor'a lihlopha tse nang le sehlooho sa lihlopha tse ling tsa data ka holimo.

E le hore u latele thupelo ena, kopa lintlha tse boemong ba 9 ba thuto ena.

03 ea 09

Khetha Data ea Bar Graph - Litsela Tse peli

Ho sebelisa Mouse

1. Etsa khetho ka konopo ea mouse ho totobatsa lisele tse nang le data ho kenyelletsoa ho graph ea bar.

Ho sebelisa Keyboard

1. Tobetsa holimo ka ho le letšehali la data ea bar graph.
2. Tšoara konopo ea SHIFT lebokoseng.
3. Sebelisa linotlolo tsa motsu ka lebokose ho khetha lintlha tse lokelang ho kenyelletsoa ho graph ea bar.

Tlhokomeliso: Etsa bonnete ba hore o khetha leha e le efe lihlooho tsa lihlooho le lihlooho tseo u li batlang li kenyelelitsoe ho graph.

Bakeng sa Thuto ena

1. Totobatsa karolo ea lisele ho tloha ho A2 ho ea ho D5, e kenyeletsang litlotla tsa lihlooho le lihlooho tsa mola

04 ea 09

Tsela ea ho Qala Mohala oa Chart

O na le likhetho tse peli bakeng sa ho qala Mohlophisi oa Chart ea Excel.

1. Tobetsa ho letšoao la Mochini oa Chate lebokoreng la lithulusi (sheba mohlala oa setšoantšo ka holimo)
2. Khetha Insert> Chate ... ho tloha ho menu.

Bakeng sa Thuto ena

1. Qala Mohlophisi oa Chate u sebelisa mokhoa oo u o ratang.

Maqephe a latelang a sebetsa ka mehato e mene ea Mochini oa Chate.

05 ea 09

Mohato oa 1 - Ho khetha Mofuta oa Graph

Hopola: Seo boholo ba rona re se bitsang "graph bar" ho buuoa ka sona, ho Excel, joaloka chate ea molumo , kapa chate ea bar .

Khetha Chate ho Tab e Tloaelehileng

1. Khetha mofuta oa Chate ho tloha ka lehlakoreng le letšehali.
2. Khetha setšoantšo se ka tlaase ho tloha ka letsohong le letona.

Tlhokomeliso: Haeba u batla ho etsa lifilimi tse batlang li sa tloaeleha, khetha Mefuta ea Tloaelehileng ea Taba ka holimo ho lebokose la lebokose la Tsela ea Chart.

Bakeng sa Thuto ena
(tabeng ea Standard Types ea Chart)

1. Khetha mofuta oa chate oa Column ka letsohong le letsohong le letšehali.
2. Khetha mofuta o mocha oa mochine o kenyelletsoeng ka letsohong le letona ka holimo.
3. Tlanya E latelang.

06 ea 09

Mothati oa 2 - Hlahloba setšoantšo sa hau sa Bar

• Haeba o khetha dintlha tsa hau pele o qala Exel Chart Wizard, o tla bona mohlala oa bar bar ea hau ka fensetereng e ka holimo ea lebokose la lebokose la lihlooho.
• Ka spreadsheet ea hau, lintlha tse kenyelletsitsoeng ka graph li pota-potiloe ke likokoanyana tse tsamaeang-moeli o mofubelu o motšo o potolohileng dintlha tsa hau.
• Ka tlas'a fensetere la ponelo-pele ke lebokose le nang le litšupiso tsa sele tsa boitsebiso ba data bo kenyelletsitsoeng ka graph.
• Haeba bar ea hau ea bar e sa shebahale hantle, hlahloba ho netefatsa hore u khethile boitsebiso bo nepahetseng ba marang-rang ka spreadsheet.

Bakeng sa Thuto ena

1. Haeba graph ea hau e bonahala e nepahetse fensetereng la pono ea pele, tobetsa E latelang .

07 ea 09

Mohato oa 3 - Ho theha setšoantšo sa Bar

Le hoja ho na le likhetho tse ngata tlas'a li-tab tse tšeletseng bakeng sa ho fetola ponahalo ea graph ea hau mohato ona, re tla be re eketsa sehlooho sa graph ea bar.

Likarolo tsohle tsa graph li ka fetoloa ka mor'a hore u qete Mochini oa Chate.

Ha ho hlokahale ho etsa likhetho tsohle tsa hau tsa ho etsa hona joale.

Bakeng sa Thuto ena

1. Tobetsa litlotla tab ka holimo ho lebokose la lebokose.
2. Lebokoseng la lebokose la Chate, thathamisa sehlooho se reng Cookie Shop 2003 - 2005 Moputso .

Tlhokomeliso: Ha u ntse u thaba litlotla, li lokela ho kenyelletsoa fensetereng ea pele ho le letona.

08 ea 09

Mohato oa 4 - Sebaka Sebaka

Ho na le likhetho tse peli feela moo u batlang ho beha mohaho oa hau oa mohaho:

1. E le letlapa le lecha (beha lifilimi ka letlapa le fapaneng ho tloha lefapheng la hau la buka)
2. E le ntho e le letlapeng 1 (beha graph lekarecheng le tšoanang le dintlha tsa hau bukeng ea buka)

Bakeng sa Thuto ena

1. Tobetsa konopo ea seea-le-moea ho beha graph e le ntho e letlapeng 1.
2. Tobetsa Qetella

Ho theha setšoantšo sa Bar

Hang ha wizard e se e phethiloe, mochini oa hau o tla be o behoa leqepheng la mosebetsi. Graph e sa ntsane e hlophisitsoe pele e ka nkoa e feletse.

09 ea 09

Bar Graph Tutorial Data

Kenya data mona ka tlase ka liseleng tse bontšitsoeng ho etsa mohaho oa bar o koahetsoeng thutong ena. Ha ho mokhoa o sebetsanang le mokhoa oa mokhoa oa ho etsa mosebetsi o koetlisitsoeng thutong ena, empa seo ha se ame moralo oa hau oa bar.

Cell - Data
A1 - Tlhaloso ea Kakaretso - The Cookie Shop
A3 - Litšenyehelo tsohle:
A4 - Chelete eohle:
A5 - Phaello / tahlehelo:
B2 - 2003
B3 - 82837
B4 - 57190
B5 - 25674
C2 - 2004
C3 - 83291
C4 - 59276
C5 - 26101
D2 - 2005
D3 - 75682
D4 - 68645
D5 - 18492

Khutlela mohatong oa bobeli oa ena thupelo.