Pankhani ya kasamalidwe ndi kusanthula deta, Excel yadzikhazikitsa yokha ngati chida chofunikira kwambiri. Mphamvu zake kupanga Ma graph ochita bwino athandizira kwambiri kutchuka kwake komanso zothandiza m'magawo osiyanasiyana. Kwa iwo omwe akufuna kukulitsa luso lawo lopanga ma chart olondola komanso owoneka bwino mu Excel, pali zidule ndi njira zingapo zomwe zingapangitse kusiyana. Kaya tikupanga malipoti aukatswiri, kusanthula mwatsatanetsatane deta, kapena kungowongolera mawonekedwe azidziwitso, nkhaniyi ipereka njira zabwino kwambiri zopangira tchati chantchito mu Excel ndikukulitsa kuthekera kwa chida champhamvuchi. Pansipa, tiwona zinthu zazikulu zomwe ziyenera kuganiziridwa, komanso njira zenizeni ndi malangizo othandiza kuti tipeze zotsatira zabwino.
1. Chiyambi cha Kupanga Ma chart a Ntchito mu Excel
Kupanga ma graph ogwirira ntchito mu Excel ndi chida champhamvu komanso chosunthika chomwe chimakupatsani mwayi wowonera ndi kuwona santhulani deta moyenera. Ma grafu ogwirira ntchito ndi othandiza makamaka pankhani ya sayansi, masamu ndi zachuma, pomwe maubwenzi pakati pa zosintha amafunika kuyimiridwa.
Mu gawo lino, tikutsogolerani. sitepe ndi sitepe Momwe mungapangire ma grafu ogwira ntchito mu Excel. Tiyamba ndi kufotokoza zoyambira za magwiridwe antchito ndi momwe mungasankhire data mu spreadsheet. Kenako, tikuwonetsani momwe mungasankhire ndikusintha mtundu wa tchati woyenera kwambiri pazosowa zanu.
Mu phunziro lonseli, tikhala ndi zitsanzo zothandiza, malangizo ndi zidule kuti mupindule kwambiri ndi zida za Excel. Kuphatikiza apo, tikukupatsani malingaliro amomwe mungawonetsere ma graph momveka bwino komanso moyenera, pogwiritsa ntchito zilembo, nthano ndi zinthu zina zowoneka. Pamapeto pa phunziroli, mudzatha kupanga ndikusintha ma chart anu mu Excel.
2. Momwe mungasankhire deta yoyenera yoyimira ntchito mu Excel
Kuti musankhe deta yoyenera ndikuyimira ntchito mu Excel, ndikofunikira kutsatira njira zingapo zofunika. Choyamba, tiyenera kuzindikira mitundu ya data yomwe ikugwirizana ndi ntchito yathu. Titha kuchita izi podina ndi kukoka mbewa pamaselo omwe ali ndi data yomwe tikufuna kugwiritsa ntchito.
Kenaka, ndi bwino kutsimikizira kuti deta yosankhidwa ikugwirizana ndi mtundu wa ntchito yomwe tikufuna kuimira. Mwachitsanzo, ngati tikugwira ntchito ya masamu, tiyeni tiwonetsetse kuti detayo ndi nambala ndipo ilibe zolakwika kapena zopanda kanthu.
Deta ikasankhidwa, titha kugwiritsa ntchito zida zomwe zilipo mu Excel kuti tiyimire ntchitoyi mowonekera. Njira yothandiza kwambiri ndiyo kupanga ma graph, omwe amalola kuti deta ifufuzidwe momveka bwino ndikuthandizira kutanthauzira kwa ntchitoyo. Titha kusankha mtundu wa graph yoyenera kwambiri pa data yathu, monga ma graph a mzere, ma bar graph, ma graph omwaza, pakati pa ena.
3. Njira zachidule za kiyibodi zofulumizitsa kupanga ma grafu ogwira ntchito mu Excel
Kupanga ma graph ogwirira ntchito mu Excel kumatha kukhala njira yotopetsa komanso yowononga nthawi ngati simugwiritsa ntchito njira zazifupi za kiyibodi. Kuphatikizika kofunikira kumeneku kumatithandiza kufulumizitsa ntchito ndikuchita ntchito zathu moyenera. Pansipa pawonetsedwa njira zazifupi za kiyibodi zomwe zingakuthandizeni kupanga ma chart a Excel mwachangu komanso mosavuta.
1. Selección de datos: Kuti mupange graph yogwira ntchito ku Excel, chinthu choyamba chomwe timafunikira ndikusankha deta yomwe tikufuna kujambula. Kuti tichite mwachangu, titha kugwiritsa ntchito kuphatikiza kiyi Ctrl + Shift + Down Arrow. Kuphatikiza uku kudzatilola kuti tisankhe mwachangu deta yonse yomwe ili pamndandanda.
2. Ikani tchati: Tikasankha deta yomwe tikufuna kujambula, tikhoza kuyika graph pogwiritsa ntchito makina ofunikira Alt + F1. Mukakanikiza makiyi awa, Excel imangopanga tchati chokhazikika kutengera zomwe mwasankha. Ngati tikufuna kuyika tchati chamtundu wina, titha kugwiritsa ntchito kuphatikiza F11 kuti mutsegule bokosi la graphics dialog box.
3. Sinthani tchati: Tikayika tchati mu spreadsheet yathu, titha kusintha pogwiritsa ntchito njira zazifupi za kiyibodi. Mwachitsanzo, ngati tikufuna kusintha mutu wa tchati, titha kusankha mutuwo ndikugwiritsa ntchito kuphatikiza kofunikira Ctrl + 1 kuti mutsegule bokosi la mtundu ndikusintha zofunikira. Momwemonso, titha kugwiritsa ntchito makiyi amivi kuti tisunthire graph mkati mwa spreadsheet ndi makiyi a kukula kuti tisinthe kukula kwake.
4. Momwe mungagwiritsire ntchito masamu a Excel kuti mupange ma grafu ogwira ntchito
Kuti mugwiritse ntchito masamu a Excel ndikupanga ma grafu ogwira ntchito, ndikofunikira kumveketsa bwino mfundo zina ndikutsata njira zina. M'munsimu muli njira zotsatirazi:
1. Sankhani deta: Choyamba, muyenera kusankha deta yomwe mukufuna kugwiritsa ntchito kupanga graph ntchito. Deta ikhoza kukhala iliyonse gulu la maselo ndipo akuyenera kukhala ndi mizati osachepera ziwiri, imodzi yamtengo wa x ndi imodzi yamtengo wa y.
2. Ikani graph: Deta ikasankhidwa, muyenera kupita ku tabu ya "Insert" ndikusankha mtundu womwe mukufuna graph. Excel imapereka mitundu yosiyanasiyana ya ma chart, monga ma chart a mizere, ma bar chart, ma scatter chart, ndi zina zambiri. Sankhani mtundu wa graph yomwe ikugwirizana bwino ndi deta ndi zolinga zowunikira.
3. Sinthani tchati mwamakonda anu: Tchaticho chikalowetsedwa, ndizotheka kuchisintha malinga ndi zomwe wogwiritsa ntchito amakonda. Excel imapereka zosankha kuti musinthe mawonekedwe a nkhwangwa, nthano, mitundu, masitayelo, pakati pa ena. Ndikofunikira kuti mufufuze zosankhazi kuti mupeze chithunzi chowoneka bwino komanso chosavuta kutanthauzira.
5. Kusintha Kwapamwamba kwa Ma chart a Ntchito mu Excel
Pulogalamuyi imalola ogwiritsa ntchito kukulitsa ndikusintha zithunzi zawo kuti zigwirizane ndi zosowa zawo. Kupyolera mu mndandanda wa ntchito ndi zida, ndizotheka kupatsa maonekedwe a akatswiri pazithunzi ndikuwonetsa deta yofunika kwambiri. Pansipa pali maupangiri ndi njira zosinthira makonda a ntchito mu Excel.
1. Sankhani graph yomwe mukufuna kusintha: Choyamba, muyenera kuzindikira graph yomwe mukufuna kusintha. Mutha kuchita izi podina tchati ndikusankha.
2. Sinthani mawonekedwe a tchati: Mukangosankha tchati, mutha kusintha kambirimbiri pamtundu wake. Izi zikuphatikizapo kusintha kukula, mtundu, ndi kalembedwe ka tchati. Mukhozanso kusintha maonekedwe ndi kukula kwa malemba pa tchati.
3. Onjezani zowonjezera pa tchati: Kuti musinthe mwamakonda, mutha kuwonjezera zina patchati. Izi zingaphatikizepo mitu ya axis, zilembo za data, nthano, kapena mizere yamayendedwe. Zinthu izi zithandizira kuwunikira deta yofunika kwambiri mu tchati ndikupangitsa kuti ikhale yowerengeka komanso yosavuta kumvetsetsa.
Kumbukirani kuti pamafunika kuchita khama komanso kuleza mtima. Mutha kufufuza zosankha zosiyanasiyana ndikuyesa masitayelo ndi mawonekedwe osiyanasiyana kuti mupeze mawonekedwe omwe akugwirizana ndi zosowa zanu. Ndi zida zoyenera komanso nthawi yocheperako, mutha kupanga ma chart okongola, okhazikika mu Excel.
6. Maupangiri owongolera mawonekedwe azithunzi za ma grafu ogwirira ntchito mu Excel
Kuwonetseratu kwa ma grafu ogwira ntchito mu Excel ndikofunikira kuti mupereke zambiri momveka bwino komanso moyenera. Nawa maupangiri okuthandizani kukonza mawonekedwe anu:
1. Sankhani mtundu woyenera wa tchati: Musanayambe kupanga graph yanu yogwira ntchito, ndikofunikira kusankha mtundu wa graph womwe umakuyenererani. deta yanu. Excel imapereka zosankha zingapo, monga mzere, mipiringidzo, mizere, ma chart amdera, pakati pa ena. Lingalirani zomwe Ndi yabwino kwambiri mtundu wa graph kuti uimirire deta yanu molondola komanso momveka bwino.
2. Samalirani kukongola kwazithunzi: Kuti tchati chanu chikhale chowoneka bwino komanso chosavuta kuwerenga, tcherani khutu ku zokongoletsa. Gwiritsani ntchito mitundu yosiyana kuti muwunikire zinthu zosiyanasiyana za graph, monga mizere, mipiringidzo kapena mfundo. Onetsetsani kuti zilembo ndi nthano ndizomveka komanso zolumikizidwa bwino. Mutha kuwonjezeranso zinthu zowoneka, monga mitu, nkhwangwa, ndi ma gridi, kuti muwonetse kumveka bwino kwa choyimira.
3. Sinthani tsatanetsatane wa tchati: Excel imakupatsani mwayi wosintha ma graph anu ambiri. Mutha kusintha masikelo a nkhwangwa kuti mutsindike mitundu ina yamitengo, kusintha kukula ndi kalembedwe ka zilembo kuti ziwonekere, kapena kuwonjezera mawonekedwe kapena zithunzi patchati chanu. Khalani omasuka kuti mufufuze makonda omwe Excel amapereka ndikuyesera kuti mupeze zotsatira zabwino kwambiri.
7. Kugwiritsa Ntchito Ma chart a Ntchito mu Excel pa Mathematics Trend Analysis
Ma chart a ntchito mu Excel ndi chida chothandiza kwambiri pakuwunika masamu. Ma grafu awa amalola maubwenzi pakati pa zosinthika kuti aziyimiridwa mowonekera, kuwonetsa kusintha kwa ntchito pakanthawi kochepa. Ndi Excel, ndizotheka kupanga ma graph ogwirira ntchito mosavuta komanso mwachangu, kupangitsa kukhala kosavuta kuphunzira masamu.
- Kuti mugwiritse ntchito ma chart mu Excel, chinthu choyamba muyenera kuchita ndikukhala ndi data yomwe mukufuna kuyimilira mu spreadsheet. Mutha kuyika zambiri m'maselo a Excel kapena kuyitanitsa kuchokera ku fayilo ina.
- Kenako, sankhani zomwe mukufuna kuyimira pa graph yogwira ntchito. Mutha kuchita izi pokokera cholozera pamaselo omwe ali ndi data.
- Data ikasankhidwa, pitani ku tabu ya "Insert". chida cha zida Excel ndikudina mtundu wa tchati chomwe mukufuna kugwiritsa ntchito. Mutha kusankha pakati pamitundu yosiyanasiyana yamatchati, monga mzere, mzere, kufalitsa, pakati pa ena.
Mukangopanga tchati chantchito mu Excel, mutha kusintha makonda kuti muwonetsetse bwino komanso molondola kwambiri. Mutha kusintha nkhwangwa, mitu, mitundu, ndi zina za tchati.
- Kuti musinthe nkhwangwazo, dinani pomwepa ndikusankha "Format Axis". Apa mutha kusintha ma intervals, malire ndi zinthu zina zokhudzana ndi nkhwangwa.
- Kuti musinthe mitu yamatchati, dinani pomwepa ndikusankha "Sinthani mawu". Mukhoza kusintha malemba, kukula, mtundu ndi zina za maudindo.
- Kuti musinthe mitundu ya tchati, dinani kumanja pagawo limodzi la tchati ndikusankha "Format Series". Apa mutha kusankha pakati pa mitundu yosiyanasiyana ndi masitayilo amtundu uliwonse wa data.
Ma chart a ntchito mu Excel ndi chida champhamvu chowunikira masamu. Kugwiritsa ntchito moyenera kumakupatsani mwayi wowonera bwino ndikumvetsetsa machitidwe a masamu. Kumbukirani kuti mutha kuyesa mitundu yosiyanasiyana yamatchati ndikusankha mwamakonda kuti mupeze zotsatira zomwe mukufuna.
8. Momwe Mungawonjezere Zolemba ndi Nthano Pama chart a Ntchito mu Excel
Kuti muwonjezere zilembo ndi nthano kuti mugwiritse ntchito ma chart mu Excel, tsatirani izi:
1. Sankhani tchati chomwe mukufuna kuwonjezera zilembo ndi nthano.
2. Pitani ku tabu ya "Design" pa toolbar ya Excel.
3. Dinani batani la "Add Item" ndikusankha "Data Labels" kuti muwonjezere zilembo pamfundo iliyonse patchati.
4. Kuti muwonjezere nthano pa tchati, dinani kumanja pa malo a tchati ndikusankha njira ya "Add Legend".
5. Sinthani zilembo ndi nthano mogwirizana ndi zomwe mumakonda, monga kusintha malo, kukula kapena mawonekedwe.
Kutsatira izi kukuthandizani kuti muwonjezere zolemba ndi nthano mosavuta pama chart anu a Excel. Izi ndizothandiza powunikira mfundo zazikuluzikulu muzowonetsa zanu ndikupangitsa kuti zomwe zaimiridwa pazithunzizo zikhale zosavuta kumva. Yesani ndi zolemba zosiyanasiyana ndi mawu omasulira kuti mupange zowoneka bwino komanso zaluso!
9. Kugwiritsa ntchito Excel's Solver Tool Kusintha Ma Parameters a Ntchito pa Tchati
Kugwiritsa ntchito chida cha Excel Solver ndi a njira yothandiza ya kusintha magawo a ntchito pa graph. Solver ndi chowonjezera cha Excel chomwe chimakupatsani mwayi wopeza kufunikira kwa cell yomwe mukufuna kusintha posintha masinthidwe osinthika. Pankhani ya graph, izi zikutanthauza kuti tikhoza kusintha magawo a ntchito kuti agwirizane bwino ndi deta yomwe ikuimiridwa.
Kuti tigwiritse ntchito Solver mu Excel, choyamba tiyenera kukhala ndi graph yokhala ndi ntchito yodziwika komanso data yofananira. Kenako, tiyenera kusankha selo lomwe tikufuna kukulitsa, ndiye kuti, lomwe limayimira phindu lomwe tikufuna kukulitsa kapena kuchepetsa. Kenako, timafotokozera zosinthika zomwe tikufuna kusintha kuti tipeze zotsatira zomwe tikufuna. Izi zikhoza kukhala, mwachitsanzo, mtengo wa coefficient kapena malo omwe ntchitoyo ikufika pamlingo waukulu kapena wocheperapo.
Titafotokozera zosintha zonse ndikusintha magawo awo, titha kuthamanga Solver. Izi zisanthula mitundu yosiyanasiyana yamitundu yosinthika ndikupeza seti yoyenera yomwe imakwaniritsa zoletsa zomwe zakhazikitsidwa. Ndikofunika kudziwa kuti Solver sadzatha kupeza yankho labwino nthawi zonse, makamaka ngati pali zovuta kapena mayankho angapo. Pazifukwa izi, titha kusintha magawo a Solver kuti tifufuze zosankha zosiyanasiyana ndikupeza zotsatira zabwino kwambiri.
10. Momwe Mungagwiritsire Ntchito Ntchito ya "Trend" ya Excel kulosera zamtengo wapatali pa tchati chogwira ntchito.
Ntchito ya "Trend" ya Excel ndi chida champhamvu chomwe chimatithandizira kuneneratu zamtsogolo pa tchati chantchito. Izi zimatengera njira yobwereranso pamzere ndipo imagwiritsa ntchito deta yomwe ilipo kale kuwerengera mzere womwe ungapitirire mtsogolo. Pansipa ndikuwonetsani momwe mungagwiritsire ntchito gawoli pang'onopang'ono kuti mulosere zolondola pama chart anu.
1. Chinthu choyamba chimene muyenera kuchita ndikusankha deta yomwe mukufuna kugwiritsa ntchito kuti muwerengere mzere wamayendedwe. Izi ziyenera kukonzedwa m'mizati iwiri: imodzi yamtengo wa X (zolowera) ndi ina ya Y (zotulutsa zomwe mukufuna kulosera). Onetsetsani kuti deta yakonzedwa motsatizana komanso motsatizana.
2. Mukasankha deta, pitani ku tabu ya "Insert" pa toolbar ya Excel ndikudina "Chati." Sankhani mtundu wa tchati womwe mungakonde (mzere, kuwaza, ndi zina) ndikudina "Chabwino." Onetsetsani kuti ma axes a graph akuwonetsa molondola zomwe zalowetsedwa ndi zotuluka.
3. Tsopano, dinani pomwe pa tchati ndi kusankha "Add Trend Line" njira ku dontho-pansi menyu. Pazenera lomwe likuwoneka, sankhani tabu "Zosankha" ndipo yang'anani bokosi la "Show equation on graph". Izi zikuwonetsani equation ya mzere wamayendedwe pa graph, pamodzi ndi coefficient of determination (R squared) mtengo, zomwe zimasonyeza momwe mzerewo ukugwirizanirana bwino ndi deta.
11. Kufunika kwa kusankha kolondola kwa nkhwangwa ndi sikelo mu ma graph a ntchito mu Excel
Chimodzi mwamakiyi opangira ma grafu ogwira ntchito mu Excel ndikuwonetsetsa kuti mwasankha nkhwangwa ndi sikelo yoyenera. Izi ndizofunikira kuti zitsimikizire kuti deta ikuimiridwa momveka bwino komanso molondola, kupewa chisokonezo ndi kutanthauzira molakwika. M'chigawo chino, tiwona kufunikira kopanga zisankho mwanzeru za nkhwangwa ndi makulitsidwe, komanso momwe tingachitire molondola.
Choyamba, ndikofunikira kumvetsetsa kuti nkhwangwa ndi zinthu zomwe zimatanthauzira mawonekedwe a graph. Amakulolani kuti muwonetse milingo yomwe deta imapezeka, ponse pawiri (X) ndi ofukula (Y) axis. Posankha nkhwangwa, muyenera kuganizira mozama zamitundu yomwe ikuyenera kuyimiridwa ndikuwonetsetsa kuti ndiyokwanira kuwonetsa kusinthasintha kwa data. Kuonjezera apo, ndi bwino kugwiritsa ntchito nkhwangwa zomwe zimayambira pa zero, chifukwa izi zimapewa kupotoza kowoneka ndikuwonetsetsa kuyimira kolondola kwa deta.
Ponena za sikelo, ndikofunikira kusankha imodzi yomwe ikugwirizana bwino ndi kuchuluka kwa data. Ngati zikhalidwe zili pafupi kwambiri, zitha kukhala zothandiza kugwiritsa ntchito sikelo yofananira kuti muwonetse kusiyana kwake. Kumbali inayi, ngati zikhalidwezo zikukulirakulira kwambiri, pangakhale kofunikira kugwiritsa ntchito sikelo ya logarithmic kuti muwone bwino zosinthikazo. Momwemonso, ndikofunikira kupewa kugwiritsa ntchito masikelo osagwirizana kapena osagwirizana, chifukwa amatha kupotoza chithunzicho ndikupangitsa kutanthauzira kwa data kukhala kovuta.
12. Momwe Mungagawire ndi Kutumiza Ma chart a Ntchito mu Excel
Mukagawana ndi kutumiza ma graph a ntchito ku Excel, pali zosankha zingapo zomwe zingakuthandizeni kuwonetsa zotsatirazo momveka bwino komanso zomveka. Kenako, tikuwonetsani njira zosiyanasiyana zogawana ndikutumiza kunja zithunzi zanu:
1. Gawani zojambulazo mwachindunji kuchokera ku Excel: Excel imakupatsani mwayi wogawana zithunzi zanu mwachangu komanso mosavuta. Ingosankhani tchati chomwe mukufuna kugawana ndikugwiritsa ntchito njira ya "Gawani" mumndandanda wazida. Mutha kugawana nawo kudzera pa imelo, malo ochezera a pa Intaneti u mapulogalamu ena utumiki wa kutumiza makalata.
2. Tumizani kunja zithunzizo ngati zithunzi: Excel imakupatsaninso mwayi kuti mutumize ma chart anu ngati zithunzi, kuwapangitsa kukhala osavuta kuyika muzolemba kapena mawonetsero. Kuti muchite izi, sankhani tchati ndikupita ku tabu "Fayilo". Kenako, sankhani njira ya "Sungani Monga" ndikusankha mtundu womwe mukufuna, monga JPEG kapena PNG. Izi zipanga kopi ya graph yanu mumtundu wazithunzi zomwe mungagwiritse ntchito mapulogalamu ena.
3. Koperani ndi kumata zojambulazo mu mapulogalamu ena: Njira ina ndikukopera graph yogwira ntchito mu Excel ndikuyiyika mu mapulogalamu ena monga Mawu kapena PowerPoint. Kuti muchite izi, sankhani tchati, dinani kumanja ndikusankha "Koperani." Kenako, tsegulani pulogalamu yomwe mukufuna kuyika tchaticho ndikugwiritsa ntchito njira yophatikizira. Chithunzicho chidzayikidwa ngati chithunzi chosinthika mu pulogalamu yosankhidwa.
13. Kukonza Mavuto Odziwika Popanga Ma chart a Ntchito mu Excel
Ngati mukukumana ndi zovuta kupanga ma chart a Excel, musadandaule, muli pamalo oyenera. M'munsimu muli njira zothetsera mavutowa ndikupangitsa kuti zithunzi zanu zizigwira ntchito bwino.
1. Tsimikizirani deta yanu: Chinthu choyamba chimene muyenera kuchita ndikuonetsetsa kuti deta yanu yalowetsedwa bwino mu Excel. Onetsetsani kuti mizati ndi mizere yasanjidwa bwino komanso kuti deta ikufanana. Komanso, onetsetsani kuti palibe maselo opanda kanthu kapena deta yolakwika yomwe ingakhudze kupanga ma graph.
2. Gwiritsani ntchito ntchito yoyenera: Excel imapereka ntchito zosiyanasiyana kuti mupange ma chart, monga mzere, mzere, mipiringidzo, ndi ma chart chart, pakati pa ena. Onetsetsani kuti mwasankha ntchito yoyenera ya mtundu wanu wa data ndi zotsatira zomwe mukufuna kupeza. Mutha kupeza maphunziro ndi zitsanzo pa intaneti kuti zikuthandizeni kusankha chinthu choyenera ndikuchigwiritsa ntchito moyenera.
14. Mapeto ndi malingaliro omaliza opangira ma chart abwino kwambiri mu Excel
Pomaliza, kupanga ma chart abwino kwambiri mu Excel kumafuna kutsatira njira zingapo zofunika. Choyamba, ndikofunikira kusankha deta yoyenera kuti iwonetsere pa graph ntchito. Izi zimaphatikizapo kuzindikira zosintha zodziyimira pawokha komanso zodalira zomwe mukufuna kuzisanthula. Kenako, izi ziyenera kukonzedwa moyenera patebulo la Excel.
Deta ikakonzedwa bwino, mutha kupitiliza kupanga tchati chantchito mu Excel. Chida chachikulu cha izi ndi ntchito ya "Insert Chart" yomwe Excel imapereka. Kupyolera mu izi, mitundu yosiyanasiyana ya ma chart, monga mizere, mipiringidzo, kapena ma scatter charts, ingasankhidwe malinga ndi zosowa za kusanthula.
Pomaliza, kuti mupeze ma chart abwino kwambiri mu Excel, ndikofunikira kusintha ndikusintha mawonekedwe a tchati. Izi zimaphatikizapo kusintha nkhwangwa, kuwonjezera mitu ndi nthano, kusintha masikelo ndi mafonti, pakati pa zosankha zina zamasanjidwe. Kuchita izi kumawongolera mawonekedwe a graph ndikupangitsa kuti deta ikhale yosavuta kutanthauzira.
Mwachidule, kupanga tchati chantchito mu Excel kungakhale ntchito yosavuta potsatira zanzeru zina zabwino. Pogwiritsa ntchito ntchito zomwe zamangidwa, monga momwe ma graph amagwirira ntchito, ndikuwongolera magawo, titha kupeza mawonekedwe omveka bwino komanso olondola a ntchito zathu zamasamu.
Ndikofunika kukumbukira kufunikira kosankha mosamala deta yolowera ndikuyika nkhwangwa zoyenera. Kuphatikiza apo, kusintha zokongoletsa monga mitundu ndi zilembo zimathandizira kuti tchaticho chiwerengedwe.
Kaya ndi cholinga cha maphunziro, kafukufuku kapena kuwonetsera, luso lopanga graph yogwira ntchito mu Excel kudzapereka phindu linalake la ntchito yathu ndipo kudzatilola kulankhulana bwino ndi zomwe tikufuna kupereka.
Pomaliza, ndi kuphatikiza luso laukadaulo komanso kumvetsetsa bwino masamu, titha kugwiritsa ntchito Excel ngati chida champhamvu chopangira ma graph ogwirira ntchito. bwino ndi akatswiri. Chifukwa chake musazengereze kugwiritsa ntchito zanzeru izi ndikupeza zotsatira zowoneka bwino pamapulojekiti anu otsatira. Manja kuntchito Tsopano pangani ma graph abwino kwambiri mu Excel!
Ndine Sebastián Vidal, mainjiniya apakompyuta omwe amakonda ukadaulo komanso DIY. Komanso, ine ndine mlengi wa tecnobits.com, komwe ndimagawana nawo maphunziro kuti ukadaulo ukhale wofikirika komanso womveka kwa aliyense.