Nzira Yokugadzira nekugadzira Chati Chechipi mu Excel

Pie chati, kana kuti denderedzwa mairafu sezvavanowanzozivikanwa, shandisa zvidye zvepe kuti zviratidze huwandu kana huwandu hunokosha hwe data iri mu chati.

Sezvo vachiratidza kuenzanirana kwemazana, mapepa emakumbo anobatsira pakuratidza chero dhiyabhorosi inoratidzira zviyero zvakaenzana zvezvikamu zviduku zvinopesana nehuwandu hwekukosha - sekuita kwekugadzirwa kweimwe firiti maererano nehuwandu hwekambani yakazara, kana mari inogadzirwa nechimwe chigadzirwa chakaenderana nekutengesa kwese mutambo wemuchina.

Denderedzwa ye chati ye pie inokwana 100%. Chikamu chega chega chinotumidzwa sechikamu uye ukuru hwayo inoratidza chikamu chipi che 100% chinomirira.

Kusiyana nemamwe magwaro, mapepa emakumbo ane chinyorwa chimwe chete chinyorwa , uye izvi zvakatevedzana hazvigoni kuva nezvakaipa kana zero (0) maonero.

01 of 06

Ratidza Percentage neChirati chePie

Izvi zvidzidzo zvinoshandisa matanho anodiwa ekuumba nekugadzirisa chati yepeiri inoratidzwa mumufananidzo pamusoro apa. Icho chati inoratidza data yakabatana nekutengeswa kwekiki muna 2013.

Icho chati chinoratidza zvose zvese zvekutengesa chikamu chemarudzi ose ekiki achishandisa mavara e data pamwe nehuwandu hunokosha hwechikamu chimwe nechimwe chinomirira chekambani yekutengesa kwegore.

Icho chati chinosimudzirawo lemon cookie yokutengesa nekuputira icho chidimbu chebhokisi chechipiri kubva kune vamwe .

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. Dzidza kuti ungatarisa sei uye shandura nyaya yemazuva ano yebasa .

02 of 06

Kutanga Pie Chart

Kupinda nekusarudza Tutorial Data

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 kuA3 kusvika kuB6.

Kugadzira Chinyorwa Chekutanga Chechi

Nhanho dziri pasi apa dzichaita chati chechipiri chepadhe-chidimbu, chisina kufanana chati-iyo inoratidza zvitsva zve data, nhoroondo, uye chinyorwa chekutsvaga chinyorwa.

Kutevera izvi, mamwe emamwe maitiro akajairika maitiro anoshandiswa kushandura chati yekutanga kutevedzera iyo inoratidzwa peji 1 yeyikudzidzisa.

1. Dzvanya pa Inser tab yebhoni .
2. Mubhokisi yeCharts yebhoni, tsvaga paIndaneti Pie Chart yekuti uzarure pasi rezasi yeiyo chati chati.
3. Hover your mouse pointer pamusoro pechati chinonzi kuverenga tsanangudzo ye chati.
4. Dzvanya pa 3-D Dhamba kuti usarudze chinyorwa chechitatu chechipiri uye uwedzere pane pepaji.

Kuwedzera Chati Chinyorwa

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 - The Cookie Shop 2013 Imari kubva kuThengesi - kupinda mubhokisi bhokisi.
5. Isai chituro pakati pe2013 uye Revenue muzvinyorwa uye chengetedzai Mufunguro wokupinda pabhodibhodi kuti muparadzanise zita iri kumitsara miviri.

03 of 06

Kuwedzera Data Labels kuPaiti Chapi

Kune zvikamu zvakasiyana-siyana kune chati mune Excel - yakadai sedunhu renzvimbo iri ne chati yepayiri inomiririra tsanangudzo dzakasarudzwa, nheti, uye chinyorwa chechati uye mavara.

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 ndechekutsvaga nzvimbo yenzvimbo mukati mechati 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.

Kuwedzera Dhiyabhorosi Dhiyabhorosi

1. Dzvanya kamwe pata chati yepayiri munzvimbo yepaki kuti uisarudze.
2. Tsanangurira kurudyi pane chati kuti uzarure mhedzisiro yenyaya dzakakanganiswa.
3. Muchirevo chemuongorori, shandisa mavhari pamusoro peDynamic Data Labels sarudzo kuti uzarure mamiriro acho ezvinhu wechipiri.
4. Muchikamu chechipiri mamiriro ega, chengeta paDhadha Dhiyabhorosi Dhiyabhorosi kuti uwedzere mararamiro ekutengesa kwekiki imwe - kune imwe slice ye pie mu chati.

Kuchenesa Chati Legend

