Maitiro Ekuita Nyanzvi uye Stylish Charts muExcel

Kushandiswa kwezvirongwa zvakaita seExcel kwakapararira, mundima yezvidzidzo uye munzvimbo yebasa. Kune vadzidzi uye nyanzvi, gadzira machati muexcel inzira inooneka uye inoshanda yekupa data rako neruzivo kuita sarudzo kana kutora mhedziso zvichibva pazviri.

Zvinoratidzwa kuti chero kutorwa kana kumiririra data yenhamba Iyo inoshanda zvakanyanya kana ikaitwa neiyo chaiyo magirafu. Kunyanya kushamisa uye kutaura, zviri nani. Nechikonzero ichi, kuziva maitiro ekugadzira aya magirafu uye nekuaratidza nemazvo anogona kazhinji kuita mutsauko pakati pekubudirira kana kukundikana mukuratidzira kana basa.

Asi usati waongorora inoyevedza uye yekuona mikana yemagirafu aya, zvinodikanwa kuti tizive mushe magirafu ayo anotipa. Excel uye mabatiro e data kuitira kuti magirafu avadudzire nemazvo uye zvinobudirira:

Mhando dzeExcel charts

Chinangwa chegirafu hachisi chimwe kunze kwekumiririra rumwe ruzivo nenzira yekuona uye muchidimbu. Nenzira iyi zviri nyore kududzira izvo data inotaridza uye kuita kuti sarudzo iite nyore. Aya ndiwo mazano ayo Excel anotipa:

Bar graph

Ndiyo imwe yeanonyanya kushandiswa, nekuti kuburikidza navo munhu anoiona anowana ruzivo rwakawanda nenzira yakapfupikiswa nekungotarisa kamwe chete. Nzira yekugadzira rudzi urwu rwemagirafu? Iwe unofanirwa kutevera matanho aya:

1. Chokutanga pane zvose, unofanira sarudza muexcel peji iyo data izvo isu tinoda kuratidza mubhara chati uye tokopa ivo kune clipboard.
2. Ipapo tinobaya "isa" uyezve tinosarudza "Inokurudzirwa Graphics", apo sarudzo dzakasiyana dzicharatidzwa mudivi rekuruboshwe. Muchiitiko chino, tinosarudza mabhawa.
3. Excel inoisa iyo data yakakopwa kubva paclipboard kupinda mukati meshizha rebasa mubharachati.

Kana chati yangogadzirwa, tinogona kuiita saizi, kuiendesa kunzvimbo dzakasiyana mukati mebepa, uye kutokopa kune rimwe pepa rebasa rakasiyana. Iwe unogona zvakare kushandura zita rechati nekudzvanya kaviri pairi uye nekunyora zita idzva.

Asi sezvo tichida kuti chati yacho ive yakashongedzwa uye ine hunyanzvi inotaridzika, isu tinofanirwa kushandisa imwe zvishandiso kuita nani. Semuenzaniso, unogona kushandura ruvara uye chimiro chebhawa chati senge:

Isu tinosarudza yedu Excel bar chart uye tinya pane iyo tab ye "chinja mavara", iyo inowanzomiririrwa nebhurashi icon kurudyi rwegirafu patinodzvanya pairi. Menyu inooneka inotibvumira sarudza akasiyana cosmetic maitiro eiyo graphic. Ingo fambisa pamusoro payo uye simudza mbeva yako pamusoro peimwe neimwe maitiro kuti uione.

Kana makoramu achinja kutaridzika, anova mbariro. A bar graph inogona kuratidzwa mumapoka akaiswa fomu kana kurongedzerwa kana kuwedzera 100% yedata inomiririrwa. Iyi sarudzo inogona kuve nzira inoshanda kwazvo yekumiririra imwe kirasi yedata kune veruzhinji.

Girafu yemutsara

Rudzi urwu rwechati runonyanya kushandiswa. kuona mafambiro kana uchishanda nezvakawanda zvakakosha. Muzviitiko izvi, mabhawa kana makoramu machati haana kukwana, sezvo asingaverengeki. Pane kudaro, girafu yemutsara inopa ruzivo rwakaunganidzwa zvakanyanya.

Aya ndiwo magadzirirwo aunoita girafu remutsara neExcel:

1. Kutanga, isu tinoisa iyo data yatinoda kumiririra mugirafu muExcel tafura uye sarudza iyo.
2. Zvadaro tinoenda kune sarudzo bar, kune tab "Isa".
3. Ikoko tinosarudza "Gadzira mutsetse girafu" in Excel.
4. Zvisarudzo zvakasiyana-siyana zvinoratidzwa, zvakabatanidzwa mapoka maviri: 2D uye 3D. Zvose nzvimbo uye mutsetse. Ndezvekusarudza iyo inotifadza zvakanyanya.

ari nzvimbo machati idzo imwe nzira yekumiririra mutsara chati uchibatanidza iyo inooneka punch yebha kana makoramu machati.

Pie kana donut chati

Imwe yeanonyanya kufarirwa mifananidzo inomiririra, kunyanya inoratidzwa kumiririra muzana yekugovera, semuenzaniso. The mapayi machati ratidza hukuru hwezvinhu zve data nhevedzano zvinoenderana nehuwandu hwezvinhu. Saka, chikamu che data mu pie chati chinoratidzwa sezvikamu zvepai yose chati.

Zvinokurudzirwa kushandisa machati aya kana pasina anopfuura manomwe kukosha uye hapana kana imwe yadzo iri zero kana yakaipa. Sezvimwe mune dzimwe sarudzo, dzinogona kugadzirwa mune ese 2D uye 3D mafomati.

Vamwe vanhu vanosarudza (inyaya yekuravira) kushandisa iyo donut chati semusiyano kana imwe nzira kune pie chati. Saizvozvi, inoshanda kuratidza hukama hwezvikamu nesese, kunyangwe inogona kunge iine anopfuura imwechete akateedzana data. Zvisinei, hadzina kuona kana kuti nyore kududzira sedzokutanga.

Kuparadzira chati uye mabhuru

Iyo inozivikanwawo se XY Type Chati, iwo ekuparadzira anotibatsira kutora data yakarongeka mumakoroni nemitsara yespredishiti. Isa iyo X kukosha mumutsara mumwe kana koramu uye inoenderana Y kukosha mumitsetse iri padyo kana makoramu.

Kutenda kune sosi yemaaxes maviri akakosha (yakachinjika X axis uye yakatwasuka Y axis), zvinogoneka kumiririra zvisingaite nguva kana mapoka, chimwe chinhu chisingagoneke nemamwe magirafu pane iyi runyorwa. Kuparadzira zvirongwa zvinoshandiswa zvakanyanya mune zvesainzi nenhamba. Inogona kusanganiswa nemitsara yakatwasuka kana yakakomberedzwa inobatana nemapoinzi akapararira anoratidza mafambiro.

Nokuda kwavo, bubble charts ivo inzira inotooneka yekugadzira chirongwa chekuparadzira. Aya mabhuru anogona kumiririrwa mu2D kana 3D, aine axis yakadzama inoita kuti ataridzike semabhora chaiwo pachiratidziri chedu.

Stock chati

Yakanyanya mukurumbira mukati menyika yehupfumi uye zvemari, uko inozivikanwa zvakare se chati yekenduru. Sezvinoratidzwa nezita rayo, machati aya akanakira kuratidza kushanduka kwemitengo yemasheya, ndosaka achishandiswa mumusika wemasheya, kunyangwe izvi zvisiri izvo zvekushandisa.