Tsela ea ho Etsa Letlapa la Stock Market e Phahameng ka ho Fetisisa-ea Fokolang

01 ea 07

Letlapa la Stock Market la Excel

Tlhokomeliso: Seo ba bangata ba rona re bitsang graph ho boleloa ho Excel e le chate .

Sete e Phahameng ka ho Fetisisa e bontša litheko tsa letsatsi le letsatsi, tse tlase le tse koalang bakeng sa setša ka nako e itseng.

Ho tlatsa mehato ho lihlooho tse ka tlase ho tla hlahisa mokateng oa marakeng oa marakeng o tšoanang le setšoantšo se ka holimo.

Mehato ea pele e etsa lechane la motheo le tse tharo tsa ho qetela li sebelisa mekhoa e mengata ea ho finyella e fumanehang tlas'a Tlhahiso , Liphetoho , le Mekhoa ea Fomete ea lithane .

Thuto Lihlooho

1. Ho kenya Data ea Graph
2. Khetha Datala Data
3. Ho theha Letlapa la Motlakase oa Tlhaho
4. Ho hlahisa Setšoantšo sa Lekhetho - Ho khetha Sebopeho
5. Ho hlahisa Setšoantšo sa Lekhetho - Ho Khetha Setšoantšo sa Sebōpeho
6. Ho theha Lethathamo la Lichelete - Ho eketsa Tlhaloso ho Leqephe la Stock

02 ea 07

Ho kenya Ditaba tsa Chart

Mohato oa pele oa ho bopa lekarete la 'maraka oa maiketsetso le phahameng-tlaase ke ho kenya data ka har'a leqephe .

Ha u kenya data , boloka melao ena kelellong:

• Nako le nako ha ho khoneha, kenya dintlha tsa hau ka dikolone joalokaha ho bontšoa setšoantšong se ka holimo
• Beha leqephe la hau la mosebetsi le sehlooho bakeng sa lihlopha tse ling tsa dintlha tse ka hodimo ho mohala le data ho lisele tse ka tlase
• U se ke ua tlohela mela kapa li-column tse se nang letho ha u kenya data ea hau kaha sena se tla baka libaka tse se nang letho chate

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 khethiloeng ka mokhoa oa ho etsa mokhoa oa mokhoa oa ho etsa li fumaneha ka thupelo ena ea motheo ea ho hlahisa Excel .

Lithuto tsa Thuto

Kenya data joalokaha ho bonngoe setšoantšong ka holimo ho lisele tse A1 ho ea ho D6.

03 ea 07

Ho khetha Data Data

Litsela tse peli tsa ho Khetha Ditaba tsa Chart

Bakeng sa thuso ka litaelo tsena, sheba mohlala oa setšoantšo ka holimo.

Ho sebelisa Mouse

1. Etsa khetho ka konopo ea mouse ho totobatsa lisele tse nang le boitsebiso bo kenyelelitsoeng chate.

Ho sebelisa Keyboard

1. Tobetsa holimo ka ho le letšehali la data ea chate.
2. Tšoara konopo ea SHIFT lebokoseng.
3. Sebelisa linotlolo tsa motsu ka lebokose ho khetha data hore e kenngoe lethathamong la lipapatso.

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

Lithuto tsa Thuto

1. Totobatsa karolo ea lisele ho tloha ho A2 ho ea ho D6, e kenyelletsang lihlooho tsa likarolo le lihlooho tsa lihlooho empa eseng sehlooho, ho sebelisa e 'ngoe ea mekhoa e ka holimo.

04 ea 07

Ho theha Letlapa la Motlakase oa Tlhaho

Bakeng sa thuso ka litaelo tsena, sheba mohlala oa setšoantšo ka holimo.

1. Tobetsa lebopeng la Ribane ea ho kenya .
   
2. Tobetsa mohlolong oa chate ho bula lenane la theoha la mefuta ea lichate e teng
   
   (Ho tsamaisa pointer ea hau ea mouse ka mofuta oa chate ho tla hlahisa tlhaloso ea chate).
   
3. Tobetsa mofuta oa chate ho o khetha.

Lithuto tsa Thuto

1. Haeba u sebelisa Excel 2007 kapa Excel 2010, tobetsa ho Insert> Tse ling tsa Charts> Stock> Likoloi-Tse Nyenyane-Tse Haufi ka Ribbon
2. Haeba u sebelisa Excel 2013, tobetsa ho kenya> Kenya Stock, Surface kapa Radar Charts> Stock> Tsela e Phahameng-Hlakola ka Ribbon
3. Leqephe la motheo la 'maraka oa' maraka oa thekiso ea motheo le tlaase le thehoa mosebetsing oa hau. Maqephe a latelang ho koahela chate ena ho bapisa setšoantšo se bontšitsoeng mohato oa pele oa thupelo ena.

05 ea 07

Ho khetha mokhoa

Bakeng sa thuso ka litaelo tsena, sheba mohlala oa setšoantšo ka holimo.

Ha o tobetsa chate, litebelisoa tse tharo - Lihlahisoa tsa Moqapi, Boemo le Temo li kenngoa lebothong tlasa sehlooho sa Lisebelisoa tsa Chate .

Ho Khetha Sebopeho sa Chate ea Khoebo ea Stock

1. Tobetsa ka lebokose la lipapatso.
2. Tobetsa Tobong ea Tlhahlobo .
3. Tobetsa metsu e mengata e ka tlaase ho ea ka ho le letona ho le letona la Panane ea Lipatane tsa Chart ho bontša mekhoa eohle e fumanehang.
4. Khetha Sebopeho sa 39.

06 ea 07

Ho Khetha Sebopeho sa Sebōpeho

Bakeng sa thuso ka litaelo tsena, sheba mohlala oa setšoantšo ka holimo.

Ha o tobetsa chate, litebelisoa tse tharo - Lihlahisoa tsa Moqapi, Boemo le Temo li kenngoa lebothong tlasa sehlooho sa Lisebelisoa tsa Chate .

Lithuto tsa Thuto

1. Tobetsa mokokotlong oa chate.
2. Tobetsa ho Fomati ea Temo.
3. Tobetsa metsu e mengata e ka tlaase ho ea ka ho le letona ho le letona la Panane ea Lipatane tsa Chart ho bontša mekhoa eohle e fumanehang.
4. Khetha Tlhahiso e Tebileng - Tlhaloso ea 3.

07 ea 07

Ho eketsa Tlhaloso ho Chate ea Stock

Bakeng sa thuso ka litaelo tsena, sheba mohlala oa setšoantšo ka holimo.

Ha o tobetsa chate, litebelisoa tse tharo - Lihlahisoa tsa Moqapi, Boemo le Temo li kenngoa lebothong tlasa sehlooho sa Lisebelisoa tsa Chate .

Lithuto tsa Thuto

1. Tobetsa ho Taba ea Mohaho .
   
2. Tobetsa Mongolo oa Chate tlas'a karolo ea Labels .
   
3. Khetha kgetho ea boraro - Tlhaloso e ka holimo .
   
4. Ngola sehlooho se reng "The Cookie Shop Daily Daily Stock" meleng e 'meli.

Ka nako ena, chate ea hau e lokela ho tšoana le lethathamo la thepa le bontšitsoeng mohato oa pele oa thupelo ena.