Momwe mungapangire graph mu Excel

Ntchito imodzi yofanana ndi masamu ndikupanga dongosolo lodalira. Zimawonetsa kudalira kwa ntchitoyo kuchokera ku kusintha mkanganowo. Pa pepala, njirayi siyophweka nthawi zonse. Koma zida za Excel, ngati tidziteteza kuti tiwalitse, lolani kuti mugwire ntchito imeneyi molondola komanso mofulumira. Tiyeni tiwone momwe izi zingagwiritsire ntchito pogwiritsa ntchito magwero osiyanasiyana.

Njira Zowonetsera Zojambula

Kudalitsika kwa ntchito ya mkanganowo ndi kudalira kwa algebraic. Nthawi zambiri, mkangano ndi kufunikira kwa ntchitoyo imapangidwa kuti iwonetse zizindikilo: motero, "x" ndi "y". Nthawi zambiri, ndikofunikira kupanga mawonekedwe a kudalira mkanganowo ndi ntchito zomwe zalembedwa pagome, kapena zimaperekedwa ngati gawo la fomula. Tiyeni tisanthule zitsanzo zaakulu zopanga graph (zojambula) pansi pa mikhalidwe yosiyanasiyana.

Njira 1: Kupanga njira yodzidalira

Choyamba, tidzakambirana momwe mungapangire graph yochokera pazotengera matebulo. Timagwiritsa ntchito tebulo podalira njira yoyenda (y) pa nthawi (x).

Tebulo logawika limakutidwa nthawi ndi nthawi ku Microsoft Excel

Tikutsindika patebulo ndikupita ku tabu ". Dinani pa batani la "Ndemanga", lomwe lili ndi kuthengo kwa tchati pa riboni. Kusankha mitundu mitundu ya ma graphs otseguka. Kuti mupeze zolinga zathu, sankhani zosavuta. Ili patsamba loyamba pamndandanda. Dongo pa izo.

Kusintha Kumanga Kwa Graph ku Microsoft Excel

Pulogalamuyi imapanga chithunzi. Koma, monga tikuwona, mizere iwiri imawonetsedwa pamalo omanga, pomwe timangofuna imodzi yokha: imawonetsa kudalira kwa mtunda nthawi ndi nthawi. Chifukwa chake, timagawa batani lakumanzere ndi mzere wabuluu ("nthawi"), chifukwa sizigwirizana ndi ntchitoyi, ndikudina batani la Delete.

Kuchotsa mzere wowonjezera pa tchati ku Microsoft Excel

Mzere wosankhidwa udzachotsedwa.

Kwenikweni, pomanga dongosolo losavuta kwambiri lomwe lingathe kuwerengedwa. Ngati mukufuna, mutha kusinthanso mayina a tchati, nkhwangwa yake, chotsani nthanoyo ndikupanga zina zina. Izi zikufotokozedwa mwatsatanetsatane mu phunziroli.

Phunziro: Momwe Mungapangire Ndandanda Yabwino

Njira 2: Kupanga zochita ndi mizere ingapo

Cholinga chovuta kwambiri cha graph graphy ndi mlandu pomwe mkangano umodzi umafanana ndi ntchito ziwiri nthawi imodzi. Pankhaniyi, muyenera kumanga mizere iwiri. Mwachitsanzo, tengani tebulo lomweli nambala ya Enterprise ndi phindu lake la ukonde lapezedwa.

Tikuwonetsa tebulo lonse ndi chipewa.

Monga momwe zidayambira kale, timadina pa "kukonza" mu gawo la chart. Apanso, sankhani njira yoyamba yomwe yafotokozedwayi yomwe ili pamndandanda womwe umatsegulidwa.

Kusintha Kupanga tchati ndi mizere iwiri mu Microsoft Excel

Pulogalamuyi imapanga zojambula zojambula molingana ndi zomwe zapezedwa. Koma, monga tikuwona, pankhaniyi, sitimangokhala ndi mzere wachitatu, komanso kudziwika pa themberero lopingasa la magwiridwe ake sagwirizana ndi omwe akufunika, ndiye kuti dongosolo la chaka.
Nthawi yomweyo chotsani mzere wowonjezera. Iye ndiye wokhawo mwachindunji pa chithunzi ichi - "chaka." Monga momwe zidayambira kale, tikutsimikizira dinaniyo ndi mbewa ndikudina batani la Delete.

Chotsani mzere wachitatu pa tchati ku Microsoft Excel

