01 of 06
Matanho ekugadzira Chati yeKirasi mu Excel 2010
Nhanho dzekusika nheyo yekorodhe chati mu Excel 2010 ndeyi:
- Simbisai deta kuti iiswe mu chati - sanganisira rutsanga uye zvinyorwa zvinyorwa asi kwete zita retafura ye data;
- Dzvanya pa Inser tab yebhoni ;
- Mubhokisi reCharts redhibhoni, tora paIndaneti Colonti Chart icon kuti uzarure rondedzero yezvinyorwa zvemashoko ematafura;
- Hover your mouse pointer pamusoro pechati chinonzi kuverenga tsanangudzo yechati;
- Dzvanya pane chati inoda;
Chinhu chisina kujeka, chisina kufananidzwa - chinoratidza chete tsvakurudzo yakasarudzwa yedata, nhoroondo, uye zvikwereti zvinokosha - zvichawedzerwa pane pepa rekushandira remazuva ano.
Kusiyana kweshanduro muExcel
Nhanho dziri mumudzidzi uyu dzinoshandisa maitiro uye maitiro aunogona kuwanika muExcel 2010 uye 2007. Izvi zvakasiyana kubva kune zvakawanikwa mumavambo ekutanga uye emangwana ehurongwa. Shandisa zvinotevera zvinoshandiswa kune column column tutorials kune dzimwe shanduro dzeExcel.
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 zvakadaro, ingosarudza mavara kune iwe unofarira sekutsiva uye uenderere mberi.
02 of 06
Kugadzira Chati Chakanyora Chekuvhara mu Excel
Kupinda nekusarudza Tutorial Data
Cherechedza: Kana iwe usina ruzivo rwaunoshandisa kushandisa iyi tutori, matanho ari mudzidzisi uyu anoshandisa dhidhiro inoratidzwa mumufananidzo pamusoro apa.
Nhanho yekutanga pakumba chati iri nguva dzose kupinda muchechi data - pasinei nokuti rudzi rwechadhi rwuri kuumbwa.
Nhanho yechipiri iri kusimbisa dhesi iyo inoshandiswa mukugadzira chati.
Kana ukasarudza deta, mutsara nehurukuro misoro yakabatanidzwa mukusarudzwa, asi musoro uri pamusoro peetafura ye data hausi. Zita racho rinofanira kuwedzerwa pane chati yacho.
- Pinda data yakaratidzwa mumufananidzo pamusoro apa mumasero ekushanda mapepa
- Pawakambopinda, sarudza huwandu hwemasero kubva kuA2 kusvika kuD5 - iyi ndiyo mhando ye data ichazofananidzirwa nechandori chati
Kuumba Chinyorwa Chakasira Chinyorwa
- Dzvanya pa Inser tab yebhoni
- Mubhokisi reCharts redhibhoni, tora paIndaneti Column Chart icon kuti uzarure kudonhora kwezvese zviripo chati dzema
- Hover your mouse pointer pamusoro pechati chinonzi kuverenga tsanangudzo ye chati
- Muchikamu che -3-D chakanyatsogadziriswa kweChinyorwa chendandemutsetse , tanga paClassed Column - kuwedzera iri chinyorwa chekushanda kumashandiro
03 of 06
Excel Chart Parts uye Kubvisa Gridlines
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.
Kuchenesa Gridlines kubva kuPlot Area
Nheyo huru yemirafu inosanganisira magiradhi emagetsi anoenderera mberi nechepamusoro penharaunda yekuita kuti zvive nyore kuverenga hutsika hwepfungwa dzakasiyana dzematare - kunyanya mumatare ane rine zvakawanda zve data.
Sezvo pane zvikamu zvitatu chete zvemashoko ari muchati ichi, nhepfenyuro dzemadhora zviri nyore kuverenga, saka zvinyorwa zvegridhi zvinogona kubviswa.
- Muchidimbu, chengeta kamwechete pane $ 60,000 gridline inomhanya nepakati pemafirimu kuti ibudise mapepa ose emagetsi - maduku maduku ebhuruu anofanira kuonekwa pakuguma kwegridhi rimwe nerimwe
- Dhinda pfuti yeChenesa pane keyboard kuti ubvise magiradhi
Panguva ino, chati yako inofanira kufanana nemuenzaniso wakaratidzwa mumufananidzo uri pamusoro.
04 of 06
Kuchinja Chati Text
Icho Chati Tools Tabs
Apo chati inenge yakasikwa muExcel 2007 kana 2010, kana kana chero chati iripo yakasarudzwa nekutsvaga pairi, matatu matabhati anowedzera akawedzerwa kubhoni sezvinoratidzwa mumufananidzo uri pamusoro.
Aya maTabvu Matayiti - Kuronga, Kurongeka, uye Fomu - ine mafomati uye maitiro ekugadzirisa zvakananga kumatareti, uye achashandiswa mumatanho anotevera kuwedzera chinyorwa kune chinyorwa chati uye kuti uchinje mavara echati.
Kuwedzera nekugadzirisa Chati Chete
MuExcel 2007 uye 2010, matanho ezvinyorwa haabatanisi mazita echati. Izvi zvinofanira kuwedzerwa zvakasiyana-siyana uchishandisa Chati Chete Chinyorwa chinowanika pa Layout tab uye yakagadzirirwa kuratidza musoro unoda.
- Kamwe kamwe pane chati kuti uzvisarudze, kana zvichidikanwa, kuwedzera zvishandisi zvechadhi tate kubhoni
- Dzvanya paIndaneti tab
- Dzvanya paGatidzi Tsvakurudzo Chokusarudza kuti uzarure pasi pezita rezvasarudzo
- Sarudza Pamusoro Chetati kubva pakurongwa kuti uise chishandiso chati chinyorwa chebhokisi bhokisi muchati iri pamusoro pehurukuro yedata
- Dzvanya kamwe mubhokisi rebhokisi kuitira kuti ugadzire mutsetse wezvinyorwa zvachose
- Bvisa zvinyorwa zvisiri izvo uye shandisa chinyorwa che chati - The Cookie Shop 2013 Income Summary - mubhokisi remusoro
- Isai chituro pakati peBhuku na2013 mumusoro uye chengetedzai Mufunguro wokupinda pabhodibhodi kuti muparadzanise zita iri mumitsetse miviri
Kushandura Mutauro Wemhando
Kushandura rudzi rwemhando inoshandiswa nekusara kwezvose zvinyorwa mubhata hakungogadziri kutaridzika kwechidimbu, asi zvichaitawo kuti zvive nyore kuverenga nheyo uye mazita mazita uye maitiro.
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
- Kamwe kamwe pane chinyorwa chechati kuti uchisarudzire
- Dzvanya paImba yebhu yebhoni
- Muchikamu chetimiro rebhoni, tsvaga paBhokisi rePolisi kuti uzarure pasi rezasi rwemavara akawanikwa
- Mipumburu kuti uwane uye uone pane faira Arial Black iri muzita kuti uchinje musoro kune iyi faira
Kuchinja Nheyo uye Mazano Ako
- Dzokorora matanho ari pamusoro apa kuti uchinje zvinyorwa mumutsara wechati uye X uye Y axes kuArial Black
05 of 06
Kuchinja Mavara muTirasi Rokutanga
Kuchinja Muvara wePasi neChoto Wall
Iyi nhanho mumudzidzisi inosanganisira kuchinja mararamiro echati chepasi uye rutivi rwomukati kune ruvara sezvinoonekwa mumufananidzo uri pamusoro.
- Icho chati iri pasi ndiyo tsananguro yakanyanyisa iri pasi pematafura emashoko munzvimbo inoita nzvimbo.
- Rutivi rworutivi ruri kuruboshwe-rutivi rwomuganhu wenharaunda pakati pematafura e data uye Y (vertical) axis mavara.
Zvinhu zviviri zvichange zvasarudzwa uchishandisa chati chinodonhera pasi chinyorwa chiri kuruboshwe kuruboshwe rwe Layout tab yebhoni.
- Dzvanya pamatare echechi kuti usarudze chati yose kana zvichidiwa
- Dzvanya paIndaneti tab yebhoni
- Nechose chati yakasarudzwa, chati yakatarwa inongororwa inofanira kuratidza Zita reChirati munzvimbo yakakwirira yekona yebhoni.
- Dzvanya pamusorosoro pasi pedyo nechati chinyorwa chisarudzo kuti uzarure kuderedza pasi kwechati chikamu
- Sarudza Pasi kubva pane zvakarongwa zvechati chikamu kuti uise pachena pasi pechati
- Dzvanya ku Format yebhubhoni
- Dzvanya paChimiza Chizadza sarudzo yekuzarura Fill Colors yeka pasi panefa
- Sarudza Mutsvuku, Rugwaro 1 kubva muchikamu cheChirongwa cheCheto chepaneti kuti uchinje ruvara rwechati yepasi kusvika kune ruvara
- Dzokorora matanho 2 kusvika ku 6 kumusoro kuti uchinje ruvara rwecha chati yeChitsuwa cheCheto kusvika kune rima
Kana iwe wakatevera matanho ose mumudzidzisi, panguva ino, chati yako inofanira kufanana neyo inowanikwa mumufananidzo uri pamusoro.
06 of 06
Kuchinja Column Kunotarisa uye Kufambisa Chati
Kuchinja Muvara weGati reData Columns
Ichi chinyorwa mukudzidzisa chinoshandisa kuoneka kwemashoko e data kuburikidza nekuchinja mavara, kuwedzera chidimbu, uye kuwedzera sarineni kune imwe kamuri.
Chimiro chizadza uye chigadzirisa zvinyorwa zvitsanangudzo, zvinowanika paTime tab ichashandiswa kuchinja kuchinja uku. Migumisiro yacho ichafananidza mapuranga anoonekwa mumufananidzo uri pamusoro.
Kushandura Mutengo Wose Wakatora Column Color
- Dzvanya kamwe pane imwe yebhuruu Zvikamu zvose zveMari Revenue mu chati kuti usarudze zvitatu zvitatu zvebhuruu
- Dzvanya pa Format Format yebhoni kana zvichidiwa
- Dzvanya paChimiza Chizadza sarudzo yekuzarura Fill Colors yeka pasi panefa
- Sarudza Remavara Akasvibirira, Rugwaro 2, Chiedza 60% kubva muchikamu cheMutambo Wechikamu chepaneti kuti uchinje marumoni 'ruvara kuti ruve ruvara rwebhuruu
Kuwedzera Dhidient
- Neyo Total Revenue columns yakasarudzwa, chengetedza mukana weZviza Firipi kechipiri kuti uzarure mhinduro yeDzadza Remaodzora
- Hover the mouse pointer pamusoro peGradient sarudzo pedyo nezasi kwerwendo kuti uzarure Guriti Panhizha
- MuChiedza Chakusiyanisa chikamu chepaneti, chengetera paChina Chakakarurama sarudzo kuti uwedzere chidimbu chinowedzera chiedza kubva kuruboshwe kuenda kurudyi kumucheto.
Kuwedzera Mutsara weKurongwa
- Neyo Total Revenue columns yakasarudzwa, chengetedza paShape Outline sarudzo kuti uzarure mhando inodonha yeApepe Outline
- Muchikamu cheClass Colors chepaneti, sarudza Dark Blue kuti uwedzere ruvara rwebhuruu rwuri muhomwe imwe neimwe
- Dzvanya paShape Outline sarudzo kechipiri
- Dzvanya paChina chekusimudza pane menyu kuti uzarure sub menu yekusarudza
- Sarudza 1 1/2 pt. kuti kuwedzere kuwanda kwema column 'mupepeti
Kugadziridza Zvose Zvikamu Series
Dzokorora nhanho dzinoshandiswa kuenzanisa zvikamu zveRevenue Revenue , uchishandisa mienzaniso inotevera:
- Mutsara Yakazadza Ruvara: Ruvara Rutsvuku 2, Rima 50%
- Chidimbu: Chiedza Kusiyana , Kurudyi Kwepakati
- Column Outline Muvara: Red Accent 2, Rima 50%
- Mutsara Pasi Mutsara Weight: 1 1/2 pt.
Kugadzirisa Mufaro / Kurasikirwa Nhepfenyuro
Dzokorora nhanho dzinoshandiswa kuenzanisa zvikamu zveRevenue Revenue , uchishandisa mienzaniso inotevera:
- Column Zera Rakazara: Olive Green Accent 3, Mirima 25%
- Chidimbu: Chiedza Kusiyana , Kurudyi Kwepakati
- Column Outline Ruvara: Olive Green Accent 3, Rima 50%
- Mutsara Pasi Mutsara Weight: 1 1/2 pt.
Panguva ino, kana matanho ose ekufambisa akateverwa, iyo chinyorwa chati inofanira kufanana necha chati inowanikwa mumufananidzo pamusoro apa.
Kufambisa Chati kuSheparet Sheet
Nhanho yekupedzisira mukudzidzisa inoendesa chati kune imwe pepa pepa mubhuku rebhuku uchishandisa Bove Chart yebhokisi yebhokisi.
Kufambisa chati kune rimwe pepa rinoita kuti zvive nyore kudhinda chati uye zvinogonawo kugadzirisa kusanganiswa mune rimwe pepa rekushanda rakazara nedata.
- Dzvanya pamatsetse echati kuti usarudze chati yose
- Dzvanya paGadziriro yebhubhoni
- Dzvanya paIndaneti yeKushatira pane imwe nzvimbo yakarurama kurudyi rwebhoni kuitira kuti uzarure Bhokisi reChikwata rebhokisi rebhokisi
- Sezvinoratidzwa mumufananidzo wepamusoro, chengetedza Itaiti itsva yechinhu mubhokisi rebhokisi uye-zvichida - kupa pepa zita, rakadai seCokie Shop 2013 Income Summary
- Dzvanya OK kuti uvhare bhokisi rebhokisi - chati inofanira kunge iri pane imwe pepa rine zita idzva rinooneka pane pepa pebhu pasi pekona.