Kanjani ukwakha schedule Excel? Step by step imiyalelo Wabasaqalayo

Namuhla, iphakethe-Microsoft Office ingenye izakhiwo enamandla kakhulu, yesimanje, ukhululekile futhi Amatebhe, okuyinto ethandwa, hhayi nje kuphela amabhizinisi ezinkulu kanye izikhungo, kodwa enh ukusetshenziswa ekhaya. Ukusebenza izingxenye ezihlukahlukene iphakethe, ungakha amanothi elula amadokhumenti wombhalo, futhi database enamandla, ingashintshwa ukuze imigomo eqondile kanye nezinhloso.

UHlelo Lokungena Emibikweni Ye - omunye izinhlelo kufakwe iphakethe izinhlelo eziyisisekelo ehhovisi futhi Positioning ngokwaso njengoba isipredishithi. Eqinisweni, i-Excel - ithuluzi elinamandla evumela ukuthi ukusebenza nje kuphela imisebenzi eyisisekelo kufakwe iphakethe, kodwa amamakhro - a algorithm zahlelwa ngokukhethekile, okuyinto isiqala ukusebenza uma kwenzeka kusebenze ishidi noma incwadi, gqamisa noma ukushintsha cell, ngokucindezela ikhi ehambisana ne njll

Esinye sezici elula kakhulu futhi enembile Excel umsebenzi - ukwakhiwa imifanekiso womfanekiso ezifanele zespredishithi. Indlela yokwenza igrafu Excel? Indlela elula futhi kuyaqondakala kakhulu indlela, okuyinto esetshenziswa kokubili Wabasaqalayo kanye nezifundiswa - Wizard Ishadi. Thola wizadi akunzima: ke esezingeni yamathuluzi, futhi ine isithonjana, elibonisa igrafu ibha. Ngaphezu kwalokho, Iseluleki Ishadi zingatholakala nge menyu engaphansi "Faka» (Excel, inguqulo 2003) ngokukhetha isithonjana esihambisanayo.

Ngemva ugijima Iseluleki Ishadi, ukwakha igrafu Excel akukho enkingeni! Okokuqala udinga ukhethe uhlobo ishadi ukuthi okudingayo. Ukutshela indlela yokwakha igrafu ku-Excel, kubalulekile ukuphawula ukuthi kumelwe ukhethe uhlobo ishadi e wizadi, bese ucindezela u- "Okulandelayo" ngokuya esinyathelweni esilandelayo.

Isinyathelo sesibili ikuvumela ukuba ukhethe ibanga lamaseli ezizosetshenziselwa kule sheduli ukwakhiwa. Nokho, ngaphambi kokuba siyihlole ukudweba igrafu ku-Excel, kubalulekile ukukhomba umugqa ahlangene ngemvume amagugu efanele, ababiziweyo Ishadi Iseluleki chungechunge. Ngemva yonke idatha mayelana isheduli esizayo, kufanele ucindezela "Okulandelayo" waphinda ukuthuthela esinyathelweni esilandelayo.

Isinyathelo sesithathu ku inqubo yokudala kulombhalo ikuvumela ukuba aguqule ukubukeka ikusasa umfanekiso idatha isibonisi. Udweba kanjani igrafu Excel ukubonisa inganeko, njengoba kulungiselelwa igridi kanye ithebula ledatha? Kulula kabi: konke okudingayo ukuze ukwazi ishadi esizayo kumele icacise kulesigaba, ukushintsha phakathi kwamathebhu ngabanye.

Ngesikhathi yokugcina esigabeni sesine, i-Excel yenza ukuba ukhethe lapho izokwenziwa ukuze udale ishadi: ku Thatha iphe- noma ekhona (Hhayi lapho eceba uqalwe). ukwakhiwa Ukugcwaliswa umdwebo kwenzeka emva ngokucindezela "Kwenziwe" Ukhiye.

Ekuphetheni, ishadi okuholela uhlale ukushintsha igrafu okuholela egqamisa kucecevu nangesandla imidvwebo Master. Kulokhu, nemingcele ukuthi ukhethe ekuqaleni ukwakha ukubonisa sokuqhafaza idatha kuyodingeka ukuba ubonise wizadi. Ungashintsha kubo njengoba okudingayo.

Uma ucabangela ukubukeka igrafu okuholela, kufanele sinake ezenza lonke ushintsho oludingekayo kulombhalo okuholela kungaba kabili egqamisa schedule. Ngesikhathi esifanayo SAS sivula iwindi "Ifomethi Ishadi Area", lapho ungakwazi wenze izinguquko ezidingekayo.

Ngakho, kusobala ukuthi impendulo yombuzo othi "Indlela ukwakha schedule Excel?» Ingabe elula enembile umsebenzisi nanoma yimuphi ezingeni ikhompyutha. UHlelo Lokungena Emibikweni Ye - isipredishithi esiyingqayizivele, okuvumela ngisho imfundamakhwela ukusebenzisa enamandla kakhulu idatha ukucutshungulwa ithuluzi.