Excel 2003 Pie Chart Tutorial

01 pa 10

Excel 2003 Pie Chart Tutorial

Phunziroli likuphatikizapo masitepe opanga tchati cha pie mu Excel 2003 pogwiritsa ntchito Excel Chart Wizard.

Kukwaniritsa masitepe omwe ali m'munsimu kudzatulutsa tchati cha pie chofanana ndi chithunzi pamwambapa.

Kusiyana kwa Mabaibulo

Masitepe a pulogalamuyi amagwiritsira ntchito machitidwe omwe akukonzekera ndi machitidwe omwe alipo mu Excel 203. Izi zimasiyanasiyana ndi zomwe zimapezeka m'mawu oyambirira a pulogalamuyi. Gwiritsani ntchito maulumikizi otsatirawa pazithunzithunzi zamagulu a mzere pazolembedwa zina za Excel.

02 pa 10

Kulowa Data Chapa Chapa

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

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.

Kwa phunziro ili

1. Lowani deta monga momwe mukuwonera pa chithunzi pamwambapa mu maselo A3 mpaka B6.

03 pa 10

Kusankha Data Chapa Chapa

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

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.

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

Kwa phunziro ili

1. Onetsetsani chigawo cha maselo kuchokera ku A3 mpaka B6 pogwiritsira ntchito njira imodzi pamwambapa.

04 pa 10

Kuyambira Mphawi Watsati

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

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.

Kwa phunziro ili

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

05 ya 10

The Excel Chart Wizard Gawo 1

Sankhani Chati pa Standard Tab

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

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

Kwa phunziro ili

1. Sankhani mtundu wa tchati wa katayi kumanzere.
2. Sankhani Pie ndi 3-D zowonetseratu tchati chaching'ono pansi pa dzanja lamanja
3. Dinani Zotsatira.

06 cha 10

The Excel Chart Wizard Khwerero 2

Onetsani Tchati chanu

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

• 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.

Kwa phunziro ili

1. Dinani Zotsatira.

07 pa 10

The Excel Chart Wizard Khwerero 3

Zosankha Chatsati

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

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.

Kwa phunziro ili

1. Dinani ku Maudindo tab pamwamba pa bokosi la adiresi lachati.
2. Mu bokosi la mutu wa Chati, lembani mutu: Msonkho Waukulu wa Zamalonda wa Zogulitsa Zakale .
3. Dinani pa tabu Labels Labels pamwamba pa bokosi la adiresi ya Tchati.
4. Mu Label Ali ndi gawo, dinani pa Peresenti yokha kusankha.
5. Pamene tchati muwindo lawonetserako likuwoneka bwino, dinani Zotsatira.

Zindikirani: Pamene muwonjezera malemba ndi deta ayenera kuwonjezeredwa pawindo lawonetserako.

08 pa 10

The Excel Chart Wizard Khwerero 4

Malo a Tchati

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

Pali zosankha ziwiri zokha zomwe mukufuna kuyika tchati chanu:

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)

Kwa phunziro ili

1. Dinani batani lawailesi kuti muike tchati ngati chinthu chomwe chili patsamba 1.
2. Dinani Kutsiriza.

Tchati chachikulu cha pie chimalengedwa ndikuyika pa tsamba lanu la ntchito. Masamba otsatirawa afotokoza tchatichi kuti afane ndi tchati cha pie chomwe chili pa Gawo 1 la phunziroli.

09 ya 10

Kuwonjezera Mtundu kwa Chapa Chapafupi

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

Sinthani mtundu wachikulire cha tchati

1. Dinani kamodzi kamodzi ndi pointer ya mouse pena paliponse pambali yoyera ya graph kuti mutsegule menyu.
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. Kwa phunziro ili, sankhani mtundu wofiirira pansi pomwe pamanja la bokosi.
6. Dinani OK.

Sinthani mtundu wachikulire / chotsani malire ku nthano

1. Dinani kamodzi kokha ndi pointer ya mouse pena paliponse kumbuyo kwa nthano ya graph kuti mutsegule menyu pansi.
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. Kwa phunziro ili, sankhani mtundu wofiirira pansi pomwe pamanja la bokosi.
7. Dinani OK.

10 pa 10

Kugwiritsira Ntchito Mbali ya Pie

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

Kuonjezerapo kugwedezeka kwa chidutswa china chimene mungathe kusunthira kapena "kuphulika" izi zimachokera pazithunzi zonsezo.

1. Dinani ndi ndondomeko yamagulu pa chithunzi kuti muwonetsetse izo. Mitengo yaing'ono ya mdima iyenera kuoneka pamphepete mwa piya.
2. Dinani kachiwiri ndi pointer pa mouse pamagawo a chikasu (oatmeal raisin). Mdima wandiweyani uyenera kuti uzingoyenda pagawo limodzi.
3. Dinani ndi kukokera kumanzere ndi pointer la mouse pa chidutswa cha chikasu cha chitumbuwa. Kagawo kamene kamayenera kuchoka pazithunzi zonsezo.
4. Kuthandizira kagawo kameneka kumalo ake oyambirira kubwereza masitepe 1 ndi 2 pamwamba ndi kukokera chidutswacho kumbuyo. Icho chidzabwereranso ku malo ake oyambirira.

Tsamba la chikasu likuphulika chithunzichi chiyenera kufanana ndi tchati cha pie chomwe chili pa Gawo 1 la phunziro ili.