Magadzirirwo, Chimiro, uye Dzimwe Chati Sarudzo

Muchidzidzo chekupedzisira, takajairana nemhando dzemachati muExcel, takaongorora zvinhu zvavo zvikuru, uye zvakare takavaka iri nyore histogram. Muchidzidzo chino, ticharamba tichizivana nemadhayagiramu, asi pamwero wepamusoro. Isu tichadzidza mafomati machati muExcel, kufambisa pakati pemashiti, kudzima uye kuwedzera zvinhu, uye zvimwe zvakawanda.

Chati chimiro uye chimiro

Mushure mekuisa chati muExcel pepa rekushanda, kazhinji zvinove zvakakosha kuti uchinje dzimwe sarudzo dzekuratidzira data. Chimiro uye chimiro chinogona kuchinjwa pane tab Constructor. Heano mamwe ezviito zviripo:

• Excel inokutendera kuti uwedzere zvinhu zvakaita semazita, ngano, zvinyorwa zvedata, zvichingodaro kune chati yako. Zvimwe zvinhu zvinobatsira kufambisa maonero uye kuwedzera ruzivo rwemukati. Kuti uwedzere chinhu, tinya pane kuraira Wedzera Chart Element Tab Constructor, wobva wasarudza yaunoda kubva pane yekudonhedza-pasi menyu.
• Kugadzirisa chinhu, senge zita, tinya kaviri pachiri uye wochigadzirisa.
• Kana iwe usingade kuwedzera maelement ega, unogona kushandisa imwe yemagadzirirwo ekare. Kuti uite izvi, tinya pane murairo Express marongerwo, uye wozosarudza marongerwo aunoda kubva pane yekudonhedza-pasi menyu.
• Excel ine huwandu hukuru hwemasitayipi anobvumidza iwe kukurumidza kushandura kutaridzika kwechati yako. Kuti ushandise chimiro, sarudza muboka rekuraira Zvitaera zvechati.

Iwe unogona zvakare kushandisa mabhatani efomati yekudimbudzira kuwedzera zvinhu pachati, shandura maitiro, kana kusefa iyo data.

Dzimwe Sarudzo dzeChati

Kune dzimwe nzira dzakawanda dzekugadzirisa uye maitiro machati. Semuenzaniso, Excel inokutendera kuti utsanangure zvakare data rekutanga, shandura mhando, uye kunyange kufambisa chati kune rimwe pepa rakasiyana.

Kuchinja mitsara nemakoramu

Dzimwe nguva unofanirwa kushandura kuti data inoiswa sei muExcel chart. Mumuenzaniso unotevera, ruzivo rwakabatanidzwa negore uye nhepfenyuro yedata imhando. Nekudaro, isu tinokwanisa kushandura mitsara nemakoramu kuitira kuti data iunganidzwe nemhando. Muzviitiko zvese izvi, chati ine ruzivo rwakafanana asi yakarongwa zvakasiyana.

1. Sarudza chati yaunoda kuchinja.
2. Pa Advanced tabo Constructor press command Row column.
3. Mitsara nemakoramu zvichatsivana. Mumuenzaniso wedu, iyo data ikozvino yakaunganidzwa nemhando uye iyo data data yave makore.

Shandura mhando yemachati muExcel

Kana iwe ukaona kuti ikozvino chati haikodzeri data iripo, unogona kushandura nyore kune imwe mhando. Mumuenzaniso unotevera, tichashandura rudzi rwechati kubva Nhoroondo on Timetable.

1. Pa Advanced tabo Constructor tinya command Shandura rudzi rwechati.
2. Mubhokisi rebhokisi rinoonekwa Shandura rudzi rwechati sarudza rudzi rutsva rwechati uye marongerwo, wobva wadzvanya OK. Mumuenzaniso wedu, tichasarudza Timetable.
3. Mhando yechati yakasarudzwa inooneka. Mumuenzaniso wazvino, unogona kuona izvozvo Timetable zvakanyanya kuburitsa masimba ekutengesa panguva iripo.

Fambisa chati muExcel

Kana yanamirwa, chati inoratidzika sechinhu chiri papepa rimwechete nedata. MuExcel, izvi zvinoitika nekusarudzika. Kana zvichidikanwa, unogona kufambisa chati kune rimwe shizha kuti uise zvirinani data.

1. Sarudza chati yaunoda kufambisa.
2. Baya Constructor, wobva wadzvanya command Move Chart.
3. A dialog box richavhura Kufambisa chati. Sarudza nzvimbo yaunoda. Mumuenzaniso wazvino, tichaisa chati pane rimwe pepa uye toripa zita Kutengeswa kwebhuku 2008-2012.
4. dzvanya OK.
5. Chati ichaendeswa kunzvimbo itsva. Kwatiri, iri ndiro pepa ratachangobva kugadzira.