Excel Volume-High-Low-Close Stock Market Chart

01 ye 09

Excel Stock Market Chart Overview

A Volume-High-Low-Yakatengesa mabhizimusi emabhizimisi emhando ndeyorudzi rwebhadhi chati kana girafu rinoshandiswa kunyanya kuratidza kuchinja kwehuwandu hwezvinhu zvinoshandiswa - zvakadai sematokari - pane imwe nguva yakatarwa.

Icho chikamu chikamu che chati uye basa ravo ndezvi:

• Mitsetse yakatetepa yakananga pa chati inoratidza huwandu hwehuwandu hwematengo yenguva yacho nepamusoro pemutsara unoratidzira mutengo wepamusoro wemari uye pasi pemutsara unoratidzira mutengo wepakati wepasi
• Ivhavha yekuvhara-kona katatu. Nzvimbo yepamusoro yekatatu inoratidza mutengo wokuvhara wezviyo
• Mabharuti akavhara mabheji anoratidza vhuni kana nhamba yezvikamu zvakatengeswa kwenguva

Excel Stock Market Chati Tutori

Iyi dzidzo inokufambisa kuburikidza nekugadzira Bhuku-High-Low-Close yekambani yemusika wechato mu Excel.

Dzidzo yekutanga inogadzira nheyo yechikwata chekushandisa uye inoshandisa maitiro ekufambisa akanyorwa pasi peTra Tools Tools paibhoni kuti abudise chati yakaonekwa mumufananidzo pamusoro apa.

Zvidzidzo Misoro

1. Kupinda uye Kusarudza Dhared Data
2. Kugadzira Chinyorwa Chekutanga-Chakanyanya-Chakanyatsovhara Chati
3. Kushandisa Chart Tools kuwedzera Chati neAxes Titles
4. Kugadzira Chart Labels uye Values
5. Kugadziridza Ivha Yakavhara
6. Kushandura Mutero Wacho Mamiriro Akasiyana-siyana
7. Kuchinja Nzvimbo Yacho Mavara Akasiyana
8. Kuwedzera Dhiyabhorosi ye-3-D uye Kubatazve Chati

02 of 09

Kupinda uye Kusarudza Dhared Data

Kupinda Data Data

Nhanho yekutanga mukugadzira Bhuku-High-Low-Close chati ndeyokuisa dhesiro 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 anowanikwa mune iyi Basic Excel Kuburitsa Tutori .

Kusarudza Data Data

Kana imwe dhesi yave ichinyorwa, danho rinotevera nderokusarudza dheta kuti iite.

Mune pepa rekushanda chaiwo, chikamu chimwechete che data chinowanzowanikwa mu chati. Kusarudza kana kusimbisa deta, saka, inoudza Excel kuti ndeupi ruzivo rwekushandisa uye ruregerero.

Mukuwedzera kune nhamba yedata, iva nechokwadi chokuti unosanganisira zvose zvinyorwa uye mutsara yemazita anotsanangura data yako.

Tutori Dzakaitika:

1. Pinda data sezvinoonekwa mumufananidzo uri pamusoro apa mumasero A1 kusvika E6.
2. Draganisa sarudza masero A2 kuE6 kuti uonekwe

03 of 09

Kugadzira Chinyorwa Chekutanga-Chakanyanya-Chakanyatsovhara Chati

Mifananidzo yose inowanikwa pasi pe Insert tab yebhoni mu Excel.

Kuisa mushonga wako wepamusoro pamusoro pechikwata chechadhi kuchaunza tsanangudzo ye chati.

Kushanda pane chimwe chikamu chinotanga kudonha pasi kuratidzira zvose zvema chati zvinowanikwa mune iyoyo.

Paunenge uumba chero chati mu Excel, purogiramu inotanga kuumba icho chinonzi chechi chekutanga kushandisa data yakasarudzwa.

Mushure mokudaro, zviri kwauri kuti uenzanise chati iyo uchishandisa Itiri Zvirati Zvishandiso .

Tutori Dzakaitika:

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. Chinyorwa cheBhuku-Chechi-Low-Close chati yemusika wechato, yakafanana neinoonekwa mumufananidzo uri pamusoro, inofanira kusikwa uye yakaiswa mune pepa rako rekushanda .

