Mmene Mungapangire Chithunzi Chachikulu Chakugulitsa Masitolo ku Excel

01 a 07

Chitsanzo cha Msika wa Stock Excel

Zindikirani: Ambiri a ife timachitcha grafu amatchulidwa ku Excel ngati tchati .

Tchati Chokwera Kwambiri Chimawonetsa mitengo yapamwamba, yotsika, ndi yotseka mtengo tsiku lonse.

Kukwaniritsa masitepe omwe ali m'munsiyi kudzatulutsa chithunzi cha msika wofanana ndi chithunzi pamwambapa.

Mapangidwe oyambirira amapanga tchati yoyamba ndipo zitatu zomalizira zimagwiritsa ntchito zinthu zambiri zojambula zomwe zilipo pansi pa Mapangidwe , Mapangidwe , ndi Mafomu a Tsamba .

Mitu Yophunzitsa

1. Kulowa Dera la Graph
2. Sankhani Deta ya Deta
3. Kupanga Tchati Chachikulu Chachigulitsa Masitolo
4. Kupanga Chikhomo Chachipewa - Kusankha Ndemanga
5. Kujambula Tchati Chachidule - Kusankha Zithunzi Zopangidwira
6. Kupanga Chikhomo Chachigwirizano - Kuwonjezera Mutu ku Chithunzi Chachigamulo

02 a 07

Kulowa Data Data

Chinthu choyamba pakupanga tchati cha Masitolo a Zogulitsa Zapamwamba ndikutsegula deta muzenera .

Mukalowetsa deta , kumbukirani malamulo awa:

• Pamene kuli kotheka, lowetsani deta yanu muzitsulo monga momwe tawonetsera pa chithunzi pamwambapa
• Ikani pepala lanu lamasewero ndi mutu wa mndandanda uliwonse wa deta pamwamba pa chigawocho ndi deta mu maselo omwe ali pansipa
• Musasiye mzere kapena mizere yopanda kanthu mukalowetsa deta yanu momwe izi zidzakhalire opanda kanthu pa tchati

Zindikirani: Maphunziro samaphatikizapo masitepe opangidwira tsambali monga momwe taonera pa chithunzi pamwambapa. Zomwe mungapange pazomwe mungapangire mapepala apangidwe zimapezeka mu phunziroli lopangira maonekedwe a Excel .

Maphunziro Otsogolera

Lowani deta monga momwe mukuwonera pa chithunzi pamwambapa mu maselo A1 mpaka D6.

03 a 07

Kusankha Data Data

Zosankha Zachiwiri Zosankha Deta Chapa

Kuti muwathandize ndi malangizo awa, onani chitsanzo cha chithunzi pamwambapa.

Kugwiritsa ntchito Mouse

1. Kokani osankha ndi batani kuti musonyeze maselo omwe ali ndi deta kuti aphatikizidwe.

Kugwiritsa ntchito Keyboard

1. Dinani pamwamba kumanzere kwa deta ya deta.
2. Gwiritsani chinsinsi cha SHIFT pa kambokosi.
3. Gwiritsani ntchito mafungulo pa makiyi kuti musankhe deta kuti muphatikizidwe.

Zindikirani: Onetsetsani kuti musankhe mzere uliwonse ndi maudindo omwe mukufuna kuti muphatikizidwe.

Maphunziro Otsogolera

1. Gwiritsani ntchito chigawo cha maselo kuchokera ku A2 mpaka D6, zomwe zikuphatikizapo maudindo a mndandanda ndi mitu ya mzere koma osati mutu, pogwiritsa ntchito njira imodzi yomwe ili pamwambayi.

04 a 07

Kupanga Tchati Chachikulu Chachigulitsa Masitolo

Kuti muwathandize ndi malangizo awa, onani chitsanzo cha chithunzi pamwambapa.

1. Dinani pa tabu ya Insert tab.
   
2. Dinani pa gulu la tchati kuti mutsegule mndandanda wotsika wa mitundu yotsatila
   
   (Kutsegula pointer yanu ya mouse pamtundu wa chithunzi kudzabweretsa kufotokoza kwa tchati).
   
3. Dinani pa mtundu wa chithunzi kuti musankhe.

Maphunziro Otsogolera

1. Ngati mukugwiritsa ntchito Excel 2007 kapena Excel 2010, dinani pa Insert> Other Charts> Stock> Vuto-Low-Low-Close mu nkhono
2. Ngati mukugwiritsa ntchito Excel 2013, dinani pa Insert> Insert Stock, Surface kapena Radar Charts> Stock> Low-Low-Low-Close mu nkhono
3. Chithunzi chofunika chapafupi cha msika wa masitolo chimalengedwa ndikuikidwa pa tsamba lanu. Masamba otsatirawa afotokozera tchatichi kuti agwirizane ndi chithunzi chomwe chikuwonetsedwa mu sitepe yoyamba ya phunziro ili.

05 a 07

Kusankha Ndemanga

Kuti muwathandize ndi malangizo awa, onani chitsanzo cha chithunzi pamwambapa.

Mukamalemba pa tchati, ma tebulo atatu - Mapangidwe, Mapangidwe, ndi Mafomu a Mtundu amawonjezedwa ku riboni pansi pa mutu wa Zida Zamatchi .

Kusankha Ndondomeko ya Tchati cha Msika wa Stock

1. Dinani pa chithunzi cha mndandanda.
2. Dinani pa tabu Yopanga .
3. Dinani kumsana Wowonjezera Wowonjezera pansi pazanja lakumanja kumanzere a Tchati Styles kuti muwonetse mafashoni onse omwe alipo.
4. Sankhani Mtundu 39.

06 cha 07

Kusankha Zithunzi Zapangidwe

Kuti muwathandize ndi malangizo awa, onani chitsanzo cha chithunzi pamwambapa.

Mukamalemba pa tchati, ma tebulo atatu - Mapangidwe, Mapangidwe, ndi Mafomu a Mtundu amawonjezedwa ku riboni pansi pa mutu wa Zida Zamatchi .

Maphunziro Otsogolera

1. Dinani kumbuyo kwa tchati.
2. Dinani pa tabu ya Fomu .
3. Dinani kumsana Wowonjezera Wowonjezera pansi pazanja lakumanja kumanzere a Tchati Styles kuti muwonetse mafashoni onse omwe alipo.
4. Sankhani Mphamvu Yamphamvu - Kalankhulidwe 3.

07 a 07

Kuwonjezera Mutu ku Chithunzi Chachigamulo

Kuti muwathandize ndi malangizo awa, onani chitsanzo cha chithunzi pamwambapa.

Mukamalemba pa tchati, ma tebulo atatu - Mapangidwe, Mapangidwe, ndi Mafomu a Mtundu amawonjezedwa ku riboni pansi pa mutu wa Zida Zamatchi .

Maphunziro Otsogolera

1. Dinani pa Tsambali layout.
   
2. Dinani pa Tsati la Chithunzi pansi pa gawo la Malemba .
   
3. Sankhani njira yachitatu - Pamwamba pa Tchati .
   
4. Lembani mutu wakuti "Chokudya cha Daily Cookie Stock" pa mizere iwiri.

Panthawiyi, tchati yanu iyenera kufanana ndi tchati chazithunzi zomwe tawonetsa pa sitepe yoyamba ya phunziroli.