Nzira Yokuumba Chati Chekoroni mu Excel

01 of 06

Nzira Yokuumba Chati Chekoroni mu Excel

Matanho ekugadzira nheyo yechinyorwa chati mu Excel ndeyi:

1. Simbisai deta kuti iiswe mu chati - sanganisira rutsanga uye zvinyorwa zvinyorwa asi kwete zita retafura ye data;
2. Dzvanya pa Inser tab yebhoni ;
3. Mubhokisi reCharts redhibhoni, tora paIndaneti Colonti Chart icon kuti uzarure rondedzero yezvinyorwa zvemashoko ematafura;
4. Hover your mouse pointer pamusoro pechati chinonzi kuverenga tsanangudzo yechati;
5. Dzvanya pane girafu raunoda;

Chinhu chisina kujeka, chisina kufananidzwa - chinoratidza chete mapuranga anomiririra tsvakurudzo yakasarudzwa yedata , chinyorwa chinyorwa chinyorwa, nhoroondo, uye zvikwereti zvinokosha - zvichawedzerwa pane pepa rekushandira riripo.

Kusiyana kweshanduro muExcel

Matanho ari mumudzidzisi uyu anoshandisa maitiro uye maitiro ekutevedza aripo muExcel 2013. Izvi zvakasiyana kubva kune zvakawanikwa mumavambo ekutanga ehurongwa. Shandisa zvinotevera zvinoshandiswa kune column column tutorials kune dzimwe shanduro dzeExcel.

• Excel 2010 Column Chart Tutorial
• Excel 2003 (uye zvinyorwa zvekare) Chati Chetatu Chetatu

Tsananguro paIndel Theme Theme Colors

Excel, kufanana nezvirongwa zveMicrosoft Office, inoshandisa zvinyorwa kuratidza kutarisa kwemagwaro ayo.

Musoro unoshandiswa padzidzo iyi ndiyo iyo yakashata yeHofisi yepamusoro.

Kana ukashandisa imwe nhepfenyuro paunotevera chidzidzo ichi, mavara akarongwa mumatanho ekudzidzisa angasawanika mumusoro wauri kushandisa. Kana zvisingaiti, ingosarudza mavara kune iwe unofarira seanotsiva uye uenderere mberi.

02 of 06

Kupinda Dhared Data uye Kuumba Chati Chakasira Chati

Cherechedza: Kana iwe usina ruzivo rwaunoshandisa kushandisa iyi tutori, matanho ari mudzidzisi uyu anoshandisa dhidhiro inoratidzwa mumufananidzo pamusoro apa.

Kupinda mucheche data nguva dzose ndiyo danho rokutanga pakuumba chati - pasinei nokuti ndechipi che chati iri kusikwa.

Nhanho yechipiri iri kusimbisa dhesi iyo inoshandiswa mukugadzira chati.

1. Pinda data yakaratidzwa mumufananidzo pamusoro apa mumasero ekushanda mapepa
2. Pawakambopinda, sarudza huwandu hwemasero kubva kuA2 kusvika kuD5 - iyi ndiyo mhando ye data ichazofananidzirwa nechandori chati

Kuumba Chinyorwa Chakasira Chinyorwa

Nhanho dziri pasi apa dzichaita hurukuro yechandori chati - chidimbu, chisina kufanana chati-iyo inoratidza zvitatu zvakatevedzana zve data, nhoroondo, uye chinyorwa chendaneti.

Mushure meizvozvo, sezvakataurwa, dzidzo inotaura nezvekuti ingashandisa sei mamwe maitiro akajairika maitiro, ayo, kana akazotevera, achashandura gwaro rekufananidza kuti rifanane nechimwe chinoratidzwa pamusoro pekudzidzisa uku.

1. Dzvanya pa Inser tab yebhoni
2. Mubhokisi reCharts redhibhoni, tora paIndaneti Column Chart icon kuti uzarure kudonhora kwezvese zviripo chati dzema
3. Hover your mouse pointer pamusoro pechati chinonzi kuverenga tsanangudzo ye chati
4. Muchikamu che -2-D Chinyorwa cherwendo, tora paClassed Column - kuti uwedzere iri dheti rekutanga kumushandi webasa

03 of 06

Kuwedzera Chati Chinyorwa

Rongedza Chituti Chakanaka Chakasirika nekunyanya pairi kaviri - asi usatora kaviri