Nhanho dzinosara mumudzidzisi unovhara fomati iyi chati kuratidzira mufananidzo unoratidzwa papeji 1.

04 of 09

Kushandisa Chart Tools

Chart Tools Overview

Kana zvasvika pakugadzirisa matati mu Excel, zvakakosha kuyeuka kuti haufaniri kubvuma kushandiswa kwekusimbisa kwechikamu chero chikamu che chati. Zvikamu zvose kana zvikamu zvechati zvinogona kuchinjwa.

Maikirwo ekugadzirisa ematsetse acho anowanikwa pane matatu matabhi edhibhoni ayo anowanzonzi Chart Tools

Kazhinji, aya matatu matatu haaoneki. Kuti uwane mazviri, zvinyoronyoro pa chati yawakangobva kuumba uye matatu matabhi - Kugadzira, Kurongeka, uye Format - yakawedzerwa kubhoni.

Pamusoro pematatu matatu, iwe uchaona musoro weChirati Tools .

Muchiito chekudzidzisa mazita pasi apa tichawedzera uye tinodzokorora mazita ekuremekedza uye chinyorwa chechati uyewo kutamisa nheyo yechati uchishandisa nzira dziri pasi pe chati ye Layout tab.

Kuwedzera Horizontal Axis Title

Mutsara wakarurama unoratidza mazuva ari pasi pechati.

1. Dzvanya pane chetatu iri mubasa rekushanda kuti uburise tashandisi tate
2. Dzvanya paIndaneti tab
3. Dzvanya paAxis Titles kuti uzarure pasi rezasi
4. Dzvanyira paPamusoro Pakuzorora Axis Title> Musoro Pasi paAxis sarudzo yekuti uwedzere mutsetse wekuti Axis Title ku chati
5. Dragradza chinyorwa chekutsvaga kuti chionekwe
6. Nyora mubhuku re " Date "

Kuwedzera Primary Primary Vertical Axis Title

Inonyanya kutaridzika inoratidza huwandu hwemagove akatengeswa kurutivi rworuboshwe rwechati.

1. Dzvanya pa chati kana zvichidikanwa
2. Dzvanya paIndaneti tab
3. Dzvanya paAxis Titles kuti uzarure pasi rezasi
4. Dzvanya paIt Primary Vertical Axis Title> Yakatenderedzwa Chete Chokutora kuti uwedzere mutemo weAxis Title unotsvaga pane chati
5. Dragradza chinyorwa chekutsvaga kuti chionekwe
6. Nyora mubhuku rinonzi " Volume "

Kuwedzera chikamu cheSekondari Chinyorwa Chekutanga

Ikosi yepamusoro yakananga inoratidza kutengesa kwematengo ematengesi akatengeswa kurutivi rworudyi rwe chati.

1. Dzvanya pa chati kana zvichidikanwa
2. Dzvanya paIndaneti tab
3. Dzvanya paAxis Titles kuti uzarure pasi rezasi
4. Dzvanya paChipiri Chechipiri Axis Title> Yakatenderedzwa Tsvakurudzo Chokutanga kuti uwedzere mutsetse wekuti Axis Title ku chati
5. Dragradza chinyorwa chekutsvaga kuti chionekwe
6. Nyora mubhuku rinonzi " Stock Price "

Kuwedzera Chati Chinyorwa

1. Dzvanya pa chati kana zvichidikanwa
2. Dzvanya paIndaneti tab yebhoni
3. Dzvanya pane Chati Chete> Chapa Chati chokusarudza kuti uwedzere Mutsetsi weTrasi yekutsika pane chati
4. Dragradza chinyorwa chekutsvaga kuti chionekwe
5. Nyora mubhuku iri pasi apa pamitsetse miviri - shandisai Enter key pabhokisi kuti muparadzanise mitsara: The Cookie Shop Stock Volume uye Mutengo

Kufambisa Chati Legend

Nokusingaperi, chikamu chechati chiri kuruoko rworudyi rwe chati. Kana tikangowedzera chikamu chechikwata chechipiri, zvinhu zvinowanikwa zvishoma munzvimbo iyoyo. Kuti kuderedza kusanganisa tichaendesa nheyo yacho kumusoro kwecha chati pasi pechinyorwa chechati.

