Chidacho chimakupatsani mwayi wowunika kutsimikizira kudalira kwa zidziwitso kuzisonyezo zina, kapena mphamvu zake. Chati chimagwiritsidwa ntchito zonse mu sayansi kapena kafukufuku, komanso pazowunikira. Tiyeni tiwone momwe mungapangire chithunzi mu Microsoft Excel.
Kupanga mapulani
Mutha kujambula chithunzi mu Microsoft Excel pokhapokha tebulo lokhala ndi deta ikakhazikitsidwa, pamaziko omwe idzamangidwe.
Gome litakonzeka, kukhala mu "Ikani" tabu, sankhani malo patebulopo pomwe tiwerengere zinthu zomwe tikufuna kuwona pagawoli. Kenako, pa riboni mu Bokosi lothandizira, dinani batani la Chart.
Pambuyo pake, mndandanda umatsegulidwa, momwe mitundu isanu ndi iwiri yama graph imasonyezedwa:
- ndandanda yokhazikika;
- ndi kudzikundikira;
- ndandanda yodziwika ndi kudzikundikira;
- ndi zolembera;
- tchati chokhala ndi zolembedwa ndi kudzikundikira;
- tchati chosasintha ndi zolembera ndi kudzikundikira;
- graphumetric graph.
Timasankha dongosolo lomwe, mumaona, ndiloyenera kwambiri pazolinga zakumangidwe kwake.
Kupitilira apo, pulogalamu ya Microsoft Excel imachita chiwembu mwachangu.
Kusintha kwa zithunzi
Graph itamangidwa, mutha kuyisintha kuti izioneka yowoneka bwino, ndikuthandizira kuti mumvetsetse zinthu zomwe chiwonetserochi chikuwonetsa.
Kuti mulembe dzina la tchatchi, pitani pa "Layout" ya wizard ya chart. Dinani batani pazambalala pansi pa dzina la "Chart Name". Pamndandanda womwe umatsegulira, sankhani pomwe padzayikidwe dzinalo: pakatikati kapena pamwamba pa dongosolo. Njira yachiwiri ndiyoyenera, kotero dinani pazinthu "Pamwamba pa tchati". Pambuyo pake, padzapezeka dzina lomwe lingasinthidwe kapena kusinthidwa mwakufuna kwanu, mwa kungodina ndi kulowa zilembo zomwe mukufuna kuchokera ku kiyibodi.
Kuti mutchule dzina la axis la graph, dinani batani la "Axis". Pamndandanda wotsitsa, sankhani pomwepo "Jina la axis yayikulu", kenako pitani pomwe pali "Jina pansi pa axis".
Pambuyo pake, mawonekedwe a dzinalo amapezeka pansi pa axis, momwe mungalowe dzina lililonse lomwe mukufuna.
Mofananamo, timasainira cholowera. Dinani "batani la" Axis ", koma pazosankha zomwe zimapezeka, sankhani dzina la" Name of the vertical axis. " Pambuyo pake, mndandanda wazosankha zitatu zomwe zimasainidwa zimatsegulidwa:
- kuzungulira
- ofukula
- yopingasa.
Ndikofunika kugwiritsa ntchito dzina lozungulira, monga pamenepa, malo amasungidwa papepala. Dinani pa dzina "Dongosolo Lozungulira".
Apanso pa pepala pafupi ndi axis yolumikizana, pamapezeka gawo lomwe mutha kulowetsa dzina la axis loyenereradi gawo lazomwe zili patsamba ili.
Ngati mukuganiza kuti nthano siyofunika kumvetsetsa dongosolo, ndipo imangotenga malo, ndiye kuti mutha kuyimitsa. Kuti muchite izi, dinani batani la "Legend" lomwe lili pa riboni ndikusankha "Ayi". Mutha kusankha pomwepo nthano iliyonse ngati simukufuna kuzimitsa, koma sinthani malowo.
Ndikupanga ndi axis yothandizira
Pali nthawi zina pamene muyenera kuyika ma graph angapo pa ndege yomweyo. Ngati ali ndi mtundu womwewo, ndiye kuti zimachitika chimodzimodzi monga tafotokozera pamwambapa. Koma bwanji ngati njirazi ndizosiyana?
Poyamba, kukhala mu "Ikani" tabu, monga nthawi yotsiriza, sankhani mfundo za patebulo. Kenako, dinani batani "Chart", ndikusankha njira yoyenera kwambiri.
Monga mukuwonera, ma graph awiri amapangidwa. Pofuna kuwonetsa dzina lolondola la gawo lililonse pa graph iliyonse, dinani kumanja komwe tiziwonjezera axis yowonjezera. Pazosankha zomwe zimawonekera, sankhani zofunikira za "Fomati ya data".
Zenera la mtundu lazithunzi limayamba. Mu gawo lake "Magawo mzere", womwe ungatsegule mosasinthika, timasinthira mawonekedwe kuti "Pamtunda wothandizira". Dinani pa batani la "Close".
Pambuyo pake, axis yatsopano imapangidwa, ndipo graph imamangidwanso.
Tsopano, tiyenera kungosayina nkhwangwa, ndi dzina la graph, kugwiritsa ntchito ndendende algorithm monga momwe adachitira chitsanzo cham'mbuyomu. Ngati pali ma graph angapo, ndibwino kuti musachotse nthano.
Ntchito kujambula
Tsopano tiyeni tiwone momwe angapangire chithunzi cha ntchito inayake.
Tiyerekeze kuti tili ndi ntchito y = x ^ 2-2. Gawo likhala 2.
Choyamba, tikupanga tebulo. Mbali yakumanzere, lembani zofunikira za x mukuwonjezera kwa 2, i.e 2, 4, 6, 8, 10, etc. Mu gawo loyenerera timayendetsa formula.
Kenako, timafika pakona ya kumunsi kwa chipindacho, ndikudina batani la mbewa, ndiku "ndikutambata" pansi penipeni pa tebulo, potengera kawonedwe kofananira ndi maselo ena.
Kenako, pitani ku "Insert" tabu. Timasankha masamba a ntchitoyo, ndikudina batani "Scatter scheme" pa riboni. Kuchokera pamndandanda wazithunzi, timasankha zojambula zokhala ndi zotchingira ndi zowoneka bwino, chifukwa mawonekedwe awa ndiabwino kwambiri popanga ntchito.
Kukhazikitsa graph.
Girayi ikamangidwa, mutha kuchotsa nthanoyo, ndikusintha zojambula, zomwe zidakambidwa kale pamwambapa.
Monga mukuwonera, Microsoft Excel imapereka mwayi wopanga ma graph osiyanasiyana. Mkhalidwe waukulu wa izi ndikupanga tebulo lomwe lili ndi deta. Pambuyo pokhazikitsa dongosolo, imatha kusinthidwa ndikusinthidwa malinga ndi cholinga chomwe mukufuna.
