Excel 2003 Line Graph Tutorial

01 pa 10

Zowonjezerapo za Wachitsulo wa Chitsanzo cha Excel 2003

Phunziroli limaphatikizapo masitepe opanga girasi lamzere mu Excel 2003 pogwiritsa ntchito Excel Chart Wizard.

Kukwaniritsa masitepe omwe ali m'munsimu kudzatulutsa mzere wofanana ndi fano pamwambapa.

02 pa 10

Kulowetsa Deta ya Dera la Graph

Kaya muli ndi tchati kapena graph mtundu wotani, choyamba pakupanga tchati cha Excel nthawi zonse ndikulowetsa deta muzenera .

Mukalowetsa deta, kumbukirani malamulo awa:

1. Musasiye mzere kapena mizere yopanda kanthu mutalowa deta yanu.
2. Lowani deta yanu muzitsulo.

• Poyika tsamba lanu lamasamba , lembani mayina omwe akufotokoza deta m'mbali imodzi ndipo, kumanja kwa izo, deta yokha.
• Ngati pali zowonjezereka zotsatila deta, lembani mndandanda wa zigawozo pamutu ndi mutu wa mndandanda uliwonse wa deta pamwamba.

Maphunziro Otsogolera

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

03 pa 10

Kusankha Data ya Graph Data

Kugwiritsa ntchito mbewa

1. Kokani osankha ndi batani kuti musonyeze maselo okhala ndi deta kuti aphatikizedwe mu graph.

Kugwiritsa ntchito kiyibodi

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 mu graph.

Zindikirani: Onetsetsani kuti musankhe mzere uliwonse ndi mitu yomwe mukufuna kuti muphatikizidwe.

Maphunziro Otsogolera

1. Onetsetsani chigawo cha maselo kuchokera ku A2 mpaka C6, chomwe chiri ndi maudindo a mndandanda ndi mitu ya mzere pogwiritsa ntchito njira imodzi yomwe ili pamwambapa.

04 pa 10

Kuyambira Mphawi Watsati

Muli ndi zisankho ziwiri zoyambira Wowonjezera Chart Ward Wizard.

1. Dinani pa chithunzi cha Wachitsulo cha Chati pazitsulo (onani chitsanzo cha chithunzi pamwambapa)
2. Dinani ku Insert> Chart ... mu menus.

Maphunziro Otsogolera

1. Yambitsani Wotchi wa Chati pogwiritsa ntchito njira yomwe mukufuna.

05 ya 10

The Excel Chart Wizard Gawo 1

Sankhani Chati pa Standard Tab

1. Sankhani mtundu wa Chati kuchokera kumanzere.
2. Sankhani chithunzi chachitsulo kuchokera ku gulu labwino.

Maphunziro Otsogolera

1. Sankhani mtundu wa chithunzi chachitsulo pamanja lamanzere.
2. Sankhani Lembali ndi chizindikiro cha chithunzi chachitsulo chakumanja
3. Dinani Zotsatira.

06 cha 10

The Excel Chart Wizard Khwerero 2

Onetsani Tchati chanu

• Mutasankha deta yanu musanayambe Excel Chart Wizard, muyenera kuwona chitsanzo cha tchati yanu pawindo lapamwamba la bokosi.
• Pa tsamba lanu, deta yomwe yaphatikizidwa mu tchatiyi ili ponseponse ndi nyerere zoyendayenda - malire akuda akuzungulira kuzungulira deta yanu.
• Pansi pazenera zowonetserako ndi bokosi lomwe lili ndi mafotokozedwe a maselo a ma data omwe ali m'ndandanda. Ngati chithunzi chako sichiwoneka bwino, onetsetsani kuti mwasankha deta yolondola mu spreadsheet.

Maphunziro Otsogolera

1. Dinani Zotsatira.

07 pa 10

The Excel Chart Wizard Khwerero 3

Zosankha Chatsati

Ngakhale pali zotsalira zambiri pansi pa ma tebulo asanu ndi limodzi kuti musinthe maonekedwe a chithunzi chanu, mu sitepe iyi, tidzangowonjezera maudindo.

Mbali zonse za mndandanda wa Excel zikhoza kusinthidwa mutatha kumaliza Chintchito cha Wotsatila, choncho simukufunikira kupanga zonse zomwe mungasankhe pakalipano.

Maphunziro Otsogolera

1. Dinani ku Maudindo tab pamwamba pa bokosi la adiresi lachati.
2. Mu bokosi la mutu wa Chithunzi, lembani mutu: Average Precipitation for Acapulco ndi Amsterdam .
3. Mu bokosi la Category (X), gwiritsani ntchito: Mwezi .
4. Mu gulu la Y (Y) axis box, mtundu: Precipitation (mm) (Dziwani: mm = millimeters).
5. Pamene tchati muwindo lawonetserako likuwoneka bwino, dinani Zotsatira.

