Mmene Mungapangire Chithunzi Chakhosi ku Excel

01 ya 06

Mmene Mungapangire Chithunzi Chakhosi ku Excel

Masitepe opanga chithunzi choyambira pa Excel ndi awa:

1. Onetsani deta kuti muphatikizidwe - phatikizani mzere ndi mitu ya mutu koma osati mutu wa tebulo la deta;
2. Dinani ku Insert tab ya riboni ;
3. Mu bokosi la Chitsulo cha riboni, dinani pa chithunzi cha Tchati cha Tchati Chotsitsa kuti mutsegule mndandanda wa mitundu yomwe ilipo.
4. Sungani pepala lanu la mouse pamtundu wa tchati kuti muwerenge kufotokoza kwa tchati;
5. Dinani pa graph yomwe mukufuna;

Tchati chodziwika, chosadziwika - chomwe chimangosonyeza ndondomeko zomwe zikuimira deta yosankhidwa, mutu wosatsatika wa tchati, nthano, ndi nkhwangwa zowonjezera - zidzawonjezedwa pa tsamba lamasamba.

Kusiyana kwa Mabaibulo mu Excel

Masitepe a pulogalamuyi amagwiritsira ntchito mazokondedwe ndi machitidwe omwe alipo mu Excel 2013. Izi zimasiyana ndi zomwe zapezeka kumayambiriro kwa pulogalamuyi. Gwiritsani ntchito maulumikizi otsatirawa pamaphunziro a tchati chazithunzi za ma Excel ena.

• Excel 2010 Kolemba Tchatilamu
• Excel 2003 (ndi Mabaibulo oyambirira) Tchati Chachidule Chakuphunzitsani

Chidziwitso pa mutu wa Excel Colors

Excel, monga mapulogalamu onse a Microsoft Office, amagwiritsa ntchito malemba kuti ayang'ane mawonekedwe ake.

Mutu umene umagwiritsidwa ntchito pa phunziro ili ndi mutu wosasinthika wa Office .

Ngati mutagwiritsa ntchito mutu wina pamene mukutsatira phunziroli, mitundu yomwe ili muzochitikazi sizingapezeke pa mutu womwe mukugwiritsa ntchito. Ngati sichoncho, ingosankhira mitundu yomwe mukuikonda ngati m'malo ndi kupitiliza.

02 a 06

Kulowa Data Chachidule ndi Kupanga Tchati Choyambira Chachidule

Zindikirani: Ngati mulibe deta yomwe ili pafupi kuti mugwiritse ntchito ndi phunziroli, ndondomeko za phunziroli zimagwiritsa ntchito deta yosonyezedwa pa chithunzi pamwambapa.

Kulowa mu ndondomekoyi ndi nthawi yoyamba kupanga tchati - ziribe kanthu mtundu wa tchati umene ulipo.

Khwerero yachiwiri ndikuwonetsa deta yomwe ingagwiritsidwe ntchito popanga tchati.

1. Lowetsani deta yosonyezedwa mu chithunzi pamwamba pa maselo ofiira a masamba
2. Mukalowa, onetsetsani maselo osiyanasiyana kuchokera ku A2 mpaka D5 - ili ndilo deta yomwe idzaimiridwe ndi tchati chachindunji

Kupanga Tchati Choyambira Chachidule

Mndandanda wa m'munsiyi udzapangira tchati chachinsinsi - chithunzi chosazindikiritsa - chomwe chimasonyeza deta zitatu, nthano, ndi mutu wosasintha.

Pambuyo pake, monga tafotokozera, phunziroli likufotokoza momwe mungagwiritsire ntchito zina zomwe zimagwiritsidwa ntchito popanga maonekedwe, zomwe, ngati zitsatiridwa, zidzasintha galasi loyambirira kuti lifanane ndi lomwe lasonyezedwa pamwamba pa phunziroli.

1. Dinani pa Insert tab ya riboni
2. Mu bokosi la Chitsulo cha riboni, dinani pa chithunzi cha Tchati cha Tchati Chotsitsa kuti mutsegule mndandanda wotsika wa mitundu ya tchati yomwe ilipo
3. Sungani chojambula chanu cha mouse pamtundu wa tchati kuti muwerenge kufotokoza kwa tchati
4. Mu gawo la 2-D Lamulo la mndandanda, dinani pa Mzere Wowonjezeredwa - kuwonjezera tchati loyambira pa tsamba

03 a 06

Kuwonjezera Mutu wa Chati

Sinthani Chinthu Chachidule Chachidutswa podutsa pawiri kawiri - koma osabwereza kawiri

