Indlela ukwakha ishedyuli in Excel? Inyathelo ngu step imiyalelo kwabasaqalayo

Namhlanje, iphakheji Microsoft Office ngomnye kwizakhiwo ezininzi ezinamandla, mihla, ukhululekile kunye nemiba ngemiba yezemfundo, nto leyo ethandwa nje kuphela amashishini amakhulu kunye namaziko, kodwa ezilungele ukusetyenziswa ekhaya. Ukusebenza kunye amacandelo ahlukeneyo yempahla, uyakwazi ukwenza iinowuthsi ezilula kunye namaxwebhu itekisi, kwaye iziko ledatha enamandla, apha naphaya ukulungiselela iinjongo ezithile neenjongo.

Microsoft Excel - enye iinkqubo iqukwe kwiphakheji yeenkqubo ezingundoqo ofisi nokubekwa ngokwalo njengendlela spreadsheet. Enyanisweni, Excel - sisixhobo esinamandla ekuvumela ukuba usebenze nje kuphela nemisebenzi esisiseko iqukwe kwiphakheji, kodwa imacros zesikocan - a algorithms ngokukodwa zahlelwa, ezo eqala ukusebenza xa kuthe ipoti ye-sheet okanye incwadi, bonisa okanye ukutshintsha i iseli, ucofe isitshixo elingqinelanayo njl

Enye yezona zinto ilula kwaye ongenantandabuzo Excel nomsebenzi - ukwakhiwa imizekeliso zomzobo kuluhlu olufanelekileyo spreadsheet. Indlela ukwenza igrafu e-Excel? Eyona ndlela ilula kakhulu iyaqondakala, esetyenziswa yi zombini abaqalayo kunye neengcali - Wizard Chart. Fumana i wizard nzima: oko ngomgangatho toolbar, kwaye i icon, nto leyo ebonisa igrafu yezitena. Ukongeza, i-Wizard Chart ingafunyanwa kwi-submenu "Faka» (Excel, uguqulelo 2003) ngokukhetha i icon ahambelanayo.

Emva kokuba usebenzise i Wizard Chart, ukwakha igrafu e-Excel akukho ingxaki! Okokuqala kufuneka ukhethe uhlobo itshathi ukuba ufuna. Ukuxelela ukwakha indlela igrafu ukuze Excel, kubalulekile ukuqaphela ukuba umele ukhethe uhlobo olukwitshati wizard, uze ucofe "Okulandelayo" ngokuya kwinyathelo elilandelayo.

Inyathelo lesibini ikuvumela ukuba ukhethe uluhlu lweeseli eziya kusetyenziswa kwishedyuli wokwakha. Noko ke, ngaphambi kokuba bazobe igrafu ukuze Excel, kubalulekile ukuchonga umgca axis kwaye atyikitye zentsulungeko ezifanelekileyo, leyo ibizwa ngokuba thotho Chart Wizard. Emva kokuba yonke idatha malunga ucwangciso elizayo, kufuneka ucinezele i "Okulandelayo" kwakhona ihamba kwinyathelo elilandelayo.

Inyathelo lesithathu kwinkqubo wokudala umzobo likuvumela ukuba ukuguqula inkangeleko ikamva kwidispleyi igrafikhi yeenkcukacha. Indlela ukuzoba igrafu e-Excel ukubonisa banentsomi, njengoko isicwangciso igridi kunye etafileni data? Yinto elula kakhulu: sonke kufuneka uyazi itshati elizayo kufuneka ukhankanye kwesi sigaba, usuke phakathi tabs ngamnye.

Ngelo yokugqibela Isigaba sesine, Excel umele ukhethe apho ziya kufakwa ukuyila itshati: kwiphepha elahlukileyo okanye i ekhoyo (ingenziwa ngo yaqalwa apho uceba). idayagramu ukwakhiwa Ukugqitywa kwenzeka emva kokuba ucofe isitshixo i "Kwenziwe".

Elokuqukumbela, itshati eliphuma kunokwenzeka kusoloko ukutshintsha igrafu ngenxa uphawulo kwiphepha kunye imizobo iNkosi. Kulo mzekelo, i parameters ukuba wakhetha ekuqaleni ukudala umboniso olubonakalayo lwe data kuya kufuneka ukuba zibhale iwizard. Ungalutshintsha njengoko ufuna.

Ukuqwalasela imbonakalo igrafu onesiphumo, kufuneka sinikele ingqalelo ezenza zonke utshintsho oluyimfuneko kulo mzobo ngenxa kunokuba kabini ebalaselisa kwishedyuli. Ngelo xesha SAS ivula i window "Ifomati Chart Area", apho ukwazi ukwenza naluphi na utshintsho oluyimfuneko.

Ngoko ke, kuyacaca ukuba impendulo yombuzo "Indlela ukwakha ishedyuli e-Excel?» Ngaba ilula kwaye ongenantandabuzo kumsebenzisi kunye naliphi na inqanaba na ikhompyutha. Microsoft Excel - a spreadsheet ekhethekileyo, evumela nkqu mafikizolo ukusebenzisa isixhobo lweenkcukacha enamandla kakhulu.