1. Dzvanya pa chati kana zvichidikanwa
2. Dzvanya paIndaneti tab yebhoni
3. Dzvanya paGe Legend kuti uzarure pasi rezasi
4. Dzvanya paRendendendende yeZvinyorwa paKusarudza kwakanakisisa kutamisa nharo kuva pasi pechati chechati

05 of 09

Kugadzirisa Chart Labels uye Values

Zvinyorwa Zvokufambisa Zvinyorwa

Muchitsauko chekutanga, zvakataurwa kuti vazhinji vekugadzirisa mafashoni emashadi vakanga vari pasi peChirati Cheteti .

Rimwe boka rekugadzirisa mafungiro asina kuwanikwa pano nderemavara ekugadzirisa zvishandiso - zvakadai seusita hwemafonti uye marara, bold, italics, nekugadzirisa.

Izvi zvinogona kuwanikwa pasi peKumba tab yebhoni -font font.

Excel Right Click Menus uye Toolbar

Nzira iri nyore, kunyange zvakadaro, yekutsvaga zvingasarudzwa ndezvekunyatsotarisa pane chinhu chaunoda kuenzanisa.

Kuita saizvozvo kunotanga chikwata chekodzero kana mamiriro ekutenderera anosanganisira chiduku chiduku chekushandisa.

Sezvo iri chikamu chemuongorori wemenu, zvigadziridzo zvekugadzirisa pane bharibhari zvinoshanduka zvichienderana nezvamakaisa pane.

Semuenzaniso, kana iwe ukanyatsotsvaga pane imwe yebhuruti yevhodhi mabhadha mu chati iwe toolbar ine zvigadziri zvese zvekufambisa zvingashandiswa nechati chinhu chino.

Kungofa-chengetedza imwe yematombo kana nhoroondo kunokupa zvinyorwa zvekufambisa zvinyorwa zvakafanana kune izvo zvakawanikwa pasi peKumba tab yebhoni.

Chart Formatting Shortcut

Muchikamu chino chekudzidzisa, tinoda kuchinja mararamiro ezvinyorwa zvose, nheyo, uye maitiro - nhamba uye mazuva ari mumatanho ematare - kumucheka webhuruu wakafanana neavo vharuti yevhoriyiti.

Panzvimbo pokuita chimwe nechimwe zvakasiyana, kunyange zvakadaro, tinogona kuchengetedza imwe nguva nekuchinja mararamiro emazita ose uye mararamiro mu chati pane imwe nguva.

Iyi nzira shomanana inosanganisira kusarudza chati yose nekutsvaga pamuchena mutsva panzvimbo pane kuisa pazvinhu zvakasiyana,

Kugadzirisa Mavara Ese uye Maitiro

1. Kumbofa nechokuita pane chichena chemashure kuti uzarure mamiriro ekutenderera kwechati
2. Dzvanya pamutsara muduku pasi kusvika kurudyi rwePaul Color icon mune mharidzo yemajeri kuti uzarure Guritsa Remavara Remavara
3. Dzvanya paBlue Accent 1, Rima 25% kuti uchinje mazita ose uye maitiro mu chati pane iyo

Kuderedza Chati Title Font Size

Iko kusina kwemaitiro emhando yechinyorwa chechati ndeye 18 pfungwa iyo inowedzera mamwe mavara uye inoderedzawo nzvimbo yenzvimbo ye chati. Kuti tigadzirise mamiriro ezvinhu aya tichabvisa chidhindwe chetaiti chetipa taita mapeji 12.

1. Dzvanya paGatidzi Chinyorwa kuti uchisarudze - chinofanira kukombwa nebhokisi
2. Dragdza sarudza musoro kuti uonekwe
3. Tsanangurira pachokwadi pazvinyorwa zvakasimbiswa kuti uzarure mamiriro ekukomberedza
4. Dzvanya pamutsara muduku pasi kusvika kurudyi rweSpain Size icon - nhamba 18 mumutsara wepamusoro wechikwata chekushandisa - kuti uzarure pasi pezita remavara emafaira aripo
5. Dzvanya pane 12 muurongwa kuti uchinje chati yemaiti yepaiti kusvika ku 12 pfungwa
6. Dzvanya pamatare echechi kuti ubvise zvakasimbiswa pane chinyorwa chechati
7. Nharaunda yenharaunda yechati inofanirawo kuwedzera mukukura

