Ma chart amathandizira kuwonetsa kuchuluka kwa manambala mu mawonekedwe, ndipo kumathandizira kumvetsetsa kwa zambiri. Komanso, pogwiritsa ntchito matchati, mutha kuwonetsa maubwenzi apakati osiyanasiyana.
Chida chaofesi ya Microsoft, Mawu, chimakuthandizaninso kupanga zojambula. Tikuuzani za momwe mungachitire pansipa.
Chidziwitso: Kupezeka pakompyuta yanu ya pulogalamu yoyika pulogalamu ya Microsoft Excel kumakupatsirani mwayi wopanga zojambula mu Neno 2003, 2007, 2010 - 2016. Ngati Excel siyikadayikidwa, Microsoft Graph imagwiritsidwa ntchito kupanga zojambula. Tchati pankhaniyi chidzaperekedwa ndi zomwe zikugwirizana (tebulo). Simungangoyika data yanu patebulopo, komanso kuitanitsa kuchokera ku chikalata cholemba kapena kuikiratu ku mapulogalamu ena.
Kupanga tchati cha maziko
Mutha kuwonjezera tchati ku Mawu m'njira ziwiri - chiphatikizeni chikalata kapena muike pepala la Excel lomwe lidzalumikizidwe ndi deta yomwe ili pa pepala la Excel. Kusiyanitsa kwa zojambula izi ndi komwe amasunga zomwe ali nazo ndi momwe zimasinthidwa atangolowa mu MS Word.
Chidziwitso: Ma chart ena amafunika dongosolo la data papepala lothandizira la Ex Excel.
Momwe mungayikitsire tchati ndikuchiyika mu chikalata?
Chithunzi cha Excel chophatikizidwa m'Mawu sichisintha ngakhale mutasintha fayilo yanu. Zinthu zomwe zidaphatikizidwa mu chikalatacho zimakhala gawo la fayilo, kusiya kukhala gawo la gwero.
Popeza kuti deta yonse imasungidwa mu chikwangwani cha Mawu, ndikofunikira kwambiri kugwiritsa ntchito kutsitsa ngati simukufunika kusintha zomwezo, poganizira fayiloyo. Komanso, kukhazikitsa ndibwino kugwiritsa ntchito pomwe simukufuna ogwiritsa ntchito omwe adzagwire ntchito ndi chikalatacho posintha zidziwitso zonse zokhudzana.
1. Dinani kumanzere pa chikalata chomwe mukufuna kuwonjezera tchati.
2. Pitani ku tabu "Ikani".
3. Mu gulu "Zithunzi" sankhani "Tchati".
4. Mu bokosi la zokambirana lomwe limawonekera, sankhani tchati chomwe mukufuna ndikudina Chabwino.
5. Osati tchati chokha chidzaonekera papepala, komanso Excel, yomwe idzakhale pazenera logawanika. Idzawonetseranso deta yachitsanzo.
6. Sinthani zamphatso zachitsanzo zomwe zidaperekedwa pazenera logawika la Excel Excel ndi zomwe mukufuna. Kuphatikiza pa data, ndizotheka kusintha zitsanzo za siginecha ya axis (Kholamu 1) ndi dzina la nthano (Mzere 1).
7. Mukamalowetsa zofunika pazenera la Excel, dinani chizindikiro "Kusintha kwa data mu Microsoft Excel»Ndipo sungani chikalatacho: Fayilo - Sungani Monga.
8. Sankhani malo kuti musunge chikalatacho ndikulowetsa dzina lomwe mukufuna.
9. Dinani "Sungani". Tsopano chikalatacho chitha kutsekedwa.
Iyi ndi imodzi mwazomwe mungagwiritse ntchito kujambula tchati pagome.
Kodi mungawonjezere bwanji chart ya Excel ku chikalata?
Njirayi imakulolani kuti mupange tchati mwachindunji ku Excel, papepala lakunja kwa pulogalamuyo, kenako ndikungoyika mtundu womwe unalumikizidwa nawo ku MS Mawu. Zomwe zili mu tchati cholumikizidwa zidzasinthidwa pomwe zosintha / zosintha zikapangidwa ku pepala lakunja momwe amasungidwira. Mawu okha amangosungira komwe fayiloyo ikupezeka, ndikuwonetsa zambiri zomwe zikuphatikizidwa.
Njira yolembera ma chart ndi yofunikira makamaka mukafuna kuphatikiza chidziwitso mu chikalata chomwe simunayang'anire. Izi zitha kukhala deta yomwe munthu wina angayikasinthe ndikofunikira.
1. Dulani tchati kuchokera ku Excel. Mutha kuchita izi ndikakanikiza makiyi. "Ctrl + X" kapena ndi mbewa: sankhani tchati ndikudina "Dulani" (gulu "Clipboard"tabu "Pofikira").
2. Mu chikalata cha Mawu, dinani pomwe mukufuna kukhazikitsa tchati.
3. Ikani tchati pogwiritsa ntchito makiyi "Ctrl + V" kapena sankhani lamulo loyenera pagawo lolamulira: Ikani.
4. Sungani chikalatacho ndi tchati chomwe mwaikamo.
Chidziwitso: Zosintha zomwe mumapanga ku pepala loyambirira la Excel (pepala lakunja) zidzawoneka pomwepo muzolemba za Mawu zomwe mudayika tchati. Kusintha mwatsatanetsatane mukatsegulanso fayilo mutayitseka, muyenera kutsimikizira zosintha za data (batani Inde).
Mwa chitsanzo china, tidasanthula tchati cha Mawu mu Mawu, koma mwanjira iyi mutha kupanga tchati cha mtundu uliwonse, zikhale tchati chokhala ndi mizati, monga momwe zidalili mchitsanzo cha kale, histogram, tchati cholowerera, kapena china chilichonse.
Sinthani kapangidwe ka tchati
Nthawi zonse mutha kusintha mawonekedwe omwe mudapanga mu Mawu. Sikofunikira konse kuwonjezera zinthu mwatsopano, kuzisintha, kuzijambula - pali mwayi wogwiritsa ntchito kapangidwe kake kamakonzedwe, kamene pali mapulogalamu ambiri a Microsoft. Mtundu uliwonse kapena mawonekedwe ake amatha kusinthidwa pamanja ndikusintha malinga ndi zofunikira kapena zofunika, monga momwe mungagwiritsire ntchito ndi gawo lililonse lazithunzi.
Momwe mungagwiritsire ntchito mawonekedwe omalizidwa?
1. Dinani pa tchati chomwe mukufuna kusintha ndikupita pa tabu "Wopanga"ili pa tabu yayikulu "Gwirani ntchito ndi chart".
2. Sankhani tchati chomwe mukufuna kugwiritsa ntchito (gulu Ma chart).
3. Masanjidwe a tchati chanu asintha.
Momwe mungagwiritsire ntchito sitayilo yokonzedwa bwino?
1. Dinani pa tchati chomwe mukufuna kugwiritsa ntchito kalembedwe kotsirizira ndikupita pa tabu "Wopanga".
2. Sankhani mtundu womwe mukufuna kugwiritsa ntchito tchati chanu pagululi. Zojambula Tchati.
3. Zosintha zidzakhudza tchati yanu nthawi yomweyo.
Chifukwa chake, mutha kusintha zojambula zanu, zomwe zimayitanidwa popita, ndikusankha mawonekedwe oyenera ndi kalembedwe, kutengera zomwe zikufunika pakadali pano. Mwachitsanzo, mutha kupanga ma tempuleti osiyanasiyana a ntchito, ndikusintha kuchokera, m'malo mopanga atsopano (Tilankhula za momwe tingasungire tchati monga template pansipa). Mwachitsanzo, muli ndi chithunzi chokhala ndi mizati kapena tchati cha pie, posankha mawonekedwe oyenera, mutha kupanga tchati ndi gawo m'Mawu kuchokera pamenepo.
Momwe mungasinthire mwamtundu wa tchati?
1. Dinani pa chithunzi kapena chinthu chomwe mukufuna kusintha. Izi zitha kuchitika mwanjira ina:
- Dinani paliponse pa tchati kuti mugwiritse ntchito chida. "Gwirani ntchito ndi chart".
- Pa tabu "Fomu"gulu "Chidutswa chapano" dinani muvi pafupi ndi "Ma chart, mutatha kusankha chinthu chomwe mukufuna.
2. Pa tabu "Wopanga", pagululi Ma chart dinani chinthu choyamba - Onjezani Chart Element.
3. Pazosankha zotulukazo, sankhani zomwe mukufuna kuwonjezera kapena kusintha.
Chidziwitso: Zosankha zomwe mwasankha ndi / kapena kusintha zimangogwira gawo lazomwe zidasankhidwa. Ngati mwasankha chithunzi chonse, mwachitsanzo, paramenti "Zolemba Pakatikati" zidzagwiritsidwa ntchito pazonse. Ngati pokhapokha pali mfundo yosankha, zosinthazi zizingochitika zokha.
Momwe mungasinthire mwamphamvu mawonekedwe a tchati?
1. Dinani pa tchati kapena chinthu chomwe mukufuna kusintha.
2. Pitani ku tabu "Fomu" gawo "Gwirani ntchito ndi chart" ndi kuchita zofunikira:
- Kuti mumange fomu yamtundu wosankhidwa, sankhani "Mawonekedwe a chidutswa chosankhidwa" pagululi "Chidutswa chapano". Pambuyo pake, mutha kukhazikitsa njira zoyenera zosinthira.
- Kupanga mawonekedwe, omwe ndi gawo la tchati, sankhani mawonekedwe omwe akufuna mu gulu "Zithunzi Zojambula". Kuphatikiza pakusintha mawonekedwe, muthanso kudzaza mawonekedwe ndi mtundu, kusintha mtundu wa mawonekedwe ake, kuwonjezera zotsatira.
- Kukonza zolemba, sankhani zomwe mukufuna pagululi. Masitayilo a NenoArt. Apa mutha kupereka "Dzazani nkhani", "Zolemba" kapena kuwonjezera zotsatira zapadera.
Kodi mungasunge bwanji tchati ngati template?
Nthawi zambiri zimachitika kuti chithunzi chojambulidwa ndi inu chitha kukhala chofunikira mtsogolo, chimodzimodzi kapena analogue yake, izi sizofunikira kwambiri. Pankhaniyi, ndibwino kupulumutsa tchati monga template - izi zimapangitsa kuti ntchito iziyenda bwino mtsogolo.
Kuti muchite izi, ingodinani tchatili patsamba lolondola la mbewa ndikusankha Sungani Monga template.
Pazenera lomwe limawonekera, sankhani malo omwe mungasunge, tchulani dzina la fayilo ndikudina "Sungani".
Ndizo zonse, tsopano mukudziwa kupanga chithunzi chilichonse m'Mawu omwe ali ophatikizika kapena olumikizidwa, kukhala ndi mawonekedwe osiyana, omwe, mwa njira, amatha kusinthidwa ndikusinthidwa kuti zigwirizane ndi zosowa zanu kapena zofunikira zina. Tikufuna kuti mukhale ndi ntchito yabwino komanso maphunziro ogwira mtima.