1. Dzokorora kamwe chete pane chinyorwa chisina kukodzera chinyorwa kuti uchisarudze-bhokisi rinofanira kuonekwa mukati memashoko Chart Title
2. Dzvanya kechipiri kuti uise Excel mu edit mode , iyo inoisa chitupa mukati mebhokisi rebhokisi
3. Dzinga zvinyorwa zvisingashandisi uchishandisa makiro e Delete / Backspace pane keyboard
4. Isa chinyorwa chechati - The Cookie Shop 2013 Inowanikwa Mukurumbira - mubhokisi rebhokisi
5. Isai chituro pakati peBhuku na2013 mumusoro uye chengetedzai Mufunguro wokupinda pabhodibhodi kuti muparadzanise zita iri mumitsetse miviri

Panguva ino, chati yako inofanira kufanana nemuenzaniso wakaratidzwa mumufananidzo uri pamusoro.

Kubva paChikamu Chisiri Chetati

Kune zvikamu zvakasiyana-siyana kune chati mune Excel - yakadai senzvimbo yenzvimbo iyo ine chinyorwa che chati inomiririra tsanangudzo dzakasarudzwa, nhoroondo, uye chinyorwa che chati.

Zvose izvi zvikamu zvinoonekwa sezvinhu zvakasiyana nepurogiramu, uye, saizvozvowo, imwe neimwe inogona kuenzaniswa zvakasiyana. Iwe unoudza Excel chikamu che chati yaunoda kuenzanisira nekutsvaga pairi nemuongorori we mouse.

Mune matanho anotevera, kana mitsva yako isingafananidzi yakanyorwa mumudzidzisi, zviri pachena kuti iwe hauna chikamu chakanaka chechati chasarudzwa pawakawedzera maitiro ekugadzirisa.

Chikanganiso chinowanzoitwa kakawanda chiri kubvumira panzvimbo yepakati mukati mekoro apo chinangwa chacho ndechokusarudza chati yose.

Nzira yakareruka yekusarudza iyo chati yose ndeyekudhonza kumusoro kwepamusoro kana kuruboshwe kurudyi kubva pane chati yechati.

Kana kukanganisa kuitwa, inogona kukurumidza kugadziriswa kuburikidza nekushandura kweAexcel kushandura kukanganisa. Uchitevera izvozvo, chengeta pane chikamu chakanaka che chati uye edza zvakare.

04 of 06

Kuchinja Chati Style uye Column Colors

Icho Chati Tools Tabs

Kana chati iri kubudiswa muExcel, kana kuti chero nguva chati iripo yakasarudzwa nekutsvaga pairi, maviri mamwe matabhi anowedzerwa kubhoni sezvinoratidzwa mumufananidzo uri pamusoro.

Aya mabhii Matati - Matongerwo uye maitiro - ane mafomati uye maitiro ekugadzirisa zvakananga kumatareti, uye achashandiswa mumatanho anotevera kuti uenzanise chandori chati.

Kuchinja Chati Style

Chati maitiro ndiwo maitiro ekugadzirisa maitiro ekufambisa anogona kushandiswa kukurumidza kuisa chati uchishandisa zvakasiyana-siyana zvekusarudza.

Kana, sezvakangoitika mumudzidzisi uyu, anogonawo kushandiswa sekutanga kwekugadzirisa nekuwedzera kwekushandurwa kunoitwa musarudzo yakasarudzwa.

1. Dzvanya pamatare echechi kuti usarudze chati yose
2. Dzvanya paGadziriro yebhubhoni
3. Dzvanya paIndaneti 3 sarudzo muchikamu cheStype Styles chebhoni
4. Zvose mapuranga ari mu chati dzinofanira kuva nemitsetse mipfupi, yakachena, yakareba iyo inomhanya kuburikidza navo uye nheyo inofanira kuenderera kumusoro kwecha chati pasi pemusoro

Kuchinja Column Colors

1. Dzvanya pamatare echechi kuti usarudze chati yose kana zvichidiwa
2. Dzvanya paKushandura Kwemavara Akasarudzwa ari kuruboshwe-rutivi rweGadziriro tab yebhoni kuitira kuti uzarure pasi pezita rezvarudzo zvevaravara
3. Hover your mouse pointer pamusoro pemutsetse wega wega wemirau kuti uone zita racho
4. Dzvanya paMiraira 3 sarudzo mune urongwa - chisarudzo chechitatu muChitevedza chemavara ehurongwa
5. Iyo mivara yemirasi yezvikamu zvakasiyana-siyana inofanira kuchinja kune machena, mashizha, uye mavara, asi mitsetse machena inofanira kunge ichiripo mumutsetse mumwe nomumwe

