Nkhani zimakhala mu Excel; fufuzani komwe!
Pa tchati kapena graph mu mapulogalamu a spreadsheet monga Microsoft Excel, nthano nthawi zambiri ili kumanja kwa tchati kapena graph ndipo nthawi zina kuzungulira malire.
Nthanoyi imalumikizidwa ndi deta yomwe ikuwonetsedweratu m'deralo la tchati. Chilichonse cholowera m'nthanochi chimaphatikizapo chinsinsi chofotokozera deta.
Zindikirani: Nthanoyi imadziwikanso ngati Mzere wa Chati.
Kodi Chinsinsi Chachiganizo N'chiyani?
Kuwonjezera pa chisokonezo pakati pa nthano ndi fungulo, Microsoft imatanthawuza pa chinthu chilichonse pa nthano ngati chinsinsi cha nthano.
Chifanizo cha nthano ndi chizindikiro chimodzi chojambulidwa kapena choyimira chokhazikika m'nthano. Kumanja kwa fungulo lililonse lachinsinsi ndi dzina lozindikiritsa deta loyimiridwa ndi fungulo.
Malingana ndi mtundu wa tchati, makiyi amthano amaimira magulu osiyanasiyana a deta mu worksheet yotsatirayi:
- Kwa graph ya mzere, grafu ya bar, kapena tchati cha mndandanda , chofunika chirichonse cha nthano chimayimira mndandanda umodzi wa deta .
- Mwachitsanzo, mu tchati cha mndandanda, mukhoza kukhala ndi fungulo labuluu lomwe limawerengera Zaka zapafupi ndi ilo, ndi lalanje la Dzina. Mitundu ya buluu pa tchatiyo imatanthawuza zaka zomwe zimalowetsamo mndandanda wa Mayina.
- Kwa tchati cha piya kapena ndondomeko yamndandanda, choyimira chilichonse choyimira chimangokhala mbali imodzi ya mndandanda wa deta.
- Kuti mugwiritse ntchito chitsanzo chomwecho kuchokera pamwamba, koma pa tchati cha pie, chodulidwa chirichonse cha chitumbuwa ndi mtundu wosiyana womwe ukuyimira chilolezo chilichonse cha "Dzina". Gawo lirilonse la chitumbuwa ndi kukula kosiyana kwa bwalo lonse kuti liyimire kusiyana kwa zaka zomwe zimachokera ku "Age" mndandanda.
Kusintha Zopangidwe Zake ndi Zake Zake
Mu Excel, zolemba zamakono zimayanjanitsidwa ndi dera lomwelo, kotero kusintha mtundu wa fungulo lachinsinsi kudzasintha mtundu wa deta m'deralo.
Mukhoza kuwongolera pomwepo kapena pompani-gwiritsani pa fayilo ya legend, ndi kusankha Format Entry Entry , kusintha mtundu, chitsanzo, kapena chithunzi choyimira deta.
Kuti musinthe zosankha zokhudzana ndi nthano yonse, osati kungowonjezera, dinani pomwepo kapena pangani ndikugwira kuti mupeze mtundu wa Format Legend . Umu ndi momwe mumasinthira malembo, kulembera malemba, mauthenga, ndi malemba.
Mmene Mungasonyezere Lamuloli mu Excel
Pambuyo pokonza tchati mu Excel, n'zotheka kuti nthano sichisonyeza. Mutha kuthetsa nthano mwa kungoigwiritsa ntchito pokhapokha.
Nazi momwemo:
- Sankhani tchati.
- Pezani Tabu Yopanga pamwamba pa Excel.
- Tsegulani menyu ya Add Chart Element .
- Sankhani Lembali kuchokera pa menyu.
- Sankhani kumene nthano iyenera kuikidwa - pomwe, pamwamba, kumanzere, kapena pansi.
Ngati njira yowonjezeramo nthano imachotsedwa, zimangotanthauza kuti muyenera kusankha deta yoyamba. Dinani pakanema tchati chatsopano, chopanda kanthu ndikusankha Deta Data , ndiyeno tsatirani malangizo owonetsera pazithunzi kuti musankhe deta yomwe imaimira.