Momwe mungasinthire ma chart mu Excel

Nkhaniyi ikukamba za momwe mungazungulire tchati mu Excel 2010-2013. Muphunzira njira zosiyanasiyana zosinthira mipiringidzo, mipiringidzo, pie ndi ma chart a mizere, kuphatikiza mitundu yawo ya 3D. Mudzawonanso momwe mungasinthire dongosolo la zomanga, magulu, mndandanda, ndi nthano. Kwa iwo omwe nthawi zambiri amasindikiza ma graph ndi ma chart, phunzirani momwe mungakhazikitsire mawonekedwe a pepala kuti asindikizidwe.

Excel imapangitsa kukhala kosavuta kuwonetsa tebulo ngati tchati kapena graph. Kuti muchite izi, ingosankhani deta ndikudina chizindikiro cha mtundu woyenera wa tchati. Komabe, zosintha zosasinthika sizingakhale zoyenera. Ngati mukufuna kutembenuza tchati mu Excel kuti mukonze magawo a chitumbuwa, mizati, kapena mizere mosiyana, ndiye kuti nkhaniyi ndi yanu.

• Sinthani tchati cha chitumbuwa mu Excel ku ngodya yomwe mukufuna
• Sinthanitsani ma Grafu a 3D mu Excel: Rotate Pie, Bar and Bar Charts
• Sinthani Tchati 180°: Konzaninso Magawo, Makhalidwe, ndi Mndandanda wa data
  
  • Kusintha Madongosolo Omanga Magawo mu Tchati cha Excel
  • Kusintha Dongosolo la Makhalidwe Omanga
  • Kubwezeretsanso dongosolo lachiwembu chazotsatira pa tchati cha 3D
  • Sinthani malo a nthano pa tchati
• Kusintha mawonekedwe a pepala kuti agwirizane bwino ndi tchati
• Kugwiritsa ntchito Chida cha Kamera Kutembenuza Tchati cha Excel kupita ku Ngongole Yopanda pake

Sinthani tchati cha chitumbuwa mu Excel ku ngodya yomwe mukufuna

Ngati nthawi zambiri mumayenera kuwonetsa kukula kwake molingana, ndiye kuti ndi bwino kugwiritsa ntchito ma chart a pie. Pachithunzi chomwe chili m'munsimu, zolemba za deta zikuphatikizana ndi mitu, kotero kuti tchaticho chikuwoneka chodetsa. Ndikufuna kukopera tchatichi mu chiwonetsero cha PowerPoint chokhudza miyambo yophikira ya anthu, ndipo ndikufunika tchaticho kuti chikhale chaudongo. Kuti ntchitoyi ichitike ndikuwunikira gawo lofunikira kwambiri, muyenera kudziwa momwe mungazungulire tchati cha pie mu Excel molunjika.

1. Dinani kumanja pagawo lililonse la tchati chanu cha pie komanso kuchokera pamenyu yomwe ikuwoneka, sankhani Mawonekedwe a mndandanda wa data (Format Data Series).
2. Gulu la dzina lomwelo lidzawonekera. M'munda Kuzungulira kozungulira kwa gawo loyamba (Ngongole ya kagawo woyamba), m'malo mwa ziro, lowetsani mtengo wa ngodya yozungulira mu madigiri ndikusindikiza Lowani. Ndikuganiza kuti kusinthasintha kwa madigiri 190 kudzandichitira tchati changa cha chitumbuwa.

Pambuyo pozungulira, tchati cha pie mu Excel chikuwoneka bwino kwambiri:

Chifukwa chake, sikovuta kutembenuza tchati cha Excel kumangono aliwonse kuti chiwonekere chomwe mukufuna. Njirayi ndi yothandiza pokonza bwino malo omwe ali ndi zilembo za data komanso kuwonetsa magawo ofunika kwambiri.

Sinthanitsani ma Grafu a 3D mu Excel: Rotate Pie, Bar and Bar Charts

Ndikuganiza kuti ma chart a 3D amawoneka abwino kwambiri. Anthu ena akawona chithunzi cha XNUMXD, amatsimikiza kuti wopangayo amadziwa zonse za njira zowonera mu Excel. Ngati graph yopangidwa ndi zosintha zokhazikika sizikuwoneka momwe mungafune, mutha kuyisintha pozungulira ndikusintha mawonekedwe.

