Zamkatimu
Mukamapanga ma chart mu Excel, magwero ake sakhala papepala lomwelo. Mwamwayi, Microsoft Excel imapereka njira yokonzera deta kuchokera pamapepala awiri kapena angapo osiyana pa tchati chomwecho. Onani pansipa kuti mudziwe zambiri.
Momwe mungapangire tchati kuchokera pamapepala angapo mu Excel
Tiyerekeze kuti pali mapepala angapo okhala ndi ndalama zopezera ndalama kwa zaka zosiyanasiyana mufayilo imodzi yamasamba. Pogwiritsa ntchito deta iyi, muyenera kupanga tchati kuti muwone chithunzi chachikulu.
1. Timamanga tchati potengera deta ya pepala loyamba
Sankhani zomwe zili patsamba loyamba lomwe mukufuna kuwonetsa patchati. Komanso tsegulani zomanga Ikani. Pagulu Zithunzi Sankhani mtundu womwe mukufuna. Mu chitsanzo chathu, timagwiritsa ntchito Volumetric Stacked Histogram.
Ndilo tchati chopachikidwa chomwe ndi mtundu wotchuka kwambiri wa ma chart omwe amagwiritsidwa ntchito.
2. Timalowetsa deta kuchokera pa pepala lachiwiri
Onetsani chithunzi chopangidwa kuti mutsegule kagawo kakang'ono kumanzere Zida zama chart. Kenako, sankhani Constructor ndi kumadula chizindikirochi Sankhani deta.
Mukhozanso dinani batani Zosefera Ma chart . Kumanja, pansi pomwe pamndandanda womwe ukuwonekera, dinani Sankhani deta.
Pawindo lomwe likuwoneka Kusankha magwero data kutsatira ulalo Onjezerani.
Timawonjezera deta kuchokera pa pepala lachiwiri. Iyi ndi mfundo yofunika, choncho samalani.
Mukasindikiza batani Onjezani, dialog box imatuluka Kusintha kwa mizere. Pafupi ndi munda mtengo muyenera kusankha mtundu wa chizindikiro.
zenera Kusintha kwa mizere dzipiringani. Koma mukamasinthira kumasamba ena, imakhalabe pazenera, koma sizigwira ntchito. Muyenera kusankha pepala lachiwiri lomwe mukufuna kuwonjezera deta.
Pa pepala lachiwiri, m'pofunika kuwunikira deta yomwe yalowetsedwa mu tchati. Ku chiwindi Kusintha kwa mizere adamulowetsa, inu muyenera alemba pa izo kamodzi.
Kuti selo ili ndi malemba omwe akhale dzina la mzere watsopano, muyenera kusankha mtundu wa deta pafupi ndi chizindikiro. Dzina la mzere. Chepetsani mazenera osiyanasiyana kuti mupitirize kugwira ntchito mu tabu Kusintha kwa mizere.
Onetsetsani kuti maulalo ali m'mizere Dzina la mzere и Makhalidwe zowonetsedwa bwino. Dinani OK.
Monga mukuwonera pachithunzi chomwe chili pamwambapa, dzina la mzere limalumikizidwa ndi selo V1kumene kwalembedwa. M'malo mwake, mutuwo ukhoza kulowetsedwa ngati malemba. Mwachitsanzo, mzere wachiwiri wa data.
Mitu yotsatizanayo idzawonekera mu nthano yachati. Choncho, ndi bwino kuwapatsa mayina atanthauzo.
Munthawi iyi yopanga chithunzi, zenera logwira ntchito liyenera kuwoneka motere:
3. Onjezani zigawo zina ngati kuli kofunikira
Ngati mukufunikirabe kuyika deta mu tchati kuchokera pamapepala ena Excel, kenako bwerezani masitepe onse kuchokera mundime yachiwiri pama tabu onse. Kenako timasindikiza OK pawindo lomwe likuwoneka Kusankha gwero la data.
Mu chitsanzo pali 3 mizere deta. Pambuyo pa masitepe onse, histogram ikuwoneka motere:
4. Sinthani ndi kukonza histogram (ngati mukufuna)
Mukamagwira ntchito mumitundu ya Excel 2013 ndi 2016, mutu ndi nthano zimangowonjezeredwa pomwe tchati cha bar chapangidwa. Mu chitsanzo chathu, iwo sanawonjezedwe, kotero ife tidzazichita tokha.
Sankhani tchati. Mu menyu omwe akuwoneka Ma chart a zinthu kanikizani mtanda wobiriwira ndikusankha zinthu zonse zomwe ziyenera kuwonjezeredwa ku histogram:
Zokonda zina, monga mawonetsedwe a zilembo za data ndi mawonekedwe a nkhwangwa, zimafotokozedwa m'mabuku osiyana.
Timapanga ma chart kuchokera ku data yonse yomwe ili patebulo
Njira yopangira ma chart yomwe yawonetsedwa pamwambapa imagwira ntchito ngati zomwe zili pamasamba onse zili mumzere womwewo. Apo ayi, chithunzicho chidzakhala chosawerengeka.
Mu chitsanzo chathu, deta yonse ili m'matebulo omwewo pamasamba onse atatu. Ngati simukutsimikiza kuti mapangidwewo ndi ofanana mwa iwo, zingakhale bwino kuti muyambe kupanga tebulo lomaliza, kutengera zomwe zilipo. Izi zitha kuchitika pogwiritsa ntchito ntchitoyi VLOOKUP or Phatikizani Table Wizards.
Ngati mu chitsanzo chathu matebulo onse anali osiyana, ndiye kuti chilinganizo chikanakhala:
=VLOOKUP (A3, '2014'!$A$2:$B$5, 2, ZABODZA)
Izi zitha kukhala:
Pambuyo pake, ingosankhani chifukwa tebulo. Mu tabu Ikani kupeza Zithunzi ndikusankha mtundu womwe mukufuna.
Kusintha tchati chopangidwa kuchokera ku data pamapepala angapo
Zimachitikanso kuti mutatha kukonza graph, kusintha kwa data kumafunika. Pankhaniyi, n'zosavuta kusintha zomwe zilipo kusiyana ndi kupanga chithunzi chatsopano. Izi zimachitika kudzera menyu. Kugwira ntchito ndi ma chart, zomwe sizili zosiyana ndi ma graph opangidwa kuchokera ku deta ya tebulo limodzi. Kuika zinthu zazikulu za graph kukuwonetsedwa m'buku lina.
Pali njira zingapo zosinthira zomwe zikuwonetsedwa patchati pomwe:
- kudzera menyu Kusankha gwero la data;
- kudzera Zosefera
- Ine ndimakhala pakati Mafomu a mndandanda wa data.
Kuti mutsegule menyu Kusankha gwero la data, chofunika pa tabu Constructor dinani submenu Sankhani deta.
Kusintha mzere:
- sankhani mzere;
- dinani pa tabu Change;
- kusintha mtengo or dzina loyamba, monga tinachitira kale;
Kuti musinthe dongosolo la mizere yamtengo wapatali, muyenera kusankha mzere ndikuwusuntha pogwiritsa ntchito mivi yapadera yopita pamwamba kapena pansi.
Kuti muchotse mzere, muyenera kungosankha ndikudina batani Chotsani. Kuti mubise mzere, muyeneranso kusankha ndikuchotsa bokosi lomwe lili mu menyu zinthu za nthano, yomwe ili kumanzere kwa zenera.
Kusintha Series Kupyolera mu Chosefera Chati
Zokonda zonse zitha kutsegulidwa podina batani losefera . Imawonekera mukangodina tchati.
Kuti mubise deta, ingodinani fyuluta ndi kuchotsa chizindikiro mizere yomwe siyenera kukhala pa tchati.
Yendetsani cholozera pamzere ndipo batani limawonekera Sinthani mzere, dinani pamenepo. Zenera likutulukira Kusankha gwero la data. Timapanga zoikamo zofunika mmenemo.
Zindikirani! Mukayendetsa mbewa pamzere, imawonetsedwa kuti mumvetsetse bwino.
Kusintha mndandanda pogwiritsa ntchito fomula
Mipikisano yonse mu graph imatanthauzidwa ndi fomula. Mwachitsanzo, ngati tisankha mndandanda mu tchati chathu, ziwoneka motere:
=SERIES(‘2013′!$B$1,’2013′!$A$2:$A$5,’2013’!$B$2:$B$5,1)
Fomula iliyonse ili ndi zigawo zikuluzikulu zinayi:
=SERIES([Dzina la mndandanda], [x-values], [y-values], nambala ya mzere)
Fomu yathu mu chitsanzo ili ndi kufotokozera motere:
- Dzina la mndandanda ('2013'!$B$1) lotengedwa mu cell B1 pa pepala 2013.
- Mtengo wa mizere ('2013'!$A$2:$A$5) wotengedwa kumaselo A2:A5 pa pepala 2013.
- Mtengo wa magawo ('2013'!$B$2:$B$5) wotengedwa kumaselo B2:b5 pa pepala 2013.
- Nambala (1) imatanthauza kuti mzere wosankhidwa uli ndi malo oyamba pa tchati.
Kuti musinthe mndandanda wazinthu zinazake, sankhani mu tchati, pitani ku bar formula ndikusintha kofunikira. Zoonadi, muyenera kusamala kwambiri mukamakonza ndondomeko yotsatizana, chifukwa izi zikhoza kubweretsa zolakwika, makamaka ngati deta yoyambirira ili pa pepala lina ndipo simungathe kuziwona pokonza ndondomekoyi. Komabe, ngati ndinu wogwiritsa ntchito wapamwamba wa Excel, mungakonde njirayi, yomwe imakupatsani mwayi wosintha pang'ono ma chart anu.