Mushure mekuunganidza, kuronga uye kugadzirisa data, zvinowanzodikanwa kuvaratidza. Matafura akanaka pakupa data mutsara nemutsara, asi chati inogona kufema hupenyu mairi. Dhiagiramu inogadzira maitiro ekuona ayo anoburitsa kwete chete data, asiwo hukama hwavo uye zvinoreva.
Iyo pie chati ndiyo indasitiri chiyero chekufambisa hukama pakati pezvikamu uye yakazara. Machati epai anoshandiswa kana zvichidikanwa kuratidza kuti zvidimbu zve data (kana zvikamu) zvinopa sei kumufananidzo mukuru. Pie machati haana kukodzera kuratidza data inoshanduka nekufamba kwenguva. Zvakare, usashandise pie chati kuenzanisa data risingawedzeri kune yakakura yakazara pakupedzisira.
Izvi zvinotevera maitiro ekuwedzera pie chati kune Excel sheet. Nzira dzakakurudzirwa dzinoshanda muExcel 2007-2013. Mifananidzo inobva kuExcel 2013 yeWindows 7. Zvichienderana neshanduro yeExcel yauri kushandisa, matanho ega ega anogona kusiyana zvishoma.
Kuisa chati
Mumuenzaniso uyu, tinoda kuratidza hukama pakati pezvikamu zvakasiyana zvevapi vanotora chikamu murudo, zvichienzaniswa nehuwandu hwezvipo. Iyo pie chati yakakwana kuenzanisira izvi. Ngatitangei nekupfupikisa mibairo yenhanho yega yega yekupa.
- Sarudza huwandu kana tafura yedata yaunoda kuratidza muchati. Cherechedza kuti kana tafura ine mutsara Mhedzisiro yese (Grand total), saka mutsara uyu haudi kusarudzwa, zvikasadaro ucharatidzwa seimwe yezvikamu zvepai chati.
- Pa Advanced tabo Insert (Isa) muchikamu Mifananidzo (Machati) tinya pane pie chati icon. Pane akati wandei akajairwa machati ekusarudza kubva. Paunenge uchiyengerera pamusoro peimwe yedzakarongwa machati sarudzo, preview inogoneswa. Sarudza yakanyatsokodzera sarudzo.
Prompt! MuExcel 2013 kana shanduro nyowani, unogona kushandisa chikamu Mifananidzo (Machati) chishandiso Kukurumidza kuongorora (Kurumidza Kuongorora), bhatani rayo rinoonekwa padivi pe data rakasarudzwa. Mukuwedzera, iwe unogona kushandisa bhatani Machati anokurudzirwa (Inokurudzirwa Machati) tab Insert (Insert) kuvhura dialog Isa chati (Isa machati).
★ Verenga zvakawanda muchinyorwa: → Maitiro ekugadzira pie chati muExcel, mafomula, muenzaniso, nhanho nhanho mirairo
Kugadzirisa Pie Chati
Kana iyo dhizaini yaiswa panzvimbo chaiyo, pachava nekudikanwa kwekuwedzera, kushandura kana kugadzirisa zvinhu zvayo zvakasiyana. Dzvanya pachati yaunoda kugadzirisa kuti uunze boka retibhu paRibhoni Kushanda nemachati (Zvishandiso zvechati) uye kugadzirisa mabhatani. MuExcel 2013, sarudzo dzakawanda dzinogona kugadziriswa uchishandisa mabhatani ekugadzirisa ari padyo nechati.
PaDesign tab
- Wedzera zvinyorwa zvedata, gadzirisa zita rechati uye ngano. Dzvanya Dzimwe sarudzo (Dzimwe Sarudzo) kuvhura iyo yekufomatidza pani uye kuwana zvakatowanda sarudzo.
- Edza kuchinja Chart Style (Chati Style) uye Mavara echati (Mavara eChati).
Pa Format tab
- Rongedza uye gadzirisa maitiro ezvinyorwa mumusoro, ngano, nezvimwe.
- Dhonza zvinhu zvechati kune zvinzvimbo zvitsva.
- Tambanudza zvikamu zvakasiyana:
- Kuti uswededze chikamu chimwe chete, ingoisarudza uye woizvuva kure nechati.
- Kuti ubvise zvikamu zvese kubva pakati, tinya-kurudyi padhiyagiramu uye sarudza Data series format (Format Data Series). Papaneru inooneka, tinya Sliced Pie Chati (Pie Kuputika) kushandura chinhambwe pakati pezvidimbu.
- Kune matatu-dimensional chati, unogona kugadzirisa ukobvu, kutenderera angle, kuwedzera mumvuri uye mamwe ma parameter echati pachayo nenzvimbo yekuronga.
Mhedzisiro haingori mufananidzo unodzidzisa wemupiro weboka rega revanopa kuchikonzero chesangano, asiwo mufananidzo wakagadzirwa zvakanaka wakakodzera mabhurocha, mapepa uye kuiswa pamawebhusaiti, uchiremekedza mavara emakambani uye chimiro chesangano rako. .