06 of 09

Kugadziridza Ivha Yakavhara

Izvo zvisingazivikanwi zvakasimbiswa pata chati - iyo inoratidza kuvhara kwekutengesa kwekutengesa - inogova mutsara wekutsvaira. Muchidimbu chedu, chiratidzo chacho hachikwanisi kuona - kunyanya kana chiri pakati pebhuruu yevhodhi yepamusoro sezvinoitika musi we 6, 7, uye 8 February.

Kuti tigadzirise mamiriro ezvinhu aya, isu tichashandura chiratidzo kune katatu apo nzvimbo yepamusoro inomirira mutengo wekuvhara wekutengesa kwezuva iroro.

Tichazochinjawo hukuru uye ruvara rwekanyararo kusvika kune tsvuku kuitira kuti rimire kunze kwemavara ebhuruu evhareji.

Cherechedza : Kana tikashandura munhu weChitsuwa Chevhavha-taurai musi waFebruary 6th - chete chiratidzo chezuva ichocho chichachinja-zvinoreva kuti tichazodzokorora matanho akafanana kanomwe kuti tishandure zvose zvichemo.

Kuti uchinje mucherechedzo kwemazuva ose mana panguva imwe chete tinoda kuchinja kuvhara kweSvondo muchikamu chechati.

Tutorial Steps

Sezvo muchitsauko chekutanga chekudzidzisa, tichashandisa mamiriro ekutenderera kuti tizadze danho iri.

Kuchinja Mararamiro

1. Dzokorora kamwe chete pamheto kuti uisarudze - inofanira kuve yakakombwa nebhokisi
2. Kamwe kamwechete pazwi Vhura mumutsago kuti uisarudze - shoko reSvondo rinofanira kunge rakapoteredzwa nebhokisi
3. Kurudyi, chengetedza shoko rokuti Swedera kuti uzarure mamiriro ezviko
4. Dzvanya ku Format Data Series sarudzo mumutauro wechikwata chekutenderera kuti uzarure bhokisi rebhokisi
5. Dzvanya pa Marker Futa muwindo wekweseri kuruboshwe rweDesk Data Data Series dialog box
6. Dzvanya paZvizadza Faira muwindo rekurudyi rwebhokisi rebhokisi
7. Dzvanya pamusara wezasi kusvika kurudyi rweMuvara wezviratidzo muwindo rokurudyi kuti uzarure jira reColors
8. Dzvanya penyoro pasi peStart Colors kuti uchinje ruvara rwemavara kune zero
9. Siya ibhokisi rekuzarura rakazarurirwa kune danho rinotevera mune zvidzidzo

Kushandura Mararamiro Akasiyana uye Kukura

1. Dzvanya pa Marker Options mune wewindo rweruboshwe ye Format Format Series box box
2. Dzvanya Pakuvakwa-mukati pasi peChiratidzo cheMutauro Wemuenzaniso muwindo rwerudyi rwebhokisi rebhokisi
3. Dzvanya pamusorosoro pasi kusvika kurudyi rweChiratidzo icon muwindo rokurudyi kuti uzarure pasi rezasi
4. Dzvanya pamaketani katatu ari muzita kuti uchinje chiratidzo
5. Pasi Pakukura , sarudzo inowedzera hukuru hwekatatu kusvika ku8
6. Dzvanya paBhura Rakatseka kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda .

07 of 09

Kushandura Mutero Wacho Mamiriro Akasiyana-siyana

Kuti uchinje ruvara rwemukati we chati yose, tichazoshandisa zvakare mamiriro ekutenderera. Rusarudzo rwemavara mumutauro wezvakakosheswa rwakarongerwa semuvara-wechena kunyange zvazvo uchiita sehupamhi kupfuura jena.

Tutori Dzakaitika:

1. Kumbofa nechokuita pane chichena chemashure kuti uzarure mamiriro ekutenderera kwechati
2. Dzvanya pamutsara muduku pasi kusvika kurudyi rweZviza Zara Radzaza - pende inogona - mumubhairi wezvakakonzera kuti uzarure hurukuro yeChinyorwa Chevara
3. Dzvanya paGreen, Chigadziko 1, Chimare 25% kuti uchinje chikara chemutsara weguru ku grey

08 of 09

Kuchinja Nzvimbo Yacho Mavara Akasiyana

Matanho ekushandura ruvara rwemukati wenharaunda yacho inenge yakafanana kune iyo yekushandura ruvara rwemukati we chati yose.

Muto wakasarudzwa nechati chechati ichi chinoratidzika sechiedza chebhuruu kunyange zvazvo chakarongerwa sechivara chebhuruu mubhokisi remavara.

Cherechedza: Chenjerera kuti usasarudza mitsetse yakananga yemigero inoshandisa nzvimbo iyo nzvimbo panzvimbo yemamiriro acho pachako.

Tutori Dzakaitika:

1. Kumbofa nechokuita pane chivara chenzvimbo chekuyera kuti uzarure nzvimbo yemugariro yemamiriro ezvinhu
2. Dzvanya pamutsara muduku pasi kusvika kurudyi rweZviza Zara Radzaza - pende inogona - mumubhairi wezvakakonzera kuti uzarure hurukuro yeChinyorwa Chevara
3. Dzvanya paGuru Dzvuku, Rugwaro 2, Chiedza 80% kuti uchinje nzvimbo yakatarisa ruvara rwemuvara webhuruu.

09 of 09

Kuwedzera Dhiyabhorosi ye-3-D uye Kubatazve Chati

Kuwedzera 3-D Dhiyabhorosi

Kuwedzera mhando ye-3-D inoshandiswa ndeyekubata kwekunakidza kunowedzera zvakadzama kune chati. Iyo inobva pane chati iri nechemberi-yakatarisa kunze kwechokumusoro.

1. Kumbofa nechokuita pane chichena chemashure kuti uzarure mamiriro ekutenderera kwechati
2. Dzvanya paGadzira Chirongwa cheSain Area munzvimbo yebhari yezvakakosha kuti uzarure bhokisi rebhokisi
3. Dzvanya pane 3-D Format muwindo uri kuruboshwe rweIndaneti Chati yeChirongwa chebhokisi
4. Dzvanya pamusoroshe pasi kusvika kurudyi rweIndaneti yepamusoro muwindo rekurudyi kuti uzarure mapaneti evevelwe
5. Dzvanya paConvex sarudzo mumapaneti kuti uise kukanganiswa kwechati pane chati
6. Dzvanya paBhura Rakatseka kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda

Kudzokorora Chati

Kudzokorora chati yacho ndeimwe imwe danho rekuita. Kubatsira pakuita chati yakawanda ndechokuti kunoderedza kutarira kwevanhu vakawanda kwakagadzirwa nechechipiri yakananga kudivi kuruoko rworudyi rwe chati.

Ichawedzerawo huwandu hwemaiti nzvimbo iyo inoita chati chati nyore kuverenga.

Nzira iri nyore yokugarisa chati ndeyokushandisa zvigadziro zvinoshandiswa zvinoshanda zvakapoteredza nechekunze kwechati kana iwe ukanyora pairi.

1. Dzvanya kamwe pane chati yechati kuti usarudze chati yose
2. Kusarudza chati kunowedzera mutsetse wakachena webhuruu kusvika kumucheto kunze kwechati
3. Mumakona emutsara uyu webhuruu ndeyekusimudza mashizha
4. Hover your mouse pointer pamusoro peimwe yemakona kusvika iyo pointer ichinje kuva museve wakaita mutsvuku
5. Apo pointer iyi iyi museve-musoro, tsanidza kuruboshwe rwemutsara uye tora kunze zvishoma kuti uwedzere chati. Icho chati ichadzokorora zvakare mukati marefu nehupamhi. Nzvimbo yacho inofanira kuwedzera muhukuru pamwe chete.

Kana iwe wakatevera matanho ose aya mune zvidzidzo panguva ino yako Chinyorwa cheBhuku-High-Low-Close Stock Market chinofanirwa kufanana nemuenzaniso wakaratidzwa mumufananidzo uri papeji 1 yeyikudzidzisa.