1. Dinani kamodzi pa mutu wosasinthika wa chithunzi kuti muwusankhe - bokosi liyenera kuwonekera kuzungulira mawu Chart Title
2. Dinani kachiwiri kuti muike Excel mu edit mode , yomwe imaika cursor mkati mwa mutu wa bokosi
3. Chotsani malemba osasintha pogwiritsa ntchito makiyi Otsala / Backspace pa makiyi
4. Lowani mutu wa tchati - Bukhu la Cookie 2013 Summary Summary - mu bokosi la mutu
5. Ikani chithunzithunzi pakati pa Shop ndi 2013 mu mutu ndikusindikizira Fungulo lolowamo pa khididiyi kuti mulekanitse mutu pa mizere iwiri

Pano, tchati yanu iyenera kufanana ndi chitsanzo chomwe chikuwonetsedwa pamwambapa.

Kulimbana ndi Gawo Lolakwika la Tchati

Pali zigawo zambiri pa tchati mu Excel - monga malo amalo omwe ali ndi tchati chachindunji chomwe chikuimira mndandanda wa data, nthano, ndi mutu wa tchati.

Zonsezi zimaonedwa ngati zosiyana ndi pulogalamuyo, ndipo, motere, aliyense akhoza kupangidwa mosiyana. Mumauza Excel chomwe chili gawo la tchati yomwe mukufuna kuimanga mwa kuyika pa iyo ndi ndondomeko ya mouse.

Muzotsatira izi, ngati zotsatira zanu sizifanana ndi zomwe zalembedwa mu phunziroli, ndizotheka kuti mulibe gawo loyenera la tchati yomwe mwasankha pamene mwasankha machitidwe omwe mumasankha.

Kulakwitsa kofala kwambiri ndikudutsa chigawo cha chiwembu pakati pa ngoloyo pamene cholinga chake ndi kusankha tchati chonse.

Njira yosavuta yosankhira tchati chonse ndikukweza pamwamba kumanzere kapena kumanzere kumbali ya mutu wa tchati.

Ngati kulakwitsa kwapangidwa, kungakonzedwe mwamsanga pogwiritsa ntchito chithunzi cha Excel kukonza cholakwika. Pambuyo pake, dinani mbali yoyenera ya tchati ndikuyesanso.

04 ya 06

Kusintha Ndondomeko ya Chati ndi Column Colors

Makanema a Chart Tools

Pamene tchati imapangidwa ku Excel, kapena pamene chithunzi chomwe chilipo chikusankhidwa pogwiritsa ntchito, ma tebulo awiri akuwonjezeredwa ku riboni monga momwe tawonetsera pa chithunzi pamwambapa.

Ma tepi a Chart - makonzedwe ndi mapangidwe - ali ndi mawonekedwe ndi machitidwe omwe angaphatikizepo ma chart, ndipo adzagwiritsidwa ntchito pazotsatira zotsatirazi kuti mupange ndondomekoyi.

Kusintha Ndondomeko ya Chati

Miyati ya tchati ndizophatikizapo zosankhidwa zomwe zingagwiritsidwe ntchito mwamsanga kupanga tchati pogwiritsa ntchito njira zosiyanasiyana.

Kapena, monga momwe zilili mu phunziroli, angagwiritsiridwenso ntchito ngati chiyambi cha kupanga maonekedwe ndi kusintha kwina kumasankhidwe osankhidwa.

1. Dinani kumbuyo kwa tchati kuti musankhe tchati chonsecho
2. Dinani pa tabu Yopanga ya kasoni
3. Dinani pazojambula 3 njirayi mu gawo la Chithunzi cha Masitala a Riboni
4. Mizere yonse mu tchati iyenera kukhala ndi mizere yaying'ono, yoyera, yopingasa yomwe ikuyenda mwa iwo ndipo nthano iyenera kupita pamwamba pa tchati pansi pa mutu

Kusintha Colors Colors

1. Dinani kumbuyo kwa tchati kuti musankhe tchati chonse ngati kuli kofunikira
2. Dinani pazithunzi Zosintha Zomwe zili kumbali ya kumanzere kwa Tabu Yokonzera ya Riboni kuti mutsegule ndondomeko yosankha mitundu
3. Sungani khola lanu la mouse pamzere uliwonse wa mitundu kuti muwone dzina lachinsinsi
4. Dinani pa Mtundu Wachidindo 3 mundandanda - chisankho chachitatu mu gawo lokongola la mndandanda
5. Mitundu ya mndandanda wa mndandanda uliwonse iyenera kusinthidwa ku lalanje, wachikasu, ndi wobiriwira, koma mizere yoyera iyenera kukhalapo pamndandanda uliwonse

