Dza uye Faira Mutsetse Girafu muExcel in 5 Matanho

Apo iwe unongoda rutsanga, kune mazano akajeka okushandisa

Mu Microsoft Excel, kuwedzera girafu yemutsara kune pepa kana bhuku rebasa rinogadzira kuratidzwa kwemufananidzo we data. Mune mamwe mamiriro ezvinhu, mifananidzo iyo ye data ingangodaro inofanirwa kushanduka uye kuchinja kunogona kungoerekana kusingaonekwi apo dhesi inovigwa mumitsara nemirasi.

Kugadzira Mutsara WeGirafu - The Short Version

Matanho ekuwedzera gwaro rekutanga girafu kana tsananguro yemutsara kune imwe Excel worksheet ndeyi:

1. Simbisai deta kuti iiswe muirafu - inosanganisira rutsanga uye koromo zvinyorwa asi kwete zita retafura ye data.
2. Dzvanya pa Inser tab yebhoni .
3. Muchikamu cheCharts chebhoni, tsvaga paIndaneti Mutsara weChiratidzo kuti uzarure rondedzero yezoratidziro ye chati / grafu types.
4. Hover your mouse pointer pamusoro pechati chinonzi kuverenga tsanangudzo ye chati / grafu.
5. Dzvanya pane girafu raidiwa.

Girafu, isina kufananidzwa-iyo inongoratidzira mitsetse iyo inomiririra tsanangudzo yezvinyorwa zvekutsvaga , chinyorwa chinyorwa chinyorwa, nhoroondo, nematare anokosha-zvichawedzerwa pane pepa rekushandira riripo.

Kusiyana kweshanduro

Matanho ari mumudzidzisi uyu anoshandisa maitiro uye maitiro ekutevedza aripo muExcel 2013. Izvi zvakasiyana kubva kune zvakawanikwa mumavambo ekutanga ehurongwa. Shandisa zvinotevera zvinoshandiswa kumatareji emutsara emagetsi kune dzimwe shanduro dze Excel.

• Excel 2010 uye 2007 Line Grafu Tutori
• Excel 2003 (uye zvinyorwa zvekare) Mutsara weGirafu Tutori

Tsananguro paIndel Theme Theme Colors

Excel, kufanana nezvirongwa zveMicrosoft Office, inoshandisa zvinyorwa kuratidza kutarisa kwemagwaro ayo. Zvichienderana nehurukuro yaunoshandisa paunotevera chidzidzo ichi, mavara akarongwa mumatanho ekudzidzisa anogona kunge asina kufanana neauri kushandisa. Iwe unogona kusarudza chero musoro waunoda uye unopfuurira.

Kugadzira Mutsara WeGrafu - The Long Version

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

Kupinda mune imwe dhiyabhorosi nguva dzose ndiyo danho rokutanga pakumba girafu - pasinei nokuti rudzi rwechirafu kana chati iri kuitwa sei.

Nhanho yechipiri iri kusimbisa dhesi inofanira kushandiswa mukugadzira girafu. Iyo data yakasarudzwa kazhinji inosanganisira mazita emakoromita uye mutsara wemutsara, ayo anoshandiswa semavara mu chati.

1. Pinda data yakaratidzwa mumufananidzo pamusoro apa mumasero ekushanda mapepa .
2. Kana uchangopinda, sarudza huwandu hwemasero kubva kuA2 kusvika kuC6.

Kana ukasarudza deta, mutsara nehurukuro misoro yakabatanidzwa mukusarudzwa, asi musoro uri pamusoro peetafura ye data hausi. Zita racho rinofanira kuwedzerwa kune grafu manyore.

Kugadzira Basic Line Grafu

Nhanho dzinotevera dzichaita ruzivo rwemashoko ekutanga-ruvara, ruzivo rusina kufananidzwa - runoratidzira sarudzo yakasarudzwa nhepfenyuro uye zvikwereti.

Mushure mokunge, sezvakataurwa, dzidzo inotaura nezvekuti ingashandisa sei zvimwe zvakajairika maitiro, izvo, kana zvichitevedzwa, zvichinja girafu yekufananidza kuenzanisa girafu rakatsetseka rakaratidzwa muchikwata chekutanga chekudzidzisa.

