Mukati
MuMicrosoft Office Excel, unogona kukurumidza kuvaka chati pane yakaunganidzwa tafura dhizaini kuratidza maitiro ayo makuru. Itsika yekuwedzera ngano kudhiyagiramu kuitira kuratidza ruzivo rwakaratidzwa pairi, kuvapa mazita. Ichi chinyorwa chichakurukura nzira dzekuwedzera ngano kune chati muExcel 2010.
Maitiro ekugadzira chati muExcel kubva patafura
Kutanga iwe unofanirwa kunzwisisa kuti dhayagiramu inovakwa sei muchirongwa chiri mubvunzo. Iyo nzira yekuvakwa kwayo yakakamurwa mune zvinotevera matanho:
- Mune tafura yezvinyorwa, sarudza mutsara waunoda wemasero, makoramu aunoda kuratidza kutsamira.
- Enda kune "Insert" tebhu mukoramu yepamusoro yezvishandiso zvemenu huru yechirongwa.
- Mu "Dhiagiramu" bhuroka, tinya pane imwe yesarudzo dzeiyo graphical inomiririra yehurongwa. Semuenzaniso, unogona kusarudza pie chati kana bar chart.
- Mushure mekupedza nhanho yapfuura, hwindo rine chati yakagadzirwa rinofanira kuoneka padivi peplate yepakutanga paExcel worksheet. Icharatidza hukama pakati pezvakakosha zvakasarudzwa muhurongwa. Saka mushandisi achakwanisa kuona nemeso misiyano yehukoshi, kuongorora girafu uye kutora mhedziso kubva mairi.
Teerera! Pakutanga, "isina" chati ichavakwa pasina ngano, data label, uye legend. Iyi ruzivo inogona kuwedzerwa kune chati kana ichidiwa.
Maitiro ekuwedzera ngano kune chati muExcel 2010 nenzira yakajairwa
Iyi ndiyo nzira yakapusa yekuwedzera ngano uye haitore mushandisi nguva yakawanda kuita. Hunhu hweiyo nzira kuita nhanho dzinotevera:
- Vaka dhayagiramu maererano nechirongwa chiri pamusoro.
- Nebhatani rekuruboshwe rembeva, tinya pane yakasvibira muchinjikwa mubhara rekushandisa kurudyi rwechati.
- Muhwindo rezvisarudzo zviripo zvinovhura, pedyo nemutsara we "Legend", tarisa bhokisi kuti uite basa racho.
- Ongorora chati. Mazita ezvinyorwa kubva kune yekutanga tafura array anofanirwa kuwedzerwa kwairi.
- Kana zvichidikanwa, unogona kushandura nzvimbo yegirafu. Kuti uite izvi, tinya-kuruboshwe pane ngano uye sarudza imwe sarudzo yenzvimbo yayo. Semuenzaniso, Kuruboshwe, Pasi, Kumusoro, Kurudyi, kana Kumusoro Kuruboshwe.
Maitiro ekuchinja ngano mavara pane chati muExcel 2010
Iyo legend captions inogona kuchinjwa kana ichidikanwa nekuisa iyo yakakodzera font uye saizi. Iwe unogona kuita izvi nekutevera mirairo iri pasi apa:
- Vaka chati uye wedzera ngano kwairi zvinoenderana nealgorithm yakurukurwa pamusoro.
- Shandura saizi, font yezvinyorwa mune yekutanga tafura rondedzero, mumaseru ayo iyo girafu pachayo inovakwa. Paunenge uchigadzira mavara mumatafura etafura, zvinyorwa zviri mungano yechati zvinongochinja.
- Tarisa mhinduro.
Zvinokosha! MuMicrosoft Office Excel 2010, zvinonetsa kufometa chinyorwa chengano pachati pachayo. Zviri nyore kushandisa nzira yakatariswa nekushandura data yetafura yakarongwa pakavakirwa girafu.
Nzira yekupedzisa chati
Pamusoro peiyo ngano, kune imwezve data inogona kuratidzwa muchirongwa. Somuenzaniso, zita rake. Kutumidza chinhu chakagadzirwa, unofanirwa kuenderera nenzira inotevera:
- Vaka dhayagiramu zvinoenderana neplate yekutanga uye enda ku "Layout" tab iri pamusoro peiyo huru menyu yechirongwa.
- Iyo Chart Tools pane inovhura, ine akati wandei sarudzo dziripo dzekugadzirisa. Mumamiriro ezvinhu aya, mushandisi anofanira kudzvanya bhatani re "Chart Name".
- Mune yekudonhedza-pasi rondedzero yezvasarudzo, sarudza mhando yekuiswa kwemusoro. Inogona kuiswa pakati nekupindirana, kana pamusoro pechati.
- Mushure mekuita manipulations apfuura, chati yakarongwa icharatidza kunyorwa "Chati Zita". Mushandisi anozokwanisa kuishandura nekunyora nemaoko chero imwe musanganiswa wemazwi kubva kukhibhodi yekombuta inofanana nerevo yetafura yekutanga.
- Zvakakoshawo kuisa mazita pamatemo pachati. Vanosainwa nenzira imwe cheteyo. Muchivharo chekushanda nemachati, mushandisi anozofanirwa kudzvanya bhatani re "Axis Names". Muchinyorwa chekudonhedza pasi, sarudza rimwe rematemo: rakamira kana rakachinjika. Zvadaro, ita shanduko yakakodzera yesarudzo yakasarudzwa.
Mamwe Mashoko! Zvinoenderana nechirongwa chakurukurwa pamusoro, unogona kugadzirisa chati mune chero vhezheni yeMS Excel. Zvisinei, zvichienderana negore iro software yakasunungurwa, matanho ekugadzirisa machati anogona kusiyana zvishoma.
Imwe nzira yekuchinja Chart Legend muExcel
Iwe unogona kugadzirisa zvinyorwa zvemavara pane chati uchishandisa zvishandiso zvakavakwa muchirongwa. Kuti uite izvi, iwe unofanirwa kutevedzera mashoma matanho ari nyore maererano neiyo algorithm:
- Nebhatani rekurudyi rembeva, tinya paizwi rinodiwa rengano mudhayagiramu rakavakwa.
- Muwindo remhando yezvinyorwa, tinya pamutsara we "Filters". Izvi zvinovhura hwindo reCustom Filters.
- Dzvanya bhatani reSarudza Dhata pazasi pehwindo.
- Mune itsva "Sarudza Data Source" menyu, iwe unofanirwa kudzvanya bhatani re "Hora" mu "Legend Elements" block.
- Muhwindo rinotevera, mundima ye "Row Name", isa zita rakasiyana rechinhu chakambosarudzwa uye tinya pakanzi "OK".
- Tarisa mhinduro.
mhedziso
Saka, kuvakwa kwengano muMicrosoft Office Excel 2010 yakakamurwa kuita nhanho dzinoverengeka, imwe neimwe inoda kudzidzwa zvakadzama. Zvakare, kana zvichidikanwa, ruzivo rwuri pachati runogona kugadziridzwa nekukurumidza. Mitemo yakakosha yekushanda nemachati muExcel yakatsanangurwa pamusoro apa.