Ishadi le-Speedometer ku-Excel

ishadi le-speedometer iyinhlanganisela yeshadi ledonadi nophaya. Ishadi libukeka kanje:

Ukwakha ishadi le-speedometer:

  1. Gqamisa ububanzi H2:I6.
  2. Kuthebhu ethuthukisiwe Faka (Faka) esigabeni Imidwebo (Amashadi) chofoza Yonke imidwebo (Amanye Amashadi) bese ukhetha Iminyaka yonke (I-Donut).Ishadi le-Speedometer ku-Excel
  3. Okulandelayo, udinga ukukhetha iphuzu ngalinye ledatha bese usebenzisa umyalo Ifomethi yokukhetha (Ukukhetha ifomethi) lungisa ukugcwaliswa kwe-elementi ngayinye. Naka isibonelo esiboniswe ngezansi:
    • Ngochungechunge lwedathayedonadi» Ukugcwaliswa kumiswa kanje: imikhakha emithathu yokuqala inombala wokugcwalisa ohlukile (obomvu, ophuzi noluhlaza okhanyayo), kanti ichashazi lesine alinawo ukugcwalisa.
    • Ngochungechunge lwedathaFloor» – iphuzu lokuqala nelesithathu aligcwalisiwe, kanti elesibili (umkhakha omncane) ligcwele abamnyama.

    Uchungechunge Lwedatha “yedonadi"Noma"Floor»kungakhethwa kuthebhu Framework (Ifomethi). Ungasebenzisa okhiye bemicibisholo ukusuka endaweni eyodwa yedatha uye kwenye.

    Ishadi le-Speedometer ku-Excel

  4. Khetha uchungechunge lwedatha “yedonadi”, cindezela inkinobho Ifomethi yokukhetha (Ukukhetha Fometha) bese ufaka ipharamitha I-engeli yokuzungezisa yomkhakha wokuqala (I-engeli) inani elingu-270 degrees.
  5. Khetha umdwebo, chofoza kwesokudla kuwo, kumenyu yokuqukethwe, chofoza Ifomethi Yendawo Yeshadi (Indawo Yeshadi Lefomethi) kanye nezinketho zokugcwalisa nomngcele, khetha ngokulandelanayo Akukho ukugcwaliswa (Hhayi indodana) futhi ayikho imigqa (Awukho umugqa).
  6. Susa inganekwane. Umphumela:Ishadi le-Speedometer ku-Excel
  7. Khetha uchungechunge lwedatha “Floor' bese ushintsha uhlobo lweshadi lwalolu chungechunge lube Isiyingi (Uphaya).Ishadi le-Speedometer ku-Excel
  8. Khetha uchungechunge lwedatha “Floor”, cindezela inkinobho Ifomethi yokukhetha (Ukukhetha ifomethi), yepharamitha I-engeli yokujikeleza yokuqala imikhakha (I-engeli) faka inani lamadigri angu-270 bese ukhetha imodi yokwakha yochungechunge i-eksisi encane (i-eksisi yesibili).Umphumela. Isakhiwo Sochungechunge Lwedatha “Floor” kuhlanganisa:
    • umkhakha ongenambala ongabonakali ohambisana nenani elingu-75,
    • Umcibisholo womkhakha omnyama ohambisana nenani elingu-1
    • kanye nomunye umkhakha ongenambala ohambisana nenani elingu-124.

    Ishadi le-Speedometer ku-Excel

  9. Ukusebenzisa isilawuli Counter (Spin inkinobho) shintsha inani leseli I3 kusukela ku-75 kuya ku-76. Kugrafu yochungechunge lwedatha "Floor» izinguquko zizokwenzeka: umkhakha wokuqala ongenambala uzobonisa inani 76; owesibili omnyama uzohlala elingana no-1; umkhakha wesithathu ongenambala uzobonisa inani 200-1-76=123. Ngenxa yefomula kuseli I3 isamba sale mikhakha emithathu siyohlala singama-200.Ishadi le-Speedometer ku-Excel

shiya impendulo