Dzimwe nguva zvinobatsira kwazvo kuona kutsamira kwezvakasiyana zvakasiyana pane imwe seti yezvimwe zvakazvimiririra zvakasiyana pagirafu imwechete. Nzira iri nyore yekuita izvi ndeye radar chati muExcel, iyo inonziwo dandemutande (cobweb) kana nyeredzi (yakaumbwa nenyeredzi).
Radar chati muExcel sevhiri rine sipoki yeimwe neimwe yakasiyana. Mitsetse yeConcentric inobatanidza spokes uye inotsanangura coordinate system.
Imwe neimwe poindi yekusiyana kwega kwega inovakwa pamataurirwo anoenderana, uye aya mapoinzi akabatanidzwa nemitsara. Maitiro ekugadzira chati yakadaro muExcel anogona kuve akapusa kana iwe ukatevera matanho aya.
Danho 1: Gadzirira data
Iyo data inofanirwa kugadzirirwa mune iyo chaiyo Excel spreadsheet fomati, zvikasadaro iwe uchafanirwa kuita shanduko huru kuti uwane yakanyatso kurongeka chati. Zvese zvakazvimirira zvakasiyana (zvinokonzeresa) zvinofanirwa kuiswa mumitsara, uye zvinotsamira zvinosiyana (zvinokonzeresa) mumakoramu. Iva nechokwadi chekuisa mazita ekusiyana kwako.
Mumufananidzo uri pamusoro Output - tsigira ndiwo maitiro echigadzirwa (akazvimirira akasiyana), uye Chigadzirwa A, B и C - bvunzo data (inotsamira akasiyana).
Danho rechipiri: Gadzira chati
Nhanho inotevera ndeyekusarudza data rese rakagadzirirwa. Wobva wavhura iyo tab Insert (Isa), fonera dialog box Isa chati (Isa chati) uye sarudza Petal chati (Radarchart). Iyo radar chart icon inoita senge pentagon ine rima spokes uye mitsara inobatanidza masipoka ese kune mumwe nemumwe mudenderedzwa.
Danho rechitatu: Ita kuti ive yakasiyana
Chinhu chekupedzisira chinodiwa pakugadzira dhayagiramu yakadaro ndeyekuita kuti ive yakasiyana. Excel machati haawanzo kukwana zvakakwana kunze kwebhokisi. Iwe unogona kushandura akati wandei nekudzvanya-kurudyi padhiyagiramu. Kana kuti tinya padhiyagiramu uye enda kune iyo tab Kushanda nemachati | Framework (Chati Zvishandiso | Format) kwaunogona kushandura mavara, font, mumvuri mhedzisiro, axis mavara uye saizi. Iva nechokwadi chekuisa mazita pamatemo uye nguva dzose uchipa chati zita.
Machati eRadar muExcel dzimwe nguva anonetsa kunzwisisa, asi anobatsira kana iwe uchida kuratidza kusiyanisa kwezvakasiyana mumativi akati wandei kamwechete. Izvi zvinoreva kuti kukosha kwechimwe chezvakasiyana-siyana kuchasimudzirwa muRadar Chart maonero nokuti ichakwira zvakanyanya kudarika mamwe mavheti. Zvese izvi zvinoita kuti radar dhayagiramu ive imwe yeanonyanya kuona, kunyangwe isingawanzo kushandiswa.
Edza iwe pachako uye uwane chimwe chishandiso chikuru chekuratidzira data yakaoma yekambani yako!
