Idan kana neman hanyar zamani don ganin bayanai, duba tsarin fuskar agogon Excel. Taswirar bugun kira a zahiri an tsara shi don ƙawata dashboard, kuma saboda kamanninsa da na'urar saurin mota, ana kiranta da ma'aunin saurin gudu.
Taswirar fuskar agogo yana da kyau don nuna matakan aiki da matakai.
Mataki-mataki:
- Ƙirƙiri shafi a cikin tebur kira na sauri (wanda ke nufin bugun kira) kuma a cikin tantanin halitta na farko mun shigar da darajar 180. Sa'an nan kuma mu shigar da kewayon bayanan da ke nuna tasiri, farawa da ƙananan dabi'u. Wadannan dabi'u dole ne su zama juzu'i na 180. Idan an bayyana ainihin bayanan a matsayin kashi, to za'a iya canza shi zuwa cikakkiyar dabi'u ta ninka ta 180 kuma a raba ta 100.
- Hana shafi kira na sauri kuma ƙirƙirar ginshiƙi donut. Don yin wannan, a kan tab Saka (Saka) a cikin sashe Diagrams (Charts) danna ƙaramin kibiya a cikin ƙananan kusurwar dama (wanda aka nuna a cikin hoton da ke ƙasa).
- Akwatin maganganu zai buɗe Saka ginshiƙi (Saka ginshiƙi). Bude shafi Duk zane-zane (Duk Charts) kuma a cikin menu na hagu, danna Raba (Pie). Zaɓi daga ƙananan nau'ikan da aka ba da shawara zobe (Donut) ginshiƙi kuma danna OK.
- ginshiƙi zai bayyana akan takardar. Domin ya yi kama da bugun kira na gaske, kuna buƙatar ɗan canza kamannin sa.
- Zaɓi batu 2 a cikin jerin bayanai kira na sauri. A cikin panel Tsarin bayanai (Format Data Point) canza siga Matsakaicin jujjuyawar sashin farko (Angle of First Slice) на 90 °.
- Zaɓi batu 1 kuma a cikin panel Tsarin bayanai (Format Data Point) canza cika zuwa Babu cika (Ba Cika ba).
Taswirar yanzu tana kama da jadawalin bugun kira. Ya rage don ƙara kibiya zuwa bugun kira!
Don ƙara kibiya, kuna buƙatar wani ginshiƙi:
- Saka ginshiƙi kuma shigar da ƙima 2. A layi na gaba, shigar da ƙimar 358 (360-2). Don ƙara kibiya mai faɗi, ƙara ƙimar farko kuma rage na biyu.
- Zaɓi ginshiƙi kuma ƙirƙirar ginshiƙi daga ciki kamar yadda aka bayyana a baya a cikin wannan labarin (matakai 2 da 3) ta zaɓin. Raba ginshiƙi maimakon shekara-shekara.
- A cikin bangarori Tsarin bayanai (Format Data Series) canza cika babban sashin ginshiƙi zuwa Babu cika (Babu Cika) da iyaka akan babu iyaka (Ba iyaka).
- Zaɓi ƙaramin ɓangaren ginshiƙi wanda zai yi aiki azaman kibiya kuma canza iyaka zuwa babu iyaka (Ba iyaka). Idan kana son canza launin kibiya, zaɓi zaɓi m cika (Ƙarfin Cika) da launi mai dacewa.
- Danna kan bangon ginshiƙi kuma a cikin rukunin da ya bayyana, canza cika zuwa Babu cika (Ba Cika ba).
- Danna alamar alamar da (+) don shiga menu mai sauri Abubuwan da aka tsara (Chart Elements) kuma cire alamar akwatunan kusa Legend (Legend) и sunan (Taken Asali).
- Na gaba, sanya hannun sama da bugun kiran kuma juya shi zuwa matsayin da ake so ta amfani da siga Matsakaicin jujjuyawar sashin farko (Angle of First Slice).
Shirya! Mun ƙirƙiri ginshiƙi na fuskar agogo!