Zamkatimu
Mu phunziro lomaliza, tidadziwa mitundu ya ma chart mu Excel, tidasanthula zinthu zawo zazikulu, komanso kupanga histogram yosavuta. Mu phunziro ili, tipitiriza kudziwana ndi zithunzi, koma pamlingo wapamwamba kwambiri. Tiphunzira kupanga ma chart mu Excel, kuwasuntha pakati pamasamba, kufufuta ndi kuwonjezera zinthu, ndi zina zambiri.
Kupanga ma chart ndi kalembedwe
Mukayika tchati mu tsamba la Excel, nthawi zambiri pamafunika kusintha zina zomwe mungasankhe. Kapangidwe ndi kalembedwe zitha kusinthidwa pa tabu Constructor. Nazi zina mwazochita zomwe zilipo:
- Excel imakupatsani mwayi wowonjezera zinthu monga mitu, nthano, zolemba zama data, ndi zina zambiri pa tchati chanu. Zowonjezera zimathandizira kuzindikira ndikuwonjezera zomwe zili mu chidziwitso. Kuti muwonjezere chinthu, dinani pa lamulo Onjezani Chart Element tsamba Constructor, ndiyeno sankhani yomwe mukufuna pa menyu yotsitsa.
- Kuti musinthe chinthu, monga mutu, dinani kawiri ndikusintha.
- Ngati simukufuna kuwonjezera zinthu payekhapayekha, mutha kugwiritsa ntchito imodzi mwamasanjidwe okonzedweratu. Kuti muchite izi, dinani pa lamulo Express layout, ndiyeno sankhani masanjidwe omwe mukufuna kuchokera pa menyu yotsitsa.
- Excel ili ndi masitaelo ambiri omwe amakulolani kuti musinthe mawonekedwe a tchati chanu mwachangu. Kuti mugwiritse ntchito kalembedwe, sankhani mu gulu lolamula Masitayilo a ma chart.
Mukhozanso kugwiritsa ntchito mabatani afupikitsa a masanjidwe kuti muwonjezere zinthu patchati, kusintha masitayelo, kapena kusefa data.
Zosankha Zina za Tchati
Pali njira zina zambiri zosinthira ndikusintha ma chart. Mwachitsanzo, Excel imakulolani kutanthauziranso deta yoyambirira, kusintha mtundu, komanso kusuntha tchati ku pepala lina.
Kusintha mizere ndi mizati
Nthawi zina muyenera kusintha momwe deta imasankhidwira mu tchati cha Excel. Muchitsanzo chotsatirachi, chidziwitsocho chimagawidwa ndi chaka ndipo mndandanda wa deta ndi mitundu. Komabe, tikhoza kusintha mizere ndi mizati kuti deta ikhale m'magulu amtundu. Pazochitika zonsezi, tchaticho chimakhala ndi chidziwitso chofanana koma chimakonzedwa mosiyana.
- Sankhani tchati chomwe mukufuna kusintha.
- Pa Advanced tabu Constructor press command Mzere wa mzere.
- Mizere ndi mizati idzalowa m'malo. Mu chitsanzo chathu, deta tsopano yagawidwa ndi mtundu ndipo mndandanda wa deta wakhala zaka.
Sinthani mtundu wa tchati mu Excel
Ngati muwona kuti tchati chamakono sichikugwirizana ndi zomwe zilipo, mukhoza kusintha mosavuta mtundu wina. Mu chitsanzo chotsatira, tidzasintha mtundu wa tchati kuchokera Mbiri on Ndondomeko.
- Pa Advanced tabu Constructor dinani lamulo Sinthani mtundu wa tchati.
- Mu bokosi la zokambirana lomwe likuwoneka Sinthani mtundu wa tchati sankhani mtundu watsopano wa tchati ndi masanjidwe, kenako dinani OK. Mu chitsanzo chathu, tidzasankha Ndondomeko.
- Mtundu wosankhidwa wa tchati umawonekera. Mu chitsanzo chamakono, inu mukhoza kuwona izo Ndondomeko limafotokoza momveka bwino kusintha kwa malonda panthawi yomwe ilipo.
Sinthani tchati mu Excel
Ikaikidwa, tchatichi chimawoneka ngati chinthu papepala lomwelo ndi deta. Mu Excel, izi zimachitika mwachisawawa. Ngati ndi kotheka, mutha kusuntha tchati patsamba lina kuti muyike bwino deta.
- Sankhani tchati chomwe mukufuna kusuntha.
- Dinani Constructor, kenako dinani lamulo Sungani Tchati.
- Bokosi la zokambirana lidzatsegulidwa Kusuntha tchati. Sankhani malo omwe mukufuna. Muchitsanzo chamakono, tidzayika tchati pa pepala lapadera ndikulitcha dzina Kugulitsa mabuku 2008-2012.
- Press OK.
- Tchaticho chisamutsidwa kupita kumalo atsopano. Kwa ife, ili ndi pepala lomwe tangopanga kumene.