Layin Chart da Radar: ka'idodi na

A wannan labarin, za mu dubi wasu daga cikin rare iri Charts: Line Chart da Radar. Da farko, bari mu magana game da nada wadannan jinsunan.

line zane

Tsara don saka idanu canje-canje a cikin yawan dabi'u a cikin miƙa mulki daga masomin zuwa ga makõma na ginshiƙi. Wannan irin hoto amfani da su bayyana dangantaka, bambancin da kuma kuzarin kawo cikas. ÃyõyinSa lissafi a cikin wannan harka suna karya line kunshi dige da layin segments.

Don faye hali muhimmancin wani mikakke zane amfani a lokuta kamar:

• Idan yawan tsauri jerin matakan ne manya-manyan. Aikace-aikace zane-zane bincika a wannan hali jaddada ci gaba da bunkasa.

• Nuna jimlar Trend da kuma yanayi na ci gaban wani tsari ko sabon abu.

• Kwatanta wani adadin lokaci jerin.

• Tari na girma kudi.

Features na yi: a shiri na mikakke zane-zane da abscissa, yawanci a lokacin, da kuma ordinate - karuwa da sauri. A wannan ginshiƙi irin dauke yiwu ga gina da dama masu lankwasa ko polygonal, kyale kwatanta daban-daban canje-canje magana ga wani irin lokaci da zamani.

radar

Tsara don kamanta misali na dabi'u da dama kama jerin.

Features na ginin: jadawali yana da wani raba axis ga kowane category zaba dabi'u. Dukan su, bi da bi, da na kowa farkon. A sakamakon gina, yawanci wani mai lankwasa polygon samu, jinyar ta samar da wata da'ira, wanda a cikin jadawali aka samu a daidai dabi'u dauke sigogi. Wannan jadawali da aka nuna a cikin kusurwa / iyakacin duniya daidaita tsarin, wanda dogara ne a kan canji na dabi'u dauke karkata zuwa ga axis. Kowane layi ne vector, sabili da haka, irin wannan zane-zane - kyau form kwatanta wasu trends.

All Charts mafi sauki hanyar gina a Microsoft Office Excel edita. Don yin wannan, akwai wani "Chart Wizard a Excel».

Mataki zuwa mataki umarnin ga "Masters na charting"

1. Bude da Excel daftarin aiki. Fara - All Programs - Microsoft Office - Microsoft Office Excel.

2. Samuwar data gina a tabular form.

3. Opening na "Masters na PD": Saka - Chart / Jadawali.

4. Akwai hanyoyi da irin ginshiƙi: mikakke zane (mulki) ko kada.

5. Selection na data source for yi. Sake suna / sunan aiki layuka.

6. Kafa da sigogi na wani gaba jadawalin. Sunan kowane axis, sunan dukan zane. Zaži category gatura. Nuna / boye asali / matsakaici Lines a kan ginshiƙi. Hiding / Nuna Legends, inda labari ne mai tabular form layuka sa hannu. Enable / fãta a layuka da kuma Categories sa hannu sunayen da dabi'u (ga wasu sauran iri jadawalai - sulusi da murabba'i da kumfa size). Hiding / Nuna tabular form data a gina zane kanta.

7. Zabi wurin da karshe sakamakon (aiki ko wani sabon page na littafin).

A wannan aikin "Masters charting a Excel» za a iya daukan complete. A duka tsari ne daidai tsarin kula da yin amfani da wadannan umarni (ba tare da data shigar) daukan ba fiye da minti goma sha biyar. Gwada shi, yana da ba haka ba wuya!