Excel 2003 Line Graph Tutorial

01 ho ea ho 10

Tlhaloso ea Tlhahlobo ea Chart ea Excel 2003

Thuto ena e akaretsa mehato ea ho theha mohala oa line ho Excel 2003 ho sebelisa Excel Chart Wizard.

Ho tlatsa mehato litabeng tse ka tlase ho tla hlahisa mochine oa line o tšoanang le setšoantšo se ka holimo.

02 ho ea ho 10

Ho kenya Data Line Graph

Ho sa tsotellehe hore na u etsa chate kapa graph ea mofuta ofe, mohato oa pele oa ho bopa chart ea Excel kamehla 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.

• Ha u beha sepache sa hau, thathamisa mabitso a hlalosang boitsebiso bo le ka lehlakoreng le le leng, 'me, 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.

Lithuto tsa Thuto

1. Kenya data joalokaha ho bonngoe setšoantšong ka holimo ho lisele tse A1 ho C6.

03 ho ea ho 10

Ho khetha Data Line Graph

Ho sebelisa mouse

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

Ho sebelisa lebokose

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

Tlhokomeliso: Etsa bonnete ba hore o khetha mohala ofe kapa ofe oa lihlooho tseo u batlang ho kenyelletsoa ho tsona.

Lithuto tsa Thuto

1. Totobatsa karolo ea lisele ho tloha ho A2 ho ea ho C6, e kenyelletsang lihlooho tsa likarolo le lihlooho tsa mola ho sebelisa e 'ngoe ea mekhoa e ka holimo.

04 ho ea ho 10

Ho qala Mocha oa Chate

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. Tobetsa ho kenya> Chate ... ka menyeteng.

Lithuto tsa Thuto

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

05 ho ea ho 10

The Excel Chart Wizard Mohato oa 1

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.

Lithuto tsa Thuto

1. Khetha mofuta oa chate ea Line ho ka letsohong le letšehali.
2. Khetholla Mohala ka letšoao la chate-tlase ka tatellano ka letsohong le letona
3. Tlanya E latelang.

06 ho ea ho 10

Excel Chart Wizard Mohato oa 2

Hlahloba Chate ea hau

• Ha u se u khethile lintlha tsa hau pele u qala Mohlophisi oa Excel Chart, u lokela ho bona mohlala oa chate ea hao ka fensetereng e ka holimo ea lebokose la lebokose la lihlooho.
• Ka spreadsheet ea hau, boitsebiso bo kenyelletsoeng chate bo pota-potiloe ke bohloa bo tsamaeang - moeli o motšo o motšo o potolohileng dintlha tsa hau.
• Ka tlas'a fensetere ea pontšo ke lebokose le nang le litšupiso tsa lisele tsa marang-rang a kenyelelitsoeng chate. Haeba chate ea hau e sa shebahala hantle, hlahloba hore u khethile ho nepahala ha data data spreadsheet.

Lithuto tsa Thuto

1. Tlanya E latelang.

07 ho ea ho 10

Excel Chart Wizard Mohato oa 3

Khetho ea Chart

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

Likarolo tsohle tsa chate ea Excel li ka fetoloa ka mor'a hore u qete Mohala oa Chart, kahoo ha ho hlokahale hore u etse mefuta eohle ea hau ea ho etsa litšoantšo hona joale.

Lithuto tsa Thuto

1. Tobetsa Mabitso a Lethathamo tab ka holimo ho lebokose la lebokose la Mochini oa Chate.
2. Lebokoseng la lebokose la Chate, thathamisa sehlooho se reng: Average Precipitation for Acapulco le Amsterdam .
3. Ka lebokoseng la lihlopha tsa (X), mofuta oa: Makhoeli .
4. Ka lebokoseng la sehlopha (Y), mofuta oa: Precipitation (mm) (Hlokomela: mm = millimeters).
5. Ha chate e fensetereng e shebahalang hantle, tobetsa E latelang.

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

08 ho ea ho 10

The Excel Chart Wizard Mohato oa 4

Sebaka sa Sebaka

Ho na le likhetho tse peli feela bakeng sa moo u batlang ho beha mochine oa hau:

1. E le letlapa le lecha (beha chate e 'ngoe ea leqephe le tsoang bukeng ea hau ea mosebetsi)
2. E le ntho e hlahang leqepheng la 1 (beha chate e le letlapa le tšoanang le lintlha tsa hau bukeng ea libuka)

Lithuto tsa Thuto

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

Motsoako oa motheo oa lifilimi o thehoa mme o behoa leqepheng la hau la mosebetsi. Maqephe a latelang a koahela moralo ona ho tšoantša moelelo oa mola o bontšitsoeng mohato oa 1 oa thuto ena.

09 ho ea ho 10

Ho theha Line Line

Beha sehlooho sa graph ka mela e 'meli

1. Tobetsa ka lekhetlo le le leng ka pointer ea mouse kae kapa kae mohloling oa graph ho e totobatsa.
2. Tobetsa ka lekhetlo la bobeli ka pointer ea mouse ka pel'a lentsoe Acapulco ho fumana ntlha ea ho kenya.
3. Tobetsa lebokose la ENTER ho lebokose ho arola sehlooho sa graph ka mela e 'meli.

Fetola 'mala oa mobala oa graph

1. Kopo ka ho le letona ka pointer ea mouse kae kae kapa kae mohloleng o mosoeu oa graph ho bula menu e theoha.
2. Tlanya le pointer ea mouse ho khetho ea pele menu: Etsa Taba ea Sebaka ho bula lebokose la lebokose la Taba ea Mochini oa Temo.
3. Tobetsa ho Litebelisoa tab ho e khetha.
4. Sebakeng sa Sebaka , tobetsa khalase e mebala ho e khetha.
5. Bakeng sa thupelo ena, khetha leseli le mosehla ka tlaase ho lebokose la lebokose.
6. Tlanya OK.

Fetola mobala o ka morao / tlosa moeli ho tloha tšōmong

1. Ka ho le letona - kopa hang ka pointer ea mouse hohle ka morao ea pale ea graph ho bula menyetla ea ho theoha.
2. Tobetsa ka pointer ea mouse ho khetho ea pele menu: Format Legend ho bula Setšoantšo Legend dialog box.
3. Tobetsa ho Litebelisoa tab ho e khetha.
4. Karolong ea Border ho ka letsohong le letšehali la lebokose la lebokose, tobetsa ho Lekhetho le le leng ho tlosa moeli.
5. Sebakeng sa Sebaka , tobetsa khalase e mebala ho e khetha.
6. Bakeng sa thupelo ena, khetha leseli le mosehla ka tlaase ho lebokose la lebokose.
7. Tlanya OK.

10 ho ea ho 10

Ho hlophisa Line Line (Ho tsoela pele)

Fetola 'mala / tlosa moeli oa sebaka sa sebaka seo

1. Ka ho le letona -bolla hang ka pointer ea mouse kae kapa kae moo ho nang le bohlooho bo botsoa ke sa graph ho bula menyetla e theoha.
2. Tlanya le pointer ea mouse ho khetho ea pele menu: Etsa Sebaka Sebaka sa Plot ho bula bukana ea Lebokose la Plot Area.
3. Tobetsa ho Litebelisoa tab ho e khetha.
4. Karolong ea Border ho ka letsohong le letšehali la lebokose la lebokose, tobetsa ho Lekhetho le le leng ho tlosa moeli.
5. Sebakeng sa Sebaka ho ea ka ho le letona, tobetsa khalase e mebala ho e khetha.
6. Bakeng sa thupelo ena, khetha leseli le mosehla ka tlaase ho lebokose la lebokose.
7. Tlanya OK.

Tlosa motsoako oa Y

1. Ka ho le letona - kopa ka lekhetlo le le leng ka pointer ea mouse ho Y axis (lehlakoreng le haufi le marulelo a marang-rang) ea graph ho bula menyetla e theoha.
2. Tobetsa ka pointer ea mouse ho kgetho ea pele ho menu: Etsa hore Axis e bule lebokose la dialog A Format.
3. Tobetsa ho Litebelisoa tab ho e khetha.
4. Karolong ea Linea ka letsohong le letšehali la lebokose la lebokose, tobetsa ho Lekhetho le leng le le leng ho tlosa mola o lekaneng.
5. Tlanya OK.

Ka nako ena, graph ea hau e lokela ho bapisa le lirapa tse bontšitsoeng mohato oa 1 oa thuto ena.