Line Diagram muExcel

Nheyo yekugadzira bar chati

Iyo Line Diagram muExcel inoshandiswa kuratidzira zvakakwana data rakasiyana rinodzidzisa rine chekuita neTafura yakasarudzwa. Nekuda kweizvi, kudikanwa kunomuka kwete kungochigadzira, asi zvakare kugadzirisa mumabasa avo. Pakutanga, inofanira kuiswa kunze kwekusarudzwa kwetambo chati, uyezve uenderere mberi nekuchinja kwe parameter ayo.

1. Simbisa chikamu chaunoda chetafura kana chayo chose, chakabata bhatani rekuruboshwe bhatani.



2. Dzvanya iyo Insert Tab.



3. Muzvivharira nemachati, Wedzera "Histogram" Kudonha-Down Menyu, uko kune matatu akaenzana mutsara mutsara graphs template uye pane bhatani kuti uende kumenyu nezvimwe menyu.



4. Kana iwe ukadzvanya iyo yekupedzisira, nyowani "Insert chart" window inovhurika, uko, kubva pane yakasarudzika zvinyorwa, sarudza "mutsara".



5. Funga nezvematanho ese aripo kuti asarudze iyo yakakodzera kuratidza iyo inoshanda data. Iyo vhezheni neboka iri kubudirira kana iwe uchida kuenzanisa tsika mumapoka akasiyana.



6. Type yechipiri mutsara neyekuunganidzwa, inokutendera kuti uratidze zviyero zvezvinhu zvega chimwe nechimwe.



7. Rudzi rumwe chete rwe chati, asi chete ne "yakajairika" prefix inosiyana kubva kune yapfuura data kune data yekuendesa data. Pano ivo vanoratidzwa muzana muzana retio, uye vasina kuenderana.



8. Mhando nhatu dzinotevera dzeBar Diagrams dzakateedzana nhatu. Iyo yekutanga inogadzira chaizvo iboka rimwechete iro rakakurukurwa pamusoro apa.



9. Dhizaini yekuunganidza inotenderera inoita kuti zviitike kuti uone huwandu hwehuwandu mune imwe yakazara.



10. Iyo yakajairika vhoriyamu ndeyakaenzana neyakagadziriswa-maviri, inoratidza iyo data muzana.



11. Sarudza imwe yemakwenzi ekutariswa, tarisa kune iyo maonero uye tinya paPinda kuti uwedzere patafura. Bata girafu neiyo iyo kuruboshwe bhatani bhatani kuti uende kune chinzvimbo chakanakira.

Kuchinja mufananidzo wezve matatu-matatu emutsara mutsara chati

Matatu-Dimensional Bar machati anozivikanwa nekuti anotaridzika zvakanaka uye anokutendera iwe kuti unyatsoratidza kuenzanisa kwe data kana mharidzo yeProjekiti. Standard Excel Mabasa anokwanisa kuchinja rudzi rwechimiro chetsoka nedata, ichisiya iyo yakasarudzika sarudzo. Ipapo iwe unogona kugadzirisa chimiro chemufananidzo, uchipa iyo dhizaini yemunhu.

1. Iwe unogona kushandura mufananidzo wedhirowa diair payo yakagadzirwa pakutanga mune matatu-dimensional fomati, saka ita izvozvi kana hurongwa hurege kuwedzerwa patafura.



2. Dzvanya LKM pamitsara yedhisheni data uye shandisa kumusoro kuti usimbise zvese kukosha.



3. Gadzira bhatani rekurudyi nebhatani rekurudyi re mbeva uye kuburikidza neiyo mamiriro menyu, enda kuChikamu "Data Range" chikamu.



4. Pane kodzero ichavhura iwindo diki iro rine mutoro wekumisikidza paramita emutsara wezvikamu zvitatu. Mu "nhamba" block, maka iyo yakakodzera nhamba yekutsiva iyo standard uye tarisa mhedzisiro iri mutafura.



5. Pakarepo ipapo, vhura chikamu icho mukati meiyo inotungamira yekugadzirisa chimiro chehuwandu hwehuwandu. Mubvunze zororo, iyo contour uye inopa chimiro pazvinenge zvichidikanwa. Usakanganwa kuongorora shanduko mune chati uye kudzima ivo kana iwe usingade chimwe chinhu.

Chinja chinhambwe pakati pemitsetse yedhiriyamu

Mune menyu yakafanana, kushanda nedhivhiji yakateerana iripo mamiriro akapatsanurwa anovhura kuburikidza ne "parameter emutsara" chikamu. Iyo ine mutoro wekuwedzera kana kuderera musango pakati pemitsara yerutivi rwemberi parutivi. Sarudza iyo yakakwana kure nekufambisa idzi slider. Kana pakarepo iyo setup haina kukodzera iwe, dzosera iyo default tsika (150%).

Kuchinja Nzvimbo yeAxes

Iko kwekupedzisira kurongeka uko kuchave kunobatsira kana uchishanda neiyo DIGING Diagram - Chinja nzvimbo yemazasi. Inoshandura axis yemadhigirii 90, ichiita kuti kuratidzwa kwegirafu riripo. Kazhinji, paunofanirwa kuronga mhando yakafanana, vashandisi vanosarudza imwe mhando yemadhinda, asi dzimwe nguva unogona kungochinja kurongwa kweiyo iripo.

1. Dzvanya pane axis kurudyi mbeva bhatani.



2. Menyu yemamenyu anoonekwa kuburikidza iwe yaunovhura iyo axis fomati yewindo.



3. Mariri, enda kune yekupedzisira tab ine paramita.



4. Wedzera "Signature" chikamu.



5. Kuburikidza ne "Signature chinzvimbo" Kudonhedza-pasi menyu, sarudza nzvimbo yaunoda, semuenzaniso, pazasi kana pamusoro, wobva watarisa mhedzisiro.