1. Dzvanya pa Inser tab yebhoni.
2. Muchikamu cheCharts chebhoni redhibhoni, chengetera Itaiti yeChino Line Chart kuti uzarure rondedzero yezvenherera ye graph / chati yerudzi.
3. Hover your mouse pointer pamusoro pemutauro weropa kuti uverenge tsanangudzo yemirafu.
4. Dzvanyira pakutanga 2-d mutsara wemafrimu mutauro uri muzita kuti uisarudze.
5. Chinokosha girafu chakasikwa uye chakaiswa pane pepa rako rekushandira sezvinoratidzwa mumufananidzo pane slide inotevera pasi apa.

Kugadzirisa Basic Basic Grafu: Kuwedzera Chati Chete

Rongedza Chituti Chakanaka Chakasirika nekunyanya pairi kaviri asi kwete kaviri kacho

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 - Average Precipitation (mm) - mubhokisi rebhokisi

Kubva paChikamu Chisiri Chetati

Kune zvikamu zvakasiyana-siyana kune chati mune Excel - yakadai sechati chechati uye mavara, nzvimbo yenzvimbo ine mitsara inomiririra data yakasarudzwa, iyo yakananga uye yakasvikidzika mitsara, uye mitsara yemigero yakanamatira.

Zvose izvi zvikamu zvinoonekwa sezvinhu zvakasiyana nepurogiramu, uye, saizvozvowo, imwe neimwe inogona kuenzaniswa zvakasiyana. Iwe unoudza Excel chikamu che grafu iwe unoda kufomira nekutsvaga pairi nemuongorori we mouse kuti uzvisarudze.

Munguva iyi zvidzidzo, kana mitsva yako isiri yakafanana neyo yakanyorwa, zviri pachena kuti iwe hauna chikamu chakanaka chechati chasarudzwa pawakashandisa maitiro ekufambisa.

Chikanganiso chinowanzoitwa kakawanda ndechekutsvaga nzvimbo yepakati iri pakati pegrafu apo chinangwa ndechokusarudza iyo yose grafu.

Nzira yakareruka yekusarudza iyo yose grafu ndeyokudhonza kumusoro kwekuruboshwe kana kwekona yekukona kubva pachirongwa chechati.

Kana kukanganisa kuchiitwa, inogona kukurumidza kugadziriswa kuburikidza nekushandurwa kweExcel. Uchitevera izvozvo, chengeta pane chikamu chakanaka che chati uye edza zvakare.

Kuchinja maGrafu's Colors Kushandisa Chart Tools Tabs

Apo chati / grafu inenge yakasikwa muExcel, kana kana chero girafu iripo yakasarudzwa nekutsvaga pairi, maviri mamwe matabhi akawedzerwa kubhoni sezvinoratidzwa mumufananidzo uri pamusoro.

Aya mabhii Matashiti - Chigadziro uye Format - ine mafomati uye maitiro ekugadzirisa zvakananga kumatsetse, uye achashandiswa mumatanho anotevera kuti achinje maruva uye ruvara rwemavara emirafu.

Kuchinja Girafu Yakatarisa Muvara

Nokuti iyi girafu chaiyo, kuenzanisira mamiriro acho ezvinhu ndechimwe chiito chekutsika nokuti chidimbu chinowedzerwa kuratidzira kuchinja kuduku kwemuvara kumativi ose murafu.

1. Dzvanya kumucheto kuti usarudze iyo yose grafu.
2. Dzvanya pa Format fomu yebhoni.
3. Dzvanya paChimiro Chizadza Chinoti, chinoratidzwa mumufananidzo uri pamusoro, kuti uzarure Fill Colors inodonha pasi pepaniti.
4. Sarudza Mutsvuku, Rugwaro 1, Chiedza 35% kubva muchikamu cheMutambo Wechikamu chezvenyu.
5. Dzvanya paChimiro Chizadza sarudzo kechipiri kuti uzarure imirasi yeClasses pasi.
6. Hover the mouse pointer pamusoro peGradient sarudzo pedyo nezasi kwerwendo kuti uzarure Guriti Panhizha.
7. Muchikamu cheChiedza Kusiyana kwepanepa, chengetera paChinaar yakasara sarudzo kuti uwedzere chidimbu chinoramba chichiwedzera kuva nerima kubva kuruboshwe kuenda kurudyi kune rimwe grafu.

