Izinhlobo amashadi kanye nezici zabo

Ngaphambi ukudala isimiso noma, kumelwe unqume on umbuzo onjani ishadi unesithakazelo kuyo.

Cabanga ayinhloko.

Embondelwe

kakhulu Igama lalesi zilwane kubolekwe ngolimi lwesiGreki. Inguqulo yezwi nezwi - ukubhala okuthunyelwe. Lona uhlobo kubhagrafu. Imidwebo Excel lolu hlobo kungaba okukhulu, flat isibonisi iminikelo (engunxande isikwele), njll

Chitha

Ukhombisa ubudlelwano mutual phakathi idatha zezinombolo e inombolo yemigqa futhi pair of amaqembu kwamadijithi noma izinombolo njengoba umugqa owodwa we pixels izixhumanisi. Izinhlobo imifanekiso uhlobo idatha ukuboniswa amaqoqo okusetshenziselwa izinjongo ngokwesayensi. Lapho amalungiselelo owandulelayo ngenxa chitha ukwakhiwa kwesakhiwo, yonke idatha ukuthi ufuna ukubeka ku-eksisi le 'X', kumele ibekwe endaweni eyodwa irowu / ikholomu, kanye namagugu "IGRIK"-eksisi - ku eduze irowu / ikholomu.

Ishadi yebha nakugrafu

Isifanekiso uchaza uhlobo ibusa isilinganiso idatha ngabanye. On onjalo amagugu umdwebo wahlela kanye eksisi eqonde ngqo phezulu, esigabeni esifanayo - enezingqimba. Kule kusobala ukuthi ukunakwa okuningi kuleli shadi inika Ukuqhathanisa idatha, kunokuba izinguquko ezenzeka ngokuhamba kwesikhathi. Lolu hlobo ishadi kukhona uhlaka "ekuqongeleleni" elikuvumela ukuba ubonise okomnikelo izingxenye ngabanye ukuba umphumela jikelele.

Igrafu ibonisa ukulandelana amagugu izinguquko lenombolo ngezikhawu ngokuphelele njalo.

Lezi zinhlobo amashadi ngokuvamile esetshenziselwa ezakhiwe.

Area amashadi

Injongo eyinhloko yale umdwebo iyona Ukugcizelelwa umthamo kwemininingwane ushintsho phakathi nenkathi ethile, ngokufanayo ngokubonisa summation lamanani input. Kanye ukubonisa inani amagugu ngamunye enanini eliphelele.

I annular kanye isiyingi amagrafu

Lezi zinhlobo amashadi zifana kakhulu ngenhloso. Bobabili ukukhombisa indima element ngayinye e enanini eliphelele. umehluko yabo amanga kuphela ukuthi indandatho ine ishadi ikhono zimumethe imigqa eziningana ngedatha. Ngamunye indandatho ngabanye enamathiselwe kuyinto inombolo ngabanye yamanani / idatha.

Radar

Lapha, esigabeni ngasinye limelela ngabanye Ukudidiyela-eksisi, uvela zero iphuzu izixhumanisi. Lolu hlobo ishadi ikuvumela ukuqhathanisa ukubaluleka isiyonke eziningi idatha input.

bubble

Olunye uhlobo iphuzu. Ubukhulu umaka incike ubukhulu bale variable lwesithathu. Lapho i-ahlelwe idatha ukuqeqeshwa kufanele kube nse lapho elungiselela ukwakha ishadi chitha.

ishadi stock

Ukusetshenziswa inqubo enjalo ngokuvamile iyingxenye ukudayisa amasheya noma nezinye izibambiso. Kungenzeka futhi ukwakha ukuzimisela okubonakalayo ushintsho lokushisa izindlela. Ukuze amathathu nanhlanu amagugu ezinjalo kwigilafu zimumethe yebhangqa izimbazo: owokuqala - kuya ezindaweni zotshwala amelela isikhawu iyehla iyenyuka ezithile, kwesibili - ukushintsha isigaba intengo.

Lena ingxenye encane izinhlobo ishadi ukuthi kungase kudingeke kuphela. Izinhlobo amashadi Excel zahlukahlukene kakhulu. Nguwena ngaso sonke isikhathi sincike imigomo. Ngakho kunqunywa ukuthi ufuna bagcine, nokwakhiwa master ozonquma!