Kusintha Chakuda cha Tchati cha Tchati

Khwerero ili limasintha maziko a tchati kuti awononge imvi pogwiritsa ntchito Fomu Yodzaza Zomwe zili pa Tsambidwe la kavalo yomwe imapezeka mu chithunzi pamwambapa.

1. Dinani kumbuyo kuti mutsegule tchati chonse ndikuwonetsera matabu a Chitsulo pa teboni
2. Dinani pa tabu ya Fomu
3. Dinani pa Fomu Yodzazani njira kuti mutsegule Zojambula Zotsitsa pansi
4. Sankhani Grey -50%, Kalankhulidwe 3, Wamphamvu 40% kuchokera ku Gawo la Masewera a Mutu wa gululo kuti musinthe mtundu wa tsatanetsatane wamtunduwu kuti ukhale wofiira

05 ya 06

Kusintha Malemba a Tchati

Kusintha Maonekedwe a Mtundu

Tsopano kuti mbiriyo ndi imvi, mawu osasinthika wakuda sakuwonekera. Gawo lotsatirali likuthandizira mtundu wa malemba onse pa tchati kupita ku zobiriwira kuti apange kusiyana pakati pa awiriwo pogwiritsa ntchito Mawu Ozaza .

Njirayi ikupezeka pa tabu ya foni yomwe ikupezeka pa chithunzi patsamba lapitalo la phunzirolo.

1. Dinani kumbuyo kwa tchati kuti musankhe tchati chonse, ngati kuli kofunikira
2. Dinani pa Tsambidwe la Mtambo wa Riboni
3. Dinani palemba Lembani njira yoti mutsegule mndandanda wazithunzi
4. Sankhani Zobiriwira, Zowonjezereka 6, Mdima Wofiira 25% kuchokera ku gawo la Masewera a Mutu wa mndandanda
5. Malembo onse pamutu, mzere, ndi nthano ayenera kusinthika

Kusintha Mtundu wa Mtundu, Kukula, ndi Kulimbikitsidwa

Kusintha kukula ndi mtundu wa mndandanda womwe umagwiritsidwa ntchito pazithunzi zonsezi, sikungokhala kusintha pamwamba pa machitidwe osasinthika, koma zidzakhalanso zosavuta kuwerengera nthano ndi nkhanza mayina ndi zikhulupiliro mu chart. Kukonzekera kwa Bold kudzawonjezeredwa ku malemba kuti apangidwe bwino kwambiri motsutsana ndi chiyambi.

Kusintha kumeneku kudzapangidwa pogwiritsa ntchito njira zomwe zili muzithunzi zamtundu wa Tsamba la Home la Ribbon.

Zindikirani : Kukula kwa foni kumayikidwa pa mfundo - kawirikawiri kumachepetsedwa ku pt .
72 pt. malemba ndi ofanana ndi inchi - 2.5 cm - kukula.

Kusintha Tanthauzo la Tsati

1. Dinani kamodzi pa mutu wa tchati kuti muisankhe
2. Dinani pa tabu la Home la riboni
3. Mu gawo la foni la riboni, dinani pa Bokosi la Masamba kuti mutsegule tsambali la zilembo zomwe zilipo
4. Pemphani kuti mupeze ndikusintha pazenera Leelawadee mu mndandanda kuti musinthe mutu wazithunzithunzi izi
5. Mu Bokosi la Masamba pafupi ndi bokosi lazithunzi, yikani kukula kwazithunzi kwa 16 pt.
6. Dinani pa chizindikiro cha Bold (kalata B ) pansi pa bokosi la malemba kuti muwonjezere kufotokozera molimba mutu

Kusintha Nthano ndi Ndondomeko Text

1. Dinani kamodzi pa malemba a X axis (osakanikirana) mu tchati kuti musankhe mayina a cookie
2. Pogwiritsira ntchito ndondomeko zotchulidwa pamwambapa kuti musinthe mawu a mutu, yesani malemba awa okhwima pa 10 pt Leelawadee, molimba mtima
3. Dinani kamodzi pamakalata a Y axis (ofukula) mu tchati kuti musankhe ndalama zomwe zili kumanzere kwa tchati
4. Pogwiritsa ntchito ndondomeko zapamwambayi, yesani malemba awa pa 10 pt Leelawadee, molimba mtima
5. Dinani kamodzi pa nthano ya tchati kuti musankhe
6. Pogwiritsa ntchito ndondomeko zapamwambayi, lembani mutuwu kwa 10 pt Leelawadee, molimba mtima

