Okuqukethwe
Lapho udala amashadi ku-Excel, idatha yomthombo yayo ayihlali iseshidini elifanayo. Ngenhlanhla, i-Microsoft Excel inikeza indlela yokuhlela idatha kusuka kumakhasi okusebenzela amabili noma ngaphezulu ahlukene eshadini elifanayo. Bheka ngezansi ukuze uthole imiyalelo enemininingwane.
Indlela yokudala ishadi kusuka kudatha kumashidi amaningi ku-Excel
Ake sicabange ukuthi kukhona amashidi amaningana anedatha yemali engenayo iminyaka ehlukene efayeleni elilodwa lesipredishithi. Usebenzisa le datha, udinga ukwakha ishadi ukuze ubone ngeso lengqondo isithombe esikhulu.
1. Sakha ishadi ngokusekelwe kudatha yeshidi lokuqala
Khetha idatha eshidini lokuqala ofuna ukulibonisa eshadini. Ngokuqhubekayo avule amatshe Faka. Eqenjini Imidwebo Khetha uhlobo lweshadi olufunayo. Esibonelweni sethu, sisebenzisa I-Volumetric Stacked Histogram.
Ishadi lebha estakiwe eliwuhlobo lwamashadi oludume kakhulu olusetshenziswayo.
2. Sifaka idatha kusuka eshidini lesibili
Gqamisa idayagramu edaliwe ukuze uvule iphaneli encane kwesokunxele Amathuluzi eshadi. Okulandelayo, khetha umakhi bese uchofoza isithonjana Khetha idatha.
Ungakwazi futhi ukuchofoza inkinobho Izihlungi Zeshadi . Kwesokudla, phansi kakhulu ohlwini oluvelayo, chofoza Khetha idatha.
Efasiteleni elivelayo Ukukhethwa komthombo idatha landela isixhumanisi Engeza.
Sengeza idatha evela eshidini lesibili. Leli yiphuzu elibalulekile, ngakho qaphela.
Uma ucindezela inkinobho Faka, ibhokisi lengxoxo liyavela Ukushintsha umugqa. Eduze nenkundla Value udinga ukukhetha isithonjana sobubanzi.
window Ukushintsha umugqa zisonga. Kodwa uma ushintshela kwamanye amashidi, azohlala esikrinini, kodwa ngeke asebenze. Udinga ukukhetha ishidi lesibili ofuna ukwengeza kulo idatha.
Eshidini lesibili, kuyadingeka ukugqamisa idatha efakwe eshadini. Kuwindi Izinguquko zerowu icushiwe, udinga nje ukuchofoza kuyo kanye.
Ukuze uthole iseli elinombhalo okuzoba igama lomugqa omusha, udinga ukukhetha ububanzi bedatha eduze kwesithonjana. Igama lomugqa. Nciphisa iwindi lobubanzi ukuze uqhubeke nokusebenza kuthebhu Izinguquko zerowu.
Qiniseka ukuthi izixhumanisi emigqeni Igama lomugqa и Amanani kukhonjiswe kahle. Chofoza OK.
Njengoba ubona esithombeni esinamathiselwe ngenhla, igama lomugqa lihlotshaniswa neseli V1lapho okulotshwe khona. Kunalokho, isihloko singafakwa njengombhalo. Isibonelo, umugqa wesibili wedatha.
Izihloko zochungechunge zizovela kunganekwane yeshadi. Ngakho-ke, kungcono ukubanika amagama anencazelo.
Kulesi sigaba sokudala umdwebo, iwindi elisebenzayo kufanele libukeke kanje:
3. Engeza izendlalelo ezengeziwe uma kunesidingo
Uma usadinga ukufaka idatha eshadini esuka kwamanye amashidi Excel, bese uphinda zonke izinyathelo ezivela endimeni yesibili kuwo wonke amathebhu. Bese sicindezela OK efasiteleni elivelayo Ukukhetha umthombo wedatha.
Esibonelweni kunemigqa emi-3 yedatha. Ngemuva kwazo zonke izinyathelo, i-histogram ibonakala kanje:
4. Lungisa futhi uthuthukise i-histogram (uyazikhethela)
Lapho usebenza kuzinguqulo ze-Excel 2013 kanye no-2016, isihloko kanye nenganekwane kwengezwa ngokuzenzakalelayo lapho kwakhiwa ishadi lebha. Esibonelweni sethu, awazange afakwe, ngakho-ke sizokwenza ngokwethu.
Khetha ishadi. Kumenyu evelayo Izakhi zeshadi cindezela isiphambano esiluhlaza bese ukhetha zonke izakhi ezidinga ukungezwa ku-histogram:
Ezinye izilungiselelo, ezifana nokuvezwa kwamalebula edatha kanye nefomethi yezimbazo, kuchazwa ekushicilelweni okuhlukile.
Senza amashadi ngenani ledatha esethebulani
Indlela yokushadi eboniswe ngenhla isebenza kuphela uma idatha kuwo wonke amathebhu amadokhumenti ikumugqa noma ikholomu efanayo. Uma kungenjalo, umdwebo ngeke ufundeke.
Esibonelweni sethu, yonke idatha itholakala kumathebula afanayo kuwo wonke amashidi angu-3. Uma ungaqiniseki ukuthi isakhiwo siyafana kuzo, kungaba ngcono ukuthi uqale uhlanganise ithebula lokugcina, ngokusekelwe kulawo atholakalayo. Lokhu kungenziwa ngokusebenzisa umsebenzi I-VLOOKUP or Hlanganisa ama-Table Wizards.
Uma esibonelweni sethu wonke amathebula abehlukene, ifomula izoba:
=I-VLOOKUP (A3, '2014'!$A$2:$B$5, 2, FALSE)
Lokhu kuzophumela kokuthi:
Ngemva kwalokho, vele ukhethe ithebula eliwumphumela. Kuthebhu Faka thola Imidwebo bese ukhetha uhlobo olufunayo.
Ukuhlela ishadi elidalwe kusuka kudatha emakhasini amaningi
Kuyenzeka futhi ukuthi ngemva kokuhlela igrafu, izinguquko zedatha ziyadingeka. Kulesi simo, kulula ukuhlela okhona kunokudala umdwebo omusha. Lokhu kwenziwa ngemenyu. Ukusebenza namashadi, okungehlukile kumagrafu akhiwe kusukela kudatha yethebula elilodwa. Ukusetha izici eziyinhloko zegrafu kuboniswa ekushicilelweni okuhlukile.
Kunezindlela ezimbalwa zokushintsha idatha eboniswa eshadini ngokwalo:
- ngokusebenzisa imenyu Ukukhetha umthombo wedatha;
- nge Izihlungi
- Ngiyalamula Amafomula ochungechunge lwedatha.
Ukuvula imenyu Ukukhetha umthombo wedatha, edingekayo kuthebhu umakhi cindezela imenyu engezansi Khetha idatha.
Ukuze uhlele umugqa:
- khetha umugqa;
- chofoza kuthebhu Guqula;
- ushintsho Value or Igama, njengoba senza ngaphambili;
Ukuze ushintshe ukuhleleka kwemigqa yamanani, udinga ukukhetha umugqa bese uwuhambisa usebenzisa imicibisholo ekhethekile eya phezulu noma phansi.
Ukuze ususe umugqa, udinga nje ukuwukhetha bese uchofoza inkinobho Susa. Ukuze ufihle umugqa, udinga ukuwukhetha futhi ususe ukumaka ibhokisi kumenyu izakhi ze-legend, elingakwesobunxele sefasitela.
Ukulungisa Uchungechunge Ngesihlungi Seshadi
Zonke izilungiselelo zingavulwa ngokuchofoza inkinobho yokuhlunga . Ivela ngokushesha uma uchofoza ishadi.
Ukuze ufihle idatha, vele uchofoze Hlunga futhi ususe ukumaka imigqa okungafanele ibe eshadini.
Hambisa isikhombisi phezu komugqa bese kuvela inkinobho Shintsha irowu, chofoza kukho. Kuvela iwindi Ukukhetha umthombo wedatha. Senza izilungiselelo ezidingekayo kuyo.
Qaphela! Uma uhambisa igundane phezu komugqa, liyagqanyiswa ukuze kuqondwe kangcono.
Ukuhlela uchungechunge usebenzisa ifomula
Lonke uchungechunge kugrafu luchazwa ngefomula. Isibonelo, uma sikhetha uchungechunge eshadini lethu, lizobukeka kanje:
=SERIES(‘2013′!$B$1,’2013′!$A$2:$A$5,’2013’!$B$2:$B$5,1)
Noma iyiphi ifomula inezingxenye ezi-4 eziyinhloko:
=UCHUNGECHUNGE([Igama lochungechunge], [amanani angu-x], [amanani angu-y], inombolo yomugqa)
Ifomula yethu esibonelweni inencazelo elandelayo:
- Igama lochungechunge ('2013'!$B$1) lithathwe kuseli B1 eshidini 2013.
- Inani lemigqa ('2013'!$A$2:$A$5) lithathwe kumaseli A2:A5 eshidini 2013.
- Inani lamakholomu ('2013'!$B$2:$B$5) elithathwe kumaseli B2:B5 eshidini 2013.
- Inombolo (1) isho ukuthi umugqa okhethiwe unendawo yokuqala eshadini.
Ukuze ushintshe uchungechunge lwedatha oluthile, lukhethe eshadini, hamba kubha yefomula futhi wenze izinguquko ezidingekayo. Yebo, kufanele uqaphele kakhulu lapho uhlela ifomula yochungechunge, ngoba lokhu kungaholela emaphutheni, ikakhulukazi uma idatha yoqobo iseshidini elihlukile futhi awukwazi ukuyibona lapho uhlela ifomula. Noma kunjalo, uma ungumsebenzisi we-Excel othuthukile, ungase uthande le ndlela, ekuvumela ukuthi wenze izinguquko ezincane ngokushesha kumashadi akho.