Muchikamu chinotevera, mazita echikwata achawedzerwa kune mabhuku epa data pamwe chete nemitemo yakaratidzwa, saka, nhepfenyuro iri pasi pe chati haina kudiwa uye inokwanisa kubviswa.

1. Dzvidza kamwechete pane nheyo iri pasi apa nzvimbo yekutsanangura.
2. Dzvanya kuvhara kona pakibhodi kuti ubvise rondedzero.

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

04 of 06

Kuchinja mavara paTabhori Tab

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 pamataiti, uye achashandiswa mumatanho anotevera kuenzanisa chati yepayiri.

Kuchinja Muvara wePelic Slices

1. Dzvanya pamatare echechi kuti usarudze chati yose.
2. tora paKushandura Colors sarudzo iri kuruoko rworuboshwe rweMugadziri tab webhoni kuitira kuti uzarure urusiro hwekutsvaga kwemavara.
3. Hover your mouse pointer pamusoro pemutsetse wega wega wemirau kuti uone zita racho.
4. Dzvanya paMiraira 5 sarudzo mune urongwa - chisarudzo chokutanga muChino chechiMonochromatic cherwendo.
5. Izvo zvidimbu zvina zvepeta mu chati zvinofanira kuchinja kune mhando dzakasiyana dzebhuruu.

Kushandura Mutsetse Wemukati Muvara

Nokuda kwechimwe chiito, kuumba maitiro ndeye nzira mbiri-mbiri nokuti chidimbu chinowedzerwa kuratidzira zvishoma kuchinja mumutsetse wacho kubva kumusoro kusvikira pasi mu chati.

1. Dzvanya kumucheto kuti usarudze chati yose.
2. Dzvanya ku Format yebhubhoni.
3. Dzvanya paChimiza Chizadza sarudzo yekuzarura Fill Colors yeka pasi panefa.
4. Sarudza Bhuu, Chigadziro 5, Chimafu 50% kubva muchikamu cheMusoro Chetambo chepaneti kuti uchinje maruva emucheto wemuvara kune ruvara rwebhuruu.
5. Dzvanya paChimiro Chizadza sarudzo kechipiri kuti uzarure gurusi raDonhorera pasi.
6. Hover the mouse pointer pamusoro peGradient sarudzo pedyo nezasi kwerwendo kuti uzarure Guriti Panhizha.
7. MuChikamu Chinosiyanisa chikamu, chengeta pa Linear Up sarudzo yekuti uwedzere chidimbu chinowedzera zvishoma nezvishoma kubva pasi kusvikira kumusoro.

Kushandura Rugwaro

Iye zvino kuti ruvara rwuri ruvara rwebhuruu, zvisizvo zvisiri zvinyorwa zvisinganyatsooneki. Ichi chikamu chinotevera chinoshandura ruvara rwemavara ose mu chati kuti ichena

1. Dzvanya kumucheto kuti usarudze chati yose.
2. Dzvanya pa Format Format yebhoni kana zvichidiwa.
3. Dzvanya paMagwaro Nyora chisarudzo kuti uzarure urusiro hweMagwaro Colors.
4. Sarudza Muchena, Chinyorwa 1 kubva muchikamu cheMutambo Wechikamu cherwendo.
5. Zvose zvinyorwa mumusoro uye zvinyorwa zvemashoko zvinofanira kuchinja kuchena.

05 of 06

Kunowedzera Category Names uye kuchinja Chati

Nhanho dzinoverengeka dzinotevera dzekudzidzisa dzichishandisa shanduko yekuita basa , iyo ine zvakawanda zvekugadzirisa mafungiro anowanika 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.

Kunowedzera Category Names uye Moving the Data Labels

Iyi danho ichawedzera zita rega yega yekiki kune mabhuku epa data pamwe chete nechikwata chekukozvino chakaratidzwa. Ichavawo nechokwadi chekuti mabhuku e data anowanikwa mukati mechati kuitira kuti pasava nechido chekuratidza vatungamiri mitsara inobatanidza chirairo kune chikamu chayo che chati ye pie.

1. Dzvidza kamwechete pane imwe yezvinyorwa zvepa data mu chati - zvose zvinyorwa zvemashoko mana muchati zvinofanira kusarudzwa.
2. Dzvanya pa Format Format yebhoni kana zvichidiwa.
3. Dzvanya paKutora Kusarudzwa Kwemafaira kune rumwe rutivi rworuboshwe rwebhoni kuitira kuti uzarure Paji Rokushandura Dhizha riri kurudyi rwekona.
4. Kana zvichidikanwa, chengetera pane Options Options pane pane kuti uzarure zvirongwa zveraire sezvinoratidzwa mumufananidzo pamusoro apa.
5. Pasi peTeti Iine chikamu cherwendo, wedzera cheki kuIndaneti Zita Rokusarudza kuratidza mazita ekoji pamwe nekutengesa kwavo mari, uye bvisa cheko chekuona kubva pane Zviratidzo zveMutungamiriri weLines .
6. Pasi peTei Position chikamu cherwendo, chengetera mukati memugumo weInside kuti uendese mabheji mana epa data kumucheto wekunze kwezvikamu zvadzo zvechati.

