Mukati
- 3 Nzira dzeKugadzirisa Sarudzo Chati muExcel
- Maitiro ekuwedzera zita kune Excel chati
- Kumisikidza machati maaxes muExcel
- Kuwedzera Data Labels kune Excel Chart
- Kuwedzera, Kubvisa, Kufambisa, uye Kugadzirisa Mafomati eChati Legend
- Ratidza uye uvanze grid mune Excel chati
- Kuvanza uye kugadzirisa data data mune Excel chati
- Shandura rudzi rwechati uye maitiro
- Kuchinja machati mavara
- Maitiro ekuchinjanisa sei x uye y axes echati
- Maitiro ekutenderedza chati muExcel kubva kuruboshwe kuenda kurudyi
Ndechipi chinhu chekutanga chatinofunga nezvazvo mushure mekugadzira chati muExcel? Nezve nzira yekupa iyo dhizaini chaizvo kutaridzika kwataifungidzira patakasvika pasi kubhizinesi!
Mune shanduro dzemazuva ano dzeExcel 2013 uye 2016, kugadzirisa machati kuri nyore uye kuri nyore. Microsoft yaenda kune hurefu hukuru kuita kuti nzira yekuseta ive nyore uye sarudzo dzinodiwa kuwanikwa nyore. Gare gare muchinyorwa chino, tinokuratidza dzimwe nzira dziri nyore dzekuwedzera uye kugadzirisa ese ekutanga machati zvinhu muExcel.
3 Nzira dzeKugadzirisa Sarudzo Chati muExcel
Kana iwe wakawana mukana wekuverenga yedu yapfuura chinyorwa chekugadzira chati muExcel, saka iwe unotoziva kuti iwe unogona kuwana ekutanga machati maturusi mune imwe yenzira nhatu:
- Sarudza chati uye shandisa ma tabo kubva muboka Kushanda nemachati (Zvishandiso zveChati) - Constructor (Dhizaini) Framework (Format).
- Tinya-kurudyi pane chinyorwa chechati chaunoda kugadzirisa uye sarudza rairo yaunoda kubva pane yemukati menyu.
- Shandisa zvidhori zvinoonekwa pedyo nekona yekurudyi yechati paunodzvanya pairi negonzo.
Zvimwe zvingasarudzwa zviri mupaneru Chart Area Format (Format Chart), iyo inooneka kudivi rekurudyi repepa rebasa paunodzvanya Dzimwe sarudzo (Dzimwe sarudzo) mumenu yezvinyorwa zvedhiyagiramu kana pamatabu eboka Kushanda nemachati (Chati Zvishandiso).
Tip: Kuti uvhure nekukurumidza chikamu chaunoda chepaneru yekuseta maparamendi echati, tinya kaviri pane chinhu chinoenderana pane chati.
Takashongedzerwa neruzivo urwu rwekutanga, ngatitarisei kuti tingagadzirise sei zvakasiyana-siyana zvechati muExcel kuti tipe iyo chaiyo kutaridzika kwatinoda kuti itaridzike.
Maitiro ekuwedzera zita kune Excel chati
Muchikamu chino, tinokuratidza kuti ungawedzera sei zita kune chati mune dzakasiyana vhezheni dzeExcel uye tokuratidza panowanikwa maturusi makuru ekuchati. Muchikamu chasara, tichatarisa mienzaniso yebasa chete mushanduro nyowani dzeExcel 2013 uye 2016.
Kuwedzera Chinyorwa kune Chati muExcel 2013 uye Excel 2016
MuExcel 2013 uye Excel 2016, paunogadzira chati, iwo mavara "Musoro wechati“. Kuti uchinje chinyorwa ichi, ingosarudza uye isa zita rako pachako:
Iwe unogona zvakare kubatanidza zita rechati nesero riri pashizha uchishandisa chinongedzo kuitira kuti zita rigadziriswe otomatiki pese panochinja zviri mukati mesero rakabatanidzwa. Nzira yekuita izvi inotsanangurwa pasi apa.
Kana nekuda kwechimwe chikonzero zita racho harina kuwedzerwa otomatiki, wobva wadzvanya chero padhayagiramu kuti uunze boka rematebhu Kushanda nemachati (ChartTools). Vhura tab Constructor (Design) uye tinya Wedzera Chart Element (Wedzera Chart Element) > Musoro wechati (Chinyorwa Cheti) > Pamusoro chati (Pamusoro Chati) kana Pakati (pamusoro) (Centered Overlay).
Kana kuti tinya chiratidzo Chati zvinhu (Chati Elements) padyo nekona yekurudyi yechati uye tarisa bhokisi Musoro wechati (Chinyorwa cheChati).
pedyo nesarudzo Musoro wechati (Chinyorwa cheChati), unogona kudzvanya museve unonongedza kurudyi (ona mufananidzo uri pamusoro) uye sarudza imwe yesarudzo:
- Pamusoro chati (Pamusoro Chati) - zita rinoiswa pamusoro penzvimbo yekuvaka machati, nepo saizi yechati ichideredzwa; iyi sarudzo inoshandiswa nekusingaperi.
- Pakati (pamusoro) (Centered Overlay) - musoro wepakati wakaiswa pamusoro penzvimbo yekuronga, nepo saizi yechati isingachinji.
Kuti uwane dzimwe sarudzo, tinya tab Constructor (Design) uye tinya Wedzera Chart Element (Wedzera Chart Element) > Musoro wechati (Chinyorwa Cheti) > Zvimwe zvingasarudzwa zvemusoro (Dzimwe sarudzo). Kana kuti tinya chiratidzo Chati zvinhu (Chati Elements), ipapo Musoro wechati (Chinyorwa Cheti) > Dzimwe sarudzo (Zvimwe Sarudzo).
Batanidza Dzimwe sarudzo (Dzimwe Sarudzo), mune ese ari maviri, anovhura pani Chart Title Format (Format Chart Title) kurudyi kwepepa rebasa, kwaunogona kuwana sarudzo dzaunoda.
Kuwedzera Chinyorwa kune Chati muExcel 2010 uye Excel 2007
Kuti uwedzere zita kune chati muExcel 2010 uye yapfuura, tevera matanho aya:
- Dzvanya pese pachati yeExcel kuti uunze boka rematebhu paMenu Ribhoni Kushanda nemachati (Chati Zvishandiso).
- Pa Advanced tabo Maitiro (Magadzirirwo) tinya Musoro wechati (Chinyorwa Cheti) > Pamusoro chati (Pamusoro Chati) kana Pakati (pamusoro) (Centered Overlay).
Kubatanidza zita rechati nesero repepa rekushanda
Machati emhando dzakasiyana muExcel anowanzo kugadzirwa aine alt mavara pachinzvimbo chezita. Kuti uise zita rako pachako chechati, unogona kusarudza chikamu chechati uye kuisa zvinyorwa nemaoko, kana kuibatanidza kune chero sero mune pepa rekushanda rine, semuenzaniso, zita retafura. Muchiitiko ichi, zita reExcel chart richagadziridzwa otomatiki pese pese zviri mukati mesero rakabatana richichinja.
Kubatanidza zita rechati kusero rebepa rekushanda:
- Simbisa musoro wechati.
- Mune formula bar, nyora chiratidzo chakaenzana (=), baya pasero rine mashoko aunoda, wobva wadzvanya pinda.
Mumuenzaniso uyu, tiri kubatanidza zita reExcel chart kune sero A1. Iwe unogona kusarudza maviri kana anopfuura maseru (semuenzaniso, akawanda makolamu misoro) uye inozobuda yechati zita rinoratidza zviri mukati memaseru akasarudzwa.
Kufambisa musoro muchati
Kana iwe uchida kuendesa zita rechati kune imwe nzvimbo, sarudza woidhonza nembeva yako:
Kubvisa musoro wechati
Kana iyo Excel chati isingade zita, saka inogona kubviswa nenzira mbiri:
- Pa Advanced tabo Constructor (Design) tinya Wedzera Chart Elements (Wedzera Chart Element) > Musoro wechati (Chinyorwa Cheti) > Aihwa (Hapana).
- Tinya-kurudyi pazita rechati uye mumenu yemukati tinya Bvisa (Delete).
Chinja font uye dhizaini yezita rechati
Kuti uchinje font yezita rechati muExcel, tinya pairi wobva wadzvanya Font (Font) mumenu yezvinyorwa. Bhokisi rebhokisi rezita rimwe chete richazaruka, umo iwe unogona kugadzirisa mafonti akasiyana-siyana.
Kana iwe uchida mamwe akatsanangurwa marongero, sarudza zita reiyo dhizaini, vhura iyo tab Framework (Format) uye tamba uchitenderedza neakasiyana sarudzo. Heino maitiro, semuenzaniso, iwe unogona kushandura zita rechati uchishandisa Menu Ribhoni:
Nenzira imwecheteyo, iwe unogona kushandura chitarisiko chezvimwe zvinhu zvechati, senge mazita axis, axis mavara, uye ngano yechati.
Kuti uwane rumwe ruzivo nezve izvi, ona chinyorwa Maitiro ekuwedzera zita kune chati muExcel.
Kumisikidza machati maaxes muExcel
Kune akawanda machati marudzi muExcel vertical axis (iriwo kukosha axis kana Y axis) uye horizontal axis (ndiyo zvakare chikamu axis kana X axis) inowedzerwa otomatiki kana ichigadzira chati.
Kuti uvanze kana kuratidza maaxes echati, tinya pane icon Chati zvinhu (Chati Elements), wobva wadzvanya museve uri mumutsara Masanhu (Matemo) uye tara mbezo dzaunoda kuratidza, kana kuti usatarise mabhokisi ari padyo neaya aunoda kuvanza.
Kune mamwe machati emhando, senge combo machati, yechipiri axis inogona kuratidzwa.
Paunenge uchigadzira XNUMXD machati, unogona kuratidza kudzika axis:
Kune chimwe nechimwe chinhu chechati maaxes muExcel, unogona kugadzirisa akasiyana paramita (tichataura nezve izvi zvakadzama gare gare):
Kuwedzera Mazita eAxis kuChati
Paunenge uchigadzira chati muExcel, unogona kuwedzera mazita ematemo akatwasuka uye akachinjika kuitira kuti zvive nyore kune vashandisi kunzwisisa kuti ndeipi data inoratidzwa muchati. Kuti uwedzere mazita e-axis, unofanirwa kuita zvinotevera:
- Dzvanya chero muExcel chart, wobva wadzvanya icon Chati zvinhu (Chati Elements) uye tarisa bhokisi Axis names (Mazita eAxis). Kana uchingoda kuratidza zita rerimwe redemo (rikatwasuka kana rakachinjika), tinya museve uri kurudyi uye usatarise rimwe remabhokisi.
- Dzvanya pane chati mu axis title text ndima woisa zvinyorwa.
Kuti ugadzirise kutaridzika kweiyo axis zita, tinya-kurudyi pairi uye mune yemukati menyu tinya Axis zita format (Format Axis Title). Izvi zvichavhura pani yezita rimwe chete nesarudzo yakakura yemaitiro ekugadzira maitiro. Iwe unogona zvakare kushandisa sarudzo dzinopihwa pane iyo tab Framework (Format) Menu ribhoni, sezvatakaita pakuseta sarudzo dzemusoro wechati.
Kubatanidza mazita eaxis neakapihwa maseru epepa rekushanda
Kufanana nemusoro wechati, zita reaxis rinogona kubatanidzwa kune rakapihwa shizha sero uchishandisa chinongedzo kuitira kuti musoro uvandudzwe otomatiki kana data iri musero rakabatana rachinja.
Kuti ugadzire chinongedzo chakadaro, sarudza zita reaxis uye muformula bar isa chiratidzo chakaenzana (=), wobva wadzvanya pachitokisi chaunoda kubatanidza zita reaxis, wobva wadzvanya pinda.
Shandura chiyero cheakisi yechati
Microsoft Excel inosarudza otomatiki hudiki uye hwakanyanya kukosha, pamwe nemayuniti eiyo vertical axis, zvichibva pane iyo data inoshandiswa kugadzira chati. Kana zvichidikanwa, iwe unogona kuseta yako wega akakodzera ma paramita eiyo vertical axis.
- Sarudza iyo yakatwasuka axis yechati uye tinya pane iyo icon Chati zvinhu (Chati Elements).
- Dzvanya museve mumutsara Masanhu (Axis) uye mune menyu inooneka, sarudza Dzimwe sarudzo (Dzimwe sarudzo). Iyo panel ichavhura Axis Format (Format Axis).
- Muchikamu Axis parameters (Axis Sarudzo) ita chimwe chezvinotevera:
- Kuseta yekutanga uye yekupedzisira kukosha kweiyo vertical axis, isa iwo akakodzera kukosha muminda. pasipasi (Minimum) kana pamusoro-soro (Maximum).
- Kuti uchinje chiyero cheaxis, isa kukosha muminda Zvikamu zvikuru (Zvikuru) uye Zvikamu zvepakati (Minor).
- Kuti udzore axis kukosha, tarisa bhokisi Reverse order of values (Values in reverse order).
Iyo yakatwasuka axis, kusiyana neyakatwasuka, kazhinji ine zvinyorwa zvedata zvinyorwa kwete zvenhamba, saka axis iyi ine mashoma masikero. Nekudaro, iwe unogona kushandura huwandu hwezvikamu zvinoratidzwa pakati pezvinyorwa, kurongeka kwezvikamu, uye poindi panopindirana maaxes maviri:
Kuchinja mafomati enhamba yeaxis labels
Kana iwe uchida kuti nhamba dziri muaxis labels dziratidzirwe semari, maperesenti, nguva, kana mune imwewo fomati, tinya-kurudyi pane zvinyorwa uye mumenu yemukati tinya. Axis Format (Format Axis). Mupanera inovhura, enda kune chikamu nhamba (Nhamba) uye sarudza imwe yeanowanikwa nhamba mafomati:
Tip: Kuti uise mafomu ezvinyorwa zve data yenhamba (iyo iri mumasero epepa rekushanda), tarisa bhokisi Batanidza kune sosi (Yakabatanidzwa kune kwakabva). Kana iwe usingakwanisi kuwana chikamu nhamba (Nhamba) mumapanera Axis Format (Format Axis), tarisa kuti kukosha axis yakasarudzwa pane chati (iyi kazhinji ndiyo yakatwasuka axis).
Kuwedzera Data Labels kune Excel Chart
Kuita kuti chati ive nyore kunzwisisa muExcel, wedzera zvinyorwa zvedata zvinoratidza ruzivo rwakadzama nezve data rakateerana. Zvichienderana nezvamunoda kuti vashandisi vateerere, unogona kuwedzera mavara kune imwechete data nhepfenyuro, kune ese akateedzana, kana kune yega mapoinzi.
- Dzvanya pane data rakateedzana raunoda kuwedzera mavara. Kuti uwedzere label kune imwe chete data point, tinya zvakare pane iyo data point.
- Dzvanya pane icon Chati zvinhu (Chati Elements) uye tarisa bhokisi Data Signatures (Data Labels).
Semuenzaniso, aya ndiwo maitiro edu eExcel chati inotaridzika kunge ine mavara eimwe yedata data.
Mune zvimwe zviitiko, unogona kusarudza kuti mavara achaiswa sei. Kuti uite izvi, tinya museve mumutsara Data Signatures (Data Labels) uye sarudza yakakodzera sarudzo. Kuratidza mavara mukati memavara akayangarara, sarudza Callout Data (Data Callout).
Maitiro ekushandura iyo data inoratidzwa mune zvinyorwa
Kuti uchinje zviri mukati me data rabels pane chati, tinya pane icon Chati zvinhu (Zvimiro zveChati) > Data Signatures (Data Labels) > Dzimwe sarudzo (Dzimwe sarudzo). Iyo panel ichavhura Data Label Format (Format Data Labels) kurutivi rwerudyi rwebepa rebasa. Pa tab Sarudzo dzeSiginecha (Label Options) muchikamu Batanidza muSiginicha (Label Rine) sarudza kubva pane zvakapihwa.
Kana iwe uchida kuwedzera mameseji echinyakare kune imwe yemapoinzi edhata, tinya pane iyo poindi iyo, wobva wadzvanya zvakare kuti uchengete chete iyo label yakasarudzwa, uye zvakare pane iyo chinyorwa chinyorwa kuti usarudze. Zvadaro, isa zvinyorwa zvako.
Kana zvikaitika kuti mavara akawandisa anoremedza iyo Excel chati, saka unogona kudzima chero ipi zvayo. Dzvanya pane siginecha nebhatani rekurudyi rembeva uye mumenu yemukati tinya Bvisa (Delete).
Mazano ekushanda ane data label:
- Kuti uchinje chinzvimbo cheimwe siginicha, ingo dhonza negonzo kunzvimbo yaunoda.
- Kuti uchinje font color uye kuzadza zvinyorwa zvedata, zvisarudzire, wobva wadzvanya tab Framework (Format) uye gadzirisa sarudzo dzemafomati dzaunoda.
Kuwedzera, Kubvisa, Kufambisa, uye Kugadzirisa Mafomati eChati Legend
Paunogadzira chati muExcel 2013 uye Excel 2016, ngano inowedzerwa pazasi penzvimbo yechati nekukasira. MuExcel 2010 uye mberi, kurudyi kwenzvimbo yekuvaka.
Kuti ubvise ngano, tinya chiratidzo Chati zvinhu (Chati Elements) pedyo nekona yepamusoro yekurudyi yechati uye usatarise bhokisi muzvinambiri (Legend).
Kuti uendese ngano yechati kune imwe nzvimbo, sarudza chati, vhura iyo tab Constructor (Design), tinya Wedzera Chart Element (Wedzera Chart Element) > muzvinambiri (Legend) uye sarudza chinzvimbo chitsva chengano. Kuti ubvise ngano, tinya Aihwa (Hapana).
Imwe nzira yekufambisa ngano ndeyekudzvanya kaviri pairi uye sarudza chinzvimbo chaunoda muchikamu. Legend options (Legend Sarudzo) mapaneru Legend Format (Format Legend).
Kugadzirisa mafomati engano, pane zvakawanda zvingasarudzwa pamatabo Shading uye Borders (Zadza & Mutsara) uye migumisiro (Effects) mapaneru Legend Format (Format Legend).
Ratidza uye uvanze grid mune Excel chati
MuExcel 2013 uye 2016, kuratidza kana kuvanza grid inyaya yemasekondi. Ingobaya pane icon Chati zvinhu (Chati Elements) uye tarisa kana kusabvisa bhokisi Grid (Mitambo yeGridhi).
Microsoft Excel inosarudza otomatiki kuti ndeipi mitsara yegridi yakanakira yakapihwa mhando yechati. Semuyenzaniso, bhaa chati inoratidza mitsetse mikuru yakatwasuka, ukuwo chinyorwa chati chinoratidza mitsetse mikuru yakachinjika yegridi.
Kuti ugadzirise rudzi rwemitsetse yegridi inoratidzwa, tinya museve wekurudyi mumutsara Grid (Gridlines) uye sarudza yakakodzera kubva pane zvakarongwa sarudzo, kana tinya Dzimwe sarudzo (Zvimwe Sarudzo) kuvhura pani Main Grid Line Format (Makuru Gridlines).
Kuvanza uye kugadzirisa data data mune Excel chati
Kana cheti yeExcel ichiratidza data rakawanda, dzimwe nguva zvinodikanwa kuvanza kwenguva pfupi chikamu cheiyo nhevedzano kuti utarise pane izvo zvaunoda panguva ino.
Kuti uite izvi, tinya chiratidzo chiri kurudyi rwegirafu. Mafirita eChati (Chati Mafirita) uye usatarise iwo mitsara uye/kana zvikamu zvauri kuda kuvanza.
Kuti ugadzirise data series, tinya bhatani Shandura mutsara (Rongedza Series) kurudyi kwezita rayo. Bhatani rinoonekwa paunofambisa mbeva pamusoro pezita remutsara uyu. Izvi zvicharatidza mutsara unoenderana pagirafu, saka unogona kuona zviri nyore kuti ndeipi chinhu chichagadziriswa.
Shandura rudzi rwechati uye maitiro
Kana iyo chati yawakagadzira isiri iyo yakanyanya kukwana data yauri kuratidza, unogona kushandura zviri nyore rudzi rwechati. Kuti uite izvi, sarudza mufananidzo, vhura tab Insert (Isa) uye muchikamu Mifananidzo (Machati) sarudza rudzi rwechati rwakasiyana.
Imwe nzira ndeyekudzvanya-kurudyi chero kupi muchati uye kubva pane yemukati menyu tinya Shandura rudzi rwechati (Shandura Chati Rudzi).
Kuti uchinje nekukurumidza chimiro chechati yakagadzirwa, tinya icon Zvitaera zvechati (Chati Zvitaera) kurudyi rwenzvimbo yekuvakira uye sarudza yakakodzera kubva pane zvakarongwa zvitaera.
Kana kuti sarudza imwe yezvitaera muchikamu Zvitaera zvechati (Machati Zvitaera) tab Constructor (Design):
Kuchinja machati mavara
Kuti uchinje dingindira reruvara rwechati muExcel, tinya chiratidzo Zvitaera zvechati (Chati Zvitaera), vhura iyo tab ruvara (Ruvara) uye sarudza imwe yemadingindira eruvara. Mavara akasarudzwa achakurumidza kushandiswa kumufananidzo, uye iwe unogona kuongorora pakarepo kana inotaridzika zvakanaka mumuvara mutsva.
Kuti usarudze ruvara kune yega yega yakatevedzana, sarudza iyo data nhevedzano muchati, vhura iyo tab Framework (Format) uye muchikamu Zvimiro zvechimiro (Shape Styles) tinya Shape zadza (Shape Zadza).
Maitiro ekuchinjanisa sei x uye y axes echati
Paunenge uchigadzira chati muExcel, kutariswa kweiyo data nhevedzano kunotemerwa otomatiki zvichienderana nenhamba yemitsara uye makoramu eiyo sosi data pakavakirwa chati. Mune mamwe mazwi, Microsoft Excel inosarudza yakazvimirira nzira yekudhirowa girafu yemitsara yakasarudzwa nemakoramu.
Kana iyo yekusarudzika kurongeka kwemitsara nemakoramu pachati isingakodzeri iwe, saka unogona kushandura zviri nyore maekisi akachinjika uye akatwasuka. Kuti uite izvi, sarudza mufananidzo uye pane tab Constructor (Design) tinya Row column (Chinja Row/Column).
Maitiro ekutenderedza chati muExcel kubva kuruboshwe kuenda kurudyi
Wakambogadzira chati muExcel uye pakupera chaipo ndipo pawakaona kuti mapoinzi edata ari mune yakapesana neyezvawaida kuwana? Kuti ugadzirise mamiriro ezvinhu aya, unoda kudzorera kurongeka umo zvikamu zvakavakwa mumufananidzo, sezvinoratidzwa pasi apa.
Tinya kurudyi pane yakachinjika axis yechati uye tinya Axis Format (Format Axis) mumenu yezvinyorwa.
Kana iwe wakajaira kushanda neRibhoni, vhura iyo tab Constructor (Design) uye tinya Wedzera Chart Element (Wedzera Chart Element) > Masanhu (Masanhu) > Zvimwe Axis Sarudzo (Zvimwe Axis Sarudzo).
Chero nzira, pane pachaonekwa. Axis Format (Format Axis) papi pane tab Axis parameters (Axis Sarudzo) iwe unofanirwa kuki iyo sarudzo Reverse order yezvikamu (Categories in reverse order).
Pamusoro pekupenengura chati muExcel kubva kuruboshwe kuenda kurudyi, unogona kushandura kurongeka kwezvikamu, kukosha, kana dhata dhata muchati, dzosera kurongeka kwekuronga kwe data data, kutenderedza pie chati kune chero kona, nezvimwe. Chinyorwa chakasiyana chakatsaurirwa kumusoro wekutenderera machati muExcel.
Nhasi wadzidza nezve maitiro aungaita machati muExcel. Ehe, chinyorwa ichi chinongobvumidza iwe kukwenya pamusoro pechinyorwa chezvirongwa uye mafomati machati muExcel, kunyangwe zvakawanda zvinogona kutaurwa pamusoro peizvi. Muchikamu chinotevera, tichavaka chati kubva kune data iri pamapepa ekushanda akasiyana-siyana. Zvichakadaro, ini ndinokurudzira kuti udzidzire kubatanidza ruzivo rwakawanikwa nhasi.