Mukati
Muchidimbu: Dzidza maitiro ekugadzira inopindirana bhachati (kana yekugovera chirongwa) kuitira kuti iratidze rumwe ruzivo kana iwe ukasarudza chaiyo koramu.
Difficulty level: average.
Interactive bar chart
Izvi ndizvo zvinoita histogram yapera inotaridzika:
Ratidza rumwe ruzivo kana imwe column yasarudzwa
Iyo histogram yekugovera yakanaka nekuti inokutendera iwe kuti unzwisise nekukurumidza kuti data iripo inoparadzirwa sei muhuwandu hwakawanda.
Mumuenzaniso wedu, isu tiri kutarisa kune yevashandi foni bhiri data kwemwedzi. Iyo bar chart inounganidza vashandi mumapoka zvichienderana nehukuru hweakaunti uyezve inoratidza nhamba yevashandi muboka rega rega. Chati iri pamusoro inoratidza kuti vashandi makumi manomwe nerimwe vaive nebhiri rerunhare pamwedzi riri pakati pe$71 ne$0.
Pamusoro pezvo, tinoona kuti vashandi gumi nemumwe vaive nechikwereti chenhare chaidarika mazana matanhatu emadhora pamwedzi. Blimey! Izvi ndizvo zvinoitika kana iwe uchipedza nguva yakawanda paFacebook! 🙂
Mubvunzo unomuka pakarepo:Ndivanaani ava vane mabills akakura kudai???»
Iyo PivotTable kurudyi yechati inoratidza mazita evashandi uye kukosha kwebhiri ravo remwedzi. Iyo sefa inogadzirwa uchishandisa slicer uye yakagadziriswa kuratidza chete avo vashandi vari veboka rakasarudzwa mune rondedzero.
Chati iyi inoshanda sei?
Chicheki chine miganhu yeboka chinoratidzwa pamusoro pemavara ehorizonti akisi yechati. Nekuda kweizvozvo, zvinoita sekunge ndiyo yakachinjika axis mavara, asi ingori chidimbu.
Iyo slicer yakabatana nePivotTable kurudyi uye inotanga kusefa pazita reboka. Dunhu Rows (Row) yeiyi pivot tafura ine mazita evashandi, nenzvimbo Zvinokosha (Values) - kukosha kweakaunti.
Data yekutanga
Iyo yekutanga data ine mutsara wakasiyana wemushandi wega wega ane ruzivo nezve mushandi uye saizi yeakaunti yake. Mune iyi fomu, iyo data inowanzo kupihwa nemakambani efoni.
Muchikamu G tafura ibasa VPR (VLOOKUP) inodzosa zita reboka. Iyi fomula inotarisa kukosha kubva muchikamu Bill Mari mutafura tblGroups uye inodzosa kukosha kubva pa column zita reboka.
Ziva kuti iyo yekupedzisira basa nharo VPR (VLOOKUP) yakaenzana TRUE (CHOKWADI). Iyi ndiyo nzira iyo basa richatarisa pa column Group Min uchitsvaga kukosha kubva muchikamu Bill Mari uye mira paukoshi hwepedyo husingapfuure ukoshi hunodiwa.
Pamusoro pezvo, unogona kugadzira mapoka otomatiki uchishandisa matafura epivot pasina kushandisa basa racho VPR (VLOOKUP). Zvisinei, ndinoda kushandisa VPR (VLOOKUP) nekuti ichi chinokupa kutonga kwakawanda pamazita emapoka. Iwe unogona kugadzirisa chimiro chezita reboka sezvaunoda uye kutonga miganhu yeboka rega rega.
Mumuenzaniso uyu, ndiri kushandisa matafura eExcel kuchengetedza kwainobva data uye netafura yekutarisa. Hazvina kuoma kuona kuti mafomula zvakare anoreva matafura. Mune iyi fomu, mafomula ari nyore kuverenga nekunyora. Hazvina kudikanwa kushandisa Excel spreadsheets kuita rudzi urwu rwebasa, izvi zvinongori zvangu zvandinoda.
Histogram uye PivotTable
Iyi nhamba inoratidza iyo PivotTable yakashandiswa kugadzira iyo bar chart. Dunhu Rows (Row) ine mazita eboka kubva mukoramu BOKA matafura ane source data, uye nzvimbo Zvinokosha (Values) ine hutsika kubva pamutsara Count of Name. Iye zvino tinogona kuratidza kugoverwa kwevashandi nenzira ye histogram.
Pivot tafura ine rumwe ruzivo
Iyo PivotTable, iri kurudyi rwechati, inoratidza rumwe ruzivo. Mune iyi pivot tafura:
- nharaunda Rows (Row) ine mazita evashandi.
- nharaunda Zvinokosha (Values) ine bhiri repamwedzi refoni.
- nharaunda Filters (Masefa) ane mazita emapoka.
Iyo group list slicer yakabatana nePivotTable kuitira kuti mazita eboka rakasarudzwa chete ndiwo aonekwe. Izvi zvinokubvumira kukurumidza kuratidza runyoro rwevashandi vanobatanidzwa muboka rimwe nerimwe.
Kuunganidza zvose kubva kune zvikamu
Iye zvino izvo zvikamu zvese zvagadzirwa, chasara kumisa mafomati echimwe nechimwe chinhu kuti chitaridzike chakanaka pane peji. Iwe unogona kugadzirisa iyo slicer maitiro kuti iite seyakatsvinda pamusoro pechati.
Chii chimwe chatingashandisa nzira iyi?
Mumuenzaniso uyu, ndakashandisa data pamabhiri efoni evashandi. Saizvozvo, chero mhando yedata inogona kugadziriswa. Histograms yakanaka nekuti inobvumidza iwe kukurumidza kuwana ruzivo nezve kugoverwa kwedata, asi kazhinji iwe unofanirwa kuwana ruzivo rwakadzama nezveboka rimwechete. Kana iwe ukawedzera mamwe minda patafura yepivot, unogona kuona mafambiro kana kuongorora inoguma data data zvakadzika.
Siya mhinduro dzako uye bvunza chero mibvunzo. Kuda kuziva mashandisiro aunoita kana kuronga kushandisa nzira yakaratidzwa?
Ndatenda!