1. Dinani kumanja pa tchati ndikusankha kuchokera pa menyu omwe akuwoneka. Kuzungulira kwa XNUMXD (Kuzungulira kwa 3D).
2. Gulu lidzawoneka Mtundu wa Ma chart (Dera la Tchati la Format). M'minda Kuzungulira mozungulira X axis (X Rotation) ndi Kuzungulira mozungulira Y axis (Y Rotation) Lowetsani chiwerengero chomwe mukufuna kuti muzungulire.Ndidakhazikitsa 40 ° ndi 35 ° motsatana kuti ndipatse chiwembu changa mozama.

Mukhozanso kukhazikitsa zosankha mu gulu ili. kuzama (Kuzama), msinkhu (Kutalika) ndi Maganizo (Mawonedwe). Yesani kuti mupeze zokonda zabwino za tchati chanu. Momwemonso, mutha kukhazikitsa tchati cha pie.

Sinthani Tchati 180 °: Konzaninso Magawo, Makhalidwe, kapena Mndandanda wa data

Ngati tchati chomwe mukufuna kutembenuza mu Excel chikuwonetsa nkhwangwa zopingasa komanso zoyima, mutha kusintha mosavuta madongosolo amagulu kapena makonda omwe adakonzedwa motsatira nkhwangwazo. Kuphatikiza apo, mu ziwembu za 3D zomwe zili ndi axis yakuzama, mutha kusintha momwe mndandanda wa data umapangidwira kuti mipiringidzo yayikulu ya 3D isaphatikize ang'onoang'ono. Mu Excel, mutha kusinthanso malo a nthano pa tchati cha pie kapena tchati cha bar.

Sinthani dongosolo lamagulu omanga pazithunzi

Tchaticho chikhoza kuzunguliridwa mozungulira mopingasa (gulu axis).

1. Dinani kumanja pa axis yopingasa ndi kuchokera ku menyu omwe akuwoneka sankhani Mtundu wa Axis (Fomati axis).
2. Gulu la dzina lomwelo lidzawonekera. Kuti musinthe tchati 180 °, ingoyang'anani bokosilo Sinthani dongosolo la magulu (Magulu mu dongosolo la reverse).

Sinthani dongosolo lachiwembu pa tchati

Potsatira njira zosavuta izi, mutha kutembenuza tchati mozungulira molunjika.

1. Dinani kumanja pa axis ofukula (mtengo axis) ndikusankha Mtundu wa Axis (Fomati axis).
2. Chongani bokosi Sinthani dongosolo la zinthu (Makhalidwe mosinthana).

Zindikirani: Kumbukirani kuti sikutheka kusintha dongosolo lomwe zikhalidwe zimapangidwira mu tchati cha radar.

Kubwezeretsanso dongosolo lachiwembu chazotsatira mu tchati cha 3D

Ngati tchati chanu cha bar kapena bar chili ndi axis yachitatu, yokhala ndi mipiringidzo ina kutsogolo ndi ina kumbuyo, mutha kusintha dongosolo lomwe mndandanda wa data umapangidwira kuti zinthu zazikulu za 3D zisagwirizane ndi zing'onozing'ono. Pogwiritsa ntchito masitepe otsatirawa, magawo awiri kapena angapo amatha kukonzedwa kuti awonetse mndandanda wonse wa nthano.