Mzere wachotsedwa komanso limodzi ndi icho, momwe mungadziwire, zomwe zimagwirizana pagawo lolumikiza zimasinthidwa. Anayamba kulondola. Koma vutoli ndi kuwonetsa kolakwika kwa nkhwangwa yozungulira yolumikizira ikutsalira. Kuthetsa vutoli, dinani pamunda womanga batani lakumanja. Mumenyu, muyenera kusiya kusankha "Sankhani deta ...".

Kusintha Kusankha kwa deta mu Microsoft Excel

Zenera losankha magwero amatsegula. Mu "siginecha yopingasa" block, dinani batani la "Sinthani".

Kusintha Kuti Musinthe Mu Signature ya Ozungulira Pazenera la Data Yosankhidwa ku Microsoft Excel

Zenera limatsegulidwa kwambiri kuposa kale. Mmenemo, muyenera kutchula malo ogwirizira mu tebulo la zomwe zikhalidwe zomwe zikuyenera kuwonetsedwa pa axis. Kuti izi zitheke, khazikitsani cholozera m'munda wokha wa zenera ili. Kenako ndimagwira batani lakumanzere ndikusankha zomwe zili pachaka, kupatula dzina lake. Adilesiyo idzakhudzanso gawo, dinani "Chabwino".

Windos Signature Window in Microsoft Excel

Kubwerera ku zenera la data losankha, nenaninso dinani "Chabwino".

Zenera losankhidwa la data ku Microsoft Excel

Pambuyo pake, zilombo zonse zomwe zimayikidwa papepala zimawonetsedwa molondola.

Zojambula pa pepalalo zimawonetsedwa molondola mu Microsoft Excel

Njira 3: Kupanga zojambula mukamagwiritsa ntchito mayunitsi osiyanasiyana

Munjira yapita, tidaganiza zomangajambula ndi mizere ingapo pa ndege yomweyo, koma ntchito zonse zidali ndi magawo ofanana (ma rubles zikwi). Kodi ndiyenera kuchita chiyani ngati mukufuna kupanga dongosolo lodalira patebulo limodzi, momwe magawo a ntchito yoyezera amasiyanasiyana? Excel ili ndi zotulutsa komanso kuchokera pa izi.

Tili ndi tebulo, lomwe limapereka deta pa kuchuluka kwa malonda a malonda ena m'matumbo komanso mu ndalama kuchokera kukhazikitsidwa kwake m'ma ruble masauzande.

Monga momwe m'mbuyomu, timagawa deta yonse ya tebulo limodzi ndi kapu.

Kusankha data ya tebulo limodzi ndi kapu mu Microsoft Excel

Dongo pa batani la "Nyimbo". Tisankhanso njira yoyamba yomanga pamndandanda.

Kusintha Kumanga Kwa Graph ya Lou Connger ndi magawo osiyanasiyana a mu Microsoft Excel

Zolinga za zojambulajambula zimapangidwa pamalo omanga. Momwemonso, zomwe zidafotokozedwa m'mabaibulo am'mbuyomu, timachotsa chaka cha "chaka" chowonjezera ".

Kuchotsa mzere wowonjezera pa graph ndi mawonekedwe okhala ndi magawo osiyanasiyana a mu Microsoft Excel

Monga momwe zapita kale, tiyenera kuwonetsa chaka chimodzi pandenja lozungulira. Dinani pa malo omanga komanso mndandanda wazomwe mungachite, sankhani njira "Sankhani deta ...".

Pawindo latsopano, mumadina batani la "Kusintha" mu "Signature" kutchinga kwa nkhwangwa yopingasa.

Pawindo lotsatira, ndikupanga zomwezo zomwe zinafotokozedwa mwatsatanetsatane mu njira yapitayo, timayambitsa magwiridwe a chaka cha chaka chimodzi kudera la axis siginecha. Dinani pa "Chabwino".

Mukabwerera ku zenera lapita, mumachitanso dinani batani la "OK".

Tsopano tiyenera kuthana ndi vuto lomwe sanakumanepo m'mbuyomu, kuti tikwaniritse vuto la zomanga, poyamba, vuto la zigawo zosagwirizana. Kupatula apo, mudzagwirizana, sangathe kupezeka pagawo lomweli, lomwe limakhala nthawi yomweyo, zomwe zimapanga ndalama zambiri (ma ruble zikwi) ndi misa (matani). Kuti athane ndi vutoli, tidzafunikira kumanga ma axis owonjezera ogwirizana.
M'malo mwathu, kupangira ndalama, tisiya chopinga, ndipo kwa "buku la" malonda "lipanga othandiza. Clay pamzere woyamba mbewa batani la mbewa ndikusankha kuchokera pamndandanda "mtundu wa chidziwitso zingapo ...".

