Taswirar Speedometer a cikin Excel

ginshiƙi gudun mita hade ne na donut da kek ginshiƙi. Jadawalin yayi kama da haka:

Don ƙirƙirar ginshiƙi mai saurin gudu:

  1. Hana kewayo H2:I6.
  2. A kan Babba shafin Saka (Saka) a cikin sashe Diagrams (Charts) danna Duk zane-zane (Sauran Charts) kuma zaɓi shekara-shekara (Doughnut).Taswirar Speedometer a cikin Excel
  3. Na gaba, kuna buƙatar zaɓar kowane wurin bayanai kuma yi amfani da umarnin Tsarin Zaɓin (Zaɓin Tsarin) daidaita cika kowane kashi. Kula da misalin da aka nuna a ƙasa:
    • Domin jerin bayanaidonut» An tsara abin cika kamar haka: sassa uku na farko suna da launi daban-daban na cika (ja, rawaya da kore mai haske), dige na hudu kuma ba shi da cikawa.
    • Domin jerin bayanaiBene»- Ba a cika maki na farko da na uku ba, kuma na biyu (ƙananan sashin) ya cika da baki.

    Jerin Data"donut"Ko"Bene»za'a iya zaɓa akan shafin tsarin (Format). Kuna iya amfani da maɓallin kibiya don matsawa daga wannan batu zuwa wani.

    Taswirar Speedometer a cikin Excel

  4. Zaɓi jerin bayanai"donut”, danna maballin Tsarin Zaɓin (Zaɓin Tsarin) kuma shigar da siga Matsakaicin jujjuyawar sashin farko (Angle) darajar digiri 270.
  5. Zaɓi zane, danna-dama akansa, a cikin menu na mahallin, danna Tsarin Yanki na Chart (Yankin Tsarin Tsarin Tsarin) kuma don cikewa da zaɓuɓɓukan iyaka, zaɓi bi da bi Babu cika (Ba son) и babu layi (Ba layi).
  6. Share labarin. Sakamako:Taswirar Speedometer a cikin Excel
  7. Zaɓi jerin bayanai"Bene' kuma canza nau'in ginshiƙi na wannan jerin zuwa Raba (Pie).Taswirar Speedometer a cikin Excel
  8. Zaɓi jerin bayanai"Bene”, danna maballin Tsarin Zaɓin (Tsarin zaɓi), don siga Angle na juyawa na farko sassa (Angle) shigar da darajar digiri 270 kuma zaɓi yanayin ginin jerin ƙananan axis (secondary axis).Sakamako. Jerin Bayanan BayaniBene” ya kunshi:
    • Bangaren mara launi mara ganuwa wanda yayi daidai da ƙimar 75,
    • baƙar fata-kibiya mai dacewa da ƙimar 1
    • da wani yanki mara launi wanda yayi daidai da ƙimar 124.

    Taswirar Speedometer a cikin Excel

  9. Amfani da sarrafawa counter (Maɓallin juyawa) canza ƙimar tantanin halitta I3 daga 75 zuwa 76. A kan jadawali na jerin bayanai "Bene» canje-canje zai faru: sashin farko mara launi zai nuna darajar 76; baki na biyu zai kasance daidai da 1; Sashin mara launi na uku zai nuna darajar 200-1-76=123. Godiya ga dabarar a cikin tantanin halitta I3 jimillar wadannan sassa uku za su kasance 200 ko da yaushe.Taswirar Speedometer a cikin Excel

Leave a Reply