Malembo onse mu tchati ayenera tsopano kukhala lemba la Leelawadee ndi mtundu wakuda wobiriwira. Pano, tchati yanu iyenera kufanana ndi chithunzi chomwe chili pamwambapa.

06 ya 06

Kuwonjezera Gridlines ndi Kusintha Mitundu Yake

Ngakhale kuti magalasi ozungulira omwe poyamba analipo ndi tchati chosasinthika chithunzi, sanali mbali ya kapangidwe kamene kanasankhidwa mu sitepe 3, ndipo, motero, achotsedwa.

Khwerero iyi idzawonjezera ma gridlinti mmalo mwa chiwembu cha tchati.

Popanda malemba a deta omwe amasonyeza mtengo weniweni wa ndondomeko iliyonse, ma gridali amachititsa kuti zikhale zosavuta kuwerenga mndandanda wamtengo wapatali kuchokera ku ndalama zomwe zalembedwa pamzere wa Y (wokhoma).

Mzere wajambulawo akuwonjezeredwa pogwiritsa ntchito njira yowonjezeredwa ndi Chati pa Tsambidwe Yokonzera wa Riboni.

1. Dinani kamodzi pa malo amodzi a tchati kuti musankhe
2. Dinani pa tabu Yopanga ya Riboni ngati kuli kofunikira
3. Dinani pa njira yowonjezera Chart Element kumbali yakumanzere ya riboni kuti mutsegule menyu otsika
4. Mu menyu otsika pansi, dinani pa Gridlines> Primary Priest Major kuti awonjezere kufooka, zoyera, magalasi ku malo a chiwonetsero cha tchati

Kupanga Kusintha kwa Mapangidwe Pogwiritsa Ntchito Pulogalamu Yokonza Mapulogalamu

Maphunziro otsatirawa akugwiritsa ntchito mapangidwe a ntchito pamanja , omwe ali ndi mitundu yambiri yopangira ma chart.

Mu Excel 2013, pamene atsegulidwa, mawonekedwewo akuwonekera kumanja kwa dzanja la Excel pulogalamu monga momwe tawonetsera pa chithunzi pamwambapa. Mutu ndi zosankha zomwe zikuwonekera pazithunzi zimasintha malinga ndi dera lomwe lasankhidwa.

Gawo loyamba lidzasintha mtundu wa magalasi omwe anangowonjezera pamwambapa kuchokera koyera kupita ku lalanje kuti awawoneke bwino kwambiri pa malo amtundu wa chigawo cha tsatanetsatane.

Kusintha Mtundu wa Gridlines '

1. Pa graph, dinani kamodzi pa $ 60,000 gridline ikuyenda pakati pa graph - zonse gridlines ayenera kuwonetsedwa (buluu ndi zoyera madontho kumapeto kwa gridline iliyonse)
2. Dinani pa tabu ya foni ya riboni ngati kuli kofunikira
3. Dinani pa Kusankhidwa kwa Mpangidwe wa Mpangidwe kumbali ya kumanzere kwa riboni kuti mutsegule Pulogalamu Yoyenera Kujambula - mutu womwe uli pamwamba pazenera uyenera kukhala Ma Format Gridlines
4. M'kati, onetsani mtundu wa mzere ku mzere wolimba
5. Ikani mtundu wa grid ku Orange, Accent 2, Darker 25%
6. Zonsezi zam'deralo m'deralo ziyenera kusinthidwa ku mdima wonyezimira

Kupanga fomu ya X Axis Line

Mzere wa X axis ulipo pamwamba pa zilembo za X zowonjezera (mayina a ma cookie), koma, monga ma gridlines, n'zovuta kuwona chifukwa cha imvi ya chithunzicho. Khwerero ili lidzasintha mtundu wa axis ndi makulidwe a mzere kuti zigwirizane ndi zomwe zajambulajambulazo.

1. Dinani pamakalata a X axis kuti muwonetse mzere wa X axis
2. Mu mapangidwe a ntchito pamanja, monga momwe asonyezedwera mu chithunzi pamwambapa, ikani mtundu wa mzere ku Mzere wolimba
3. Ikani mtundu wa mzere wa axisi ku Orange, Accent 2, Darker 25%
4. Ikani m'lifupi la mzere wa axisi kufika ku 0,75 pt.
5. Mzere wa X axis uyenera tsopano kufanana ndi galasili

Ngati mwatsatira zonsezi mu phunziroli, tchati chanu chachitsulo chiyenera kutsutsana ndi chitsanzo chomwe chili pamwamba pa tsamba lino.