Kusintha kwa mtundu wa kuchuluka kwa deta yambiri mu Microsoft Excel

Zewi la Fota ya data limayambitsidwa. Tiyenera kusamukira ku "magawo", ngati inali yotseguka m'chigawo china. Kumbali yakumanja kwa zenera pali chopindika "kumanga mzere". Muyenera kukhazikitsa kusintha kwa malo "mwa anialir anter". Dongo la "Tsekani".

Ziwerengero zingapo za data mu Microsoft Excel

Pambuyo pake, anialiary yolumikizira oterera adzamangidwa, ndipo mzere wogulitsa udzatsimikiziridwa kumalumikizidwe ake. Chifukwa chake, ntchito pa ntchitoyi idatsirizidwa bwino.

Ogwiritsa ntchito a Axtil Ortis Omangidwa ku Microsoft Excel

Njira 4: Kupanga grafiph yodalira pa ntchito ya algebraic

Tsopano tiyeni tikambirane njira yomanga dongosolo lodalira lomwe lidzakhazikitsidwa ndi ntchito ya algebraic.

Tili ndi ntchito yotsatirayi: y = 3x ^ 2 + 22. Pamaziko ake, ndikofunikira kupanga chithunzi cha zomwe zimadalira za y kuchokera ku x.

Musanafike kumanga chithunzi, tidzafunika kupanga tebulo lotengera ntchito yomwe yafotokozedwayo. Makhalidwe a mkangano (X) patebulo lathu ilembedwa kuchokera -15 mpaka + 330 mu gawo 3. Kuthamangira njira zoyambira zoyambira, kusinthiratu "chida".
Tikusonyeza mu khungu loyamba la "X" mtengo "-15" ndikugawa. Mu "kunyumba", dongo lomwe lili pa batani la "Dzazani" lomwe lili mu gawo losintha. Pa mndandanda, sankhani "kudutsa ..." Njira.

Kusintha ku Win Couglunjika Chipangizo cha pa Microsoft Excel

Utoto wa "Progisonis" udzachitidwa. Mu "malo" block, lembani dzinalo "pamizamu", popeza tifunika kudzaza nambala. M'gulu la "mtundu", siyani "masamu", omwe amakhazikitsidwa mwachinyengo. M'dera la "sitepe", khazikitsani mtengo "3". Pamalire, timakhazikitsa chiwerengero "30". Chitani dinani pa "Chabwino".

Pambuyo pochita izi algorithm iyi, tsamba lonse "x" lidzadzaza ndi mfundo mogwirizana ndi chiwembu chomwe chatchulidwa.

Nyanja ya X imadzaza ndi mfundo mu Microsoft Excel

Tsopano tikuyenera kukhazikitsa mfundo za Y zomwe zingafanane ndi zomwe X. Chifukwa chake, tikukumbukira kuti tili ndi formula y = 3x ^ 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 + 2 2. Ndikofunikira kutembenuza kwa njira yopambana, yomwe mfundo ya X idzasinthidwa ndi mafotokozedwe a tebulo okhala ndi mfundo zofananira.
Sankhani selo yoyamba mu "Y". Poganizira izi kwa ife, Adilesi yakangana Yoyamba X akuimiridwa ndi A2 amaimiridwa ndi A2 amalumikizana, ndiye m'malo mwa fomulayo, timapeza mawu otere:
= 3 * (A2 ^ 2) + 2 * A2-15
Timalemba mawu awa mu khungu loyamba la "Y". Kuti mupeze zotsatira za kuwerengera, dinani kiyi.

Formula mu khungu loyamba la y Column mu Microsoft Excel

Zotsatira za ntchitoyi kuti mkangano woyamba wa formula adapangidwa. Koma tiyenera kuwerengera zomwe amakhulupirira pankhani zina zotsutsana. Lowetsani formula ya mtengo uliwonse y nthawi yayitali komanso yotopetsa. Zimathamanga kwambiri komanso zosavuta kuzikopera. Ntchitoyi imatha kuthetsedwa pogwiritsa ntchito cholembera ndikuthokoza pazinthuzi zonena za mafotokozedwe ake, monga momwe ziliri. Mukamakopera formula ina ya RAREES y, mfundo za X mu formula zimangosintha mwachidule pamalumikizidwe ake oyamba.
Timanyamula cholozera chakumapeto kwa chinthu chomwe foloko idalembedwa kale. Nthawi yomweyo, kusintha kuyenera kuchitika kwa chotemberero. Idzakhala mtanda wakuda womwe umakhala ndi dzina la cholembera. Dinani batani lakumanzere ndikutenga chikhomo chakumapeto kwa tebulo mu "Y".