Kurongedza Pie Chart pane X uye Y Axes

Iyo yekupedzisira yekugadzirisa danho ichave kukukwezva kana kuputira rutivi rwemuti kubva kune rumwe rutivi rwechipiri kuti awedzere kusimbidzirwa naro. Parizvino, iri pasi pechirongwa chechati, uye kuchikwevera kunze apo iri munzvimbo iyi ichave ichiita bumping mumusoro.

Kushandura chati pane X axis - kusveta chati pane zvakapoteredza kuitira kuti slice yemonimu iri kuratidzika kumucheto wekona wekona wekodhi-ichapa nzvimbo yakawanda yekuiputira kubva kune imwe shata.

Kushandura chati pane Y axis kuchakwevera chiso chechira pasi kuitira kuti zvive nyore kuverenga mabhii ematafura pamapetanga emakumbo pamusoro pe chati.

Nekufambisa Task pane pane yakazaruka:

1. Dzvanya kamwe pane chati yechati kuti usarudze chati yose.
2. Dzvanya Pamigumisiro yezviratidzo muvharoji kuti uzarure runyora rwekugona kusarudzwa.
3. Dzvanya pakushandura kwe 3-D munyore kuti uone zvingawanikwa.
4. Isai X kushanduka kusvika ku 170 ^o kutarisa chati kuitira kuti slice yemonimu inotarisana nechezasi kwekona yechati.
5. Isai Y kuchinjika kusvika ku 40 ^o kutora chiso chechati pasi.

06 of 06

Kuchinja Fonti Tsika uye Kuwedzera Pane Chimwe Cheti

Kuchinja ukuru uye rudzi rwefonti rinoshandiswa mu chati, hakusi kungovandudzika pamusoro pemhando yekushandiswa inoshandiswa mu chati, asi zvichaitawo kuti zvive nyore kuverenga mazita emasikirwo uye mazano e data mu chati.

Cherechedza : Ukuru hwefonti hunotaridzwa mumatsetse-zvishoma zvakaderedzwa kusvika pt .
72 pt manyorero akaenzana ne inch - 2.5 cm - muhukuru.

1. Kamwe kamwe pane chinyorwa chechati kuti uchisarudzire.
2. Dzvanya paImba yebhu yebhoni.
3. Muchikamu chetimiro rebhoni, tsvaga paBhokisi rePolisi kuti uzarure rondedzero yezvinyorwa zviripo.
4. Mipumburu kuti uwane uye uone pane faira Britannic Bold mune urongwa kuti uchinje musoro kune iyi faira.
5. MumaSpain Size box pedyo nefonti yebhokisi, sarudza musoro weusita we18 pt.
6. Dzvidza kamwe chete pane mabhii e data mu chati kuitira kusarudza mavara ose mana.
7. Uchishandisa matanho ari pamusoro apa, shandisa mazita ekutora ku 12 pt Britannic Bold.

Kubhadhara Chikamu chePie Chart

Iyi danho yekupedzisira yekugadzirisa ndeyekukweva kana kuputika slice yemoniti kubva kune imwe nzvimbo ye pie kuti iwedzere kusimbisa.

Mushure mokuputika muchero weAra, imwe nhafura ye pie ichaderera muhukuru kuti igare nechinangwa chekuchinja. Somugumisiro, zvinogona kunge zvakakosha kudzorera rimwe kana kuti mamwe emapepa epa data kuti aise zvizere mukati mezvikamu zvavo.

1. Dzvanya kamwe pata chati yepayiri munzvimbo yepaki kuti uisarudze.
2. Kamwe kamwechete padimu yeArim ye chati ye pie kuti usarudze chikamu ichocho che chati - iva nechokwadi chekuti chidimbu chemuori chete chakakomberedzwa nediki duku rebhuruu rinoratidza mavara.
3. Dzvanya uye dhonzai mudira weLimu kubva pane chati ye pie kuti muiparadze.
4. Kuti udzorezve dhiyabhorosi yedheta, kanda kamwe pane dheta re data - dzose mavara ema data anofanira kusarudzwa.
5. Dzvanya kechipiri pane pepa re data kuti uiswe uye uikudze kune nzvimbo yaunoda.

Panguva ino, kana iwe wakatevera matanho ose aya muchidzidzo, chati yako inofanira kufanana nemuenzaniso wakaratidzwa papeji 1 yekudzidzisa.