Maitiro ekuwedzera chirongwa kune iyo purogiramu muExcel

Nhanho 1: Kugadzira iyo yakasanganiswa purogiramu

Ngatitangei nebasa guru - kugadzira chirongwa chakasanganiswa. Tsika dzese dzakabatanidzwa mumitsara yakasarudzwa yetafura ichaiswa mazviri. Vanogona kunge vari kupfuura maviri, asi ikozvino tichangoongorora maviri mifananidzo yekujekesa, nekuti mademo akasara akagadzirirwa nenzira imwecheteyo. Iko kusimbiswa kukuru mukugadzira madhayeti akadai kunoitwa kuti ugone kugadzirwa kwakajairika kwehunhu mumagariro akasiyana zvachose kana zvine chekuita nezvimwe zvikamu zvekuyera.

1. Vhura iyo shizha rinodiwa uye neiyo bhatani rekuruboshwe bhatani kuratidza ese matsime etafura iyo ichaita chirongwa. Usakanganwa kuti mazita ezvikamu anofanirawo kusarudzwa, sezvo ivo vari pazita remazita.



2. Enda kune "Insert" tab, uko iyo yekuwedzera-pane chishandiso inowanikwa.



3. Vhura runyorwa nemirairo kana kuona iyo yakazara rondedzero yavo nekudzvanya pane "Yakakurudzirwa Chati" bhatani.



4. Muwindo idzva, tinya pane rondedzero "Chirongwa", verenga sarudzo dziripo uye mbiri-mbiri pane zvakakodzera kuti uwedzere patafura.



5. Fambisa hurongwa kana ikapindira nebasa rine pepa kana kungofanirwa kuve kune imwe nzvimbo.

Dzimwe nguva zvinogona kupedzwa pane izvi, sezvo mitsara yese ichiratidzwa nenzira kwayo uye haadi mamwe marongero. Nekudaro, kazhinji, kuparadzira mune ye data renji hakubvumirane kuti tigone kuona zvirimo zvegirafu, saka zvakafanira kuiburuka.

Nhanho yechipiri: Nzvimbo yeAuxilia Axes

Auxiliary Axes - iyo chete mhinduro yemamiriro ezvinhu, apo mumwe kana akati wandei mitsara yemifananidzo inoratidzwa sedzimbo yakatwasuka. Izvi zvinokonzerwa nenyaya yavo iri pamucheto weiyo shoma yakaziviswa pane huru axis, saka, inodikanwa kuti uwedzere kuwedzera imwe.

1. Sezvatinogona kuoneka mune inotevera skrini, dambudziko rakamuka nenhamba inonzi "kutengeswa", izvo zvinokatyamadza zvakanyanyisa kuderera. Ipapo iwe unofanirwa kudzvanya pane mutsara kurudyi mbeva bhatani.



2. Mumamiriro ezvinhu menyu inoonekwa, sarudza "fomati ye data".



3. Menyu yacho inoratidzwa, kwaicherechedzai "Auxiliary Axis" Marker.



4. Mushure meizvozvo, dzokera kumarongero uye uone kuti kuratidzwa kwakachinja sei.

Nemamwe mitsara ine matambudziko akafanana anomuka, ita zvimwe chete, wobva waenda kune inotevera nhanho kuti uwedzere kuratidzwa kwehunhu.

Nhanho 3: Kuwedzera Legend

Iyo ngano inokutendera kuti utarise mazita emutsara wega wega uye haakubvumire iwe kuti uvhiringidzwe mavari, zvinoratidzawo ruvara rwakagoverwa mataira. Kubva munzvimbo yayo mudhiraivhi pachayo, zvinoenderana nemabatirwo akaitwa, saka dzimwe nguva zvinodikanwa kuti uchinje nzvimbo yayo kuzadza.

1. Sarudza girafu kuti zvishandiso zvinoratidzirwe pamusoro pepamusoro pani kuti ushande nazvo, uko tinya pa "Wedzera Chati Yechati".



2. Mukudonha-pasi menyu iwe unoda "ngano".



3. Menyu yakaparadzana ichavhurwa, iwe pachako nekuisa mucherechedzo wakatarisana nechinhu chakakosha sarudza nzvimbo yengozi.



4. Semuenzaniso, iwe unogona kuiisa, uye dhayati pachayo yakatambanudzwa zvishoma - saka kuratidzwa kwehunhu kuchawedzera kunzwisisika.

Sezvinowedzera, tinokupa zano kuti uverenge murayiridzo wakaparadzana, izvo zvinoratidza maitiro ekuwedzera mazita emahara. Izvi zvinokanganisawo kunzwisisa kwezvirongwa zvehurongwa.

Verenga Zvakawanda: Kugonesa Signature Axes ye chati mune excel