Dziwani: Pamene mukulemba maudindo, ayenera kuwonjezeredwa pawindo lawonetserako

08 pa 10

The Excel Chart Wizard Khwerero 4

Malo a Girasi

Pali zosankha ziwiri zokha zomwe mukufuna kuyika pa graph yanu:

1. Monga chinsalu chatsopano (onetsani tchati pa tsamba lina lochokera m'buku lanu la ntchito)
2. Monga chojambula 1 (onetsani chithunzi cha pepala lomwelo monga data yanu mu bukhuli)

Maphunziro Otsogolera

1. Dinani batani lawailesi kuti muike galasi ngati chinthu chojambula 1.
2. Dinani Kutsiriza.

Mzere wolemba mzere umapangidwa ndikuikidwa pa tsamba lanu la ntchito. Masamba otsatirawa akuphimba fayiloyi kuti lifanane ndi mzere wa mzere wowonetsedwa pa Gawo 1 la phunziro ili.

09 ya 10

Kupanga Malemba a Mzere

Ikani mutu wa grafu pa mizere iwiri

1. Dinani kamodzi ndi ndondomeko yamagulu paliponse pa mutu wa graph kuti muwonetsetse izo.
2. Dinani kachiwiri ndi pointer ya mouse pamaso pa mawu akuti Acapulco kuti mupeze malo olowa.
3. Onetsetsani ENTER yeniyeni pa khididiyi kuti mugawire mutu wa graph mu mizere iwiri.

Sinthani mtundu wachikulire wa grafu

1. Dinani pang'onopang'ono kamodzi ndi ndondomeko yamanja kulikonse kumbali yoyera ya graph kuti mutsegule menyu otsika.
2. Dinani ndi ndondomeko ya ndondomeko yoyamba pa menyu: Pangani Tchati Chachigawo kuti mutsegule bokosi lachigawo Chamawonekedwe Cha Chithunzi.
3. Dinani pa Zithunzi Zomwe Mungasankhe .
4. Kumalo gawolo, dinani palasi yachikasu kuti muisankhe.
5. Phunziro ili, sankhani mtundu wachikasu pamunsi mwa bokosi la bokosi.
6. Dinani OK.

Sinthani mtundu wachikulire / chotsani malire ku nthano

1. Chotsani-yesani kamodzi ndi ndondomeko yamanja kulikonse kumbuyo kwa nthano ya graph kuti mutsegule menyu.
2. Dinani ndi ndondomeko ya ndondomeko yoyamba pa menyu: Format Legend kutsegula Format Legend dialog box.
3. Dinani pa Zithunzi Zomwe Mungasankhe .
4. Mu gawo la Border kumanzere kwa bokosi la bokosi, dinani pa Njira yosachotsera malire.
5. Kumalo gawolo, dinani palasi yachikasu kuti muisankhe.
6. Phunziro ili, sankhani mtundu wachikasu pamunsi mwa bokosi la bokosi.
7. Dinani OK.

10 pa 10

Kupanga Malemba a Mzere (Kupitilira)

Sinthani mtundu / chotsani malire a malo amalo

1. Kumanja -bwerani kamodzi ndi ndondomeko yamagulu paliponse pamtunda wa imvi muli graph kuti mutseke menyu.
2. Dinani ndi ndondomeko ya ndondomeko yoyamba pa menyu: Pangani Chigawo cha Plot kuti mutsegule Bokosi la Mafotokozedwe a Plot Area.
3. Dinani pa Zithunzi Zomwe Mungasankhe .
4. Mu gawo la Border kumanzere kwa bokosi la bokosi, dinani pa Njira yosachotsera malire.
5. Kumalo omwe ali kumanja kupita kumanja, dinani palasi yachikasu kuti muisankhe.
6. Phunziro ili, sankhani mtundu wachikasu pamunsi mwa bokosi la bokosi.
7. Dinani OK.

Chotsani chingwe cha Y

1. Chotsani -dolani kamodzi ndi kondomu yamagulu pa Y axis (mzere wozungulira pafupi ndi mvula yamtundu) ya grafu kuti mutsegule menyu.
2. Dinani ndi ndondomeko ya ndondomeko yoyamba pa menyu: Lembani Axis kuti mutsegule bokosi la Ma Axis dialog.
3. Dinani pa Zithunzi Zomwe Mungasankhe .
4. Mu gawo la Lines kumanzere kwa bokosi la bokosi, dinani pa Chosankha chochotsamo mzere wotsatira.
5. Dinani OK.

Panthawiyi, graph yanu iyenera kufanana ndi mzere wa mzere womwe wasonyeza pa Gawo 1 la phunziro ili.