Tchati cha bar cholumikizira chokhala ndi chidziwitso chowonjezera

Mwachidule: Phunzirani momwe mungapangire tchati cholumikizirana (kapena gawo logawa) kuti liwonetse zambiri mukasankha gawo linalake.

Mulingo Wovuta: pafupifupi.

Interactive bar chart

Izi ndi zomwe histogram yomalizidwa imawonekera:

Onetsani zina zowonjezera pamene gawo linalake lasankhidwa

Histogram yogawa ndi yabwino chifukwa imakulolani kuti mumvetsetse momwe deta yomwe ilipo imabalalitsidwa muunyinji wamba.

M'chitsanzo chathu, tikuyang'ana deta ya foni ya antchito kwa mwezi umodzi. Tchati cha bar chimasonkhanitsa antchito m'magulu malinga ndi kukula kwa akauntiyo ndikuwonetsa chiwerengero cha antchito pagulu lililonse. Tchati pamwambapa chikuwonetsa kuti antchito 71 anali ndi ngongole yapamwezi ya foni pakati pa $0 ndi $199.

Kuphatikiza apo, tikuwona kuti antchito a 11 anali ndi bilu ya foni yomwe idaposa $600 pamwezi. Blimey! Izi ndi zomwe zimachitika mukakhala nthawi yambiri pa Facebook! 🙂

Funso limabuka nthawi yomweyo:Ndindani anthu omwe ali ndi ma bill ochuluka chonchi???»

PivotTable yomwe ili kumanja kwa tchati ikuwonetsa mayina a antchito ndi mtengo wabilu yawo ya mweziwo. Fyulutayo imapangidwa pogwiritsa ntchito masila ndipo imakonzedwa kuti iwonetse antchito okhawo omwe ali m'gulu lomwe lasankhidwa pamndandanda.

Kodi tchatichi chimagwira ntchito bwanji?

Chodulira chokhala ndi malire amagulu chikuwonetsedwa pamwamba pa zilembo za tchati chopingasa. Zotsatira zake, zikuwoneka ngati ndi zilembo zopingasa zopingasa, koma ndi gawo chabe.

Tchati cha bar cholumikizira chokhala ndi chidziwitso chowonjezera

Wodulayo amalumikizidwa ndi PivotTable kumanja ndikuyamba kusefa pa dzina la gulu. Chigawo Mizere (Mizere) ya tebulo ili la pivot ili ndi mayina a antchito, ndi dera Makhalidwe (Makhalidwe) - mtengo wa akaunti.

Deta yoyamba

Deta yoyamba ili ndi mzere wosiyana wa wogwira ntchito aliyense ndi chidziwitso cha wogwira ntchitoyo ndi kukula kwa akaunti yake. Mu fomu iyi, deta nthawi zambiri imaperekedwa ndi makampani amafoni.

Tchati cha bar cholumikizira chokhala ndi chidziwitso chowonjezera

Mugawo G tebulo ndi ntchito VPR (VLOOKUP) yomwe imabweretsanso dzina la gulu. Fomula iyi imayang'ana mtengo kuchokera pamndandanda Mtengo wa Bill mu tebulo tblGroups ndi kubwezeretsa mtengo kuchokera pamndandanda dzina la gulu.

Onani kuti mkangano womaliza wa ntchito VPR (VLOOKUP) yofanana WOONA (ZOONA). Umu ndi momwe ntchitoyi idzayang'anire pamzati Gulu Min kuyang'ana mtengo kuchokera pagawo Mtengo wa Bill ndi kuyima pamtengo wapafupi womwe sudutsa mtengo womwe ukufunidwa.

Kuphatikiza apo, mutha kupanga magulu pogwiritsa ntchito matebulo a pivot popanda kugwiritsa ntchito ntchitoyi VPR (VLOOKUP). Komabe, ndimakonda kugwiritsa ntchito VPR (VLOOKUP) chifukwa mawonekedwewa amakupatsani mwayi wowongolera mayina amagulu. Mutha kusintha mtundu wa dzina la gulu momwe mukufunira ndikuwongolera malire a gulu lililonse.

Muchitsanzo ichi, ndikugwiritsa ntchito matebulo a Excel kusunga gwero ndi tebulo loyang'ana. Sizovuta kuwona kuti mafomuwa amatanthauzanso matebulo. Mu mawonekedwe awa, mafomuwa ndi osavuta kuwerenga ndi kulemba. Sikofunikira kugwiritsa ntchito maspredishiti a Excel kuti mugwire ntchito yamtunduwu, izi ndizomwe ndimakonda.

Histogram ndi PivotTable

Tchati cha bar cholumikizira chokhala ndi chidziwitso chowonjezera

Chithunzichi chikuwonetsa PivotTable yomwe imagwiritsidwa ntchito popanga tchati cha bar. Chigawo Mizere (Mizere) ili ndi mayina amagulu kuchokera pamndandanda GULANI matebulo okhala ndi deta yochokera, ndi dera Makhalidwe (Values) ili ndi zikhalidwe zochokera pamndandanda Chiwerengero cha Dzina. Tsopano tikhoza kusonyeza kugawa kwa antchito mu mawonekedwe a histogram.

Pivot table yokhala ndi zambiri zowonjezera

PivotTable, yomwe ili kumanja kwa tchati, ikuwonetsa zambiri. Mu tebulo ili la pivot:

  • Area Mizere (Mizere) ili ndi mayina a antchito.
  • Area Makhalidwe (Makhalidwe) ali ndi ngongole yapamwezi yamafoni.
  • Area Mafayilo (Zosefera) zili ndi mayina amagulu.

Odula mndandanda wamagulu amalumikizidwa ndi PivotTable kuti mayina okha agulu losankhidwa aziwonetsedwa. Izi zimakulolani kuti muwonetse mwamsanga mndandanda wa antchito omwe akuphatikizidwa mu gulu lirilonse.

Tchati cha bar cholumikizira chokhala ndi chidziwitso chowonjezera

Kusonkhanitsa zonse kuchokera ku zigawo

Tsopano popeza zigawo zonse zidapangidwa, chomwe chatsala ndikukhazikitsa masanjidwe a chinthu chilichonse kuti chiwoneke bwino patsamba. Mutha kusintha masitayelo a slicer kuti awoneke bwino pamwamba pa tchati.

Tchati cha bar cholumikizira chokhala ndi chidziwitso chowonjezera

Kodi njira imeneyi tingagwiritsire ntchito chiyani?

Mu chitsanzo ichi, ndinagwiritsa ntchito deta pamabilu a telefoni a antchito. Mofananamo, mtundu uliwonse wa deta ukhoza kukonzedwa. Ma histograms ndiabwino chifukwa amakulolani kuti mumve mwachangu za kugawa kwa data, koma nthawi zambiri muyenera kudziwa zambiri za gulu limodzi. Ngati muwonjeza magawo owonjezera pa tebulo la pivot, mutha kuwona zomwe zikuchitika kapena kusanthula zitsanzo za data mozama kwambiri.

Siyani ndemanga zanu ndikufunsani mafunso. Mukufuna kudziwa momwe mumagwiritsira ntchito kapena kukonzekera kugwiritsa ntchito njira yomwe yasonyezedwa?

Zikomo!

Siyani Mumakonda