Kushandura Rugwaro

Iye zvino kuti mamiriro acho akadzera, mhinduro dzisina kuchena dzisati dzaonekwa. Ichi chikamu chinotevera chinoshandura ruvara rwemavara ose muirafu kuti rive rakachena

1. Dzvanya kumucheto kuti usarudze iyo yose grafu.
2. Dzvanya pa Format fomu yebhoni kana zvichidiwa.
3. Dzvanya Rugwaro Nyora zororo kuti uzarure Text Colors inodonha pasi.
4. Sarudza Muchena, Chinyorwa 1 kubva muchikamu cheMutambo Wechikamu cherwendo.
5. Zvose zviri mumusoro, x uye y axes, uye nhoroondo inofanira kuchenesa.

Kushandura Mitsara Inowanikwa: Kufambisa muIndaneti Pane

Nhanho mbiri dzekupedzisira dzekudzidzisa dzinoshandisa maitiro ekugadzirisa basa , ayo ane maitiro akawanda ekufambisa anowanikwa emashadi.

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.

Kushandura Mutsetse Wemavara weAcapulco

1. Muchirafu, chengeta kamwe chete pamuganhu wearangi weAcapulco kuti uisarudze - zviduku zviduku zvinofanira kuonekwa pamwe chete nehurefu hwomurongo.
2. Dzvanya pa Format Format yebhoni kana zvichidiwa.
3. Pasi parutivi rworuboshwe rworabhoni, chengetera paKutora Kusarudza sarudzo kuti uzarure Purogiramu Yemafashandi pane .
4. Sezvo mutsetse weAcapulco waimbove wakasarudzwa, zita riri pane pane rinofanira kuverenga Format Data Series.
5. Muchikamu, chengetera paZvizazaza (iyo pende inogona) kuzarura mutsara wezvakanyorwa.
6. Mutsamba yezvasarudzwa, chengetera paZviza zera iri pedyo neErape Color kuti uzarure Line Colors inodonha pasi.
7. Sarudza Green, Accent 6, Chiedza 40% kubva muchikamu cheMutambo Wechikamu cherwendo - mutsetse weAcapulco inofanira kuchinja kune ruvara rwemavara.

Kuchinja Amsterdam

1. Muchirafu, chinyorwa kamwe chete pamutsara webhuruu weAmsterdam kuti uisarudze.
2. Muchipatimendi Chekuita basa pane, ruvara rwekuzadza ikozvino kuratidzikiswa pasi peikoni kunofanira kushanduka kubva kune ruvara rwebhuruu kuratidza kuti pane pane ikozvino kuratidza zvigaro zveAmsterdam.
3. Dzvanya paZvizazaza icon kuti uzarure Line Colors inyorera pasi.
4. Sarudza Bhuruu, Chigadziro 1, Chiedza 40% kubva muchikamu cheChirongwa cheChitatu cherwendo - mutsetse weAmsterdam inofanira kuchinja kune ruvara rwebhuruu.

Kubuda kunze kweGridlines

Ikokupedzisira kuchinja kwekushandurwa kunofanira kuitwa ndeyekugadzirisa zvigadzirwa zvegridhi zvinomhanya zvakananga kumagrafu.

Nheyo huru yemirafu inosanganisira idzi gridliniti kuitira kuti zvive nyore kuverenga hutsika hwemashoko akanangana pamiganhu ye data.

Havana, zvisinei, vanofanira kunge vakanyatsoratidzwa zvikuru. Imwe nzira yakajeka yekuvataurira pasi ndeyekugadzirisa kuve pachena kwavo vachishandura maBasa ekugadzira basa.

Nokutadza, kusvikidzika kwepakati kuri 0%, asi nekuwedzera izvo, magiradhi ejeri achaperera kumashure kwavari.

1. Dzvanya paKutora Kusarudzwa Kwemafaira paGadzirisa tab yebhoni kana zvichidiwa kuti uzarure paDhigiriji Rakashandura
2. Muchikamu, chengeta kamwechete pa 150 mm gridline ichimhanya nepakati pebhokisi - dzose magiradhi anofanirwa kuiswa pachena (mabhuruu ebhuruu pamagumo ega rega gridline)
3. Mukati pane kuchinja kwehutano ku 75% - zvinyorwa zvepa girafu zvinofanira kupera zvikuru