Kushandura Mutsetse Wemukati Muvara

Danho iyi inoshandura mamiriro echati kuvhara grey uchishandisa mufananidzo Wechizadza Chimiro chiri paIndaneti tab yebhoni yakagadzirwa mumufananidzo uri pamusoro.

1. Dzvanya kumucheto kuti usarudze chati yose uye kuratidzira Tate Tool Tool pamabhoni
2. Dzvanya paIndaneti tab
3. Dzvanya paChimiza Chizadza sarudzo yekuzarura Fill Colors yeka pasi panefa
4. Sarudza Grey -50%, Accent 3, Chiedza 40% kubva muchikamu cheChirongwa cheCheto chepaneti kuti uchinje chikamu chemukati chechati kuchena guru

05 of 06

Kuchinja Chati Text

Kushandura Rugwaro

Iye zvino kuti ruvara rwuri grey, iyo isina kumira yakanyora haisi kuoneka. Chikamu chinotevera chinoshandura ruvara rwezvinyorwa zvose mu chati kune ruvara kuti zvivandudzire kusiyana kwemaviri achishandisa Text Fill chisarudzo.

Iyi sarudzo inowanikwa paIndaneti tab yebhoni yakabatwa mumufananidzo pane peji rekare rekudzidzisa.

1. Dzvanya pamatare echechi kuti usarudze chati yose, kana zvichidikanwa
2. Dzvanya ku Format yebhubhoni
3. Dzvanya paMagwaro Gadza chisarudzo chekuzarura iyo Text Colors inodonha pasi
4. Sarudza Green, Chigumbuso 6, Chimafu 25% kubva muchikamu cheMutambo Wechikamu cherwendo
5. Zvose zvinyorwa mumusoro, zvinyorwa, uye nhoroondo zvinofanira kuchinja kune zvisikwa

Kushandura Mutauro Wemhando, Kukura, uye Kusimbiswa

Kuchinja ukuru uye chimiro chefonti inoshandiswa pamashoko ose mu chati, hakungogadziri kuve nekuvandudzika pamusoro pemashandisi asina kushandiswa anoshandiswa, asi zvichaitawo kuti zvive nyore kuverenga nheyo uye mazita mazita uye mazano mu chati. Kuronga kuumbwa kuchawedzerwawo pane zvakanyorwa kuti zviite kuti zvive pachena kupfuura zvakasara.

Iko kushandurwa kuchaitwa kuburikidza nekusarudza zviri mukati mechikamu chendaneti yeImba yebhu yebhoni.

Cherechedza : Uhu hwefonti hunotaridzwa pamakona - kazhinji hupfupiswa kusvika pt .
72 pt. magwaro akaenzana ne-inch - 2.5 cm - muhukuru.

Kushandura Chati Title Text

1. Kamwe kamwe pane chinyorwa chechati kuti uchisarudzire
2. Dzvanya paImba yebhu yebhoni
3. Muchikamu chetimiro rebhoni, tsvaga paBhokisi rePolisi kuti uzarure pasi rezasi rwemavara akawanikwa
4. Mipumburu kuti uwane uye uone pane faira Leelawadee mubhuku kuti uchinje musoro kune iyi faira
5. MuSpain Size box pedyo nefonti yebhokisi, sarudza musoro weusita we16 pt.
6. Dzvanya paBold icon (tsamba B ) pasi peBhokisi reSpaiti kuti uwedzere kushandiswa kwakashinga kune musoro

Kuchinja Nheyo uye Mazano Ako

1. Kamwe kamwe pane mazai e-axis (akazowona) akareba mukati mechati kuti usarudze mazita ekiokie
2. Uchishandisa matanho ari kumusoro pamusoro pekushandurwa kwemavara echikwata, chengetedza mabhii aya e-10 pt Leelawadee, ushingi
3. Kamwe kamwe pane mavara eY axis (vertical) muchechi kuti usarudze mari yemari kuruoko rworuboshwe rwechadhi
4. Uchishandisa matanho ari kumusoro, shandisa mazai aya e-10 pt Leelawadee, ushingi
5. Dzvidza kamwe chete pamutsara wechati kuti ukasarudze
6. Kushandisa matanho ari kumusoro, gadzira rugwaro rwemhemberero kune 10 pt Leelawadee, ushingi

Zvose zvinyorwa mu chati zvinofanira kuva ikozvino reLeelawadee mhando uye ruvara ruvara ruvara. Panguva ino, chati yako inofanira kufanana necha chati mufananidzo uri pamusoro.

