Ubwino umodzi wofunikira wa ma chart mu Excel ndikutha kufananiza mndandanda wama data ndi thandizo lawo. Koma musanayambe kupanga tchati, ndi bwino kuthera nthawi yochepa kuganizira za deta ndi momwe mungasonyezere kuti chithunzicho chikhale chomveka bwino momwe mungathere.
Tiyeni tiwone njira zomwe Excel ingawonetsere ma data angapo kuti apange tchati chomveka bwino komanso chosavuta kuwerenga popanda kugwiritsa ntchito PivotCharts. Njira yofotokozedwayo imagwira ntchito mu Excel 2007-2013. Zithunzi zimachokera ku Excel 2013 za Windows 7.
Mzere ndi ma chart a bar okhala ndi ma data angapo
Kuti mupange tchati chabwino, choyamba fufuzani kuti mizati ya deta ili ndi mitu komanso kuti deta yakonzedwa m'njira yabwino kuti mumvetsetse. Onetsetsani kuti deta yonse ndi yofanana ndi kukula kwake, mwinamwake zingakhale zosokoneza, mwachitsanzo, ngati gawo limodzi liri ndi deta yogulitsa mu madola ndipo gawo lina liri ndi mamiliyoni a madola.
Sankhani deta yomwe mukufuna kuwonetsa patchati. Mu chitsanzo ichi, tikufuna kufananiza mayiko 5 apamwamba ndi malonda. Pa tabu Ikani (Ikani) sankhani mtundu wa tchati woti muyike. Idzawoneka motere:
Monga mukuwonera, zidzatengera kukonzetsa pang'ono chithunzicho musanachiwonetse kwa omvera:
- Onjezani mitu ndi zolemba zotsatizana za data. Dinani pa tchati kuti mutsegule gulu la tabu Kugwira ntchito ndi ma chart (Zida za Tchati), kenako sinthani mutu wa tchati podina mawuwo Mutu wa tchati (Mutu wa Tchati). Kuti musinthe zilembo zama data, tsatirani izi:
- atolankhani Sankhani deta (Sankhani Data) tabu Constructor (Design) kuti mutsegule zokambirana Kusankha gwero la data (Sankhani Gwero la Data).
- Sankhani mndandanda wa data womwe mukufuna kusintha ndikudina batani Change (Sinthani) kuti mutsegule zokambirana Kusintha kwa mizere (Sinthani Series).
- Lembani chizindikiro chatsopano cha data mu gawo lazolemba Dzina la mzere (Dzina la mndandanda) ndikusindikiza OK.
- Sinthanitsani mizere ndi mizati. Nthawi zina tchati chosiyana chimafuna makonzedwe osiyana a chidziwitso. Tchati chathu chokhazikika cha bar chimapangitsa kuti zikhale zovuta kuwona momwe zotsatira za dziko lililonse zasinthira pakapita nthawi. Dinani batani Mzere wa mzere (Sinthani Row/Colum) pa tabu Constructor (Kupanga) ndikuwonjezera zolemba zolondola za mndandanda wazinthu.
Pangani tchati cha combo
Nthawi zina mumayenera kufananiza ma dataset awiri osiyana, ndipo izi zimachitika bwino pogwiritsa ntchito ma chart osiyanasiyana. Tchati cha combo cha Excel chimakupatsani mwayi wowonetsa mndandanda wamitundu yosiyanasiyana ndi masitaelo mu tchati chimodzi. Mwachitsanzo, tiyerekeze kuti tikufuna kufananitsa Chiwerengero cha Pachaka motsutsana ndi malonda a mayiko 5 apamwamba kuti tiwone kuti ndi mayiko ati omwe akutsatira zomwe zikuchitika.
Kuti mupange tchati cha combo, sankhani zomwe mukufuna kuwonetsa, kenako dinani choyambitsa bokosi Kuyika tchati (Ikani Tchati) mu ngodya ya gulu lolamula Zithunzi (Ma chart) tabu Ikani (Ikani). Mu mutu Zithunzi zonse (Machati Onse) dinani Kuphatikiza (Kombe).
Sankhani mtundu woyenera wa tchati pagulu lililonse la data kuchokera pamndandanda wotsikira pansi. Mu chitsanzo chathu, pa mndandanda wa deta Chaka Chokwanira tinasankha tchati ndi madera (Dera) ndikuliphatikiza ndi histogram kuti awonetse kuchuluka kwa momwe boma lililonse limathandizira pazokwanira komanso momwe machitidwe awo amayendera.
Komanso, gawo Kuphatikiza (Combo) ikhoza kutsegulidwa mwa kukanikiza batani Sinthani mtundu wa tchati (Sintha Mtundu wa Tchati) tabu Constructor (Kupanga).
Tip: Ngati chimodzi mwazinthu zamtundu wa data chili ndi sikelo yosiyana ndi ena onse ndipo deta imakhala yovuta kusiyanitsa, ndiye yang'anani bokosilo Sekondale axle (Secondary Axis) kutsogolo kwa mzere womwe sukugwirizana ndi sikelo yonse.
