Ungayenza kanjani ishadi le-gantal e-Excel

Phakathi kobuningi bemidwebo, engakhiwa kusetshenziswa uhlelo lwe-Microsoft Excel, kufanele ukhethe ikakhulukazi i-Gnta ishadi. Ishadi elivundlilelontalo yekholomu, kwi-axis evundlile lapho umugqa wesikhathi utholakala khona. Ngalo, kulula kakhulu ukubala nokukhomba izingxenye zesikhashana. Ake sibheke ukuthi singakha kanjani ishadi le-ganta e-Excel.

Ukwakha ishadi le-gantal e-Excel

Khombisa izimiso zokwenza ishadi le-Gntart lihamba phambili kusibonelo esithile.

1. Sithatha itafula labasebenzi bamabhizinisi, lapho usuku lokukhululwa kwabo eholidini kanye nenani lamaholide afanele libonisiwe. Ngendlela yokusebenza, kuyadingeka ukuba nekholomu lapho amagama abasebenzi angenalungelo khona, ngaphandle kwalokho isihloko kufanele sisuswe.



2. Okokuqala sakha umdwebo. Ukuze senze lokhu, sabela indawo yetafula, ethathwa njengesisekelo ekwakhiweni. Iya kuthebhu ethi "Faka" bese uqhafaza inkinobho ethi "Line-" etholakala ethepheni. Uhlu lwezinhlobo zemidwebo yomugqa ovelayo, khetha noma yiluphi uhlobo lweshadi ngeqongelela. Ake sithi esimweni sethu kuzoba uhlelo lwenqwaba ngokuqongelela.



3. Ngemuva kwalokho, i-Excel izokwakha lo mdwebo.



4. Manje kudingeka senze umugqa wokuqala ongabonakali we-Blue ukuze isikhathi sesikhathi samaholide sihlala kumdwebo. Qhafaza kwesokudla kunoma iyiphi indawo eluhlaza okwesibhakabhaka yalo mdwebo. Kumenyu yokuqukethwe, khetha "Ifomethi yohlobo lwedatha ...".



5. Iya esigabeni esithi "Gcwalisa", sibeka i-switch ephuzwini le- "NO Gcwalisa" bese uchofoza inkinobho ethi "Vala".



6. Imininingwane emyalisweni itholakala ngaphansi phezulu, okungeyona elula kakhulu yokuhlaziywa. Sizozama ukukulungisa: Ngokuchofoza inkinobho efanele yegundane eduze kwe-eksisi, lapho amagama abasebenzi akhona. Kumenyu yokuqukethwe, dlula entweni ethi "Axis Format".



7. Ngokuzenzakalelayo, siwela esigabeni "amapharamitha we-axis", lapho sibeka khona umkhaza obhekene ne- "reverse oda yezigaba" bese uqhafaza u- "Vala".



8. Inganekwane ayidingeki emjovo weGanta. Ukuyikhipha, khetha inkinobho yegundane nge-Click Chart bese ucindezela ukhiye wokususa kwikhibhodi.



9. Njengoba sibona, isikhathi esihlanganisa ishadi lingaphezu kwemingcele yonyaka wekhalenda. Ungavumela isikhathi sonyaka kuphela noma yisiphi esinye ingxenye yengxenye ngokuchofoza kwi-eksisi lapho kubekwa khona izinsuku. Kumenyu evela, khetha ipharamitha ye- "axis format".



10. Kuthebhu ye- "Axis Parameners" eduze kwezilungiselelo "Inani elincane" ne "Value Mantrue", sihumusha ukushintshwa kwemodi "ye-Auto" kumodi "elungisiwe" kwimodi "elungisiwe" kwimodi "elungisiwe" kwimodi "elungisiwe" kwimodi "elungisiwe" kwimodi "elungisiwe" kwimodi "elungisiwe" kwimodi "elungisiwe" kwimodi "elungisiwe" kwimodi "elungisiwe" kwimodi "elungisiwe" kwimodi "elungisiwe" kwimodi "elungisiwe" kwimodi "elungisiwe". Sibeka amanani ezinsuku emafasiteleni ahambisanayo esiwadingayo. Masinyane, uma ufisa, ungabeka intengo yokuhlukaniswa okuyisisekelo nokuphakathi. Iwindi lingavalwa.



11. Ukuqedela ukuhlela kweshadi le-gantta, kusalokhu kuza negama lakhe. Iya kuthebhu ethi "Layout" bese uqhafaza inkinobho ethi "Isihloko se-DIAGRAM". Uhlu oluvelayo, khetha inani "ngaphezulu komdwebo."



12. Ensimini lapho kwavela khona igama, faka noma yiliphi igama elifanele, elifanelekile ngencazelo.



13. Vele, futhi ungaqhuba ukuhlela okwengeziwe komphumela otholwayo, okwenza kube nezidingo zakho nokunambitheka, cishe ku-infinity, kepha jikelele ishadi le-gantta selilungile.



Ngakho-ke, njengoba sibona, ukwakhiwa kweshadi leGanta akunzima kangako, njengoba kubonakala ekuqaleni. I-algorithm echazwe ngenhla ingasetshenziswa hhayi kuphela ukuthi i-accounting kanye nokuhlola amaholide, kodwa futhi nokuxazulula eminye imisebenzi eminingi.