Nzira Yokuita Necheji Yakashata-Yakaswedera Pakati peStock Market muExpcel

01 of 07

Excel Stock Market Chart Overview

Cherechedza: Zvizhinji zvatiri kudana girafu zvinotaurwa kuna Excel sechati .

Chinhu chakakwirira-Chakanyatsovhara chinoratidza zuva roga roga, rakaderera, nekuvhara mitengo yekutengeswa kwechitoro pane imwe nguva yakatarwa.

Kuzadza matanho ari mumusoro ari pasi apa kuchabudisa chati yemusika wakafanana nemufananidzo uri pamusoro.

Matanho ekutanga anogadzira chati chekutanga uye matatu yekupedzisira inoshandisa huwandu hwekuita maitiro akawanikwa pasi peChirongwa , Kurongeka , uye Fomati tate dzebhoni .

Zvidzidzo Misoro

1. Kupinda muGrafu Data
2. Sarudza Dhadhi Data
3. Kuumba Chinhu Chakakosha Cheki Musika Mutengo
4. Kugadzirisa Stock Chart - Kusarudza Chimiro
5. Kugadzirisa muStock Chart - Kusarudza Chimiro Chimiro
6. Kugadzirisa Stock Chart - Kuwedzera Cheti kuChate Chart

02 of 07

Kupinda Data Data

Nhanho yekutanga yekuumba chitupa cheSvondo-Pfupi-Yakatengeswa yemusika wekutengeserana ndechokuisa data mumushandi webasa .

Paunopinda munharaunda, chengeta mitemo iyi mupfungwa:

• Chero pazvinenge zvichibvira, nyora deta yako muhurukuro sezvinoratidzwa mumufananidzo uri pamusoro
• Isa pepa rako rekushandisa rine musoro wehesi yega yega yepamusoro pamusoro pe column uye data iri mumasero ari pasi apa
• Usasiya mitsara kana michori isina chakanaka paunopinda deta yako sezvo izvi zvichange zvisingawani nzvimbo dzisina kukwana mu chati

Cherechedza: Dzidzo haisanganisi matanho ekugadzirisa pepa rekushandira sezvinoratidzwa mumufananidzo pamusoro apa. Mashoko pamusoro pekufambisa mafirimu ekushandurwa kwemashizha anowanika mune iyi inokosha yeAustom formatting tutorial .

Tutorial Steps

Pinda data sezvinoonekwa mumufananidzo uri pamusoro apa mumasero A1 kusvika kuD6.

03 of 07

Kusarudza Data Data

Zvisarudzo zviviri zvekusarudza Data Data

Kuti ubatsirwe nemirairo iyi, ona muenzaniso wechifananidzo pamusoro apa.

Kushandisa Mouse

1. Dragradza nebhokisi rekuisa kuti uise pachena masero ane data kuti aiswe mu chati.

Kushandisa Keyboard

1. Dzvanya kumusoro kumusoro kuruboshwe kwedata data.
2. Tora pasi SHIFT key pa keyboard.
3. Shandisai mitsetse yemicherechero pabhokisi kuti musarudze deta kuti iiswe mubhuku remaoko.

Cherechedza: Iva nechokwadi chekusarudza chero imwe koromo nemazita emutsara waunoda kuiswa mu chati.

Tutorial Steps

1. Simbisa bhokisi remasero kubva paA2 kusvika kuD6, ​​iyo inosanganisira mazita emakoroni uye mutsara wemutsara asi kwete musoro, uchishandisa imwe yenzira idzi dziri pamusoro.

04 of 07

Kuumba Chinhu Chakakosha Cheki Musika Mutengo

Kuti ubatsirwe nemirairo iyi, ona muenzaniso wechifananidzo pamusoro apa.

1. Dzvanya paIndaneti ribhoni tab.
   
2. Dzvanya pane chikamu chechati kuitira kuti uzarure kudonhedzera urongwa hwemafuta aripo mapepa
   
   (Hovering your mouse pointer pamusoro pechirongwa chechati kuchaunza tsanangudzo ye chati).
   
3. Dzvanya pane imwe yerati kuti uisarudze.

Tutorial Steps

1. Kana uri kushandisa Excel 2007 kana Excel 2010, bhura paItai> Zvimwe Zvinyorwa> Stock> Volume-High-Low-Close mubhoni
2. Kana uri kushandisa Excel 2013, tora paItai> Isa Stock, Surface kana Radar Charts> Stock> Volume-High-Low-Close mubhoni
3. Chinhu chakakosha cheku High-Low-Close chati yemusika chati yakasikwa uye yakagadzirirwa pane pepa rako rekushanda. Mapeji acho anotevera akavhara fomu iyi kuti ifanane nemufananidzo wakaratidzwa muchitamba chekutanga chekudzidzisa.

05 of 07

Kusarudza Chimiro

Kuti ubatsirwe nemirairo iyi, ona muenzaniso wechifananidzo pamusoro apa.

Kana iwe ukanyora pane chati, ma tate matatu - Zvigadziro, Zvigadziro, uye Mafomu Akabatanidzwa zvinowedzerwa kubhoni pasi pemusoro weChirt Tools .

Kusarudza Chimiro cheChikoro CheStock Market

1. Dzvanya patafura chati.
2. Dzvanya paGadziriro yebhu.
3. Dzvanya paMiseve Yakawandisa pasi muzasi kwekona yekona yeChaneti Styles pane panoratidza mafirimu ose aripo.
4. Sarudza Mutambo 39.

06 of 07

Kusarudza Chimiro Chimiro

Kuti ubatsirwe nemirairo iyi, ona muenzaniso wechifananidzo pamusoro apa.

Kana iwe ukanyora pane chati, ma tate matatu - Zvigadziro, Zvigadziro, uye Mafomu Tema zvinowanikwa kudhibhoni pasi pezita reChirt Tools .

Tutorial Steps

1. Dzvanya pamatare acho.
2. Dzvanya paIndaneti tab.
3. Dzvanya paMiseve Yakawandisa pasi muzasi kwekona yekona yeChaneti Styles pane panoratidza mafirimu ose aripo.
4. Sarudza Chiito Chakanyanya - Accent 3.

07 of 07

Kuwedzera Musoro kune Stock Chart

Kuti ubatsirwe nemirairo iyi, ona muenzaniso wechifananidzo pamusoro apa.

Kana iwe ukanyora pane chati, ma tate matatu - Zvigadziro, Zvigadziro, uye Mafomu Tema zvinowanikwa kudhibhoni pasi pezita reChirt Tools .

Tutorial Steps

1. Dzvanya paIndaneti tab.
   
2. Dzvanya pa Chati Chete pasi pechikamu cheMabhuku .
   
3. Sarudza chisarudzo chechitatu - Pamusoro Chetati .
   
4. Nyora mubhuku rinonzi "The Cookie Shop Daily Daily Value" pamiganhu miviri.

Panguva ino, chati yako inofanira kufanana nechati chechikwata chinoratidzwa muchitsauko chekutanga chekudzidzisa.