1. Dinani kumanja pamzere wamtengo wapatali (Z-axis) mu tchati ndi menyu yomwe ikuwonekera, dinani. Mtundu wa Axis (Fomati axis).
2. Chongani bokosi Sinthani dongosolo la zinthu (Mindandanda mobwerera m'mbuyo) kusonyeza mizati motsatana mobweza.

Sinthani malo a nthano pa tchati

Pa tchati cha chitumbuwa cha Excel pansipa, nthanoyo ili pansi. Ndikufuna kusuntha nthano kumanja kwa tchati kuti ikope chidwi bwino.

1. Dinani kumanja pa nthanoyo ndi menyu yomwe ikuwoneka, dinani Mtundu wa Legend (Nthano ya Format).
2. Mu gawo Zosankha za nthano (Zosankha za Nthano) sankhani imodzi mwamabokosi ochonga: Kuchokera kumwamba (Pamwamba), pansi (Pansi), Kumanzere (Kumanzere), Kumanja (Kumanja) kapena Top pomwe (Pamwamba kumanja).

Tsopano ndimakonda chithunzi changa kwambiri.

Kusintha mawonekedwe a pepala kuti agwirizane bwino ndi tchati

Ngati mukungofunika kusindikiza tchati, ingosinthani mawonekedwe a pepala mu Excel osatembenuza tchaticho. Chithunzi chili m'munsichi chikuwonetsa kuti tchati sichikukwanira pa tsamba. Mwachikhazikitso, mapepala ogwirira ntchito amasindikizidwa motsatira chithunzi (chapamwamba kuposa chotambasula). Kuti chithunzi changa chiwoneke bwino chikasindikizidwa, ndisintha mawonekedwe atsamba kuchoka ku chithunzi kupita ku mawonekedwe.

1. Sankhani pepala lokhala ndi tchati kuti musindikize.
2. Dinani Kapangidwe katsamba (Mapangidwe a Tsamba), dinani muvi womwe uli pansi pa batani Mafotokozedwe (Kuwongolera) ndikusankha njira malo (Mawonekedwe).

Tsopano pawindo lowonetseratu, ndikutha kuona kuti tchaticho chikugwirizana bwino ndi malo osindikizika.

Kugwiritsa ntchito Chida cha Kamera Kutembenuza Tchati cha Excel kupita ku Ngongole Yopanda pake

Mu Excel, mutha kutembenuza tchati ku ngodya iliyonse pogwiritsa ntchito chida kamera. Zotsatira za ntchito Makamera ikhoza kuikidwa pafupi ndi graph yoyambirira kapena papepala latsopano.

Tip: Ngati mukufuna kutembenuza tchati ndi 90 °, nthawi zina ndikwanira kungosintha mtundu wa tchati. Mwachitsanzo, kuchokera ku bar chart kupita ku bar chart.

Kuwonjezera chida kamera pa Quick Access Toolbar, gwiritsani ntchito yaing'ono pansi muvi kumanja kwa gululo. Mu menyu omwe akuwoneka, dinani Magulu ena (Malamulo Ambiri).

Sankhani kamera (Kamera) pamndandanda Magulu onse (Malamulo onse) ndikudina kuwonjezera (Onjezani).

Tsopano kugwiritsa ntchito chida kamera, tsatirani njira zotsatirazi.

Zindikirani: Chonde kumbukirani kuti sizingatheke kugwiritsa ntchito chida kamera molunjika ku tchati, chifukwa zotsatira zake zingakhale zosayembekezereka.

1. Pangani graph kapena tchati china chilichonse.
2. Zingakhale zofunikira kutembenuza malo a zilembo za ma ax a tchati ndi 270 ° pogwiritsa ntchito menyu. Mtundu wa Axis (Format Axis), yomwe yafotokozedwa pamwambapa. Izi ndizofunikira kuti zolembazo ziwerengedwe pambuyo pozungulira tchati.
3. Sankhani magulu osiyanasiyana omwe tchati ili pamwambapa.
4. Dinani pachizindikiro kamera (Kamera) pa Quick Access Toolbar.
5. Dinani pa selo iliyonse ya pepala kuti mupange chinthu cha kamera.
6. Tsopano dinani ndikugwira chogwirizira chozungulira pamwamba pa chojambulacho.
7. Sinthani tchati ku ngodya yomwe mukufuna ndikumasula chogwirizira.

Zindikirani: Mu chida kamera pali drawback imodzi. Zotsatira zake zitha kukhala zocheperako kuposa tchati choyambirira, ndipo zitha kuwoneka ngati zolimba kapena zopindika.

Charting ndi njira yabwino yowonetsera deta. Ma graph mu Excel ndi osavuta kugwiritsa ntchito, ofotokozera, owoneka, ndipo mapangidwe ake amatha kusinthidwa kuti agwirizane ndi zosowa zilizonse. Tsopano mukudziwa momwe mungasinthire histograms, mizere ndi ma chart a pie.

Nditalemba zonsezi, ndikumva ngati guru weniweni pantchito yozungulira ma chart. Ndikukhulupirira kuti nkhani yanga ikuthandizani kuthana ndi ntchito yanu. Khalani okondwa ndikusintha chidziwitso chanu cha Excel!