Momwe mungapangire graph ku Excel

Ndondomekoyo imakupatsani mwayi wowunikira kudalira kwa data kuchokera ku zisonyezo zina kapena zamphamvu zawo. Zinthu izi zimagwiritsidwa ntchito kuntchito zasayansi kapena kafukufuku, komanso m'mawu. Tiyeni tiwone momwe tingapangire graph mu Microsoft Excel.

Kupanga zithunzi ku Excel

Aliyense wogwiritsa ntchito, akufuna kuwonetsa bwino zambiri za manambala mu mawonekedwe a okamba, amatha kupanga ndandanda. Njirayi ndiyosavuta ndipo imatanthawuza kukhalapo kwa tebulo komwe kudzagwiritsidwa ntchito pa database. Pakuganiza kwake, chinthucho chitha kusinthidwa kuti chikuwoneka bwino ndikuyankha zofunikira zonse. Tidzasanthula momwe mungapangire mitundu yosiyanasiyana ya ma graph.

Kupanga dongosolo lanthawi zonse

Mutha kujambula ndandanda mu Excel pokhapokha patebulopo ikakonzeka kudziwa zambiri pamaziko omwe idzamangidwa.

1. Kukhala pa "kuyika" tabu, amagawa malo omwe mukufuna kuti muwone pa tchati. Kenako pa tepi mu "chithunzi" chotchinga cha chida podina batani la "sakani".
2. Pambuyo pake, pali mndandanda womwe mitundu isanu ndi iwiri ya ma graphs akuimiridwa:
   • Mwachizolowezi;
   • Ndi kudzikundikira;
   • Ozunguliridwa ndi kudzikundikira;
   • Ndi zikwangwani;
   • Ndi zikwangwani ndi kudzikundikira;
   • Kukhazikika ndi zolembera ndi kudzikundikira;
   • Voliyumu.

   Sankhani amene malingaliro anu ndi oyenera kwambiri pazolinga zake.



3. Zowonjezera zowonjezera zimapanga dongosolo mwachindunji.

Kusintha Zojambula

Mukamaliza graph, mutha kuchita izi kuti musinthe kuti mupereke chinthucho choyimira kwambiri ndikuwongolera kumvetsetsa zakuthupi zomwe zimawonetsera.

1. Kusaina ndandanda, pitani ku tabu "ya" ya "ya nthiti ya ntchito ndi ma chart. Dinani pa batani pa nthiti yokhala ndi dzina la "tchati". M'ndandanda womwe umatsegulidwa, timatchula momwe dzinalo lidzapezeke: pakati kapena pamwamba pa ndandanda. Njira yachiwiri nthawi zambiri imakhala yoyenera, motero timagwiritsa ntchito "pamwamba pa chithunzi" Mwachitsanzo. Zotsatira zake, dzinali limapezeka, lomwe limatha kusinthidwa kapena kusinthidwa mosaganizira, kungodina ndi zilembo zomwe mukufuna kuchokera pa kiyibodi.



2. Mutha kutchula dzina la axes podina batani la "Axis". Pa mndandanda wa dontho, sankhani "dzina la axis wamkulu wopingasa", kenako pitani ku "dzina pansi pa axis".



3. Pansi pa Axis pali mawonekedwe a dzina lomwe aliyense angagwiritsidwe ntchito mwanzeru yake.



4. Momwemonso, timasaina ma axis. Dinani pa batani la "Dzina la" Axis ", koma mumenyu zomwe zikuwoneka, sankhani" Dzinalo la Nation of the Artis wamkulu ". Mndandanda wa zosankha zitatu zosagawera udzatsegulidwa: kuzungulira, vertical, zopingasa. Ndikofunika kugwiritsa ntchito dzina lozungulira, monga momwe pamenepa malowo amapulumutsidwa papepala.



5. Pa pepala pafupi ndi axis yofananira, munda umawonekera momwe mungalembetsere dzina loyenereradi ndi zomwe zalembedwazo.



6. Ngati mukuganiza kuti kumvetsetsa ndandanda ya nthano sikukufunika ndipo zimangochitika zokha, mutha kuzichotsa. Dinani pa batani la Nthanda, lomwe lili pa tepi, kenako posankha "Ayi". Nthawi yomweyo, mutha kusankha mawonekedwe aliwonse a nthano, ngati simuchotsa, koma sinthani malowo.

Kupanga ndandanda yokhala ndi axaliar tent

Pali zochitika zomwe mungafunikire kuyika zigawo zingapo pa ndege yomweyo. Ngati ali ndi njira zomwezo zomwezo, izi zimachitika chimodzimodzi monga tafotokozera pamwambapa. Koma bwanji ngati pali njira zosiyanasiyana?

1. Kukhala pa "kuyika" tabu, ngati nthawi yotsiriza, sonyezani malingaliro a tebulo. Kenako, timadina pa batani la "Ndege" ndikusankha njira yoyenera kwambiri.



2. Monga tikuwona, zithunzi ziwiri zimapangidwa. Pofuna kuwonetsa dzina lolondola la magawo a dongosolo lirilonse, amadina batani lamanja la mbewa limodzi kuti tiwonjezere axis owonjezera. Mumenyu zomwe zimawoneka, fotokozerani chinthucho "mtundu wa zidziwitso zingapo".



3. Zewi la Fota ya data limayambitsidwa. Mu gawo lakelo "mzere magawo", zomwe zikuyenera kutseguka mosavuta, sinthaninso kusinthanso kwa "anixilir yoyipitsa" udindo. Dinani batani la "Tsekani".



4. Axis yatsopano imapangidwa, ndipo ndandandayo imakonzanso.



5. Tiyenera kungoipitsa axis ndi dzina la chithunzi pa algorithm ofanana ndi chitsanzo cham'mbuyomu. Ngati pali zithunzi zina, nthano ndiyabwino kuti musayeretse.

Kupanga Zithunzi Zogwiritsira Ntchito

Tsopano tiyeni tiwone momwe mungapangire tchati pa ntchito yopatsidwa.

1. Tiyerekeze kuti tili ndi ntchitoyi y = x ^ 2-2. Gawolo lidzakhala lolingana 2. Loyamba amamanga tebulo. Mbali yakumanzere, lembani mtengo wa X mu Gawo 2, ndiye kuti, 2, 4, 6, 10, 10, etc. Ku gawo lamanja lomwe timayendetsa formula.



2. Kenako, timabweretsa cholozera kwa ngodya yakumanja la cell, dinani batani lakumanzere ndikuti "kutambasula" pansi pa gome, potero kukopera formula maselo.



3. Kenako pitani ku "kuyika" tabu. Sankhani deta ya piritsi ndikudina batani la "Centraft" pa tepi. Kuchokera mndandanda wa zojambulajambula, sankhani mfundo yokhala ndi ma curve osalala ndi zikwangwani, monga mtundu uwu ndi woyenera kwambiri womanga.



4. Zojambulajambula zimakhazikika.



5. Chinthucho chitamangidwa, mutha kuchotsa nthanoyo ndikupanga zosintha zina zomwe zafotokozedwa kale.

Monga mukuwonera, Microsoft Excel imapereka kuthekera kopanga mitundu yosiyanasiyana ya ma graph. Mkhalidwe waukulu chifukwa cha ichi ndikupanga tebulo ndi deta. Ndandanda yopangidwa ikhoza kusinthidwa ndikukonzedwa molingana ndi cholinga.