Chimodzi mwa zigawo zofunikira za kusanthula kulikonse ndikutulukira njira yaikulu ya zochitika. Pokhala ndi deta izi, mukhoza kupanga chitukuko cha chitukuko china. Izi zikuwonekera makamaka mu chitsanzo cha mzere wazithunzi pa tchati. Tiyeni tione momwe tingamangire mu Microsoft Excel.
Mzere wamakono ku Excel
Ntchito ya Excel imapereka mphamvu yokhala ndi mzere wogwiritsa ntchito grafu. Pa nthawi yomweyi, deta yoyamba yomwe imapangidwira imachokera ku tebulo lomwe lapangidwa kale.
Plotting
Pofuna kumanga grafu, muyenera kukhala ndi tebulo lokonzekera, pogwiritsa ntchito yomwe idzakhazikitsidwe. Mwachitsanzo, tengani deta pa mtengo wa dola mu ruble kwa nthawi inayake.
- Timamanga tebulo, pomwe pamtundu umodzi padzakhala nthawi (mmalo mwathu, masiku), ndi zina - mtengo, mphamvu zomwe zidzawonetsedwe pa graph.
- Sankhani tebulo ili. Pitani ku tabu "Ikani". Kumeneko pa tepiyi mu chida cha zipangizo "Zolemba" dinani pa batani "Ndondomeko". Kuchokera pa mndandanda womwe waperekedwa, sankhani njira yoyamba yoyamba.
- Pambuyo pake, ndondomekoyi idzamangidwa, koma iyenera kupitsidwanso patsogolo. Pangani mutu wa tchati. Kuti muchite izi, dinani pa izo. Mu gulu la tabu lomwe likuwonekera "Kugwira Ntchito ndi Mphatso" pitani ku tabu "Kuyika". Momwemo timatsinkhani pa batani. "Dzina lachati". M'ndandanda yomwe imatsegula, sankhani chinthucho "Pamwamba pa tchati".
- M'munda umene umapezeka pamwamba pa graph, lowetsani dzina lomwe timaganiza kuti ndiloyenera.
- Kenako timasaina zipilala. M'mabuku omwewo "Kuyika" Dinani pa batani pambali "Mayina a axis". Squentially timapita pamwamba pa mfundozo "Dzina lachinthu chachikulu cholumikizira" ndi "Mutu pansi pa".
- M'munda womwe umapezeka, lowetsani dzina lazitali, molingana ndi zomwe zili pa deta yomwe ilipo.
- Kuti tipeze dzina la zowonongeka timagwiritsanso ntchito tabu "Kuyika". Dinani pa batani "Dzina la axis". Sequentially ayendetsedwe kupyolera muzowonjezera zinthu zamkati. "Dzina la chingwe chowongolera" ndi "Yatchulidwa". Mtundu wotere wa dzina lokha lidzakhala loyenera kwambiri kwa mtundu wathu wa zithunzi.
- M'munda wa dzina lolowera liwoneka, lowetsani dzina lofunika.
Phunziro: Momwe mungapangire grafu ku Excel
Kupanga mzere mzere
Tsopano mukufunika kuwonjezera mwatsatanetsatane mzerewu.
- Kukhala mu tab "Kuyika" dinani pa batani "Mzere wazotsatira"yomwe ili mu chida chogwiritsa ntchito "Kusanthula". Kuchokera pandandanda yomwe imatsegulira, sankhani chinthucho "Zonenedwa Zophatikiza" kapena "Kuwerengera kwachilendo".
- Pambuyo pake, mndandanda wa mzerewu wawonjezeredwa ku tchati. Mwachinsinsi, ndi wakuda.
Kukhazikitsa mzere wamakono
Pali kuthekera kwazowonjezera mzere wa mzere.
- Pitani mosapita ku tab "Kuyika" pa zinthu zamkati "Kusanthula", "Mzere wazotsatira" ndi "Advanced Trend Line Options ...".
- Fenje lazenera likuyamba, mukhoza kupanga machitidwe osiyanasiyana. Mwachitsanzo, mungasinthe mtundu wa kupatsa ndi kuyerekezera mwa kusankha imodzi mwa mfundo zisanu ndi imodzi:
- Chiwonongeko;
- Mzere;
- Mphamvu;
- Logarithmic;
- Zowonetsera;
- Kujambula kwapadera.
Kuti tipeze kudalirika kwa chitsanzo chathu, ikani Chongani pafupi ndi chinthucho "Ikani pa chithunzi chofunika cha kulondola kwa kuyerekezera". Kuti muwone zotsatira, dinani pa batani. "Yandikirani".
Ngati chizindikiro ichi ndi 1, ndiye chitsanzo ndi chodalirika momwe zingathere. Kutalika mlingo kuchokera ku unit, osakhudzidwa pang'ono.
Ngati simukukhutira ndi msinkhu wodalirika, mukhoza kubwereranso ku magawo ndikusintha mtundu wa kufatsa ndi kuyerekezera. Kenaka, pangani coefficient kachiwiri.
Kutchulidwa
Ntchito yaikulu ya mzerewu ndi mphamvu yokonzekera zowonjezereka.
- Apanso, pitani ku magawo. Mu bokosi lokhalamo "Chiwonetsero" m'madera oyenerera, timasonyeza kuti nthawi zingapo kapena zammbuyo tikuyenera kupitiliza njira yoyenera kulongosola. Timakanikiza batani "Yandikirani".
- Apanso, pitani ku ndandanda. Zimasonyeza kuti mzerewu ndi wochepa. Tsopano ikhoza kugwiritsidwa ntchito kuti mudziwe kuti chiwerengero choyenera chiti chidzanenedweratu kwa tsiku lina pamene mukusunga zomwe zikuchitika.
Monga mukuonera, mu Excel sizowonjezera kumanga mzere wotsatira. Purogalamuyi imapereka zipangizo kuti zikonzedwe kuti zisonyeze zizindikiro molondola. Malinga ndi ndondomeko, mukhoza kupanga nthawi yeniyeni.