Chochita pamwambapa chidapangitsa kuti chithunzithunzi cha "y" chidadzazidwa ndi zotsatira za kuwerengera kwa forla y = 3x ^ 2 + 2 + 2 + 2 + 2.

Column Y wadzazidwa ndi zidziwitso za formula ya formula a Microsoft Excel

Tsopano ndi nthawi yoti mumange mwachindunji chojambulachokha. Sankhani zonse zokopa. Apanso mu "kuyika" tabu, kanikizani "tchati" gulu ". Pankhaniyi, tiyeni tisankhe kuchokera pamndandanda wazosankha "kukonza ndi zilembo".

Kusintha Kumanga Kwa Graph Ndi Olembera ku Microsoft Excel

Tchati chomwe ndi zolembera chidzawonetsedwa pamalo omanga. Koma, monga momwe zinthu zisanachitike, tifunika kusintha zina mwazosintha kuti zitheke.

Kuwonetsera koyambirira kwa zithunzi ndi zilembo ku Microsoft Excel

Choyamba, timachotsa mzerewu "X", yomwe ili yopingasa pa zilembo 0. Timagawa chinthu ichi ndikudina batani la Delete.

Kuchotsa mzere wa X pa tchati ku Microsoft Excel

Sitifunikiranso nthano, popeza tili ndi mzere umodzi wokha ("Y"). Chifukwa chake, tikutsindika nthano ndikusindikiza batani lochotsa.

Tsopano tiyenera kusinthidwa m'malo olumikizirana ndi omwe amagwirizana ndi "x" patebulo.
Batani la mbewa lamanja limawunikira mzere wojambula. Sungani "Sankhani deta ..." mumenyu.

Sinthani ku zenera la data ku Microsoft Excel

Pazenera loyambitsidwa la bokosi losankhidwa la Source, "Kusintha" kwatidziwitsa kale, komwe kuli "siginecha ya opingasa".

Kusintha Kuti Musinthe Mu Siginecha ya Ozungulira Axis Yogwirizanitsa Pazenera Zosankhidwa pa Microsoft Excel

Zewi la "Axis Siginecha" limayambitsidwa. M'dera lomwe lili ndi siginecha ya axis, tikuwonetsa magwiridwe antchito ndi deta ya "X". Timaika chotengera kumunda, kenako ndikupanga batani lofunikira la mbewa yakumanzere, sankhani malingaliro onse a gulu lolingana la tebulo, kupatula dzina lake. Kamodzi magwiridwewo akuwonetsedwa m'munda, dongo pa dzinalo "Chabwino".

Windo la Sign Signature yokhala ndi adilesi yolembedwa mu gawo la Microsoft Excel

Kubwerera ku zenera losankha deta, dongo pa batani la "Ok" mmenemo, monga asanachite m'winja lapitalo.

Kutseka pazenera lazosankhidwa pa Microsoft Excel

Pambuyo pake, pulogalamuyo imasintha tchati chomwe kale zidapangidwa kale malinga ndi zosintha zomwe zidapangidwa mu makonda. Chithunzi chodalira kudalira pamaziko a ntchito ya algebraic yomwe ingawonekere pomaliza.

Ndandandayi imamangidwa pamaziko a formula yopatsidwa mu Microsoft Excel

Phunziro: Momwe Mungapangire Autocomple mu Microsoft Excel

Monga mukuwonera, pogwiritsa ntchito pulogalamu ya Excel, njira yopangira magawa yofananira ndiyosavuta poyerekeza ndi chilengedwe cha pepala. Zotsatira za zomangamanga zitha kugwiritsidwa ntchito pophunzitsira ntchito yophunzitsira komanso mwachindunji. Malo owoneka bwino amadalira zomwe zimachokera pa chithunzi: Mapulogalamu kapena ntchito. Mlandu wachiwiri, musanapange chithunzi, muyenera kupanga tebulo ndi mfundo ndi malingaliro a ntchito. Kuphatikiza apo, ndandandayi imathamangitsidwa chifukwa cha ntchito imodzi ndi zingapo.