Momwe mungapangire ma chart mu Excel kuchokera pamasamba awiri kapena kupitilira apo

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 Momwe mungapangire ma chart mu Excel kuchokera pamasamba awiri kapena kupitilira apo. Kumanja, pansi pomwe pamndandanda womwe ukuwonekera, dinani Sankhani deta. 

Pawindo lomwe likuwoneka Kusankha magwero data kutsatira ulalo Onjezerani.

Momwe mungapangire ma chart mu Excel kuchokera pamasamba awiri kapena kupitilira apo
Kuwonjezera gwero latsopano

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.  

Momwe mungapangire ma chart mu Excel kuchokera pamasamba awiri kapena kupitilira apo
Ndikofunika kwambiri kusankha mzere wolondola kuti tchaticho chikhale cholondola.

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. 

Momwe mungapangire ma chart mu Excel kuchokera pamasamba awiri kapena kupitilira apo
Umu ndi momwe kusankhidwa kwa deta yofunikira kuti mulowe mu tchati kumawonekera

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.

Momwe mungapangire ma chart mu Excel kuchokera pamasamba awiri kapena kupitilira apo
Kuyang'ana maulalo ku data yomwe ikuwonetsedwa patchati

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:

Momwe mungapangire ma chart mu Excel kuchokera pamasamba awiri kapena kupitilira apo
Ngati chinachake chikulakwika ndi inu, monga chithunzi pamwambapa, ndiye kuti munalakwitsa kwinakwake, ndipo muyenera kuyambanso

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:

Momwe mungapangire ma chart mu Excel kuchokera pamasamba awiri kapena kupitilira apo
Histogram yokonzeka m'magulu angapo

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:

Momwe mungapangire ma chart mu Excel kuchokera pamasamba awiri kapena kupitilira apo
Mutha kusiya zonse momwe zilili ndipo osawonjezera magawo ena

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:

Momwe mungapangire ma chart mu Excel kuchokera pamasamba awiri kapena kupitilira apo
Ndikosavuta kugwira ntchito ndi tebulo lomaliza

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.

Kusintha kudzera pa menyu Kusankha gwero la 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.

Momwe mungapangire ma chart mu Excel kuchokera pamasamba awiri kapena kupitilira apo
Hestogram Data Editing Window

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 Momwe mungapangire ma chart mu Excel kuchokera pamasamba awiri kapena kupitilira apo. 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.

Momwe mungapangire ma chart mu Excel kuchokera pamasamba awiri kapena kupitilira apo
Menyu yosinthira deta - ingochotsani mabokosi ndikusintha nthawi

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)

Momwe mungapangire ma chart mu Excel kuchokera pamasamba awiri kapena kupitilira apo
Deta iliyonse mu Excel imatenga mawonekedwe a fomula

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.

Siyani Mumakonda