Indlela yokwakha imifanekiso? Excel!

Naliphi na inkqubo ebomini bethu, enye indlela okanye enye, inxulumene namanani. Kwiyeza, sibona izikhombisi zeenombolo, ekudleni sibalwa inani leekhalori, kwinto esicinga ngayo ukuqhubeka nokunye njalo.

Ngokuqhelekileyo, iigrafu zisetyenziselwa ukujonga utshintsho oluninzi. Ziyakuvumela ukuba ubone ngokubonakalayo inkqubo yenani.

Ukusebenza ngamatshathi, isicelo seofisi ye-Excel sikulungele kakhulu. Kulula kakhulu ukwakha isati e-Excel . Akukho mlawuli, ipen, ababala, okanye iipensele ezilula ezifunekayo. Kuwe, yonke into izakwenza lula ikhompyutha.

Ngoko, ukuba uyazibuza indlela yokwakha imifanekiso kwi-Excel, khangela umbuzo kule nqaku.

Ngaphambi kokuba udale ishati kwi-Excel 2010 okanye kwi-Excel 2003, kufuneka uvule iphepha elingenanto. Njengomthetho, ngokuzenzakalelayo igama lefayile engenanto kule nkqubo "Book1".

Senza le miyalelo yeelandelayo:

Qala iqhosha (ikhoneni elingezantsi lasekhohlo liso), Zonke uluhlu lweenkqubo ezifakiwe, iMicrosoft Office, Excel.

Umsebenzi wokuqala ugqityiwe.

Isinyathelo esilandelayo kukudala ifom yefayili yedatha yokubonisa imifanekiso. Yenza itafile, faka iinkcukacha ezifunekayo kuyo, iintloko kunye neikholomu.

Isinyathelo sesibini sigqityiwe.

Kwaye ngoku, ngombuzo wakho malunga nendlela yokwakha imifanekiso kwi-Excel, "iWeb Wizard" iya kuphendula, okufuneka uyibize kwibar yamathuluzi. Ukwenza oku, nqakraza kula maqhosha alandelayo: Faka, Ishadi ...

IWizard izakhela lula nayiphi na isati okanye i-histogram, efuna amanyathelo amane kuphela.

Masiqale.

Isigaba sokuqala.

Kule meko, ucelwa ukuba ukhethe uhlobo lwetati elizayo. Iindidi zezikhetho ziyamangalisa: indawo, ipramramidal, bubble, kunye neendawo, i-petal, njl. Ifom yokwakhiwa kwexesha elizayo linokujongwa kwibhokisi yebhokisi yencoko, kwisiqingatha esifanelekileyo.

Isigaba sesibini.

Isigaba somsebenzi weDarikhi. Apha ufanele ukhethe iimetriki zeesati ezayo. Ukwenza oku, khetha itafile yedata edalwe ngaphambili. Kwinqanaba elifanayo, amagama omxholo anikezelwa.

Isigaba sesithathu.

Ubukhulu kakhulu ekusebenzeni. Kuya kukukhokelela kwimpendulo kumbuzo wendlela yokwakha imifanekiso kwi-Excel eyona nto ifundisa. Ukuzaliswa okuchanekileyo, masihambe kwiithebhu.

1. Umxholo. Udibanisa iilebula zomqolo kwimida yetshathi okanye, ngokuchaseneyo, isusa ezikhoyo.
2. Imida yegridi. Ikuvumela ukuba ungeze okanye ususe imigca ephakathi kunye neyona siseko.
3. Iimpawu. Ukhetha uhlobo lwe-axis.
4. Izihloko. Icacisa amagama e-axis nganye yetshathi.
5. Itafile yedatha. Ukongeza okanye ukususa itheyibhile ngamanani enani, ngesiseko apho ukwakhiwa kwendawo ehambelana nayo.
6. Iinkcazo zeenkcukacha. Ubonisa uphawu ngalunye lwegrafu (umgca, uluhlu, ixabiso).

Isigaba sesine.

Okokugqibela. Kuyo, "I-Wizard yokwakha" iya kukunika ukhetho lwendawo yetshathi ezayo. Kukho iindlela ezimbini ongakhetha kuzo: kwiphepha elikhoyo (kunye nombhalo kunye netafile yeenombolo) okanye kwiphepha elitsha elicocekileyo.

Emva kwamanyathelo amane omsebenzi we-"Charting Wizard" agqityiweyo, zikhululeke ukucofa iqhosha elithi "Qeda" kwaye uphendule kumbuzo malunga nendlela yokwakha imifanekiso kwi-Excel, uyazi! Vumelana ukuba kulula kakhulu kunokuba ibonakala kuqala. Iingcamango kufuneka zihlale zixhaswa ngumsebenzi. Ngoko, zama! Uya kuphumelela.

Eyona nqabileyo!