Imwe yemabhenefiti akakosha emachati muExcel kugona kuenzanisa dhata dhata nerubatsiro rwavo. Asi usati wagadzira chati, zvakakosha kushandisa nguva shoma uchifunga nezve data ripi uye kuti ungariratidza sei kuitira kuti mufananidzo uve wakajeka sezvinobvira.
Ngatitarisei nzira dzeExcel dzinogona kuratidza akawanda data akatevedzana kugadzira yakajeka uye iri nyore kuverenga chati pasina kushandisa PivotCharts. Iyo yakatsanangurwa nzira inoshanda muExcel 2007-2013. Mifananidzo inobva kuExcel 2013 yeWindows 7.
Column uye mabhawa machati ane akawanda data akateedzana
Kuti ugadzire chati yakanaka, tanga watarisa kuti makoramu edata ane misoro uye kuti data rakarongwa nenzira yakanaka yekurinzwisisa. Ita shuwa kuti data rese rakayerwa uye hukuru hwakafanana, zvikasadaro zvinogona kuvhiringa, semuenzaniso, kana imwe column ine data rekutengesa mumadhora uye imwe column ine mamirioni emadhora.
Sarudza iyo data yaunoda kuratidza muchati. Mumuenzaniso uyu, tinoda kuenzanisa iyo yepamusoro 5 inoti nekutengesa. Pa tab Insert (Insert) sarudza rudzi rwechati yekuisa. Ichaita seizvi:
Sezvauri kuona, zvinotora zvishoma kurongedza dhayagiramu usati wariratidza kune vateereri:
- Wedzera mazita uye data series zvinyorwa. Dzvanya pachati kuti uvhure boka retibhu Kushanda nemachati (Chati Zvishandiso), wozogadzirisa musoro wechati nekudzvanya pane chinyorwa Musoro wechati (Chinyorwa cheChati). Kuti uchinje data series labels, tevera matanho aya:
- dzvanya Sarudza data (Sarudza Data) tab Constructor (Design) kuvhura dialog Kusarudza nzvimbo yedata (Sarudza Data Source).
- Sarudza data rakatevedzana raunoda kuchinja uye tinya bhatani chinja (Rodza) kuvhura dialog Row shanduko (Hora Series).
- Nyora chinyorwa chitsva che data mundima yemavara Zita remusara (Series zita) uye tinya OK.
- Chinjana mitsara nemakoramu. Dzimwe nguva chimiro chechati chakasiyana chinoda hurongwa hwakasiyana hweruzivo. Yedu yakajairwa bar chart inoita kuti zviome kuona kuti mhedzisiro yenyika yega yega yakachinja sei nekufamba kwenguva. Baya bhatani Row column (Chinja Row/Column) pane tab Constructor (Gadzira) uye wedzera iwo chaiwo mavara eiyo data nhevedzano.
Gadzira combo chati
Dzimwe nguva iwe unofanirwa kuenzanisa maviri akasiyana datasets, uye izvi zvinonyanya kuitwa uchishandisa akasiyana marudzi emachati. Iyo Excel combo chati inokutendera iwe kuti uratidze akasiyana data akatevedzana uye masitayipi mune imwechete chati. Semuyenzaniso, ngatitii tinoda kuenzanisa iyo Yegore Yese inopesana nekutengesa kwepamusoro 5 nyika kuti tione kuti ndedzipi nyika dziri kutevera maitiro ese.
Kuti ugadzire combo chati, sarudza iyo data yaunoda kuratidza pairi, wobva wadzvanya bhokisi rebhokisi rekutanga Kuisa chati (Chati Insert) mukona yeboka rekuraira Mifananidzo (Machati) tab Insert (Insert). Muchitsauko Madhayagiramu ese (All Charts) tinya Yakabatanidzwa (Combo).
Sarudza iyo yakakodzera chati yemhando yega yega data data kubva kune yekudonha-pasi zvinyorwa. Mumuenzaniso wedu, kune akatevedzana data Year Total takasarudza chati nenzvimbo (Nzvimbo) uye akaisanganisa nehistogram kuratidza kuti yakawanda sei nyika imwe neimwe kuhuwandu uye kuti maitiro avo anowirirana sei.
Mukuwedzera, chikamu Yakabatanidzwa (Combo) inogona kuvhurwa nekudzvanya bhatani Shandura rudzi rwechati (Shandura Chati Rudzi) tab Constructor (Design).
Tip: Kana imwe yedata yakatevedzana ine chiyero chakasiyana kubva kune yakasara uye iyo data inova yakaoma kusiyanisa, wobva watarisa bhokisi Sekondari ekisero (Secondary Axis) pamberi pemutsara usingakwane muchiyero chese.