06 of 06

Kuwedzera maGridlinti uye kuchinja mavara avo

Kunyange zvazvo mitsara yekutenderera yakananga yekutanga yakanga iripo nechasipo koromusi chati, vakanga vasiri chikamu chekugadzirisa mutsva kwakasarudzwa mudanho rechitatu, uye, naizvozvo, rakabviswa.

Iyi danho ichawedzera mapepa emagodhi zvakare munzvimbo yebindu che chati.

Mukushayikwa kwemashoko ematare anoratidza kukosha kweiyo imwe yekorodhe, zvinyorwa zvegridhi zvinoita kuti zvive nyore kuverenga zvinyorwa zvemakoroni kubva kune mari inorongwa pane Y (vertical) axis.

Itiridhiyadhi inowedzerwa uchishandisa chandiso yeAd Add Ert pane Design tab yebhoni.

1. Dzvanya kamwe pane imwe yenzvimbo yenzvimbo ye chati kuti uisarudze
2. Dzvanya paGadzira yebhu yebhoni kana zvichidiwa
3. Dzvanya paDhadha yeKatani Element yowedzera kune rumwe rutivi rworuboshwe rwebhoni kuti uzarure mhando yekunyorera
4. Muruwadzikisa pasi, tora paGridlines> Primary Horizontal Major kuti uwedze kushaya simba, machena, magiradhi emadhora kune nzvimbo yechati che chati

Kuita Kuumba Kuchinja Kushandisa Kukurukura Mafaji Akasiyana

Nhanho dzinotevera dzekudzidzisa dzinoshandisa maitiro ekugadzirisa basa , ayo ane zvakawanda zvekugadzirisa mafungiro anowanikwa pamataiti.

MuExcel 2013, kana yakagadziridzwa, pane pane pane inowanikwa kuruoko rworudyi rweEccel chinyorwa sezvazvinoratidzwa mumufananidzo uri pamusoro. Musoro uye zvisarudzo zvinowanikwa munzvimbo dzakasiyana-siyana zvinoshandiswa zvichienderana nenzvimbo yechati inosarudzwa.

Nhanho yekutanga ichachinja mararita emigero yegridhi yakangowedzerwa pamusoro apa kubva kumachena kusvika kuarineni kuitira kuti vaonekwe zvakajeka nepamusoro pevhu rakadzoka renzvimbo yenzvimbo ye chati.

Kuchinja Gridlines 'Mucherechedzo

1. Muchikamu, chengeta kamwechete pane $ 60,000 gridline inomhanya nepakati pebhokisi - dzose magiradhi ejeri anofanira kuiswa pachena (bhuruu nemavhenekera machena pakuguma kwegridline rimwe nerimwe)
2. Dzvanya pa Format Format yebhoni kana zvichidiwa
3. Dzvanya paKutora Kusarudzwa Kwemafaira kune rumwe rutivi rworuboshwe rwebhoni kuitira kuti uzarure Paneji Yemaitiro Akasimudza - musoro uri pamusoro pepamusoro unofanirwa kuve MaGrid Major Gridlines
4. Muchikamu, sarudza mutsara wemutsetse kune Solid line
5. Isa gridline ruvara kune Orange, Accent 2, Rima 25%
6. Zvose zvegridhidhi munharaunda yacho inofanira kuchinja kusvika kune machena machena muvara

Kugadzirisa X Axis Line

Mutsara we X axis uripo pamusoro pemashizha eX axis (mazita ekoji), asi, kufanana nemigero yegridhi, zvakaoma kuona nekuda kwemukati wakachena we chati. Iyi danho ichashandura mutsara we-axis uye uwandu hwemutsara kuti ufanane neyemajeri emagetsi.

1. Dzvanya pamabhaisi e-axis kuti uone mutsara we X axis
2. Mune maitiro ekugadzirisa basa, sezvakaratidzwa mumufananidzo uri pamusoro, sarudza mutsara wemutsetse kune Mutsara wakasimba
3. Isa mutsara wemutsara weAlexis kuArime, Accent 2, Chima 25%
4. Isa mutsara wetsanga kusvika ku 0.75 pt.
5. Mutsara we X axis unofanirwa kufanana nematarenda echati

Kana iwe wakatevera matanho ose mune iyi tutorial, yako chinyorwa chati inofanira kunge ichienderana nemuenzaniso wakaratidzwa pamusoro peji rino.