I-FreeOffice Calc: Uyenza njani iTshathi yokuSasaza

Kwisithuba esidlulileyo ndikufundise ukuba njani ngenisa ngaphandle ifayile yokutshintsha yedatha kwifomathi yokubhaliweyo okungenanto. Namhlanje ndiza kumela uthotho lwedatha ezintathu ezinxulumeneyo kwitshathi yokuchithachitha.

Into yokuqala ekuya kufuneka sicace ngayo, ukuba sisebenze ngakumbi kule nkqubo, lulwandiso lwedatha esidlala ngalo. Kuyinyani ukuba sinokukhetha uthotho lwegraphic, kodwa xa uneeseli eziyi-1000 kwikholamu nganye, njengokuba kunjalo kum, ugqiba ukubhala kwakamsinya.

Emva kwexesha siya kuqonda ukuba sinokugrafu idatha ngokukhawuleza ngakumbi ngokukhetha iikholamu ekuthethwa ngazo ngaphambi kokuqalisa isixhobo segrafu kodwa, ngenxa yesifundo, siya kulitsiba le nxalenye.

1. Lungiselela idatha

Apha unokubona indlela endiyilungiselele ngayo iikholamu ezineentloko zazo. Ndikwahlule iphepha ngokuthe tye ukuze ndibone idatha ngamaxesha onke (ngasekhohlo) ngelixa ndinecandelo apho ndiza kufaka igrafu efikelelekayo (ekunene).

Injongo yam kukwenza uhlobo lwe-XY igrafu apho ndizakusebenzisa iiquadrants ezi-3:

• Ku- (X>0, Y>0) ndiza kwenza iyelenqe ikholam engu-Y ngokuchasene no-X.
• E (X<0, Y>0) ndiya kuceba u-Y ngokuchasene no-X-1.
• Ngo (X>0, Y<0) ndiza kwenza iyelenqe u-Y-1 ngokuchasene no-X.

2. Isixhobo "seMizobo".

Ifumaneka kwibar yesixhobo okanye kwimenyu ethi 'Faka', yenza kube lula ngathi ukwenza iiKholamu, iiBha, amaCandelo, iMida, i-Scatter, njl.

Kwimeko yam, ndiza kudala i-XY yokuchitha icebo ngemigca egudileyo, ndinikwe inani elikhulu lamanqaku akhoyo kwigrafu yam.

3. Uluhlu lweDatha

Ukuba sicofa 'okulandelayo', iwizadi iyasivumela ukuba sikhethe "uluhlu lwedatha" esiza kusebenza ngalo. Njengoko ndikhankanyile ngasentla, sinokukhetha kwangaphambili imimandla yedatha yedatha esifuna ukuyigrafu. Olu luhlu lwedatha lungaqulatha amacandelo amaninzi espredishithi esifanayo. Ngezizathu zobulula siza kulitsiba eli nyathelo (akuyomfuneko ukwenza igrafu).

4. Uluhlu lweDatha

Igrafu yethu iya kumela nganye yoluhlu lwedatha echazwe kweli nyathelo ngemigca.

Kwimeko yam, ndibabize ngokuthi a, b kunye no-c, ngokulandela ulandelelwano lwee-quadrants endizikhankanye ngaphambili.

Ukukhetha uluhlu olufunekayo u-X okanye u-Y amaxabiso sinokucofa ibhokisi esekunene, eya kunciphisa ibhokisi yencoko yababini kwaye isivumele ukuba sikhethe iibhokisi ngesandla.

Ukuze ungachithi ukhuphelo lwanaphakade iiseli, siya kuyichaza ngokulandela i-nomenclature:

$sheetname.$column$startcell:$column$endcell

Kwimeko yefayile yam yeCalc (.ods), idatha ikwiphepha elinegama elithi "UsemosLinux", kunye no-X kunye no-Y amaxabiso abe ziiseli 3 ukuya ku-1002 kukholomu K no-J ngokulandelelanayo.

5. Imizobo Elements

Ekugqibeleni, kweli nyathelo lokugqibela sinokuhlengahlengisa i-aesthetics yegrafu. Njengayo yonke into eyenziwe ukuza kuthi ga ngoku, inokuguqulwa kamva.

6. Ukuphinda usebenze kwakhona

Apha sinegrafu yethu.

Nangona i-Libreoffice ihambe indlela ende xa ithelekiswa ne-OpenOffice yangaphambili, unyango lwemizobo lusenokuphuculwa (kwaye sele lungcono kakhulu kunokuba lwalunjalo). Ngenxa yokungazi kwam ngokupheleleyo, ndiza kuyibalula kumbono weCalc: umgca oluhlaza okwesibhakabhaka ngandlel’ ithile, kodwa usonjululwa ngokukhawuleza nje ukuba sihlengahlengise ubungakanani begrafu:

Igrafu kufuneka ibe lula ngakumbi, ngoko ke ndiya kuyitshintsha ifomathi yeezembe. Ukwenza naluphi na uhlengahlengiso, nqakraza ngokulula kwinto esifuna ukuyilungisa, nokuba yigrafu yonke, uthotho lwedatha, izembe okanye ilivo.

Ekugqibeleni, ndithumela ngaphandle igrafu ukuyigcina ngaphandle kwespredishithi kwaye ndiyisebenzise kwamanye amaxwebhu. Apha kubalulekile ukuba uhlengahlengise ubungakanani kunye nesisombululo somfanekiso kakuhle, kodwa kwesi sifundo sele sikhona.

Isiphelo

Le mihla kufuneka ndilwe ne-spreadsheets ezinkulu ze-Ofisi 2013. Njengomthandi olungileyo weSoftware yasimahla, ndithatha ithuba lokusebenza kunye neCalc kunanini na ngaphambili. I-Libreoffice yeyona ndlela ilungileyo, kunye nazo zonke iingxaki zayo ezinokubakho. Ungalibazisi ukufunda ukusebenza naye.

Emva kokulayisha iifayile zam zeOfisi ka-2013 kuyo, ndothuka kakhulu, kude kakhulu neFUD eninzi ekhutshwe ngayo. Kuyinyani ukuba ezinye izinto ezibonwa ngabasebenzisi be-Excel abaphambili zikude, kodwa kusetyenziso olusemgangathweni lwe-spreadsheet esinayo kwiCalc enye indlela yasimahla, yasimahla kwaye ihlala ikhona ngocofa nje kube kanye kuzo ZONKE iinkqubo zethu.